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

convert xml to dataframe python

Mr. Ghost answered on March 2, 2022 Popularity 9/10 Helpfulness 8/10

answer convert xml to dataframe python

related xml to dataframe python

convert xml to dataframe python

Comment

XML_file = 'file.xml' 
df = pd.DataFrame(XMl_file)

Popularity 9/10 Helpfulness 8/10 Language python

Source: Grepper

Tags: dataframe python xml

Link to this answer
Share Copy Link

Contributed on Mar 02 2022

Mr. Ghost

0 Answers Avg Quality 2/10

Closely Related Answers

xml to dataframe python

Comment

import pandas as pd 
df = pd.read_xml("filename.xml")

Popularity 7/10 Helpfulness 5/10 Language python

Source: Grepper

Tags: dataframe python xml xm

Link to this answer
Share Copy Link

Contributed on Jan 27 2023

Innocent Iguana

0 Answers Avg Quality 2/10

xml to dataframe python

Comment

import pandas as pd 
import xml.etree.ElementTree as et 

xtree = et.parse("students.xml")
xroot = xtree.getroot() 

df_cols = ["name", "email", "grade", "age"]
rows = []

for node in xroot: 
    s_name = node.attrib.get("name")
    s_mail = node.find("email").text # if node is not None else None
    s_grade = node.find("grade").text # if node is not None else None
    s_age = node.find("age").text # if node is not None else None
    
    rows.append({"name": s_name, "email": s_mail, 
                 "grade": s_grade, "age": s_age})

out_df = pd.DataFrame(rows, columns = df_cols)

Popularity 7/10 Helpfulness 3/10 Language python

Source: medium.com

Tags: dataframe python xml

Link to this answer
Share Copy Link

Contributed on Jan 27 2023

Innocent Iguana

0 Answers Avg Quality 2/10

convert xml to dataframe python

Contents

More Related Answers

convert xml to dataframe python

Closely Related Answers

xml to dataframe python

xml to dataframe python

Grepper

Documentation

Social

Legal

Contact

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