Blank rows resulting from simple csv script

Diez B. Roggisch deets at nospam.web.de
Tue Apr 24 16:17:44 EDT 2007


Drew schrieb:
> 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?

The modes aren't compatible - either use rb, wb or r,w

Diez



More information about the Python-list mailing list