擅长:python、mysql、java
<p>我确信有更好的解决方案使用xml库,但这里有一个简单的解决方案</p>
<pre><code>import numpy as np
a = open('file.xml')
lines = a.readlines()
my_arr = np.zeros((len(lines)-2,2))
for i in range(len(lines[1:-1])):
contents=lines[i+1].split('\"')
my_arr[i,0]=(eval(contents[5]))
my_arr[i,1]=(eval(contents[9]))
#Now sort according to arrival times
my_arr = (my_arr[my_arr[:,0].argsort()])
print(my_arr)
final_output=[]
cum_dist=0
last_index=0
for i in range(int(my_arr[-1,0])+1):
if(i == my_arr[last_index,0]):
cum_dist+=my_arr[last_index,1]
last_index+=1
final_output.append(int(cum_dist))
print(final_output)
np.savetxt('outputfile.txt',np.array(final_output), newline=',',fmt='%s')
a.close()
</code></pre>
<p>您的输出是</p>
<pre><code>[[ 2. 3.]
[ 4. 5.]
[ 6. 2.]
[ 8. 1.]
[ 10. 4.]]
[0, 0, 3, 3, 8, 8, 10, 10, 11, 11, 15]
</code></pre>