{"id":42,"date":"2024-03-31T15:15:31","date_gmt":"2024-03-31T14:15:31","guid":{"rendered":"http:\/\/lerking.servehttp.com\/?p=42"},"modified":"2024-04-02T14:44:22","modified_gmt":"2024-04-02T13:44:22","slug":"parsing-xml-file-in-python","status":"publish","type":"post","link":"https:\/\/blog.lerk.ing\/index.php\/2024\/03\/31\/parsing-xml-file-in-python\/","title":{"rendered":"Parsing xml file in python"},"content":{"rendered":"\n

Today I'm going to show you how you can relatively easy parse and extract data from xml files, using the standard xml module.<\/p>\n\n\n\n

The xml document we'll be parsing has the following structure.<\/p>\n\n\n\n

<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
<CATALOG><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Empire Burlesque<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Bob Dylan<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>USA<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Columbia<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>10.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1985<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Hide your heart<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Bonnie Tyler<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>CBS Records<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>9.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1988<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Greatest Hits<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Dolly Parton<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>USA<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>RCA<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>9.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1982<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Still got the blues<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Gary Moore<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Virgin records<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>10.20<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1990<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Eros<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Eros Ramazzotti<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>EU<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>BMG<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>9.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1997<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>One night only<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Bee Gees<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Polydor<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>10.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1998<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Sylvias Mother<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Dr.Hook<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>CBS<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>8.10<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1973<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Maggie May<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Rod Stewart<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Pickwick<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>8.50<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1990<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Romanza<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Andrea Bocelli<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>EU<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Polydor<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>10.80<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1996<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>When a man loves a woman<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Percy Sledge<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>USA<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Atlantic<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>8.70<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1987<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Black angel<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Savage Rose<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>EU<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Mega<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>10.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1995<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>1999 Grammy Nominees<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Many<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>USA<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Grammy<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>10.20<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1999<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>For the good times<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Kenny Rogers<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Mucik Master<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>8.70<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1995<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Big Willie style<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Will Smith<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>USA<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Columbia<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>9.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1997<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Tupelo Honey<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Van Morrison<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Polydor<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>8.20<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1971<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Soulsville<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Jorn Hoel<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>Norway<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>WEA<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>7.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1996<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>The very best of<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Cat Stevens<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Island<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>8.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1990<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Stop<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Sam Brown<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>A and M<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>8.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1988<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Bridge of Spies<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>T'Pau<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Siren<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>7.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1987<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Private Dancer<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Tina Turner<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Capitol<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>8.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1983<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Midt om natten<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Kim Larsen<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>EU<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Medley<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>7.80<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1983<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Pavarotti Gala Concert<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Luciano Pavarotti<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>DECCA<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>9.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1991<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>The dock of the bay<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Otis Redding<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>USA<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Stax Records<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>7.90<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1968<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Picture book<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Simply Red<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>EU<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>Elektra<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>7.20<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1985<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Red<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>The Communards<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>UK<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>London<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>7.80<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1987<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n    <\/span><CD><\/span><\/span>\n        <\/span><TITLE><\/span>Unchain my heart<\/span><\/TITLE><\/span><\/span>\n        <\/span><ARTIST><\/span>Joe Cocker<\/span><\/ARTIST><\/span><\/span>\n        <\/span><COUNTRY><\/span>USA<\/span><\/COUNTRY><\/span><\/span>\n        <\/span><COMPANY><\/span>EMI<\/span><\/COMPANY><\/span><\/span>\n        <\/span><PRICE><\/span>8.20<\/span><\/PRICE><\/span><\/span>\n        <\/span><YEAR><\/span>1987<\/span><\/YEAR><\/span><\/span>\n    <\/span><\/CD><\/span><\/span>\n<\/CATALOG><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Start by importing the xml.etree.ElementTree function.
Then define a function to parse a xml file.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
import<\/span> xml<\/span>.<\/span>etree<\/span>.<\/span>ElementTree <\/span>as<\/span> ET<\/span><\/span>\n<\/span>\ndef<\/span> <\/span>parse_xml<\/span>(<\/span>file<\/span>):<\/span><\/span>\n    <\/span># Parse the xml file<\/span><\/span>\n    tree <\/span>=<\/span> ET<\/span>.<\/span>parse<\/span>(<\/span>file<\/span>)<\/span><\/span>\n    <\/span># Get the root of the xml file<\/span><\/span>\n    root <\/span>=<\/span> tree<\/span>.<\/span>getroot<\/span>()<\/span><\/span>\n<\/span>\n    <\/span># Using list comprehension, you can make a list like this:<\/span><\/span>\n    <\/span># Get all 'CD' elements with 'COUNTRY' tag = UK<\/span><\/span>\n    uk <\/span>=<\/span> <\/span>[<\/span>c <\/span>for<\/span> c <\/span>in<\/span> root<\/span>.<\/span>findall<\/span>(<\/span>'<\/span>CD<\/span>'<\/span>)<\/span> <\/span>if<\/span> c<\/span>.<\/span>find<\/span>(<\/span>'<\/span>COUNTRY<\/span>'<\/span>).<\/span>text <\/span>==<\/span> <\/span>'<\/span>UK<\/span>'<\/span>]<\/span><\/span>\n    <\/span><\/span>\n    <\/span># Next, let's print the title, artist and year for all the cd elements found.<\/span><\/span>\n    <\/span>for<\/span> cd <\/span>in<\/span> uk<\/span>:<\/span><\/span>\n        <\/span>print<\/span>(<\/span>f<\/span>"Title: <\/span>{<\/span>cd<\/span>.<\/span>find<\/span>(<\/span>'<\/span>TITLE<\/span>'<\/span>).<\/span>text<\/span>}<\/span>, Artist: <\/span>{<\/span>cd<\/span>.<\/span>find<\/span>(<\/span>'<\/span>ARTIST<\/span>'<\/span>).<\/span>text<\/span>}<\/span>, Year: <\/span>{<\/span>cd<\/span>.<\/span>find<\/span>(<\/span>'<\/span>YEAR<\/span>'<\/span>).<\/span>text<\/span>}<\/span>"<\/span>)<\/span><\/span>\n<\/span>\n# Run the script<\/span><\/span>\nif<\/span> __name__ <\/span>==<\/span> <\/span>'<\/span>__main__<\/span>'<\/span>:<\/span><\/span>\n    <\/span>parse_xml<\/span>(<\/span>'<\/span>.\/xml\/catalog.xml<\/span>'<\/span>)<\/span><\/span>\n    <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The expected output would be something along these lines:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
Title:<\/span> <\/span>Hide<\/span> <\/span>your<\/span> <\/span>heart,<\/span> <\/span>Artist:<\/span> <\/span>Bonnie<\/span> <\/span>Tyler,<\/span> <\/span>Year:<\/span> <\/span>1988<\/span><\/span>\nTitle:<\/span> <\/span>Still<\/span> <\/span>got<\/span> <\/span>the<\/span> <\/span>blues,<\/span> <\/span>Artist:<\/span> <\/span>Gary<\/span> <\/span>Moore,<\/span> <\/span>Year:<\/span> <\/span>1990<\/span><\/span>\nTitle:<\/span> <\/span>One<\/span> <\/span>night<\/span> <\/span>only,<\/span> <\/span>Artist:<\/span> <\/span>Bee<\/span> <\/span>Gees,<\/span> <\/span>Year:<\/span> <\/span>1998<\/span><\/span>\nTitle:<\/span> <\/span>Sylvias<\/span> <\/span>Mother,<\/span> <\/span>Artist:<\/span> <\/span>Dr.Hook,<\/span> <\/span>Year:<\/span> <\/span>1973<\/span><\/span>\nTitle:<\/span> <\/span>Maggie<\/span> <\/span>May,<\/span> <\/span>Artist:<\/span> <\/span>Rod<\/span> <\/span>Stewart,<\/span> <\/span>Year:<\/span> <\/span>1990<\/span><\/span>\nTitle:<\/span> <\/span>For<\/span> <\/span>the<\/span> <\/span>good<\/span> <\/span>times,<\/span> <\/span>Artist:<\/span> <\/span>Kenny<\/span> <\/span>Rogers,<\/span> <\/span>Year:<\/span> <\/span>1995<\/span><\/span>\nTitle:<\/span> <\/span>Tupelo<\/span> <\/span>Honey,<\/span> <\/span>Artist:<\/span> <\/span>Van<\/span> <\/span>Morrison,<\/span> <\/span>Year:<\/span> <\/span>1971<\/span><\/span>\nTitle:<\/span> <\/span>The<\/span> <\/span>very<\/span> <\/span>best<\/span> <\/span>of,<\/span> <\/span>Artist:<\/span> <\/span>Cat<\/span> <\/span>Stevens,<\/span> <\/span>Year:<\/span> <\/span>1990<\/span><\/span>\nTitle:<\/span> <\/span>Stop,<\/span> <\/span>Artist:<\/span> <\/span>Sam<\/span> <\/span>Brown,<\/span> <\/span>Year:<\/span> <\/span>1988<\/span><\/span>\nTitle:<\/span> <\/span>Bridge<\/span> <\/span>of<\/span> <\/span>Spies,<\/span> <\/span>Artist:<\/span> <\/span>T<\/span>'<\/span>Pau, Year: 1987<\/span><\/span>\nTitle: Private Dancer, Artist: Tina Turner, Year: 1983<\/span><\/span>\nTitle: Pavarotti Gala Concert, Artist: Luciano Pavarotti, Year: 1991<\/span><\/span>\nTitle: Red, Artist: The Communards, Year: 1987<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\n\n\n\n
That concludes this short introduction into parsing a xml document.
Happy coding, until the next time.<\/p>\n\n\n\n
Files for download.<\/p>\n\n\n\n
parse_xml.py<\/a>Download<\/a><\/div>\n\n\n\n
catalog.xml<\/a>Download<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"
Today I’m going to show you how you can relatively easy parse and extract data from xml files, using the standard xml module. The xml document we’ll be parsing has the following structure. Start by importing the xml.etree.ElementTree function.Then define a function to parse a xml file. The expected output would be something along these […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[16,19],"class_list":["post-42","post","type-post","status-publish","format-standard","hentry","category-programming","tag-python","tag-xml"],"_links":{"self":[{"href":"https:\/\/blog.lerk.ing\/index.php\/wp-json\/wp\/v2\/posts\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.lerk.ing\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.lerk.ing\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.lerk.ing\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.lerk.ing\/index.php\/wp-json\/wp\/v2\/comments?post=42"}],"version-history":[{"count":1,"href":"https:\/\/blog.lerk.ing\/index.php\/wp-json\/wp\/v2\/posts\/42\/revisions"}],"predecessor-version":[{"id":43,"href":"https:\/\/blog.lerk.ing\/index.php\/wp-json\/wp\/v2\/posts\/42\/revisions\/43"}],"wp:attachment":[{"href":"https:\/\/blog.lerk.ing\/index.php\/wp-json\/wp\/v2\/media?parent=42"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.lerk.ing\/index.php\/wp-json\/wp\/v2\/categories?post=42"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.lerk.ing\/index.php\/wp-json\/wp\/v2\/tags?post=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}