Converting tuple to int in python

Question

I have a query which returns a tuple and I'm trying to convert the first value from that tuple to a int but it always gives me this error: TypeError: int() argument must be a string, a bytes-like object or a number, not 'tuple'

I don't understand why it's doing this because the returned values looks like this: [(25,)]

Here is the code:

cursor.execute("SELECT temp FROM temperatures WHERE datetimetest = ?", [datenow])
    currentTemp = cursor.fetchall()
    print(currentTemp) # this gives me [(25,)]
    convertedTemp = int(currentTemp[0])

[(25,)] is a list containing a tuple (1 length tuple) OF an int. do not try to convert, just access it using var[0][0] — Paritosh Singh
– Paritosh Singh, Commented Dec 13, 2018 at 19:42

MCO · Accepted Answer · 2018-12-13 19:43:08Z

6

because [(25,)] is actually an int inside a tuple inside a list - so the correct call to get the int would be currentTemp[0][0]

answered Dec 13, 2018 at 19:43

MCO

1,3151 gold badge13 silver badges21 bronze badges

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

1 Comment

Truica Sorin Over a year ago

Oh now i understand! I'm kind of new to python so i didn't knew that:( Thanks for helping me!

Abdulwahab Alhendi · Accepted Answer · 2020-06-06 08:50:27Z

0

You can convert list of tuples to list of integers

query = "some query that gets list of integers"
cursor.execute(query)
values = cursor.fetchall()

# values now looks like : [(1,), (2,), (3,)] 

i = 0
for v in values:
    values[i] = v[0]
    i += 1

# values now looks like : [1, 2, 3]

answered Jun 6, 2020 at 8:50

Abdulwahab Alhendi

111 bronze badge

Collectives™ on Stack Overflow

Converting tuple to int in python

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related