Not enough argument for format string while importing csv into MySQL database

Question

Full Traceback:
 File "./csvimportdb.py", line 12, in <module>
    cursor.execute('''INSERT INTO newsletter_subscriber(id, name, email ) VALUES("%s", "%s", "%s")''', row)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 159, in execute
    query = query % db.literal(args)
TypeError: not enough arguments for format string

My Code:

#!/usr/bin/python

import csv
import MySQLdb

mydb = MySQLdb.connect(host='localhost', user='english', passwd='english', db='english_mez')
cursor = mydb.cursor()

csv_data = csv.reader(file('final.csv'))
for row in csv_data:

    cursor.execute('INSERT INTO newsletter_subscriber(id, name, email )' 'VALUES("%s", "%s", "%s")', row[0], row[1], row[2])
#close the connection to the database.
mydb.commit()
cursor.close()
print "Done"

I need to pass row, row, row to make it right but can't do that. How to fix?

Edit: Printing row gives:

['6630\tCarmen Rocche\[email protected]\t\t\t\t\t']
['6631\tSuhasini\[email protected]\t\t\t\t\t']
['6632\tAmarjeet \[email protected]\t\t\t\t\t']
['6633\tFazali Hadi\[email protected]\t\t\t\t\t']
['6634\tVishaka Samarakone\[email protected]\t\t\t\t\t']
['6635\tLoemongga\[email protected]\t\t\t\t\t']

i updated the answer. you need data=row[0].split('\t') because it is not comma seperated, rather it is tab seperated — suhailvs
– suhailvs, Commented Nov 26, 2013 at 7:15

suhailvs · Accepted Answer · 2013-11-26 07:44:31Z

1

for row in csv_data:
    data=row[0].split('\t')
    if len(data) < 4: continue
    query="""insert into newsletter_subscriber (id, name, email) values 
      (%d, '%s', '%s')""" %(int(data[0]), data[1], data[2])
    cursor.execute(query)

edited Nov 26, 2013 at 7:44

answered Nov 26, 2013 at 7:07

suhailvs

21.9k15 gold badges104 silver badges104 bronze badges

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

6 Comments

pynovice Over a year ago

Already tried it, list index out of range error. I am updating question with csv content.

pynovice Over a year ago

Nope,

cursor.execute("insert into newsletter_subscriber(id, name, email) values (?, ?, ?)", (data[0], data[1], data[2]))   File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 159,

in execute` query = query % db.literal(args) TypeError: not all arguments converted during string formatting`

suhailvs Over a year ago

@user2032220 try (int(data[0]), data[1], data[2]))

suhailvs Over a year ago

@user2032220 i updated answer. i don't know what is the problem sorry :(

pynovice Over a year ago

tried that which results in

query="""insert into newsletter_subscriber(id, name, email) values(%d, '%s', '%s')""" %(int(data[0]), data[1], data[2]) IndexError: list index out of range

`

|

Collectives™ on Stack Overflow

Not enough argument for format string while importing csv into MySQL database

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related