VD-Info Parsing and Arrangement

Ed Chao

·

Follow

1 min read

·

Aug 6, 2020

--

Listen

Share

%%time
## statick informaiton of VDimport xml.etree.ElementTree as et
import pandas as pd
import itertools
from xml.etree.ElementTree import parsepath = 'D:/00_我在管院研究所的日子/97_ETC資料區/2019VD/'
file = 'vd_info_0000.xml'tree =  et.parse(path + file)
root = tree.getroot()level1 = [data for data in root.iter('Info')]
key_list = level1[0].keys()def attrib(key):
    temp = pd.DataFrame([level1[i].attrib[key]  for i in range(len(level1))], columns = [key])
    return temp
df = pd.concat([attrib(key) for key in key_list], axis = 1)
df.to_csv('vdInfo.csv', encoding = 'utf_8_sig', index = False)
df