CODEWITHSUNDEEP
rlubridate
user9085964
user9085964

Reputation: 49

How to find an interval in csv datetime

I have a csv file with a datetime column

> head(GU$`Local time`)
[1] "2021-01-11 00:00:00 GMT" "2021-01-11 00:01:00 GMT"
[3] "2021-01-11 00:02:00 GMT" "2021-01-11 00:03:00 GMT"
[5] "2021-01-11 00:04:00 GMT" "2021-01-11 00:05:00 GMT"

And I want to create a boolean column returning TRUE if time is in a certain interval and FALSE otherwise .

I defined the start and end time :

StartPreLondonInterval <- as.POSIXct("05:05:00", "%H:%M:%S", tz = "Europe/London")
EndPreLondonInterval <-as.POSIXct("07:59:59", "%H:%M:%S", tz = "Europe/London")

But they return me not just the time, but the current day to, I want just the time :

> StartPreLondonInterval
[1] "2021-01-27 05:05:00 GMT"

Anyones now how can I do that ?

I was thinking that after the interval would be checked with interval() function from lubridate package .

Upvotes: 0

Views: 127

Answers (1)

nniloc
nniloc

Reputation: 4243

One possible solution is to use the format function to extract H:M:S from the datetime, then check if the H:M:S times are within a specified range.

# create dummy data
datetimes <- seq(from = as.POSIXct("2021-01-11 00:00:00", tz = "GMT"), length.out = 100, by = "mins")

Add hms and time_chk columns.

library(dplyr)

data.frame(local_time = datetimes) %>%
  mutate(hms = format(local_time, "%H:%M:%S"),
         time_chk = hms >= "00:01:00" & hms <= "00:03:00")


#---------
             local_time      hms time_chk
1   2021-01-11 00:00:00 00:00:00    FALSE
2   2021-01-11 00:01:00 00:01:00     TRUE
3   2021-01-11 00:02:00 00:02:00     TRUE
4   2021-01-11 00:03:00 00:03:00     TRUE
5   2021-01-11 00:04:00 00:04:00    FALSE
6   2021-01-11 00:05:00 00:05:00    FALSE
7   2021-01-11 00:06:00 00:06:00    FALSE

Upvotes: 1

Related Questions