{ "cells": [ { "cell_type": "markdown", "id": "3862dec2", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T15:53:24.609320Z", "start_time": "2022-10-22T15:53:24.602721Z" } }, "source": [ "## Problem Statement: \n", "**How many store clerks are requeried in diffrent shifts to manage the store**" ] }, { "cell_type": "code", "execution_count": 1, "id": "77cf9ff2", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T15:43:41.457229Z", "start_time": "2022-10-22T15:43:39.938110Z" } }, "outputs": [], "source": [ "import pandas as pd \n", "import numpy as np \n", "import matplotlib.pyplot as plt \n", "import seaborn as sns " ] }, { "cell_type": "code", "execution_count": 6, "id": "a54d23f9", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T15:51:36.187948Z", "start_time": "2022-10-22T15:51:36.151587Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
DateTimeTransactionItem
02016-10-3009:58:111Bread
12016-10-3010:05:342Scandinavian
22016-10-3010:05:342Scandinavian
32016-10-3010:07:573Hot chocolate
42016-10-3010:07:573Jam
\n", "
" ], "text/plain": [ " Date Time Transaction Item\n", "0 2016-10-30 09:58:11 1 Bread\n", "1 2016-10-30 10:05:34 2 Scandinavian\n", "2 2016-10-30 10:05:34 2 Scandinavian\n", "3 2016-10-30 10:07:57 3 Hot chocolate\n", "4 2016-10-30 10:07:57 3 Jam" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset = pd.read_csv('/Users/rishavdas/Downloads/Data/retail_dataset.csv')\n", "dataset.head()" ] }, { "cell_type": "code", "execution_count": 7, "id": "c5ebb5db", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T15:52:14.402585Z", "start_time": "2022-10-22T15:52:14.397780Z" } }, "outputs": [ { "data": { "text/plain": [ "(21293, 4)" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.shape" ] }, { "cell_type": "code", "execution_count": 11, "id": "b7b5e7e7", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T16:00:52.252597Z", "start_time": "2022-10-22T16:00:52.213174Z" } }, "outputs": [], "source": [ "dataset['Year'] = [i.split('-')[0] for i in dataset.Date]\n", "dataset['Month'] = [i.split('-')[1] for i in dataset.Date]\n", "dataset['Day'] = [i.split('-')[2] for i in dataset.Date]\n", "dataset['Hour'] = [i.split(':')[0] for i in dataset.Time]" ] }, { "cell_type": "code", "execution_count": 12, "id": "5c18ddec", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T16:00:53.564054Z", "start_time": "2022-10-22T16:00:53.543452Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
DateTimeTransactionItemYearMonthDayHour
02016-10-3009:58:111Bread2016103009
12016-10-3010:05:342Scandinavian2016103010
22016-10-3010:05:342Scandinavian2016103010
32016-10-3010:07:573Hot chocolate2016103010
42016-10-3010:07:573Jam2016103010
\n", "
" ], "text/plain": [ " Date Time Transaction Item Year Month Day Hour\n", "0 2016-10-30 09:58:11 1 Bread 2016 10 30 09\n", "1 2016-10-30 10:05:34 2 Scandinavian 2016 10 30 10\n", "2 2016-10-30 10:05:34 2 Scandinavian 2016 10 30 10\n", "3 2016-10-30 10:07:57 3 Hot chocolate 2016 10 30 10\n", "4 2016-10-30 10:07:57 3 Jam 2016 10 30 10" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.head()" ] }, { "cell_type": "code", "execution_count": 13, "id": "9791e2dc", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T16:01:28.994103Z", "start_time": "2022-10-22T16:01:28.984082Z" } }, "outputs": [ { "data": { "text/plain": [ "'2016-10-30'" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.Date.min()" ] }, { "cell_type": "code", "execution_count": 14, "id": "566fa29b", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T16:01:34.395122Z", "start_time": "2022-10-22T16:01:34.386042Z" } }, "outputs": [ { "data": { "text/plain": [ "'2017-04-09'" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.Date.max()" ] }, { "cell_type": "code", "execution_count": 15, "id": "45db7b0a", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T16:03:08.542048Z", "start_time": "2022-10-22T16:03:08.531181Z" } }, "outputs": [ { "data": { "text/plain": [ "95" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.Item.nunique()" ] }, { "cell_type": "markdown", "id": "247d2e15", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T16:04:00.803864Z", "start_time": "2022-10-22T16:04:00.797386Z" } }, "source": [ "## Most Sold Items " ] }, { "cell_type": "code", "execution_count": 18, "id": "4572da3f", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T16:09:40.641736Z", "start_time": "2022-10-22T16:09:40.621312Z" } }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "[('Coffee', 5471), ('Bread', 3325), ('Tea', 1435), ('Cake', 1025), ('Pastry', 856), ('NONE', 786), ('Sandwich', 771), ('Medialuna', 616), ('Hot chocolate', 590), ('Cookies', 540), ('Brownie', 379), ('Farm House', 374), ('Muffin', 370), ('Juice', 369), ('Alfajores', 369)]\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ItemsFrequency_of_Sales
0Coffee5471
1Bread3325
2Tea1435
3Cake1025
4Pastry856
5NONE786
6Sandwich771
7Medialuna616
8Hot chocolate590
9Cookies540
10Brownie379
11Farm House374
12Muffin370
13Juice369
14Alfajores369
\n", "
" ], "text/plain": [ " Items Frequency_of_Sales\n", "0 Coffee 5471\n", "1 Bread 3325\n", "2 Tea 1435\n", "3 Cake 1025\n", "4 Pastry 856\n", "5 NONE 786\n", "6 Sandwich 771\n", "7 Medialuna 616\n", "8 Hot chocolate 590\n", "9 Cookies 540\n", "10 Brownie 379\n", "11 Farm House 374\n", "12 Muffin 370\n", "13 Juice 369\n", "14 Alfajores 369" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from collections import Counter \n", "Total_sales = Counter(dataset.Item)\n", "most_frequent_sales = Total_sales.most_common(15)\n", "print(most_frequent_sales)\n", "x, y = zip(*most_frequent_sales)\n", "x, y = list(x), list(y)\n", "names = pd.DataFrame(x)\n", "no_of_sales = pd.DataFrame(y)\n", "most_sold_item = pd.concat([names.iloc[:, 0], no_of_sales.iloc[:, 0]], axis=1)\n", "most_sold_item.columns = \"Items\", 'Frequency_of_Sales'\n", "most_sold_item" ] }, { "cell_type": "code", "execution_count": 20, "id": "8fb4050b", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T16:30:16.886909Z", "start_time": "2022-10-22T16:30:15.684147Z" } }, "outputs": [ { "data": { "text/html": [ " \n", " " ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "application/vnd.plotly.v1+json": { "config": { "linkText": "Export to plot.ly", "plotlyServerURL": "https://plot.ly", "showLink": false }, "data": [ { "hole": 0.4, "hoverinfo": "label+percent+name", "labels": [ "Coffee", "Bread", "Tea", "Cake", "Pastry", "NONE", "Sandwich", "Medialuna", "Hot chocolate", "Cookies", "Brownie", "Farm House", "Muffin", "Juice", "Alfajores" ], "name": "Product", "type": "pie", "values": [ 5471, 3325, 1435, 1025, 856, 786, 771, 616, 590, 540, 379, 374, 370, 369, 369 ] } ], "layout": { "annotations": [ { "font": { "size": 20 }, "showarrow": false, "text": "Most Sold", "x": 0.5, "y": 0.5 } ], "template": { "data": { "bar": [ { "error_x": { "color": "#2a3f5f" }, "error_y": { "color": "#2a3f5f" }, "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "bar" } ], "barpolar": [ { "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "barpolar" } ], "carpet": [ { "aaxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "baxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "type": "carpet" } ], "choropleth": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "choropleth" } ], "contour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "contour" } ], "contourcarpet": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "contourcarpet" } ], "heatmap": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "heatmap" } ], "heatmapgl": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "heatmapgl" } ], "histogram": [ { "marker": { "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "histogram" } ], "histogram2d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "histogram2d" } ], "histogram2dcontour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "histogram2dcontour" } ], "mesh3d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "mesh3d" } ], "parcoords": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "parcoords" } ], "pie": [ { "automargin": true, "type": "pie" } ], "scatter": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter" } ], "scatter3d": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter3d" } ], "scattercarpet": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattercarpet" } ], "scattergeo": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergeo" } ], "scattergl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergl" } ], "scattermapbox": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattermapbox" } ], "scatterpolar": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolar" } ], "scatterpolargl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolargl" } ], "scatterternary": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterternary" } ], "surface": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "surface" } ], "table": [ { "cells": { "fill": { "color": "#EBF0F8" }, "line": { "color": "white" } }, "header": { "fill": { "color": "#C8D4E3" }, "line": { "color": "white" } }, "type": "table" } ] }, "layout": { "annotationdefaults": { "arrowcolor": "#2a3f5f", "arrowhead": 0, "arrowwidth": 1 }, "autotypenumbers": "strict", "coloraxis": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "colorscale": { "diverging": [ [ 0, "#8e0152" ], [ 0.1, "#c51b7d" ], [ 0.2, "#de77ae" ], [ 0.3, "#f1b6da" ], [ 0.4, "#fde0ef" ], [ 0.5, "#f7f7f7" ], [ 0.6, "#e6f5d0" ], [ 0.7, "#b8e186" ], [ 0.8, "#7fbc41" ], [ 0.9, "#4d9221" ], [ 1, "#276419" ] ], "sequential": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "sequentialminus": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ] }, "colorway": [ "#636efa", "#EF553B", "#00cc96", "#ab63fa", "#FFA15A", "#19d3f3", "#FF6692", "#B6E880", "#FF97FF", "#FECB52" ], "font": { "color": "#2a3f5f" }, "geo": { "bgcolor": "white", "lakecolor": "white", "landcolor": "#E5ECF6", "showlakes": true, "showland": true, "subunitcolor": "white" }, "hoverlabel": { "align": "left" }, "hovermode": "closest", "mapbox": { "style": "light" }, "paper_bgcolor": "white", "plot_bgcolor": "#E5ECF6", "polar": { "angularaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "radialaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "scene": { "xaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "yaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "zaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" } }, "shapedefaults": { "line": { "color": "#2a3f5f" } }, "ternary": { "aaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "baxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "caxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "title": { "x": 0.05 }, "xaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 }, "yaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 } } }, "title": { "text": "Most Sold Product - Top 15 " } } }, "text/html": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "import chart_studio.plotly as py\n", "from plotly.offline import init_notebook_mode, plot, iplot\n", "import plotly.graph_objs as go\n", "\n", "init_notebook_mode(connected=True)\n", "val = most_sold_item.Items\n", "fig = {\n", " 'data': [{\n", " 'values': most_sold_item.iloc[:, 1],\n", " 'labels': val,\n", " 'name': 'Product',\n", " 'hoverinfo': 'label+percent+name',\n", " 'hole': .4,\n", " 'type': 'pie'\n", " }],\n", " 'layout': {\n", " 'title': \"Most Sold Product - Top 15 \",\n", " 'annotations': [{\n", " 'font': {\n", " 'size': 20\n", " },\n", " 'showarrow': False,\n", " 'text': 'Most Sold',\n", " 'x': .5,\n", " 'y': .5\n", " }]\n", " }\n", "}\n", "iplot(fig)" ] }, { "cell_type": "code", "execution_count": 24, "id": "e8261cd9", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T16:46:11.807074Z", "start_time": "2022-10-22T16:46:11.767499Z" } }, "outputs": [ { "data": { "application/vnd.plotly.v1+json": { "config": { "linkText": "Export to plot.ly", "plotlyServerURL": "https://plot.ly", "showLink": false }, "data": [ { "hoverinfo": "label+percent", "labels": [ "Coffee", "Bread", "Tea", "Cake", "Pastry", "NONE", "Sandwich", "Medialuna", "Hot chocolate", "Cookies", "Brownie", "Farm House", "Muffin", "Juice", "Alfajores" ], "marker": { "line": { "color": "#000000", "width": 2 } }, "textfont": { "size": 20 }, "textinfo": "value", "type": "pie", "values": [ 5471, 3325, 1435, 1025, 856, 786, 771, 616, 590, 540, 379, 374, 370, 369, 369 ] } ], "layout": { "template": { "data": { "bar": [ { "error_x": { "color": "#2a3f5f" }, "error_y": { "color": "#2a3f5f" }, "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "bar" } ], "barpolar": [ { "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "barpolar" } ], "carpet": [ { "aaxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "baxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "type": "carpet" } ], "choropleth": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "choropleth" } ], "contour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "contour" } ], "contourcarpet": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "contourcarpet" } ], "heatmap": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "heatmap" } ], "heatmapgl": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "heatmapgl" } ], "histogram": [ { "marker": { "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "histogram" } ], "histogram2d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "histogram2d" } ], "histogram2dcontour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "histogram2dcontour" } ], "mesh3d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "mesh3d" } ], "parcoords": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "parcoords" } ], "pie": [ { "automargin": true, "type": "pie" } ], "scatter": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter" } ], "scatter3d": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter3d" } ], "scattercarpet": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattercarpet" } ], "scattergeo": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergeo" } ], "scattergl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergl" } ], "scattermapbox": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattermapbox" } ], "scatterpolar": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolar" } ], "scatterpolargl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolargl" } ], "scatterternary": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterternary" } ], "surface": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "surface" } ], "table": [ { "cells": { "fill": { "color": "#EBF0F8" }, "line": { "color": "white" } }, "header": { "fill": { "color": "#C8D4E3" }, "line": { "color": "white" } }, "type": "table" } ] }, "layout": { "annotationdefaults": { "arrowcolor": "#2a3f5f", "arrowhead": 0, "arrowwidth": 1 }, "autotypenumbers": "strict", "coloraxis": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "colorscale": { "diverging": [ [ 0, "#8e0152" ], [ 0.1, "#c51b7d" ], [ 0.2, "#de77ae" ], [ 0.3, "#f1b6da" ], [ 0.4, "#fde0ef" ], [ 0.5, "#f7f7f7" ], [ 0.6, "#e6f5d0" ], [ 0.7, "#b8e186" ], [ 0.8, "#7fbc41" ], [ 0.9, "#4d9221" ], [ 1, "#276419" ] ], "sequential": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "sequentialminus": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ] }, "colorway": [ "#636efa", "#EF553B", "#00cc96", "#ab63fa", "#FFA15A", "#19d3f3", "#FF6692", "#B6E880", "#FF97FF", "#FECB52" ], "font": { "color": "#2a3f5f" }, "geo": { "bgcolor": "white", "lakecolor": "white", "landcolor": "#E5ECF6", "showlakes": true, "showland": true, "subunitcolor": "white" }, "hoverlabel": { "align": "left" }, "hovermode": "closest", "mapbox": { "style": "light" }, "paper_bgcolor": "white", "plot_bgcolor": "#E5ECF6", "polar": { "angularaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "radialaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "scene": { "xaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "yaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "zaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" } }, "shapedefaults": { "line": { "color": "#2a3f5f" } }, "ternary": { "aaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "baxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "caxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "title": { "x": 0.05 }, "xaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 }, "yaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 } } } } }, "text/html": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "labels = x\n", "values = y\n", "trace = go.Pie(labels=labels,\n", " values=values,\n", " hoverinfo=\"label+percent\",\n", " textinfo='value',\n", " textfont=dict(size=20),\n", " marker=dict(line=dict(color=\"#000000\", width=2)))\n", "iplot([trace], filename=\"graph_objs_pie_chart\")" ] }, { "cell_type": "markdown", "id": "9a3b81c0", "metadata": {}, "source": [ "## Hourly Trend analysis" ] }, { "cell_type": "code", "execution_count": 30, "id": "793346d3", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T17:01:13.737470Z", "start_time": "2022-10-22T17:01:13.659474Z" } }, "outputs": [], "source": [ "hours_list = sorted(list(dataset.Hour.unique()))\n", "items_per_hr = []\n", "\n", "for i in hours_list:\n", " x = dataset[dataset.Hour ==i]\n", " items_per_hr.append(Counter(x.Item))" ] }, { "cell_type": "code", "execution_count": 32, "id": "5596e082", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T17:01:48.787951Z", "start_time": "2022-10-22T17:01:48.780640Z" } }, "outputs": [ { "data": { "text/plain": [ "['01',\n", " '07',\n", " '08',\n", " '09',\n", " '10',\n", " '11',\n", " '12',\n", " '13',\n", " '14',\n", " '15',\n", " '16',\n", " '17',\n", " '18',\n", " '19',\n", " '20',\n", " '21',\n", " '22',\n", " '23']" ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "hours_list" ] }, { "cell_type": "code", "execution_count": 31, "id": "fca2773b", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T17:01:29.524092Z", "start_time": "2022-10-22T17:01:29.490291Z" } }, "outputs": [ { "data": { "text/plain": [ "[Counter({'Bread': 1}),\n", " Counter({'Coffee': 13,\n", " 'Pastry': 2,\n", " 'Bread': 2,\n", " 'Medialuna': 6,\n", " 'Toast': 1,\n", " 'NONE': 1}),\n", " Counter({'Coffee': 199,\n", " 'Cake': 8,\n", " 'Tartine': 1,\n", " 'NONE': 24,\n", " 'Bread': 171,\n", " 'Pastry': 57,\n", " 'Jam': 7,\n", " 'Tea': 21,\n", " 'Hot chocolate': 9,\n", " 'Coke': 1,\n", " 'Medialuna': 43,\n", " 'Farm House': 13,\n", " 'Sandwich': 5,\n", " 'Scandinavian': 6,\n", " 'Fudge': 2,\n", " 'Granola': 1,\n", " 'Brownie': 5,\n", " 'Keeping It Local': 3,\n", " 'Siblings': 2,\n", " 'Muffin': 3,\n", " 'Toast': 23,\n", " 'Cookies': 12,\n", " 'Scone': 6,\n", " 'Juice': 4,\n", " 'Vegan mincepie': 1,\n", " 'Alfajores': 4,\n", " 'Dulce de Leche': 1,\n", " 'Muesli': 2,\n", " 'Panatone': 1,\n", " 'Gingerbread syrup': 1,\n", " 'Afternoon with the baker': 3,\n", " 'Nomad bag': 1,\n", " 'Baguette': 8,\n", " 'Eggs': 1,\n", " 'Truffles': 1,\n", " 'Jammie Dodgers': 4,\n", " 'Spanish Brunch': 2,\n", " 'Mineral water': 2,\n", " 'Bakewell': 2,\n", " 'Mortimer': 2,\n", " 'Christmas common': 4,\n", " 'Tiffin': 1,\n", " 'Argentina Night': 2}),\n", " Counter({'Bread': 400,\n", " 'Coffee': 583,\n", " 'Pastry': 191,\n", " 'Medialuna': 120,\n", " 'Juice': 27,\n", " 'Jam': 22,\n", " 'Tea': 103,\n", " 'NONE': 79,\n", " 'Coke': 15,\n", " 'Farm House': 64,\n", " \"Ella's Kitchen Pouches\": 2,\n", " 'Victorian Sponge': 1,\n", " 'Alfajores': 19,\n", " 'Focaccia': 5,\n", " 'Tartine': 4,\n", " 'My-5 Fruit Shoot': 1,\n", " 'Hot chocolate': 56,\n", " 'Brownie': 22,\n", " 'Cookies': 39,\n", " 'Scandinavian': 24,\n", " 'Basket': 2,\n", " 'Cake': 40,\n", " 'Fudge': 12,\n", " 'Mineral water': 4,\n", " 'Muffin': 16,\n", " 'Sandwich': 17,\n", " 'Keeping It Local': 18,\n", " 'Granola': 4,\n", " 'The Nomad': 4,\n", " 'Jammie Dodgers': 4,\n", " 'Scone': 20,\n", " 'Toast': 64,\n", " 'Truffles': 2,\n", " 'Vegan mincepie': 4,\n", " 'Art Tray': 1,\n", " 'Tiffin': 9,\n", " 'Afternoon with the baker': 2,\n", " 'Spanish Brunch': 5,\n", " 'Raspberry shortbread sandwich': 1,\n", " 'Eggs': 4,\n", " 'Baguette': 22,\n", " 'Bakewell': 2,\n", " 'Extra Salami or Feta': 3,\n", " 'Nomad bag': 2,\n", " 'Chocolates': 2,\n", " 'Duck egg': 1,\n", " 'Cherry me Dried fruit': 1,\n", " 'Honey': 1,\n", " 'Salad': 1}),\n", " Counter({'Scandinavian': 43,\n", " 'Hot chocolate': 76,\n", " 'Jam': 23,\n", " 'Cookies': 77,\n", " 'Muffin': 60,\n", " 'Coffee': 820,\n", " 'Pastry': 203,\n", " 'Bread': 508,\n", " 'Medialuna': 125,\n", " 'Tea': 156,\n", " 'NONE': 97,\n", " 'Tartine': 3,\n", " 'Basket': 2,\n", " 'Mineral water': 5,\n", " 'Farm House': 55,\n", " 'Fudge': 20,\n", " 'Cake': 83,\n", " 'Soup': 2,\n", " 'Juice': 35,\n", " 'Alfajores': 36,\n", " 'Brownie': 34,\n", " 'Honey': 1,\n", " 'Smoothies': 8,\n", " 'Focaccia': 9,\n", " 'Hearty & Seasonal': 2,\n", " 'My-5 Fruit Shoot': 2,\n", " 'Empanadas': 1,\n", " 'Coke': 3,\n", " 'Keeping It Local': 13,\n", " \"Ella's Kitchen Pouches\": 2,\n", " 'Truffles': 13,\n", " 'Kids biscuit': 1,\n", " 'Caramel bites': 1,\n", " 'Sandwich': 20,\n", " 'Jammie Dodgers': 14,\n", " 'Bakewell': 7,\n", " 'The Nomad': 11,\n", " 'Scone': 32,\n", " 'Toast': 61,\n", " 'Dulce de Leche': 1,\n", " 'Lemon and coconut': 1,\n", " 'Vegan mincepie': 6,\n", " 'Crisps': 2,\n", " 'Frittata': 3,\n", " 'Muesli': 1,\n", " 'Tiffin': 14,\n", " 'Granola': 8,\n", " 'Spanish Brunch': 18,\n", " 'Eggs': 1,\n", " 'Baguette': 26,\n", " 'Gingerbread syrup': 1,\n", " 'Nomad bag': 1,\n", " \"Valentine's card\": 1,\n", " 'Art Tray': 1,\n", " 'Vegan Feast': 1,\n", " 'Afternoon with the baker': 4,\n", " 'Salad': 1,\n", " 'Cherry me Dried fruit': 1,\n", " 'Extra Salami or Feta': 1,\n", " 'Duck egg': 1,\n", " 'Drinking chocolate spoons ': 1,\n", " 'Coffee granules ': 1,\n", " 'Argentina Night': 2,\n", " 'Half slice Monster ': 1}),\n", " Counter({'Scandinavian': 58,\n", " 'Coffee': 946,\n", " 'Bread': 528,\n", " 'Jam': 28,\n", " 'NONE': 114,\n", " 'Basket': 2,\n", " 'Muffin': 74,\n", " 'Tea': 176,\n", " 'Juice': 66,\n", " 'Tartine': 11,\n", " 'Cake': 133,\n", " 'Farm House': 78,\n", " 'Cookies': 78,\n", " 'My-5 Fruit Shoot': 4,\n", " 'Pastry': 151,\n", " 'Soup': 14,\n", " 'Hearty & Seasonal': 7,\n", " 'Smoothies': 13,\n", " 'Medialuna': 108,\n", " 'The BART': 1,\n", " 'Brownie': 62,\n", " 'Mineral water': 9,\n", " 'Alfajores': 48,\n", " 'Fudge': 20,\n", " 'Hot chocolate': 91,\n", " 'Mighty Protein': 1,\n", " 'Victorian Sponge': 1,\n", " 'Focaccia': 6,\n", " 'Keeping It Local': 15,\n", " 'Truffles': 18,\n", " 'Art Tray': 3,\n", " 'Sandwich': 53,\n", " 'Kids biscuit': 1,\n", " \"Ella's Kitchen Pouches\": 5,\n", " 'The Nomad': 11,\n", " 'Jammie Dodgers': 17,\n", " 'Toast': 55,\n", " 'Scone': 51,\n", " 'Coke': 13,\n", " 'Vegan mincepie': 11,\n", " 'Bakewell': 7,\n", " 'Dulce de Leche': 2,\n", " 'Muesli': 2,\n", " 'Gingerbread syrup': 3,\n", " 'Panatone': 1,\n", " 'Frittata': 2,\n", " 'Tiffin': 25,\n", " 'Brioche and salami': 2,\n", " 'Granola': 4,\n", " 'Chicken Stew': 2,\n", " 'Afternoon with the baker': 1,\n", " 'Extra Salami or Feta': 7,\n", " 'Baguette': 28,\n", " 'Salad': 5,\n", " 'Spanish Brunch': 23,\n", " 'Eggs': 5,\n", " 'Crisps': 1,\n", " \"Valentine's card\": 2,\n", " 'Chocolates': 2,\n", " 'Vegan Feast': 1,\n", " 'Gift voucher': 1,\n", " 'Christmas common': 3,\n", " 'Coffee granules ': 3,\n", " 'Duck egg': 1,\n", " 'Honey': 1,\n", " 'Tacos/Fajita': 1}),\n", " Counter({'Scandinavian': 38,\n", " 'Fudge': 23,\n", " 'Coffee': 740,\n", " 'Medialuna': 55,\n", " 'Hot chocolate': 56,\n", " \"Ella's Kitchen Pouches\": 1,\n", " 'Juice': 56,\n", " 'Bread': 474,\n", " 'Muffin': 34,\n", " 'Jam': 15,\n", " 'Victorian Sponge': 2,\n", " 'Frittata': 17,\n", " 'Tea': 183,\n", " 'Hearty & Seasonal': 36,\n", " 'Soup': 83,\n", " 'Pick and Mix Bowls': 9,\n", " 'Cookies': 67,\n", " 'Farm House': 58,\n", " 'Tartine': 11,\n", " 'Pastry': 97,\n", " 'Sandwich': 162,\n", " 'NONE': 167,\n", " 'Coke': 25,\n", " 'Alfajores': 36,\n", " 'Mineral water': 29,\n", " 'Smoothies': 18,\n", " 'Focaccia': 6,\n", " 'Brownie': 44,\n", " 'My-5 Fruit Shoot': 2,\n", " 'Fairy Doors': 1,\n", " 'Cake': 127,\n", " 'Art Tray': 13,\n", " 'Empanadas': 1,\n", " 'Chimichurri Oil': 1,\n", " 'Eggs': 5,\n", " 'Truffles': 36,\n", " 'Kids biscuit': 1,\n", " 'Keeping It Local': 5,\n", " 'Jammie Dodgers': 21,\n", " 'Tiffin': 19,\n", " 'Scone': 49,\n", " 'Crepes': 1,\n", " 'The Nomad': 12,\n", " 'Vegan mincepie': 7,\n", " 'Toast': 45,\n", " 'Dulce de Leche': 1,\n", " 'Brioche and salami': 1,\n", " 'Muesli': 3,\n", " 'Lemon and coconut': 1,\n", " 'Salad': 15,\n", " 'Crisps': 2,\n", " 'Chicken Stew': 29,\n", " 'Afternoon with the baker': 3,\n", " 'Spanish Brunch': 33,\n", " 'Baguette': 23,\n", " 'Gingerbread syrup': 1,\n", " 'Extra Salami or Feta': 4,\n", " 'Granola': 5,\n", " 'Chocolates': 1,\n", " 'Vegan Feast': 2,\n", " 'Duck egg': 2,\n", " 'Nomad bag': 1,\n", " 'Christmas common': 1,\n", " 'Bakewell': 3,\n", " 'Drinking chocolate spoons ': 1,\n", " 'Tacos/Fajita': 1}),\n", " Counter({'Tea': 181,\n", " 'NONE': 159,\n", " 'Cookies': 61,\n", " 'Coffee': 607,\n", " 'Juice': 52,\n", " 'Pick and Mix Bowls': 1,\n", " 'Hearty & Seasonal': 39,\n", " 'Smoothies': 19,\n", " 'Cake': 124,\n", " 'Tartine': 9,\n", " 'Mighty Protein': 4,\n", " 'Frittata': 27,\n", " 'Mineral water': 30,\n", " 'Muffin': 52,\n", " 'Scandinavian': 31,\n", " 'Chicken sand': 1,\n", " 'Bread': 340,\n", " 'Victorian Sponge': 1,\n", " 'Fudge': 17,\n", " 'Soup': 112,\n", " 'Focaccia': 13,\n", " 'Sandwich': 234,\n", " 'Coke': 45,\n", " 'Alfajores': 42,\n", " 'Farm House': 37,\n", " 'Brownie': 55,\n", " 'Pastry': 48,\n", " 'Hot chocolate': 51,\n", " 'Eggs': 2,\n", " 'Bread Pudding': 1,\n", " 'Empanadas': 1,\n", " 'Art Tray': 9,\n", " 'Fairy Doors': 1,\n", " 'Bowl Nic Pitt': 1,\n", " 'Keeping It Local': 2,\n", " 'Bacon': 1,\n", " 'Medialuna': 36,\n", " 'My-5 Fruit Shoot': 1,\n", " 'Jam': 12,\n", " 'Spread': 1,\n", " 'Truffles': 32,\n", " 'The Nomad': 7,\n", " 'Bakewell': 6,\n", " 'Lemon and coconut': 3,\n", " 'Scone': 38,\n", " 'Crepes': 1,\n", " 'Vegan mincepie': 7,\n", " 'Toast': 23,\n", " 'Crisps': 5,\n", " 'Bare Popcorn': 1,\n", " 'Panatone': 3,\n", " 'Gingerbread syrup': 3,\n", " 'Jammie Dodgers': 14,\n", " 'Afternoon with the baker': 2,\n", " 'Tiffin': 21,\n", " 'Granola': 3,\n", " 'Salad': 34,\n", " 'Chicken Stew': 40,\n", " 'Spanish Brunch': 34,\n", " 'Extra Salami or Feta': 7,\n", " 'Baguette': 16,\n", " \"Valentine's card\": 1,\n", " 'Chocolates': 2,\n", " 'Duck egg': 3,\n", " 'Christmas common': 1,\n", " 'Drinking chocolate spoons ': 1,\n", " 'Half slice Monster ': 2,\n", " 'Argentina Night': 2,\n", " 'Tacos/Fajita': 4}),\n", " Counter({'Coffee': 636,\n", " 'Bread': 341,\n", " 'NONE': 96,\n", " 'Jam': 22,\n", " 'Frittata': 18,\n", " 'Scandinavian': 32,\n", " 'Fudge': 33,\n", " 'Tea': 233,\n", " 'Muffin': 60,\n", " 'Mighty Protein': 3,\n", " 'Hearty & Seasonal': 21,\n", " 'Coke': 36,\n", " 'Sandwich': 171,\n", " 'Hot chocolate': 68,\n", " 'Cookies': 49,\n", " 'Mineral water': 21,\n", " 'Juice': 44,\n", " 'Soup': 72,\n", " 'Pastry': 49,\n", " 'Cake': 182,\n", " 'Focaccia': 5,\n", " 'Alfajores': 56,\n", " 'Brownie': 58,\n", " 'Medialuna': 48,\n", " 'Dulce de Leche': 4,\n", " 'Victorian Sponge': 1,\n", " 'Empanadas': 2,\n", " 'Farm House': 21,\n", " 'Tartine': 2,\n", " 'Bowl Nic Pitt': 1,\n", " 'Bread Pudding': 2,\n", " 'Truffles': 41,\n", " 'Keeping It Local': 3,\n", " 'Kids biscuit': 2,\n", " 'Art Tray': 5,\n", " 'My-5 Fruit Shoot': 1,\n", " 'Olum & polenta': 1,\n", " 'Polenta': 1,\n", " 'Bakewell': 7,\n", " 'Spread': 1,\n", " 'Scone': 50,\n", " 'Crepes': 4,\n", " 'Toast': 22,\n", " 'Jammie Dodgers': 17,\n", " 'Crisps': 2,\n", " 'Eggs': 3,\n", " 'Afternoon with the baker': 9,\n", " 'The Nomad': 10,\n", " 'Tiffin': 19,\n", " 'Salad': 33,\n", " 'Chicken Stew': 30,\n", " 'Raspberry shortbread sandwich': 1,\n", " 'Extra Salami or Feta': 14,\n", " 'Duck egg': 3,\n", " 'Smoothies': 5,\n", " 'Spanish Brunch': 32,\n", " 'Granola': 2,\n", " 'Baguette': 12,\n", " 'Bare Popcorn': 2,\n", " \"Valentine's card\": 2,\n", " 'Nomad bag': 2,\n", " 'Coffee granules ': 2,\n", " 'Chocolates': 1,\n", " 'Drinking chocolate spoons ': 3,\n", " 'Mortimer': 1,\n", " 'Raw bars': 1,\n", " 'Tacos/Fajita': 4,\n", " 'Christmas common': 1}),\n", " Counter({'Mineral water': 18,\n", " 'Coffee': 519,\n", " 'Soup': 43,\n", " 'Tea': 207,\n", " 'Juice': 42,\n", " 'Alfajores': 64,\n", " 'Cake': 174,\n", " 'Muffin': 35,\n", " 'Hot chocolate': 89,\n", " 'Cookies': 77,\n", " 'Bread': 310,\n", " 'Sandwich': 75,\n", " 'Medialuna': 34,\n", " 'Dulce de Leche': 1,\n", " 'Farm House': 25,\n", " 'Fudge': 11,\n", " \"Ella's Kitchen Pouches\": 3,\n", " 'Brownie': 53,\n", " 'Jam': 9,\n", " 'Frittata': 10,\n", " 'Coke': 25,\n", " 'Granola': 1,\n", " 'Scandinavian': 17,\n", " 'Tartine': 4,\n", " 'Mighty Protein': 1,\n", " 'Pastry': 32,\n", " 'Focaccia': 1,\n", " 'Truffles': 26,\n", " 'Keeping It Local': 4,\n", " 'Victorian Sponge': 1,\n", " 'Jammie Dodgers': 23,\n", " 'Caramel bites': 2,\n", " 'My-5 Fruit Shoot': 2,\n", " 'Kids biscuit': 1,\n", " 'NONE': 32,\n", " 'Bakewell': 6,\n", " 'Tiffin': 15,\n", " 'Scone': 49,\n", " 'Smoothies': 7,\n", " 'Toast': 16,\n", " 'Vegan mincepie': 9,\n", " 'Crisps': 1,\n", " 'Hearty & Seasonal': 1,\n", " 'Afternoon with the baker': 4,\n", " 'Spanish Brunch': 22,\n", " 'Extra Salami or Feta': 1,\n", " 'Chicken Stew': 18,\n", " 'Baguette': 10,\n", " 'The Nomad': 2,\n", " 'Salad': 3,\n", " 'Argentina Night': 1,\n", " 'Vegan Feast': 1,\n", " 'Half slice Monster ': 3,\n", " 'Christmas common': 1,\n", " 'Drinking chocolate spoons ': 1,\n", " 'Honey': 2,\n", " 'Tacos/Fajita': 1,\n", " 'Eggs': 1,\n", " 'Cherry me Dried fruit': 1}),\n", " Counter({'Alfajores': 47,\n", " 'Coffee': 321,\n", " 'Juice': 30,\n", " 'Tea': 126,\n", " 'Soup': 15,\n", " 'Hot chocolate': 71,\n", " 'Cookies': 59,\n", " 'Medialuna': 25,\n", " 'Bread': 196,\n", " 'Eggs': 5,\n", " 'Pick and Mix Bowls': 2,\n", " 'Mineral water': 13,\n", " 'Brownie': 39,\n", " 'Cake': 124,\n", " 'Farm House': 14,\n", " 'Scandinavian': 15,\n", " 'Fudge': 6,\n", " 'Focaccia': 6,\n", " 'Jam': 3,\n", " 'Pastry': 16,\n", " 'Hearty & Seasonal': 1,\n", " 'Sandwich': 29,\n", " 'Empanadas': 1,\n", " 'Bread Pudding': 1,\n", " 'My-5 Fruit Shoot': 2,\n", " 'Chimichurri Oil': 1,\n", " 'Truffles': 17,\n", " 'Art Tray': 4,\n", " 'Muffin': 25,\n", " 'Kids biscuit': 5,\n", " 'Coke': 10,\n", " 'Tartine': 1,\n", " 'Jammie Dodgers': 8,\n", " 'NONE': 13,\n", " 'Hack the stack': 1,\n", " 'Bakewell': 8,\n", " 'Lemon and coconut': 1,\n", " 'Tiffin': 19,\n", " \"Ella's Kitchen Pouches\": 1,\n", " 'Scone': 28,\n", " 'Frittata': 4,\n", " 'Vegan mincepie': 7,\n", " 'Crisps': 1,\n", " 'Bare Popcorn': 1,\n", " 'Toast': 8,\n", " 'Raspberry shortbread sandwich': 1,\n", " 'Spanish Brunch': 3,\n", " 'Baguette': 6,\n", " 'Salad': 4,\n", " \"Valentine's card\": 1,\n", " 'Smoothies': 6,\n", " 'Afternoon with the baker': 1,\n", " 'Chocolates': 1,\n", " 'Drinking chocolate spoons ': 1,\n", " 'Vegan Feast': 1,\n", " 'Honey': 1}),\n", " Counter({'Bread': 46,\n", " 'Coffee': 69,\n", " 'Muffin': 9,\n", " 'Scandinavian': 10,\n", " 'Alfajores': 14,\n", " 'Fudge': 9,\n", " 'Tea': 41,\n", " 'Focaccia': 2,\n", " 'Farm House': 6,\n", " 'Dulce de Leche': 2,\n", " 'Juice': 8,\n", " 'My-5 Fruit Shoot': 3,\n", " \"Ella's Kitchen Pouches\": 3,\n", " 'Cookies': 20,\n", " 'Hot chocolate': 14,\n", " 'Brownie': 6,\n", " 'Pastry': 8,\n", " 'Medialuna': 11,\n", " 'Coke': 5,\n", " 'Art Tray': 2,\n", " 'Tartine': 1,\n", " 'NONE': 4,\n", " 'Kids biscuit': 1,\n", " 'Truffles': 3,\n", " 'Cake': 30,\n", " 'Hack the stack': 1,\n", " 'Jam': 6,\n", " 'Bare Popcorn': 1,\n", " 'Jammie Dodgers': 2,\n", " 'Smoothies': 1,\n", " 'Mineral water': 2,\n", " 'Baguette': 1,\n", " 'Sandwich': 4,\n", " 'Afternoon with the baker': 1,\n", " 'Soup': 1,\n", " 'Eggs': 1,\n", " 'Scone': 4,\n", " 'Chicken Stew': 4,\n", " 'Tiffin': 4,\n", " 'Vegan Feast': 2,\n", " 'The Nomad': 1,\n", " 'Duck egg': 1,\n", " 'Salad': 3,\n", " 'Mortimer': 2,\n", " 'Coffee granules ': 1,\n", " 'Extra Salami or Feta': 1,\n", " 'Chocolates': 1}),\n", " Counter({'Cookies': 1,\n", " 'Coffee': 11,\n", " 'Medialuna': 4,\n", " 'Mighty Protein': 2,\n", " 'Juice': 3,\n", " 'Mineral water': 2,\n", " 'Alfajores': 3,\n", " 'Hot chocolate': 4,\n", " 'Fudge': 4,\n", " 'Pastry': 2,\n", " 'Bread': 6,\n", " 'Empanadas': 1,\n", " 'Sandwich': 1,\n", " 'Tea': 5,\n", " 'Scandinavian': 2,\n", " 'Farm House': 3,\n", " 'Muffin': 2,\n", " 'Truffles': 3,\n", " 'Jam': 2,\n", " 'Afternoon with the baker': 14,\n", " 'Focaccia': 1,\n", " 'Tshirt': 5,\n", " 'Vegan Feast': 1}),\n", " Counter({'Coffee': 6,\n", " 'Tea': 3,\n", " 'Brownie': 1,\n", " 'Adjustment': 1,\n", " 'Hot chocolate': 3,\n", " 'Vegan mincepie': 1,\n", " 'Jammie Dodgers': 1,\n", " 'Medialuna': 1,\n", " 'Bread': 2,\n", " 'Coke': 6,\n", " 'Pintxos': 2,\n", " 'Juice': 1,\n", " 'Postcard': 3,\n", " 'Tshirt': 11,\n", " 'Truffles': 1,\n", " 'Fudge': 1,\n", " \"Valentine's card\": 4}),\n", " Counter({'Dulce de Leche': 1,\n", " 'Fudge': 1,\n", " 'Vegan mincepie': 1,\n", " 'Pintxos': 4,\n", " 'Coke': 1,\n", " 'Coffee': 1,\n", " 'Postcard': 7,\n", " 'Nomad bag': 1,\n", " 'Tshirt': 5}),\n", " Counter({'Hot chocolate': 2, 'Vegan Feast': 1}),\n", " Counter({'Juice': 1,\n", " 'Mineral water': 1,\n", " 'Vegan Feast': 5,\n", " 'Scandinavian': 1}),\n", " Counter({\"Valentine's card\": 2, 'Vegan Feast': 1})]" ] }, "execution_count": 31, "metadata": {}, "output_type": "execute_result" } ], "source": [ "items_per_hr" ] }, { "cell_type": "code", "execution_count": 34, "id": "87ec008d", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T17:07:53.326104Z", "start_time": "2022-10-22T17:07:53.305719Z" } }, "outputs": [], "source": [ "product_hours = pd.DataFrame(items_per_hr).set_index([hours_list])" ] }, { "cell_type": "code", "execution_count": 36, "id": "b5e680be", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T17:08:03.628729Z", "start_time": "2022-10-22T17:08:03.545018Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
BreadCoffeePastryMedialunaToastNONECakeTartineJamTea...SpreadBare PopcornOlum & polentaPolentaRaw barsHack the stackTshirtAdjustmentPintxosPostcard
011.0NaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
072.013.02.06.01.01.0NaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
08171.0199.057.043.023.024.08.01.07.021.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
09400.0583.0191.0120.064.079.040.04.022.0103.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
10508.0820.0203.0125.061.097.083.03.023.0156.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
11528.0946.0151.0108.055.0114.0133.011.028.0176.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
12474.0740.097.055.045.0167.0127.011.015.0183.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
13340.0607.048.036.023.0159.0124.09.012.0181.0...1.01.0NaNNaNNaNNaNNaNNaNNaNNaN
14341.0636.049.048.022.096.0182.02.022.0233.0...1.02.01.01.01.0NaNNaNNaNNaNNaN
15310.0519.032.034.016.032.0174.04.09.0207.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
16196.0321.016.025.08.013.0124.01.03.0126.0...NaN1.0NaNNaNNaN1.0NaNNaNNaNNaN
1746.069.08.011.0NaN4.030.01.06.041.0...NaN1.0NaNNaNNaN1.0NaNNaNNaNNaN
186.011.02.04.0NaNNaNNaNNaN2.05.0...NaNNaNNaNNaNNaNNaN5.0NaNNaNNaN
192.06.0NaN1.0NaNNaNNaNNaNNaN3.0...NaNNaNNaNNaNNaNNaN11.01.02.03.0
20NaN1.0NaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaN5.0NaN4.07.0
21NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
22NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
23NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "

18 rows × 95 columns

\n", "
" ], "text/plain": [ " Bread Coffee Pastry Medialuna Toast NONE Cake Tartine Jam \\\n", "01 1.0 NaN NaN NaN NaN NaN NaN NaN NaN \n", "07 2.0 13.0 2.0 6.0 1.0 1.0 NaN NaN NaN \n", "08 171.0 199.0 57.0 43.0 23.0 24.0 8.0 1.0 7.0 \n", "09 400.0 583.0 191.0 120.0 64.0 79.0 40.0 4.0 22.0 \n", "10 508.0 820.0 203.0 125.0 61.0 97.0 83.0 3.0 23.0 \n", "11 528.0 946.0 151.0 108.0 55.0 114.0 133.0 11.0 28.0 \n", "12 474.0 740.0 97.0 55.0 45.0 167.0 127.0 11.0 15.0 \n", "13 340.0 607.0 48.0 36.0 23.0 159.0 124.0 9.0 12.0 \n", "14 341.0 636.0 49.0 48.0 22.0 96.0 182.0 2.0 22.0 \n", "15 310.0 519.0 32.0 34.0 16.0 32.0 174.0 4.0 9.0 \n", "16 196.0 321.0 16.0 25.0 8.0 13.0 124.0 1.0 3.0 \n", "17 46.0 69.0 8.0 11.0 NaN 4.0 30.0 1.0 6.0 \n", "18 6.0 11.0 2.0 4.0 NaN NaN NaN NaN 2.0 \n", "19 2.0 6.0 NaN 1.0 NaN NaN NaN NaN NaN \n", "20 NaN 1.0 NaN NaN NaN NaN NaN NaN NaN \n", "21 NaN NaN NaN NaN NaN NaN NaN NaN NaN \n", "22 NaN NaN NaN NaN NaN NaN NaN NaN NaN \n", "23 NaN NaN NaN NaN NaN NaN NaN NaN NaN \n", "\n", " Tea ... Spread Bare Popcorn Olum & polenta Polenta Raw bars \\\n", "01 NaN ... NaN NaN NaN NaN NaN \n", "07 NaN ... NaN NaN NaN NaN NaN \n", "08 21.0 ... NaN NaN NaN NaN NaN \n", "09 103.0 ... NaN NaN NaN NaN NaN \n", "10 156.0 ... NaN NaN NaN NaN NaN \n", "11 176.0 ... NaN NaN NaN NaN NaN \n", "12 183.0 ... NaN NaN NaN NaN NaN \n", "13 181.0 ... 1.0 1.0 NaN NaN NaN \n", "14 233.0 ... 1.0 2.0 1.0 1.0 1.0 \n", "15 207.0 ... NaN NaN NaN NaN NaN \n", "16 126.0 ... NaN 1.0 NaN NaN NaN \n", "17 41.0 ... NaN 1.0 NaN NaN NaN \n", "18 5.0 ... NaN NaN NaN NaN NaN \n", "19 3.0 ... NaN NaN NaN NaN NaN \n", "20 NaN ... NaN NaN NaN NaN NaN \n", "21 NaN ... NaN NaN NaN NaN NaN \n", "22 NaN ... NaN NaN NaN NaN NaN \n", "23 NaN ... NaN NaN NaN NaN NaN \n", "\n", " Hack the stack Tshirt Adjustment Pintxos Postcard \n", "01 NaN NaN NaN NaN NaN \n", "07 NaN NaN NaN NaN NaN \n", "08 NaN NaN NaN NaN NaN \n", "09 NaN NaN NaN NaN NaN \n", "10 NaN NaN NaN NaN NaN \n", "11 NaN NaN NaN NaN NaN \n", "12 NaN NaN NaN NaN NaN \n", "13 NaN NaN NaN NaN NaN \n", "14 NaN NaN NaN NaN NaN \n", "15 NaN NaN NaN NaN NaN \n", "16 1.0 NaN NaN NaN NaN \n", "17 1.0 NaN NaN NaN NaN \n", "18 NaN 5.0 NaN NaN NaN \n", "19 NaN 11.0 1.0 2.0 3.0 \n", "20 NaN 5.0 NaN 4.0 7.0 \n", "21 NaN NaN NaN NaN NaN \n", "22 NaN NaN NaN NaN NaN \n", "23 NaN NaN NaN NaN NaN \n", "\n", "[18 rows x 95 columns]" ] }, "execution_count": 36, "metadata": {}, "output_type": "execute_result" } ], "source": [ "product_hours" ] }, { "cell_type": "code", "execution_count": 43, "id": "232cf008", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T17:21:28.290430Z", "start_time": "2022-10-22T17:21:28.189620Z" } }, "outputs": [], "source": [ "sales_list = []\n", "sales_list_sum = []\n", "sales_list_avg = []\n", "for i in hours_list:\n", " sales_list.append(product_hours.loc[i, :].sum())\n", " counter_val = dataset[dataset.Hour == i]\n", " sales_list_sum.append(counter_val.Item.value_counts())\n", " sales_list_avg.append(((counter_val.Item.value_counts())/len(counter_val.Hour)*100))\n", "sales_list = (pd.DataFrame(sales_list)).set_index([hours_list])\n", "sales_list['Hours'] = sales_list.index\n", "sales_list.columns = \"Number of sales\", \"Hours\"\n", "sales_list_sum = (pd.DataFrame(sales_list_sum)).set_index([hours_list])\n", "sales_list_percent = (pd.DataFrame(sales_list_avg)).set_index([hours_list])" ] }, { "cell_type": "code", "execution_count": 44, "id": "4d0d3474", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T17:21:35.181170Z", "start_time": "2022-10-22T17:21:35.166706Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Number of salesHours
011.001
0725.007
08669.008
092045.009
102763.010
113216.011
123021.012
132776.013
142736.014
152147.015
161356.016
17372.017
1882.018
1948.019
2022.020
213.021
228.022
233.023
\n", "
" ], "text/plain": [ " Number of sales Hours\n", "01 1.0 01\n", "07 25.0 07\n", "08 669.0 08\n", "09 2045.0 09\n", "10 2763.0 10\n", "11 3216.0 11\n", "12 3021.0 12\n", "13 2776.0 13\n", "14 2736.0 14\n", "15 2147.0 15\n", "16 1356.0 16\n", "17 372.0 17\n", "18 82.0 18\n", "19 48.0 19\n", "20 22.0 20\n", "21 3.0 21\n", "22 8.0 22\n", "23 3.0 23" ] }, "execution_count": 44, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sales_list" ] }, { "cell_type": "code", "execution_count": 45, "id": "fc3c0fe3", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T17:22:21.741528Z", "start_time": "2022-10-22T17:22:21.686999Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
BreadCoffeeMedialunaPastryNONEToastTeaFarm HouseCookiesHot chocolate...Bare PopcornSpreadRaw barsPolentaOlum & polentaHack the stackTshirtPostcardPintxosAdjustment
011.0NaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
072.013.06.02.01.01.0NaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
08171.0199.043.057.024.023.021.013.012.09.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
09400.0583.0120.0191.079.064.0103.064.039.056.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
10508.0820.0125.0203.097.061.0156.055.077.076.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
11528.0946.0108.0151.0114.055.0176.078.078.091.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
12474.0740.055.097.0167.045.0183.058.067.056.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
13340.0607.036.048.0159.023.0181.037.061.051.0...1.01.0NaNNaNNaNNaNNaNNaNNaNNaN
14341.0636.048.049.096.022.0233.021.049.068.0...2.01.01.01.01.0NaNNaNNaNNaNNaN
15310.0519.034.032.032.016.0207.025.077.089.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
16196.0321.025.016.013.08.0126.014.059.071.0...1.0NaNNaNNaNNaN1.0NaNNaNNaNNaN
1746.069.011.08.04.0NaN41.06.020.014.0...1.0NaNNaNNaNNaN1.0NaNNaNNaNNaN
186.011.04.02.0NaNNaN5.03.01.04.0...NaNNaNNaNNaNNaNNaN5.0NaNNaNNaN
192.06.01.0NaNNaNNaN3.0NaNNaN3.0...NaNNaNNaNNaNNaNNaN11.03.02.01.0
20NaN1.0NaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaN5.07.04.0NaN
21NaNNaNNaNNaNNaNNaNNaNNaNNaN2.0...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
22NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
23NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "

18 rows × 95 columns

\n", "
" ], "text/plain": [ " Bread Coffee Medialuna Pastry NONE Toast Tea Farm House \\\n", "01 1.0 NaN NaN NaN NaN NaN NaN NaN \n", "07 2.0 13.0 6.0 2.0 1.0 1.0 NaN NaN \n", "08 171.0 199.0 43.0 57.0 24.0 23.0 21.0 13.0 \n", "09 400.0 583.0 120.0 191.0 79.0 64.0 103.0 64.0 \n", "10 508.0 820.0 125.0 203.0 97.0 61.0 156.0 55.0 \n", "11 528.0 946.0 108.0 151.0 114.0 55.0 176.0 78.0 \n", "12 474.0 740.0 55.0 97.0 167.0 45.0 183.0 58.0 \n", "13 340.0 607.0 36.0 48.0 159.0 23.0 181.0 37.0 \n", "14 341.0 636.0 48.0 49.0 96.0 22.0 233.0 21.0 \n", "15 310.0 519.0 34.0 32.0 32.0 16.0 207.0 25.0 \n", "16 196.0 321.0 25.0 16.0 13.0 8.0 126.0 14.0 \n", "17 46.0 69.0 11.0 8.0 4.0 NaN 41.0 6.0 \n", "18 6.0 11.0 4.0 2.0 NaN NaN 5.0 3.0 \n", "19 2.0 6.0 1.0 NaN NaN NaN 3.0 NaN \n", "20 NaN 1.0 NaN NaN NaN NaN NaN NaN \n", "21 NaN NaN NaN NaN NaN NaN NaN NaN \n", "22 NaN NaN NaN NaN NaN NaN NaN NaN \n", "23 NaN NaN NaN NaN NaN NaN NaN NaN \n", "\n", " Cookies Hot chocolate ... Bare Popcorn Spread Raw bars Polenta \\\n", "01 NaN NaN ... NaN NaN NaN NaN \n", "07 NaN NaN ... NaN NaN NaN NaN \n", "08 12.0 9.0 ... NaN NaN NaN NaN \n", "09 39.0 56.0 ... NaN NaN NaN NaN \n", "10 77.0 76.0 ... NaN NaN NaN NaN \n", "11 78.0 91.0 ... NaN NaN NaN NaN \n", "12 67.0 56.0 ... NaN NaN NaN NaN \n", "13 61.0 51.0 ... 1.0 1.0 NaN NaN \n", "14 49.0 68.0 ... 2.0 1.0 1.0 1.0 \n", "15 77.0 89.0 ... NaN NaN NaN NaN \n", "16 59.0 71.0 ... 1.0 NaN NaN NaN \n", "17 20.0 14.0 ... 1.0 NaN NaN NaN \n", "18 1.0 4.0 ... NaN NaN NaN NaN \n", "19 NaN 3.0 ... NaN NaN NaN NaN \n", "20 NaN NaN ... NaN NaN NaN NaN \n", "21 NaN 2.0 ... NaN NaN NaN NaN \n", "22 NaN NaN ... NaN NaN NaN NaN \n", "23 NaN NaN ... NaN NaN NaN NaN \n", "\n", " Olum & polenta Hack the stack Tshirt Postcard Pintxos Adjustment \n", "01 NaN NaN NaN NaN NaN NaN \n", "07 NaN NaN NaN NaN NaN NaN \n", "08 NaN NaN NaN NaN NaN NaN \n", "09 NaN NaN NaN NaN NaN NaN \n", "10 NaN NaN NaN NaN NaN NaN \n", "11 NaN NaN NaN NaN NaN NaN \n", "12 NaN NaN NaN NaN NaN NaN \n", "13 NaN NaN NaN NaN NaN NaN \n", "14 1.0 NaN NaN NaN NaN NaN \n", "15 NaN NaN NaN NaN NaN NaN \n", "16 NaN 1.0 NaN NaN NaN NaN \n", "17 NaN 1.0 NaN NaN NaN NaN \n", "18 NaN NaN 5.0 NaN NaN NaN \n", "19 NaN NaN 11.0 3.0 2.0 1.0 \n", "20 NaN NaN 5.0 7.0 4.0 NaN \n", "21 NaN NaN NaN NaN NaN NaN \n", "22 NaN NaN NaN NaN NaN NaN \n", "23 NaN NaN NaN NaN NaN NaN \n", "\n", "[18 rows x 95 columns]" ] }, "execution_count": 45, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sales_list_sum" ] }, { "cell_type": "code", "execution_count": 46, "id": "b3bc2dc5", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T17:22:37.774808Z", "start_time": "2022-10-22T17:22:37.742267Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
BreadCoffeeMedialunaPastryNONEToastTeaFarm HouseCookiesHot chocolate...Bare PopcornSpreadRaw barsPolentaOlum & polentaHack the stackTshirtPostcardPintxosAdjustment
01100.000000NaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
078.00000052.00000024.0000008.0000004.0000004.000000NaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
0825.56053829.7458896.4275048.5201793.5874443.4379673.1390131.9431991.7937221.345291...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
0919.55990228.5085575.8679719.3398533.8630813.1295845.0366753.1295841.9070902.738386...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1018.38581329.6778864.5240687.3470873.5106772.2077455.6460371.9905902.7868262.750633...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1116.41791029.4154233.3582094.6952743.5447761.7101995.4726372.4253732.4253732.829602...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1215.69016924.4952001.8205893.2108575.5279711.4895736.0575971.9198942.2178091.853691...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1312.24783921.8659941.2968301.7291075.7276660.8285306.5201731.3328532.1974061.837176...0.0360230.036023NaNNaNNaNNaNNaNNaNNaNNaN
1412.46345023.2456141.7543861.7909363.5087720.8040948.5160820.7675441.7909362.485380...0.0730990.0365500.036550.036550.03655NaNNaNNaNNaNNaN
1514.43875224.1732651.5836051.4904521.4904520.7452269.6413601.1644153.5864004.145319...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1614.45427723.6725661.8436581.1799410.9587020.5899719.2920351.0324484.3510325.235988...0.073746NaNNaNNaNNaN0.073746NaNNaNNaNNaN
1712.36559118.5483872.9569892.1505381.075269NaN11.0215051.6129035.3763443.763441...0.268817NaNNaNNaNNaN0.268817NaNNaNNaNNaN
187.31707313.4146344.8780492.439024NaNNaN6.0975613.6585371.2195124.878049...NaNNaNNaNNaNNaNNaN6.097561NaNNaNNaN
194.16666712.5000002.083333NaNNaNNaN6.250000NaNNaN6.250000...NaNNaNNaNNaNNaNNaN22.9166676.2500004.1666672.083333
20NaN4.545455NaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaN22.72727331.81818218.181818NaN
21NaNNaNNaNNaNNaNNaNNaNNaNNaN66.666667...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
22NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
23NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "

18 rows × 95 columns

\n", "
" ], "text/plain": [ " Bread Coffee Medialuna Pastry NONE Toast Tea \\\n", "01 100.000000 NaN NaN NaN NaN NaN NaN \n", "07 8.000000 52.000000 24.000000 8.000000 4.000000 4.000000 NaN \n", "08 25.560538 29.745889 6.427504 8.520179 3.587444 3.437967 3.139013 \n", "09 19.559902 28.508557 5.867971 9.339853 3.863081 3.129584 5.036675 \n", "10 18.385813 29.677886 4.524068 7.347087 3.510677 2.207745 5.646037 \n", "11 16.417910 29.415423 3.358209 4.695274 3.544776 1.710199 5.472637 \n", "12 15.690169 24.495200 1.820589 3.210857 5.527971 1.489573 6.057597 \n", "13 12.247839 21.865994 1.296830 1.729107 5.727666 0.828530 6.520173 \n", "14 12.463450 23.245614 1.754386 1.790936 3.508772 0.804094 8.516082 \n", "15 14.438752 24.173265 1.583605 1.490452 1.490452 0.745226 9.641360 \n", "16 14.454277 23.672566 1.843658 1.179941 0.958702 0.589971 9.292035 \n", "17 12.365591 18.548387 2.956989 2.150538 1.075269 NaN 11.021505 \n", "18 7.317073 13.414634 4.878049 2.439024 NaN NaN 6.097561 \n", "19 4.166667 12.500000 2.083333 NaN NaN NaN 6.250000 \n", "20 NaN 4.545455 NaN NaN NaN NaN NaN \n", "21 NaN NaN NaN NaN NaN NaN NaN \n", "22 NaN NaN NaN NaN NaN NaN NaN \n", "23 NaN NaN NaN NaN NaN NaN NaN \n", "\n", " Farm House Cookies Hot chocolate ... Bare Popcorn Spread \\\n", "01 NaN NaN NaN ... NaN NaN \n", "07 NaN NaN NaN ... NaN NaN \n", "08 1.943199 1.793722 1.345291 ... NaN NaN \n", "09 3.129584 1.907090 2.738386 ... NaN NaN \n", "10 1.990590 2.786826 2.750633 ... NaN NaN \n", "11 2.425373 2.425373 2.829602 ... NaN NaN \n", "12 1.919894 2.217809 1.853691 ... NaN NaN \n", "13 1.332853 2.197406 1.837176 ... 0.036023 0.036023 \n", "14 0.767544 1.790936 2.485380 ... 0.073099 0.036550 \n", "15 1.164415 3.586400 4.145319 ... NaN NaN \n", "16 1.032448 4.351032 5.235988 ... 0.073746 NaN \n", "17 1.612903 5.376344 3.763441 ... 0.268817 NaN \n", "18 3.658537 1.219512 4.878049 ... NaN NaN \n", "19 NaN NaN 6.250000 ... NaN NaN \n", "20 NaN NaN NaN ... NaN NaN \n", "21 NaN NaN 66.666667 ... NaN NaN \n", "22 NaN NaN NaN ... NaN NaN \n", "23 NaN NaN NaN ... NaN NaN \n", "\n", " Raw bars Polenta Olum & polenta Hack the stack Tshirt Postcard \\\n", "01 NaN NaN NaN NaN NaN NaN \n", "07 NaN NaN NaN NaN NaN NaN \n", "08 NaN NaN NaN NaN NaN NaN \n", "09 NaN NaN NaN NaN NaN NaN \n", "10 NaN NaN NaN NaN NaN NaN \n", "11 NaN NaN NaN NaN NaN NaN \n", "12 NaN NaN NaN NaN NaN NaN \n", "13 NaN NaN NaN NaN NaN NaN \n", "14 0.03655 0.03655 0.03655 NaN NaN NaN \n", "15 NaN NaN NaN NaN NaN NaN \n", "16 NaN NaN NaN 0.073746 NaN NaN \n", "17 NaN NaN NaN 0.268817 NaN NaN \n", "18 NaN NaN NaN NaN 6.097561 NaN \n", "19 NaN NaN NaN NaN 22.916667 6.250000 \n", "20 NaN NaN NaN NaN 22.727273 31.818182 \n", "21 NaN NaN NaN NaN NaN NaN \n", "22 NaN NaN NaN NaN NaN NaN \n", "23 NaN NaN NaN NaN NaN NaN \n", "\n", " Pintxos Adjustment \n", "01 NaN NaN \n", "07 NaN NaN \n", "08 NaN NaN \n", "09 NaN NaN \n", "10 NaN NaN \n", "11 NaN NaN \n", "12 NaN NaN \n", "13 NaN NaN \n", "14 NaN NaN \n", "15 NaN NaN \n", "16 NaN NaN \n", "17 NaN NaN \n", "18 NaN NaN \n", "19 4.166667 2.083333 \n", "20 18.181818 NaN \n", "21 NaN NaN \n", "22 NaN NaN \n", "23 NaN NaN \n", "\n", "[18 rows x 95 columns]" ] }, "execution_count": 46, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sales_list_percent" ] }, { "cell_type": "code", "execution_count": 50, "id": "70f54c31", "metadata": { "ExecuteTime": { "end_time": "2022-10-22T17:28:31.309541Z", "start_time": "2022-10-22T17:28:31.083206Z" } }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 50, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAA3wAAAGpCAYAAADWeDSXAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAxgElEQVR4nO3de1yUdaLH8e+gTHIASV8qZWiJIt7STM1yM7soaWmmm4KObKVtXhIDMkW76Japq5bXWryUJpdka8tzTtuek1tbu+Epb6CePYhZWqmUponAaAzDnD96ycrNsYC5/Pi8X695vWYeZp75PsPIb77+nucZi8vlcgkAAAAAYJwAbwcAAAAAADQMCh8AAAAAGIrCBwAAAACGovABAAAAgKEofAAAAABgKAofAAAAABiqqbcD1FV0dLS3IwAAAACAV+Xn59e43O8Ln1T7xgEAAACA6S41CcYunQAAAABgKAofAAAAABjKiF06AQAAgF+qvLxcx48fl8Ph8HYUwK3AwEC1bdtWAQGXN3dH4QMAAECjdvz4cTVv3lzNmzf3dhTArbNnz+r48eOKiIi4rPuzSycAAAAaNYfDQdmD32jevPnPmo2m8AEAAACAoSh8AAAAgAc5nU4tWLBAEydO1EMPPaR33nmn1vvGx8erpKTkZz9HTEyM4uPjKy47duyoS+QGN3r06HpfZ0lJieLj4+t9vTU5evSoZsyYUWlZQ2zTL8ExfAAAAMBFSh1OWQObNNg6/v73v+uKK67Qa6+9pvLycsXGxmrgwIFq1apVnZ7zYiEhIUpLS6u39cF/UfgAAACAi1gDm2j8rIw6rSNzia3Wn7Vp00bZ2dm69dZb1adPH2VkZMhqteqrr77S888/rx9//FHBwcF6+eWXKx6Tk5OjJUuWyOVyacKECRo+fLieeOIJfffdd7JarVq+fLnCwsIumSklJUWFhYVq06aNHnroIc2bN08Oh0ODBw/WpEmT9Kc//UkZGRm67rrrdOLECaWnp2v06NF6++23VVJSoilTpigtLU1btmzR1q1b1aRJEz3zzDMKCQnRU089paCgIB07dkwLFixQr169tGDBAu3du1dWq1WrVq3SE088oU2bNuncuXOaOnWqNm3aVJHN4XAoMTFRx44d09SpU3XnnXdqzZo12r17twoLC5WQkKCePXsqMTFRTqdTnTp10nPPPVfj6/Lyyy/ro48+UocOHWp8DSZOnKjOnTtrxowZmjVrltasWaOAgAB9+eWX6tq1q+bNm6ddu3Zp6dKlkqRhw4bpoYce0qRJk3Tddddp3759GjBggJKSki7rvZCRkaGtW7cqICBASUlJioiI0JIlS7Rq1SodPHhQr732mqZPn67p06erWbNmmjNnjpYtW1ZpO+uCwgcAAAB4UPfu3ZWQkKB169YpLy9PI0eO1OzZs3XkyBGlpKSoU6dOeuyxx/TFF19UPObFF1/UK6+8oubNm+uhhx7SoEGD9PXXX2vz5s3av3+/zp49W6nwFRcXV+zO2KpVKy1fvlySNGrUKMXExGj69On63e9+pw4dOighIUHHjh1Tenq6srKydOLECU2aNKnG7KdPn9Z7772nzMxMnTp1Sk8//bSeeeYZnTx5Uu+++662b9+uP/3pTwoMDNSZM2f05ptvKjs7WwcPHpTVatWJEye0Z88e3X777ZXWW1paqpSUFDVv3lzx8fG67bbbFBoaqo0bN+rAgQN65ZVX5HK5FB0drblz5+rPf/6zSktLq70uffr00aeffqo//vGP2rt3r1588cXL+p386le/0sKFC/XEE0/owIEDWrZsmf7whz+oRYsWmjhxogYPHqzS0lKNGDFCTz31lO6+++5qhW/Hjh3VdiE9deqU3nvvPWVlZamoqEgPP/ywVq1aVWOG8vJybdmyRR9++GG17bRarZe1HTWh8AEAAAAe9Pnnn6tPnz666667VFxcrMTERP3jH/9QmzZt9Ic//EFWq1VHjx6V0+mseMyhQ4cqjhH74YcfdObMGT388MOaMWOGgoKClJKSUuk5atuls3379pKkr776Ss8++6ykf53mPzw8XFarVREREWrTpk2lx7lcLknSN998oyNHjujBBx+U9FNRk6SOHTsqICBAbdq0UWlpqY4cOaJu3bpJ+qlMSdJ3332nbdu2affu3Zo9e3al9bdu3VpXXXWVpJ++Z87lcun06dOaPXu2AgICVFZWpttuu00HDhzQxIkTFRkZqbvvvrva63Ly5El17txZFotFPXr0uOTv4cI2SdINN9wgSerWrZu++uorlZWVqWXLlpJ+Kuhff/21JKlTp04KCAhQaGhotfXddNNNlcrc6NGjdfToUXXp0kUBAQEKCwtTYGCgysrKasxw4XdT03bWBSdtAQAAADwoOztbGzdulPRTMWvbtm3Fbo9Tp07VggULZLVaK5WBqKgorV27Vps3b9awYcN0xRVX6Pjx41q/fr3uvPPOS5745WIXvqw7IiJCy5YtU1pamkaPHq327dvrxIkT+vHHH/X999/r5MmTkn468Ul5ebk+//xzSVLbtm3VrVs3paWlaeXKlYqJiZEkWSyWSs8TERGhvLw8SdLHH3+srKwsDR48WB9//LHsdrvCw8Mr3f/kyZP6/vvvVVxcLKfTqc8//1xHjhzR73//ew0ZMkQul0u7du1Sly5dKnYL3bdvX7XX5aqrrlJeXp7Ky8uVn59fbfutVqtOnTqlsrIyHT58uGL5haz79+9XZGSkmjRpotOnT8vlcmnfvn1q27ZtjdvpzjXXXKMDBw6ovLxchYWFstvtCg4O1qlTpySp4nW9+HdT03bWBTN8AAAAgAfZbDYtXLhQo0ePVnBwsPr27atbbrlFx44dU0JCgq688ko1a9asonRJUkJCgh555BGdO3dOd9xxh1q3bq2DBw9qzJgxCgoK0vPPP/+zMiQlJenJJ5/UuXPnFB0drfj4eE2bNk0TJkzQ1VdfrcDAQEnSkCFDNHbsWF1//fUKCgpS69atdcstt2j8+PEqKSlRQkJCjevv2bOnWrRoIZvNpsDAQL300ksKCQlRs2bNdMstt1S7f4sWLfS73/1OBQUFSkpK0rXXXqvvvvtOsbGxCg8PV1FRkaKiopSQkKDXXntNLVu21PXXX1/tdWnTpo3uvfdejRkzRl26dKn2PPfff7/mzZunq6++utIs5ltvvaUNGzaod+/eioqK0pNPPqlp06aprKxMI0aM0HXXXfezXt8LWrVqpWHDhikuLk5Op1PPPvusWrdurauvvlrjxo2rmAW9WE3bWRcW18X/deCHoqOja2zvAAAAwOU4fPhwpRN8NPRZOv3BhZO11LfHH39c8+bNq9hd0hdcfCIXf1H1PXupTsQunQAAAMBF6qOo+XPZayhTpkxRp06dfKrsNQbM8AEAAKBRqzpbAvg6ZvgA+KxSh9P9nTzMFzMBAADUB07aAsCj6uPLbOvbpb4cFwBgPpfLJYfDUXGiEsCXORwO/ZydNCl8AAAAaNTatGmj48ePq7y83NtRALcufN/h5aLwAQAAoFELCQlRSEiIt2MADYJj+AAAAADAUBQ+AAAAADAUhQ8AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAAADAUBQ+AAAAADAUhQ8AAAAADEXhAwAAAABDUfgAAAAAwFANUviKi4v1yCOPKDY2VuvWrVNxcbEmTZqkcePGaePGjZKkgoIC2Ww2xcXF6d1335Uk5eXlKTY2VnFxcfrss88aIhoAAAAANBoNUvi2bt2qmJgYZWVl6X/+53+UmZmpkSNHKjMzU9nZ2Tp58qRSU1OVnJyszZs3KyMjQ6WlpVqxYoWWL1+u9evXa9WqVQ0RDQB+sVKH09sRqvHFTAAAwHc0bYiVTpgwQU6nU6WlpbLb7dq7d69Gjhwpi8Wifv36KTc3V3l5eZo/f74sFouioqJ06NAhnT59Wm3btpUkNWvWTIWFhQoLC2uIiADws1kDm2j8rAxvx6gkc4nN2xEAAIAPa5DCJ0klJSX69a9/raioKBUXFys4OFiSFBQUpJKSEpWXl8tisVQss9vtcrlcFY+/sOziwrd69WqtWbOmoSIDAAAAgFEa7KQtzZs317Zt29SlSxft27dPdrtdkmS32xUaGqqAgH89td1uV0hISEUBlKRz584pJCSk0joTEhKUn59f6QIAAAAAqFmDFL7XXntNH3/8saSfZup++9vfaseOHZKknTt3qkePHoqKilJOTo4cDofy8/MVGRmpsLAwFRQUqKioSCUlJQoNDW2IeAAAAADQKDTILp333nuvZs2apQ0bNqhNmzaaM2eOUlJStGnTJt11110KDw/X1KlTlZKSIrvdLpvNJqvVqqSkJCUmJsrhcCgxMbEhogEAAABAo9EghS88PFyvv/56pWUbNmyodDsiIkLp6emVlnXv3l1ZWVkNEQkAAAAAGh2+eB0AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAAADAUBQ+AAAAADAUhQ8AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAMOVOpzejlCNL2YCAMBETb0dAMAvU+pwyhrYxNsxKvHFTJCsgU00flaGt2NUkrnE5u0IAAA0ChQ+wE/xIR4AAADusEsnAAAAABiKwgcA8Fm+eKyfL2YCAKA27NIJAPBZ7LoMAEDdMMMHAAAAAIai8AEAAACAoSh8AAAAAGAoCh8AAAAAGIrCBwAAAACGovABAAAAgKEofAAAAABgKAofAAAAABiKwgcAAAAAhqLwAQAAAIChKHwAAAAAYCgKHwAAAAAYisIHAAAAAIai8AEAAACAoSh8AAAAAGAoCh8AAAAAGIrCBwAAAACGovABAAAAgKEofAAAAABgKAofAAAAABiKwgcAAAAAhqLwAQAAAIChmtb3CouLi5WUlKTz58+rRYsWevbZZ3X//ferQ4cOkqRly5apvLxcM2fOlNPp1IQJEzR8+HDl5eVp/vz5slgsSkpKUv/+/es7GgAAAAA0KvU+w7dlyxYNHTpUaWlp6tixo7Zs2aK4uDilpaUpLS1N4eHhSk1NVXJysjZv3qyMjAyVlpZqxYoVWr58udavX69Vq1bVdywAAAAAaHTqvfDFxcVpxIgRkiSn06nQ0FBlZ2dr/PjxWrt2rSQpLy9PN954o6xWq6KionTo0CGdPn1abdu2VWhoqJo1a6bCwsL6jgYAAAAAjUq9F76QkBBZrVbt3btXO3bsULt27ZScnKz09HTt379fubm5Ki8vl8VikSQFBQXJbrfL5XJVrOPCsqpWr16t6OjoShcAAAAAQM3q/Rg+Sdq9e7cWLlyoV155RSEhIQoKClJAQIAGDBigQ4cOKSDgXz3TbrcrJCSkogBK0rlz5xQSElJtvQkJCUpISKi0jNIHAAAAADWr9xm+w4cPa+HChUpNTVV4eLgWL16sTz75RNJPRbBz586KiopSTk6OHA6H8vPzFRkZqbCwMBUUFKioqEglJSUKDQ2t72gAAAAA0KjU+wzfunXrVFRUpOTkZEnS6NGjtX79eq1du1b9+/dXz5491bJlS6WkpMhut8tms8lqtSopKUmJiYlyOBxKTEys71gAAAAA0OjUe+FbtGhRtWWjRo2qdDsiIkLp6emVlnXv3l1ZWVn1HQcAAAAAGi2+eB0AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAAADAUBQ+AAAAADAUhQ8AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAAADAUBQ+AAAAADAUhQ8AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAAADAUBQ+AADqWanD6e0I1fhiJgBAw2vq7QAAAJjGGthE42dleDtGJZlLbN6OAADwAmb4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAAADAUBQ+AAAAADAUhQ8AAAAADEXhAwAAAABDUfgAAAAAwFAUPjRqpQ6ntyNU44uZAAAA4J+aejsA4E3WwCYaPyvD2zEqyVxi83YEAAAAGKLeZ/iKi4v129/+VvHx8ZoxY4aKioo0adIkjRs3Ths3bpQkFRQUyGazKS4uTu+++64kKS8vT7GxsYqLi9Nnn31W37EAAAAAoNGp98K3ZcsWDR06VGlpaerYsaPeeOMNjRw5UpmZmcrOztbJkyeVmpqq5ORkbd68WRkZGSotLdWKFSu0fPlyrV+/XqtWrarvWAAAAADQ6NR74YuLi9OIESMkSU6nU+vXr1f//v1lsVjUr18/5ebmKi8vTzfeeKOsVquioqJ06NAhnT59Wm3btlVoaKiaNWumwsLC+o4GAAAAAI1KvR/DFxISIknau3evduzYoW7duik4OFiSFBQUpJKSEpWXl8tisVQss9vtcrlcFeu4sCwsLKzSulevXq01a9bUd2QAAAAAMFKDnKVz9+7deu6557Ry5UoFBwfLbrdLkux2u0JDQxUQ8K+ntdvtCgkJqSiAknTu3LmK4nixhIQE5efnV7oAAAAAAGrmtvB9/fXX2r9/v/7v//5PiYmJ2r179yXvf/jwYS1cuFCpqakKDw9Xjx49tGPHDknSzp071aNHD0VFRSknJ0cOh0P5+fmKjIxUWFiYCgoKVFRUpJKSEoWGhtbPFgIAAABAI+W28M2dO1cWi0WrVq3S+PHjtXz58kvef926dSoqKlJycrLi4+MVFRWlrVu36oEHHlDfvn0VHh6uqVOn6sUXX1RsbKxiY2NltVqVlJSkxMREPfjgg5o2bVq9bSAAAAAANFZuj+ELCAhQVFSUysrKdNNNN6m0tPSS91+0aFG1ZUOGDKl0OyIiQunp6ZWWde/eXVlZWZeTGQAAAABwGdzO8AUHB2vy5MkaOnSo0tPT1apVK0/kAgAAAADUkdsZvpUrV+rrr79Wp06ddPDgQY0ZM8YTuQAAAAAAdeS28H377bdaunSpzpw5o2HDhunUqVO65ZZbPJENAAAAAFAHbnfpnDdvnmbPni2r1arBgwdr6dKlnsgFAAAAAKgjt4WvrKxMkZGRslgsioiIqPgSdQAAAACAb3Nb+K6++mq98sorOnv2rNLS0tSmTRtP5AIAAAAA1JHbwrdgwQKFhYWpd+/ekmr+2gUAAAAAgO+p9aQtW7durbgeHBysXr16SZLee+893X///Q2dCwAAAABQR7UWvqNHj3oyBwAAAACgntVa+KZPny5Jcrlc+vLLL+VwOCRJJ06c8EwyAAAAAECduP0evscff1xFRUU6efKknE6nWrVqpdtuu80T2QAAAAAAdeD2pC2nT5/Wxo0bdcMNN+idd96R0+n0RC4AAAAAQB25LXwBAQFyOp06d+6cmjVrpvPnz3siFwAAAACgjtwWvjFjxujVV19V//79dccddygiIsITuQAAAAAAdeT2GL4RI0ZUXB80aJDCw8MbNBAAAAAAoH64LXxvvvmmmjRpouLiYqWlpemee+5RUlKSJ7IBAAAAAOrA7S6db775poYPH65t27bp/fffV05OjidyAQAAAADqyG3hs1gs+uabb3TVVVfJ4XDohx9+8EQuAAAAAEAduS189913n+bMmaNHHnlES5Ys0fjx4z2RCwAAAABQR26P4bPZbLLZbJKkp59+usEDAQAAAADqh9sZPgAAAACAf6q18G3fvl2SdPbsWY+FAQAAAADUn1oL37Jly/T111/r0UcfVUFBgY4fP15xAQAAAAD4vlqP4fv1r3+tefPm6YsvvtCsWbMqllssFm3evNkj4QAAAAAAv1ythe/CyVreeecdjRo1ypOZAAAAAAD1wO1JW7p06aKxY8cqJiZGo0aN0r59+zyRCwAAAABQR26/lmHhwoVaunSprr32Wh05ckSzZ89WVlaWJ7IBAAAAAOrA7QxfeXm5rr32WknSddddp6ZN3XZEAAAAAIAPcNverrrqKq1evVq9e/fWnj17FB4e7olcAAAAAIA6cjvDt3jxYrVo0UIffPCBrrzySi1evNgTuQAAAAAAdeR2hi8wMFATJkzwRBYAAAAAQD1yO8MHAAAAAPBPbgtfdna2J3IAAAAAAOqZ28L38ssveyIHAAAAAKCeuT2Gr6ysTGPHjlVkZKQsFoskadGiRQ0eDAAAAABQN24L38yZMz2RAwAAAABQz9zu0tmrVy/t27dP27Ztk91uV7t27TyRCwAAAABQR24L39y5cxUSEqL//d//VZMmTTRr1ixP5AIAAAAA1JHbwvf9998rLi5OgYGBGjhwoJxOpydyAQAAAADqyG3ha9q0qXbt2iWXy6X8/HwFBQV5IhcAAAAAoI7cFr7nnntOaWlpOn36tNasWaN58+Z5IhcAAAAAoI7cnqXzmmuu0bRp03T48GFFRUWpffv2nsgFAAAAAKgjt4VvzZo12rNnj7p3767MzEwNGjRIkyZN8kQ2AAAAAEAduC182dnZeuONNyRJ5eXlGjduHIUPAAAAAPyA22P4wsPDderUKUnS2bNnFR4e3uChAAAAAAB1V+sM35133imLxaJz585p8ODBateunY4ePaqWLVt6Mh8AAAAA4BeqtfB9+OGHnswBAAAAAKhnbo/h+8tf/qK3335bP/74Y8WyzZs3N2goAAAAAEDduS18q1at0ksvvaTmzZv/7JUvWrRIN998s3r37q3hw4erQ4cOkqRly5apvLxcM2fOlNPp1IQJEzR8+HDl5eVp/vz5slgsSkpKUv/+/X/+FgEAAAAAJF1G4evcubOio6MVEOD2/C4VnE6n5syZo127dunmm2/WwYMHFRcXp+nTp1fcZ968eUpOTtb111+vBx98UDExMVqxYoWWL1+u0NBQTZkyRRkZGb9sqwAAAAAA7gtf//79NXjwYEVERMjlcslisbjdpdPpdGrEiBFq166dJOngwYPKzs7W9u3bNWjQIE2ePLnSbF5UVJQOHTqk06dPq23btpKkZs2aqbCwUGFhYfWwmQAAAADQ+LgtfG+99ZaWL1+uVq1aXfZKrVarBg4cqNzcXElSu3btlJycrD59+mjGjBnKzc1VeXm5LBaLJCkoKEh2u10ul6tiHReWXVz4Vq9erTVr1lx2DgAAAABozNwWvmuuuUZdu3aV1Wr9xU/St29fBQUFKSAgQAMGDNChQ4cq7SJqt9sVEhJSUQAl6dy5cwoJCam0noSEBCUkJFRaFh0d/YtzAQAAAIDJ3B6Y9/333ysmJkbx8fGKj4/Xb37zm5/9JIsXL9Ynn3wiSdq9e7c6d+6sqKgo5eTkyOFwKD8/X5GRkQoLC1NBQYGKiopUUlKi0NDQn79FAAAAAABJlzHDt2zZsjo/yZQpU5SSkqK1a9eqf//+6tmzp1q2bKmUlBTZ7XbZbDZZrVYlJSUpMTFRDodDiYmJdX5eAAAAAGjM3Ba+d955p9qyi8+2eSkX736ZlpZW6WcRERFKT0+vtKx79+7Kysq6rHUDAAAAAC7NbeFr3769JMnlcikvL0+FhYUNHgoAAAAAUHduC999991XcX3kyJF6+OGHGzQQAAAAAKB+uC18W7durbh+6tQpZvgAAAAAwE+4LXxHjx6tuG61WrVy5coGDQQAAAAAqB+1Fr7jx49LkkaPHu2xMAAAAACA+lNr4XvqqadksVjkcrkkSRaLRQcOHJDdbldubq6n8gEAAAAAfqFaC9/GjRsrrhcXF2vx4sX68ccftWDBAo8EAwAAAADUTYC7O3z00UcaO3asunbtqoyMDHXo0METuQAAAAAAdVTrDN+ZM2e0YMECnTlzRq+++qquvvpqT+YCAAAAANRRrYXvnnvukcvl0u23365Vq1ZV+tmiRYsaPBgAAAAAoG5qLXwrVqzwYAwAAAAAQH2rtfDddNNNnswBAAAAAKhnbk/aAgAAGo9Sh9PbEarxxUwA4C9qneEDAACNjzWwicbPyvB2jEoyl9i8HQEA/BYzfAAAAABgKAofAAAAABiKwgcAAAAAhqLwAQAAAIChKHwAAAAAYCgKHwAAAAAYisIHAAAAAIai8AEAAACAoSh8AAAAAGAoCh8AAAAAGIrCBwAAAACGovABAAAAgKEofAAAAABgKAofAAAAABiKwgcAAAAAhqLwAQAAAIChKHwAAAAAYCgKHwAAAAAYisIHAAAAAIai8AEAAACAoSh8AAAAAGAoCh8AAAAAGIrCBwAAAACGovABAAAAgKEofAAAAABgKAofAAAAABiKwgcAAAAAhqLwAQAAAIChKHwAAAAAYCgKHwAAAAAYisIHAAAAAIai8AEAAACAoSh8AAAAAGAoCh8AAAAAGIrCBwAAAACGatDCt2jRIv3tb39TcXGxJk2apHHjxmnjxo2SpIKCAtlsNsXFxendd9+VJOXl5Sk2NlZxcXH67LPPGjIaAAAAABivQQqf0+nUrFmztG3bNklSZmamRo4cqczMTGVnZ+vkyZNKTU1VcnKyNm/erIyMDJWWlmrFihVavny51q9fr1WrVjVENAAAAABoNBqs8I0YMUKjRo2SJO3du1f9+/eXxWJRv379lJubq7y8PN14442yWq2KiorSoUOHdPr0abVt21ahoaFq1qyZCgsLGyIeAAAAADQKDVL4rFarBg4cWHG7uLhYwcHBkqSgoCCVlJSovLxcFoulYpndbpfL5ap4zIVlF1u9erWio6MrXQAAAAAANfPISVuCg4MrypvdbldoaKgCAv711Ha7XSEhIRUFUJLOnTunkJCQSutJSEhQfn5+pQsAAAAAoGYeKXw9evTQjh07JEk7d+5Ujx49FBUVpZycHDkcDuXn5ysyMlJhYWEqKChQUVGRSkpKFBoa6ol4AAAAAGCkpp54EpvNpieeeEKbNm3SXXfdpfDwcE2dOlUpKSmy2+2y2WyyWq1KSkpSYmKiHA6HEhMTPRENAAAAAIzVoIUvISGh4vqGDRsq/SwiIkLp6emVlnXv3l1ZWVkNGQkAAAAAGg2+eB0AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAAADAUBQ+AAAAADAUhQ8AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAAADAUBQ+AAAAADAUhQ8AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFD/Wi1OH0doRqfDETAAAA4ElNvR0AZrAGNtH4WRnejlFJ5hKbtyMAAAAAXsUMHwAAAAAYisIHAAAAAIai8AEAAACAoSh8AAAAAGAoCh8AAAAAGIrCBwAAAACGovABAAAAgKEofAAAAABgKAofAAAAABiKwgcAAAAAhqLwAQAAAIChKHwAAAAAYCgKHwAAAAAYisIHAAAAAIZq6qknuuOOOxQRESFJSkhI0Nq1a2W32xUTE6OHH35YBQUFmjlzppxOpyZMmKDhw4d7KhoAAAAAGMkjM3zHjh3TzTffrLS0NKWlpSk3N1cjR45UZmamsrOzdfLkSaWmpio5OVmbN29WRkaGSktLPRENAAAAAIzlkcJ38OBB5efny2az6YUXXtDevXvVv39/WSwW9evXT7m5ucrLy9ONN94oq9WqqKgoHTp0yBPRAAAAAMBYHil8LVu21LRp05SRkSFJ+vDDDxUcHCxJCgoKUklJicrLy2WxWCqW2e32autZvXq1oqOjK10AAAAAADXzyDF80dHR6tatmyTp1ltv1TfffCO73a6QkBDZ7XZdc801Cgj4V/e88LOqEhISlJCQUG3dAAAAAIDqPDLDt2nTJr311luSpF27dqlnz57asWOHJGnnzp3q0aOHoqKilJOTI4fDofz8fEVGRnoiGgAAAAAYyyOFz2az6YMPPlB8fLwKCws1btw4bd26VQ888ID69u2r8PBwTZ06VS+++KJiY2MVGxsrq9XqiWgAAAAAYCyP7NIZGhqqDRs2VFpW9XZERITS09M9EQcAAAAAGgW+eB0AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAgN8rdTi9HaEaX8wEoPFp6u0AAAAAdWUNbKLxszK8HaOSzCU2b0cAAGb4AAAAAMBUFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAAADAUBQ+AAAAADAUhQ8AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAAADAUBQ+AAAAADAUhQ8AAAAADEXhAwAAAABDUfgAAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAENR+AAAAADAUBQ+AAAAADAUhQ8AAMCLSh1Ob0eoxhczAfhlmno7AAAAQGNmDWyi8bMyvB2jkswlNm9HAFBPmOEDAAAAAENR+AAAAADAUBQ+AAAA/Gy+eJyfL2YCvI1j+AAAAPCzcewh4B98qvCVlZVp5syZOnHihHr27KmUlBRvRwIAAAAAv+VTu3S+//77io6OVmZmps6ePat9+/Z5O5JH+eJuCL6YCQAAoC588fONL2aCGXxqhi83N1dDhw6VJA0YMEB79uxRz549vZzKc9g1AgAAoOHxmQuNiU/N8BUXFys4OFiSFBQUpJKSkl+0Hl/8HxJfzAQAAAD/4YufJy83k79m99fcF7O4XC5XA2X52V544QXdc8896t27t/7zP/9TP/zwg37zm99U/Hz16tVas2aNFxMCAAAAgO/Jz8+vcblPFb5///d/17fffqvJkyfrqaee0pgxY3TDDTd4LU90dHStL5yv89fs/ppb8t/s/ppb8t/s/ppb8t/s/ppb8t/s/ppb8t/s/ppb8t/s/ppb8t/s/ppb8l52n9qlc9iwYcrLy1NsbKyaNGni1bIHAAAAAP7Op07aYrVatWLFCm/HAAAAAAAj+NQMHwAAAACg/lD4LmH69OnejvCL+Wt2f80t+W92f80t+W92f80t+W92f80t+W92f80t+W92f80t+W92f80t+W92f80teS+7T520BQAAAABQf5jhAwAAAABD+dRJW7ytrKxMM2fO1IkTJ9SzZ0+lpKTI5XJpxowZSkhIUOfOnb0dsUZVczscDh08eFCS9M9//lPr1q1T3759vZyyZlWzP/roo3r88cdVWlqqIUOG6JFHHvF2xBpVzT1x4kQ98cQTKisr0913362HHnrI2xHdWrRokW6++Wb169dPjz/+uOx2u2JiYvTwww97O5pbF7Lfcccd+uCDD7Rr1y7Nnj3b27HcupA7OjpaKSkpKisrU+fOnTV//nxvR3PrQvauXbvqySef1Pnz52Wz2XT//fd7O9olXfxekaQ//vGPOnz4sF+9X3r37q3hw4erQ4cOkqRly5YpPDzcy+lqdyH3gAEDNHfuXBUUFKhly5Z66aWXZLVavR3vki5k/+STT/xmHJX+lbtXr15+MYZe7EL27t27+8U4WlxcrKSkJJ0/f14tWrTQCy+8oMTERJ8fQ6vmfvHFF9W0aVOf/4wrVc8+e/ZszZkzx+fH0Kq558yZo1mzZnll/GSG7yLvv/++oqOjlZmZqbNnz2rXrl2aPHmy9u3b5+1ol1Q198iRI5WWlqaUlBTdeuutPj1IVc3+9ttva9iwYdqyZYvef/99lZSUeDtijarmfvrppzV+/Hi98cYb2r9/v44dO+btiLVyOp2aNWuWtm3bJknKzMzUyJEjlZmZqezsbJ08edLLCWtXNXt6erqWLFni5VTuVc29fv16TZs2TZmZmbLb7T79N6Zq9tdff11TpkxRVlaWMjMz5atHBVTNLUklJSV69dVXvZjq8lTNfvDgQcXFxSktLU1paWk+W/aq5n7zzTfVu3dvZWZmKiYmRidOnPBywtpVzf7MM8/4xThaNfd//Md/+MUYKlXPvm7dOr8YR7ds2aKhQ4cqLS1NHTt21BtvvOEXY2jV3H/+85/94jOuVD37o48+6hdjaNXc8fHxXhs/meG7SG5uroYOHSpJGjBggPbs2aPp06crMzPTy8kurabcPXv21OrVqzV37lwvp7u0qtmPHDkii8WisrIySVJgYKA349Wqau65c+dq8eLFkqRu3brpn//8p6655hpvRqyV0+nUiBEj1K5dO0nS3r17NXLkSFksFvXr10+5ubkaMmSIl1PWrGr2du3aaf78+fr73//u5WSXVjX3jBkz1Lx584qf+fKsR9XsTz75pCwWi4qKiuR0OmWxWLycsGZVc0s/faAcNWqUCgsLvZjMvarZDx48qOzsbG3fvl2DBg3S5MmTvZywZlVz79y5Ux07dtSDDz6om266Sffdd5+XE9aupveLJJ8fR6vm7tatm/bv3+/zY6hUPfuRI0c0bdo0Sb49jsbFxVX8zXY6nVq/fr3effddnx9Dq+Z2uVx+8RlXqp79kUceUb9+/Spu++oYWjV3SkqKBgwY4JXxkxm+ixQXFys4OFiSFBQUJIfDoZ49e3o5lXtVc5eUlOi7777TFVdcofbt23s53aVVzS5JGRkZuueee9SjRw+f/Udc03tl+/btKi8v16effqrz5897OWHtrFarBg4cWHG7pvePr6qafdCgQQoI8P0/Y1Vzt2jRQk2aNNFf//pX2e12denSxYvpLq1q9oCAAH3xxRe677771KtXLy8mu7SquY8fP66CggL17t3bi6kuT9Xs7dq1U3JystLT07V//37l5uZ6L9wlVM1dWFio4OBgvf766/r888+1d+9eL6a7tKrZJfnFOFo197/927/5xRgqVc8eFRXlF+NoSEiIrFar9u7dqx07dqhbt25+MYZWzT1ixAi/+Iwr1ZzdH8bQqrlvv/12r42fvv9JyYOCg4Nlt9slSXa7XaGhoV5OdHlqyv2Xv/xF9957r5eTuVc1++bNm7VgwQJt27ZNDodDn3zyiZcT1qxq7scee0z//d//ralTp6pdu3YKCwvzcsLL56/ve3/3/vvva9OmTVq6dKm3o/xsnTp10t/+9jfZ7XZt377d23Euy+rVq/32VN59+/ZVnz59FBAQoAEDBujQoUPejnRZmjdvrptvvlmS1L9//4pj4vyFv4yjF0tNTfWLMbQmjz76qN+Mo7t379Zzzz2nlStX+tUYenHupk39aye/qtn9ZQytmttb4yeF7yI9evTQjh07JEmffvqp3/zPR025P/30U91www3eDXYZqma//vrrFRISIklq2bKlzp496814taqa22q16vHHH1dqaqq+//57v3nvSJW3ZefOnerRo4eXE5lv165dSktL09q1ayve7/7ihRdeUH5+viwWi5o1a+btOJctJydHTz31lBYuXKj33ntPH330kbcjXbbFixdXfHDfvXu3T59c4WIXxiJJ2r9/v6677jrvBvqZ/GUcvVhwcLBfjKE12b17t1+Mo4cPH9bChQuVmpqq8PBwvxlDq+b2J1Wz+8sYWjW3N8dPCt9Fhg0bpry8PMXGxqpJkyZ+84e+ptzffvutWrdu7e1oblXNPn/+fC1dulQ2m03Hjh1TTEyMtyPWqGruQYMGafbs2YqLi9PAgQPVokULb0e8bDabTVu3btUDDzygvn37+t1A4I9WrlypM2fOaMqUKYqPj1dOTo63I122sWPHav78+bLZbGratKkGDBjg7UiX5b/+67+UlpamuXPn6p577tHtt9/u7UiXbcqUKVq/fr1sNpuuvfZan/0gXFVcXJx2796tsWPHymq1Vhxz4y/8ZRy92PTp0/1iDK1Ju3bt/GIcXbdunYqKipScnKz4+HhFRUX5xRhaNffFJ7TydVWz22w2vxhDq+Zu2bKl18ZPvngdAAAAAAzFDB8AAAAAGIrCBwAAAACGovABAAAAgKEofAAAAABgKAofAAAAABiKwgcAwEU+++wzpaSkVFoWHx+vo0ePeikRAAC/HIUPAAAAAAzV1NsBAADwB4WFhXruuedkt9sVGBio559/XpI0Z84cpaWlSZKGDBmibdu2VXzJriTde++92rBhgywWi371q19pxowZXtsGAEDjQ+EDAKCKf/zjH4qPj6+4nZeXp9TUVMXExOiBBx7Qp59+qt///veaPXt2resYPXq0Bg0apBkzZuixxx7Tbbfdpi1btsjlcslisXhiMwAAYJdOAACqGjhwoNLS0iouXbt21fnz59W7d29JUp8+fXTo0KFqj3O5XBXXIyMjJUmzZ8/WX//6V02YMEHffvutysvLPbMRAACIwgcAwGWxWq3KycmRJO3atUvt27fXFVdcoVOnTkmSDhw4UKnMXZjFe+uttzRjxgxlZGRoz549+vLLLz0fHgDQaLFLJwAAl2Hy5Mlas2aN3nnnHblcLr3wwgtq3bq1evXqpTFjxqhr16668sorqz2uW7dumjhxoq688kpFRESoY8eOng8PAGi0LK6L9z8BAAAAABiDXToBAAAAwFAUPgAAAAAwFIUPAAAAAAxF4QMAAAAAQ1H4AAAAAMBQFD4AAAAAMBSFDwAAAAAMReEDAAAAAEP9PxUztF6k9AVYAAAAAElFTkSuQmCC\n", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "import matplotlib.pyplot as plt\n", "\n", "f, ax = plt.subplots(figsize=(15, 7))\n", "sns.set(style='ticks')\n", "sns.barplot(\n", " x='Hours',\n", " y=\"Number of sales\",\n", " data=sales_list,\n", " label=\"Sales Frequency based upon Hours\",\n", " color='b',\n", ")\n", "sns.set_context('paper')\n", "ax.legend(ncol=2, loc=\"upper right\", frameon=True)" ] }, { "cell_type": "code", "execution_count": null, "id": "dcbf6bc7", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "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.8.8" } }, "nbformat": 4, "nbformat_minor": 5 }