[R] Combining Data Frames

Uwe Ligges ligges at statistik.tu-dortmund.de
Sun Feb 24 20:09:58 CET 2008



stephen sefick wrote:
> I have two dataframes in R that were tab seperated .txt files
> 
> y<-read.table("foo.txt", header=T)
> x<-read.table("foo.txt", header=T)
> 
> these are set up like this:
> 
> Datetime                 Temp
> 01/01/07 00:01         11.5
> 01/01/07 00:16         11.6
> 
> etc etc to 66000 rows in y and 33000 rows in x
> 
> The two files overlap with the same data for a period of time but
> contain different values outside of these.  Is there a way to merge
> these two data sets based on the shared date time column into one
> large dataset of ~90,000 lines.  I want to eventually make this into a
> time series with frequency= 1/15.


Have you tried ?merge.

Uwe Ligges


> Thanks
> 
> Stephen



More information about the R-help mailing list