Displaying 6 results from an estimated 6 matches for "shipname".
Did you mean:
chipname
2006 Aug 10
5
Ampersand Heartburn
Greetings all.
I''m using the Microsoft "NorthWind Traders" database "orders" table as
test data for the Rico LiveGrid JavaScript.
The problem I''m noticing is that some of the records in the "ShipName"
field contain ampersands -- which for some reason are not being escaped
by Rails.
Rails does in fact automatically escape all of the other characters like
apostrophes'' that might otherwise cause problems. However it returns
ampersands as ampersands with no escape character or o...
2017 Jul 11
2
Problems with time formats when importing data using readHTMLTable
...missions.
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 (??) Course (??)
1...
2017 Jul 11
0
Problems with time formats when importing data using readHTMLTable
...ipt 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 (??)...
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
...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
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