Ad:

Python Discussion Thread
Marked Solved
Views: 7146

Oct 20th, 2009

TypeError: 'list' object is not callable

Expand Post »

I am trying to insert data from a text file into an SQL table. I'm getting this error:

"
csv_data = csv.reader(file('TxtFile1.txt', 'r'))
TypeError: 'list' object is not callable
"

Python Syntax (Toggle Plain Text)
import MySQLdb, csv, sys
conn = MySQLdb.connect (host = "localhost",user =
"a", passwd = "b",db = "c")
c = conn.cursor()
csv_data = csv.reader(file('TxtFile1.txt', 'r'))
for row in csv_data: print row
row = csv_data.next()
c.execute("INSERT INTO a (Category, Value) VALUES (%s, %s)", row)
#c.commit()
#c.close()
import MySQLdb, csv, sys
conn = MySQLdb.connect (host = "localhost",user =
"a", passwd = "b",db = "c")
c = conn.cursor()
csv_data = csv.reader(file('TxtFile1.txt', 'r'))
for row in csv_data: print row
row = csv_data.next()
c.execute("INSERT INTO a (Category, Value) VALUES (%s, %s)", row)
#c.commit()
#c.close()

I just want to know why this error is occurring and how it can be remedied. Any help would be great, thanks.

Similar Threads

Help with fixing "str object is not callable" error in Python
'file' object is not callable in Python
Annoying Student Plea for Help in Python
Urgent!!!!!!URGENTTTTT! in Python
os.execv() in Python

Shadow-Illusion

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jun 2008

Permalink

Oct 20th, 2009

Re: TypeError: 'list' object is not callable

Well it looks like you may be opening the file wrong, i don't know why is raising that error, you're not even using a list object. Try this:

Python Syntax (Toggle Plain Text)
import MySQLdb, csv, sys
conn = MySQLdb.connect (host = "localhost",user =
"a", passwd = "b",db = "c")
c = conn.cursor()
csv_data = csv.reader(file('TxtFile1.txt'))
for row in csv_data: print row
row = csv_data.next()
c.execute("INSERT INTO a (Category, Value) VALUES (%s, %s)", row)
#c.commit()
#c.close()
import MySQLdb, csv, sys
conn = MySQLdb.connect (host = "localhost",user =
"a", passwd = "b",db = "c")
c = conn.cursor()
csv_data = csv.reader(file('TxtFile1.txt'))
for row in csv_data: print row
row = csv_data.next()
c.execute("INSERT INTO a (Category, Value) VALUES (%s, %s)", row)
#c.commit()
#c.close()

I believe this should work, if not post back and we can try something else.

ov3rcl0ck

Reputation Points: 35

Solved Threads: 22

Junior Poster

Offline

113 posts
since Sep 2009

Permalink

Oct 20th, 2009

Re: TypeError: 'list' object is not callable

Quote ...

csv_data = csv.reader(open('TxtFile1.txt'))

This seems to have fixed the problem.

However im trying to input the rows from the textfile into a SQL table. The 'insert' statement isnt actually doing anything, any ideas to fix it?

The output of the textfile came out like:
['test one']
['test two']
['test three']

Shadow-Illusion

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jun 2008

Permalink

Oct 20th, 2009

Re: TypeError: 'list' object is not callable

You should uncomment your commit statement. You need to commit your transactions before they go through.

jlm699

Reputation Points: 355

Solved Threads: 292

Veteran Poster

Offline

1,102 posts
since Jul 2008

Permalink

Oct 20th, 2009

Re: TypeError: 'list' object is not callable

Click to Expand / Collapse Quote originally posted by jlm699 ...

You should uncomment your commit statement. You need to commit your transactions before they go through.

Yeah I'm aware of that, I uncomment it and try and commit to the DB when the code isn't showing errors.
This is the current code:

Python Syntax (Toggle Plain Text)
import MySQLdb, csv, sys
db = MySQLdb.connect(user="a", passwd="b", db = "c")
c = db.cursor()
# This statement works fine #c.execute ("INSERT INTO popularity (Category, Value) VALUES ('alpha', 'beta')")
csv_data = csv.reader(open('TxtFile1.txt', 'r'))
for row in csv_data:
    print row
    c.execute("INSERT INTO a (Category, Value) VALUES (%s, %s)", row)
import MySQLdb, csv, sys
db = MySQLdb.connect(user="a", passwd="b", db = "c")
c = db.cursor()
# This statement works fine #c.execute ("INSERT INTO popularity (Category, Value) VALUES ('alpha', 'beta')")
csv_data = csv.reader(open('TxtFile1.txt', 'r'))
for row in csv_data:
    print row
    c.execute("INSERT INTO a (Category, Value) VALUES (%s, %s)", row)

I think I need to replace '%s' with something, but I'm not sure on what exactly.

The print row command outputs:
['test one']

I want 'test' to go into Category and 'one' to go into Value.

Last edited by Shadow-Illusion; Oct 20th, 2009 at 10:25 pm.

Shadow-Illusion

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jun 2008

Permalink

Oct 20th, 2009

Re: TypeError: 'list' object is not callable

Click to Expand / Collapse Quote originally posted by Shadow-Illusion ...

The print row command outputs:
['test one']

I want 'test' to go into Category and 'one' to go into Value.

In that case you'll want this:

python Syntax (Toggle Plain Text)
    c.execute("INSERT INTO a (Category, Value) VALUES (%s, %s)", tuple(row[0].split()))
    c.execute("INSERT INTO a (Category, Value) VALUES (%s, %s)", tuple(row[0].split()))

Basically this takes the element [0], which represents that string 'test one', and then splits it (the default split delimiter is a space), so it turns it into ['test', 'one']. Finally, you just need to turn it into a tuple.

When doing string formatting, you need to have a tuple containing each argument for string formatting as an element. Here's an example of a string formatting requiring two arguments:

python Syntax (Toggle Plain Text)
>>> print 'Hey %s totally %s check' % ('test', 'one')
Hey test totally one check
>>>
>>> print 'Hey %s totally %s check' % ('test', 'one')
Hey test totally one check
>>>

As you can see, I need two things to fill into the %s pieces. The two elements in the tuple satisfy this requirement.

Here's the transformation from "row" to the tuple required in broken down steps:

python Syntax (Toggle Plain Text)
>>> row = ['test one']
>>> row[0]
'test one'
>>> row[0].split()
['test', 'one']
>>> tuple(row[0].split())
('test', 'one')
>>>
>>> row = ['test one']
>>> row[0]
'test one'
>>> row[0].split()
['test', 'one']
>>> tuple(row[0].split())
('test', 'one')
>>>

Last edited by jlm699; Oct 20th, 2009 at 11:25 pm.

jlm699

Reputation Points: 355

Solved Threads: 292

Veteran Poster

Offline

1,102 posts
since Jul 2008

Permalink

Oct 21st, 2009

Re: TypeError: 'list' object is not callable

Thanks jlm, that worked perfectly - everything is great now.
I just needed the spliting code at the end.

Thanks again ~ solved.

Shadow-Illusion

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jun 2008

Permalink

Oct 14th, 2010

Re: TypeError: 'list' object is not callable

Hi i am trying to count column k in the csv file and increment it if the next values is the same as the first value
for example,

p(ki) k sum(k)
0.117909 106 1
0.067853 61 1
0.048943 44 1
0.047831 43 3
0.047831 43
0.047831 43
0.046719 42 2
0.046719 42

Python Syntax (Toggle Plain Text)
 
import csv
 
 
#choosing the csv file to be imported
reader = csv.reader(open("NoOfCounts1.csv","r"))
 
#this will print the second cloumn in the dataset
 
nobracket = []
NoOfCounts = []
total = 0 
for urls,NoOfCounts in reader:
    #This is getting rid of the commas behind the numbers
    if NoOfCounts[-1] == ')':
           s2 =  NoOfCounts[:-1]
           s3 = int(s2)
           nobracket.append(s3)
           NoOfCounts = NoOfCounts[:-1]
           total  +=int(NoOfCounts[1])
 
print 'The total is =' ,total # the result
 
sortedk = sorted(nobracket)
 
# A new list to store  ki(s)
kilist = []
sumk = 0
prevk = thisk
counts =[(thisk,1)]
for thisk in sortedk:
    count = counts[-1][1]
    sumk += 1
    counts = [-1] (thisk,count)
else:
        print 'sum of k:',counts[-1]
        counts.append((thisk,1))
        prevk = thisk
 
 
 
for ki in nobracket:
    pki = ki/float(total) #converts the total to a floating number
   print pki,ki
   kilist.sort()
   kilist.append(kilist)
   print( '%f \t %d' %  (pki,ki))
 
 
   print ('%i \t %i')%(k,sum)
     
import csv


#choosing the csv file to be imported
reader = csv.reader(open("NoOfCounts1.csv","r"))

#this will print the second cloumn in the dataset

nobracket = []
NoOfCounts = []
total = 0 
for urls,NoOfCounts in reader:
    #This is getting rid of the commas behind the numbers
    if NoOfCounts[-1] == ')':
           s2 =  NoOfCounts[:-1]
           s3 = int(s2)
           nobracket.append(s3)
           NoOfCounts = NoOfCounts[:-1]
           total  +=int(NoOfCounts[1])

print 'The total is =' ,total # the result

sortedk = sorted(nobracket)

# A new list to store  ki(s)
kilist = []
sumk = 0
prevk = thisk
counts =[(thisk,1)]
for thisk in sortedk:
    count = counts[-1][1]
    sumk += 1
    counts = [-1] (thisk,count)
else:
        print 'sum of k:',counts[-1]
        counts.append((thisk,1))
        prevk = thisk
    
    
    
for ki in nobracket:
    pki = ki/float(total) #converts the total to a floating number
   print pki,ki
   kilist.sort()
   kilist.append(kilist)
   print( '%f \t %d' %  (pki,ki))


   print ('%i \t %i')%(k,sum)

this is the error i am getting at a moment

Traceback (most recent call last):
File "C:\Python26\First Experiment\pk2.py", line 34, in <module>
counts = [-1](thisk,count)
TypeError: 'list' object is not callable
>>>

djmagba

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Oct 2010

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Python Forum Timeline: How to change text file encoding with python?

Next Thread in Python Forum Timeline: String Letter-Counter Function Problems - Help Urgent!

DaniWeb Message

Cancel Changes

User Name
Password