[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