Blank rows resulting from simple csv script

John Machin sjmachin at lexicon.net
Tue Apr 24 20:28:53 EDT 2007


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.





More information about the Python-list mailing list