ML_Proj_Example.py

import pymongo
from pprint import pprint

mc = pymongo.MongoClient("localhost", 27017)

db = mc['yelp']

doctor = db.businesses.find_one()

reviews_on_business = db.reviews.find({"business_id" : doctor["business_id"]})

r = [x for x in reviews_on_business]

print sum([x['stars'] for x in r]) / len(r)

new_b = [x for x in db.businesses.find().limit(5)]

print new_b[2]
print "RATING", new_b[2]["stars"]

new_b_id = new_b[2]['business_id']

reviews_new = [x for x in db.reviews.find({"business_id" : new_b_id})]

print len(reviews_new)

print sum([x["stars"] for x in reviews_new]) / float(5)

amount_without_reviews = 0

bs = [x['business_id'] for x in db.businesses.find({},{'business_id':True})]
reviews = db.reviews.find({"business_id":{"$in":bs}})

print len([r for r in reviews])