[R] Problems with time formats when importing data using readHTMLTable
David Winsemius
dwinsemius at comcast.net
Wed Jul 12 00:07:29 CEST 2017
Sent from my iPhone
> On Jul 11, 2017, at 10:00 AM, Cristina Silva <csilva at ipma.pt> wrote:
>
> Dear David,
>
> Thank you very much. You have solved my problem, not of importing in the right format but the date conversion. It works for me, and if I specify the timezone tz='GMT', I get exactly the same time of the webpage.
>
R date times are a bit weird. To me , anyway. Input is in UTC, but default output is in your locale. So I usually wrap format around a result if I want UTC.
--
David
> Sincerely yours,
>
> Cristina
>
> On Tue, 11 Jul 2017 07:15:43 -0700, David Winsemius wrote:
>>> On Jul 11, 2017, at 6:25 AM, Cristina Silva <csilva at ipma.pt> wrote:
>>>
>>> Dear Jeff,
>>>
>>> I am sorry, I didn't notice that it was not plain text. I hope that it is now in the correct format. I explain the problem again, now with more detais.
>>> I am collecting the track positions of our research vessel from www.marinetraffic.com. In the page, the data appear in a table:
>>>
>>> Timestamp Source Speed (kn) Latitude (°) Longitude (°) Course (°) Show on Map
>>> 2017-07-11 10:57 (UTC) Terr-AIS 8.6 37.36228 -9.176811 200
>>> 2017-07-11 10:54 (UTC) Terr-AIS 8.4 37.36875 -9.174048 200
>>> 2017-07-11 09:50 (UTC) Terr-AIS 8 37.51499 -9.184502 149
>>> 2017-07-11 09:08 (UTC) Terr-AIS 7.7 37.60513 -9.228263 169
>>> 2017-07-11 09:05 (UTC) Terr-AIS 8 37.61168 -9.229627 167
>>> 2017-07-11 09:03 (UTC) Terr-AIS 6.9 37.61626 -9.230456 132
>>> 2017-07-11 08:59 (UTC) Terr-AIS 3.4 37.61758 -9.237928 101
>>> 2017-07-11 08:57 (UTC) Terr-AIS 3.6 37.61808 -9.240235 116
More information about the R-help
mailing list