Re: [R] Combining Data Frames

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Fri, 22 Feb 2008 13:54:23 -0500

You could do it with zoo:

DF1 <- data.frame(Datetime = ISOdate(2000, 1:2, 1), Temp = 1:2) DF2 <- data.frame(Datetime = ISOdate(2000, 2:3, 1), Temp = 3:4)

library(zoo)
# convert to zoo
z1 <- zoo(DF1[,2], DF1[,1])
z2 <- zoo(DF2[,2], DF2[,1])

# merge
z <- merge(z1, z2, all = TRUE)

# take rowmeans
zz <- zoo(rowMeans(z, na.rm = TRUE), time(z))

# or

DF3 <- data.frame(data = rowMeans(z, na.rm = TRUE), Time = time(z))

On Fri, Feb 22, 2008 at 1:36 PM, 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.
>



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. Received on Fri 22 Feb 2008 - 18:56:27 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 22 Feb 2008 - 19:30:43 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive