Convert a XML file into a Dataframe with Python

Question

I need some help. I have an XML file that I need to convert the data into a dataframe with python in Jupyter Notebook to do some analytics prediction on it.this is some part of an XML file enter image description here

and there is my code: enter image description here

the problem is that I can get the name values but all the values for the start and duration are none. I tried with .get instead of .find but the name values got none as well.

Learn [how to use code block](http://stackoverflow.com/editing-help) to display code instead of image — Circle Hsiao, Oct 25 '18 at 02:10
See https://stackoverflow.com/questions/28259301/how-to-convert-an-xml-file-to-nice-pandas-dataframe — bbd108, Oct 25 '18 at 02:14

score 0 · Answer 1 · answered Oct 31 '18 at 13:26

Try with below code.

import xml.etree.ElementTree as ET
import pandas as pd
dfcols=['Name','Start','Duration']
df_xml=pd.DataFrame(columns=dfcols)
print(df_xml)
tree = ET.parse('test.xml')
for subchild in tree.getroot().findall('ScoreEvent'):
        Name=subchild.find('Name').text
        Start=float(subchild.find('Start').text)
        Duration=float(subchild.find('Duration').text)
        df_xml=df_xml.append(pd.DataFrame([[Name,Start,Duration]],columns=dfcols),ignore_index=True)
print(df_xml)

It worked for me

Convert a XML file into a Dataframe with Python

1 Answers1