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

2015-08-19 Thread Laura Creighton
In a message of Wed, 19 Aug 2015 06:32:46 -0700, ryguy7272 writes: Well, yes, I was originally trying to do it it R, but I couldn't get it working, so I thought I'd try to do it in Python. That was a sample R script. Can I do essentially the same thing in Python? Can I read the XML from the

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

2015-08-19 Thread Laura Creighton
In a message of Wed, 19 Aug 2015 04:57:44 -0700, ryguy7272 writes: 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

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

2015-08-19 Thread Joel Goldstick
Well, yes, I was originally trying to do it it R, but I couldn't get it working, so I thought I'd try to do it in Python. That was a sample R script. Can I do essentially the same thing in Python? Can I read the XML from the web?

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

2015-08-19 Thread ryguy7272
On Wednesday, August 19, 2015 at 8:21:50 AM UTC-4, Laura Creighton wrote: In a message of Wed, 19 Aug 2015 04:57:44 -0700, ryguy7272 writes: 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

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

2015-08-19 Thread Denis McMahon
On Wed, 19 Aug 2015 04:57:44 -0700, ryguy7272 wrote: [stuff] Downloading xml from the web is easy writing csv or txt is easy The tricky bit is converting the xml you have into the csv or text data you want. And to do that, you need to understand the structure of the xml data that you are

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

2015-08-19 Thread Petite Abeille
On Aug 19, 2015, at 7:01 PM, Denis McMahon denismfmcma...@gmail.com wrote: Downloading xml from the web is easy writing csv or txt is easy The tricky bit is converting the xml you have into the csv or text data you want. curl | xml2 | 2csv http://www.ofb.net/~egnor/xml2/ref --

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

2015-08-19 Thread ryguy7272
On Wednesday, August 19, 2015 at 1:14:44 PM UTC-4, Petite Abeille wrote: On Aug 19, 2015, at 7:01 PM, Denis McMahon wrote: Downloading xml from the web is easy writing csv or txt is easy The tricky bit is converting the xml you have into the csv or text data you want.