XML to Python dataframe with nested tag structure

Asked Sep 03 '19 at 14:27

Active Sep 03 '19 at 15:27

Viewed 121 times

I have a massive XML in the structure as show in the picture below. I need to parse this into a dataframe. My Dataframe would contain columns such as FinInstrmGnlAttrbts_ID, FinInstrmGnlAttrbts_FullName, etc. I have no idea how to traverse XML tag structures in Python.

import xml.etree.ElementTree as et
_xt = et.parse("DLTINS_20171019_01of01.xml")
_xr = _xt.getroot()
_xr
for child in _xr:
    print (child.tag, child.attrib)

it gives me

{urn:iso:std:iso:20022:tech:xsd:head.003.001.01}Hdr {}
{urn:iso:std:iso:20022:tech:xsd:head.003.001.01}Pyld {}

edited Sep 03 '19 at 15:20

alex

6,818
9
52
103

asked Sep 03 '19 at 14:27

Varun

Oh no! What if a girl had just the right answer for you? – Mr Felix U Sep 03 '19 at 14:34
@MrFelixU Then I would say Merci Mademoiselle grandement apprécier to her. :) – Varun Sep 03 '19 at 14:48
Possible duplicate of [How do I parse XML in Python?](https://stackoverflow.com/questions/1912434/how-do-i-parse-xml-in-python) – alex Sep 03 '19 at 15:22
You can try [xmltodict](https://github.com/martinblech/xmltodict) or something else to "flatten" your XML. Search for "flatten XML Python" to find more. – Julien Palard Sep 03 '19 at 15:27
You do get some output. What is the problem with it? – mzjn Sep 06 '19 at 06:45

XML to Python dataframe with nested tag structure

0 Answers0