USelectricity

Forecast the US demand for electricity.
https://github.com/RamiKrispin/USelectricity

Last synced: over 1 year ago
JSON representation

Acceptance Criteria

• Revelant topics? false
• External users? false
• Open source license? false
• Active? false
• Fork? false

👍 0

👎 0

Repository metadata

Forecast the US demand for electricity

• Host: GitHub
• URL: https://github.com/RamiKrispin/USelectricity
• Owner: RamiKrispin
• Created: 2021-01-14T13:03:45.000Z (over 4 years ago)
• Default Branch: main
• Last Pushed: 2022-02-11T22:10:49.000Z (about 3 years ago)
• Last Synced: 2024-01-22T18:35:59.760Z (over 1 year ago)
• Language: R
• Homepage: https://ramikrispin.github.io/USelectricity/
• Size: 3.29 GB
• Stars: 96
• Watchers: 18
• Forks: 13
• Open Issues: 1
• Releases: 0
• Metadata Files:
  • Readme: README.Rmd

README.Rmd

          ---
output: github_document
---



```{r, include = FALSE}
knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>"
)

`%>%` <- magrittr::`%>%`
```

# USelectricity




WIP...

The [US Electricity Dashboard](https://ramikrispin.github.io/USelectricity/) provides real-time tracking and forecasting for US (lower 48 states) hourly electricity demand. This project's primary goal is to demonstrate a data science project's deployment into production using open source and free tools such as R, h2o, Github Actions, Docker, and others. That includes the following components:

* Data - pulling the US hourly demand and generation of electricity data from the Energy Information Administration (EIA) API with the use of R and jq
* Forecast - generating 72 hours forecast for the total demand with the use of Generalized Linear Model (GLM) using the h2o package
* Dashboard - communicating the demand data and forecast with the use of the flexdashboard package
* Automation - the data on the dashboard is getting refresh every hour, and the forecast generated every 72 hours with the use of Github Actions and Docker


### Data

The dashboard provides an overview for the overall hourly demand and generation of electricity in the US (lower 48). 


Demand 
https://www.eia.gov/opendata/qb.php?category=3389935&sdid=EBA.US48-ALL.D.H
Net generation
https://www.eia.gov/opendata/qb.php?category=3390020&sdid=EBA.US48-ALL.NG.H

```{r include=FALSE}
load("./data/elec_df.rda")
df <- elec_df %>% 
  dplyr::filter(date_time >= lubridate::ymd_hms("2021-01-01 00:00:00", tz = "US/Eastern" ) & 
                  date_time < lubridate::ymd_hms("2021-02-01 00:00:00", tz = "US/Eastern" )) %>%
  tidyr::pivot_wider(names_from = type, values_from = series)

df$date_time_us <- lubridate::with_tz(time = df$date_time, tzone = "US/Eastern")

p <- plotly::plot_ly(data = df) %>%
  plotly::add_lines(x = ~ date_time_us,
                y = ~ demand,
                name = "Demand",
                line = list(color = "#1f77b4")) %>%
  plotly::add_lines(x = ~ date_time_us,
                y = ~ generation,
                name = "Generation",
                line = list(color = "#2ca02c")) %>%
    plotly::layout(title = "The US (Lower 48) Demand and Generation of Electricity",
                 yaxis = list(title = "Megawatt-Hour"),
                 xaxis = list(title = "Eastern Time
 Source: US Energy Information Administration"),
                 hovermode = "compare") 

plotly::orca(p, "./figures/elec_df.svg")
  
```


        

---

Owner metadata

• Name: Rami Krispin
• Login: RamiKrispin
• Email:
• Kind: user
• Description: Data science and engineering manager at  | Author, open-source contributor 🌈 | Time-series analysis, and forecasting ❤️ | Opinions are my own 😎
• Website: https://ramikrispin.github.io/
• Location: Cupertino, California, US
• Twitter: Rami_Krispin
• Company:
• Icon url: https://avatars.githubusercontent.com/u/12760966?u=654c914d9df714991b890ea38ac4fce0e55c0d8f&v=4
• Repositories: 26
• Last ynced at: 2023-03-02T08:40:24.602Z
• Profile URL: https://github.com/RamiKrispin

---

Committers metadata

Last synced: over 1 year ago

Name	Email	Commits
RamiKrispin	r****p@u****u	7306
RamiKrispin	r****p@u****u	5

Committer domains:

• umich.ecu: 1
• umich.edu: 1

---

Issue and Pull Request metadata

Last synced: over 1 year ago

More stats: https://issues.ecosyste.ms/repositories/lookup?url=https://github.com/RamiKrispin/USelectricity

---

---

---

Dependencies

Score: 5.267858159063328