[R] Combining Data Frames
Henrique Dallazuanna
wwwhsd at gmail.com
Fri Feb 22 19:41:17 CET 2008
Try this:
x
Datetime Temp
1 01/01/07 00:01 11.5
2 01/01/07 00:16 11.6
y
Datetime Temp
1 01/01/07 00:01 10
2 01/01/07 00:16 3
merge(x, y, by="Datetime")
Datetime Temp.x Temp.y
1 01/01/07 00:01 11.5 10
2 01/01/07 00:16 11.6 3
On 22/02/2008, stephen sefick <ssefick at gmail.com> 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.
>
> Thanks
>
> Stephen
> --
> Let's not spend our time and resources thinking about things that are
> so little or so large that all they really do for us is puff us up and
> make us feel like gods. We are mammals, and have not exhausted the
> annoying little problems of being mammals.
>
> -K. Mullis
>
> ______________________________________________
> R-help at 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.
>
--
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O
More information about the R-help
mailing list