AttributeError: 'module' object has no attribute 'writer'

Question

I am trying to execute this following program to read csv file in sublime text2 gets error message "AttributeError: 'module' object has no attribute 'writer'" Any Solution.

import sys
import csv
def readcsv():
  f = open("F://xyz.csv",'r')
  readerr=csv.reader(f)
  for row in readerr():
      print row
  f.close()
readcsv()

FULL ERROR MESSAGE

The current working directory is F:\ Traceback (most recent call last): File "F:\readfiles.py", line 12, in readcsv()
File "F:\readfiles.py", line 7, in readcsv readerr=csv.reader(f) AttributeError: 'module' object has no attribute 'reader' [Finished in 1.4s with exit code 1]

So does this file actually exist? is f actually a valid file object? — EdChum
– EdChum, Commented Apr 17, 2015 at 10:58
Sorry the error is :AttributeError: 'module' object has no attribute 'reader' — mohammad khan
– mohammad khan, Commented Apr 17, 2015 at 10:58
You obviously have another module named csv in your sys.path - to know which one, just add a print csv line just after the import csv one. — bruno desthuilliers
– bruno desthuilliers, Commented Apr 17, 2015 at 11:00
Well aside from your error this line looks iffy: for row in readerr(): shouldn't it be for row in readerr:? — EdChum
– EdChum, Commented Apr 17, 2015 at 11:00

petezurich · Accepted Answer · 2019-06-11 11:06:48Z

4

Debugging steps:-

Ideally csv should have reader module. My best guess is you have some other module named csv which is being imported. Can you try the following on python console:-'

>>>import csv
>>>dir(csv)

If you do not find the reader, writer etc. modules, chances are you are importing a wrong module with same name. Now try >>>csv.__file__, Rename this file and follow previous step once again.

In general your code could look pythonic the following way:-

with open('csvfile.csv', 'rb') as csvfile:
     rows = csv.reader(csvfile)
     for row in rows:
         print row

edited Jun 11, 2019 at 11:06

petezurich

10.3k10 gold badges48 silver badges63 bronze badges

answered Apr 17, 2015 at 11:13

Barun Sharma

1,4682 gold badges15 silver badges20 bronze badges

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

Comments

searching_for_truth · Accepted Answer · 2015-04-17 15:51:21Z

0

The syntax is slightly off.

for row in readerr():

The parenthesis is function syntax. The command should only be acting on an object.

If you change that line to this, it will work for row in reader:

answered Apr 17, 2015 at 15:51

searching_for_truth

712 bronze badges

1 Comment

searching_for_truth Over a year ago

OOPS , the revised syntax did not make it into the answer for row in readerr:

Sahil Sharma · Accepted Answer · 2020-10-14 13:21:14Z

0

you must have named the file as csv.py, renaming it would troubleshoot the error.

answered Oct 14, 2020 at 13:21

Sahil Sharma

1

Comments

SwapnilTech · Accepted Answer · 2020-10-31 06:35:32Z

0

I had this same error and the reason was my file name was also called 'csv.py' Try changing it to something else and try again. Should work !! :)

answered Oct 31, 2020 at 6:35

SwapnilTech

1

Collectives™ on Stack Overflow

AttributeError: 'module' object has no attribute 'writer'

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related