Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to find different elements of two time vectors?

Considering these two time vectors:

a<-seq(as.POSIXct("2010-01-01 05:00:00"), as.POSIXct("2010-01-02 23:55:00"), by = '5 min')
b<-seq(as.POSIXct("2010-01-01 00:00:00"), as.POSIXct("2010-01-03 23:55:00"), by = '10 min')

How to get the different elements between these two vectors? I've tried:

union(setdiff(a, b), setdiff(b, a))

But the returned values are not in time format.

like image 318
YQ.Wang Avatar asked Dec 24 '16 08:12

YQ.Wang


2 Answers

This uses only operations that preserve "POSIXct" class:

c(a[!a %in% b], b[!b %in% a])
like image 60
G. Grothendieck Avatar answered Nov 14 '22 02:11

G. Grothendieck


This will also work (using the default origin):

as.POSIXct(union(setdiff(a, b), setdiff(b, a)), origin = '1970-01-01')

#[1] "2010-01-01 05:05:00 IST" "2010-01-01 05:15:00 IST" "2010-01-01 05:25:00 IST" "2010-01-01 05:35:00 IST" "2010-01-01 05:45:00 IST"
#[6] "2010-01-01 05:55:00 IST" "2010-01-01 06:05:00 IST" "2010-01-01 06:15:00 IST" "2010-01-01 06:25:00 IST" "2010-01-01 06:35:00 IST"

# this checks a U b = (a - b) U (b - a) U (a /\ b) for PoSIxct objects, should evaluate to true
all(sort(as.POSIXct(union(union(setdiff(a, b), setdiff(b, a)), intersect(a, b)), origin = '1970-01-01')) == sort(as.POSIXct(union(a, b), origin = '1970-01-01')))
# TRUE
like image 3
Sandipan Dey Avatar answered Nov 14 '22 02:11

Sandipan Dey