Get Daily Data in Long Format

Aggregates and reshapes the data by day, returning it in a long format.

Usage

get_daily_data_long(power_data, year_to_plot = 2024)

Arguments

power_data

data frame with timestamp, INPUT, and OUTPUT columns.

year_to_plot

year for which to filter the dataframe.

Value

A data frame with daily total_input and total_output values.

Examples

# Example using a small sample data frame
power_data <- data.frame(
  timestamp = c(
    as.POSIXct("2000-01-01 01:00:00", tz = "UTC"),
    as.POSIXct("2000-01-02 01:00:00", tz = "UTC"),
    as.POSIXct("2000-02-01 02:00:00", tz = "UTC"),
    as.POSIXct("2000-02-02 02:00:00", tz = "UTC")
  ),
  INPUT = c(1.0, 2.0, 3.0, 4.0),
  OUTPUT = c(4.0, 3.0, 2.0, 1.0)
)
get_daily_data_long(power_data)
#> # A tibble: 740 × 3
#>    day        type         value
#>    <date>     <chr>        <dbl>
#>  1 2024-01-01 total_input     NA
#>  2 2024-01-01 total_output    NA
#>  3 2024-01-02 total_input     NA
#>  4 2024-01-02 total_output    NA
#>  5 2024-01-03 total_input     NA
#>  6 2024-01-03 total_output    NA
#>  7 2024-01-04 total_input     NA
#>  8 2024-01-04 total_output    NA
#>  9 2024-01-05 total_input     NA
#> 10 2024-01-05 total_output    NA
#> # ℹ 730 more rows