San Diego Burrito Analytics: The best burritos (under construction)

Scott Cole

21 May 2016

This notebook will determine the best and worst burritos across the different dimensions, such as:

  1. What taco shop has the highest rated burritos?
  2. What taco shop has the best California burrito?
  3. What taco shop has the most optimal meat-to-filling ratio?

Default imports


In [1]:
%config InlineBackend.figure_format = 'retina'
%matplotlib inline

import numpy as np
import scipy as sp
import matplotlib.pyplot as plt
import pandas as pd

import seaborn as sns
sns.set_style("white")


C:\Users\Scott\Anaconda2\lib\site-packages\matplotlib\__init__.py:872: UserWarning: axes.color_cycle is deprecated and replaced with axes.prop_cycle; please use the latter.
  warnings.warn(self.msg_depr % (key, alt_key))

Load data


In [2]:
filename="burrito_current.csv"
df = pd.read_csv(filename)
N = df.shape[0]

Find the best location for each dimension


In [10]:
m_best = ['Volume','Cost','Tortilla','Temp','Meat','Fillings','Meat:filling',
               'Uniformity','Salsa','Synergy','Wrap','overall','Google','Yelp']

for m in m_best:
    print m
    print 'High,', df.Location[df[m].idxmax()], df[m][df[m].idxmax()]
    print 'Low,', df.Location[df[m].idxmin()], df[m][df[m].idxmin()]


Volume
High, Karina's Taco Shop  1.07
Low, Taco stand 0.65
Cost
High, La Perla Cocina 9.99
Low, Oscar's Mexican food 4.85
Tortilla
High, California Burritos 5.0
Low, Lolita's taco shop 1.5
Temp
High, Donato's taco shop 5.0
Low, Tony's Fresh Mexican Food 1.0
Meat
High, Pollos Maria 5.0
Low, Raul's Mexican food 1.0
Fillings
High, Mikes Taco Club 5.0
Low, Raul's Mexican food 1.0
Meat:filling
High, Taco Stand 5.0
Low, Raul's Mexican food 0.5
Uniformity
High, Oscar's Mexican food 5.0
Low, Lolita's taco shop 1.0
Salsa
High, Taco stand 5.0
Low, JV's Mexican Food 0.5
Synergy
High, Taco Stand 5.0
Low, Raul's Mexican food 1.0
Wrap
High, Oscar's Mexican food 5.0
Low, Cancun Mexican & Seafood 0.5
overall
High, California Burritos 5.0
Low, Raul's Mexican food 1.0
Google
High, Lola's 7 Up Market & Deli 4.9
Low, Nico's Taco Shop 2.9
Yelp
High, Taco Stand 4.5
Low, Rigoberto's Taco Shop 2.5