lag function row name with
Hi John, dplyr::lag expects a vector. The following should work dplyr::lag(temp[,1],2) HTH, Eric
On Mon, Mar 25, 2019 at 9:45 AM John <miaojpm at gmail.com> wrote:
Hi, I have a dataset whose row names corresponds to months. When I apply lag function (dplyr package) on this dataset, I get NAs with warning messages. Is there any lag function that carries out the lag but keep the row names? I will have two datasets. The dates of the datasets are not exactly the same, and I want to find out the correlation for the overlapping period. Thanks,
temp
oil95 1981M01 103.27 1981M02 107.92 1981M03 110.26 1981M04 110.26 1981M05 110.11 1981M06 109.93 1981M07 109.93 1981M08 109.93 1981M09 109.93 1981M10 109.93
dplyr::lag(temp, 2)
oil95 1981M01 NA 1981M02 <NA> 1981M03 <NA> 1981M04 <NA> 1981M05 <NA> 1981M06 <NA> 1981M07 <NA> 1981M08 <NA> 1981M09 <NA> 1981M10 <NA> Warning message: In format.data.frame(x, digits = digits, na.encode = FALSE) : corrupt data frame: columns will be truncated or padded with NAs
[[alternative HTML version deleted]]
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.