If you want to use regular expressions, try:
> x
V1 V2 V3 V4
1 1 2009-06-20 00:53:00 73
2 2 2009-06-20 01:08:00 73
3 3 2009-06-20 01:44:00 72
4 4 2009-06-20 01:53:00 71
5 5 2009-06-20 02:07:00 72
> x[grep(":53:", x$V3),]
V1 V2 V3 V4
1 1 2009-06-20 00:53:00 73
4
Try this:
> Lines <- "dt,tf
+ 2009-06-20 00:53:00,73
+ 2009-06-20 01:08:00,73
+ 2009-06-20 01:44:00,72
+ 2009-06-20 01:53:00,71
+ 2009-06-20 02:07:00,72"
> DF <- read.csv(textConnection(Lines), colClasses = c("POSIXct", "numeric"))
> DF[format(DF$dt, "%M") == "53",]
dt tf
1 2009
Convert dt to POSIXct class:
wtd$dt <- as.POSIXct(wtd$dt)
subset(wtd, format(dt, '%M') == 53)
On Mon, Jun 22, 2009 at 9:58 PM, Keith Jones wrote:
> Hi,
>
> I have a data frame with two columns: dt and tf. The dt column is datetime
> and the tf column is a temperature.
>
>
Hi,
I have a data frame with two columns: dt and tf. The dt column is
datetime and the tf column is a temperature.
dt tf
1 2009-06-20 00:53:00 73
2 2009-06-20 01:08:00 73
3 2009-06-20 01:44:00 72
4 2009-06-20 01:53:00 71
5 2009-06-20 02:07:00 72
...
I need a
4 matches
Mail list logo