About Me

I am an undergraduate computer science student, interested in Astronomy and Data Science. I always had a knack for Astronomy and Astrophysics, wasn't good in Physics but in Mathematics and found Data Science, and Analytics interesting. Data Science was one such field which overlaps with several fields hence I opted that as my career path.

Dataset Description

The dataset comprises of 48 attributes, with a total of 1.3 million records divided into two separate .csv files as numbered (asteroids with numerical designation) and unnumbered (asteroids without numerical designation).

Attributes	Attributes Meaning
spkid	Object Primary SPK-ID
name	Object IAU name
neo	Near Earth Object
pha	Potentially Hazardous Object
H	Absolute Magnitude
G	Magnitude Slope Parameter
diameter	Object Diameter(KM)
albedo	Geometric Albedo
rot_per	Rotation Period(h)
GM	Standard Gravitational Parameter
BV	Color Index B-V magnitude difference
UB	Color Index B-V magnitude difference
spec_B	Spectral Taxanomic type (SMASSII)
spec_T	Spectral Taxanomic type(Tholen)
H_sigma	1-Sigma uncertainty in absolute magnitude
diameter_sigma	1-Sigma uncertainty in object diameter(KM)
epoch	Epoch of oscillation in julian day form
epoch_cal	Epoch of oscillation in calendar date/time form
e	Eccentricity
a	Semi-major axis
q	Perihilion distance(AU)
i	Inclination
om	Longitude of ascending node(deg)
w	Argument of perihilion(deg)
ma	Mean Anomoly(deg)
ad	Aphelion distnace(AU)
n	Mean Motion(deg/d)
tp	Time of perihilion passage
per	Sidereal orbital period(days)
per_y	Sidereal orbital period(years
moid	Earth Minimum orbit intersection distance(AU)
moid_ld	Eart Minimum orbit intersection distance(LD)
moid_jup	Jupiter Minimum orbital intersection distance
t_jupiter	Jupiter Tisserand Invariant
sigma_e	eccentricity(1-sigma uncertainty)
sigma_a	Semi-major axis(1-sigma uncertainty)
sigma_q	Perihelion Distance (1-sigma uncertainty)(AU)
sigma_i	Inclination (1-sigma uncertainty)(deg)
sigma_om	Longitude of the ascending node(1-sigma uncertainty)(deg)
sigma_w	Argument of perihelion(1-sigma uncertainty)(deg)
sigma_ma	Mean Anomoly (1-sigma uncertainty)(deg)
sigma_ad	Apehelion distance(1-sigma uncertainty)(AU)
sigma_n	Mean motion(1-sigma uncertainty)(deg/d)
sigma_tp	Time of perihelion passage(1-sigma uncertainty)(d)
sigma_per	Sidereal orbital period(1-sigma uncertainty)(d)
class	Orbital classification
data_arc	Time between the first and the last observation of Asteroid
rms	Normalized Root mean square of an orbit fit

Tables

Asteroid Dataset Number

@kaggle.chiragajain_asteroids_with_physical_and_orbital_features.asteroid_dataset_number

40.41 MB
720000 rows
48 columns


CREATE TABLE asteroid_dataset_number (
  "spkid" BIGINT,
  "name" VARCHAR,
  "neo" VARCHAR,
  "pha" VARCHAR,
  "h" DOUBLE,
  "g" DOUBLE,
  "diameter" DOUBLE,
  "albedo" DOUBLE,
  "rot_per" DOUBLE,
  "gm" DOUBLE,
  "bv" DOUBLE,
  "ub" DOUBLE,
  "spec_b" VARCHAR,
  "spec_t" VARCHAR,
  "h_sigma" DOUBLE,
  "diameter_sigma" DOUBLE,
  "epoch" DOUBLE,
  "epoch_cal" VARCHAR,
  "e" DOUBLE,
  "a" DOUBLE,
  "q" DOUBLE,
  "i" DOUBLE,
  "om" DOUBLE,
  "w" DOUBLE,
  "ma" DOUBLE,
  "ad" DOUBLE,
  "n" DOUBLE,
  "tp" DOUBLE,
  "per" DOUBLE,
  "per_y" DOUBLE,
  "moid" DOUBLE,
  "moid_ld" DOUBLE,
  "moid_jup" DOUBLE,
  "t_jup" DOUBLE,
  "sigma_e" DOUBLE,
  "sigma_a" DOUBLE,
  "sigma_q" 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,
  "class" VARCHAR,
  "data_arc" BIGINT,
  "rms" DOUBLE
);

Asteroid Dataset Unnumber

@kaggle.chiragajain_asteroids_with_physical_and_orbital_features.asteroid_dataset_unnumber

40.44 MB
670288 rows
48 columns


CREATE TABLE asteroid_dataset_unnumber (
  "spkid" BIGINT,
  "name" VARCHAR,
  "neo" VARCHAR,
  "pha" VARCHAR,
  "h" DOUBLE,
  "g" VARCHAR,
  "diameter" DOUBLE,
  "albedo" DOUBLE,
  "rot_per" DOUBLE,
  "gm" VARCHAR,
  "bv" VARCHAR,
  "ub" VARCHAR,
  "spec_b" VARCHAR,
  "spec_t" VARCHAR,
  "h_sigma" DOUBLE,
  "diameter_sigma" DOUBLE,
  "epoch" DOUBLE,
  "epoch_cal" VARCHAR,
  "e" DOUBLE,
  "a" DOUBLE,
  "q" DOUBLE,
  "i" DOUBLE,
  "om" DOUBLE,
  "w" DOUBLE,
  "ma" DOUBLE,
  "ad" DOUBLE,
  "n" DOUBLE,
  "tp" DOUBLE,
  "per" DOUBLE,
  "per_y" DOUBLE,
  "moid" DOUBLE,
  "moid_ld" DOUBLE,
  "moid_jup" DOUBLE,
  "t_jup" DOUBLE,
  "sigma_e" DOUBLE,
  "sigma_a" DOUBLE,
  "sigma_q" 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,
  "class" VARCHAR,
  "data_arc" DOUBLE,
  "rms" DOUBLE
);