擅长:python、mysql、java
<p>这应该计算平均值,忽略没有测量值的线</p>
<pre><code>with open('your_csv', 'rb') as f:
for i, l in enumerate(f):
if i == 0: continue
s_l = l.split(';')
last_3 = s_l[-3:]
if all(last_3):
last_3_floats = map(float, last_3)
avg = sum(last_3_floats )/len(last_3_floats)
print s_l[0] + ';' + str(avg)
</code></pre>
<p>p.S未测试</p>