fiddle.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "habitable_colors = ['#B1BF64','#087F14','#66CCFF','#083440','#4DE5A4','#BFB735','#347F07','#264AFF','#193640','#24E55E','#AEBF69','#A2BEFF','#0E0077','#607F23','#AEBF69']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "gas_colors = ['#01ABBF','#7F3D44','#630577','#401131','#E53324','#E5E08A','#A90700','#AA0BBF','#6B677F','#D6EFFF','#905FE5','#A90E37','#BF5CAE']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "rocky_colors = ['#787878','#7F7248','#383236','#837772','#A9442A','#A98945','#6E6169','#CFC75C']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "host_star_df = pd.read_csv('host_star.csv').set_index('HostStar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "HostStarClass                                                                  K\n",
       "HostStarRadiusSlrRad                                                         NaN\n",
       "HostStarTempK                                                               4977\n",
       "DistFromSunParsec                                                         12.995\n",
       "HostStarInnerHabitabilityAU                                                  NaN\n",
       "HostStarOuterHabitabilityAU                                                  NaN\n",
       "HostStarColor                                                            #ffd2a1\n",
       "HostStarMetallicity                                                        -0.31\n",
       "HostStarLuminosity                                                           NaN\n",
       "HostStarMassSlrMass                                                         0.77\n",
       "RightAscension                                                    05 54 04.23991\n",
       "Declination                                                       -60 01 24.4977\n",
       "HostStarPlanetList             ['HD 40307 b', 'HD 40307 c', 'HD 40307 d', 'HD...\n",
       "DistFromSunLY                                                            42.3637\n",
       "HabitablePlanets                                                               0\n",
       "HabitablePlanetsList                                                          []\n",
       "Planets                                                                        6\n",
       "Coordinates                    -10.449451973561402 -6.450823355709227 4.25039...\n",
       "Name: HD 40307, dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "host_star_df.loc['HD 40307']"
   ]
  },
  {
   "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>HostStarRadiusSlrRad</th>\n",
       "      <th>HostStarTempK</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HostStar</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>CFBDS 1458</th>\n",
       "      <td>NaN</td>\n",
       "      <td>540.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SDSS J1110+0116</th>\n",
       "      <td>NaN</td>\n",
       "      <td>940.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SIMP0136+0933</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1098.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2M 044144</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2M 0746+20</th>\n",
       "      <td>0.0890</td>\n",
       "      <td>2205.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2M 2140+16</th>\n",
       "      <td>0.1000</td>\n",
       "      <td>2300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2M 2206-20</th>\n",
       "      <td>0.1100</td>\n",
       "      <td>2350.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2M1207</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2550.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRAPPIST-1</th>\n",
       "      <td>0.1210</td>\n",
       "      <td>2559.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UScoCTIO 108</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Oph 11</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2838.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FU Tau</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2838.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GJ 682</th>\n",
       "      <td>NaN</td>\n",
       "      <td>3028.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Proxima Centauri</th>\n",
       "      <td>0.1410</td>\n",
       "      <td>3050.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2MASS J0219-3925</th>\n",
       "      <td>0.2810</td>\n",
       "      <td>3064.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gliese 876</th>\n",
       "      <td>0.3761</td>\n",
       "      <td>3129.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LHS 1140</th>\n",
       "      <td>0.1860</td>\n",
       "      <td>3131.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-445</th>\n",
       "      <td>0.2100</td>\n",
       "      <td>3157.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GJ 3323</th>\n",
       "      <td>0.1190</td>\n",
       "      <td>3159.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EPIC 210490365</th>\n",
       "      <td>0.2950</td>\n",
       "      <td>3180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIP 57050</th>\n",
       "      <td>0.4000</td>\n",
       "      <td>3190.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIP 79431</th>\n",
       "      <td>NaN</td>\n",
       "      <td>3191.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ross 128</th>\n",
       "      <td>0.1967</td>\n",
       "      <td>3192.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-1582</th>\n",
       "      <td>0.3000</td>\n",
       "      <td>3208.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EPIC 206318379</th>\n",
       "      <td>0.2930</td>\n",
       "      <td>3214.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gliese 1214</th>\n",
       "      <td>0.2213</td>\n",
       "      <td>3250.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GJ 1132</th>\n",
       "      <td>0.2070</td>\n",
       "      <td>3270.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-1646</th>\n",
       "      <td>0.2600</td>\n",
       "      <td>3299.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gliese 3634</th>\n",
       "      <td>0.4300</td>\n",
       "      <td>3314.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GJ 422</th>\n",
       "      <td>NaN</td>\n",
       "      <td>3323.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIP 67537</th>\n",
       "      <td>8.6900</td>\n",
       "      <td>4985.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-954</th>\n",
       "      <td>0.7600</td>\n",
       "      <td>4990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HAT-P-19</th>\n",
       "      <td>0.8200</td>\n",
       "      <td>4990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-1178</th>\n",
       "      <td>0.7500</td>\n",
       "      <td>4990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-278</th>\n",
       "      <td>2.9350</td>\n",
       "      <td>4991.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 98219</th>\n",
       "      <td>4.5000</td>\n",
       "      <td>4992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-1608</th>\n",
       "      <td>0.7200</td>\n",
       "      <td>4992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 93083</th>\n",
       "      <td>NaN</td>\n",
       "      <td>4995.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-1593</th>\n",
       "      <td>0.7700</td>\n",
       "      <td>4995.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-472</th>\n",
       "      <td>0.7800</td>\n",
       "      <td>4996.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-169</th>\n",
       "      <td>0.7630</td>\n",
       "      <td>4997.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WASP-52</th>\n",
       "      <td>0.7900</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WTS-2</th>\n",
       "      <td>0.7520</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lupus-TR 3b</th>\n",
       "      <td>0.8200</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIP 65891</th>\n",
       "      <td>8.9300</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-1208</th>\n",
       "      <td>0.7600</td>\n",
       "      <td>5001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-934</th>\n",
       "      <td>0.7700</td>\n",
       "      <td>5001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 95089</th>\n",
       "      <td>4.9000</td>\n",
       "      <td>5002.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-1261</th>\n",
       "      <td>0.7700</td>\n",
       "      <td>5006.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BD+14 4559</th>\n",
       "      <td>NaN</td>\n",
       "      <td>5008.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-749</th>\n",
       "      <td>0.7500</td>\n",
       "      <td>5009.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-475</th>\n",
       "      <td>0.7900</td>\n",
       "      <td>5009.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 181342</th>\n",
       "      <td>4.6000</td>\n",
       "      <td>5014.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-489</th>\n",
       "      <td>0.7600</td>\n",
       "      <td>5014.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 103720</th>\n",
       "      <td>0.7300</td>\n",
       "      <td>5017.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-224</th>\n",
       "      <td>0.6760</td>\n",
       "      <td>5018.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 167042</th>\n",
       "      <td>4.3000</td>\n",
       "      <td>5020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-859</th>\n",
       "      <td>0.7700</td>\n",
       "      <td>5020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIP 97233</th>\n",
       "      <td>5.3400</td>\n",
       "      <td>5020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-242</th>\n",
       "      <td>0.8500</td>\n",
       "      <td>5020.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>550 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  HostStarRadiusSlrRad  HostStarTempK\n",
       "HostStar                                             \n",
       "CFBDS 1458                         NaN          540.0\n",
       "SDSS J1110+0116                    NaN          940.0\n",
       "SIMP0136+0933                      NaN         1098.0\n",
       "2M 044144                          NaN         2100.0\n",
       "2M 0746+20                      0.0890         2205.0\n",
       "2M 2140+16                      0.1000         2300.0\n",
       "2M 2206-20                      0.1100         2350.0\n",
       "2M1207                             NaN         2550.0\n",
       "TRAPPIST-1                      0.1210         2559.0\n",
       "UScoCTIO 108                       NaN         2700.0\n",
       "Oph 11                             NaN         2838.0\n",
       "FU Tau                             NaN         2838.0\n",
       "GJ 682                             NaN         3028.0\n",
       "Proxima Centauri                0.1410         3050.0\n",
       "2MASS J0219-3925                0.2810         3064.0\n",
       "Gliese 876                      0.3761         3129.0\n",
       "LHS 1140                        0.1860         3131.0\n",
       "Kepler-445                      0.2100         3157.0\n",
       "GJ 3323                         0.1190         3159.0\n",
       "EPIC 210490365                  0.2950         3180.0\n",
       "HIP 57050                       0.4000         3190.0\n",
       "HIP 79431                          NaN         3191.0\n",
       "Ross 128                        0.1967         3192.0\n",
       "Kepler-1582                     0.3000         3208.0\n",
       "EPIC 206318379                  0.2930         3214.0\n",
       "Gliese 1214                     0.2213         3250.0\n",
       "GJ 1132                         0.2070         3270.0\n",
       "Kepler-1646                     0.2600         3299.0\n",
       "Gliese 3634                     0.4300         3314.0\n",
       "GJ 422                             NaN         3323.0\n",
       "...                                ...            ...\n",
       "HIP 67537                       8.6900         4985.0\n",
       "Kepler-954                      0.7600         4990.0\n",
       "HAT-P-19                        0.8200         4990.0\n",
       "Kepler-1178                     0.7500         4990.0\n",
       "Kepler-278                      2.9350         4991.0\n",
       "HD 98219                        4.5000         4992.0\n",
       "Kepler-1608                     0.7200         4992.0\n",
       "HD 93083                           NaN         4995.0\n",
       "Kepler-1593                     0.7700         4995.0\n",
       "Kepler-472                      0.7800         4996.0\n",
       "Kepler-169                      0.7630         4997.0\n",
       "WASP-52                         0.7900         5000.0\n",
       "WTS-2                           0.7520         5000.0\n",
       "Lupus-TR 3b                     0.8200         5000.0\n",
       "HIP 65891                       8.9300         5000.0\n",
       "Kepler-1208                     0.7600         5001.0\n",
       "Kepler-934                      0.7700         5001.0\n",
       "HD 95089                        4.9000         5002.0\n",
       "Kepler-1261                     0.7700         5006.0\n",
       "BD+14 4559                         NaN         5008.0\n",
       "Kepler-749                      0.7500         5009.0\n",
       "Kepler-475                      0.7900         5009.0\n",
       "HD 181342                       4.6000         5014.0\n",
       "Kepler-489                      0.7600         5014.0\n",
       "HD 103720                       0.7300         5017.0\n",
       "Kepler-224                      0.6760         5018.0\n",
       "HD 167042                       4.3000         5020.0\n",
       "Kepler-859                      0.7700         5020.0\n",
       "HIP 97233                       5.3400         5020.0\n",
       "Kepler-242                      0.8500         5020.0\n",
       "\n",
       "[550 rows x 2 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "host_star_df[['HostStarRadiusSlrRad', 'HostStarTempK']].sort_values('HostStarTempK').head(550)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'PlanetIdentifier', 'Declination', 'DiscoveryMethod',\n",
       "       'DiscoveryYear', 'DistFromSunParsec', 'Eccentricity',\n",
       "       'HostStarMassSlrMass', 'HostStarMetallicity', 'HostStarRadiusSlrRad',\n",
       "       'HostStarTempK', 'ListsPlanetIsOn', 'PeriodDays', 'PlanetaryMassJpt',\n",
       "       'RadiusJpt', 'RightAscension', 'SemiMajorAxisAU', 'SurfaceTempK',\n",
       "       'TypeFlag', 'HostStar', 'HostStarLuminosity',\n",
       "       'HostStarInnerHabitabilityAU', 'HostStarOuterHabitabilityAU',\n",
       "       'HostStarClass', 'HostStarColor'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"working_data.csv\")\n",
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Declination</th>\n",
       "      <th>DiscoveryMethod</th>\n",
       "      <th>DiscoveryYear</th>\n",
       "      <th>DistFromSunParsec</th>\n",
       "      <th>Eccentricity</th>\n",
       "      <th>HostStarMassSlrMass</th>\n",
       "      <th>HostStarMetallicity</th>\n",
       "      <th>HostStarRadiusSlrRad</th>\n",
       "      <th>HostStarTempK</th>\n",
       "      <th>ListsPlanetIsOn</th>\n",
       "      <th>...</th>\n",
       "      <th>RightAscension</th>\n",
       "      <th>SemiMajorAxisAU</th>\n",
       "      <th>SurfaceTempK</th>\n",
       "      <th>TypeFlag</th>\n",
       "      <th>HostStar</th>\n",
       "      <th>HostStarLuminosity</th>\n",
       "      <th>HostStarInnerHabitabilityAU</th>\n",
       "      <th>HostStarOuterHabitabilityAU</th>\n",
       "      <th>HostStarClass</th>\n",
       "      <th>HostStarColor</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PlanetIdentifier</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",
       "      <th>KOI-1843.03</th>\n",
       "      <td>+40 13 14.7</td>\n",
       "      <td>transit</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.50</td>\n",
       "      <td>3687.0</td>\n",
       "      <td>Controversial</td>\n",
       "      <td>...</td>\n",
       "      <td>19 00 03.14</td>\n",
       "      <td>0.0048</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>KOI-1843</td>\n",
       "      <td>1.592389e+25</td>\n",
       "      <td>0.194521</td>\n",
       "      <td>0.280237</td>\n",
       "      <td>M</td>\n",
       "      <td>#ffcc6f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-974 b</th>\n",
       "      <td>+40 13 14.7</td>\n",
       "      <td>transit</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.50</td>\n",
       "      <td>3687.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 00 03.14</td>\n",
       "      <td>0.0390</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-974</td>\n",
       "      <td>1.592389e+25</td>\n",
       "      <td>0.194521</td>\n",
       "      <td>0.280237</td>\n",
       "      <td>M</td>\n",
       "      <td>#ffcc6f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KOI-1843.02</th>\n",
       "      <td>+40 13 14.7</td>\n",
       "      <td>transit</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.50</td>\n",
       "      <td>3687.0</td>\n",
       "      <td>Controversial</td>\n",
       "      <td>...</td>\n",
       "      <td>19 00 03.14</td>\n",
       "      <td>0.0520</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>KOI-1843</td>\n",
       "      <td>1.592389e+25</td>\n",
       "      <td>0.194521</td>\n",
       "      <td>0.280237</td>\n",
       "      <td>M</td>\n",
       "      <td>#ffcc6f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-9 b</th>\n",
       "      <td>+38 24 03</td>\n",
       "      <td>transit</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>0.0626</td>\n",
       "      <td>1.07</td>\n",
       "      <td>0.12</td>\n",
       "      <td>1.02</td>\n",
       "      <td>5777.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 02 17</td>\n",
       "      <td>0.1430</td>\n",
       "      <td>707.2</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-9</td>\n",
       "      <td>3.994170e+26</td>\n",
       "      <td>0.974217</td>\n",
       "      <td>1.403506</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-9 c</th>\n",
       "      <td>+38 24 03</td>\n",
       "      <td>transit</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>0.0684</td>\n",
       "      <td>1.07</td>\n",
       "      <td>0.12</td>\n",
       "      <td>1.02</td>\n",
       "      <td>5777.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 02 17</td>\n",
       "      <td>0.2290</td>\n",
       "      <td>557.9</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-9</td>\n",
       "      <td>3.994170e+26</td>\n",
       "      <td>0.974217</td>\n",
       "      <td>1.403506</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Declination DiscoveryMethod  DiscoveryYear  \\\n",
       "PlanetIdentifier                                               \n",
       "KOI-1843.03       +40 13 14.7         transit         2012.0   \n",
       "Kepler-974 b      +40 13 14.7         transit            NaN   \n",
       "KOI-1843.02       +40 13 14.7         transit            NaN   \n",
       "Kepler-9 b          +38 24 03         transit         2010.0   \n",
       "Kepler-9 c          +38 24 03         transit         2010.0   \n",
       "\n",
       "                  DistFromSunParsec  Eccentricity  HostStarMassSlrMass  \\\n",
       "PlanetIdentifier                                                         \n",
       "KOI-1843.03                     NaN           NaN                 0.52   \n",
       "Kepler-974 b                    NaN           NaN                 0.52   \n",
       "KOI-1843.02                     NaN           NaN                 0.52   \n",
       "Kepler-9 b                    650.0        0.0626                 1.07   \n",
       "Kepler-9 c                    650.0        0.0684                 1.07   \n",
       "\n",
       "                  HostStarMetallicity  HostStarRadiusSlrRad  HostStarTempK  \\\n",
       "PlanetIdentifier                                                             \n",
       "KOI-1843.03                      0.07                  0.50         3687.0   \n",
       "Kepler-974 b                     0.07                  0.50         3687.0   \n",
       "KOI-1843.02                      0.07                  0.50         3687.0   \n",
       "Kepler-9 b                       0.12                  1.02         5777.0   \n",
       "Kepler-9 c                       0.12                  1.02         5777.0   \n",
       "\n",
       "                    ListsPlanetIsOn      ...        RightAscension  \\\n",
       "PlanetIdentifier                         ...                         \n",
       "KOI-1843.03           Controversial      ...           19 00 03.14   \n",
       "Kepler-974 b      Confirmed planets      ...           19 00 03.14   \n",
       "KOI-1843.02           Controversial      ...           19 00 03.14   \n",
       "Kepler-9 b        Confirmed planets      ...              19 02 17   \n",
       "Kepler-9 c        Confirmed planets      ...              19 02 17   \n",
       "\n",
       "                  SemiMajorAxisAU  SurfaceTempK TypeFlag    HostStar  \\\n",
       "PlanetIdentifier                                                       \n",
       "KOI-1843.03                0.0048           NaN        0    KOI-1843   \n",
       "Kepler-974 b               0.0390           NaN        0  Kepler-974   \n",
       "KOI-1843.02                0.0520           NaN        0    KOI-1843   \n",
       "Kepler-9 b                 0.1430         707.2        0    Kepler-9   \n",
       "Kepler-9 c                 0.2290         557.9        0    Kepler-9   \n",
       "\n",
       "                  HostStarLuminosity  HostStarInnerHabitabilityAU  \\\n",
       "PlanetIdentifier                                                    \n",
       "KOI-1843.03             1.592389e+25                     0.194521   \n",
       "Kepler-974 b            1.592389e+25                     0.194521   \n",
       "KOI-1843.02             1.592389e+25                     0.194521   \n",
       "Kepler-9 b              3.994170e+26                     0.974217   \n",
       "Kepler-9 c              3.994170e+26                     0.974217   \n",
       "\n",
       "                 HostStarOuterHabitabilityAU  HostStarClass  HostStarColor  \n",
       "PlanetIdentifier                                                            \n",
       "KOI-1843.03                         0.280237              M        #ffcc6f  \n",
       "Kepler-974 b                        0.280237              M        #ffcc6f  \n",
       "KOI-1843.02                         0.280237              M        #ffcc6f  \n",
       "Kepler-9 b                          1.403506              G        #fff4ea  \n",
       "Kepler-9 c                          1.403506              G        #fff4ea  \n",
       "\n",
       "[5 rows x 23 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.set_index('PlanetIdentifier').drop('Unnamed: 0', axis=1)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Declination</th>\n",
       "      <th>DiscoveryMethod</th>\n",
       "      <th>DiscoveryYear</th>\n",
       "      <th>DistFromSunParsec</th>\n",
       "      <th>Eccentricity</th>\n",
       "      <th>HostStarMassSlrMass</th>\n",
       "      <th>HostStarMetallicity</th>\n",
       "      <th>HostStarRadiusSlrRad</th>\n",
       "      <th>HostStarTempK</th>\n",
       "      <th>ListsPlanetIsOn</th>\n",
       "      <th>...</th>\n",
       "      <th>RadiusJpt</th>\n",
       "      <th>RightAscension</th>\n",
       "      <th>SemiMajorAxisAU</th>\n",
       "      <th>SurfaceTempK</th>\n",
       "      <th>TypeFlag</th>\n",
       "      <th>HostStarLuminosity</th>\n",
       "      <th>HostStarInnerHabitabilityAU</th>\n",
       "      <th>HostStarOuterHabitabilityAU</th>\n",
       "      <th>HostStarClass</th>\n",
       "      <th>HostStarColor</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HostStar</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",
       "      <th>sun</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-90</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRAPPIST-1</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-11</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-80</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-55</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K2-138</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIP 41378</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-444</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-20</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-102</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-84</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-154</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-169</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-292</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-296</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-186</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-62</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-238</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-122</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-32</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-33</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-245</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-197</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-235</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-176</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-342</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-286</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-224</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-402</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</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>HD 330075</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 32963</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 231701</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 233604</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 23596</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 240210</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 240237</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 24040</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 24064</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 25171</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 2638</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 26965</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 27442 A</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 27631</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 27894</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 28185</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 28254</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 285507</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 28678</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 29021</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 290327</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 2952</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 30177</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 30562</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 30669</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 30856</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 31253</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 31527</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HD 32518</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>xi Aql</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2692 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Declination  DiscoveryMethod  DiscoveryYear  DistFromSunParsec  \\\n",
       "HostStar                                                                     \n",
       "sun                   0                0              3                  0   \n",
       "Kepler-90             8                8              8                  8   \n",
       "TRAPPIST-1            7                7              7                  7   \n",
       "Kepler-11             6                6              6                  6   \n",
       "Kepler-80             6                6              6                  6   \n",
       "Kepler-55             5                5              5                  5   \n",
       "K2-138                5                5              5                  5   \n",
       "HIP 41378             5                5              5                  5   \n",
       "Kepler-444            5                5              5                  5   \n",
       "Kepler-20             5                5              5                  5   \n",
       "Kepler-102            5                5              5                  5   \n",
       "Kepler-84             5                5              5                  5   \n",
       "Kepler-154            5                5              5                  5   \n",
       "Kepler-169            5                5              5                  5   \n",
       "Kepler-292            5                5              5                  5   \n",
       "Kepler-296            5                5              5                  5   \n",
       "Kepler-186            5                5              5                  5   \n",
       "Kepler-62             5                5              5                  5   \n",
       "Kepler-238            5                5              5                  5   \n",
       "Kepler-122            5                5              5                  5   \n",
       "Kepler-32             5                5              5                  5   \n",
       "Kepler-33             5                5              5                  5   \n",
       "Kepler-245            4                4              4                  4   \n",
       "Kepler-197            4                4              4                  4   \n",
       "Kepler-235            4                4              4                  4   \n",
       "Kepler-176            4                4              4                  4   \n",
       "Kepler-342            4                4              4                  4   \n",
       "Kepler-286            4                4              4                  4   \n",
       "Kepler-224            4                4              4                  4   \n",
       "Kepler-402            4                4              4                  4   \n",
       "...                 ...              ...            ...                ...   \n",
       "HD 330075             1                1              1                  1   \n",
       "HD 32963              1                1              1                  1   \n",
       "HD 231701             1                1              1                  1   \n",
       "HD 233604             1                1              1                  0   \n",
       "HD 23596              1                1              1                  1   \n",
       "HD 240210             1                1              1                  1   \n",
       "HD 240237             1                1              1                  0   \n",
       "HD 24040              1                1              1                  1   \n",
       "HD 24064              1                1              1                  1   \n",
       "HD 25171              1                1              1                  1   \n",
       "HD 2638               1                1              1                  1   \n",
       "HD 26965              1                1              1                  1   \n",
       "HD 27442 A            1                1              1                  1   \n",
       "HD 27631              1                1              1                  1   \n",
       "HD 27894              1                1              1                  1   \n",
       "HD 28185              1                1              1                  1   \n",
       "HD 28254              1                1              1                  1   \n",
       "HD 285507             1                1              1                  1   \n",
       "HD 28678              1                1              1                  1   \n",
       "HD 29021              1                1              1                  1   \n",
       "HD 290327             1                1              1                  1   \n",
       "HD 2952               1                1              1                  1   \n",
       "HD 30177              1                1              1                  1   \n",
       "HD 30562              1                1              1                  1   \n",
       "HD 30669              1                1              1                  1   \n",
       "HD 30856              1                1              1                  1   \n",
       "HD 31253              1                1              1                  1   \n",
       "HD 31527              3                3              3                  3   \n",
       "HD 32518              1                1              1                  1   \n",
       "xi Aql                1                1              1                  1   \n",
       "\n",
       "            Eccentricity  HostStarMassSlrMass  HostStarMetallicity  \\\n",
       "HostStar                                                             \n",
       "sun                    9                    9                    9   \n",
       "Kepler-90              0                    8                    8   \n",
       "TRAPPIST-1             7                    7                    7   \n",
       "Kepler-11              5                    6                    0   \n",
       "Kepler-80              0                    6                    6   \n",
       "Kepler-55              0                    5                    0   \n",
       "K2-138                 0                    5                    5   \n",
       "HIP 41378              0                    5                    5   \n",
       "Kepler-444             5                    5                    5   \n",
       "Kepler-20              0                    5                    5   \n",
       "Kepler-102             0                    5                    5   \n",
       "Kepler-84              0                    5                    0   \n",
       "Kepler-154             0                    0                    0   \n",
       "Kepler-169             0                    5                    0   \n",
       "Kepler-292             0                    5                    0   \n",
       "Kepler-296             0                    5                    5   \n",
       "Kepler-186             0                    5                    5   \n",
       "Kepler-62              0                    5                    5   \n",
       "Kepler-238             0                    5                    0   \n",
       "Kepler-122             0                    5                    0   \n",
       "Kepler-32              0                    5                    0   \n",
       "Kepler-33              0                    5                    5   \n",
       "Kepler-245             0                    4                    0   \n",
       "Kepler-197             4                    4                    0   \n",
       "Kepler-235             0                    4                    0   \n",
       "Kepler-176             0                    0                    0   \n",
       "Kepler-342             0                    0                    0   \n",
       "Kepler-286             0                    4                    0   \n",
       "Kepler-224             0                    4                    0   \n",
       "Kepler-402             0                    0                    0   \n",
       "...                  ...                  ...                  ...   \n",
       "HD 330075              1                    1                    1   \n",
       "HD 32963               1                    1                    1   \n",
       "HD 231701              1                    1                    1   \n",
       "HD 233604              1                    1                    1   \n",
       "HD 23596               1                    1                    1   \n",
       "HD 240210              1                    1                    1   \n",
       "HD 240237              1                    1                    1   \n",
       "HD 24040               1                    1                    1   \n",
       "HD 24064               1                    1                    1   \n",
       "HD 25171               1                    1                    1   \n",
       "HD 2638                1                    1                    1   \n",
       "HD 26965               1                    1                    1   \n",
       "HD 27442 A             1                    1                    1   \n",
       "HD 27631               1                    1                    1   \n",
       "HD 27894               1                    1                    1   \n",
       "HD 28185               1                    1                    1   \n",
       "HD 28254               1                    1                    1   \n",
       "HD 285507              1                    1                    1   \n",
       "HD 28678               1                    1                    1   \n",
       "HD 29021               1                    1                    1   \n",
       "HD 290327              1                    1                    1   \n",
       "HD 2952                1                    1                    1   \n",
       "HD 30177               1                    1                    1   \n",
       "HD 30562               1                    1                    1   \n",
       "HD 30669               1                    1                    1   \n",
       "HD 30856               1                    1                    1   \n",
       "HD 31253               1                    1                    1   \n",
       "HD 31527               3                    0                    0   \n",
       "HD 32518               1                    1                    1   \n",
       "xi Aql                 1                    1                    1   \n",
       "\n",
       "            HostStarRadiusSlrRad  HostStarTempK  ListsPlanetIsOn  \\\n",
       "HostStar                                                           \n",
       "sun                            9              9                9   \n",
       "Kepler-90                      8              8                8   \n",
       "TRAPPIST-1                     7              7                7   \n",
       "Kepler-11                      6              6                6   \n",
       "Kepler-80                      6              6                6   \n",
       "Kepler-55                      5              5                5   \n",
       "K2-138                         5              5                5   \n",
       "HIP 41378                      5              5                5   \n",
       "Kepler-444                     5              5                5   \n",
       "Kepler-20                      5              5                5   \n",
       "Kepler-102                     5              5                5   \n",
       "Kepler-84                      5              5                5   \n",
       "Kepler-154                     5              5                5   \n",
       "Kepler-169                     5              5                5   \n",
       "Kepler-292                     5              5                5   \n",
       "Kepler-296                     5              5                5   \n",
       "Kepler-186                     5              5                5   \n",
       "Kepler-62                      5              5                5   \n",
       "Kepler-238                     5              5                5   \n",
       "Kepler-122                     5              5                5   \n",
       "Kepler-32                      5              5                5   \n",
       "Kepler-33                      5              5                5   \n",
       "Kepler-245                     4              4                4   \n",
       "Kepler-197                     4              4                4   \n",
       "Kepler-235                     4              4                4   \n",
       "Kepler-176                     4              4                4   \n",
       "Kepler-342                     4              4                4   \n",
       "Kepler-286                     4              4                4   \n",
       "Kepler-224                     4              4                4   \n",
       "Kepler-402                     4              4                4   \n",
       "...                          ...            ...              ...   \n",
       "HD 330075                      0              1                1   \n",
       "HD 32963                       0              1                1   \n",
       "HD 231701                      1              1                1   \n",
       "HD 233604                      1              1                1   \n",
       "HD 23596                       1              1                1   \n",
       "HD 240210                      0              1                1   \n",
       "HD 240237                      1              1                1   \n",
       "HD 24040                       1              1                1   \n",
       "HD 24064                       1              1                1   \n",
       "HD 25171                       1              1                1   \n",
       "HD 2638                        0              1                1   \n",
       "HD 26965                       0              1                1   \n",
       "HD 27442 A                     1              0                1   \n",
       "HD 27631                       1              1                1   \n",
       "HD 27894                       0              1                1   \n",
       "HD 28185                       1              1                1   \n",
       "HD 28254                       1              1                1   \n",
       "HD 285507                      1              1                1   \n",
       "HD 28678                       1              1                1   \n",
       "HD 29021                       1              1                1   \n",
       "HD 290327                      1              1                1   \n",
       "HD 2952                        1              1                1   \n",
       "HD 30177                       1              1                1   \n",
       "HD 30562                       1              1                1   \n",
       "HD 30669                       1              1                1   \n",
       "HD 30856                       1              1                1   \n",
       "HD 31253                       1              1                1   \n",
       "HD 31527                       0              3                3   \n",
       "HD 32518                       1              1                1   \n",
       "xi Aql                         1              1                1   \n",
       "\n",
       "                ...        RadiusJpt  RightAscension  SemiMajorAxisAU  \\\n",
       "HostStar        ...                                                     \n",
       "sun             ...                9               0                9   \n",
       "Kepler-90       ...                8               8                7   \n",
       "TRAPPIST-1      ...                7               7                7   \n",
       "Kepler-11       ...                6               6                6   \n",
       "Kepler-80       ...                6               6                5   \n",
       "Kepler-55       ...                5               5                0   \n",
       "K2-138          ...                5               5                5   \n",
       "HIP 41378       ...                5               5                0   \n",
       "Kepler-444      ...                5               5                5   \n",
       "Kepler-20       ...                5               5                5   \n",
       "Kepler-102      ...                5               5                0   \n",
       "Kepler-84       ...                5               5                0   \n",
       "Kepler-154      ...                5               5                0   \n",
       "Kepler-169      ...                5               5                0   \n",
       "Kepler-292      ...                5               5                0   \n",
       "Kepler-296      ...                5               5                5   \n",
       "Kepler-186      ...                5               5                5   \n",
       "Kepler-62       ...                5               5                5   \n",
       "Kepler-238      ...                5               5                0   \n",
       "Kepler-122      ...                5               5                0   \n",
       "Kepler-32       ...                5               5                0   \n",
       "Kepler-33       ...                5               5                5   \n",
       "Kepler-245      ...                4               4                0   \n",
       "Kepler-197      ...                4               4                4   \n",
       "Kepler-235      ...                4               4                0   \n",
       "Kepler-176      ...                4               4                0   \n",
       "Kepler-342      ...                4               4                0   \n",
       "Kepler-286      ...                4               4                0   \n",
       "Kepler-224      ...                4               4                0   \n",
       "Kepler-402      ...                4               4                0   \n",
       "...             ...              ...             ...              ...   \n",
       "HD 330075       ...                0               1                1   \n",
       "HD 32963        ...                0               1                1   \n",
       "HD 231701       ...                0               1                1   \n",
       "HD 233604       ...                0               1                1   \n",
       "HD 23596        ...                0               1                1   \n",
       "HD 240210       ...                0               1                1   \n",
       "HD 240237       ...                0               1                1   \n",
       "HD 24040        ...                0               1                1   \n",
       "HD 24064        ...                0               1                1   \n",
       "HD 25171        ...                0               1                1   \n",
       "HD 2638         ...                0               1                1   \n",
       "HD 26965        ...                0               1                1   \n",
       "HD 27442 A      ...                0               1                1   \n",
       "HD 27631        ...                0               1                1   \n",
       "HD 27894        ...                0               1                1   \n",
       "HD 28185        ...                0               1                1   \n",
       "HD 28254        ...                0               1                1   \n",
       "HD 285507       ...                0               1                0   \n",
       "HD 28678        ...                0               1                1   \n",
       "HD 29021        ...                0               1                1   \n",
       "HD 290327       ...                0               1                1   \n",
       "HD 2952         ...                0               1                1   \n",
       "HD 30177        ...                0               1                1   \n",
       "HD 30562        ...                0               1                1   \n",
       "HD 30669        ...                0               1                1   \n",
       "HD 30856        ...                0               1                1   \n",
       "HD 31253        ...                0               1                1   \n",
       "HD 31527        ...                0               3                3   \n",
       "HD 32518        ...                0               1                1   \n",
       "xi Aql          ...                0               1                1   \n",
       "\n",
       "            SurfaceTempK  TypeFlag  HostStarLuminosity  \\\n",
       "HostStar                                                 \n",
       "sun                    0         9                   9   \n",
       "Kepler-90              0         8                   8   \n",
       "TRAPPIST-1             7         7                   7   \n",
       "Kepler-11              6         6                   6   \n",
       "Kepler-80              0         6                   6   \n",
       "Kepler-55              0         5                   5   \n",
       "K2-138                 0         5                   5   \n",
       "HIP 41378              0         5                   5   \n",
       "Kepler-444             0         5                   5   \n",
       "Kepler-20              5         5                   5   \n",
       "Kepler-102             0         5                   5   \n",
       "Kepler-84              0         5                   5   \n",
       "Kepler-154             0         5                   5   \n",
       "Kepler-169             0         5                   5   \n",
       "Kepler-292             0         5                   5   \n",
       "Kepler-296             0         5                   5   \n",
       "Kepler-186             0         5                   5   \n",
       "Kepler-62              5         5                   5   \n",
       "Kepler-238             0         5                   5   \n",
       "Kepler-122             0         5                   5   \n",
       "Kepler-32              0         5                   5   \n",
       "Kepler-33              5         5                   5   \n",
       "Kepler-245             0         4                   4   \n",
       "Kepler-197             0         4                   4   \n",
       "Kepler-235             0         4                   4   \n",
       "Kepler-176             0         4                   4   \n",
       "Kepler-342             0         4                   4   \n",
       "Kepler-286             0         4                   4   \n",
       "Kepler-224             0         4                   4   \n",
       "Kepler-402             0         4                   4   \n",
       "...                  ...       ...                 ...   \n",
       "HD 330075              1         1                   0   \n",
       "HD 32963               0         1                   0   \n",
       "HD 231701              1         1                   1   \n",
       "HD 233604              0         1                   1   \n",
       "HD 23596               1         1                   1   \n",
       "HD 240210              0         1                   0   \n",
       "HD 240237              0         1                   1   \n",
       "HD 24040               0         1                   1   \n",
       "HD 24064               0         1                   1   \n",
       "HD 25171               1         1                   1   \n",
       "HD 2638                1         1                   0   \n",
       "HD 26965               0         1                   0   \n",
       "HD 27442 A             0         1                   0   \n",
       "HD 27631               1         1                   1   \n",
       "HD 27894               1         1                   0   \n",
       "HD 28185               1         1                   1   \n",
       "HD 28254               1         1                   1   \n",
       "HD 285507              0         1                   1   \n",
       "HD 28678               1         1                   1   \n",
       "HD 29021               0         1                   1   \n",
       "HD 290327              1         1                   1   \n",
       "HD 2952                0         1                   1   \n",
       "HD 30177               1         1                   1   \n",
       "HD 30562               1         1                   1   \n",
       "HD 30669               0         1                   1   \n",
       "HD 30856               1         1                   1   \n",
       "HD 31253               0         1                   1   \n",
       "HD 31527               3         3                   0   \n",
       "HD 32518               0         1                   1   \n",
       "xi Aql                 0         1                   1   \n",
       "\n",
       "            HostStarInnerHabitabilityAU  HostStarOuterHabitabilityAU  \\\n",
       "HostStar                                                               \n",
       "sun                                   9                            9   \n",
       "Kepler-90                             8                            8   \n",
       "TRAPPIST-1                            7                            7   \n",
       "Kepler-11                             6                            6   \n",
       "Kepler-80                             6                            6   \n",
       "Kepler-55                             5                            5   \n",
       "K2-138                                5                            5   \n",
       "HIP 41378                             5                            5   \n",
       "Kepler-444                            5                            5   \n",
       "Kepler-20                             5                            5   \n",
       "Kepler-102                            5                            5   \n",
       "Kepler-84                             5                            5   \n",
       "Kepler-154                            5                            5   \n",
       "Kepler-169                            5                            5   \n",
       "Kepler-292                            5                            5   \n",
       "Kepler-296                            5                            5   \n",
       "Kepler-186                            5                            5   \n",
       "Kepler-62                             5                            5   \n",
       "Kepler-238                            5                            5   \n",
       "Kepler-122                            5                            5   \n",
       "Kepler-32                             5                            5   \n",
       "Kepler-33                             5                            5   \n",
       "Kepler-245                            4                            4   \n",
       "Kepler-197                            4                            4   \n",
       "Kepler-235                            4                            4   \n",
       "Kepler-176                            4                            4   \n",
       "Kepler-342                            4                            4   \n",
       "Kepler-286                            4                            4   \n",
       "Kepler-224                            4                            4   \n",
       "Kepler-402                            4                            4   \n",
       "...                                 ...                          ...   \n",
       "HD 330075                             0                            0   \n",
       "HD 32963                              0                            0   \n",
       "HD 231701                             1                            1   \n",
       "HD 233604                             1                            1   \n",
       "HD 23596                              1                            1   \n",
       "HD 240210                             0                            0   \n",
       "HD 240237                             1                            1   \n",
       "HD 24040                              1                            1   \n",
       "HD 24064                              1                            1   \n",
       "HD 25171                              1                            1   \n",
       "HD 2638                               0                            0   \n",
       "HD 26965                              0                            0   \n",
       "HD 27442 A                            0                            0   \n",
       "HD 27631                              1                            1   \n",
       "HD 27894                              0                            0   \n",
       "HD 28185                              1                            1   \n",
       "HD 28254                              1                            1   \n",
       "HD 285507                             1                            1   \n",
       "HD 28678                              1                            1   \n",
       "HD 29021                              1                            1   \n",
       "HD 290327                             1                            1   \n",
       "HD 2952                               1                            1   \n",
       "HD 30177                              1                            1   \n",
       "HD 30562                              1                            1   \n",
       "HD 30669                              1                            1   \n",
       "HD 30856                              1                            1   \n",
       "HD 31253                              1                            1   \n",
       "HD 31527                              0                            0   \n",
       "HD 32518                              1                            1   \n",
       "xi Aql                                1                            1   \n",
       "\n",
       "            HostStarClass  HostStarColor  \n",
       "HostStar                                  \n",
       "sun                     9              9  \n",
       "Kepler-90               8              8  \n",
       "TRAPPIST-1              7              7  \n",
       "Kepler-11               6              6  \n",
       "Kepler-80               6              6  \n",
       "Kepler-55               5              5  \n",
       "K2-138                  5              5  \n",
       "HIP 41378               5              5  \n",
       "Kepler-444              5              0  \n",
       "Kepler-20               5              5  \n",
       "Kepler-102              5              5  \n",
       "Kepler-84               5              5  \n",
       "Kepler-154              5              5  \n",
       "Kepler-169              5              5  \n",
       "Kepler-292              5              5  \n",
       "Kepler-296              5              0  \n",
       "Kepler-186              5              5  \n",
       "Kepler-62               5              5  \n",
       "Kepler-238              5              5  \n",
       "Kepler-122              5              5  \n",
       "Kepler-32               5              5  \n",
       "Kepler-33               5              5  \n",
       "Kepler-245              4              4  \n",
       "Kepler-197              4              4  \n",
       "Kepler-235              4              4  \n",
       "Kepler-176              4              4  \n",
       "Kepler-342              4              4  \n",
       "Kepler-286              4              4  \n",
       "Kepler-224              4              4  \n",
       "Kepler-402              4              4  \n",
       "...                   ...            ...  \n",
       "HD 330075               1              1  \n",
       "HD 32963                1              1  \n",
       "HD 231701               1              1  \n",
       "HD 233604               1              1  \n",
       "HD 23596                1              1  \n",
       "HD 240210               1              1  \n",
       "HD 240237               1              1  \n",
       "HD 24040                1              1  \n",
       "HD 24064                1              1  \n",
       "HD 25171                1              1  \n",
       "HD 2638                 1              0  \n",
       "HD 26965                1              0  \n",
       "HD 27442 A              1              0  \n",
       "HD 27631                1              1  \n",
       "HD 27894                1              1  \n",
       "HD 28185                1              1  \n",
       "HD 28254                1              1  \n",
       "HD 285507               1              1  \n",
       "HD 28678                1              1  \n",
       "HD 29021                1              1  \n",
       "HD 290327               1              1  \n",
       "HD 2952                 1              1  \n",
       "HD 30177                1              1  \n",
       "HD 30562                1              1  \n",
       "HD 30669                1              1  \n",
       "HD 30856                1              1  \n",
       "HD 31253                1              1  \n",
       "HD 31527                3              3  \n",
       "HD 32518                1              1  \n",
       "xi Aql                  1              1  \n",
       "\n",
       "[2692 rows x 22 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grouped_df = df.groupby('HostStar').count().sort_values('RadiusJpt', ascending = False)\n",
    "grouped_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "stars = grouped_df.head(7).index.tolist()\n",
    "extras = ['sun', 'Kepler-9']\n",
    "for extra in extras:\n",
    "    stars.append(extra) \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>Declination</th>\n",
       "      <th>DiscoveryMethod</th>\n",
       "      <th>DiscoveryYear</th>\n",
       "      <th>DistFromSunParsec</th>\n",
       "      <th>Eccentricity</th>\n",
       "      <th>HostStarMassSlrMass</th>\n",
       "      <th>HostStarMetallicity</th>\n",
       "      <th>HostStarRadiusSlrRad</th>\n",
       "      <th>HostStarTempK</th>\n",
       "      <th>ListsPlanetIsOn</th>\n",
       "      <th>...</th>\n",
       "      <th>RightAscension</th>\n",
       "      <th>SemiMajorAxisAU</th>\n",
       "      <th>SurfaceTempK</th>\n",
       "      <th>TypeFlag</th>\n",
       "      <th>HostStar</th>\n",
       "      <th>HostStarLuminosity</th>\n",
       "      <th>HostStarInnerHabitabilityAU</th>\n",
       "      <th>HostStarOuterHabitabilityAU</th>\n",
       "      <th>HostStarClass</th>\n",
       "      <th>HostStarColor</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PlanetIdentifier</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",
       "      <th>Kepler-9 b</th>\n",
       "      <td>+38 24 03</td>\n",
       "      <td>transit</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>650.00000</td>\n",
       "      <td>0.062600</td>\n",
       "      <td>1.0700</td>\n",
       "      <td>1.200000e-01</td>\n",
       "      <td>1.020</td>\n",
       "      <td>5777.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 02 17</td>\n",
       "      <td>0.143000</td>\n",
       "      <td>707.2</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-9</td>\n",
       "      <td>3.994170e+26</td>\n",
       "      <td>0.974217</td>\n",
       "      <td>1.403506</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-9 c</th>\n",
       "      <td>+38 24 03</td>\n",
       "      <td>transit</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>650.00000</td>\n",
       "      <td>0.068400</td>\n",
       "      <td>1.0700</td>\n",
       "      <td>1.200000e-01</td>\n",
       "      <td>1.020</td>\n",
       "      <td>5777.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 02 17</td>\n",
       "      <td>0.229000</td>\n",
       "      <td>557.9</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-9</td>\n",
       "      <td>3.994170e+26</td>\n",
       "      <td>0.974217</td>\n",
       "      <td>1.403506</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-9 d</th>\n",
       "      <td>+38 24 03</td>\n",
       "      <td>transit</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>650.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0700</td>\n",
       "      <td>1.200000e-01</td>\n",
       "      <td>1.020</td>\n",
       "      <td>5777.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 02 17</td>\n",
       "      <td>0.027100</td>\n",
       "      <td>1601.5</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-9</td>\n",
       "      <td>3.994170e+26</td>\n",
       "      <td>0.974217</td>\n",
       "      <td>1.403506</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mercury</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.205637</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.000000e-08</td>\n",
       "      <td>1.000</td>\n",
       "      <td>5778.0</td>\n",
       "      <td>Solar System</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.387098</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>sun</td>\n",
       "      <td>3.841730e+26</td>\n",
       "      <td>0.955446</td>\n",
       "      <td>1.376463</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Venus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.006764</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.000000e-08</td>\n",
       "      <td>1.000</td>\n",
       "      <td>5778.0</td>\n",
       "      <td>Solar System</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.723321</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>sun</td>\n",
       "      <td>3.841730e+26</td>\n",
       "      <td>0.955446</td>\n",
       "      <td>1.376463</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Earth</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.016732</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.000000e-08</td>\n",
       "      <td>1.000</td>\n",
       "      <td>5778.0</td>\n",
       "      <td>Solar System</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>sun</td>\n",
       "      <td>3.841730e+26</td>\n",
       "      <td>0.955446</td>\n",
       "      <td>1.376463</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mars</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.093365</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.000000e-08</td>\n",
       "      <td>1.000</td>\n",
       "      <td>5778.0</td>\n",
       "      <td>Solar System</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.523712</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>sun</td>\n",
       "      <td>3.841730e+26</td>\n",
       "      <td>0.955446</td>\n",
       "      <td>1.376463</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jupiter</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.048536</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.000000e-08</td>\n",
       "      <td>1.000</td>\n",
       "      <td>5778.0</td>\n",
       "      <td>Solar System</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.202480</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>sun</td>\n",
       "      <td>3.841730e+26</td>\n",
       "      <td>0.955446</td>\n",
       "      <td>1.376463</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saturn</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.055508</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.000000e-08</td>\n",
       "      <td>1.000</td>\n",
       "      <td>5778.0</td>\n",
       "      <td>Solar System</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.541499</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>sun</td>\n",
       "      <td>3.841730e+26</td>\n",
       "      <td>0.955446</td>\n",
       "      <td>1.376463</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Uranus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1781.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.046857</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.000000e-08</td>\n",
       "      <td>1.000</td>\n",
       "      <td>5778.0</td>\n",
       "      <td>Solar System</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.187979</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>sun</td>\n",
       "      <td>3.841730e+26</td>\n",
       "      <td>0.955446</td>\n",
       "      <td>1.376463</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Neptune</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1846.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.008954</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.000000e-08</td>\n",
       "      <td>1.000</td>\n",
       "      <td>5778.0</td>\n",
       "      <td>Solar System</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.069528</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>sun</td>\n",
       "      <td>3.841730e+26</td>\n",
       "      <td>0.955446</td>\n",
       "      <td>1.376463</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pluto</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1930.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.248852</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>1.000000e-08</td>\n",
       "      <td>1.000</td>\n",
       "      <td>5778.0</td>\n",
       "      <td>Solar System</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.486860</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>sun</td>\n",
       "      <td>3.841730e+26</td>\n",
       "      <td>0.955446</td>\n",
       "      <td>1.376463</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-11 b</th>\n",
       "      <td>+41 54 33</td>\n",
       "      <td>transit</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>613.20279</td>\n",
       "      <td>0.045000</td>\n",
       "      <td>0.9610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.053</td>\n",
       "      <td>5663.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 48 27</td>\n",
       "      <td>0.091000</td>\n",
       "      <td>870.7</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-11</td>\n",
       "      <td>3.930608e+26</td>\n",
       "      <td>0.966435</td>\n",
       "      <td>1.392294</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-11 c</th>\n",
       "      <td>+41 54 33</td>\n",
       "      <td>transit</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>613.20279</td>\n",
       "      <td>0.026000</td>\n",
       "      <td>0.9610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.053</td>\n",
       "      <td>5663.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 48 27</td>\n",
       "      <td>0.107000</td>\n",
       "      <td>806.8</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-11</td>\n",
       "      <td>3.930608e+26</td>\n",
       "      <td>0.966435</td>\n",
       "      <td>1.392294</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-11 d</th>\n",
       "      <td>+41 54 33</td>\n",
       "      <td>transit</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>613.20279</td>\n",
       "      <td>0.004000</td>\n",
       "      <td>0.9610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.053</td>\n",
       "      <td>5663.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 48 27</td>\n",
       "      <td>0.155000</td>\n",
       "      <td>658.7</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-11</td>\n",
       "      <td>3.930608e+26</td>\n",
       "      <td>0.966435</td>\n",
       "      <td>1.392294</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-11 e</th>\n",
       "      <td>+41 54 33</td>\n",
       "      <td>transit</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>613.20279</td>\n",
       "      <td>0.012000</td>\n",
       "      <td>0.9610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.053</td>\n",
       "      <td>5663.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 48 27</td>\n",
       "      <td>0.195000</td>\n",
       "      <td>596.4</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-11</td>\n",
       "      <td>3.930608e+26</td>\n",
       "      <td>0.966435</td>\n",
       "      <td>1.392294</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-11 f</th>\n",
       "      <td>+41 54 33</td>\n",
       "      <td>transit</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>613.20279</td>\n",
       "      <td>0.013000</td>\n",
       "      <td>0.9610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.053</td>\n",
       "      <td>5663.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 48 27</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>525.3</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-11</td>\n",
       "      <td>3.930608e+26</td>\n",
       "      <td>0.966435</td>\n",
       "      <td>1.392294</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-11 g</th>\n",
       "      <td>+41 54 33</td>\n",
       "      <td>transit</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>613.20279</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.053</td>\n",
       "      <td>5663.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 48 27</td>\n",
       "      <td>0.466000</td>\n",
       "      <td>386.4</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-11</td>\n",
       "      <td>3.930608e+26</td>\n",
       "      <td>0.966435</td>\n",
       "      <td>1.392294</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-55 d</th>\n",
       "      <td>+44 01 35</td>\n",
       "      <td>transit</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>610.01000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.619</td>\n",
       "      <td>4503.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 00 40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-55</td>\n",
       "      <td>5.430075e+25</td>\n",
       "      <td>0.359208</td>\n",
       "      <td>0.517492</td>\n",
       "      <td>K</td>\n",
       "      <td>#ffd2a1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-55 b</th>\n",
       "      <td>+44 01 35</td>\n",
       "      <td>transit</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>610.01000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.619</td>\n",
       "      <td>4503.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 00 40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-55</td>\n",
       "      <td>5.430075e+25</td>\n",
       "      <td>0.359208</td>\n",
       "      <td>0.517492</td>\n",
       "      <td>K</td>\n",
       "      <td>#ffd2a1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-55 c</th>\n",
       "      <td>+44 01 35</td>\n",
       "      <td>transit</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>610.01000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.619</td>\n",
       "      <td>4503.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 00 40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-55</td>\n",
       "      <td>5.430075e+25</td>\n",
       "      <td>0.359208</td>\n",
       "      <td>0.517492</td>\n",
       "      <td>K</td>\n",
       "      <td>#ffd2a1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-55 e</th>\n",
       "      <td>+44 01 35</td>\n",
       "      <td>transit</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>610.01000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.619</td>\n",
       "      <td>4503.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 00 40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-55</td>\n",
       "      <td>5.430075e+25</td>\n",
       "      <td>0.359208</td>\n",
       "      <td>0.517492</td>\n",
       "      <td>K</td>\n",
       "      <td>#ffd2a1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-55 f</th>\n",
       "      <td>+44 01 35</td>\n",
       "      <td>transit</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>610.01000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.619</td>\n",
       "      <td>4503.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 00 40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-55</td>\n",
       "      <td>5.430075e+25</td>\n",
       "      <td>0.359208</td>\n",
       "      <td>0.517492</td>\n",
       "      <td>K</td>\n",
       "      <td>#ffd2a1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-80 b</th>\n",
       "      <td>+39 58 43.62</td>\n",
       "      <td>transit</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>357.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7300</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.678</td>\n",
       "      <td>4540.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 44 27.016</td>\n",
       "      <td>0.064800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-80</td>\n",
       "      <td>6.731309e+25</td>\n",
       "      <td>0.399938</td>\n",
       "      <td>0.576170</td>\n",
       "      <td>K</td>\n",
       "      <td>#ffd2a1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-80 c</th>\n",
       "      <td>+39 58 43.62</td>\n",
       "      <td>transit</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>357.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7300</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.678</td>\n",
       "      <td>4540.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 44 27.016</td>\n",
       "      <td>0.079200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-80</td>\n",
       "      <td>6.731309e+25</td>\n",
       "      <td>0.399938</td>\n",
       "      <td>0.576170</td>\n",
       "      <td>K</td>\n",
       "      <td>#ffd2a1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-80 d</th>\n",
       "      <td>+39 58 43.62</td>\n",
       "      <td>transit</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>357.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7300</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.678</td>\n",
       "      <td>4540.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 44 27.016</td>\n",
       "      <td>0.037200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-80</td>\n",
       "      <td>6.731309e+25</td>\n",
       "      <td>0.399938</td>\n",
       "      <td>0.576170</td>\n",
       "      <td>K</td>\n",
       "      <td>#ffd2a1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-80 e</th>\n",
       "      <td>+39 58 43.62</td>\n",
       "      <td>transit</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>357.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7300</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.678</td>\n",
       "      <td>4540.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 44 27.016</td>\n",
       "      <td>0.049100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-80</td>\n",
       "      <td>6.731309e+25</td>\n",
       "      <td>0.399938</td>\n",
       "      <td>0.576170</td>\n",
       "      <td>K</td>\n",
       "      <td>#ffd2a1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-80 f</th>\n",
       "      <td>+39 58 43.62</td>\n",
       "      <td>transit</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>357.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7300</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.678</td>\n",
       "      <td>4540.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 44 27.016</td>\n",
       "      <td>0.017500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-80</td>\n",
       "      <td>6.731309e+25</td>\n",
       "      <td>0.399938</td>\n",
       "      <td>0.576170</td>\n",
       "      <td>K</td>\n",
       "      <td>#ffd2a1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-80 g</th>\n",
       "      <td>+39 58 43.62</td>\n",
       "      <td>transit</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>357.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7300</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.678</td>\n",
       "      <td>4540.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>19 44 27.016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-80</td>\n",
       "      <td>6.731309e+25</td>\n",
       "      <td>0.399938</td>\n",
       "      <td>0.576170</td>\n",
       "      <td>K</td>\n",
       "      <td>#ffd2a1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-90 h</th>\n",
       "      <td>+49 18 18.58</td>\n",
       "      <td>transit</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>780.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.2000</td>\n",
       "      <td>-1.200000e-01</td>\n",
       "      <td>1.200</td>\n",
       "      <td>6080.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>18 57 44.038</td>\n",
       "      <td>1.010000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-90</td>\n",
       "      <td>6.782558e+26</td>\n",
       "      <td>1.269520</td>\n",
       "      <td>1.828933</td>\n",
       "      <td>F</td>\n",
       "      <td>#f8f7ff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-90 g</th>\n",
       "      <td>+49 18 18.58</td>\n",
       "      <td>transit</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>780.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.2000</td>\n",
       "      <td>-1.200000e-01</td>\n",
       "      <td>1.200</td>\n",
       "      <td>6080.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>18 57 44.038</td>\n",
       "      <td>0.710000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-90</td>\n",
       "      <td>6.782558e+26</td>\n",
       "      <td>1.269520</td>\n",
       "      <td>1.828933</td>\n",
       "      <td>F</td>\n",
       "      <td>#f8f7ff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-90 f</th>\n",
       "      <td>+49 18 18.58</td>\n",
       "      <td>transit</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>780.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.2000</td>\n",
       "      <td>-1.200000e-01</td>\n",
       "      <td>1.200</td>\n",
       "      <td>6080.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>18 57 44.038</td>\n",
       "      <td>0.480000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-90</td>\n",
       "      <td>6.782558e+26</td>\n",
       "      <td>1.269520</td>\n",
       "      <td>1.828933</td>\n",
       "      <td>F</td>\n",
       "      <td>#f8f7ff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-90 e</th>\n",
       "      <td>+49 18 18.58</td>\n",
       "      <td>transit</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>780.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.2000</td>\n",
       "      <td>-1.200000e-01</td>\n",
       "      <td>1.200</td>\n",
       "      <td>6080.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>18 57 44.038</td>\n",
       "      <td>0.420000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-90</td>\n",
       "      <td>6.782558e+26</td>\n",
       "      <td>1.269520</td>\n",
       "      <td>1.828933</td>\n",
       "      <td>F</td>\n",
       "      <td>#f8f7ff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-90 d</th>\n",
       "      <td>+49 18 18.58</td>\n",
       "      <td>transit</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>780.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.2000</td>\n",
       "      <td>-1.200000e-01</td>\n",
       "      <td>1.200</td>\n",
       "      <td>6080.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>18 57 44.038</td>\n",
       "      <td>0.320000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-90</td>\n",
       "      <td>6.782558e+26</td>\n",
       "      <td>1.269520</td>\n",
       "      <td>1.828933</td>\n",
       "      <td>F</td>\n",
       "      <td>#f8f7ff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-90 c</th>\n",
       "      <td>+49 18 18.58</td>\n",
       "      <td>transit</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>780.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.2000</td>\n",
       "      <td>-1.200000e-01</td>\n",
       "      <td>1.200</td>\n",
       "      <td>6080.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>18 57 44.038</td>\n",
       "      <td>0.089000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-90</td>\n",
       "      <td>6.782558e+26</td>\n",
       "      <td>1.269520</td>\n",
       "      <td>1.828933</td>\n",
       "      <td>F</td>\n",
       "      <td>#f8f7ff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-90 b</th>\n",
       "      <td>+49 18 18.58</td>\n",
       "      <td>transit</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>780.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.2000</td>\n",
       "      <td>-1.200000e-01</td>\n",
       "      <td>1.200</td>\n",
       "      <td>6080.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>18 57 44.038</td>\n",
       "      <td>0.074000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-90</td>\n",
       "      <td>6.782558e+26</td>\n",
       "      <td>1.269520</td>\n",
       "      <td>1.828933</td>\n",
       "      <td>F</td>\n",
       "      <td>#f8f7ff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kepler-90 i</th>\n",
       "      <td>+49 18 18.58</td>\n",
       "      <td>transit</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>780.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.2000</td>\n",
       "      <td>-1.200000e-01</td>\n",
       "      <td>1.200</td>\n",
       "      <td>6080.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>18 57 44.038</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Kepler-90</td>\n",
       "      <td>6.782558e+26</td>\n",
       "      <td>1.269520</td>\n",
       "      <td>1.828933</td>\n",
       "      <td>F</td>\n",
       "      <td>#f8f7ff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRAPPIST-1 b</th>\n",
       "      <td>-05 02 36.44</td>\n",
       "      <td>transit</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>12.56000</td>\n",
       "      <td>0.019000</td>\n",
       "      <td>0.0802</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.121</td>\n",
       "      <td>2559.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 06 30.34</td>\n",
       "      <td>0.011110</td>\n",
       "      <td>400.1</td>\n",
       "      <td>0</td>\n",
       "      <td>TRAPPIST-1</td>\n",
       "      <td>2.164056e+23</td>\n",
       "      <td>0.022677</td>\n",
       "      <td>0.032669</td>\n",
       "      <td>M</td>\n",
       "      <td>#ffcc6f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRAPPIST-1 c</th>\n",
       "      <td>-05 02 36.44</td>\n",
       "      <td>transit</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>12.56000</td>\n",
       "      <td>0.014000</td>\n",
       "      <td>0.0802</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.121</td>\n",
       "      <td>2559.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 06 30.34</td>\n",
       "      <td>0.015220</td>\n",
       "      <td>341.9</td>\n",
       "      <td>0</td>\n",
       "      <td>TRAPPIST-1</td>\n",
       "      <td>2.164056e+23</td>\n",
       "      <td>0.022677</td>\n",
       "      <td>0.032669</td>\n",
       "      <td>M</td>\n",
       "      <td>#ffcc6f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRAPPIST-1 d</th>\n",
       "      <td>-05 02 36.44</td>\n",
       "      <td>transit</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>12.56000</td>\n",
       "      <td>0.003000</td>\n",
       "      <td>0.0802</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.121</td>\n",
       "      <td>2559.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 06 30.34</td>\n",
       "      <td>0.021450</td>\n",
       "      <td>288.0</td>\n",
       "      <td>0</td>\n",
       "      <td>TRAPPIST-1</td>\n",
       "      <td>2.164056e+23</td>\n",
       "      <td>0.022677</td>\n",
       "      <td>0.032669</td>\n",
       "      <td>M</td>\n",
       "      <td>#ffcc6f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRAPPIST-1 e</th>\n",
       "      <td>-05 02 36.44</td>\n",
       "      <td>transit</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>12.56000</td>\n",
       "      <td>0.007000</td>\n",
       "      <td>0.0802</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.121</td>\n",
       "      <td>2559.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 06 30.34</td>\n",
       "      <td>0.028180</td>\n",
       "      <td>251.3</td>\n",
       "      <td>0</td>\n",
       "      <td>TRAPPIST-1</td>\n",
       "      <td>2.164056e+23</td>\n",
       "      <td>0.022677</td>\n",
       "      <td>0.032669</td>\n",
       "      <td>M</td>\n",
       "      <td>#ffcc6f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRAPPIST-1 f</th>\n",
       "      <td>-05 02 36.44</td>\n",
       "      <td>transit</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>12.56000</td>\n",
       "      <td>0.011000</td>\n",
       "      <td>0.0802</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.121</td>\n",
       "      <td>2559.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 06 30.34</td>\n",
       "      <td>0.037100</td>\n",
       "      <td>219.0</td>\n",
       "      <td>0</td>\n",
       "      <td>TRAPPIST-1</td>\n",
       "      <td>2.164056e+23</td>\n",
       "      <td>0.022677</td>\n",
       "      <td>0.032669</td>\n",
       "      <td>M</td>\n",
       "      <td>#ffcc6f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRAPPIST-1 g</th>\n",
       "      <td>-05 02 36.44</td>\n",
       "      <td>transit</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>12.56000</td>\n",
       "      <td>0.003000</td>\n",
       "      <td>0.0802</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.121</td>\n",
       "      <td>2559.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 06 30.34</td>\n",
       "      <td>0.045100</td>\n",
       "      <td>198.6</td>\n",
       "      <td>0</td>\n",
       "      <td>TRAPPIST-1</td>\n",
       "      <td>2.164056e+23</td>\n",
       "      <td>0.022677</td>\n",
       "      <td>0.032669</td>\n",
       "      <td>M</td>\n",
       "      <td>#ffcc6f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRAPPIST-1 h</th>\n",
       "      <td>-05 02 36.44</td>\n",
       "      <td>transit</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>12.56000</td>\n",
       "      <td>0.086000</td>\n",
       "      <td>0.0802</td>\n",
       "      <td>4.000000e-02</td>\n",
       "      <td>0.121</td>\n",
       "      <td>2559.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 06 30.34</td>\n",
       "      <td>0.059600</td>\n",
       "      <td>167.0</td>\n",
       "      <td>0</td>\n",
       "      <td>TRAPPIST-1</td>\n",
       "      <td>2.164056e+23</td>\n",
       "      <td>0.022677</td>\n",
       "      <td>0.032669</td>\n",
       "      <td>M</td>\n",
       "      <td>#ffcc6f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K2-138 b</th>\n",
       "      <td>-10 50 58.91</td>\n",
       "      <td>transit</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>183.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9300</td>\n",
       "      <td>1.600000e-01</td>\n",
       "      <td>0.860</td>\n",
       "      <td>5378.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 15 47.769</td>\n",
       "      <td>0.033800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>K2-138</td>\n",
       "      <td>2.132538e+26</td>\n",
       "      <td>0.711854</td>\n",
       "      <td>1.025533</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K2-138 c</th>\n",
       "      <td>-10 50 58.91</td>\n",
       "      <td>transit</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>183.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9300</td>\n",
       "      <td>1.600000e-01</td>\n",
       "      <td>0.860</td>\n",
       "      <td>5378.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 15 47.769</td>\n",
       "      <td>0.044540</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>K2-138</td>\n",
       "      <td>2.132538e+26</td>\n",
       "      <td>0.711854</td>\n",
       "      <td>1.025533</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K2-138 d</th>\n",
       "      <td>-10 50 58.91</td>\n",
       "      <td>transit</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>183.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9300</td>\n",
       "      <td>1.600000e-01</td>\n",
       "      <td>0.860</td>\n",
       "      <td>5378.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 15 47.769</td>\n",
       "      <td>0.058830</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>K2-138</td>\n",
       "      <td>2.132538e+26</td>\n",
       "      <td>0.711854</td>\n",
       "      <td>1.025533</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K2-138 e</th>\n",
       "      <td>-10 50 58.91</td>\n",
       "      <td>transit</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>183.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9300</td>\n",
       "      <td>1.600000e-01</td>\n",
       "      <td>0.860</td>\n",
       "      <td>5378.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 15 47.769</td>\n",
       "      <td>0.078070</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>K2-138</td>\n",
       "      <td>2.132538e+26</td>\n",
       "      <td>0.711854</td>\n",
       "      <td>1.025533</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K2-138 f</th>\n",
       "      <td>-10 50 58.91</td>\n",
       "      <td>transit</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>183.00000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9300</td>\n",
       "      <td>1.600000e-01</td>\n",
       "      <td>0.860</td>\n",
       "      <td>5378.0</td>\n",
       "      <td>Confirmed planets</td>\n",
       "      <td>...</td>\n",
       "      <td>23 15 47.769</td>\n",
       "      <td>0.104300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>K2-138</td>\n",
       "      <td>2.132538e+26</td>\n",
       "      <td>0.711854</td>\n",
       "      <td>1.025533</td>\n",
       "      <td>G</td>\n",
       "      <td>#fff4ea</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>49 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Declination DiscoveryMethod  DiscoveryYear  \\\n",
       "PlanetIdentifier                                                \n",
       "Kepler-9 b           +38 24 03         transit         2010.0   \n",
       "Kepler-9 c           +38 24 03         transit         2010.0   \n",
       "Kepler-9 d           +38 24 03         transit         2010.0   \n",
       "Mercury                    NaN             NaN            NaN   \n",
       "Venus                      NaN             NaN            NaN   \n",
       "Earth                      NaN             NaN            NaN   \n",
       "Mars                       NaN             NaN            NaN   \n",
       "Jupiter                    NaN             NaN            NaN   \n",
       "Saturn                     NaN             NaN            NaN   \n",
       "Uranus                     NaN             NaN         1781.0   \n",
       "Neptune                    NaN             NaN         1846.0   \n",
       "Pluto                      NaN             NaN         1930.0   \n",
       "Kepler-11 b          +41 54 33         transit         2011.0   \n",
       "Kepler-11 c          +41 54 33         transit         2011.0   \n",
       "Kepler-11 d          +41 54 33         transit         2011.0   \n",
       "Kepler-11 e          +41 54 33         transit         2011.0   \n",
       "Kepler-11 f          +41 54 33         transit         2011.0   \n",
       "Kepler-11 g          +41 54 33         transit         2011.0   \n",
       "Kepler-55 d          +44 01 35         transit         2014.0   \n",
       "Kepler-55 b          +44 01 35         transit         2014.0   \n",
       "Kepler-55 c          +44 01 35         transit         2014.0   \n",
       "Kepler-55 e          +44 01 35         transit         2014.0   \n",
       "Kepler-55 f          +44 01 35         transit         2014.0   \n",
       "Kepler-80 b       +39 58 43.62         transit         2014.0   \n",
       "Kepler-80 c       +39 58 43.62         transit         2014.0   \n",
       "Kepler-80 d       +39 58 43.62         transit         2014.0   \n",
       "Kepler-80 e       +39 58 43.62         transit         2014.0   \n",
       "Kepler-80 f       +39 58 43.62         transit         2016.0   \n",
       "Kepler-80 g       +39 58 43.62         transit         2017.0   \n",
       "Kepler-90 h       +49 18 18.58         transit         2013.0   \n",
       "Kepler-90 g       +49 18 18.58         transit         2013.0   \n",
       "Kepler-90 f       +49 18 18.58         transit         2013.0   \n",
       "Kepler-90 e       +49 18 18.58         transit         2013.0   \n",
       "Kepler-90 d       +49 18 18.58         transit         2013.0   \n",
       "Kepler-90 c       +49 18 18.58         transit         2013.0   \n",
       "Kepler-90 b       +49 18 18.58         transit         2013.0   \n",
       "Kepler-90 i       +49 18 18.58         transit         2017.0   \n",
       "TRAPPIST-1 b      -05 02 36.44         transit         2016.0   \n",
       "TRAPPIST-1 c      -05 02 36.44         transit         2016.0   \n",
       "TRAPPIST-1 d      -05 02 36.44         transit         2017.0   \n",
       "TRAPPIST-1 e      -05 02 36.44         transit         2017.0   \n",
       "TRAPPIST-1 f      -05 02 36.44         transit         2017.0   \n",
       "TRAPPIST-1 g      -05 02 36.44         transit         2017.0   \n",
       "TRAPPIST-1 h      -05 02 36.44         transit         2017.0   \n",
       "K2-138 b          -10 50 58.91         transit         2018.0   \n",
       "K2-138 c          -10 50 58.91         transit         2018.0   \n",
       "K2-138 d          -10 50 58.91         transit         2018.0   \n",
       "K2-138 e          -10 50 58.91         transit         2018.0   \n",
       "K2-138 f          -10 50 58.91         transit         2018.0   \n",
       "\n",
       "                  DistFromSunParsec  Eccentricity  HostStarMassSlrMass  \\\n",
       "PlanetIdentifier                                                         \n",
       "Kepler-9 b                650.00000      0.062600               1.0700   \n",
       "Kepler-9 c                650.00000      0.068400               1.0700   \n",
       "Kepler-9 d                650.00000           NaN               1.0700   \n",
       "Mercury                         NaN      0.205637               1.0000   \n",
       "Venus                           NaN      0.006764               1.0000   \n",
       "Earth                           NaN      0.016732               1.0000   \n",
       "Mars                            NaN      0.093365               1.0000   \n",
       "Jupiter                         NaN      0.048536               1.0000   \n",
       "Saturn                          NaN      0.055508               1.0000   \n",
       "Uranus                          NaN      0.046857               1.0000   \n",
       "Neptune                         NaN      0.008954               1.0000   \n",
       "Pluto                           NaN      0.248852               1.0000   \n",
       "Kepler-11 b               613.20279      0.045000               0.9610   \n",
       "Kepler-11 c               613.20279      0.026000               0.9610   \n",
       "Kepler-11 d               613.20279      0.004000               0.9610   \n",
       "Kepler-11 e               613.20279      0.012000               0.9610   \n",
       "Kepler-11 f               613.20279      0.013000               0.9610   \n",
       "Kepler-11 g               613.20279           NaN               0.9610   \n",
       "Kepler-55 d               610.01000           NaN               0.6310   \n",
       "Kepler-55 b               610.01000           NaN               0.6310   \n",
       "Kepler-55 c               610.01000           NaN               0.6310   \n",
       "Kepler-55 e               610.01000           NaN               0.6310   \n",
       "Kepler-55 f               610.01000           NaN               0.6310   \n",
       "Kepler-80 b               357.00000           NaN               0.7300   \n",
       "Kepler-80 c               357.00000           NaN               0.7300   \n",
       "Kepler-80 d               357.00000           NaN               0.7300   \n",
       "Kepler-80 e               357.00000           NaN               0.7300   \n",
       "Kepler-80 f               357.00000           NaN               0.7300   \n",
       "Kepler-80 g               357.00000           NaN               0.7300   \n",
       "Kepler-90 h               780.00000           NaN               1.2000   \n",
       "Kepler-90 g               780.00000           NaN               1.2000   \n",
       "Kepler-90 f               780.00000           NaN               1.2000   \n",
       "Kepler-90 e               780.00000           NaN               1.2000   \n",
       "Kepler-90 d               780.00000           NaN               1.2000   \n",
       "Kepler-90 c               780.00000           NaN               1.2000   \n",
       "Kepler-90 b               780.00000           NaN               1.2000   \n",
       "Kepler-90 i               780.00000           NaN               1.2000   \n",
       "TRAPPIST-1 b               12.56000      0.019000               0.0802   \n",
       "TRAPPIST-1 c               12.56000      0.014000               0.0802   \n",
       "TRAPPIST-1 d               12.56000      0.003000               0.0802   \n",
       "TRAPPIST-1 e               12.56000      0.007000               0.0802   \n",
       "TRAPPIST-1 f               12.56000      0.011000               0.0802   \n",
       "TRAPPIST-1 g               12.56000      0.003000               0.0802   \n",
       "TRAPPIST-1 h               12.56000      0.086000               0.0802   \n",
       "K2-138 b                  183.00000           NaN               0.9300   \n",
       "K2-138 c                  183.00000           NaN               0.9300   \n",
       "K2-138 d                  183.00000           NaN               0.9300   \n",
       "K2-138 e                  183.00000           NaN               0.9300   \n",
       "K2-138 f                  183.00000           NaN               0.9300   \n",
       "\n",
       "                  HostStarMetallicity  HostStarRadiusSlrRad  HostStarTempK  \\\n",
       "PlanetIdentifier                                                             \n",
       "Kepler-9 b               1.200000e-01                 1.020         5777.0   \n",
       "Kepler-9 c               1.200000e-01                 1.020         5777.0   \n",
       "Kepler-9 d               1.200000e-01                 1.020         5777.0   \n",
       "Mercury                  1.000000e-08                 1.000         5778.0   \n",
       "Venus                    1.000000e-08                 1.000         5778.0   \n",
       "Earth                    1.000000e-08                 1.000         5778.0   \n",
       "Mars                     1.000000e-08                 1.000         5778.0   \n",
       "Jupiter                  1.000000e-08                 1.000         5778.0   \n",
       "Saturn                   1.000000e-08                 1.000         5778.0   \n",
       "Uranus                   1.000000e-08                 1.000         5778.0   \n",
       "Neptune                  1.000000e-08                 1.000         5778.0   \n",
       "Pluto                    1.000000e-08                 1.000         5778.0   \n",
       "Kepler-11 b                       NaN                 1.053         5663.0   \n",
       "Kepler-11 c                       NaN                 1.053         5663.0   \n",
       "Kepler-11 d                       NaN                 1.053         5663.0   \n",
       "Kepler-11 e                       NaN                 1.053         5663.0   \n",
       "Kepler-11 f                       NaN                 1.053         5663.0   \n",
       "Kepler-11 g                       NaN                 1.053         5663.0   \n",
       "Kepler-55 d                       NaN                 0.619         4503.0   \n",
       "Kepler-55 b                       NaN                 0.619         4503.0   \n",
       "Kepler-55 c                       NaN                 0.619         4503.0   \n",
       "Kepler-55 e                       NaN                 0.619         4503.0   \n",
       "Kepler-55 f                       NaN                 0.619         4503.0   \n",
       "Kepler-80 b              4.000000e-02                 0.678         4540.0   \n",
       "Kepler-80 c              4.000000e-02                 0.678         4540.0   \n",
       "Kepler-80 d              4.000000e-02                 0.678         4540.0   \n",
       "Kepler-80 e              4.000000e-02                 0.678         4540.0   \n",
       "Kepler-80 f              4.000000e-02                 0.678         4540.0   \n",
       "Kepler-80 g              4.000000e-02                 0.678         4540.0   \n",
       "Kepler-90 h             -1.200000e-01                 1.200         6080.0   \n",
       "Kepler-90 g             -1.200000e-01                 1.200         6080.0   \n",
       "Kepler-90 f             -1.200000e-01                 1.200         6080.0   \n",
       "Kepler-90 e             -1.200000e-01                 1.200         6080.0   \n",
       "Kepler-90 d             -1.200000e-01                 1.200         6080.0   \n",
       "Kepler-90 c             -1.200000e-01                 1.200         6080.0   \n",
       "Kepler-90 b             -1.200000e-01                 1.200         6080.0   \n",
       "Kepler-90 i             -1.200000e-01                 1.200         6080.0   \n",
       "TRAPPIST-1 b             4.000000e-02                 0.121         2559.0   \n",
       "TRAPPIST-1 c             4.000000e-02                 0.121         2559.0   \n",
       "TRAPPIST-1 d             4.000000e-02                 0.121         2559.0   \n",
       "TRAPPIST-1 e             4.000000e-02                 0.121         2559.0   \n",
       "TRAPPIST-1 f             4.000000e-02                 0.121         2559.0   \n",
       "TRAPPIST-1 g             4.000000e-02                 0.121         2559.0   \n",
       "TRAPPIST-1 h             4.000000e-02                 0.121         2559.0   \n",
       "K2-138 b                 1.600000e-01                 0.860         5378.0   \n",
       "K2-138 c                 1.600000e-01                 0.860         5378.0   \n",
       "K2-138 d                 1.600000e-01                 0.860         5378.0   \n",
       "K2-138 e                 1.600000e-01                 0.860         5378.0   \n",
       "K2-138 f                 1.600000e-01                 0.860         5378.0   \n",
       "\n",
       "                    ListsPlanetIsOn      ...        RightAscension  \\\n",
       "PlanetIdentifier                         ...                         \n",
       "Kepler-9 b        Confirmed planets      ...              19 02 17   \n",
       "Kepler-9 c        Confirmed planets      ...              19 02 17   \n",
       "Kepler-9 d        Confirmed planets      ...              19 02 17   \n",
       "Mercury                Solar System      ...                   NaN   \n",
       "Venus                  Solar System      ...                   NaN   \n",
       "Earth                  Solar System      ...                   NaN   \n",
       "Mars                   Solar System      ...                   NaN   \n",
       "Jupiter                Solar System      ...                   NaN   \n",
       "Saturn                 Solar System      ...                   NaN   \n",
       "Uranus                 Solar System      ...                   NaN   \n",
       "Neptune                Solar System      ...                   NaN   \n",
       "Pluto                  Solar System      ...                   NaN   \n",
       "Kepler-11 b       Confirmed planets      ...              19 48 27   \n",
       "Kepler-11 c       Confirmed planets      ...              19 48 27   \n",
       "Kepler-11 d       Confirmed planets      ...              19 48 27   \n",
       "Kepler-11 e       Confirmed planets      ...              19 48 27   \n",
       "Kepler-11 f       Confirmed planets      ...              19 48 27   \n",
       "Kepler-11 g       Confirmed planets      ...              19 48 27   \n",
       "Kepler-55 d       Confirmed planets      ...              19 00 40   \n",
       "Kepler-55 b       Confirmed planets      ...              19 00 40   \n",
       "Kepler-55 c       Confirmed planets      ...              19 00 40   \n",
       "Kepler-55 e       Confirmed planets      ...              19 00 40   \n",
       "Kepler-55 f       Confirmed planets      ...              19 00 40   \n",
       "Kepler-80 b       Confirmed planets      ...          19 44 27.016   \n",
       "Kepler-80 c       Confirmed planets      ...          19 44 27.016   \n",
       "Kepler-80 d       Confirmed planets      ...          19 44 27.016   \n",
       "Kepler-80 e       Confirmed planets      ...          19 44 27.016   \n",
       "Kepler-80 f       Confirmed planets      ...          19 44 27.016   \n",
       "Kepler-80 g       Confirmed planets      ...          19 44 27.016   \n",
       "Kepler-90 h       Confirmed planets      ...          18 57 44.038   \n",
       "Kepler-90 g       Confirmed planets      ...          18 57 44.038   \n",
       "Kepler-90 f       Confirmed planets      ...          18 57 44.038   \n",
       "Kepler-90 e       Confirmed planets      ...          18 57 44.038   \n",
       "Kepler-90 d       Confirmed planets      ...          18 57 44.038   \n",
       "Kepler-90 c       Confirmed planets      ...          18 57 44.038   \n",
       "Kepler-90 b       Confirmed planets      ...          18 57 44.038   \n",
       "Kepler-90 i       Confirmed planets      ...          18 57 44.038   \n",
       "TRAPPIST-1 b      Confirmed planets      ...           23 06 30.34   \n",
       "TRAPPIST-1 c      Confirmed planets      ...           23 06 30.34   \n",
       "TRAPPIST-1 d      Confirmed planets      ...           23 06 30.34   \n",
       "TRAPPIST-1 e      Confirmed planets      ...           23 06 30.34   \n",
       "TRAPPIST-1 f      Confirmed planets      ...           23 06 30.34   \n",
       "TRAPPIST-1 g      Confirmed planets      ...           23 06 30.34   \n",
       "TRAPPIST-1 h      Confirmed planets      ...           23 06 30.34   \n",
       "K2-138 b          Confirmed planets      ...          23 15 47.769   \n",
       "K2-138 c          Confirmed planets      ...          23 15 47.769   \n",
       "K2-138 d          Confirmed planets      ...          23 15 47.769   \n",
       "K2-138 e          Confirmed planets      ...          23 15 47.769   \n",
       "K2-138 f          Confirmed planets      ...          23 15 47.769   \n",
       "\n",
       "                  SemiMajorAxisAU  SurfaceTempK TypeFlag    HostStar  \\\n",
       "PlanetIdentifier                                                       \n",
       "Kepler-9 b               0.143000         707.2        0    Kepler-9   \n",
       "Kepler-9 c               0.229000         557.9        0    Kepler-9   \n",
       "Kepler-9 d               0.027100        1601.5        0    Kepler-9   \n",
       "Mercury                  0.387098           NaN        0         sun   \n",
       "Venus                    0.723321           NaN        0         sun   \n",
       "Earth                    1.000000           NaN        0         sun   \n",
       "Mars                     1.523712           NaN        0         sun   \n",
       "Jupiter                  5.202480           NaN        0         sun   \n",
       "Saturn                   9.541499           NaN        0         sun   \n",
       "Uranus                  19.187979           NaN        0         sun   \n",
       "Neptune                 30.069528           NaN        0         sun   \n",
       "Pluto                   39.486860           NaN        0         sun   \n",
       "Kepler-11 b              0.091000         870.7        0   Kepler-11   \n",
       "Kepler-11 c              0.107000         806.8        0   Kepler-11   \n",
       "Kepler-11 d              0.155000         658.7        0   Kepler-11   \n",
       "Kepler-11 e              0.195000         596.4        0   Kepler-11   \n",
       "Kepler-11 f              0.250000         525.3        0   Kepler-11   \n",
       "Kepler-11 g              0.466000         386.4        0   Kepler-11   \n",
       "Kepler-55 d                   NaN           NaN        0   Kepler-55   \n",
       "Kepler-55 b                   NaN           NaN        0   Kepler-55   \n",
       "Kepler-55 c                   NaN           NaN        0   Kepler-55   \n",
       "Kepler-55 e                   NaN           NaN        0   Kepler-55   \n",
       "Kepler-55 f                   NaN           NaN        0   Kepler-55   \n",
       "Kepler-80 b              0.064800           NaN        0   Kepler-80   \n",
       "Kepler-80 c              0.079200           NaN        0   Kepler-80   \n",
       "Kepler-80 d              0.037200           NaN        0   Kepler-80   \n",
       "Kepler-80 e              0.049100           NaN        0   Kepler-80   \n",
       "Kepler-80 f              0.017500           NaN        0   Kepler-80   \n",
       "Kepler-80 g                   NaN           NaN        0   Kepler-80   \n",
       "Kepler-90 h              1.010000           NaN        0   Kepler-90   \n",
       "Kepler-90 g              0.710000           NaN        0   Kepler-90   \n",
       "Kepler-90 f              0.480000           NaN        0   Kepler-90   \n",
       "Kepler-90 e              0.420000           NaN        0   Kepler-90   \n",
       "Kepler-90 d              0.320000           NaN        0   Kepler-90   \n",
       "Kepler-90 c              0.089000           NaN        0   Kepler-90   \n",
       "Kepler-90 b              0.074000           NaN        0   Kepler-90   \n",
       "Kepler-90 i                   NaN           NaN        0   Kepler-90   \n",
       "TRAPPIST-1 b             0.011110         400.1        0  TRAPPIST-1   \n",
       "TRAPPIST-1 c             0.015220         341.9        0  TRAPPIST-1   \n",
       "TRAPPIST-1 d             0.021450         288.0        0  TRAPPIST-1   \n",
       "TRAPPIST-1 e             0.028180         251.3        0  TRAPPIST-1   \n",
       "TRAPPIST-1 f             0.037100         219.0        0  TRAPPIST-1   \n",
       "TRAPPIST-1 g             0.045100         198.6        0  TRAPPIST-1   \n",
       "TRAPPIST-1 h             0.059600         167.0        0  TRAPPIST-1   \n",
       "K2-138 b                 0.033800           NaN        0      K2-138   \n",
       "K2-138 c                 0.044540           NaN        0      K2-138   \n",
       "K2-138 d                 0.058830           NaN        0      K2-138   \n",
       "K2-138 e                 0.078070           NaN        0      K2-138   \n",
       "K2-138 f                 0.104300           NaN        0      K2-138   \n",
       "\n",
       "                  HostStarLuminosity  HostStarInnerHabitabilityAU  \\\n",
       "PlanetIdentifier                                                    \n",
       "Kepler-9 b              3.994170e+26                     0.974217   \n",
       "Kepler-9 c              3.994170e+26                     0.974217   \n",
       "Kepler-9 d              3.994170e+26                     0.974217   \n",
       "Mercury                 3.841730e+26                     0.955446   \n",
       "Venus                   3.841730e+26                     0.955446   \n",
       "Earth                   3.841730e+26                     0.955446   \n",
       "Mars                    3.841730e+26                     0.955446   \n",
       "Jupiter                 3.841730e+26                     0.955446   \n",
       "Saturn                  3.841730e+26                     0.955446   \n",
       "Uranus                  3.841730e+26                     0.955446   \n",
       "Neptune                 3.841730e+26                     0.955446   \n",
       "Pluto                   3.841730e+26                     0.955446   \n",
       "Kepler-11 b             3.930608e+26                     0.966435   \n",
       "Kepler-11 c             3.930608e+26                     0.966435   \n",
       "Kepler-11 d             3.930608e+26                     0.966435   \n",
       "Kepler-11 e             3.930608e+26                     0.966435   \n",
       "Kepler-11 f             3.930608e+26                     0.966435   \n",
       "Kepler-11 g             3.930608e+26                     0.966435   \n",
       "Kepler-55 d             5.430075e+25                     0.359208   \n",
       "Kepler-55 b             5.430075e+25                     0.359208   \n",
       "Kepler-55 c             5.430075e+25                     0.359208   \n",
       "Kepler-55 e             5.430075e+25                     0.359208   \n",
       "Kepler-55 f             5.430075e+25                     0.359208   \n",
       "Kepler-80 b             6.731309e+25                     0.399938   \n",
       "Kepler-80 c             6.731309e+25                     0.399938   \n",
       "Kepler-80 d             6.731309e+25                     0.399938   \n",
       "Kepler-80 e             6.731309e+25                     0.399938   \n",
       "Kepler-80 f             6.731309e+25                     0.399938   \n",
       "Kepler-80 g             6.731309e+25                     0.399938   \n",
       "Kepler-90 h             6.782558e+26                     1.269520   \n",
       "Kepler-90 g             6.782558e+26                     1.269520   \n",
       "Kepler-90 f             6.782558e+26                     1.269520   \n",
       "Kepler-90 e             6.782558e+26                     1.269520   \n",
       "Kepler-90 d             6.782558e+26                     1.269520   \n",
       "Kepler-90 c             6.782558e+26                     1.269520   \n",
       "Kepler-90 b             6.782558e+26                     1.269520   \n",
       "Kepler-90 i             6.782558e+26                     1.269520   \n",
       "TRAPPIST-1 b            2.164056e+23                     0.022677   \n",
       "TRAPPIST-1 c            2.164056e+23                     0.022677   \n",
       "TRAPPIST-1 d            2.164056e+23                     0.022677   \n",
       "TRAPPIST-1 e            2.164056e+23                     0.022677   \n",
       "TRAPPIST-1 f            2.164056e+23                     0.022677   \n",
       "TRAPPIST-1 g            2.164056e+23                     0.022677   \n",
       "TRAPPIST-1 h            2.164056e+23                     0.022677   \n",
       "K2-138 b                2.132538e+26                     0.711854   \n",
       "K2-138 c                2.132538e+26                     0.711854   \n",
       "K2-138 d                2.132538e+26                     0.711854   \n",
       "K2-138 e                2.132538e+26                     0.711854   \n",
       "K2-138 f                2.132538e+26                     0.711854   \n",
       "\n",
       "                 HostStarOuterHabitabilityAU  HostStarClass  HostStarColor  \n",
       "PlanetIdentifier                                                            \n",
       "Kepler-9 b                          1.403506              G        #fff4ea  \n",
       "Kepler-9 c                          1.403506              G        #fff4ea  \n",
       "Kepler-9 d                          1.403506              G        #fff4ea  \n",
       "Mercury                             1.376463              G        #fff4ea  \n",
       "Venus                               1.376463              G        #fff4ea  \n",
       "Earth                               1.376463              G        #fff4ea  \n",
       "Mars                                1.376463              G        #fff4ea  \n",
       "Jupiter                             1.376463              G        #fff4ea  \n",
       "Saturn                              1.376463              G        #fff4ea  \n",
       "Uranus                              1.376463              G        #fff4ea  \n",
       "Neptune                             1.376463              G        #fff4ea  \n",
       "Pluto                               1.376463              G        #fff4ea  \n",
       "Kepler-11 b                         1.392294              G        #fff4ea  \n",
       "Kepler-11 c                         1.392294              G        #fff4ea  \n",
       "Kepler-11 d                         1.392294              G        #fff4ea  \n",
       "Kepler-11 e                         1.392294              G        #fff4ea  \n",
       "Kepler-11 f                         1.392294              G        #fff4ea  \n",
       "Kepler-11 g                         1.392294              G        #fff4ea  \n",
       "Kepler-55 d                         0.517492              K        #ffd2a1  \n",
       "Kepler-55 b                         0.517492              K        #ffd2a1  \n",
       "Kepler-55 c                         0.517492              K        #ffd2a1  \n",
       "Kepler-55 e                         0.517492              K        #ffd2a1  \n",
       "Kepler-55 f                         0.517492              K        #ffd2a1  \n",
       "Kepler-80 b                         0.576170              K        #ffd2a1  \n",
       "Kepler-80 c                         0.576170              K        #ffd2a1  \n",
       "Kepler-80 d                         0.576170              K        #ffd2a1  \n",
       "Kepler-80 e                         0.576170              K        #ffd2a1  \n",
       "Kepler-80 f                         0.576170              K        #ffd2a1  \n",
       "Kepler-80 g                         0.576170              K        #ffd2a1  \n",
       "Kepler-90 h                         1.828933              F        #f8f7ff  \n",
       "Kepler-90 g                         1.828933              F        #f8f7ff  \n",
       "Kepler-90 f                         1.828933              F        #f8f7ff  \n",
       "Kepler-90 e                         1.828933              F        #f8f7ff  \n",
       "Kepler-90 d                         1.828933              F        #f8f7ff  \n",
       "Kepler-90 c                         1.828933              F        #f8f7ff  \n",
       "Kepler-90 b                         1.828933              F        #f8f7ff  \n",
       "Kepler-90 i                         1.828933              F        #f8f7ff  \n",
       "TRAPPIST-1 b                        0.032669              M        #ffcc6f  \n",
       "TRAPPIST-1 c                        0.032669              M        #ffcc6f  \n",
       "TRAPPIST-1 d                        0.032669              M        #ffcc6f  \n",
       "TRAPPIST-1 e                        0.032669              M        #ffcc6f  \n",
       "TRAPPIST-1 f                        0.032669              M        #ffcc6f  \n",
       "TRAPPIST-1 g                        0.032669              M        #ffcc6f  \n",
       "TRAPPIST-1 h                        0.032669              M        #ffcc6f  \n",
       "K2-138 b                            1.025533              G        #fff4ea  \n",
       "K2-138 c                            1.025533              G        #fff4ea  \n",
       "K2-138 d                            1.025533              G        #fff4ea  \n",
       "K2-138 e                            1.025533              G        #fff4ea  \n",
       "K2-138 f                            1.025533              G        #fff4ea  \n",
       "\n",
       "[49 rows x 23 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "the_allstars = df[df.HostStar.isin(stars)]\n",
    "the_allstars"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'builtin_function_or_method' object has no attribute 'tolist'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-13-ef4c4c19105f>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      3\u001b[0m     \u001b[0mrunning_string\u001b[0m \u001b[0;34m+=\u001b[0m \u001b[0;34m'star'\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m     \u001b[0msystem\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mthe_allstars\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mthe_allstars\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'HostStar'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0mstar\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mT\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_json\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreplace\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m' '\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'_'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 5\u001b[0;31m     \u001b[0mplanet_list\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msystem\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtolist\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      6\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      7\u001b[0m     \u001b[0mrunning_string\u001b[0m \u001b[0;34m+=\u001b[0m \u001b[0msystem\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mT\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_json\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreplace\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m' '\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'_'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mAttributeError\u001b[0m: 'builtin_function_or_method' object has no attribute 'tolist'"
     ]
    }
   ],
   "source": [
    "running_string = 'const systems = ['\n",
    "for star in stars:\n",
    "    running_string += 'star'\n",
    "    system = the_allstars[the_allstars['HostStar'] == star].T.to_json().replace(' ','_')\n",
    "    planet_list = system.index.tolist()\n",
    "    \n",
    "    running_string += system.T.to_json().replace(' ','_')\n",
    "    running_string += ','\n",
    "running_string += ']'\n",
    "with open('test.js',mode='w') as openfile:\n",
    "    openfile.write(running_string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "stars = grouped_df.head(7).index.tolist()\n",
    "extras = ['sun', 'Kepler-9']\n",
    "for extra in extras:\n",
    "    stars.append(extra) \n",
    "\n",
    "writable_stars = []\n",
    "for star in stars:\n",
    "    writable_stars.append(star.replace(' ', '_'))\n",
    "\n",
    "running_string = 'const test = {list:' + json.dumps(writable_stars) + ','\n",
    "for star in stars:\n",
    "    system = the_allstars[the_allstars['HostStar'] == star]\n",
    "    planet_list = system.index.tolist()\n",
    "    writable_planets = []\n",
    "    for planet in planet_list:\n",
    "        writable_planets.append(planet.replace(' ', '_'))\n",
    "    running_string += '\"' + star.replace(' ','_') + '\"' + ':{list:'+json.dumps(writable_planets) + ','\n",
    "    running_string += system.T.to_json().replace(' ','_')[1:]\n",
    "    running_string += ','\n",
    "running_string += '}'\n",
    "with open('test.js',mode='w') as openfile:\n",
    "    openfile.write(running_string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "for index, star in enumerate(stars):\n",
    "    stars[index] = star.replace(' ', '_')\n",
    "json.dumps(stars)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "''' js test script\n",
    "test.list.forEach(star => {\n",
    "    console.log(star)\n",
    "    test[star].list.forEach(planet => {\n",
    "        console.log(planet)\n",
    "    })\n",
    "})\n",
    "'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc['Neptune']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "mass_vs_radius_df = df[['RadiusJpt','PlanetaryMassJpt', 'HostStar']].dropna()\n",
    "mass_vs_radius_df = mass_vs_radius_df[mass_vs_radius_df['RadiusJpt'] < 5]\n",
    "mass_vs_radius_df = mass_vs_radius_df[mass_vs_radius_df['PlanetaryMassJpt'] < 10]\n",
    "\n",
    "mass_vs_radius_df.index.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "system_in_question = \"Kepler-9\"\n",
    "mass_vs_radius_df_2 = mass_vs_radius_df[mass_vs_radius_df['HostStar'] == system_in_question]\n",
    "mass_vs_radius_df_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "trace01 = {\n",
    "    'y': mass_vs_radius_df['RadiusJpt'].tolist(),\n",
    "    'x': mass_vs_radius_df['PlanetaryMassJpt'].tolist(),\n",
    "    'mode': 'markers',\n",
    "    'marker': {\n",
    "        'size': [r**.5*10 for r in mass_vs_radius_df['RadiusJpt'].tolist()],\n",
    "    },\n",
    "    'text': mass_vs_radius_df.index.tolist()\n",
    "}\n",
    "\n",
    "trace02 = {\n",
    "    'name': 'Exoplanets',\n",
    "    'y': mass_vs_radius_df_2['RadiusJpt'].tolist(),\n",
    "    'x': mass_vs_radius_df_2['PlanetaryMassJpt'].tolist(),\n",
    "    'mode': 'lines',\n",
    "    'marker': {\n",
    "        'size': [r**.5*10 for r in mass_vs_radius_df_2['RadiusJpt'].tolist()],\n",
    "        'color': 'red',\n",
    "        'opacity':.9\n",
    "        \n",
    "    },\n",
    "    'text': mass_vs_radius_df_2.index.tolist()\n",
    "}\n",
    "trace01"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "mass_vs_radius_df.plot(x='PlanetaryMassJpt', y='RadiusJpt', kind = 'scatter', s=[r*10 for r in mass_vs_radius_df['RadiusJpt'].tolist()])\n",
    "\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "host_star_df[host_star_df['HabitablePlanets']>0][host_star_df['DistFromSunLY']<100].sort_values(['HabitablePlanets','DistFromSunLY'], ascending=[False, True])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "columns = grouped_df.columns.tolist()\n",
    "for column in columns:\n",
    "    print(column, ' - ', grouped_df[column].sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#host_star_columns = ['HostStarClass','HostStarRadiusSlrRad','HostStarTempK','DistFromSunParsec','HostStarInnerHabitabilityAU','HostStarOuterHabitabilityAU','HostStarColor','HostStarMetallicity','HostStarLuminosity','HostStarMassSlrMass','RightAscension','Declination']\n",
    "#host_star_df = df.groupby('HostStar')[host_star_columns].max().dropna(how='all')\n",
    "#host_star_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "planet_list = []\n",
    "for star in host_star_df.index.tolist():\n",
    "    print(df[df[\"HostStar\"] == star].index.tolist())\n",
    "    planet_list.append(df[df[\"HostStar\"] == star].index.tolist())\n",
    "host_star_df['HostStarPlanetList'] = planet_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "habitable_list = []\n",
    "habitable_nums = []\n",
    "planet_nums = []\n",
    "for star in host_star_df.index.tolist():\n",
    "    habitables = 0\n",
    "    planets = 0\n",
    "    habitable_sub_list = []\n",
    "    starStats = host_star_df.loc[star]\n",
    "    inner = starStats['HostStarInnerHabitabilityAU']\n",
    "    outer = starStats['HostStarOuterHabitabilityAU']\n",
    "    #if inner > 0:\n",
    "    for planet in starStats['HostStarPlanetList']:\n",
    "        planetStats = df.loc[planet]\n",
    "        planets += 1\n",
    "        if planetStats['SemiMajorAxisAU']>(inner*.7) and planetStats['SemiMajorAxisAU']<(outer*1.3):\n",
    "            print(planet)\n",
    "            habitable_sub_list.append(planet)\n",
    "            habitables += 1\n",
    "    habitable_list.append(habitable_sub_list)\n",
    "    habitable_nums.append(habitables)\n",
    "    planet_nums.append(planets)\n",
    "host_star_df['HabitablePlanets'] = habitable_nums\n",
    "host_star_df['HabitablePlanetsList'] = habitable_list\n",
    "host_star_df['Planets'] = planet_nums"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "host_star_df.corr(method= 'spearman', min_periods=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "'''lightyears = [3.26*d for d in host_star_df['DistFromSunParsec'].tolist()]\n",
    "host_star_df['DistFromSunLY'] = lightyears'''\n",
    "the_max = host_star_df['DistFromSunLY'].max()\n",
    "bins = []\n",
    "order = -1\n",
    "labels = []\n",
    "while 10**order < the_max:\n",
    "    order += 1\n",
    "    bins.append(10**(order))\n",
    "    labels.append('10^'+str(order))\n",
    "\n",
    "print(the_max, '-', bins)\n",
    "labels = labels[:-1]\n",
    "labels"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "distance_from_sun_df = host_star_df[['DistFromSunLY','HabitablePlanets']].dropna()\n",
    "bar_servable_1 = pd.value_counts(pd.cut(distance_from_sun_df['DistFromSunLY'], bins = bins))\n",
    "binned = pd.DataFrame(bar_servable_1,).sort_index()\n",
    "binned['Order of Distance in Light Years']=labels\n",
    "binned = binned.set_index('Order of Distance in Light Years')\n",
    "binned.plot(kind='bar')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "distance_from_sun_df['bin'] = pd.cut(distance_from_sun_df['DistFromSunLY'], bins = bins)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "bar_servable_2 = distance_from_sun_df.groupby('bin').sum()['HabitablePlanets']\n",
    "bar_servable_2.sort_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "bar_servable_1.sort_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "bar_trace_stars = {\n",
    "    'x': labels,\n",
    "    'y': bar_servable_1.sort_index().tolist(),\n",
    "    'name': 'Systems with Exoplanets',\n",
    "    'type': 'bar'  \n",
    "}\n",
    "bar_trace_hab = {\n",
    "    'x': labels,\n",
    "    'y': bar_servable_2.sort_index().tolist(),\n",
    "    'name': 'Potentially Habitable Planets',\n",
    "    'type': 'bar'  \n",
    "}\n",
    "bar_trace_stars"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "bar_trace_hab"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "location_df = host_star_df[['RightAscension','Declination','DistFromSunLY']].dropna()\n",
    "location_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Kepler-9 -1539.9039134475752 500.2603491155542 1368.5415246630942\n",
      "sun 0 0 0\n",
      "HD 10180 -68.25830277523994 52.92520452735363 92.80157703921971\n",
      "Kepler-90 -173.61122965974192 1448.00591950006 -2084.5084196005596\n",
      "Gliese 667 C 10.896255655714036 -17.532596898521373 9.522265664891716\n",
      "HD 219134 -16.034878818331286 6.7051134387771025 12.399801099313779\n",
      "tau Ceti -7.348373975649817 -8.966760485982912 2.7085466148903614\n",
      "HD 40307 -34.08155637669682 -21.03977322734041 13.862934868740846\n",
      "Gliese 581 -2.306532255654748 -1.3269252260781572 -20.078753716681728\n",
      "TRAPPIST-1 6.611653176571944 11.558431830781737 38.740674990977574\n"
     ]
    }
   ],
   "source": [
    "stars = [\"Kepler-9\", \"sun\", \"HD 10180\", \"Kepler-90\", \"Gliese 667 C\", \"HD 219134\", \"tau Ceti\", \"HD 40307\", \"Gliese 581\", \"TRAPPIST-1\"];\n",
    "for star in stars:\n",
    "    print(star, host_star_df.loc[star]['Coordinates'])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "host_star_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "host_star_temps = host_star_df[host_star_df['HostStarTempK']<20000]\n",
    "host_star_temps = host_star_temps[host_star_temps['HostStarMassSlrMass']<3.5]\n",
    "host_star_temps = host_star_temps[['HostStarTempK','HostStarMassSlrMass', 'HostStarRadiusSlrRad']].dropna()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "trace01 = {\n",
    "    'y': host_star_temps['HostStarTempK'].tolist(),\n",
    "    'x': host_star_temps['HostStarMassSlrMass'].tolist(),\n",
    "    'mode': 'markers',\n",
    "    'marker': {\n",
    "        'size': [p**.5*10 for p in host_star_df['Planets'].tolist()],\n",
    "    },\n",
    "    'text': host_star_temps.index.tolist()\n",
    "}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "json.dumps(host_star_temps.index.tolist())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "host_star_dist = host_star_df#[host_star_df['HostStarTempK']<20000]\n",
    "#host_star_dist = host_star_dist[host_star_dist['HostStarMassSlrMass']<3.5]\n",
    "host_star_dist = host_star_dist[['HostStarTempK','DistFromSunLY', 'HostStarRadiusSlrRad']].dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}