Not able to read CSV file in python

Question

I am trying to Import CSV file in python but I am getting following error while doing it.

import csv
with open('retlvl2.csv', 'rb') as csvfile:
    spamreader = csv.reader(csvfile, delimiter=' ', quotechar='|')
    for row in spamreader:
        print ', '.join(row)
  **File "<ipython-input-12-82caba3702b8>", line 4
    print ', '.join(row)
             ^
SyntaxError: invalid syntax**

Can anyone help on this, please?

The **File "<ipython-input-12-82caba3702b8>", line 4, is indeed invalid syntax. It looks like something copied from an error message? — Kendas
– Kendas, Commented Apr 2, 2018 at 7:26

Lauro Bravar · Accepted Answer · 2018-04-02 07:28:19Z

3

If you are using Python 3 you should add parenthesis to your print declaration:

print(', '.join(row))

answered Apr 2, 2018 at 7:28

Lauro Bravar

3732 silver badges9 bronze badges

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

2 Comments

jezrael Over a year ago

Thak you for delete answer :)+30

yoselyn itb varela torres Oct 20 at 15:23

thanksss I just had the same problem

Daniel McLaury · Accepted Answer · 2018-04-02 07:27:28Z

2

Probably you're trying to use python2 syntax in python3. print needs parentheses in python3.

answered Apr 2, 2018 at 7:27

Daniel McLaury

4,4641 gold badge18 silver badges45 bronze badges

Comments

Pabasara Ranathunga · Accepted Answer · 2018-04-02 07:29:23Z

1

Try with parenthesis, What is your python version???

print (', '.join(row))

answered Apr 2, 2018 at 7:29

Pabasara Ranathunga

1701 gold badge2 silver badges18 bronze badges

3 Comments

Ghanshyam Savaliya Over a year ago

Thanks for the input. its Python 3.6.4 32 Bits.

Ghanshyam Savaliya Over a year ago

but even after that, I am getting an error  with open('retlvl2.csv', 'rb') as csvfile:     spamreader = csv.reader(csvfile, delimiter=' ', quotechar='|')     for row in spamreader:         print (', '.join(row))          Traceback (most recent call last):    File "<ipython-input-13-cd38e3cb57f8>", line 3, in <module>     for row in spamreader:

Error: iterator should return strings, not bytes (did you open the file in text mode?)

Pabasara Ranathunga Over a year ago

you have opened the file in 'rb' [read the file in binary] mode. Replace 'rb' with 'rt', it will work fine :-)

nghiep truong · Accepted Answer · 2018-04-02 07:50:45Z

0

I think the problem comes from your csv file. Lines can end in '\n', '\r', or '\r\n',.. You should try this

with open('C:\Test\example.csv', newline='') as csvfile:

with open('C:\Test\example.csv', newline='\n') as csvfile:

...

I am not sure but you should try.

answered Apr 2, 2018 at 7:50

nghiep truong

3103 silver badges8 bronze badges

Collectives™ on Stack Overflow

Not able to read CSV file in python

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Related