[R] R: R: Is there a way to extract some fields data from HTML pages through any R function ?

[Daniel Nordlund]

> -----Original Message-----
> From: r-help-bounces at r-project.org 
> [mailto:r-help-bounces at r-project.org] On Behalf Of mauede at alice.it
> Sent: Sunday, July 05, 2009 11:28 PM
> To: Martin Morgan
> Cc: r-help at stat.math.ethz.ch
> Subject: [R] R: R: Is there a way to extract some fields data 
> from HTML pages through any R function ?
> 
> It helps. But it is overly sophisticated.
> I have already downloaded and used the Excel file containing 
> the validated stuff.
> 
> Since there are R commands to download gzip as well as FASTA 
> files, I wonder whether it is possible to 
> automatically download the Excel file from 
> http://mirecords.umn.edu/miRecords/download.php
> Actually the latter may not be the actual file URL because it 
> is necessary to click on the word "here" to download the file.
> 
> Thank you,
> Maura
> 
Maura,

I haven't seen a response to your question (however, I just may have missed
it, or you mave have received an off-line response).  I went to the URL
above and found that the Excel file is at

http://mirecords.umn.edu/miRecords/download_data.php?v=1

I think you could use the read.xls() function from the gdata package to get
the file, something like this

library(gdata)
df <- read.xls("http://mirecords.umn.edu/miRecords/download_data.php?v=1")

Hope this is helpful,

Dan

Daniel Nordlund
Bothell, WA USA