Message-ID: <CAAxdm-5AZsXWsg3JrnoLrnm-LUybrapk0jxgx-+maYU2Md+=Dg@mail.gmail.com>
Date: 2012-09-25T15:34:44Z
From: jim holtman
Subject: add a data frame to my data frame
In-Reply-To: <1348584274275-4644122.post@n4.nabble.com>
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.