Can I download XML data from the web and save, in as CSV or TXT delimitation?
ryanshuell at gmail.com
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 <- "http://www.usda.gov/oce/commodity/wasde/report_format/latest-July-2015-New-Format.xml"
# 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