How to get a single value from a pymongo query of a mongodb in python?

Question

I'm trying to use pymongo. Everything is ok so far, I can connect to mongodb, insert and make queries. The problem i'm facing is getting data from find() into a python array.

This is my code

>>> a = db.sensor.find({'sensor_id':3})
>>> a
<pymongo.cursor.Cursor object at 0x637f70>
>>> for bla in a:
...     print bla
... 
{u'date': datetime.datetime(2013, 3, 4, 21, 8, 23, 907000), u'_id': ObjectId('51350d4772ab8a691c370453'), u'sensor_id': 3, u'value': -1625.0}
{u'date': datetime.datetime(2013, 3, 4, 21, 20, 12, 694000), u'_id': ObjectId('5135100c72ab8a695b54a4f3'), u'sensor_id': 3, u'value': -1875.0}
{u'date': datetime.datetime(2013, 3, 4, 21, 22, 4, 985000), u'_id': ObjectId('5135107c72ab8a69851a5a95'), u'sensor_id': 3, u'value': -1812.0}
{u'date': datetime.datetime(2013, 3, 4, 21, 26, 11, 758000), u'_id': ObjectId('5135117372ab8a69b285b4c7'), u'sensor_id': 3, u'value': -1312.0}

Is there a way to make something like myValues[i] = bla.value?

teapot_of_wine · Accepted Answer · 2014-10-30 10:56:10Z

12

The "bla" is just a dictionary, so

myValues[i] = bla['value']

is what you are looking for.

edited Oct 30, 2014 at 10:56

answered Mar 10, 2013 at 8:42

teapot_of_wine

5363 silver badges18 bronze badges

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

Comments

PrabhuPrakash · Accepted Answer · 2016-10-25 10:44:20Z

0

a = db.sensor.find({'sensor_id':3})
#your values are in dictionary format..
for key, val in a.items():
     print(val)

if you want particular column value, try this..

a = db.sensor.find({'sensor_id':3})
#your values are in dictionary format..
for key, val in a.items():
    if 'date' in key:
       print(val) #now you got only date column values

answered Oct 25, 2016 at 10:44

PrabhuPrakash

2612 silver badges7 bronze badges

Collectives™ on Stack Overflow

How to get a single value from a pymongo query of a mongodb in python?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related