Import CSV into Database using Pymysql Python 3

Question

I couldn't understand while file is not considered by the interpreter

csv_data = csv.reader(file('D:\\Eclipse_Python\\Python\\com\\praveen\\pandas\\iplStats.csv'))

for row in csv_data:
    print(row)
    cur.execute('PREPARE stmt FROM INSERT INTO praveendb.iplstats (Wins,Losses,Year,Loss,Team) VALUES(?,?,?,?,?)', row)

ERROR:

Traceback (most recent call last):
  File "D:\Eclipse_Python\Python\pandasLibDataFrame.py", line 28, in <module>
    csv_data = csv.reader(file('D:\\Eclipse_Python\\Python\\pandas\\iplStats.csv'))
NameError: name 'file' is not defined

backtrack · Accepted Answer · 2018-12-04 10:20:33Z

1

I assume you are suing Python 3. If you are using Python 3. File() is not availabe instead use open()

import csv

with open('yourfile.csv') as csv_file:
    do you code

edited Dec 4, 2018 at 10:20

answered Dec 4, 2018 at 10:15

backtrack

8,1545 gold badges56 silver badges103 bronze badges

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

1 Comment

buran Over a year ago

in addition to what @Backtrack said, use with context manager - both for reading the file and connecting to the database

Collectives™ on Stack Overflow

Import CSV into Database using Pymysql Python 3

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related