The Columbia/Boone County Public Health and Human Services performs safety inspections of every restaurant. The numbers of critical-violation and non-critical violation in the latest inspection can be explored in the map I produced: https://public.tableau.com/profile/publish/FinalProject_166/Howsafeistherestaurant#!/publish-confirm

How I made it:

1. I first used Python to scrape the data I want from The Columbia/Boone County Public Health and Human Services website.

2. I then used “agate” to analyze my data. According to my analysis, the median critical violation and median non-critical violation of Columbia restaurants are both 0, which is pretty good in general. El Tigre, a Mexican restaurant, had nine critical violations, ranking the first in the latest inspection. Among the top ten restaurants with the most critical violations, five are Asian restaurants.

In terms of non-critical violation, Chinese Wok Express ranked the first with a total of nine non-critical violations. Surprisingly, Kaldi’s Coffee ranked the fifth, which had five non-critical violations.

I then combined the critical and non-critical violations, and the data suggests that Chinese Wok Express ranked the first again with 14 violations in total. The top five unsafe restaurants consist of four Asian restaurants and one Mexican restaurant.

3. Finally, I made a restaurant map by using Tableau, and published it at: https://public.tableau.com/profile/publish/FinalProject_166/Howsafeistherestaurant#!/publish-confirm. I used the critical violation as a filter, as this is the most important part in the inspections.

Detailed steps and codes are available on my Github page.