Blank rows resulting from simple csv script

[Drew]

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?

Thanks,
Drew

[Diez B. Roggisch]

Re: Blank rows resulting from simple csv script

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

[John Machin]

Re: Blank rows resulting from simple csv script

On 25/04/2007 6:17 AM, Diez B. Roggisch wrote:

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
>

Bzzzzt! *ALWAYS* use binary mode for both reading and writing.