擅长:python、mysql、java
<p>这对Python很管用</p>
<pre><code>import csv
with open('path/to/input') as infile, open('path/to/output', 'w') as outfile:
outfile = csv.writer(outfile, delimiter='\t')
for time, *temps in csv.reader(infile, delimiter='\t'):
temps = [float(t) for t in temps if t!='0.0']
avg = sum(temps)/len(temps)
outfile.writerow([time, avg])
</code></pre>