Blank rows resulting from simple csv script

Michael Bentley michael at jedimindworks.com
Tue Apr 24 16:48:54 EDT 2007


On Apr 24, 2007, at 3:35 PM, Drew wrote:

> Hi all -
>
> I've written a simple script to read a .csv file and then write out
> rows to a new file only if the value in the 4th column is a 0. Here's
> the code:
>
> import csv
>
> reader = csv.reader(open('table_export.csv','rb'))
>
> writer = csv.writer(open('new_jazz.csv','w'))
>
> for row in reader:
>     if row[3] == '0':
>         writer.writerow(row)
>
> This is writing out the correct rows, however it is writing a blank
> row between each of the rows written out. Any ideas?

Write in binary mode.




More information about the Python-list mailing list