Visualizing Electricity Usage and Rates

Contributors: Elena Lomako, Andrew Cheng, Paul Samaniego, Riya Gajjar, Madeline Cruz

Table of Contents

1. Introduction
   1. Summary
   2. Objectives
2. Featured Files and Links
3. Technologies
4. Resources

Introduction

Summary

The US Energy Information Administration (EIA) hosts and collects information gathered across different energy sectors and jurisdictions to promote sound policymaking, efficient markets and public understanding of energy and its interactions with the economy and environment.

Using the Sales (consumption), revenue, prices & customers annual dataset, we aim to create a webpage containing interactive visualization elements to assist in the public understanding of electricity usage and price, and how these features change over time.

Objectives

The primary objective for this project is to use a versatile technology stack; incorporating SQL, Python, HTML, and Javascript to create a dashboard of interactive visualizations. These visualizations are meant to demonstrate how electricity usage differs across states over time.

Featured Files and Links

• Visualization Dashboard (WIP)
• SQL Schema
• HTML script
• JS Scripts

Technologies and API

Python
├── statsmodels 0.14.0
│   └── pandas 2.1.1
├── SQLAlchemy 1.4.39
└── Flask 2.2.2
Javascript
├── Leaflet 1.9.4
├── D3 7.8.5
├── Tabulator 5.5
└── Plotly 5.18.0
SQL

Resources

---

• EIA Dataset