Download CSV Files from EUROSTAT Website
Hello, And thanks a lot. This is indeed very close to what I need. I am trying to figure out how not to "lose" the headers and how to avoid downloading labels like "(p)" together with the numerical data I am interested in. If anyone on the list knows how to make this minor modifications, s/he will make my life much easier. Cheers Lorenzo
On Fri, 01 Nov 2013 14:25:49 +0100, Adams, Jean <jvadams at usgs.gov> wrote:
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.isella at 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 at 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.