Can I download XML data from the web and save, in as CSV or TXT delimitation?

ryguy7272 ryanshuell at
Wed Aug 19 13:57:44 CEST 2015

I'm trying to get R to download the data from here:

# install and load the necessary package
# Save the URL of the xml file in a variable

xml.url <- ""
# Use the xmlTreePares-function to parse xml file directly from the web

xmlfile <- xmlTreeParse(xml.url)
# the xml file is now saved as an object you can easily work with in R:

# Use the xmlRoot-function to access the top node
xmltop = xmlRoot(xmlfile)
# have a look at the XML-code of the first subnodes:

Everything seems fine up to that point.  The next line seems to NOT parse the data as I thought it would.
# To extract the XML-values from the document, use xmlSApply:
datacat <- xmlSApply(xmltop, function(x) xmlSApply(x, xmlValue))

I did some research on this, and it seemed to work in other examples of xml data. I guess this data set is different...or I just don't understand this well enough to know what's really going on...

Basically, I want to get this:


Into a data table. How can I do that?


More information about the Python-list mailing list