Our team wanted to return the power of sustainable living to the hands of the consumers, beginning with helping clients be well-informed about the sustainability of their spending habits.

What it does

Green Wallet uses transaction data from the Capital One API to generate a Spending Sustainability Report, similar to a credit score. The Report ranges from 0 to 1000, with 0 being the most sustainable and 1000 being the least sustainable. The score on your Report is calculated by pulling data about the transaction (price, merchant, purchase category and description) and the corresponding data about the merchant (sustainability rating), sending the data to the python script, and returning the Report score to be sent to the website.

How we built it

  • Determined workflow
  • Delegated tasks between teammates
    • Create database of vendors/merchants and respective sustainability indices
    • Build website
    • Make a sample set of transactions with Capital One API
    • Write script for calculating Spending Sustainability Report
      • Also make an equation for calculating the score for each purchase
    • Combined finished pieces

Front End

  • MongoDB database of vendors/activities and their sustainability index (represented in a coefficent between 0 and 5, with 0 having the least environmental impact and 5 having the greatest)
  • Capital One API stores transaction data, containing the merchant, cost, timestamp, and description of transaction
  • Website delivers data and score to the user

Back End

  • Google Cloud houses scripts and functions
  • Python script calculates Spending Sustainability report based on data from MongoDB and Capital One API
  • Score sent back to user through HTTPS requests

Challenges we ran into

  • Categorizing each vendor and assigning a sustainability index
  • Learning how to set up MongoDB
  • Pulling correct data from databases to the script

Accomplishments that we're proud of

  • Creating a working prototype
  • Optimizing our database use
  • Creating value for the consumer by informing them about the environmental impact of their purchases

What we learned

  • How to use MongoDB and Google Cloud
  • How to use the Capital One API to make transactions
  • Different methods of data manipulation and standardizing
Share this project: