Breaking News: Grepper is joining You.com. Read the official announcement!

How to convert an XML file to nice pandas dataframe

Mappy Show answered on May 8, 2022 Popularity 3/10 Helpfulness 1/10

answer How to convert an XML file to nice pandas dataframe

How to convert an XML file to nice pandas dataframe

Comment

import pandas as pd
import xml.etree.ElementTree as ET
import io

def iter_docs(author):
    author_attr = author.attrib
    for doc in author.iter('document'):
        doc_dict = author_attr.copy()
        doc_dict.update(doc.attrib)
        doc_dict['data'] = doc.text
        yield doc_dict

xml_data = io.StringIO(u'''YOUR XML STRING HERE''')

etree = ET.parse(xml_data) #create an ElementTree object 
doc_df = pd.DataFrame(list(iter_docs(etree.getroot())))

Popularity 3/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: dataframe file nice pandas python xml

Link to this answer
Share Copy Link