# data[].attributes.body
Panda and Burritos - Analyzing Chipotle Order Data -
1- This data should be amassed from a collection of states rather than only the two locations from Washington D.C. and Langston, Michigan. By collecting data from only two Chipotle restaurants, the data may be affected by the local economic status, culture, or even religion. The data should be collected from numerous restaurants ranging from different geopolitical locations to understand the true popularity of different ingredients.

2-If the data was collected from numerous restaurants, a margin of error can be created for each specific ingredient. The same amount of meals can be collected from each restaurant to find the average out of the restaurants and the margin of error which would include about 95% of the data per each ingredient.

3- The data can be collected from in-store orders rather than Grub Hub orders because Grub Hub may attain data from lazier and less motivated people due to their inability to pick up food for themselves.

Student Survey-

4- The data could be collected from different grades and age ranges of students attending Clinton to see the overall student popularity of Chipotle rather than only 21 students in the 10th grade.

5- I can collect different samples that different people in my group collect to develop a margin of error.

6- We could create a histogram with the number of ingredients within ranges of 10%.

Ranker.com-

7- They could generate a percentage out of the whole of people who like each ingredient.

# data[].attributes.headline
Pandas & Burritos - Analyzing Chipotle Order Data

# data[].attributes.subject
Pandas & Burritos - Analyzing Chipotle Order Data

# data[].attributes.body
Pro- The data included in this document is based on 3,000 Chipotle meals from 1,800 GrubHub orders taking place in 2012. This data is beneficial because it provides the exact number of people who order each meat or base in their meal and the popularity of specific combinations from the Chipotle Meals. According to the  3,000 Chipotle meals, the total number of people who ordered a Chicken Bowl, Chicken Burrito, Chicken Salad Bowl, or Chicken tacos exceeded 1,450 people. Of the 5 types of meat available in 2014, about 48.3 percent of the orders included chicken as the main base from Chipotle. This suggests chicken is the most appealing and popular meat from Chipotle by far.
With chicken bowls being the most popular at over 700 of the 3,000 orders being chicken bowls, the number of combinations with toppings out of this meal was 348. Two out of the top three combinations included white rice, black beans, cheese, and lettuce together amassing 28 meals. This is only the people that included this specific combination of ingredients. All of the top three included tomato salsa and white rice combined which was 45 people. This allowed us to understand what are the most popular combinations and ingredients and how the more popular ingredients may be more appealing to people when looking at a digital image. It also allowed us to understand that Chipotle creates and has available large servings of the more popular ingredients available on the counter for customers.

How could this data lead us to an incorrect conclusion?- The data suggested that chicken bowls were the most popular rather than chicken burritos. This suggests that we should create an NFT out of a bowl rather than a burrito. However, we will stick to a burrito due to our belief that it will provide a funnier and more appealing image through the use of our art skills. Although this data amasses three thousand meals, the number of people who made the specific online orders through GrubHub was 1,800 which is a small number of orders compared to the total number of orders at the 2,966 Chipotle Restaurants in the year. Also, this data was collected from only two Chipotle restaurants in Washington D.C. and Langston, Michigan in 2012. In 2012, Brown rice was a  new ingredient that had not yet been introduced to all stores. This may have impacted the data because brown rice may not have been available in these stores. Also, a plant-based protein main named sofritas had not yet been released. We are unable to know if brown rice or sofritas was a popular ingredient at the time. We are unable to include this in our digital image NFT because we do not know its popularity. Also, the locations may have impacted the data. According to the CDC, in 2017 Washington D.C. was found to have the lowest fertility rate at only 1.4 children per mother. This was the lowest fertility rate out of any state. This suggests that younger generations do not generally live in Washington D.C. Since we are looking to find data that is representative of younger generations such as generation Z, this data may not be precise for our NFT because it may be skewed to the taste perception of older generations. This is just one of the limiting factors that arise from having data that is of small quantity and from a small location rather than a variety of sources.

# data[].attributes.attachment_link.readable_text
Everyone, without exception, loves Chipotle. One of the top fast casual restaurants in the world, it offers enormous dope burritos and burrito bowls made exactly how you like them. These are the best Chipotle toppings behind the glass, ranked from best to worst. The best Chipotle burrito and taco toppings come in many forms. Whether you want fresh veggies, creamy sauces, or zippy tangy salsa, Chipotle has an array of ingredients you will enjoy. One of the most popular toppings at Chipotle has got to be its delicious cheese.

What ingredients will you find on this best Chipotle toppings list? If you like rice with your Mexican cuisine, Chipotle has you covered. The fast food chain offers two healthy varieties - Cilantro-Lime Brown Rice and Cilantro-Line White Rice. Avocado fans love Chipotle's creamy guacamole on everything from tacos to burritos.

When it comes to salsas, Chipotle does it best. Green-chili, Corn, Fresh tomato and Tomatillo Red Chili Salsa are all great toppings. Sour Cream is also popular with Chipotle fair.

Which Chipotle topping is the best? Help us decide by giving your favorites a thumbs up and share what you think is the best items in the comments section. Also, check out the best Chipotle secret menu items, as well as the best things to order, to get ideas for new combinations and creations to try next time you visit.

# data[].attributes.attachment_link.description
Everyone, without exception, loves Chipotle. One of the top fast casual restaurants in the world, it offers enormous dope burritos and burrito bowls made exactly how you like them. These are the best Chipotle toppings behind the glass, ranked from best to worst. The best Chipotle burrito and taco...

# data[].attributes.attachment_link.readable_text
A few months back the New York Times ran an article titled "At Chipotle, How Many Calories Do People Really Eat?" which took a look at the average amount of calories a typical order at Chipotle contained. They found that:

The typical order at Chipotle has about 1,070 calories. That's more than half of the calories that most adults are supposed to eat in an entire day. The recommended range for most adults is between 1,600 and 2,400.

Very surprising, Chipotle isn't the healthiest place to eat. What was more interesting to me was the fact that the NYT released the data they used for the article on their Github page. The article states that "The data is based on about 3,000 meals in about 1,800 Grubhub orders from July to December 2012, almost all from two Chipotle restaurants: one in Washington, D.C., and another in East Lansing, Mich."

I had been meaning to mess around with this order file for a while but had forgotten about it. That was until today when today I saw Chipotle had announced it will be offering delivery in select cities through a SF based delivery startup.

After starting up a new IPython notebook I loaded the TSV file into a pandas dataframe and ran the .head() method to make sure everything looked okay.

import pandas as pd df = pd.read_table('/Users/danielforsyth/Desktop/orders.tsv') df.head()

The First thing I wanted to look at was what items were the most popular.

items = df.item_name.value_counts().plot(kind='bar')

You can see that the chicken bowl dominates all of the items but there's obviously way too much going on here. How about just the top ten most popular items.

items = df.item_name.value_counts()[:10].plot(kind='bar')

That's much easier to read and you can clearly see the chicken bowl and chicken burrito are the most popular items at the locations included in the data.

Next I wanted to look at the prices of the orders. This was a little trickier as the 'item price' column contained string values and multiple items could be part of one order. The first step was to strip the $ sign from the string and then convert it to a float. Then you can just group by the order_id and add the sum method on the end.

df['item_price'] = df['item_price'].str.replace('$','') df['item_price'] = df['item_price'].astype(float) orders = df.groupby('order_id').sum() orders.head() orders['item_price'].describe()

From this we are able to see that 1834 meals were ordered with a total of 4622 different items. The mean price of a meal is $18 with the minimum being right around $10 (Obligatory mention of the term fast casual). Someone was also able to rack up a $205 dollar bill.

The last type of information I was interested in finding was the variety of different meals people ordered. The 'choice description' column describes the item type. For example what kind of soda or what toppings on a burrito bowl.

descriptions = df.groupby(["item_name", "choice_description"])["order_id"].count().reset_index(name="count")

Using this new dataframe we can easily see the most popular versions of each menu item. For example the different kinds of the most ordered item, the chicken bowl.

descriptions = descriptions[descriptions['item_name'].str.contains("Chicken Bowl")] descriptions.sort(['count'], ascending=False)[:10]

There were actually 348 different varieties of chicken bowls ordered but I limited it to the top ten which you can see here.

How about the most popular drinks?

descriptions = descriptions[descriptions['item_name'].str.contains("Canned Soda")] descriptions.sort(['count'], ascending=False)

It was very interesting playing around with this dataset, I would be curious to see the results if something like this were to be done at a much larger scale, to see things such as ordering trends in different stores and areas of the country. I am sure this data is very useful to Chipotle to see what items are doing well on top of optimizing inventory control on a location to location basis.

If you have any questions, feedback, advice, or corrections please get in touch with me on Twitter or email me at danforsyth1@gmail.com.

# data[].attributes.attachment_link.title
Pandas & Burritos - Analyzing Chipotle Order Data

# data[].attributes.attachment_link.description
A few months back the New York Times ran an article titled "At Chipotle, How Many Calories Do People Really Eat?" which took a look at the average amount of calories a typical order at Chipotle contained. They found that: The typical order at Chipotle has about 1,

# data[].attributes.attachment_link.title
Study: 94% of Crypto Buyers are Gen Z/Millennial, but Gen X is Outspending Them

# data[].attributes.attachment_link.description
In this analysis, we explore who is buying cryptocurrency using Stilt’s deep data set and we glean some interesting findings. Check it out!

# data[].attributes.body
I chose this topic because I personally love burritos and I am curious about the perspective of generation Z students in Manhattan.  Also, I am creating an NFT collection of a burrito. I would like to understand the ingredients that students in the Clinton School enjoy. I would like to know if they crave burritos enough to purchase a digital image of them. I will be using the Chipotle meals and ingredients as the basis for my survey questions and statistical information because it is the most popular and well-known vendor of burritos. This information is important because it will allow us to create a digital image with a filling of ingredients students most enjoy in their burritos. The most attractive and popular toppings will be placed on the digital image priced at the highest. I will be surveying students at the Clinton School because "94% of all cryptocurrency buyers are Generation Z or Millennials"  (Gogal). Although I will be limited to surveying students attending 10th grade in the Clinton School, the age range of students is within the vast majority of people purchasing digital images. By accessing the statistical information online and survey information about Chipotle, I will be able to create a digital image that I economically value the most.