WATTS UP

CAPP 30122 Group Project

Team Members

Frank Vasquez, Jacob Trout, Praveen Devarajan, Xiaoyue Wei

Project Summary

This project aggregates and analyzes data to builds interactive visualizations on electricity generation in the United States. It seeks explore the relationship between sources energy (renewable vs non-renewable), energy prices, and C02 emissions across states and across time.

To Launch the Application

1. Clone the repository.

git clone https://github.com/capp30122-watts-up/watts_up.git

2. Navigate to the repository.

cd ./watts_up

3. Download Poetry, which allows the user to run the application in a virtual environment, following these instructions. Then install poetry.

poetry install

4. Activate the virtual environment in poetry.

poetry shell

5. [OPTIONAL] Execute the ETL process. Pull data from API, combine multiple years of E-Grid data, clean, and create the database. Note that one of the API key is needed to execute this process. One can request an API key here. We recommend requesting API key from the EIA directly. This step is optional since the completed database is already present in the application. This step takes approximately 1 minute to run.

Once the API key is acquired, set the variable in your terminal with the following code:

export API_KEY="Your_API_KEY_Here"

After the key is set, run the data processing.

python3 -m watts_up getdata

6. Launch the Application.

python3 -m watts_up dashboard

The IDE will provide a local URL. Either control+click the link or paste it into your browser to view the interactive dashboard.

For further information on the project:

Click here for a summary of the project

Acknowledgments

Professor: James Turk

Teaching Assistant: Reza Rizky Pratama

Data Sources:

• Energy Information Agency
• Environmental Protection Agency
• US Census