CODEWITHSUNDEEP
pythonpython-2.7csv
sipher_z
sipher_z

Reputation: 1251

Generating CSV and blank line

I am generating and parsing CSV files and I'm noticing something odd.

When the CSV gets generated, there is always an empty line at the end, which is causing issues when subsequently parsing them.

My code to generate is as follows:

with open(file, 'wb') as fp:
    a = csv.writer(fp, delimiter=",", quoting=csv.QUOTE_NONE, quotechar='')
    a.writerow(["Id", "Builing", "Age", "Gender"])

    results = get_results()

    for val in results:
        if any(val):
            a.writerow(val)

It doesn't show up via the command line, but I do see it in my IDE/text editor

Does anyone know why it is doing this?

Could it be possible whitespace?

Upvotes: 2

Views: 84

Answers (1)

RobertB
RobertB

Reputation: 1929

Is the problem the line terminator? It could be as simple as changing one line:

a = csv.writer(fp, delimiter=",", quoting=csv.QUOTE_NONE, quotechar='', lineterminator='\n')

I suspect this is it since I know that csv.writer defaults to using carriage return + line feed ("\r\n") as the line terminator. The program you are using to read the file might be expecting just a line feed ("\n"). This is common in switching file back and forth between *nix and Windows.

If this doesn't work, then the program you are using to read the file seems to be expecting no line terminator for the last row, I'm not sure the csv module supports that. For that, you could write the csv to a StringIO, "strip()" it and then write that your file.

Also since you are not quoting anyting, is there a reason to use csv at all? Why not:

with open(file, 'wb') as fp:
    fp.write("\n".join( [ ",".join([ field for field in record ]) for record in get_results()]))

Upvotes: 1

Related Questions