[R] merge by time, certain value if 5 min before and after an "event"

[Adams, Jean]

Dagmar,

Can you explain more fully why rows 1, 2, and 5 in your result are "low"
and rows 3 and 4 are "high"?  It is not clear to me from the information
you have provided.

> result[c(1, 2, 5), ]
            Timestamp location Event
1 24.09.2012 09:05:01        1   low
2 24.09.2012 09:49:50        2   low
5 24.09.2012 10:05:10        5   low

> result[3:4, ]
            Timestamp location Event
3 24.09.2012 09:51:01        3  high
4 24.09.2012 10:04:50        1  high

Jean


On Thu, Oct 2, 2014 at 8:13 AM, Dagmar <Ramgad82 at gmx.net> wrote:

> Hello! I hope someone can help me. It would save me days of work. Thanks in
> advance!
> I have two dataframes which look like these:
>
>
> myframe <- data.frame (Timestamp=c("24.09.2012 09:00:00", "24.09.2012
> 10:00:00",
> "24.09.2012 11:00:00"), Event=c("low","high","low") )
> myframe
>
>
> mydata <- data.frame ( Timestamp=c("24.09.2012 09:05:01", "24.09.2012
> 09:49:50", "24.09.2012 09:51:01", "24.09.2012 10:04:50", "24.09.2012
> 10:05:10")
> , location=c("1","2","3","1","5") )
> mydata
>
>
> # I want to merge them by time so I have a dataframe which looks like this
> in the end (i.e. "Low"  during 5 min before and after "high" )
>
> result <- data.frame ( Timestamp=c("24.09.2012 09:05:01", "24.09.2012
> 09:49:50", "24.09.2012 09:51:01", "24.09.2012 10:04:50", "24.09.2012
> 10:05:10")
> , location=c("1","2","3","1","5") ,
> Event=c("low", "low","high","high","low"))
> result
>
> Anyone knows how do merge them?
> Best regards,
> Dagmar
>
> ______________________________________________
> 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.
>

	[[alternative HTML version deleted]]