Hi Paul, match might help, but without a real data sample, it is hard to check if the following might work.
mm=match(df.col378[,"Date"],df.col362[,"Date"]) #mm will have NAs, where there is no matching date in df.col362 #and have the index of the match, where the two dates match new.df=cbind(df.col378,"transits.col362"=df.col362[mm,"transits"]) cheers Peter > On 27 Mar 2017, at 22:09, Paul Bernal <paulberna...@gmail.com> wrote: > > Dear friends, > > I have one dataframe which contains 378 observations, and another one, > containing 362 observations. > > Both dataframes have two columns, one date column and another one with the > number of transits. > > I wanted to come up with a code so that I could fill in the dates that are > missing in one of the dataframes and replace the column of transits with > the value NA. > > I have tried several things but R obviously complains that the length of > the dataframes are different. > > How can I solve this? > > Any guidance will be greatly appreciated, > > Best regards, > > Paul > > [[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. ______________________________________________ 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.
