eia_dashboard
USelectricity - Southern California Edison Sub Region 
WIP…
The US Electricity Dashboard 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 eia.
- 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 48 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 (SOCAL region).
```{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”)
```
