Ledger Red

Website
Jupyter Notebooks

Inspiration

After understanding ConocoPhillip's initiative for sustainability and boldness to try new alternatives, we concluded that tracking CO2 and oil/oil equivalent production trends would provide insight in making decisions to better promote sustainability, such as reducing CO2 and oil production for alternative energy sources.

What it does

Our project reads data from .csv files and presents graphics on CO2 emissions and other sustainability-related data, and, as an experiment, calculates the bbl/oil equivalent for each production type, to see if it changes over time. The project furthermore has a map to display regions of O&G activity relevant to ConocoPhillips that we focused on.

How we built it

Our team experimented with jupyter notebook, Unity, JS, and HTML in order to build our project and came to the conclusion that a web app would work best and implemented content from Jupyter notebook into it.

Challenges we ran into

The scope of the project was initially too large for a 24-hour hackathon, given our skills. However, with some re-planning and pivoting, we managed to work out a much more reasonable project plan. We attempted adding GUI elements to our Jupyter notebook, but ran into inter-library conflicts with the GUI elements interacting with data types created by other Python libraries. We also explored using Unity as a front-end, rather than a webapp, due to our team member's interest in game design, but found that it created too much overhead for too little advantage. We also had difficulty finding accessible data, so we had to transcribe from old reports, which presented unexpected challenges in the form of typos! Luckily we checked the numbers and identified the typos.

Accomplishments that we're proud of

Despite this being our first hackathon, we're proud of the team's determination to push through and learn new skills in a short 24-hour period. Most of the tools used in this project were largely unknown to us initially, and by the end of this hackathon, we learned a few new things about web development and data analysis.

What we learned

Given that this was our team's first hackathon, we learned about the process of a hackathon and how important it is to prepare and plan for shortcomings. Additionally, much of our team's expertise usually lied outside of the realm of web development and within this short 24-hour period, we learned a lot of material about web development.