CSV文件，需要提取数据，格式化数据并转换为xm

Question

这可能是一个非常简单的问题，但我只是回到python的世界。 我有一个.csv文件

FRAME, SEQID, CYCLE SEC, CYCLE COUNT, SIZE, GAMMA, GAIN0, GAIN1, GAIN2, GAIN3, GAIN4, GAIN5, SHUTTER0, SHUTTER1, SHUTTER2, SHUTTER3, SHUTTER4, SHUTTER5, LAT, LON, ALT, UTC
000000, 3371, 058, 0000, 3951616, 0.000, 64,64,64,64,64,64, 34,34,34,34,34,34, 52.53922000, 0.79127400, 48.300, 11:06:35.00
000001, 3372, 060, 0000, 3954176, 0.000, 64,64,64,64,64,64, 34,34,34,34,34,34, 52.53922033, 0.79127483, 48.400, 11:06:37.00
000002, 3373, 062, 0000, 3955200, 0.000, 64,64,64,64,64,64, 34,34,34,34,34,34, 52.53922050, 0.79127600, 48.400, 11:06:39.00

我需要提取'FRAME，LAT，LON'，然后将其格式化为.xml文件。在

^{pr2}$

就像我说的，可能是一个简单的问题，已经很久了。 提前谢谢。 保罗

Answer 1

您可以使用csv模块读取csv文件，ElementTree创建xml：

import csv
from xml.etree.ElementTree import Element, SubElement, tostring 


root = Element('viewpointlist')
with open('test.csv') as f:
    reader = csv.DictReader(f)
    for line in reader:
        child = SubElement(root, "viewpoint")

        element = SubElement(child, 'vpid')
        element.text = line['FRAME']
        element = SubElement(child, 'lat')
        element.text = line[' LAT']
        element = SubElement(child, 'lng')
        element.text = line[' LON']

print tostring(root)

打印（缩进以便于阅读）：

^{pr2}$