Hi Lorenzo, Perhaps package "pxR" can help you out.
http://cran.at.r-project.org/web/packages/pxR/index.html pxR: PC-Axis with R The pxR package provides a set of functions for reading and writing PC-Axis files, used by different statistical organizations around the globe for data dissemination. Regards, Carlos Ortega. 2013/11/4 Adams, Jean <jvad...@usgs.gov> > 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. > -- Saludos, Carlos Ortega www.qualityexcellence.es [[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.
