[memo]
<?xml version="1.0" encoding="UTF-8"?> <StringTable> <StringEntry Id="1" Res="aaa"/> <StringEntry Id="2" Res="bbb"/> </StringTable>
<?xml version="1.0" encoding="UTF-8"?> <StringTable> <StringEntry Id="2" Res="BBB"/> <StringEntry Id="3" Res="ccc"/> </StringTable>
<?xml version="1.0" encoding="UTF-8"?> <StringTable> <StringEntry Id="2" Res="BBB"/> <StringEntry Id="3" Res="CCC"/> <StringEntry Id="4" Res="DDD"/> </StringTable>
import os import xml.etree.ElementTree as ET import pandas as pd files = [ r"sample1.xml", r"sample2.xml", r"sample3.xml" ] data = {} for f in files: tree = ET.parse(f) root = tree.getroot() a = root.iterfind("StringEntry") col = os.path.basename(f) entry = {} for c in a: entry[c.get("Id")] = c.get("Res") data[col] = entry df = pd.DataFrame( data)