[R] add a data frame to my data frame

[jim holtman]

Is this what you want:

> myframe2
     ID Hunger        myframestime
1 Ernie      1 2012-09-24 09:00:00
2 Ernie      1 2012-09-25 09:00:00
3  Bert      2 2012-09-24 10:00:00
4  Bert      2 2012-09-25 10:00:00
> environ2
     ID Temp Rain          envirotime
1 Ernie   25  0.1 2012-09-24 09:00:00
2 Ernie   30    5 2012-09-25 09:00:00
3  Bert   27    2 2012-09-25 10:00:00
> merge(myframe2, environ2, by.x = c("ID", "myframestime"), by.y = c("ID", "envirotime"))
     ID        myframestime Hunger Temp Rain
1  Bert 2012-09-25 10:00:00      2   27    2
2 Ernie 2012-09-24 09:00:00      1   25  0.1
3 Ernie 2012-09-25 09:00:00      1   30    5


On Tue, Sep 25, 2012 at 10:44 AM, Tagmarie <Ramgad82 at gmx.net> wrote:
> Hello,
> Once again I feel so dumb. Can anyone help me?
> I have a data frame somewhat like that:
>
> myframe <- data.frame (ID=c("Ernie", "Ernie", "Bert", "Bert"),
> Timestamp=c("24.09.2012 09:00", "25.09.2012 09:00", "24.09.2012 10:00",
> "25.09.2012 10:00"), Hunger=c("1","1","2","2") )
> myframestime <- as.POSIXct (strptime(as.character(myframe$Timestamp),
> "%d.%m.%Y %H:%M"), tz="GMT")
> myframe2 <- cbind (myframe,myframestime)
> myframe2$Timestamp <- NULL
>
> Now I have a second dataframe with environmental variables. Something like
> this:
>
> environ <- data.frame (ID=c("Ernie", "Ernie", "Bert"),
> Timestamp=c("24.09.2012 09:00", "25.09.2012 09:00", "25.09.2012 10:00"),
> Temp=c("25","30","27"), Rain =c ("0.1", "5", "2"))
> envirotime <- as.POSIXct (strptime(as.character(environ$Timestamp),
> "%d.%m.%Y %H:%M"), tz="GMT")
> environ2 <- cbind (environ,envirotime)
> environ2$Timestamp <- NULL
>
> How do I merge or handle the two data frames at the respective lines so that
> I get the data (Temp, Rain) at the correct line with (Hunger)?
>
>
>
>
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/add-a-data-frame-to-my-data-frame-tp4644122.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.



-- 
Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.