Team Catalyst was inspired to do challenge 3, because our studies and work have revolved around energy for the last couple of years, and we are understand how crucial it is for everyone to work together to transition to a low-carbon economy. We are three friends who have an irrational love for data and the power it has to solve many of the world's biggest challenges. While our profession is not particularly data science, we work with a large amount of data daily, and we wanted to pool our knowledge and skills to tackle challenge 3.

What it does

Our project does the following:

  1. Find current state and future projections on overall renewable trends for North American cities and corporations that report to CDP
  2. Model and forecast renewable energy percentage for given data for city or corporation

How I built it

We first filtered through the data and came up with ideas using Excel, then performed data visualization and scale up using Python.

Tools used:

  • Excel
  • Python
  • Pandas
  • Seaborn
  • Statsmodels.api
  • Google Geocoding API

Challenges I ran into

  • Missing data made us want to cry
  • Different rows and columns, and misalignment between question and responses also made us want to cry
  • Data exploration was hard at first in Python and large amount of data did not make data processing any easier, which made us want to cry

Accomplishments that I'm proud of

  • Being able to apply what we learned on real-life data
  • Collaborating during COVID-19 quarantine was challenging at times
  • Juggling the hackathon alongside full-time work and more
  • Presenting the hollistic view of the project concisely within 2 minutes and 5 slides

What I learned

  • Data science skills require constant practice and taking on challenges like this is a great opportunity for sharpening our skills
  • Yearly data availability is key in the CDP Questionnaires to be able to make meaningful comparisons
  • Constraints for responses is important to get consistent data between different organizations and cities
  • Existing tools are extremely powerful and should be the first thing we try before choosing fancier, newer ones

What's next for Challenge 3-Team Catalyst

We will continue to pursue challenges like this to increase our understanding of how the world as a whole is moving towards improving the environment and how we can do our part in this journey.

Built With

Share this project:

Updates