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

Read XML file to Pandas DataFrame

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

answer Read XML file to Pandas DataFrame

related Python: Extracting XML to DataFrame (Pandas)

Read XML file to Pandas DataFrame

Comment

from lxml import objectify
xml = objectify.parse('Document1.xml')
root = xml.getroot()

data=[]
for i in range(len(root.getchildren())):
    data.append([child.text for child in root.getchildren()[i].getchildren()])

df = pd.DataFrame(data).T
df.columns = ['bathrooms', 'price', 'property_id']

Popularity 10/10 Helpfulness 6/10 Language python

Source: stackoverflow.com

Tags: dataframe file pandas python xml

Link to this answer
Share Copy Link

Contributed on May 08 2022

Mappy Show

0 Answers Avg Quality 2/10

Closely Related Answers

Python: Extracting XML to DataFrame (Pandas)

Comment

path = 'AttributesXMLPandas.xml'
dfcols = ['ID', 'Text', 'CreationDate']

root = et.parse(path)
rows = root.findall('.//row')

# NESTED LIST
xml_data = [[row.get('Id'), row.get('Text'), row.get('CreationDate')] 
            for row in rows]

df_xml = pd.DataFrame(xml_data, columns=dfcols)

print(df_xml)

#   ID   Text             CreationDate
# 0  1  (...)  2011-08-30T21:15:28.063
# 1  2  (...)  2011-08-30T21:24:56.573
# 2  3  (...)                     None

Popularity 8/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on May 08 2022

Mappy Show

0 Answers Avg Quality 2/10

Read XML file to Pandas DataFrame

Contents

More Related Answers

Read XML file to Pandas DataFrame

Closely Related Answers

Python: Extracting XML to DataFrame (Pandas)

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.