[SOLVED] Using Python to connect to an XML ?

[jehoshua]

Thanks @snippsat

Initially I was using a different XML file for testing, and got a warning ..

read_xml_10.py:8: XMLParsedAsHTMLWarning: It looks like you're parsing an XML document using an HTML parser. If this really is an HTML document (maybe it's XHTML?), you can ignore or filter this warning. If it's XML, you should know that using an XML parser will be more reliable. To parse this document as XML, make sure you have the lxml package installed, and pass the keyword argument features="xml" into the BeautifulSoup constructor.
soup = BeautifulSoup(file, 'lxml')

No doubt because it was the full (large) file. I notice though, there are 3 sets of totals though, not 2, as there are two account numbers. That will be because "append" is used.

[snippsat]

Initially I was using a different XML file for testing, and got a warning ..

That's just a warning,just ignore it it make no difference in output,sometime html parser works better for xml.
Can just do this.

import warnings
from bs4 import UserWarning
warnings.filterwarnings("ignore", category=UserWarning, module='bs4')