Thank you, I will have to wait until I get home form work to test the XML. But
I'm looking to do something more along the lines of an automated process over
copy and pasting.
James
________________________________
From: "Adams, Jean" <jvad...@usgs.gov>
To: jcrosbie <ja...@crosb.ie>
Cc: R help <r-help@r-project.org>
Sent: Wednesday, May 29, 2013 6:50 AM
Subject: Re: [R] Download data
I tried reading in the data using the XML package, but I can't figure out how
to read either ALL of the tables or a particular table. The code below just
reads the first table. Maybe someone else will know how.
Jean
library(XML)
look <- readHTMLTable("http://www.ngx.com/settlehistory.html";)
head(look[[1]])
V1 V2 V3 V4 V5 V6 V7
V8 V9 V10
1 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-05-01 2013-05-31 0
-16.0000
2 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-06-01 2013-06-30 0
-18.2500
3 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-07-01 2013-07-31 0
-19.7500
4 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-08-01 2013-08-31 0
-21.2500
5 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-09-01 2013-09-30 0
-22.7500
6 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-10-01 2013-10-31 0
-23.0000
On Tue, May 28, 2013 at 11:02 AM, jcrosbie <ja...@crosb.ie> wrote:
Hi, I'm trying to download data from:
>http://www.ngx.com/settlehistory.html
>
>Is it possible to fetch the data with R?
>
>Thank you
>
>
>
>--
>View this message in context:
>http://r.789695.n4.nabble.com/Download-data-tp4668138.html
>Sent from the R help mailing list archive at Nabble.com.
>
>______________________________________________
>R-help@r-project.org mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.
>
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
