How do I parse XML in Python?

Question

I have many rows in a database that contains xml and I'm trying to write a Python script that will go through those rows and count how many instances of a particular node attribute show up. For instance, my tree looks like: <foo> <bar> <type foobar="1"/> <type foobar="2"/> </bar> </foo>How can I access the attributes 1 and 2 in the XML using Python?

Answer 1

You could use something called ElementTree or xml.dom or xml.sax to do much of the work. If you can put a line of xml into a string, then you can use the string functions to find and count the number of instances of the tag.are you are scanning. It depends on how you have this stored in the database, the type of database, and more..