You need to show, not tell, what you did to get better answers. Did you
use the all=TRUE argument to merge()?
> df <-
data.frame(A=c(10,11,12),B=c(5,5,4),C=c(3.3,4,3),time=as.Date(c("1990-01-01","1990-02-07","1990-02-14")))
0
> merge(df, data.frame(time=seq(as.Date("1990-01-01"),
to=as.Date("1990-02-15"), by="days")), all.y=TRUE)
time A B C
1 1990-01-01 10 5 3.3
2 1990-01-02 NA NA NA
3 1990-01-03 NA NA NA
...
36 1990-02-05 NA NA NA
37 1990-02-06 NA NA NA
38 1990-02-07 11 5 4.0
39 1990-02-08 NA NA NA
...
Bill Dunlap
TIBCO Software
wdunlap tibco.com
On Wed, Jul 20, 2016 at 8:26 PM, lily li <chocol...@gmail.com> wrote:
> Yes, I tried to create a dataframe and merge it with the shortened
> dataframe. The resulting dataframe goes with the short one and truncates
> the complete date column, so it does not work.
>
> On Wed, Jul 20, 2016 at 6:38 PM, David Winsemius <dwinsem...@comcast.net>
> wrote:
>
> >
> > > On Jul 20, 2016, at 1:31 PM, lily li <chocol...@gmail.com> wrote:
> > >
> > > Hi R users,
> > >
> > > I have a dataframe, where there is a column 'time' represents time
> series
> > > but is not complete. How to expand the dataframe so this column will
> > become
> > > complete, where other columns with the newly added rows have NA values?
> > > Thanks.
> > >
> > > df
> > > A B C time
> > > 10 5 3.3 1990-01-01
> > > 11 5 4 1990-02-07
> > > 12 4 3 1990-02-14
> > > ...
> >
> > Make a dataframe with a 'time' column using seq.Date and merge that
> > dataframe with your df dataframe.
> >
> > >
> > > [[alternative HTML version deleted]]
> >
> > Really .... isn't it time you learned how to send plain text. You've
> > posted many questions on Rhelp. It's really not that difficult on
> gmail. I
> > also have a gmail account and have had no difficulty finding instructions
> > on how to do it.
> >
> > >
> > > ______________________________________________
> > > 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.
> >
> > David Winsemius
> > Alameda, CA, USA
> >
> >
>
> [[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.
