Displaying 5 results from an estimated 5 matches for "318358".
Did you mean:
138358
2017 Jul 11
2
Problems with time formats when importing data using readHTMLTable
...bpage changed some permissions.
Here is the script used to get the data directly from the webpage into
R, for a sample of 20 records (10 per page):
library(XML)
x <- list()
for (i in 1:2)
{
x[i]<-
readHTMLTable(paste('http://www.marinetraffic.com/en/ais/index/positions/all/shipid:318358/mmsi:263601000/shipname:NORUEGA/per_page:10/page:',
i, sep=''))
}
ais <- do.call('rbind', x)
ais <- ais[,-7]
and I got the following table:
> ais
Timestamp Source
Speed (kn) Latitude (??) Longitude (??)...
2017 Jul 11
0
Problems with time formats when importing data using readHTMLTable
...> Here is the script used to get the data directly from the webpage into R, for a sample of 20 records (10 per page):
>
> library(XML)
> x <- list()
> for (i in 1:2)
> {
> x[i]<- readHTMLTable(paste('http://www.marinetraffic.com/en/ais/index/positions/all/shipid:318358/mmsi:263601000/shipname:NORUEGA/per_page:10/page:', i, sep=''))
> }
>
> ais <- do.call('rbind', x)
> ais <- ais[,-7]
>
> and I got the following table:
>
>> ais
> Timestamp Source...
2017 Jul 10
0
Problems with time formats when importing data using readHTMLTable
Not reproducible. [1][2][3] If our answers don't seem to apply to your situation, it will likely be because you did not explain your question clearly.
Not plain text. This is a plain text mailing list, and the best-case scenario when you let your email program send HTML is that what you saw is not what we see (worst case is your email is scrambled on our end).
Have you read the
2017 Jul 11
1
Problems with time formats when importing data using readHTMLTable
...ata directly from the webpage
>> into R, for a sample of 20 records (10 per page):
>>
>> library(XML)
>> x <- list()
>> for (i in 1:2)
>> {
>> x[i]<-
>> readHTMLTable(paste('http://www.marinetraffic.com/en/ais/index/positions/all/shipid:318358/mmsi:263601000/shipname:NORUEGA/per_page:10/page:',
>> i, sep=''))
>> }
>>
>> ais <- do.call('rbind', x)
>> ais <- ais[,-7]
>>
>> and I got the following table:
>>
>>> ais
>>...
2017 Jul 10
2
Problems with time formats when importing data using readHTMLTable
Hi,
I am extracting positions data from the marine traffic website. The
table has a "Timestamp" column which, in the browser, appears with the
format yyyy-mm-dd HH:MM (UTC), e.g. 2017-07-10 14:04 (UTC).
When I import the table, the same date "2017-07-10 14:04 (UTC)" appears
as "1499696500149969650021 minutes ago", This is the more recent date
and time. Older