Try to read csv file from python programming

Question

I have kept csv file in D directory and trying to read that csv file using python programming. This is my code in python:

import csv

try:
     path = "D:\\abc.csv"
     with open("path", "rb") as csvfile:
         readCSV = csv.reader(csvfile, delimiter=',')
         for row in readCSV:
             print (row)    
except Exception, e:
    raise e

This is the error I am getting:

The current working directory is F:\
Traceback (most recent call last):
  File "F:\directory.py", line 16, in <module>
    raise e
IOError: [Errno 2] No such file or directory: 'path'

Possible duplicate of How do I read and write CSV files with Python? — Martin Thoma
– Martin Thoma, Commented Jan 11, 2017 at 7:55

agamagarwal · Accepted Answer · 2015-04-02 06:46:43Z

1

Remove the double quotes around path. Edit it to this:

with open(path, "rb") as csvfile:

answered Apr 2, 2015 at 6:46

agamagarwal

9887 silver badges17 bronze badges

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

Comments

Avinash Raj · Accepted Answer · 2015-04-02 06:59:49Z

1

You need to remove the double quotes around path. "path" is a string and in-order to get the value of path variable , you need to put the variable as it is, so that it got expanded.

with open(path, "rb") as csvfile:

edited Apr 2, 2015 at 6:59

answered Apr 2, 2015 at 6:46

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

Comments

Alex Fung · Accepted Answer · 2015-04-02 08:25:22Z

1

This line

with open("path", "rb") as csvfile:

should be

with open(path, "rb") as csvfile:

As any text in "" or '' in python would be consider as string type instead of variable.

edited Apr 2, 2015 at 8:25

answered Apr 2, 2015 at 6:47

Alex Fung

2,00615 silver badges21 bronze badges

2 Comments

mohammad khan Over a year ago

I have removed the double quotes around the path. Now i am getting following error: The current working directory is F:\ Traceback (most recent call last): File "F:\directory.py", line 16, in <module> raise e AttributeError: 'module' object has no attribute 'reader'

Alex Fung Over a year ago

I think you have named the python script as csv.py Check out this link Please avoid naming .py script with common library names such as csv,os,etc as python will think you are import the .py instead of the library

Collectives™ on Stack Overflow

Try to read csv file from python programming

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related