NoSQL-Challenge

Table of Content

• NoSQL_set_up_JAdiong.ipynb
• NoSQL_analysis_JAdiong.ipynb
• Resources folder

References of code sourced from

• Monash Lesson Plans - NoSQL-Databases
• AskBCs Sunshine - assisted in generating code for the RatingValue. Unable to change data type to Integer without setting all non 1-5 rating values to value to Null. Following code generated by Sunshine

start code

Set non 1-5 Rating Values to Null

non_ratings = ["AwaitingInspection", "Awaiting Inspection", "AwaitingPublication", "Pass", "Exempt"] establishments.update_many({"RatingValue": {"$in": non_ratings}}, [ {'$set':{ "RatingValue" : None}} ])

end code

• ASKBCs Liang - assisted in generating following code to identify top 5 establishments with a rating value of 5 nearest to the new restaurant "Penang Flavours"

start code

query = {'RatingValue': {'$eq': 5}, 'geocode.latitude': {'$lte': degree_search + latitude, '$gte': latitude - degree_search}, 'geocode.longitude': {'$lte': degree_search + longitude, '$gte': longitude - degree_search} }

end code