XML文件解析

#-*-coding:utf-8-*-


#*********Author:段廷银***************
#*********Public Date:2018-04-19******


f=open("device_list.csv","r")


des=open("description.csv","r").read()
import re


rep = '''<DeviceID>(.*?)</DeviceID>
<Name>(.*?)</Name>'''
re_find =  re.findall(rep,des)


s_lon=""
s_lat=""
res=""
for line in f.readlines():


    info=line.split(",")
    device_name=info[1]
    lon=info[2]
    lat=info[3]
    sipid=""
    for i in re_find:
        if device_name == i[1]:
            sipid=i[0]
            break


    if sipid=="":
        print(device_name+":"+"NULL")
        continue


    res+= sipid +","+device_name+","+lon+","+lat+"\n"
    s_lon+="'"+sipid+"'"+" " + ":" + " " + lon + "\n"
    s_lat+="'"+sipid+"'"+" " + ":" + " " + lat + "\n"


fw_res=open("res.csv","w")
fw_res.write(res)
fw_res.close()


fw_lon=open("lon.yml","w")
fw_lon.write(s_lon)
fw_lon.close()


fw_lat=open("lat.yml","w")
fw_lat.write(s_lat)
fw_lat.close()