Hi,
I have a data frame where each row is different date an every column is different time series.
The date range in the tabke is 01.01.2019-01.01.2021.
Some of the time series are relevat for only part of the dates and have missing values in weekend and holidays.
How can I complete the missing values for each time series using previous day values only for the relevat dates of each column (time series - if the time series is from 01.03.2019 to 01.09.2019 I want to complete only the missing values in this dates range).
I have tried to use fill function:
data <- data %>%
fill(colnames(data))
but it completes also the missing data after the specific time series is over.
Thank you!