NASA Exoplanet Dataset

Build an algorithm to find planets out of the solar system

@kaggle.arashnic_exoplanets

Table List

1 table(1.34 MB)

Exoplanets

@kaggle.arashnic_exoplanets.exoplanets

1.34 MB
9564 rows
49 columns

kepid Kepid	kepoi_name Kepoi Name	kepler_name Kepler Name	koi_disposition Koi Disposition	koi_pdisposition Koi Pdisposition	koi_score Koi Score	koi_fpflag_ss Koi Fpflag Ss	koi_fpflag_co Koi Fpflag Co	koi_period Koi Period	koi_period_err1 Koi Period Err1	koi_period_err2 Koi Period Err2	koi_time0bk Koi Time0bk	koi_time0bk_err1 Koi Time0bk Err1	koi_time0bk_err2 Koi Time0bk Err2	koi_impact Koi Impact	koi_impact_err1 Koi Impact Err1	koi_impact_err2 Koi Impact Err2	koi_duration Koi Duration	koi_duration_err1 Koi Duration Err1	koi_duration_err2 Koi Duration Err2	koi_depth Koi Depth	koi_depth_err1 Koi Depth Err1	koi_depth_err2 Koi Depth Err2	koi_prad Koi Prad	koi_prad_err1 Koi Prad Err1	koi_prad_err2 Koi Prad Err2	koi_teq Koi Teq	koi_insol Koi Insol	koi_insol_err1 Koi Insol Err1	koi_insol_err2 Koi Insol Err2	koi_model_snr Koi Model Snr	koi_tce_plnt_num Koi Tce Plnt Num	koi_tce_delivname Koi Tce Delivname	koi_steff Koi Steff	koi_steff_err1 Koi Steff Err1	koi_steff_err2 Koi Steff Err2	koi_slogg Koi Slogg	koi_slogg_err1 Koi Slogg Err1	koi_slogg_err2 Koi Slogg Err2	koi_srad Koi Srad	koi_srad_err1 Koi Srad Err1	koi_srad_err2 Koi Srad Err2	ra Ra	dec Dec	koi_kepmag Koi Kepmag
10797460	K00752.01	Kepler-227 b	CONFIRMED	CANDIDATE	1			9.48803557	0.0000278	-0.0000278	170.53875	0.00216	-0.00216	0.146	0.318	-0.146	2.9575	0.0819	-0.0819	616	19.5	-19.5	2.26	0.26	-0.15	793	93.59	29.45	-16.65	35.8	1	q1_q17_dr25_tce	5455	81	-81	4.467	0.064	-0.096	0.927	0.105	-0.061	291.93423	48.141651	15.347
10797460	K00752.02	Kepler-227 c	CONFIRMED	CANDIDATE	0.969			54.4183827	0.000248	-0.000248	162.51384	0.00352	-0.00352	0.586	0.059	-0.443	4.507	0.116	-0.116	875	35.5	-35.5	2.83	0.32	-0.19	443	9.11	2.87	-1.62	25.8	2	q1_q17_dr25_tce	5455	81	-81	4.467	0.064	-0.096	0.927	0.105	-0.061	291.93423	48.141651	15.347
10811496	K00753.01	nan	CANDIDATE	CANDIDATE				19.89913995	0.0000149	-0.0000149	175.850252	0.000581	-0.000581	0.969	5.126	-0.077	1.7822	0.0341	-0.0341	10800	171	-171	14.6	3.92	-1.31	638	39.3	31.04	-10.49	76.3	1	q1_q17_dr25_tce	5853	158	-176	4.544	0.044	-0.176	0.868	0.233	-0.078	297.00482	48.134129	15.436
10848459	K00754.01	nan	FALSE POSITIVE	FALSE POSITIVE		1		1.736952453	2.63e-7	-2.63e-7	170.307565	0.000115	-0.000115	1.276	0.115	-0.092	2.40641	0.00537	-0.00537	8080	12.8	-12.8	33.46	8.5	-2.83	1395	891.96	668.95	-230.35	505.6	1	q1_q17_dr25_tce	5805	157	-174	4.564	0.053	-0.168	0.791	0.201	-0.067	285.53461	48.28521	15.597
10854555	K00755.01	Kepler-664 b	CONFIRMED	CANDIDATE	1			2.525591777	0.00000376	-0.00000376	171.59555	0.00113	-0.00113	0.701	0.235	-0.478	1.6545	0.042	-0.042	603	16.9	-16.9	2.75	0.88	-0.35	1406	926.16	874.33	-314.24	40.9	1	q1_q17_dr25_tce	6031	169	-211	4.438	0.07	-0.21	1.046	0.334	-0.133	288.75488	48.2262	15.509
10872983	K00756.01	Kepler-228 d	CONFIRMED	CANDIDATE	1			11.09432054	0.0000204	-0.0000204	171.20116	0.00141	-0.00141	0.538	0.03	-0.428	4.5945	0.061	-0.061	1520	24.2	-24.2	3.9	1.27	-0.42	835	114.81	112.85	-36.7	66.5	1	q1_q17_dr25_tce	6046	189	-232	4.486	0.054	-0.229	0.972	0.315	-0.105	296.28613	48.22467	15.714
10872983	K00756.02	Kepler-228 c	CONFIRMED	CANDIDATE	1			4.13443512	0.0000105	-0.0000105	172.97937	0.0019	-0.0019	0.762	0.139	-0.532	3.1402	0.0673	-0.0673	686	18.7	-18.7	2.77	0.9	-0.3	1160	427.65	420.33	-136.7	40.2	2	q1_q17_dr25_tce	6046	189	-232	4.486	0.054	-0.229	0.972	0.315	-0.105	296.28613	48.22467	15.714
10872983	K00756.03	Kepler-228 b	CONFIRMED	CANDIDATE	0.992			2.56658897	0.0000178	-0.0000178	179.55437	0.00461	-0.00461	0.755	0.212	-0.523	2.429	0.165	-0.165	227	16.8	-16.8	1.59	0.52	-0.17	1360	807.74	793.91	-258.2	15	3	q1_q17_dr25_tce	6046	189	-232	4.486	0.054	-0.229	0.972	0.315	-0.105	296.28613	48.22467	15.714
6721123	K00114.01	nan	FALSE POSITIVE	FALSE POSITIVE		1	1	7.36178958	0.0000213	-0.0000213	132.25053	0.00253	-0.00253	1.169	7.133	-0.044	5.022	0.136	-0.136	234	5.8	-5.8	39.21	6.45	-9.67	1342	767.22	349.28	-365.49	47.7	1	q1_q17_dr25_tce	6227	111	-124	3.986	0.182	-0.098	1.958	0.322	-0.483	298.86435	42.151569	12.66
10910878	K00757.01	Kepler-229 c	CONFIRMED	CANDIDATE	1			16.06864674	0.0000109	-0.0000109	173.621937	0.000517	-0.000517	0.052	0.262	-0.052	3.5347	0.0241	-0.0241	4910	33.3	-33.3	5.76	0.22	-0.49	600	30.75	4.46	-6.66	161.9	1	q1_q17_dr25_tce	5031	75	-83	4.485	0.083	-0.028	0.848	0.033	-0.072	286.99948	48.37579	15.841


CREATE TABLE exoplanets (
  "kepid" BIGINT,
  "kepoi_name" VARCHAR,
  "kepler_name" VARCHAR,
  "koi_disposition" VARCHAR,
  "koi_pdisposition" VARCHAR,
  "koi_score" DOUBLE,
  "koi_fpflag_nt" BIGINT,
  "koi_fpflag_ss" BIGINT,
  "koi_fpflag_co" BIGINT,
  "koi_fpflag_ec" BIGINT,
  "koi_period" DOUBLE,
  "koi_period_err1" DOUBLE,
  "koi_period_err2" DOUBLE,
  "koi_time0bk" DOUBLE,
  "koi_time0bk_err1" DOUBLE,
  "koi_time0bk_err2" DOUBLE,
  "koi_impact" DOUBLE,
  "koi_impact_err1" DOUBLE,
  "koi_impact_err2" DOUBLE,
  "koi_duration" DOUBLE,
  "koi_duration_err1" DOUBLE,
  "koi_duration_err2" DOUBLE,
  "koi_depth" DOUBLE,
  "koi_depth_err1" DOUBLE,
  "koi_depth_err2" DOUBLE,
  "koi_prad" DOUBLE,
  "koi_prad_err1" DOUBLE,
  "koi_prad_err2" DOUBLE,
  "koi_teq" DOUBLE,
  "koi_teq_err1" VARCHAR,
  "koi_teq_err2" VARCHAR,
  "koi_insol" DOUBLE,
  "koi_insol_err1" DOUBLE,
  "koi_insol_err2" DOUBLE,
  "koi_model_snr" DOUBLE,
  "koi_tce_plnt_num" DOUBLE,
  "koi_tce_delivname" VARCHAR,
  "koi_steff" DOUBLE,
  "koi_steff_err1" DOUBLE,
  "koi_steff_err2" DOUBLE,
  "koi_slogg" DOUBLE,
  "koi_slogg_err1" DOUBLE,
  "koi_slogg_err2" DOUBLE,
  "koi_srad" DOUBLE,
  "koi_srad_err1" DOUBLE,
  "koi_srad_err2" DOUBLE,
  "ra" DOUBLE,
  "dec" DOUBLE,
  "koi_kepmag" DOUBLE
);