StellarDASH | Devpost

Inspiration

We were inspired by the prompt to create a data visualization dashboard that would take in the provided .csv files and display the data to the user and uncover unseen patterns in the drill runs for asteroids and potentially find better methods of optimizing drilling overall.

What it does

StellarDASH reads the .csv files and converts the bland and repetitive data into actual interactive graphs and tables that accurately display the correlations between the numerous subcategories of the drill runs on the asteroids such as rate of penetration and the max depth and the cost.

How we built it

We built the app using the FERN stack, Express, React and Node.js. Along with that we used Docker as a form of Kubernetes. For data analysis we used Python and the Python's data analysis library pandas and matplotlib. With Javascript, we created the web app using Typescript too.

Challenges we ran into

Several challenges we ran into was calculating certain data points and deriving it from other given data, and finding general methods to calculate such data without any errors from bad data in the .csv files including null cells, negative values and typos within the .csv as well.

Accomplishments that we're proud of

We utilized Python to "clean' the given data to sort and re order the drill run data to make it easier to analyze overall and graphically represent as well as removed extraneous and false data in the process. The graphs also clearly delineate patterns within the drill runs which we used to help overall optimize drill runs on asteroids in the future.

What we learned

In this project, we learned especially a lot about Python's data analysis library of pandas and how coders can stack simple but effective functions within the library to create a clean, sorted set of data ready to be analyzed.

What's next for StellarDASH

Next for StellarDASH, we would like to see if our program can be expanded and applied not only to asteroids but also to the terrain and underground aspects of drilling here on Earth. We would also like to add a real time optimization function to our project where it would inform the user when it would be efficient and cost effective to swap out a drill bit for another.