Mars Asteroid Observation

Predict the days required for asteroid observation passing by Mars.

@kaggle.sanskar457_observation_days_dataset

Table List

1 table(3.6 MB)

Final Observation Days

@kaggle.sanskar457_observation_days_dataset.final_observation_days

3.6 MB
18000 rows
26 columns

id ID	full_name Full Name	sigma_e Sigma E	sigma_a Sigma A	sigma_i Sigma I	sigma_om Sigma Om	sigma_w Sigma W	sigma_ma Sigma Ma	sigma_ad Sigma Ad	sigma_n Sigma N	sigma_tp Sigma Tp	sigma_per Sigma Per	a A	e E	i I	om Om	w W	ad Ad	q Q	per_y Per Y	n_obs_used N Obs Used	ma Ma	condition_code Condition Code	h H	epoch_mjd Epoch Mjd	data_arc Data Arc
11674	(2013 OV4)	5.7563e-8	1.6053e-8	0.000010259	0.000029534	0.000035075	0.000016541	2.2542e-8	2.0545e-9	0.000068583	0.000014348	2.66109640267416	0.404226485887497	12.657240836609	324.191505322047	323.057653976762	3.736782050135	1.58541075521333	4.34109324170838	117	129.101981106434		17.59	60200	8139
10222	(2011 QH117)	0.0000039589	4.4753e-7	0.000020718	0.0002165	0.0022087	0.0016414	5.622e-7	9.1653e-8	0.0055514	0.00036409	2.20489438105969	0.256237637720195	2.76992068081515	356.125106829477	322.595505211762	2.76987130868495	1.63991745343442	3.2740845340409	18	255.757257722363	2	19.9	60200	3722
15475	(2016 AQ193)	0.75102	1.28	15.77	4.6322	13.312	90.643	1.5487	0.33098	108.3	993.85	2.0085087944742	0.209980244348082	34.3630722874244	95.4670690740529	292.517372740235	2.43025596191317	1.58676162703524	2.84654994841248	6	56.4857575920148	9	20.288	57391	1
11743	(2013 PB88)	1.5729e-7	1.9302e-7	0.000027339	0.000015851	0.00018561	0.00022798	2.6547e-7	2.6847e-8	0.00090516	0.00016967	2.57395485744091	0.375341337181327	28.2144229142433	158.584788901227	272.252761944084	3.54006651547716	1.60784319940467	4.12961525108569	34	109.396437085527	1	18.32	60200	3515
3226	380393 (2002 XL63)	5.8605e-8	1.5391e-8	0.0000068673	0.000062687	0.000064468	0.000013766	2.0748e-8	2.6219e-9	0.000053308	0.000012991	2.3734252833961	0.34808733320926	3.39202913501161	164.335304306459	233.395947485803	3.19958456086488	1.54726600592732	3.65655027428562	227	265.069228496057		17.92	60200	7507
9466	(2010 JN15)	0.00012336	0.00049967	0.002235	0.0018773	0.0080385	0.55302	0.00066751	0.00011134	1.6435	0.39971	2.13172226550378	0.33589432131431	9.56015119954021	244.074080732463	4.82934456635586	2.84775566910577	1.41568886190178	3.1124625479887	16	92.6524996954094	6	20.661	60200	37
19842	(2019 LB17)	1.1952e-7	3.6577e-8	0.0000096202	0.000037891	0.000070358	0.000024196	4.9558e-8	6.1233e-9	0.000092256	0.000030981	2.39004605124827	0.354895512930001	7.75446157204169	146.041722572813	137.46834035922	3.23826267053235	1.54182943196419	3.69502691117428	63	51.8817324649202		19.2	60200	4068
13883	(2015 AM282)	0.0000050315	1.2388e-7	0.000088162	0.000054679	0.0019188	0.0013158	1.3914e-7	4.0379e-8	0.0033228	0.000091841	1.83088876890879	0.123182371625753	18.1124887420747	316.65732986016	224.630782740978	2.05642198964593	1.60535554817165	2.47742857898922	35	123.418756061432	1	20.2	60200	1871
6323	623699 (2017 GT7)	5.9133e-8	1.6229e-8	0.0000060074	0.000022357	0.000049217	0.000042555	1.7913e-8	5.1819e-9	0.00010769	0.000012081	1.84604082742042	0.103728410577356	19.250929501333	250.108799548049	210.758935288628	2.03752770830964	1.65455394653119	2.50824615331697	141	271.782484818171		18.13	60200	3675
3258	382586 (2002 CC214)	6.737e-7	2.2991e-8	0.000027669	0.00010523	0.00013935	0.000055235	3.1584e-8	3.3968e-9	0.00022404	0.000019966	2.51253544581295	0.373763769337152	5.12779609494997	138.275429374175	307.851072317675	3.4516301646332	1.5734407269927	3.98268995073605	142	178.681803437121		18.37	60200	7330


CREATE TABLE final_observation_days (
  "id" BIGINT,
  "full_name" VARCHAR,
  "sigma_e" DOUBLE,
  "sigma_a" DOUBLE,
  "sigma_i" DOUBLE,
  "sigma_om" DOUBLE,
  "sigma_w" DOUBLE,
  "sigma_ma" DOUBLE,
  "sigma_ad" DOUBLE,
  "sigma_n" DOUBLE,
  "sigma_tp" DOUBLE,
  "sigma_per" DOUBLE,
  "a" DOUBLE,
  "e" DOUBLE,
  "i" DOUBLE,
  "om" DOUBLE,
  "w" DOUBLE,
  "ad" DOUBLE,
  "q" DOUBLE,
  "per_y" DOUBLE,
  "n_obs_used" BIGINT,
  "ma" DOUBLE,
  "condition_code" DOUBLE,
  "h" DOUBLE,
  "epoch_mjd" BIGINT,
  "data_arc" DOUBLE
);