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())