r - 使用 NA 的时间序列填充 [英] r - time series padding with NA

问题描述

说，如果我有一个如下的数据框:

Say, if I have a data frame as follows:

Date1 <- seq(from = as.POSIXct("2010-05-01 02:00"), 
             to = as.POSIXct("2010-10-10 22:00"), by = 3600)
Dat <- data.frame(DateTime = Date1,
                  x1 = rnorm(length(Date1)))

每次测量之间的间隔为 1 小时.怎么可能在这一年的剩余时间里用 NA 填充这个数据框，最终解决方案的长度应该是 8760，即全年的每小时测量值.例如，我想让 DateTime 列的范围从 2010-01-01 00:00 到 2010-12-31 23:00，但是对于已添加到原始日期的日期，x1 列是 NA数据框(如果有意义的话).我想提出一个可以有任意年数的解决方案，即如果数据从 2009 年 5 月延伸到 2012 年 9 月，那么最终解决方案应该有这个数据集，但缺少时间，即从 2009 年 1 月到 2012 年 12 月到用 NA 填充.我该如何解决这个问题?

where the spacing between each measurement is 1 hour. How would it be possible to pad this data frame with NAs for the rest of the year, where the final solution should have a length of 8760 i.e. hourly measurements for the entire year. I would like to have the DateTime column to extent from 2010-01-01 00:00 to 2010-12-31 23:00, for example, but have the x1 column to be NA for the days that have been added to the original data frame (if that makes sense). I would like to come up with a solution where there can be any number of years i.e. if the data extends from May 2009 to September 2012 then the final solution should have this data set but with the missing times i.e. from January 2009 to December 2012 to be padded with NA's. How can I go about solving this issue?

推荐答案

创建包含所有小时的新数据框，然后合并两个数据框.

Create new data frame that contains all hours and then merge both data frames.

df2<-data.frame(DateTime=seq(from = as.POSIXct("2010-01-01 00:00"), 
                             to = as.POSIXct("2010-12-31 23:00"), by = "hour"))
merge(df2,Dat,all=TRUE)

这篇关于r - 使用 NA 的时间序列填充的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！