wake-county-restaurants

A data science project analyzing sanitation scores for Wake County restaurants

Setup

1. Clone the repository

   git clone git@github.com:SharonY25/wake-county-restaurants.git
   cd wake-county-restaurants
   

2. If you need to keep your python environments isolated, set up a virtual environment

   virtualenv $(which python3) venv
   source venv/bin/activate
   pip install -r requirements.txt
   

   And when you're finished working in this environment,

   deactivate
   

3. Download the raw input data

   One of our raw data files is larger than GitHub's per-file limit (100MB), so we do not track our raw data in git.

   From Wake County Data, download:

   • Restaurants_in_Wake_County.csv
   • Food_Inspections.csv
   • Food_Inspection_Violations.csv

   to wake-county-restaurants/data

Running the project

To run the main data analysis module, run

python main.py

To download and save data from Yelp, first you need to get an API key from Yelp, and save it in a plain text file wake-county-restaurants/yelp_api_key. Then, run

python src/yelp.py

About the data

1. Restaurants: This table captures all active facilities where Wake County performs sanitations inspections.  Facilities that are closed are removed from all three files in this dataset.  Per NC State regulations, facilities that have a change in ownership are considered closed and the restaurant re-opens under a new permit, even if there is not a change in the name of the restaurant.
   

2. Food Inspections: This table captures all Wake County performs sanitations inspections at active restaurants since September 20, 2012
   

3. Food Inspection Violations: This table captures all violations identified during specific Wake County sanitations inspections at active restaurants since September 20, 2012.  It reports the results in code violations and according to CDC Risk Factors.  You can find additional information about the CDC Risk Factors on the FDA website: Retail Risk Factor Study