Can I download XML data from the web and save, in as CSV or TXT delimitation?
Joel Goldstick
joel.goldstick at gmail.com
Wed Aug 19 09:49:11 EDT 2015
>
>
> 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?
> http://www.usda.gov/oce/commodity/wasde/report_format/latest-July-2015-New-Format.xml
>
> Parse it, or clean it, or whatever, and save it as a CSV or TXT? Is that possible?
>
> Thanks.
Of course you can
1. read a file from a website using python urllib modules or requests
module (3rd party but simpler)
2. There are several xml parsers. I haven't experienced them, so
google is your friend
3. python has csv reader and writer modules
--
Joel Goldstick
http://joelgoldstick.com
More information about the Python-list
mailing list