Python Business Intelligence Cookbook

Retrieving multiple records using PyMongo

In order to produce a list view on a web page, or to pull more than a single record out of MongoDB, say, for analysis, you will need to query for multiple records.

Getting ready

PyMongo provides a find() function that we can use to search for multiple documents that match a given criteria, returning a cursor instance that we can iterate over.

How to do it…

from pymongo import MongoClient
client = MongoClient('localhost', 27017)
db = client.pythonbicookbook
accidents = db.accidents
# Retrieve all records where the accident happened on a Friday
data = accidents.find({"Day_of_Week": 7})
# Show a count for the result
data.count() # returns 896218

How it works…

The find() function is a powerful method for filtering ...