擅长:python、mysql、java
<blockquote>
<p>This is iterating through the main file & write to a new file without
the cell 'Total'</p>
</blockquote>
<pre><code>f_original = open(fname, 'r')
f_new = open(fname+'_new.csv', 'w')
#iterate through the lines
for line in f_original:
if not line.startswith('Total'):
f_new.write(line)
f_original.close()
f_new.close()
</code></pre>
<blockquote>
<p>Thanks Lucas & Wilbur</p>
</blockquote>