NASA
Near Earth
Object
Hazard Analysis

NASA Near Earth Object Hazard Analysis

Tags

Data cleaning
Pivot tables
Visualization
Interactive dashboard

Tools

Excel

Source

Get the raw data from Kaggle

Context

Near-Earth objects are asteroids and comets with orbits that bring them to within 120 million miles of the Sun, which means they can circulate through the Earth's orbital neighborhood. This analysis is about foreign object hazard probability.

Data Cleaning:

Since this dataset was pulled from Kaggle to much cleaning was not necessary. I trimmed few unnecessary data & added a few columns by using the existing data for analysis. I also calculated the respective Ranges of Absolute Magnitude provided.

Dashboard:

This is an interactive Visualization/Dashboard where you can see a report of potential hazardous asteroids, Sentry object count & also a comparison of both to see the amount of sentry objects that are prone to become hazardous.


Filtering is possible based on asteroid Orbit classes,