Skip to content

Instantly share code, notes, and snippets.

@FavioVazquez

FavioVazquez/Filterting_sorting_optimus.ipynb

Created July 19, 2019 17:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save FavioVazquez/5d95088cc50325b7eda9573ad80f668f to your computer and use it in GitHub Desktop.
Save FavioVazquez/5d95088cc50325b7eda9573ad80f668f to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
Filterting_sorting_optimus.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Import optimus and pandas"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"from optimus import Optimus\n",
"from pyspark.sql.functions import *\n",
"import pandas as pd\n",
"import numpy as np\n",
"op = Optimus()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Read the data and transform to Spark dataframe"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"url = 'https://raw.githubusercontent.com/justmarkham/DAT8/master/data/chipotle.tsv'\n",
"chipo_pd = pd.read_csv(url, sep = '\\t')\n",
"chipo_pd[['item_name', 'choice_description', 'item_price']] = chipo_pd[['item_name', 'choice_description', 'item_price']].astype(str)"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"chipo = op.spark.createDataFrame(chipo_pd)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# See the data"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<style>\n",
" .data_type {\n",
" font-size: 0.8em;\n",
" font-weight: normal;\n",
" }\n",
"\n",
" .column_name {\n",
" font-size: 1.2em;\n",
" }\n",
"\n",
" .info_items {\n",
" margin: 10px 0;\n",
" font-size: 0.8em;\n",
" }\n",
"\n",
" .optimus_table td {\n",
" padding: 2px;\n",
" border-left: 1px solid #cccccc;\n",
" border-right: 1px solid #cccccc;\n",
" }\n",
"\n",
" .optimus_table tr:nth-child(even) {\n",
" background-color: #f2f2f2 !important;\n",
" }\n",
"\n",
" .optimus_table tr:nth-child(odd) {\n",
" background-color: #ffffff !important;\n",
" }\n",
"\n",
" .optimus_table thead {\n",
" border-bottom: 1px solid black;\n",
" }\n",
" .optimus_table{\n",
" font-size: 12px;\n",
" }\n",
"\n",
" .optimus_table tbody{\n",
" font-family: monospace;\n",
" border-bottom: 1px solid #cccccc;\n",
" }\n",
"\n",
"\n",
"</style>\n",
"\n",
"\n",
"\n",
"\n",
"<div class=\"info_items\">Viewing 10 of 4622 rows / 5 columns</div>\n",
"<div class=\"info_items\">1 partition(s)</div>\n",
"\n",
"<table class=\"optimus_table\">\n",
" <thead>\n",
" <tr>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">order_id</div>\n",
" <div class=\"data_type\">1 (bigint)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">quantity</div>\n",
" <div class=\"data_type\">2 (bigint)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">item_name</div>\n",
" <div class=\"data_type\">3 (string)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">choice_description</div>\n",
" <div class=\"data_type\">4 (string)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">item_price</div>\n",
" <div class=\"data_type\">5 (string)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" </tr>\n",
"\n",
" </thead>\n",
" <tbody>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Fresh⸱Tomato⸱Salsa'>Chips⸱and⸱Fresh⸱Tomato⸱Salsa</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='nan'>nan</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='$2.39⸱'>$2.39⸱</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Izze'>Izze</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Clementine]'>[Clementine]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='$3.39⸱'>$3.39⸱</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Nantucket⸱Nectar'>Nantucket⸱Nectar</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Apple]'>[Apple]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='$3.39⸱'>$3.39⸱</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Tomatillo-Green⸱Chili⸱Salsa'>Chips⸱and⸱Tomatillo-Green⸱Chili⸱Salsa</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='nan'>nan</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='$2.39⸱'>$2.39⸱</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='2'>2</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='2'>2</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Chicken⸱Bowl'>Chicken⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo-Red⸱Chili⸱Salsa⸱(Hot),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Sour⸱Cream]]'>[Tomatillo-Red⸱Chili⸱Salsa⸱(Hot),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Sour⸱Cream]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='$16.98⸱'>$16.98⸱</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='3'>3</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Chicken⸱Bowl'>Chicken⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa⸱(Mild),⸱[Rice,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa⸱(Mild),⸱[Rice,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='$10.98⸱'>$10.98⸱</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='3'>3</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Side⸱of⸱Chips'>Side⸱of⸱Chips</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='nan'>nan</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='$1.69⸱'>$1.69⸱</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='4'>4</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Steak⸱Burrito'>Steak⸱Burrito</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Fajita⸱Vegetables,⸱Black⸱Beans,⸱Pinto⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Fajita⸱Vegetables,⸱Black⸱Beans,⸱Pinto⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='$11.75⸱'>$11.75⸱</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='4'>4</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Steak⸱Soft⸱Tacos'>Steak⸱Soft⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Green⸱Chili⸱Salsa,⸱[Pinto⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]'>[Tomatillo⸱Green⸱Chili⸱Salsa,⸱[Pinto⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='$9.25⸱'>$9.25⸱</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='5'>5</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Steak⸱Burrito'>Steak⸱Burrito</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Pinto⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Pinto⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='$9.25⸱'>$9.25⸱</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" </tbody>\n",
"</table>\n",
"\n",
"<div class=\"info_items\">Viewing 10 of 4622 rows / 5 columns</div>\n",
"<div class=\"info_items\">1 partition(s)</div>\n"
],
"text/plain": [
"<IPython.core.display.HTML object>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"chipo.table(10)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# How many items are more expensive than $10?"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"+--------+--------+--------------------+--------------------+----------+\n",
"|order_id|quantity| item_name| choice_description|item_price|\n",
"+--------+--------+--------------------+--------------------+----------+\n",
"| 75| 1|Barbacoa Crispy T...|[Tomatillo Red Ch...| 11.75|\n",
"| 83| 1| Veggie Salad Bowl|[Fresh Tomato Sal...| 11.25|\n",
"| 468| 1| Carnitas Salad Bowl|[Fresh Tomato Sal...| 11.89|\n",
"| 19| 1| Barbacoa Bowl|[Roasted Chili Co...| 11.75|\n",
"| 4| 1| Steak Burrito|[Tomatillo Red Ch...| 11.75|\n",
"| 26| 1| Veggie Burrito|[Tomatillo Red Ch...| 11.25|\n",
"| 109| 1| Chicken Salad|[Roasted Chili Co...| 10.98|\n",
"| 304| 1| Veggie Soft Tacos|[Tomatillo Red Ch...| 11.25|\n",
"| 501| 1| Barbacoa Salad Bowl|[Fresh Tomato Sal...| 11.89|\n",
"| 3| 1| Chicken Bowl|[Fresh Tomato Sal...| 10.98|\n",
"| 28| 1| Veggie Bowl|[Fresh Tomato Sal...| 11.25|\n",
"| 250| 1| Steak Salad Bowl|[Fresh Tomato Sal...| 11.89|\n",
"+--------+--------+--------------------+--------------------+----------+\n",
"\n"
]
}
],
"source": [
"# Use substr (like in SQL) to get from the first numer to the end and then cast it\n",
"chipo = chipo.withColumn(\"item_price\", chipo.item_price.substr(2,10).cast(\"float\"))\n",
"# Delete the duplicates in item_name and quantity\n",
"chipo_filtered = chipo.rows.drop_duplicates(['item_name','quantity'])\n",
"# Select only the products with quantity equals to 1\n",
"chipo_one_prod = chipo_filtered.where(\"quantity = 1\")\n",
"# Select products that aare more expensive than $10\n",
"chipo_one_prod.where(\"item_price > 10\").show()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# What is the price of each item?"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [],
"source": [
"# Select only the products with quantity equals to 1\n",
"chipo_one_prod = chipo_filtered.where(\"quantity = 1\")\n",
"#select only the item_name and item_price columns\n",
"price_per_item = chipo_one_prod[['item_name', 'item_price']]"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<style>\n",
" .data_type {\n",
" font-size: 0.8em;\n",
" font-weight: normal;\n",
" }\n",
"\n",
" .column_name {\n",
" font-size: 1.2em;\n",
" }\n",
"\n",
" .info_items {\n",
" margin: 10px 0;\n",
" font-size: 0.8em;\n",
" }\n",
"\n",
" .optimus_table td {\n",
" padding: 2px;\n",
" border-left: 1px solid #cccccc;\n",
" border-right: 1px solid #cccccc;\n",
" }\n",
"\n",
" .optimus_table tr:nth-child(even) {\n",
" background-color: #f2f2f2 !important;\n",
" }\n",
"\n",
" .optimus_table tr:nth-child(odd) {\n",
" background-color: #ffffff !important;\n",
" }\n",
"\n",
" .optimus_table thead {\n",
" border-bottom: 1px solid black;\n",
" }\n",
" .optimus_table{\n",
" font-size: 12px;\n",
" }\n",
"\n",
" .optimus_table tbody{\n",
" font-family: monospace;\n",
" border-bottom: 1px solid #cccccc;\n",
" }\n",
"\n",
"\n",
"</style>\n",
"\n",
"\n",
"\n",
"\n",
"<div class=\"info_items\">Viewing 50 of 50 rows / 2 columns</div>\n",
"<div class=\"info_items\">20 partition(s)</div>\n",
"\n",
"<table class=\"optimus_table\">\n",
" <thead>\n",
" <tr>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">item_name</div>\n",
" <div class=\"data_type\">1 (string)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">item_price</div>\n",
" <div class=\"data_type\">2 (float)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" </tr>\n",
"\n",
" </thead>\n",
" <tbody>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Carnitas⸱Salad⸱Bowl'>Carnitas⸱Salad⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.890000343322754'>11.890000343322754</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Salad⸱Bowl'>Barbacoa⸱Salad⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.890000343322754'>11.890000343322754</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Steak⸱Salad⸱Bowl'>Steak⸱Salad⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.890000343322754'>11.890000343322754</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Steak⸱Burrito'>Steak⸱Burrito</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Crispy⸱Tacos'>Barbacoa⸱Crispy⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Veggie⸱Salad⸱Bowl'>Veggie⸱Salad⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.25'>11.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Veggie⸱Burrito'>Veggie⸱Burrito</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.25'>11.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Veggie⸱Soft⸱Tacos'>Veggie⸱Soft⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.25'>11.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Veggie⸱Bowl'>Veggie⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.25'>11.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chicken⸱Salad'>Chicken⸱Salad</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='10.979999542236328'>10.979999542236328</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chicken⸱Bowl'>Chicken⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='10.979999542236328'>10.979999542236328</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Carnitas⸱Crispy⸱Tacos'>Carnitas⸱Crispy⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Soft⸱Tacos'>Barbacoa⸱Soft⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Steak⸱Soft⸱Tacos'>Steak⸱Soft⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Steak⸱Crispy⸱Tacos'>Steak⸱Crispy⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Carnitas⸱Soft⸱Tacos'>Carnitas⸱Soft⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Steak⸱Salad'>Steak⸱Salad</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Carnitas⸱Burrito'>Carnitas⸱Burrito</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Burrito'>Barbacoa⸱Burrito</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Steak⸱Bowl'>Steak⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Carnitas⸱Salad'>Carnitas⸱Salad</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Carnitas⸱Bowl'>Carnitas⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chicken⸱Salad⸱Bowl'>Chicken⸱Salad⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.75'>8.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chicken⸱Soft⸱Tacos'>Chicken⸱Soft⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.75'>8.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chicken⸱Crispy⸱Tacos'>Chicken⸱Crispy⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.75'>8.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Veggie⸱Salad'>Veggie⸱Salad</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.489999771118164'>8.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Veggie⸱Crispy⸱Tacos'>Veggie⸱Crispy⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.489999771118164'>8.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chicken⸱Burrito'>Chicken⸱Burrito</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.489999771118164'>8.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Crispy⸱Tacos'>Crispy⸱Tacos</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='7.400000095367432'>7.400000095367432</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Burrito'>Burrito</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='7.400000095367432'>7.400000095367432</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Bowl'>Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='7.400000095367432'>7.400000095367432</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Salad'>Salad</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='7.400000095367432'>7.400000095367432</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Guacamole'>Chips⸱and⸱Guacamole</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='4.449999809265137'>4.449999809265137</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Izze'>Izze</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='3.390000104904175'>3.390000104904175</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Nantucket⸱Nectar'>Nantucket⸱Nectar</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='3.390000104904175'>3.390000104904175</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Mild⸱Fresh⸱Tomato⸱Salsa'>Chips⸱and⸱Mild⸱Fresh⸱Tomato⸱Salsa</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='3.0'>3.0</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Tomatillo⸱Red⸱Chili⸱Salsa'>Chips⸱and⸱Tomatillo⸱Red⸱Chili⸱Salsa</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='2.950000047683716'>2.950000047683716</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Roasted⸱Chili⸱Corn⸱Salsa'>Chips⸱and⸱Roasted⸱Chili⸱Corn⸱Salsa</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='2.950000047683716'>2.950000047683716</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Tomatillo⸱Green⸱Chili⸱Salsa'>Chips⸱and⸱Tomatillo⸱Green⸱Chili⸱Salsa</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='2.950000047683716'>2.950000047683716</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Roasted⸱Chili-Corn⸱Salsa'>Chips⸱and⸱Roasted⸱Chili-Corn⸱Salsa</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='2.390000104904175'>2.390000104904175</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Tomatillo-Red⸱Chili⸱Salsa'>Chips⸱and⸱Tomatillo-Red⸱Chili⸱Salsa</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='2.390000104904175'>2.390000104904175</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Fresh⸱Tomato⸱Salsa'>Chips⸱and⸱Fresh⸱Tomato⸱Salsa</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='2.390000104904175'>2.390000104904175</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Tomatillo-Green⸱Chili⸱Salsa'>Chips⸱and⸱Tomatillo-Green⸱Chili⸱Salsa</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='2.390000104904175'>2.390000104904175</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Chips'>Chips</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='2.1500000953674316'>2.1500000953674316</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Side⸱of⸱Chips'>Side⸱of⸱Chips</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1.690000057220459'>1.690000057220459</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Canned⸱Soft⸱Drink'>Canned⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1.25'>1.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Bottled⸱Water'>Bottled⸱Water</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1.090000033378601'>1.090000033378601</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='Canned⸱Soda'>Canned⸱Soda</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1.090000033378601'>1.090000033378601</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" </tbody>\n",
"</table>\n",
"\n",
"<div class=\"info_items\">Viewing 50 of 50 rows / 2 columns</div>\n",
"<div class=\"info_items\">20 partition(s)</div>\n"
],
"text/plain": [
"<IPython.core.display.HTML object>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"price_per_item.sort(desc(\"item_price\")).table()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Sort by the name of the item"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<style>\n",
" .data_type {\n",
" font-size: 0.8em;\n",
" font-weight: normal;\n",
" }\n",
"\n",
" .column_name {\n",
" font-size: 1.2em;\n",
" }\n",
"\n",
" .info_items {\n",
" margin: 10px 0;\n",
" font-size: 0.8em;\n",
" }\n",
"\n",
" .optimus_table td {\n",
" padding: 2px;\n",
" border-left: 1px solid #cccccc;\n",
" border-right: 1px solid #cccccc;\n",
" }\n",
"\n",
" .optimus_table tr:nth-child(even) {\n",
" background-color: #f2f2f2 !important;\n",
" }\n",
"\n",
" .optimus_table tr:nth-child(odd) {\n",
" background-color: #ffffff !important;\n",
" }\n",
"\n",
" .optimus_table thead {\n",
" border-bottom: 1px solid black;\n",
" }\n",
" .optimus_table{\n",
" font-size: 12px;\n",
" }\n",
"\n",
" .optimus_table tbody{\n",
" font-family: monospace;\n",
" border-bottom: 1px solid #cccccc;\n",
" }\n",
"\n",
"\n",
"</style>\n",
"\n",
"\n",
"\n",
"\n",
"<div class=\"info_items\">Viewing 100 of 4622 rows / 5 columns</div>\n",
"<div class=\"info_items\">51 partition(s)</div>\n",
"\n",
"<table class=\"optimus_table\">\n",
" <thead>\n",
" <tr>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">order_id</div>\n",
" <div class=\"data_type\">1 (bigint)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">quantity</div>\n",
" <div class=\"data_type\">2 (bigint)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">item_name</div>\n",
" <div class=\"data_type\">3 (string)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">choice_description</div>\n",
" <div class=\"data_type\">4 (string)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">item_price</div>\n",
" <div class=\"data_type\">5 (float)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" </tr>\n",
"\n",
" </thead>\n",
" <tbody>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='776'>776</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='306'>306</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='422'>422</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Sprite]'>[Sprite]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='182'>182</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='784'>784</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='754'>754</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='264'>264</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='708'>708</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='709'>709</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='363'>363</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='298'>298</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Nestea]'>[Nestea]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1742'>1742</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1798'>1798</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1800'>1800</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1803'>1803</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Lemonade]'>[Lemonade]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='798'>798</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='849'>849</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='432'>432</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='899'>899</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='749'>749</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='945'>945</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Sprite]'>[Sprite]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='465'>465</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='949'>949</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1076'>1076</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='481'>481</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1109'>1109</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='774'>774</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1136'>1136</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='511'>511</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1196'>1196</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1248'>1248</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='520'>520</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Sprite]'>[Sprite]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1253'>1253</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Lemonade]'>[Lemonade]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1360'>1360</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='2'>2</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='12.979999542236328'>12.979999542236328</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='566'>566</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1373'>1373</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1443'>1443</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1741'>1741</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1448'>1448</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Nestea]'>[Nestea]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='154'>154</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1454'>1454</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1666'>1666</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1480'>1480</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1508'>1508</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='148'>148</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1517'>1517</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1525'>1525</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Sprite]'>[Sprite]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='168'>168</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1537'>1537</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Coke]'>[Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1554'>1554</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='230'>230</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1558'>1558</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='129'>129</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Sprite]'>[Sprite]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1664'>1664</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6⸱Pack⸱Soft⸱Drink'>6⸱Pack⸱Soft⸱Drink</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Diet⸱Coke]'>[Diet⸱Coke]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='6.489999771118164'>6.489999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='97'>97</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1278'>1278</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱(Mild),⸱[Lettuce,⸱Black⸱Beans,⸱Rice]]'>[Fresh⸱Tomato⸱(Mild),⸱[Lettuce,⸱Black⸱Beans,⸱Rice]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.6899995803833'>8.6899995803833</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1200'>1200</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Black⸱Beans,⸱Cheese,⸱Guacamole,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Black⸱Beans,⸱Cheese,⸱Guacamole,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='182'>182</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Black⸱Beans,⸱Cheese]]'>[Fresh⸱Tomato⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Black⸱Beans,⸱Cheese]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1426'>1426</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1533'>1533</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱(Mild),⸱[Lettuce,⸱Rice,⸱Cheese]]'>[Fresh⸱Tomato⸱(Mild),⸱[Lettuce,⸱Rice,⸱Cheese]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.6899995803833'>8.6899995803833</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='795'>795</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa]'>[Tomatillo⸱Red⸱Chili⸱Salsa]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1299'>1299</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[[Tomatillo-Red⸱Chili⸱Salsa⸱(Hot),⸱Tomatillo-Green⸱Chili⸱Salsa⸱(Medium)],⸱[Rice,⸱Pinto⸱Beans,⸱Fajita⸱Veggies,⸱Lettuce]]'>[[Tomatillo-Red⸱Chili⸱Salsa⸱(Hot),⸱Tomatillo-Green⸱Chili⸱Salsa⸱(Medium)],⸱[Rice,⸱Pinto⸱Beans,⸱Fajita⸱Veggies,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='110'>110</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Cheese,⸱Lettuce]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Cheese,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='730'>730</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa⸱(Mild),⸱[Rice,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa⸱(Mild),⸱[Rice,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='504'>504</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa⸱(Mild),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa⸱(Mild),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.479999542236328'>11.479999542236328</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='61'>61</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Black⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Black⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1203'>1203</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Roasted⸱Chili⸱Corn⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Guacamole]]'>[Roasted⸱Chili⸱Corn⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Guacamole]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='425'>425</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Cheese,⸱Sour⸱Cream]]'>[Fresh⸱Tomato⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Cheese,⸱Sour⸱Cream]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='51'>51</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[[Tomatillo-Red⸱Chili⸱Salsa⸱(Hot),⸱Tomatillo-Green⸱Chili⸱Salsa⸱(Medium)],⸱[Rice,⸱Pinto⸱Beans,⸱Fajita⸱Veggies,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]'>[[Tomatillo-Red⸱Chili⸱Salsa⸱(Hot),⸱Tomatillo-Green⸱Chili⸱Salsa⸱(Medium)],⸱[Rice,⸱Pinto⸱Beans,⸱Fajita⸱Veggies,⸱Cheese,⸱Sour⸱Cr...</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1303'>1303</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa⸱(Mild),⸱[Rice,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa⸱(Mild),⸱[Rice,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='907'>907</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Fajita⸱Vegetables,⸱Black⸱Beans,⸱Sour⸱Cream]]'>[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Fajita⸱Vegetables,⸱Black⸱Beans,⸱Sour⸱Cream]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='483'>483</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo-Green⸱Chili⸱Salsa⸱(Medium),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Guacamole]]'>[Tomatillo-Green⸱Chili⸱Salsa⸱(Medium),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Guacamole]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.479999542236328'>11.479999542236328</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='483'>483</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa⸱(Mild),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa⸱(Mild),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.479999542236328'>11.479999542236328</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='485'>485</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[[Roasted⸱Chili⸱Corn⸱Salsa⸱(Medium),⸱Tomatillo-Red⸱Chili⸱Salsa⸱(Hot)],⸱[Pinto⸱Beans,⸱Rice,⸱Fajita⸱Veggies]]'>[[Roasted⸱Chili⸱Corn⸱Salsa⸱(Medium),⸱Tomatillo-Red⸱Chili⸱Salsa⸱(Hot)],⸱[Pinto⸱Beans,⸱Rice,⸱Fajita⸱Veggies]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='705'>705</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='550'>550</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='562'>562</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[[Tomatillo-Green⸱Chili⸱Salsa⸱(Medium),⸱Roasted⸱Chili⸱Corn⸱Salsa⸱(Medium)],⸱[Rice,⸱Fajita⸱Veggies,⸱Guacamole,⸱Lettuce]]'>[[Tomatillo-Green⸱Chili⸱Salsa⸱(Medium),⸱Roasted⸱Chili⸱Corn⸱Salsa⸱(Medium)],⸱[Rice,⸱Fajita⸱Veggies,⸱Guacamole,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.479999542236328'>11.479999542236328</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='576'>576</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa]'>[Tomatillo⸱Red⸱Chili⸱Salsa]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='676'>676</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='346'>346</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Cheese,⸱Lettuce]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Cheese,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='440'>440</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Cheese,⸱Lettuce]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Cheese,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='812'>812</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Black⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Black⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1356'>1356</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese]]'>[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1361'>1361</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='953'>953</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Roasted⸱Chili⸱Corn⸱Salsa,⸱[Cheese,⸱Lettuce]]'>[Roasted⸱Chili⸱Corn⸱Salsa,⸱[Cheese,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1426'>1426</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1097'>1097</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Fajita⸱Vegetables,⸱Black⸱Beans,⸱Sour⸱Cream,⸱Cheese,⸱Lettuce,⸱Guacamole]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Fajita⸱Vegetables,⸱Black⸱Beans,⸱Sour⸱Cream,⸱Cheese,⸱Lettuce,⸱Guacamole]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1112'>1112</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Sour⸱Cream,⸱Cheese,⸱Lettuce]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Sour⸱Cream,⸱Cheese,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='504'>504</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo-Green⸱Chili⸱Salsa⸱(Medium),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Guacamole]]'>[Tomatillo-Green⸱Chili⸱Salsa⸱(Medium),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Guacamole]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.479999542236328'>11.479999542236328</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='514'>514</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Lettuce]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='244'>244</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Roasted⸱Chili⸱Corn⸱Salsa,⸱[Rice,⸱Cheese,⸱Lettuce]]'>[Roasted⸱Chili⸱Corn⸱Salsa,⸱[Rice,⸱Cheese,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='554'>554</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Pinto⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Pinto⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1059'>1059</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Cheese,⸱Lettuce]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Cheese,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='310'>310</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo-Red⸱Chili⸱Salsa⸱(Hot),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]'>[Tomatillo-Red⸱Chili⸱Salsa⸱(Hot),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='56'>56</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Pinto⸱Beans,⸱Cheese,⸱Lettuce]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Pinto⸱Beans,⸱Cheese,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='331'>331</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Fajita⸱Vegetables,⸱Black⸱Beans,⸱Sour⸱Cream,⸱Cheese]]'>[Tomatillo⸱Red⸱Chili⸱Salsa,⸱[Rice,⸱Fajita⸱Vegetables,⸱Black⸱Beans,⸱Sour⸱Cream,⸱Cheese]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1041'>1041</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Sour⸱Cream,⸱Lettuce]]'>[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Sour⸱Cream,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='664'>664</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole]]'>[Fresh⸱Tomato⸱Salsa,⸱[Rice,⸱Black⸱Beans,⸱Cheese,⸱Sour⸱Cream,⸱Guacamole]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='11.75'>11.75</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='42'>42</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Fresh⸱Tomato⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Cheese,⸱Sour⸱Cream]]'>[Fresh⸱Tomato⸱Salsa,⸱[Fajita⸱Vegetables,⸱Rice,⸱Cheese,⸱Sour⸱Cream]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='9.25'>9.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='330'>330</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='1'>1</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Barbacoa⸱Bowl'>Barbacoa⸱Bowl</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='[Tomatillo-Red⸱Chili⸱Salsa⸱(Hot),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]'>[Tomatillo-Red⸱Chili⸱Salsa⸱(Hot),⸱[Black⸱Beans,⸱Rice,⸱Cheese,⸱Sour⸱Cream,⸱Lettuce]]</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='8.989999771118164'>8.989999771118164</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" </tbody>\n",
"</table>\n",
"\n",
"<div class=\"info_items\">Viewing 100 of 4622 rows / 5 columns</div>\n",
"<div class=\"info_items\">51 partition(s)</div>\n"
],
"text/plain": [
"<IPython.core.display.HTML object>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"chipo.sort(\"item_name\").table()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# What was the quantity of the most expensive item ordered?"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<style>\n",
" .data_type {\n",
" font-size: 0.8em;\n",
" font-weight: normal;\n",
" }\n",
"\n",
" .column_name {\n",
" font-size: 1.2em;\n",
" }\n",
"\n",
" .info_items {\n",
" margin: 10px 0;\n",
" font-size: 0.8em;\n",
" }\n",
"\n",
" .optimus_table td {\n",
" padding: 2px;\n",
" border-left: 1px solid #cccccc;\n",
" border-right: 1px solid #cccccc;\n",
" }\n",
"\n",
" .optimus_table tr:nth-child(even) {\n",
" background-color: #f2f2f2 !important;\n",
" }\n",
"\n",
" .optimus_table tr:nth-child(odd) {\n",
" background-color: #ffffff !important;\n",
" }\n",
"\n",
" .optimus_table thead {\n",
" border-bottom: 1px solid black;\n",
" }\n",
" .optimus_table{\n",
" font-size: 12px;\n",
" }\n",
"\n",
" .optimus_table tbody{\n",
" font-family: monospace;\n",
" border-bottom: 1px solid #cccccc;\n",
" }\n",
"\n",
"\n",
"</style>\n",
"\n",
"\n",
"\n",
"\n",
"<div class=\"info_items\">Viewing 1 of 4622 rows / 5 columns</div>\n",
"<div class=\"info_items\">58 partition(s)</div>\n",
"\n",
"<table class=\"optimus_table\">\n",
" <thead>\n",
" <tr>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">order_id</div>\n",
" <div class=\"data_type\">1 (bigint)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">quantity</div>\n",
" <div class=\"data_type\">2 (bigint)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">item_name</div>\n",
" <div class=\"data_type\">3 (string)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">choice_description</div>\n",
" <div class=\"data_type\">4 (string)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" <th>\n",
" <div class=\"column_name\">item_price</div>\n",
" <div class=\"data_type\">5 (float)</div>\n",
" <div class=\"data_type\">\n",
" \n",
" nullable\n",
" \n",
" </div>\n",
" </th>\n",
" \n",
" </tr>\n",
"\n",
" </thead>\n",
" <tbody>\n",
" \n",
" <tr>\n",
" \n",
" <td>\n",
" <div title='1443'>1443</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='15'>15</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='Chips⸱and⸱Fresh⸱Tomato⸱Salsa'>Chips⸱and⸱Fresh⸱Tomato⸱Salsa</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='nan'>nan</div>\n",
" </td>\n",
" \n",
" <td>\n",
" <div title='44.25'>44.25</div>\n",
" </td>\n",
" \n",
" </tr>\n",
" \n",
" </tbody>\n",
"</table>\n",
"\n",
"<div class=\"info_items\">Viewing 1 of 4622 rows / 5 columns</div>\n",
"<div class=\"info_items\">58 partition(s)</div>\n"
],
"text/plain": [
"<IPython.core.display.HTML object>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"chipo.sort(desc(\"item_price\")).table(1)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# How many times were a Veggie Salad Bowl ordered?"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"18"
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"chipo_salad = chipo.where(chipo.item_name == \"Veggie Salad Bowl\")\n",
"chipo_salad.count()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# How many times people orderd more than one Canned Soda?"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"20"
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"chipo_drink_steak_bowl = chipo.where((chipo.item_name == \"Canned Soda\") & (chipo.quantity > 1))\n",
"chipo_drink_steak_bowl.count()"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.8"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment