how to remove blank lines from a csv file created using python

Question

We are creating a subfile from a big csv file. The subfile contains only those rows which have their first column's value as D1:

import csv
with open('input.csv', 'rb') as csvfile:

     reader = csv.reader(csvfile, delimiter='|', quotechar='|')

     writer1 = csv.writer(open('output.csv', 'w'), delimiter = ' ')

     for row in reader:
         a = row[0]
         row  =  '|'.join(row)
         if (a=='D1'):
                 writer1.writerow(row)

This code gives 2 issues:

1. A Blank line comes after every row in new csv file
2. Every word has extra spaces between it's letters. So, "Hello" becomes "H e l l o".

Answer 1

This code runs fine:

import csv
with open('input.csv', 'rb') as csvfile:

     reader = csv.reader(csvfile, delimiter='|', quotechar='|')

     writer1 = csv.writer(open('output.csv', 'wb'), delimiter = '|')

     for row in reader:
         a = row[0]
         if (a=='D1'):
                 writer1.writerow(row)

Thanks to Pedru

Answer 2

From python csv docs..

import csv
with open('eggs.csv', 'w', newline='') as csvfile:
    spamwriter = csv.writer(csvfile, delimiter=' ',
                            quotechar='|', quoting=csv.QUOTE_MINIMAL)
    spamwriter.writerow(['Spam'] * 5 + ['Baked Beans'])
    spamwriter.writerow(['Spam', 'Lovely Spam', 'Wonderful Spam'])

So it seems that You have to use lists ['Spam'] with spamwriter.writerow... If its not list, this method writerow is creating its own list from iterable input like this:

>>> a = 'ala ma kota'
>>> list(a)
['a', 'l', 'a', ' ', 'm', 'a', ' ', 'k', 'o', 't', 'a']