[R] Incorrect Conversion of Datetime

Ogbos Okike g||ted|||e2014 @end|ng |rom gm@||@com
Wed Jan 8 10:37:23 CET 2020


Dear Friends,
A sample of my data is:
98 05 01 02    8541
98 05 01 03    8548
98 05 01 04    8512
98 05 01 05    8541
98 05 01 06    8509
98 05 01 07    8472
98 05 01 08    8454
98 05 01 09    8461
98 05 01 10    8462
98 05 01 11    8475
98 05 01 12    8433
98 05 01 13    8479
98 05 01 14    8417
98 05 01 15    8463
98 05 01 16    8473
98 05 01 17    8450
98 05 01 18    8433
98 05 01 19    8437
98 05 01 20    8437
98 05 01 21    8438
98 05 01 22    8421
98 05 01 23    8420
98 05 02 00    8371
98 05 02 01    8338
98 05 02 02    8251
98 05 02 03    8204
98 05 02 04    8183
98 05 02 05    8231
98 05 02 06    8242
Columns 1, 2, 3, 4 and 5 stands for year, month, day , hour and count.

Using:
Sys.setenv( TZ="GMT" )


dta <- read.table("Ohr1may98", col.names = c("year", "month", "day",
"hour", "counts"))
dta$year <- with( dta, ifelse(year < 50, year + 2000, year + 1900))
dta$datetime <- with( dta, as.POSIXct(ISOdatetime(year, month,day,hour,0,0)))
a =  dta$datetime
I converted the datetime and plotted the graph of count vs a. The plot
was great but I have issues with the date.

The raw data is for some hours for Ist and second day of may 1998 as
is evident from the sample data. But the result of date stored in "a"
above shows:
> a
 [1] "1998-01-05 02:00:00 GMT" "1998-01-05 03:00:00 GMT"
 [3] "1998-01-05 04:00:00 GMT" "1998-01-05 05:00:00 GMT"
 [5] "1998-01-05 06:00:00 GMT" "1998-01-05 07:00:00 GMT"
 [7] "1998-01-05 08:00:00 GMT" "1998-01-05 09:00:00 GMT"
 [9] "1998-01-05 10:00:00 GMT" "1998-01-05 11:00:00 GMT"
[11] "1998-01-05 12:00:00 GMT" "1998-01-05 13:00:00 GMT"
[13] "1998-01-05 14:00:00 GMT" "1998-01-05 15:00:00 GMT"
[15] "1998-01-05 16:00:00 GMT" "1998-01-05 17:00:00 GMT"
[17] "1998-01-05 18:00:00 GMT" "1998-01-05 19:00:00 GMT"
[19] "1998-01-05 20:00:00 GMT" "1998-01-05 21:00:00 GMT"
[21] "1998-01-05 22:00:00 GMT" "1998-01-05 23:00:00 GMT"
[23] "1998-01-06 00:00:00 GMT" "1998-01-06 01:00:00 GMT"
[25] "1998-01-06 02:00:00 GMT" "1998-01-06 03:00:00 GMT"
[27] "1998-01-06 04:00:00 GMT" "1998-01-06 05:00:00 GMT"
[29] "1998-01-06 06:00:00 GMT"
This seems to suggest day 5 and 6 in January 1998 instead of day 1 and
2 in May of 1998.

I have spent some time trying to resolve this but I have not been successful.

I would be thankful if you could help me to check where I went astray.

Thank you.
Best wishes
Ogbos



More information about the R-help mailing list