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

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


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

http://www.usda.gov/oce/commodity/wasde/report_format/latest-July-2015-New-Format.xml


# install and load the necessary package
install.packages("XML")
library(XML)
# 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:
class(xmlfile)


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



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:

xmltop


Into a data table. How can I do that?

Thanks.


More information about the Python-list mailing list