Dictionary output is not as expected in PYTHON

Question

Here prsnson.result contains the data which are comming from an query. I want the expected output, but its not coming. I am using python 2.5

for row in prsnobj.result:
    ansdb = {row[0] : row[1]}
    print ansdb

Actual: {1L: 3L} {2L: 4L} {3L: 2L} {4L: 2L} {5L: 2L}

Expected: {1: 3, 2: 4, 3: 2, 4: 2, 5: 2}

Related: In dictionary output is not getting as expected in PYTHON — Ashwini Chaudhary
– Ashwini Chaudhary, Commented Dec 10, 2013 at 6:28

Henrik Andersson · Accepted Answer · 2013-12-10 06:36:49Z

1

Integers fetched from a database is commonly returned as Long when utilizing the different database interfaces.

If you want the output you're after

ansdb = {}
for row in prsnobj.result:
    ansdb[int(row[0])] = int(row[1])

Perhaps the MySQL documentation for Python could help clear things up

edited Dec 10, 2013 at 6:36

answered Dec 10, 2013 at 6:29

Henrik Andersson

47.5k16 gold badges102 silver badges94 bronze badges

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

4 Comments

Ashwini Chaudhary Over a year ago

OP wants a single dict, not multiple dicts.

markmnl Over a year ago

I wouldn't say always - it depends on the interface you are using

Amy Over a year ago

yes i dont want multiple dictionary...i want is all in one dictionary

Henrik Andersson Over a year ago

Man, people here are starting to get lazy. One would think that the actual problem was getting ints from the longs and appending unique keys to a dict would be the easy task.

tdolydong · Accepted Answer · 2013-12-10 06:34:01Z

0

for row in prsnobj.result:
    ansdb = {int(row[0]) : int(row[1])}
print ansdb

you result type is long， you should tranfer to int

answered Dec 10, 2013 at 6:34

tdolydong

8586 silver badges8 bronze badges

1 Comment

Amy Over a year ago

i dnt want multiple dictionary

AaronB · Accepted Answer · 2013-12-10 06:42:37Z

0

All the L means is that it's in long integer (64-bit) form, so your returned value is indeed still correct. When you create a new dictionary with entries already in there (as you are), it's going to automatically convert all of the entries to long form; instead you should use a tuple or simply print each one in the loop itself:

for row in prsnobj.result:
    print row[0] + " : " + row[1]

or

for row in prsnobj.result:
    ansdb = (row[0], row[1])
    print ansdb

Depending on how your prsnobj object was defined, you may end up getting long integers still. If so, you need to look back at the code that defines prsnobj and check that it was created properly. Use printouts to make sure that the object is always in the state that you want it to be in!

edited Dec 10, 2013 at 6:42

answered Dec 10, 2013 at 6:29

AaronB

3061 silver badge4 bronze badges

Collectives™ on Stack Overflow

Dictionary output is not as expected in PYTHON

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related