Hi,
For the second part of your question, use ?merge() or ?join() from library(plyr) dat1<-read.table(text=" 2011-02-01 15.29130 2011-02-08 17.60278 2011-02-15 17.99737 2011-02-22 25.43690 ",sep="",header=FALSE,stringsAsFactors=FALSE) dat2<-read.table(text=" 2011-02-01 342.34 2011-02-02 68.45 2011-02-03 130.47 2011-02-04 129.86 2011-02-05 81.98 2011-02-06 77.30 2011-02-07 81.38 2011-02-08 139.95 2011-02-09 124.40 ",sep="",header=FALSE,stringsAsFactors=FALSE) merge(dat2,dat1,by="V1",all=TRUE) # V1 V2.x V2.y #1 2011-02-01 342.34 15.29130 #2 2011-02-02 68.45 NA #3 2011-02-03 130.47 NA #4 2011-02-04 129.86 NA #5 2011-02-05 81.98 NA #6 2011-02-06 77.30 NA #7 2011-02-07 81.38 NA #8 2011-02-08 139.95 17.60278 #9 2011-02-09 124.40 NA #10 2011-02-15 NA 17.99737 #11 2011-02-22 NA 25.43690 A.K. ----- Original Message ----- From: Matthijs Daelman <matthijs.dael...@gmail.com> To: r-help <r-help@r-project.org> Cc: Sent: Friday, January 4, 2013 5:53 PM Subject: [R] How to plot multiple time series with different time base in same plot? Hi I have to time series with a different time base. The first has only sporadic datapoints: 2011-02-01 15.29130 2011-02-08 17.60278 2011-02-15 17.99737 2011-02-22 25.43690 The other has a daily datapoint: 2011-02-01 342.34 2011-02-02 68.45 2011-02-03 130.47 2011-02-04 129.86 2011-02-05 81.98 2011-02-06 77.30 2011-02-07 81.38 2011-02-08 139.95 2011-02-09 124.40 ...etc. In Excel, it is fairly easy to get these two time series in one and the same scatter plot, with two Y-axes, but how would you do this with R? Also, I would like to obtain a data frame that contains both variables: 2011-02-01 342.34 15.29130 2011-02-02 68.45 NA 2011-02-03 130.47 NA 2011-02-04 129.86 NA 2011-02-05 81.98 NA 2011-02-06 77.30 NA 2011-02-07 81.38 NA 2011-02-08 139.95 17.60278 2011-02-09 124.40 NA etc. I can imagine that the data frame can be obtained using (nested) loops, but that does not seem very efficient with a large dataset. Any ideas? Thanks a lot. Matthijs Daelman [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list 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 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.