Using Python to populate a csv file

Question

The following piece of code creates a CSV file, but every other line is blank. How can I prevent these linebreaks from happening?

import datetime
import time
import csv

i = 0
while i < 10:
    TempProbe = "78.12" 
    CurrentTime = time.strftime("%x")
    CurrentDate = time.strftime("%I:%M:%S")
    stringAll = TempProbe + "," + CurrentTime + "," + CurrentDate
    print(stringAll)
    file = open("outFile.csv", "a")
    csvWriter = csv.writer( file )
    csvWriter.writerow( [TempProbe, CurrentTime,CurrentDate] )
    file.close()
    i = i + 1
    time.sleep(1)

Works perfect for me as it is on 2.7

Alan Kavanagh
– Alan Kavanagh

2016-06-04 20:58:08 +00:00
Commented Jun 4, 2016 at 20:58 — Alan Kavanagh
– Alan Kavanagh, Commented Jun 4, 2016 at 20:58

Moses Koledoye · Accepted Answer · 2016-06-04 21:08:56Z

5

This is probably because the default line terminator is '\r\n'. You can correct this by passing lineterminator='\n' to your csv.writer object, like so:

csvWriter = csv.writer(file, lineterminator='\n')

P.S. Move this line out of your while loop to avoid destroying and recreating the file writer object.

edited Jun 4, 2016 at 21:08

answered Jun 4, 2016 at 20:55

Moses Koledoye

78.8k8 gold badges139 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Laszlowaty Over a year ago

I never understood while people are using csv library for saving files. Since *.csv files are simple text files, it's perfectly good (and faster) to just create a proper string and dump it into the file.

Moses Koledoye Over a year ago

I find the dictwriter of the csv module very handy. Much neater than dumping into the file directly. It even gets better when you need to open a tab delimited file.

Community · Accepted Answer · 2017-05-23 11:44:16Z

1

You need to set the lineterminator for your csvWriter, as in the code below.

csvWriter = csv.writer(file, lineterminator='\n')

For an explanation why, see: CSV file written with Python has blank lines between each row

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Jun 4, 2016 at 21:06

wschella

1811 silver badge6 bronze badges

Comments

Ajeet Shah · Accepted Answer · 2016-06-04 21:18:03Z

0

You can simply use the open function to write a csv file:

file = open("outFile.csv", "a")
file.write(stringAll+'\n')

Also, you should take the file open and close functions out of the loop.

answered Jun 4, 2016 at 21:18

Ajeet Shah

19.9k10 gold badges66 silver badges107 bronze badges

Comments

Merlin · Accepted Answer · 2016-06-04 21:29:39Z

0

Use this: 'ab' vs 'a',writes binary should fix the problem

file = open("outFile.csv", "ab")
csvWriter = csv.writer(file, lineterminator='\n' )

or this you dont need to open/close on every write :

file      = open("outFile.csv", "ab")
csvWriter = csv.writer(file, lineterminator='\n' )

i = 0
while i < 10:
    TempProbe = "78.12" 
    CurrentTime = time.strftime("%x")
    CurrentDate = time.strftime("%I:%M:%S")
    stringAll = TempProbe + "," + CurrentTime + "," + CurrentDate
    print(stringAll)
    csvWriter.writerow( [TempProbe, CurrentTime,CurrentDate] )   
    i = i + 1
    time.sleep(1)

file.close()

answered Jun 4, 2016 at 21:29

Merlin

25.9k44 gold badges141 silver badges213 bronze badges

Collectives™ on Stack Overflow

Using Python to populate a csv file

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related