nadireag/Green-Energy

UNC Data Bootcamp - Project 2

Renewable Energy vs Consumption in US by State

Data Sources

• https://data.world/doe/united-states-renewable-energy

• https://www.eia.gov/state/rankings/

• https://en.wikipedia.org/wiki/List_of_states_and_territories_of_the_United_States_by_population#cite_note-5

• https://www.kaggle.com/washimahmed/usa-latlong-for-state-abbreviations

• https://leafletjs.com/examples/choropleth/us-states.js

• Our ETL project link for data cleaning part https://github.com/nadireag/ETL-Project

Description:

Renewable energy is energy that comes from natural resources such as sunlight, wind, rain, tides, plants, waves and geothermal heat. These energy resources are renewable, meaning they are naturally replenished.

The major types of renewable energy sources: Biomass, Hydropower, Geothermal, Wind and Solar.

Questions:

• Which states are using the most renewable energy?

• Total energy consumption vs. renewable energy potential by State: Can a State’s potential meet their consumption?

• Types of renewable energy by highest potential: Which types account for the most potential? By State?

Analysis

• Clean and modify the data using Pandas and Jupyter Notebook.

• Use Heroku and PostgreSQL as the database.

• Use Python as the server side language, Flask as the web server and SQLAlchemy as the ORM.

• Use HTML, CSS and JavaScript on the front end.

• Use D3, Plotly, Chart.js and Leaflet to visualize the data.

Development Team

• Nadire Gokcehan - @nadireag
• Reid Powell - @ReidP31
• Jacob Abdelkhaleq - @jacobabdel