UK Food Standards Agency Ratings Data Evaluation (NoSQL)

Data Analysis Project - UK Food Standards Agency:

Database and Jupyter Notebook Set Up:
● Successfully imported establishments data from establishments.json into MongoDB using the uk_food database and establishments collection.
● Utilized PyMongo and Pretty Print libraries for data manipulation and visualization in Jupyter Notebook.
● Confirmed the proper setup by listing databases, ensuring uk_food is present, and verifying the establishments collection.

Update the Database:
● Incorporated a new halal restaurant, "Penang Flavours," in Greenwich, London, with the required information.
● Identified and returned the BusinessTypeID for "Restaurant/Cafe/Canteen."
● Updated the new restaurant entry with the acquired BusinessTypeID.
● Removed establishments within the Dover Local Authority as per the magazine's request.
● Converted latitude, longitude, and RatingValue to decimal and integer numbers using update_many.

Exploratory Analysis:
● Addressed specific questions posed by Eat Safe, Love to aid their decision-making process.
● Explored establishments with a hygiene score equal to 20, identified establishments in London with RatingValue greater than or equal to 4.
● Determined the top 5 establishments with a RatingValue of 5, sorted by the lowest hygiene score, nearest to "Penang Flavours."
● Conducted an analysis of establishments in each Local Authority area with a hygiene score of 0, sorting the results from highest to lowest.

Results Presentation:
● Compiled and presented results using count_documents, pprint, and Pandas DataFrame for clear understanding.
● Delivered actionable insights to assist Eat Safe, Love in focusing future articles on establishments meeting specific criteria.

Conclusion:
● Successfully met the magazine's requirements, showcasing advanced skills in MongoDB, data manipulation, and exploratory data analysis.
● Demonstrated the ability to address specific queries, clean data, and provide meaningful insights to support editorial decision-making.
● Contributed to Eat Safe, Love's objective of guiding journalists and food critics in identifying locations for future articles.