[R] Calculating date difference in days
reichm@@j m@iii@g oii sbcgiob@i@@et
reichm@@j m@iii@g oii sbcgiob@i@@et
Wed May 22 23:43:42 CEST 2019
R Help
I have a function to calculate a date difference in days but my results come
back in hours. I suspect I am using the as.POSIXlt function incorrectly .
Suggestions?
# Start time of data to be considered
start_day <- "2016-04-30"
# Make event and sequence IDs into factors
elapsed_days <- function(end_date, start_date){
ed <- as.POSIXlt(end_date)
sd <- as.POSIXlt(start_date)
ed-sd
}
trans_sequence$eventID <- elapsed_days(trans_sequence$Date, start_day)
> trans_sequence
# A tibble: 39 x 5
# Groups: Emitter [15]
Emitter Date SIZE Geohash
eventID
<int> <date> <int> <chr>
<time>
1 1 2016-05-01 12 A;B;C;D;E;F;G;H;I;J;K;L
19 hours
2 1 2016-05-02 5 A;B;C;D;E
43 hours
3 1 2016-05-05 11 A;B;C;D;E;F;G;H;I;J;K
115 hours
4 2 2016-05-01 9 C;D;E;F;G;H;I;J;K
19 hours
5 2 2016-05-02 3 F;G;H
43 hours
6 2 2016-05-05 3 L;M;N
115 hours
7 3 2016-05-01 3 L;M;N
19 hours
8 3 2016-05-02 3 I;J;K
43 hours
9 3 2016-05-04 25
A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y 91 hours
10 3 2016-05-05 7 O;P;Q;R;S;T;U
115 hours
Jeff Reichman
[[alternative HTML version deleted]]
More information about the R-help
mailing list