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 <miao...@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@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. > [[alternative HTML version deleted]] ______________________________________________ R-help@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.
