Lorenzo,
I may be able to help you get started. You can use the XML package to grab
the information off the internet.
library(XML)
mylines <- readLines(url("http://bit.ly/1coCohq";))
closeAllConnections()
mylist <- readHTMLTable(mylines, asText=TRUE)
mytable <- mylist1$xTable
However, when I look at the resulting object, mytable, it doesn't have
informative row or column headings. Perhaps someone else can figure out
how to get that information.
Jean
On Thu, Oct 31, 2013 at 10:38 AM, Lorenzo Isella
<lorenzo.ise...@gmail.com>wrote:
> Dear All,
> I often need to do some work on some data which is publicly available on
> the EUROSTAT website.
> I saw several ways to download automatically mainly the bulk data from
> EUROSTAT to later on postprocess it with R, for instance
>
> http://bit.ly/HrDICj
> http://bit.ly/HrDL10
> http://bit.ly/HrDTgT
>
> However, what I would like to do is to be able to download directly the
> csv file corresponding to a properly formatted dataset (typically a dynamic
> dataset) from EUROSTAT.
> To fix the ideas, please consider the dataset at the following link
>
> http://bit.ly/1coCohq
>
> what I would like to do is to automatically read its content into R, or at
> least to automatically download it as a csv file (full extraction, single
> file, no flags and footnotes) which I can then manipulate easily.
> Any suggestion is appreciated.
> Cheers
>
> Lorenzo
>
> ______________________________**________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/**listinfo/r-help<https://stat.ethz.ch/mailman/listinfo/r-help>
> PLEASE do read the posting guide http://www.R-project.org/**
> posting-guide.html <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.
