Click Here to view the repository
Repository

NoSQL Food Establishment Data Analysis

  • Objective

    Showcase proficiency in querying MongoDB databases and processing the results using Python, with a focus on evaluating UK food establishment hygiene ratings for a food magazine.

    Method

     Utilized MongoDB and PyMongo to import, query, and update a database of food establishments.  Converted query results into Pandas DataFrames for detailed analysis.  Performed various data manipulations and analyses, including filtering by hygiene scores and location, and updating data types.

    Findings

     Identified establishments with specific hygiene scores and high rating values in London.   Found the top establishments with a rating of 5 and lowest hygiene scores near the new restaurant "Penang Flavours."  Determined local authority areas with the highest number of establishments having a hygiene score of 0.

    Impact

     Provided valuable insights for "Eat Safe, Love" magazine, helping to guide their journalists and food critics in focusing their articles on noteworthy establishments.  Demonstrated effective use of NoSQL databases for real-world data analysis and decision-making.

    Challenges

     Managing and querying a large dataset efficiently.  Ensuring data integrity and accurate data type conversions.

    Tools Used

     Terminal  Jupyter lab  Anaconda  Pandas  Python  MongoDB