Ok I finally found it. On the x axis I wanted to plot dates either as POSIXct or as number of day of recording (integer). On the y axis I wanted the time of day so that the graph would present a dark bar on each day (x-axis) and between the time (y-axis) that the … Read more
If I understand correctly, the trick is that you want to fill downward except for the bottommost NAs. And the problem with tidyr‘s fill is that it goes all the way down. This isn’t a fully-tidyverse solution, but for this data: library(dplyr) library(tidyr) data <- tribble( ~Date, ~time_series_1, ~time_series_2, as.Date(“2019-01-01”), NA, 10, as.Date(“2019-02-01”), 5, NA, … Read more
# Filter dat.filtered <- subset(dat, f2 > 0) # Convert to time-series library(xts); xts.sample <- xts(dat.filtered$f2, order.by = as.Date(dat.filtered$f1, “%d/%m/%Y”)) Sample data dat <- read.table(text = ” f1 f2 1 11/1/16 0 2 12/1/16 0 3 11/2/16 56.25 4 12/2/16 0 5 11/3/16 56.25 6 12/3/16 0 7 11/4/16 111 8 12/4/16 0 9 11/5/16 … Read more
The Systems Identification Toolbox may have what you need. If you need or want to do it by hand, however (homework?), I would suggest outlining the steps of what needs to be done (break up the problem in parts, starting from the definition of MA models) and asking a more detailed question when you get … Read more