CCCPaste

xml_parse_przyklad

import xml.etree.ElementTree as ET
import pandas as pd

mytree = ET.parse('plik_xml.xml')
myroot = mytree.getroot()

for i, item in enumerate(myroot):
    print(i, item.tag)

len  = len(myroot[6].findall('run'))        
all_runs_list = [ [] for x in range(len)] 

for n in range(len):
    for i in myroot[6].findall('run')[n]:
        all_runs_list[n].append(i.attrib)

for k in range(len):
    pd.DataFrame(all_runs_list[k]).to_csv('output{}.csv'.format(k), float_format='%.3f')       
    
df1 = pd.read_csv('output0.csv')
df2 = pd.read_csv('output1.csv')

columns = ['number', 'depth', 'A', 'B', 'T', 'H', 'V', 'S']

df_1 = df1.copy()
df_2 = df2.copy()

print(df_1[columns].reset_index())
print(df_2[columns].reset_index())