How could I convert a simple XML to CSV using Python?

Question

This is my XML file test.xml:

<nodes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://sumo.dlr.de/xsd/nodes_file.xsd">
    <node id="0" x="0.0" y="0.0" type="traffic_light"/> 
    <node id="1" x="0.0" y="500.0" type="priority"/> 
    <node id="2" x="500.0" y="0.0" type="priority"/> 
    <node id="3" x="0.0" y="-500.0" type="priority"/>
    <node id="4" x="-500.0" y="0.0" type="priority"/>

</nodes>

I want to convert it to a CSV file which contains the following columns: id, x, y, type. So it would be something like this:

id,x,y,type
0,0.0,0.0,traffic_light
1,0.0,500.0,priority
2,500.0,0.0,priority
3,0.0,-500.0,priority
4,-500.0,0.0,priority

How could I do it via Python? Thanks for your attention!

napuzba · Accepted Answer · 2018-09-13 06:01:27Z

2

use xml.etree.ElementTree and csv modules:

import xml.etree.ElementTree as et
import csv

tree = et.parse('node.xml')
nodes = tree.getroot()
with open('node.csv', 'w') as ff:
    cols = ['id','x','y','type']
    nodewriter = csv.writer(ff)
    nodewriter.writerow(cols)
    for node in nodes:
        values = [ node.attrib[kk] for kk in cols]
        nodewriter.writerow(values)

answered Sep 13, 2018 at 6:01

napuzba

6,3183 gold badges24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kekw Over a year ago

where does [kk] come from?

napuzba Over a year ago

@y.y see list comprehensions

Collectives™ on Stack Overflow

How could I convert a simple XML to CSV using Python?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related