Lorenzo, You might want to post this is a new question to get some new eyes on it.
Or, you could try posting your question to http://stackoverflow.com/. Scraping the web is a common topic for that group. Jean On Mon, Nov 4, 2013 at 3:53 AM, Lorenzo Isella <lorenzo.ise...@gmail.com>wrote: > 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 <jvad...@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.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 >> 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.
