[R] Subset a datafram according to time
MacQueen, Don
macqueen1 at llnl.gov
Fri Feb 10 01:23:35 CET 2012
(apologies in advance for the stupid line-wrapping that I expect my email
software to force upon us)
If I understand correctly what you want, I would
(1) in both data frames, combine date and time into a single column
(variable) that is class POSIXct
(2) use the merge() function
This assumes that your every-6-minutes data frame does NOT have a column
with the same name as the observations in the every-second data frame. In
fact, it would be best if the only column name they have in common is the
date-time column.
Your question is a little puzzling because your example data is not one
obs per second, nor is it one per every 6 minutes.
This may help:
as.POSIXct('01/12/2012 03:14:55', format='%m/%d/%Y %H:%M:%S')
or perhaps
mydat$dt <- as.POSIXct( paste(mydat$date,mydat$time) , format='%m/%d/%Y
%H:%M:%S')
(supposing that your data frame is named mydat, and it has columns named
'date' and 'time' that look like those in your example.)
-Don
--
Don MacQueen
Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550
925-423-1062
On 2/9/12 1:22 AM, "NickNz125" <nickthomas125 at gmail.com> wrote:
>PREFERED WAY OF DOING IT
>I have a data set of observations every second for a month long period, I
>want to extract the observations according to the date & time of another
>data frame ( the other data frame is in the same format). I want to do
>this
>to match these observations to my test observations (in the other data
>frame) which are done every 6 minutes. So basically im shrinking the data
>frame of second observations to only display the date time observation
>every
>6 minutes.
>
>ALTERNATIVE WAY
>In other words I just wanna extract every 6 minute observation value from
>this dataframe of everysecond observations
>
>date time observations
>02/08/2011 00:00 1.165
>02/08/2011 00:01 1.241
>02/08/2011 00:02 1.232
>
>
>Im pretty new to the porgram done 2 days on it learning and learning, im
>getting my head around it.
>
>Help would be much appreciated.
>
>--
>View this message in context:
>http://r.789695.n4.nabble.com/Subset-a-datafram-according-to-time-tp437229
>3p4372293.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.
More information about the R-help
mailing list