Building your own data-driven food tour

Food touring has become my default mode of exploration during my travels. I believe food is one of the best ways to engage a culture and it’s unique traditions. What better way is there to do this than a well-crafted food tour? We hop from restaurant to restaurant, in a seemingly random geographic sense, ending up in a city’s lost corners among it’s real citizens. We get to try the food that excites the people that live in that place. Doing this helps me avoid tourist traps, expensive chains, and otherwise boring food. I see food as part of the destination, not a necessary evil to work in between museum tours. As with all other things, the food tour has become an outlet for my near obsession with data and achieving the best possible experience for my money. Within the budget I usually work with on vacations, this generally means using online research to create an efficient, frugal, and super delicious route of a few restaurants. I seek out the best food and hop around place grabbing small bites at each, preferably splitting with friends. At the end of the day we almost always have discovered new neighborhoods that “tourists” would not see, encountered many locals about their daily routine, and had some really amazing and affordable food. I recently scheduled one of these tours by bike in DC, and had some great success. I’ll break down how I did it and talk about how you can set your own up. I want to note that I’m still refining this method, but it’s certainly going to be much better than randomly walking into restaurants or even using a single service like Yelp for finding a place.  This method will work for any major city in the Western world and can be modified to fit your own personal preferences. For instance, I don’t like to eat the same cuisine at multiple places during a tour nor do I want to spend more than $10 at one place.

How to design your food tour based on data

  1. Choose your city, time-frame, and preferences.

The major questions you’ll have to answer here are:

How much freedom do you have over what you’ll be doing on this trip? Do your companions have dietary restrictions or preferences? Are they open to spending hours walking around eating? How long do you have in the city? A full food tour of 5-7 restaurants will likely take you 6 hours. Do you have that much time? What is your budget? What will the weather be like? How widely spaced is the city? Are there specific landmarks or neighborhoods you really ought to see?

Once you’ve answered these questions you can begin planning the tour itself. It’s a fun process.

2. Build a base list.

Find the website that has the most robust number of average ratings per restaurant for the city you’ll be visiting. In my case, for Washington DC, happens to be very strong. So that’s what we’ll be using. You may also consider Zomato, TripAdvisor, Zagat, Eater24, or Chowhound to build your base list. Once you’ve decided on a site, open up a new Excel spreadsheet or Google Sheet. Start by listing out the top 25 highest-rated restaurants in a column. Only choose places located within a reasonable distance of where you’ll be staying (~10 miles).

3. Verify that list with other sources

Since you’re a budding data scientist, you know that using data from a single sample is not good data management, especially when sites like Yelp can be heavily biased by confirmation bias and other research biases. Really, its kind of shocking how far off some seemingly statistically significant restaurant reviews can be. I’ve got all kinds of theories as to why this is the case, but I won’t get into that right now.

To verify the restaurants you have as being worthy of your food tour there a couple things you can do. First, plot out them on a map. This can be done pretty easily with Google Maps or within the Yelp site using the Map List feature. Remove all places from the list that are too far from your desired general area. For DC list meant avoiding places that were in Northern Virginia and MD. These were out of biking range and didn’t make sense for us.

Make sure you don’t have any coffee shops on the map. Yelpers really love and inflate a comfy coffee shop, but we don’t want them on our food tour. I also usually eliminate chains and hipstery-looking places that I know will be overpriced.

Now for the actual verification. This involves a bit of groundwork, but is totally worth it. In separate columns on your spreadsheet, list out the scores for your current list on Google Places (just Google the restaurant name), Zagat (I just use the food rating #), and Zomato. I don’t think TripAdvisor is a good place to find restaurants so I don’t use them. If a place does not have a score on one of these sites, you assign it the average score minus a 15% penalty for not being noteworthy enough to make that site. Make sure you apply similar criteria to Google, Zagat and Zomato when it comes to $Price and location.

Now you should have 4 columns of ratings. Add a fifth called notable mentions. Here you will either mark a 0 or 1 depending on whether the restaurant is mentioned on notable lists for that city. Try Eater24, Chowhound’s forums, Serious Eats Articles, and local newspaper “Best of” lists. CityPaper and local universities usually maintain good lists. If a restaurant appears in any of these places in a positive way, they get a 1 in this column.

4. Ensure there are no outliers.

If there was a restaurant that kept popping up in your searches in step 3, but is not on your list. Put it on the list. Repeat step 3 for any new places you’ve added.

5. Total the scores.

In your sixth column input a formula like the following to sum up your data:

Yelp scorex6+Zagat+Googlex6+Zomato*6+Mention in Blog 1 or 0= Aggregate Score

You now can sort your data based on the aggregate scores. This should give you a pretty good idea of the most well respected and enjoyable restaurants in the city.

Depending on your time and ability to move around, you have a great list to work from for an introductory look at the food of that city. if you have time, take a peek at pictures and menus of the food on Yelp. How are their portions? How are the prices? Is this a sit-down place or a take out joint. In general, anything with $ on Yelp will be carryout, $$ will be casual sit-down, and $$$+ will be fine dining.

Here’s a link to the Google Sheet I used for DC. I can’t say that this method is perfect. But is does to a pretty good job of helping to narrow down places but on certain criteria. So you shouldn’t end up somewhere totally terrible or out of your price range.

Get out there and enjoy some amazing food!