Exomoon Code.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Filter Archive"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# IMPORTS AND PREAMBLE\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['rowid',\n",
       " 'pl_name',\n",
       " 'hostname',\n",
       " 'pl_letter',\n",
       " 'hd_name',\n",
       " 'hip_name',\n",
       " 'tic_id',\n",
       " 'gaia_id',\n",
       " 'sy_snum',\n",
       " 'sy_pnum',\n",
       " 'sy_mnum',\n",
       " 'cb_flag',\n",
       " 'discoverymethod',\n",
       " 'disc_year',\n",
       " 'disc_refname',\n",
       " 'disc_pubdate',\n",
       " 'disc_locale',\n",
       " 'disc_facility',\n",
       " 'disc_telescope',\n",
       " 'disc_instrument',\n",
       " 'rv_flag',\n",
       " 'pul_flag',\n",
       " 'ptv_flag',\n",
       " 'tran_flag',\n",
       " 'ast_flag',\n",
       " 'obm_flag',\n",
       " 'micro_flag',\n",
       " 'etv_flag',\n",
       " 'ima_flag',\n",
       " 'dkin_flag',\n",
       " 'pl_controv_flag',\n",
       " 'pl_orbper',\n",
       " 'pl_orbpererr1',\n",
       " 'pl_orbpererr2',\n",
       " 'pl_orbperlim',\n",
       " 'pl_orbper_reflink',\n",
       " 'pl_orbsmax',\n",
       " 'pl_orbsmaxerr1',\n",
       " 'pl_orbsmaxerr2',\n",
       " 'pl_orbsmaxlim',\n",
       " 'pl_orbsmax_reflink',\n",
       " 'pl_angsep',\n",
       " 'pl_angseperr1',\n",
       " 'pl_angseperr2',\n",
       " 'pl_angseplim',\n",
       " 'pl_angsep_reflink',\n",
       " 'pl_rade',\n",
       " 'pl_radeerr1',\n",
       " 'pl_radeerr2',\n",
       " 'pl_radelim',\n",
       " 'pl_rade_reflink',\n",
       " 'pl_radj',\n",
       " 'pl_radjerr1',\n",
       " 'pl_radjerr2',\n",
       " 'pl_radjlim',\n",
       " 'pl_radj_reflink',\n",
       " 'pl_bmasse',\n",
       " 'pl_bmasseerr1',\n",
       " 'pl_bmasseerr2',\n",
       " 'pl_bmasselim',\n",
       " 'pl_bmasse_reflink',\n",
       " 'pl_bmassj',\n",
       " 'pl_bmassjerr1',\n",
       " 'pl_bmassjerr2',\n",
       " 'pl_bmassjlim',\n",
       " 'pl_bmassj_reflink',\n",
       " 'pl_bmassprov',\n",
       " 'pl_dens',\n",
       " 'pl_denserr1',\n",
       " 'pl_denserr2',\n",
       " 'pl_denslim',\n",
       " 'pl_dens_reflink',\n",
       " 'pl_orbeccen',\n",
       " 'pl_orbeccenerr1',\n",
       " 'pl_orbeccenerr2',\n",
       " 'pl_orbeccenlim',\n",
       " 'pl_orbeccen_reflink',\n",
       " 'pl_insol',\n",
       " 'pl_insolerr1',\n",
       " 'pl_insolerr2',\n",
       " 'pl_insollim',\n",
       " 'pl_insol_reflink',\n",
       " 'pl_eqt',\n",
       " 'pl_eqterr1',\n",
       " 'pl_eqterr2',\n",
       " 'pl_eqtlim',\n",
       " 'pl_eqt_reflink',\n",
       " 'pl_orbincl',\n",
       " 'pl_orbinclerr1',\n",
       " 'pl_orbinclerr2',\n",
       " 'pl_orbincllim',\n",
       " 'pl_orbincl_reflink',\n",
       " 'pl_tranmid',\n",
       " 'pl_tranmiderr1',\n",
       " 'pl_tranmiderr2',\n",
       " 'pl_tranmidlim',\n",
       " 'pl_tranmid_systemref',\n",
       " 'pl_tranmid_reflink',\n",
       " 'ttv_flag',\n",
       " 'pl_imppar',\n",
       " 'pl_impparerr1',\n",
       " 'pl_impparerr2',\n",
       " 'pl_impparlim',\n",
       " 'pl_imppar_reflink',\n",
       " 'pl_trandep',\n",
       " 'pl_trandeperr1',\n",
       " 'pl_trandeperr2',\n",
       " 'pl_trandeplim',\n",
       " 'pl_trandep_reflink',\n",
       " 'pl_trandur',\n",
       " 'pl_trandurerr1',\n",
       " 'pl_trandurerr2',\n",
       " 'pl_trandurlim',\n",
       " 'pl_trandur_reflink',\n",
       " 'pl_ratdor',\n",
       " 'pl_ratdorerr1',\n",
       " 'pl_ratdorerr2',\n",
       " 'pl_ratdorlim',\n",
       " 'pl_ratdor_reflink',\n",
       " 'pl_ratror',\n",
       " 'pl_ratrorerr1',\n",
       " 'pl_ratrorerr2',\n",
       " 'pl_ratrorlim',\n",
       " 'pl_ratror_reflink',\n",
       " 'pl_occdep',\n",
       " 'pl_occdeperr1',\n",
       " 'pl_occdeperr2',\n",
       " 'pl_occdeplim',\n",
       " 'pl_occdep_reflink',\n",
       " 'pl_orbtper',\n",
       " 'pl_orbtpererr1',\n",
       " 'pl_orbtpererr2',\n",
       " 'pl_orbtperlim',\n",
       " 'pl_orbtper_systemref',\n",
       " 'pl_orbtper_reflink',\n",
       " 'pl_orblper',\n",
       " 'pl_orblpererr1',\n",
       " 'pl_orblpererr2',\n",
       " 'pl_orblperlim',\n",
       " 'pl_orblper_reflink',\n",
       " 'pl_rvamp',\n",
       " 'pl_rvamperr1',\n",
       " 'pl_rvamperr2',\n",
       " 'pl_rvamplim',\n",
       " 'pl_rvamp_reflink',\n",
       " 'pl_projobliq',\n",
       " 'pl_projobliqerr1',\n",
       " 'pl_projobliqerr2',\n",
       " 'pl_projobliqlim',\n",
       " 'pl_projobliq_reflink',\n",
       " 'pl_trueobliq',\n",
       " 'pl_trueobliqerr1',\n",
       " 'pl_trueobliqerr2',\n",
       " 'pl_trueobliqlim',\n",
       " 'pl_trueobliq_reflink',\n",
       " 'st_spectype',\n",
       " 'st_spectype_reflink',\n",
       " 'st_teff',\n",
       " 'st_tefferr1',\n",
       " 'st_tefferr2',\n",
       " 'st_tefflim',\n",
       " 'st_teff_reflink',\n",
       " 'st_rad',\n",
       " 'st_raderr1',\n",
       " 'st_raderr2',\n",
       " 'st_radlim',\n",
       " 'st_rad_reflink',\n",
       " 'st_mass',\n",
       " 'st_masserr1',\n",
       " 'st_masserr2',\n",
       " 'st_masslim',\n",
       " 'st_mass_reflink',\n",
       " 'st_met',\n",
       " 'st_meterr1',\n",
       " 'st_meterr2',\n",
       " 'st_metlim',\n",
       " 'st_met_reflink',\n",
       " 'st_metratio',\n",
       " 'st_lum',\n",
       " 'st_lumerr1',\n",
       " 'st_lumerr2',\n",
       " 'st_lumlim',\n",
       " 'st_lum_reflink',\n",
       " 'st_logg',\n",
       " 'st_loggerr1',\n",
       " 'st_loggerr2',\n",
       " 'st_logglim',\n",
       " 'st_logg_reflink',\n",
       " 'st_age',\n",
       " 'st_ageerr1',\n",
       " 'st_ageerr2',\n",
       " 'st_agelim',\n",
       " 'st_age_reflink',\n",
       " 'st_dens',\n",
       " 'st_denserr1',\n",
       " 'st_denserr2',\n",
       " 'st_denslim',\n",
       " 'st_dens_reflink',\n",
       " 'st_vsin',\n",
       " 'st_vsinerr1',\n",
       " 'st_vsinerr2',\n",
       " 'st_vsinlim',\n",
       " 'st_vsin_reflink',\n",
       " 'st_rotp',\n",
       " 'st_rotperr1',\n",
       " 'st_rotperr2',\n",
       " 'st_rotplim',\n",
       " 'st_rotp_reflink',\n",
       " 'st_radv',\n",
       " 'st_radverr1',\n",
       " 'st_radverr2',\n",
       " 'st_radvlim',\n",
       " 'st_radv_reflink',\n",
       " 'rastr',\n",
       " 'ra',\n",
       " 'decstr',\n",
       " 'dec',\n",
       " 'glat',\n",
       " 'glon',\n",
       " 'elat',\n",
       " 'elon',\n",
       " 'ra_reflink',\n",
       " 'sy_pm',\n",
       " 'sy_pmerr1',\n",
       " 'sy_pmerr2',\n",
       " 'sy_pmra',\n",
       " 'sy_pmraerr1',\n",
       " 'sy_pmraerr2',\n",
       " 'sy_pmdec',\n",
       " 'sy_pmdecerr1',\n",
       " 'sy_pmdecerr2',\n",
       " 'sy_pm_reflink',\n",
       " 'sy_dist',\n",
       " 'sy_disterr1',\n",
       " 'sy_disterr2',\n",
       " 'sy_dist_reflink',\n",
       " 'sy_plx',\n",
       " 'sy_plxerr1',\n",
       " 'sy_plxerr2',\n",
       " 'sy_plx_reflink',\n",
       " 'sy_bmag',\n",
       " 'sy_bmagerr1',\n",
       " 'sy_bmagerr2',\n",
       " 'sy_bmag_reflink',\n",
       " 'sy_vmag',\n",
       " 'sy_vmagerr1',\n",
       " 'sy_vmagerr2',\n",
       " 'sy_vmag_reflink',\n",
       " 'sy_jmag',\n",
       " 'sy_jmagerr1',\n",
       " 'sy_jmagerr2',\n",
       " 'sy_jmag_reflink',\n",
       " 'sy_hmag',\n",
       " 'sy_hmagerr1',\n",
       " 'sy_hmagerr2',\n",
       " 'sy_hmag_reflink',\n",
       " 'sy_kmag',\n",
       " 'sy_kmagerr1',\n",
       " 'sy_kmagerr2',\n",
       " 'sy_kmag_reflink',\n",
       " 'sy_umag',\n",
       " 'sy_umagerr1',\n",
       " 'sy_umagerr2',\n",
       " 'sy_umag_reflink',\n",
       " 'sy_gmag',\n",
       " 'sy_gmagerr1',\n",
       " 'sy_gmagerr2',\n",
       " 'sy_gmag_reflink',\n",
       " 'sy_rmag',\n",
       " 'sy_rmagerr1',\n",
       " 'sy_rmagerr2',\n",
       " 'sy_rmag_reflink',\n",
       " 'sy_imag',\n",
       " 'sy_imagerr1',\n",
       " 'sy_imagerr2',\n",
       " 'sy_imag_reflink',\n",
       " 'sy_zmag',\n",
       " 'sy_zmagerr1',\n",
       " 'sy_zmagerr2',\n",
       " 'sy_zmag_reflink',\n",
       " 'sy_w1mag',\n",
       " 'sy_w1magerr1',\n",
       " 'sy_w1magerr2',\n",
       " 'sy_w1mag_reflink',\n",
       " 'sy_w2mag',\n",
       " 'sy_w2magerr1',\n",
       " 'sy_w2magerr2',\n",
       " 'sy_w2mag_reflink',\n",
       " 'sy_w3mag',\n",
       " 'sy_w3magerr1',\n",
       " 'sy_w3magerr2',\n",
       " 'sy_w3mag_reflink',\n",
       " 'sy_w4mag',\n",
       " 'sy_w4magerr1',\n",
       " 'sy_w4magerr2',\n",
       " 'sy_w4mag_reflink',\n",
       " 'sy_gaiamag',\n",
       " 'sy_gaiamagerr1',\n",
       " 'sy_gaiamagerr2',\n",
       " 'sy_gaiamag_reflink',\n",
       " 'sy_icmag',\n",
       " 'sy_icmagerr1',\n",
       " 'sy_icmagerr2',\n",
       " 'sy_icmag_reflink',\n",
       " 'sy_tmag',\n",
       " 'sy_tmagerr1',\n",
       " 'sy_tmagerr2',\n",
       " 'sy_tmag_reflink',\n",
       " 'sy_kepmag',\n",
       " 'sy_kepmagerr1',\n",
       " 'sy_kepmagerr2',\n",
       " 'sy_kepmag_reflink',\n",
       " 'pl_nnotes',\n",
       " 'st_nphot',\n",
       " 'st_nrvc',\n",
       " 'st_nspec',\n",
       " 'pl_nespec',\n",
       " 'pl_ntranspec']"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# READ IN CSV FILE\n",
    "archive = pd.read_csv(r'C:\\ ') # YOUR PATH TO CSV FILE\n",
    "\n",
    "\n",
    "# LISTING ALL COLUMNS FOR EASY ACCESS TO COLUMNS\n",
    "list(archive.columns.values.tolist()) \n",
    "#print('Done.')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Done.\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-3-dae1c0169c43>:2: UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access\n",
      "  archive.radj = archive['pl_radj']\n"
     ]
    }
   ],
   "source": [
    "# FILTERING OUT RADII LESS THAN 0.5\n",
    "archive.radj = archive['pl_radj']\n",
    "rad_filt = archive[archive.radj >= 0.5] # KEEPS ROWS THAT HAVE RADIUS GREATER THAN OR EQUAL TO 0.5 JUPITER RADII\n",
    "#rad_filt\n",
    "print('Done.')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-4-be63a5dfa1ec>:4: UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access\n",
      "  rad_filt.method = rad_filt['discoverymethod'] # GIVES 'discoverymethod' COLUMN OWN DATAFRAME\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>rowid</th>\n",
       "      <th>pl_name</th>\n",
       "      <th>hostname</th>\n",
       "      <th>pl_letter</th>\n",
       "      <th>hd_name</th>\n",
       "      <th>hip_name</th>\n",
       "      <th>tic_id</th>\n",
       "      <th>gaia_id</th>\n",
       "      <th>sy_snum</th>\n",
       "      <th>sy_pnum</th>\n",
       "      <th>...</th>\n",
       "      <th>sy_kepmag</th>\n",
       "      <th>sy_kepmagerr1</th>\n",
       "      <th>sy_kepmagerr2</th>\n",
       "      <th>sy_kepmag_reflink</th>\n",
       "      <th>pl_nnotes</th>\n",
       "      <th>st_nphot</th>\n",
       "      <th>st_nrvc</th>\n",
       "      <th>st_nspec</th>\n",
       "      <th>pl_nespec</th>\n",
       "      <th>pl_ntranspec</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>90</td>\n",
       "      <td>CoRoT-1 b</td>\n",
       "      <td>CoRoT-1</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 36352297</td>\n",
       "      <td>Gaia DR2 3105507886130792448</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>91</td>\n",
       "      <td>CoRoT-10 b</td>\n",
       "      <td>CoRoT-10</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 405010127</td>\n",
       "      <td>Gaia DR2 4263752921128319616</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>92</td>\n",
       "      <td>CoRoT-11 b</td>\n",
       "      <td>CoRoT-11</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 110178537</td>\n",
       "      <td>Gaia DR2 4285511294172309504</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>93</td>\n",
       "      <td>CoRoT-12 b</td>\n",
       "      <td>CoRoT-12</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 280210963</td>\n",
       "      <td>Gaia DR2 3107255598526406912</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>94</td>\n",
       "      <td>CoRoT-13 b</td>\n",
       "      <td>CoRoT-13</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 281909674</td>\n",
       "      <td>Gaia DR2 3101974231859723776</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5616</th>\n",
       "      <td>5617</td>\n",
       "      <td>XO-3 b</td>\n",
       "      <td>XO-3</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 8400842</td>\n",
       "      <td>Gaia DR2 470650560777348352</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>1.0</td>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5617</th>\n",
       "      <td>5618</td>\n",
       "      <td>XO-4 b</td>\n",
       "      <td>XO-4</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 51234631</td>\n",
       "      <td>Gaia DR2 990291507088739072</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5618</th>\n",
       "      <td>5619</td>\n",
       "      <td>XO-5 b</td>\n",
       "      <td>XO-5</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 9155187</td>\n",
       "      <td>Gaia DR2 920308932010648448</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5619</th>\n",
       "      <td>5620</td>\n",
       "      <td>XO-6 b</td>\n",
       "      <td>XO-6</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 138168780</td>\n",
       "      <td>Gaia DR2 1114308481600798336</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5620</th>\n",
       "      <td>5621</td>\n",
       "      <td>XO-7 b</td>\n",
       "      <td>XO-7</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 268403451</td>\n",
       "      <td>Gaia DR2 2303332931542914048</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>819 rows × 318 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      rowid     pl_name  hostname pl_letter hd_name hip_name         tic_id  \\\n",
       "89       90   CoRoT-1 b   CoRoT-1         b     NaN      NaN   TIC 36352297   \n",
       "90       91  CoRoT-10 b  CoRoT-10         b     NaN      NaN  TIC 405010127   \n",
       "91       92  CoRoT-11 b  CoRoT-11         b     NaN      NaN  TIC 110178537   \n",
       "92       93  CoRoT-12 b  CoRoT-12         b     NaN      NaN  TIC 280210963   \n",
       "93       94  CoRoT-13 b  CoRoT-13         b     NaN      NaN  TIC 281909674   \n",
       "...     ...         ...       ...       ...     ...      ...            ...   \n",
       "5616   5617      XO-3 b      XO-3         b     NaN      NaN    TIC 8400842   \n",
       "5617   5618      XO-4 b      XO-4         b     NaN      NaN   TIC 51234631   \n",
       "5618   5619      XO-5 b      XO-5         b     NaN      NaN    TIC 9155187   \n",
       "5619   5620      XO-6 b      XO-6         b     NaN      NaN  TIC 138168780   \n",
       "5620   5621      XO-7 b      XO-7         b     NaN      NaN  TIC 268403451   \n",
       "\n",
       "                           gaia_id  sy_snum  sy_pnum  ...  sy_kepmag  \\\n",
       "89    Gaia DR2 3105507886130792448        1        1  ...        NaN   \n",
       "90    Gaia DR2 4263752921128319616        1        1  ...        NaN   \n",
       "91    Gaia DR2 4285511294172309504        1        1  ...        NaN   \n",
       "92    Gaia DR2 3107255598526406912        1        1  ...        NaN   \n",
       "93    Gaia DR2 3101974231859723776        1        1  ...        NaN   \n",
       "...                            ...      ...      ...  ...        ...   \n",
       "5616   Gaia DR2 470650560777348352        1        1  ...        NaN   \n",
       "5617   Gaia DR2 990291507088739072        1        1  ...        NaN   \n",
       "5618   Gaia DR2 920308932010648448        1        1  ...        NaN   \n",
       "5619  Gaia DR2 1114308481600798336        1        1  ...        NaN   \n",
       "5620  Gaia DR2 2303332931542914048        1        1  ...        NaN   \n",
       "\n",
       "      sy_kepmagerr1 sy_kepmagerr2  \\\n",
       "89              NaN           NaN   \n",
       "90              NaN           NaN   \n",
       "91              NaN           NaN   \n",
       "92              NaN           NaN   \n",
       "93              NaN           NaN   \n",
       "...             ...           ...   \n",
       "5616            NaN           NaN   \n",
       "5617            NaN           NaN   \n",
       "5618            NaN           NaN   \n",
       "5619            NaN           NaN   \n",
       "5620            NaN           NaN   \n",
       "\n",
       "                                      sy_kepmag_reflink pl_nnotes st_nphot  \\\n",
       "89    <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0        6   \n",
       "90    <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0        0   \n",
       "91    <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0        0   \n",
       "92    <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0        0   \n",
       "93    <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0        0   \n",
       "...                                                 ...       ...      ...   \n",
       "5616  <a refstr=STASSUN_ET_AL__2019 href=https://ui....       1.0       50   \n",
       "5617  <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0       11   \n",
       "5618  <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0       26   \n",
       "5619  <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0        0   \n",
       "5620  <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0        0   \n",
       "\n",
       "     st_nrvc st_nspec pl_nespec pl_ntranspec  \n",
       "89         1        0         5           20  \n",
       "90         0        0         0            0  \n",
       "91         0        0         0            0  \n",
       "92         0        0         0            0  \n",
       "93         0        0         0            0  \n",
       "...      ...      ...       ...          ...  \n",
       "5616       4        0         5            0  \n",
       "5617       1        0         2            0  \n",
       "5618       2        0         0            0  \n",
       "5619       0        0         0            0  \n",
       "5620       0        0         0            0  \n",
       "\n",
       "[819 rows x 318 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#pd.set_option('display.max_columns', None) # PRINTS WHOLE TABLE OF COLUMNS\n",
    "#pd.set_option('display.max_rows', None) # PRINTS WHOLE TABLE OF ROWS\n",
    "\n",
    "rad_filt.method = rad_filt['discoverymethod'] # GIVES 'discoverymethod' COLUMN OWN DATAFRAME\n",
    "disc_and_rad = rad_filt[rad_filt['discoverymethod'].str.contains('Transit')] # FILTERS ROWS THAT HAVE THE WORD 'transit' IN\n",
    "disc_and_rad\n",
    "#print('Done.')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Calculating the CHZ\n",
    "#### Using Equations from page 10 in Kopparapu et al (2013)\n",
    "###### https://iopscience.iop.org/article/10.1088/0004-637X/765/2/131/pdf#page=10.44"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Done.\n"
     ]
    }
   ],
   "source": [
    "T = disc_and_rad['st_teff'] - 5780\n",
    "\n",
    "# Recent Venus\n",
    "a_v = 1.4316e-4\n",
    "b_v = 2.9875e-9\n",
    "c_v = -7.5702e-12\n",
    "d_v = -1.1635e-15\n",
    "\n",
    "VS_eff = 1.7753 + (a_v*T) + (b_v*T**2) + (c_v*T**3) + (d_v*T**4)\n",
    "\n",
    "\n",
    "# Early Mars\n",
    "a_m = 5.4513e-5\n",
    "b_m = 1.5313e-9\n",
    "c_m = -2.7786e-12\n",
    "d_m = -4.8997e-16\n",
    "\n",
    "MS_eff = 0.3179 + (a_m*T) + (b_m*T**2) + (c_m*T**3) + (d_m*T**4)\n",
    "\n",
    "#print(VS_eff, MS_eff)\n",
    "print('Done.')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Done.\n"
     ]
    }
   ],
   "source": [
    "L = 10**(disc_and_rad['st_lum'])\n",
    "\n",
    "in_CHZ = (L/VS_eff)**0.5\n",
    "out_CHZ = (L/MS_eff)**0.5\n",
    "\n",
    "in_CHZ = pd.DataFrame({'in_CHZ': in_CHZ}) # GIVES TWO NEW COLUMNS OWN HEADER \n",
    "out_CHZ = pd.DataFrame({'out_CHZ': out_CHZ}) # GIVES TWO NEW COLUMNS OWN HEADER \n",
    "print('Done.')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "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>pl_name</th>\n",
       "      <th>hostname</th>\n",
       "      <th>pl_letter</th>\n",
       "      <th>hd_name</th>\n",
       "      <th>hip_name</th>\n",
       "      <th>tic_id</th>\n",
       "      <th>gaia_id</th>\n",
       "      <th>sy_snum</th>\n",
       "      <th>sy_pnum</th>\n",
       "      <th>...</th>\n",
       "      <th>sy_kepmagerr2</th>\n",
       "      <th>sy_kepmag_reflink</th>\n",
       "      <th>pl_nnotes</th>\n",
       "      <th>st_nphot</th>\n",
       "      <th>st_nrvc</th>\n",
       "      <th>st_nspec</th>\n",
       "      <th>pl_nespec</th>\n",
       "      <th>pl_ntranspec</th>\n",
       "      <th>in_CHZ</th>\n",
       "      <th>out_CHZ</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>90</td>\n",
       "      <td>CoRoT-1 b</td>\n",
       "      <td>CoRoT-1</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 36352297</td>\n",
       "      <td>Gaia DR2 3105507886130792448</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>20</td>\n",
       "      <td>1.050514</td>\n",
       "      <td>2.463741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>91</td>\n",
       "      <td>CoRoT-10 b</td>\n",
       "      <td>CoRoT-10</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 405010127</td>\n",
       "      <td>Gaia DR2 4263752921128319616</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.334638</td>\n",
       "      <td>0.817680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>92</td>\n",
       "      <td>CoRoT-11 b</td>\n",
       "      <td>CoRoT-11</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 110178537</td>\n",
       "      <td>Gaia DR2 4285511294172309504</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.130398</td>\n",
       "      <td>2.598429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>93</td>\n",
       "      <td>CoRoT-12 b</td>\n",
       "      <td>CoRoT-12</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 280210963</td>\n",
       "      <td>Gaia DR2 3107255598526406912</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.816969</td>\n",
       "      <td>1.939931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>94</td>\n",
       "      <td>CoRoT-13 b</td>\n",
       "      <td>CoRoT-13</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 281909674</td>\n",
       "      <td>Gaia DR2 3101974231859723776</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.810939</td>\n",
       "      <td>1.902291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5616</th>\n",
       "      <td>5617</td>\n",
       "      <td>XO-3 b</td>\n",
       "      <td>XO-3</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 8400842</td>\n",
       "      <td>Gaia DR2 470650560777348352</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>1.0</td>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1.649701</td>\n",
       "      <td>3.793718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5617</th>\n",
       "      <td>5618</td>\n",
       "      <td>XO-4 b</td>\n",
       "      <td>XO-4</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 51234631</td>\n",
       "      <td>Gaia DR2 990291507088739072</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1.358046</td>\n",
       "      <td>3.126820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5618</th>\n",
       "      <td>5619</td>\n",
       "      <td>XO-5 b</td>\n",
       "      <td>XO-5</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 9155187</td>\n",
       "      <td>Gaia DR2 920308932010648448</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.710389</td>\n",
       "      <td>1.706387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5619</th>\n",
       "      <td>5620</td>\n",
       "      <td>XO-6 b</td>\n",
       "      <td>XO-6</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 138168780</td>\n",
       "      <td>Gaia DR2 1114308481600798336</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.342817</td>\n",
       "      <td>3.056267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5620</th>\n",
       "      <td>5621</td>\n",
       "      <td>XO-7 b</td>\n",
       "      <td>XO-7</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 268403451</td>\n",
       "      <td>Gaia DR2 2303332931542914048</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.210062</td>\n",
       "      <td>2.802250</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>819 rows × 320 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      rowid     pl_name  hostname pl_letter hd_name hip_name         tic_id  \\\n",
       "89       90   CoRoT-1 b   CoRoT-1         b     NaN      NaN   TIC 36352297   \n",
       "90       91  CoRoT-10 b  CoRoT-10         b     NaN      NaN  TIC 405010127   \n",
       "91       92  CoRoT-11 b  CoRoT-11         b     NaN      NaN  TIC 110178537   \n",
       "92       93  CoRoT-12 b  CoRoT-12         b     NaN      NaN  TIC 280210963   \n",
       "93       94  CoRoT-13 b  CoRoT-13         b     NaN      NaN  TIC 281909674   \n",
       "...     ...         ...       ...       ...     ...      ...            ...   \n",
       "5616   5617      XO-3 b      XO-3         b     NaN      NaN    TIC 8400842   \n",
       "5617   5618      XO-4 b      XO-4         b     NaN      NaN   TIC 51234631   \n",
       "5618   5619      XO-5 b      XO-5         b     NaN      NaN    TIC 9155187   \n",
       "5619   5620      XO-6 b      XO-6         b     NaN      NaN  TIC 138168780   \n",
       "5620   5621      XO-7 b      XO-7         b     NaN      NaN  TIC 268403451   \n",
       "\n",
       "                           gaia_id  sy_snum  sy_pnum  ...  sy_kepmagerr2  \\\n",
       "89    Gaia DR2 3105507886130792448        1        1  ...            NaN   \n",
       "90    Gaia DR2 4263752921128319616        1        1  ...            NaN   \n",
       "91    Gaia DR2 4285511294172309504        1        1  ...            NaN   \n",
       "92    Gaia DR2 3107255598526406912        1        1  ...            NaN   \n",
       "93    Gaia DR2 3101974231859723776        1        1  ...            NaN   \n",
       "...                            ...      ...      ...  ...            ...   \n",
       "5616   Gaia DR2 470650560777348352        1        1  ...            NaN   \n",
       "5617   Gaia DR2 990291507088739072        1        1  ...            NaN   \n",
       "5618   Gaia DR2 920308932010648448        1        1  ...            NaN   \n",
       "5619  Gaia DR2 1114308481600798336        1        1  ...            NaN   \n",
       "5620  Gaia DR2 2303332931542914048        1        1  ...            NaN   \n",
       "\n",
       "                                      sy_kepmag_reflink pl_nnotes  st_nphot  \\\n",
       "89    <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0         6   \n",
       "90    <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0         0   \n",
       "91    <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0         0   \n",
       "92    <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0         0   \n",
       "93    <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0         0   \n",
       "...                                                 ...       ...       ...   \n",
       "5616  <a refstr=STASSUN_ET_AL__2019 href=https://ui....       1.0        50   \n",
       "5617  <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0        11   \n",
       "5618  <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0        26   \n",
       "5619  <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0         0   \n",
       "5620  <a refstr=STASSUN_ET_AL__2019 href=https://ui....       0.0         0   \n",
       "\n",
       "     st_nrvc st_nspec pl_nespec pl_ntranspec    in_CHZ   out_CHZ  \n",
       "89         1        0         5           20  1.050514  2.463741  \n",
       "90         0        0         0            0  0.334638  0.817680  \n",
       "91         0        0         0            0  1.130398  2.598429  \n",
       "92         0        0         0            0  0.816969  1.939931  \n",
       "93         0        0         0            0  0.810939  1.902291  \n",
       "...      ...      ...       ...          ...       ...       ...  \n",
       "5616       4        0         5            0  1.649701  3.793718  \n",
       "5617       1        0         2            0  1.358046  3.126820  \n",
       "5618       2        0         0            0  0.710389  1.706387  \n",
       "5619       0        0         0            0  1.342817  3.056267  \n",
       "5620       0        0         0            0  1.210062  2.802250  \n",
       "\n",
       "[819 rows x 320 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# ADDING THE NEW CHZ COLUMNS TO THE FILTERED DATAFRAME\n",
    "filtered = pd.concat([disc_and_rad, in_CHZ, out_CHZ], axis=1) # CONCAT IS CONCATENATION - JOINING TWO STRINGS INTO ONE \n",
    "filtered"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Assuming that the orbits follow a Keplarian orbit, the orbit semi-major axis is mean distance from its parent star in AU."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "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>pl_name</th>\n",
       "      <th>hostname</th>\n",
       "      <th>pl_letter</th>\n",
       "      <th>hd_name</th>\n",
       "      <th>hip_name</th>\n",
       "      <th>tic_id</th>\n",
       "      <th>gaia_id</th>\n",
       "      <th>sy_snum</th>\n",
       "      <th>sy_pnum</th>\n",
       "      <th>...</th>\n",
       "      <th>sy_kepmagerr2</th>\n",
       "      <th>sy_kepmag_reflink</th>\n",
       "      <th>pl_nnotes</th>\n",
       "      <th>st_nphot</th>\n",
       "      <th>st_nrvc</th>\n",
       "      <th>st_nspec</th>\n",
       "      <th>pl_nespec</th>\n",
       "      <th>pl_ntranspec</th>\n",
       "      <th>in_CHZ</th>\n",
       "      <th>out_CHZ</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2848</th>\n",
       "      <td>2849</td>\n",
       "      <td>Kepler-1628 b</td>\n",
       "      <td>Kepler-1628</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 123362984</td>\n",
       "      <td>Gaia DR2 2105245187265625728</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.174356</td>\n",
       "      <td>0.453242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2875</th>\n",
       "      <td>2876</td>\n",
       "      <td>Kepler-1647 b</td>\n",
       "      <td>Kepler-1647</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 170344769</td>\n",
       "      <td>Gaia DR2 2073793420945053824</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.548719</td>\n",
       "      <td>3.592337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2952</th>\n",
       "      <td>2953</td>\n",
       "      <td>Kepler-1704 b</td>\n",
       "      <td>Kepler-1704</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 350738167</td>\n",
       "      <td>Gaia DR2 2136191736602006016</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.264619</td>\n",
       "      <td>2.993113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2955</th>\n",
       "      <td>2956</td>\n",
       "      <td>Kepler-1708 b</td>\n",
       "      <td>Kepler-1708</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 272716898</td>\n",
       "      <td>Gaia DR2 2078801971283008128</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.911720</td>\n",
       "      <td>2.119406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3311</th>\n",
       "      <td>3312</td>\n",
       "      <td>Kepler-1981 b</td>\n",
       "      <td>Kepler-1981</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 121457557</td>\n",
       "      <td>Gaia DR2 2099583977992504576</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.990198</td>\n",
       "      <td>2.330102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3756</th>\n",
       "      <td>3757</td>\n",
       "      <td>Kepler-34 b</td>\n",
       "      <td>Kepler-34</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 272369124</td>\n",
       "      <td>Gaia DR2 2079692678777827712</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.911052</td>\n",
       "      <td>2.140151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3949</th>\n",
       "      <td>3950</td>\n",
       "      <td>Kepler-419 c</td>\n",
       "      <td>Kepler-419</td>\n",
       "      <td>c</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 27454084</td>\n",
       "      <td>Gaia DR2 2135604425595213440</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.662990</td>\n",
       "      <td>3.824131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4005</th>\n",
       "      <td>4006</td>\n",
       "      <td>Kepler-453 b</td>\n",
       "      <td>Kepler-453</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 164457525</td>\n",
       "      <td>Gaia DR2 2107434834610481920</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.587897</td>\n",
       "      <td>1.405676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4027</th>\n",
       "      <td>4028</td>\n",
       "      <td>Kepler-47 d</td>\n",
       "      <td>Kepler-47</td>\n",
       "      <td>d</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 271548206</td>\n",
       "      <td>Gaia DR2 2080506523540902912</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.639573</td>\n",
       "      <td>1.521445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4149</th>\n",
       "      <td>4150</td>\n",
       "      <td>Kepler-553 c</td>\n",
       "      <td>Kepler-553</td>\n",
       "      <td>c</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 264508613</td>\n",
       "      <td>Gaia DR2 2086498312157538688</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.562493</td>\n",
       "      <td>1.366741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4954</th>\n",
       "      <td>4955</td>\n",
       "      <td>PH2 b</td>\n",
       "      <td>PH2</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 416279912</td>\n",
       "      <td>Gaia DR2 2139300262131379584</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.703348</td>\n",
       "      <td>1.665605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5021</th>\n",
       "      <td>5022</td>\n",
       "      <td>TOI-1227 b</td>\n",
       "      <td>TOI-1227</td>\n",
       "      <td>b</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 360156606</td>\n",
       "      <td>Gaia DR2 5842480953772012928</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.040959</td>\n",
       "      <td>0.109280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5129</th>\n",
       "      <td>5130</td>\n",
       "      <td>TOI-199 c</td>\n",
       "      <td>TOI-199</td>\n",
       "      <td>c</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 309792357</td>\n",
       "      <td>Gaia DR2 4762582895440787712</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.519426</td>\n",
       "      <td>1.258202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5154</th>\n",
       "      <td>5155</td>\n",
       "      <td>TOI-2134 c</td>\n",
       "      <td>TOI-2134</td>\n",
       "      <td>c</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 75878355</td>\n",
       "      <td>Gaia DR2 4610267648427698816</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.344308</td>\n",
       "      <td>0.861570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5283</th>\n",
       "      <td>5284</td>\n",
       "      <td>TOI-4600 c</td>\n",
       "      <td>TOI-4600</td>\n",
       "      <td>c</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TIC 232608943</td>\n",
       "      <td>Gaia DR2 1631416599805196544</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a refstr=STASSUN_ET_AL__2019 href=https://ui....</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.498281</td>\n",
       "      <td>1.211949</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15 rows × 320 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      rowid        pl_name     hostname pl_letter hd_name hip_name  \\\n",
       "2848   2849  Kepler-1628 b  Kepler-1628         b     NaN      NaN   \n",
       "2875   2876  Kepler-1647 b  Kepler-1647         b     NaN      NaN   \n",
       "2952   2953  Kepler-1704 b  Kepler-1704         b     NaN      NaN   \n",
       "2955   2956  Kepler-1708 b  Kepler-1708         b     NaN      NaN   \n",
       "3311   3312  Kepler-1981 b  Kepler-1981         b     NaN      NaN   \n",
       "3756   3757    Kepler-34 b    Kepler-34         b     NaN      NaN   \n",
       "3949   3950   Kepler-419 c   Kepler-419         c     NaN      NaN   \n",
       "4005   4006   Kepler-453 b   Kepler-453         b     NaN      NaN   \n",
       "4027   4028    Kepler-47 d    Kepler-47         d     NaN      NaN   \n",
       "4149   4150   Kepler-553 c   Kepler-553         c     NaN      NaN   \n",
       "4954   4955          PH2 b          PH2         b     NaN      NaN   \n",
       "5021   5022     TOI-1227 b     TOI-1227         b     NaN      NaN   \n",
       "5129   5130      TOI-199 c      TOI-199         c     NaN      NaN   \n",
       "5154   5155     TOI-2134 c     TOI-2134         c     NaN      NaN   \n",
       "5283   5284     TOI-4600 c     TOI-4600         c     NaN      NaN   \n",
       "\n",
       "             tic_id                       gaia_id  sy_snum  sy_pnum  ...  \\\n",
       "2848  TIC 123362984  Gaia DR2 2105245187265625728        1        1  ...   \n",
       "2875  TIC 170344769  Gaia DR2 2073793420945053824        2        1  ...   \n",
       "2952  TIC 350738167  Gaia DR2 2136191736602006016        1        1  ...   \n",
       "2955  TIC 272716898  Gaia DR2 2078801971283008128        1        1  ...   \n",
       "3311  TIC 121457557  Gaia DR2 2099583977992504576        1        1  ...   \n",
       "3756  TIC 272369124  Gaia DR2 2079692678777827712        2        1  ...   \n",
       "3949   TIC 27454084  Gaia DR2 2135604425595213440        1        2  ...   \n",
       "4005  TIC 164457525  Gaia DR2 2107434834610481920        2        1  ...   \n",
       "4027  TIC 271548206  Gaia DR2 2080506523540902912        2        3  ...   \n",
       "4149  TIC 264508613  Gaia DR2 2086498312157538688        1        2  ...   \n",
       "4954  TIC 416279912  Gaia DR2 2139300262131379584        1        1  ...   \n",
       "5021  TIC 360156606  Gaia DR2 5842480953772012928        1        1  ...   \n",
       "5129  TIC 309792357  Gaia DR2 4762582895440787712        1        2  ...   \n",
       "5154   TIC 75878355  Gaia DR2 4610267648427698816        1        2  ...   \n",
       "5283  TIC 232608943  Gaia DR2 1631416599805196544        1        2  ...   \n",
       "\n",
       "      sy_kepmagerr2                                  sy_kepmag_reflink  \\\n",
       "2848            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "2875            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "2952            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "2955            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "3311            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "3756            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "3949            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "4005            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "4027            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "4149            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "4954            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "5021            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "5129            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "5154            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "5283            NaN  <a refstr=STASSUN_ET_AL__2019 href=https://ui....   \n",
       "\n",
       "     pl_nnotes  st_nphot st_nrvc st_nspec pl_nespec pl_ntranspec    in_CHZ  \\\n",
       "2848       1.0         0       0        0         0            0  0.174356   \n",
       "2875       1.0         0       0        0         0            0  1.548719   \n",
       "2952       0.0         0       0        0         0            0  1.264619   \n",
       "2955       1.0         0       0        0         0            0  0.911720   \n",
       "3311       0.0         0       0        0         0            0  0.990198   \n",
       "3756       1.0         0       0        0         0            0  0.911052   \n",
       "3949       NaN         0       0        0         0            0  1.662990   \n",
       "4005       3.0         0       0        0         0            0  0.587897   \n",
       "4027       3.0         0       0        0         0            0  0.639573   \n",
       "4149       1.0         0       0        0         0            0  0.562493   \n",
       "4954       1.0         0       0        0         0            0  0.703348   \n",
       "5021       0.0         0       0        0         0            0  0.040959   \n",
       "5129       0.0         0       0        0         0            0  0.519426   \n",
       "5154       0.0         0       0        0         0            0  0.344308   \n",
       "5283       2.0         0       0        0         0            0  0.498281   \n",
       "\n",
       "       out_CHZ  \n",
       "2848  0.453242  \n",
       "2875  3.592337  \n",
       "2952  2.993113  \n",
       "2955  2.119406  \n",
       "3311  2.330102  \n",
       "3756  2.140151  \n",
       "3949  3.824131  \n",
       "4005  1.405676  \n",
       "4027  1.521445  \n",
       "4149  1.366741  \n",
       "4954  1.665605  \n",
       "5021  0.109280  \n",
       "5129  1.258202  \n",
       "5154  0.861570  \n",
       "5283  1.211949  \n",
       "\n",
       "[15 rows x 320 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# FILTERS OUT PLANETS WITH ORBITAL SEPARATION OUTSIDE THIS CALCULATED RANGE OF CHZ\n",
    "\n",
    "filtered_archive = filtered[(filtered['pl_orbsmax'] >= filtered['in_CHZ']) & (filtered['pl_orbsmax'] <= filtered['out_CHZ'])]\n",
    "filtered_archive\n",
    "#print('Done.')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>pl_name</th>\n",
       "      <th>pl_radj</th>\n",
       "      <th>pl_orbsmax</th>\n",
       "      <th>in_CHZ</th>\n",
       "      <th>out_CHZ</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2848</th>\n",
       "      <td>Kepler-1628 b</td>\n",
       "      <td>0.574</td>\n",
       "      <td>0.2952</td>\n",
       "      <td>0.174356</td>\n",
       "      <td>0.453242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2875</th>\n",
       "      <td>Kepler-1647 b</td>\n",
       "      <td>1.059</td>\n",
       "      <td>2.7205</td>\n",
       "      <td>1.548719</td>\n",
       "      <td>3.592337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2952</th>\n",
       "      <td>Kepler-1704 b</td>\n",
       "      <td>1.066</td>\n",
       "      <td>2.0270</td>\n",
       "      <td>1.264619</td>\n",
       "      <td>2.993113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2955</th>\n",
       "      <td>Kepler-1708 b</td>\n",
       "      <td>0.889</td>\n",
       "      <td>1.6400</td>\n",
       "      <td>0.911720</td>\n",
       "      <td>2.119406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3311</th>\n",
       "      <td>Kepler-1981 b</td>\n",
       "      <td>0.840</td>\n",
       "      <td>1.3292</td>\n",
       "      <td>0.990198</td>\n",
       "      <td>2.330102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3756</th>\n",
       "      <td>Kepler-34 b</td>\n",
       "      <td>0.764</td>\n",
       "      <td>1.0896</td>\n",
       "      <td>0.911052</td>\n",
       "      <td>2.140151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3949</th>\n",
       "      <td>Kepler-419 c</td>\n",
       "      <td>1.130</td>\n",
       "      <td>1.6800</td>\n",
       "      <td>1.662990</td>\n",
       "      <td>3.824131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4005</th>\n",
       "      <td>Kepler-453 b</td>\n",
       "      <td>0.553</td>\n",
       "      <td>0.7903</td>\n",
       "      <td>0.587897</td>\n",
       "      <td>1.405676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4027</th>\n",
       "      <td>Kepler-47 d</td>\n",
       "      <td>0.628</td>\n",
       "      <td>0.6992</td>\n",
       "      <td>0.639573</td>\n",
       "      <td>1.521445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4149</th>\n",
       "      <td>Kepler-553 c</td>\n",
       "      <td>1.033</td>\n",
       "      <td>0.8980</td>\n",
       "      <td>0.562493</td>\n",
       "      <td>1.366741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4954</th>\n",
       "      <td>PH2 b</td>\n",
       "      <td>0.833</td>\n",
       "      <td>0.8330</td>\n",
       "      <td>0.703348</td>\n",
       "      <td>1.665605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5021</th>\n",
       "      <td>TOI-1227 b</td>\n",
       "      <td>0.854</td>\n",
       "      <td>0.0886</td>\n",
       "      <td>0.040959</td>\n",
       "      <td>0.109280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5129</th>\n",
       "      <td>TOI-199 c</td>\n",
       "      <td>1.010</td>\n",
       "      <td>0.8070</td>\n",
       "      <td>0.519426</td>\n",
       "      <td>1.258202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5154</th>\n",
       "      <td>TOI-2134 c</td>\n",
       "      <td>0.649</td>\n",
       "      <td>0.3710</td>\n",
       "      <td>0.344308</td>\n",
       "      <td>0.861570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5283</th>\n",
       "      <td>TOI-4600 c</td>\n",
       "      <td>0.841</td>\n",
       "      <td>1.1520</td>\n",
       "      <td>0.498281</td>\n",
       "      <td>1.211949</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            pl_name  pl_radj  pl_orbsmax    in_CHZ   out_CHZ\n",
       "2848  Kepler-1628 b    0.574      0.2952  0.174356  0.453242\n",
       "2875  Kepler-1647 b    1.059      2.7205  1.548719  3.592337\n",
       "2952  Kepler-1704 b    1.066      2.0270  1.264619  2.993113\n",
       "2955  Kepler-1708 b    0.889      1.6400  0.911720  2.119406\n",
       "3311  Kepler-1981 b    0.840      1.3292  0.990198  2.330102\n",
       "3756    Kepler-34 b    0.764      1.0896  0.911052  2.140151\n",
       "3949   Kepler-419 c    1.130      1.6800  1.662990  3.824131\n",
       "4005   Kepler-453 b    0.553      0.7903  0.587897  1.405676\n",
       "4027    Kepler-47 d    0.628      0.6992  0.639573  1.521445\n",
       "4149   Kepler-553 c    1.033      0.8980  0.562493  1.366741\n",
       "4954          PH2 b    0.833      0.8330  0.703348  1.665605\n",
       "5021     TOI-1227 b    0.854      0.0886  0.040959  0.109280\n",
       "5129      TOI-199 c    1.010      0.8070  0.519426  1.258202\n",
       "5154     TOI-2134 c    0.649      0.3710  0.344308  0.861570\n",
       "5283     TOI-4600 c    0.841      1.1520  0.498281  1.211949"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# TEST TO SEE IF THE MASS > 0.5 JUPITER MASS AND SEPARATION IS WITHIN THE CALCULATED CIRCUMSTELLAR HABITABLE ZONE\n",
    "test = filtered_archive[['pl_name','pl_radj','pl_orbsmax','in_CHZ','out_CHZ']]\n",
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}