Python: Can not write to CSV file

Question

I have this snippet of Python code:

import csv

def analyse(csvFileToRead, csvFileToWrite):
    # open file to read
    openedCsvFileToRead = open(csvFileToRead)
    reader = csv.reader(openedCsvFileToRead)

    # open file to write
    openedCsvFileToWrite = open(csvFileToWrite)
    writer = csv.writer(openedCsvFileToWrite)

    for row in reader:
        date = row[8]
        if date[0] == "5":
            writer.writerow(row)

    # close file
    openedCsvFileToRead.close()
    openedCsvFileToWrite.close()

if __name__ == "__main__":
    analyse("mydata.csv", "mynewdata.csv")

when run using Python 3.4 I get the following error message:

Traceback (most recent call last):
  File "main.py", line 40, in <module>
    analyse("mydata.csv", "mynewdata.csv")
  File "main.py", line 25, in analyse
    writer.writerow(row)
io.UnsupportedOperation: not writable

What Am I doing wrong? I'm on Windows 7 64bit.

dano · Accepted Answer · 2014-06-30 17:50:25Z

13

You have to open the file in write mode:

openedCSvFileToWrite = open(csvFileToWrite, "w")

Note that in Python 2.x, the docs always use 'wb', rather than 'w'.

edited Jun 30, 2014 at 17:50

answered Jun 30, 2014 at 17:45

dano

95.5k21 gold badges234 silver badges231 bronze badges

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

2 Comments

Amani Over a year ago

thanks worked, I totally never thought of that. I really deserve a down vote.

pepr Over a year ago

@Amani: This is a correct question. If everyone understood everything, there would be no StackOverflow ;)

Collectives™ on Stack Overflow

Python: Can not write to CSV file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related