1 of 15

weTroid

We really did…

Aishwarya Adiki

Anusha Jain

Chris Vallone

Laasya Gudisa

2 of 15

Upon First Glance

Dissecting the Problem

Data Analysis type problem

Required the use of a language that has extensive support for data analysis and visualization

3 of 15

Solution

PANDAS!!!

The most common languages used are Python, Ruby, Perl
Our expertise: Python
Solved using the Pandas DataFramework Libraray

4 of 15

Solution…contd.

High Code Readability
Scalability
Easy Cross platform integration
Lambda calculus

Why Python is our hero

5 of 15

SOLUTION…contd

Besides, Python has Plotly….

Another reason why we chose python was because the language has a graphing library called Plotly for interactive graphical analysis ☺

6 of 15

Requirements:

Make sense of the data

Optimized solution for digging through a well

Cheapest
Fastest

7 of 15

Deliverables

Provide charts/graphs over the data to show drilling performance
UI Elements to change what you are comparing across multiple asteroids
Depth vs Cost Curves
Bin compare and rank drilling performance
Analyze Optimize and output a drilling plan
Fastest
Cheapest

8 of 15

Excel

Performed Data Analysis on Excel for one .csv file

Python

Compare

Scale

Backend Timeline

Performed Data Analysis using Python for one .csv file

Scaled the python code to analyze data for all asteroid.csv files at the same time

Cross checking the excel numbers against python numbers ensured accuracy

9 of 15

React

Didn’t work due to complex integration

Plotly

Graphs

Scale

Frontend Timeline

Used python library to plot on .csv file

Scaled the code to display traces (20 total) for all asteroid.csv files at the same time

Got one trace for asteroid 1.csv

10 of 15

CHEAPEST

ChallengDriller (always a constant $10,000)
BuzzDrillDrin
AstroBit
Apollo

As measured by the average rate of penetration for each bit

11 of 15

FASTEST

As measured by the average rate of penetration for each bit

ChallengDriller
AstroBit
BuzzDrillDrin
Apollo

12 of 15

Recommendation

1^st:ChallengDriller

2^nd:BuzzDrillDrin

13 of 15

Appollo costs a lot per hour of drilling, which considering the time it takes to drill on oil rigs is simply unsustainable

Astrobit is the second fastest but having a costperhour makes AstroBit so expensive that we can just go for the slower BuzzDrilllDrin

Second best option would be BuzzDrillDrin which is a little slow but cheap

CHALLENGDRIVER!!

ChallengDriver always costs only $10000 for each run and has the fastest penetration rate

14 of 15

Thank you!!

We really troid