Book a Demo!
CoCalc Logo Icon
StoreFeaturesDocsShareSupportNewsAboutPoliciesSign UpSign In
wesm
GitHub Repository: wesm/pydata-book
Path: blob/3rd-edition/datasets/mta_perf/parse.py
1797 views
1
from pandas import DataFrame
2
from lxml import objectify
3
4
path = 'Performance_MNR.xml'
5
parsed = objectify.parse(open(path))
6
root = parsed.getroot()
7
8
data = []
9
10
for elt in root.INDICATOR:
11
el_data = {}
12
for child in elt.getchildren():
13
el_data[child.tag] = child.pyval
14
data.append(el_data)
15
16
perf = DataFrame(data)
17
18