stk_variation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "2b8bb7f3",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import mysql.connector\n",
    "from mysql.connector import Error\n",
    "\n",
    "import mysql.connector\n",
    "\n",
    "mydb = mysql.connector.connect(\n",
    "  host=\"localhost\",\n",
    "  user=\"root\",\n",
    "  password=\"waleedahmed\",\n",
    "  database=\"us_boxing\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "ce2953af",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sku</th>\n",
       "      <th>stock</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ADHBG100-B/G12</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-10-24 05:18:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ADHBG100-B/R12</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-10-24 05:18:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ADHTG300-R/B12</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-10-24 05:18:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ADIH200PL-BLUE/R14</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-10-24 05:18:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ADIACC052K-BG</td>\n",
       "      <td>3</td>\n",
       "      <td>2019-10-24 05:18:21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  sku  stock                date\n",
       "0      ADHBG100-B/G12      1 2019-10-24 05:18:21\n",
       "1      ADHBG100-B/R12      1 2019-10-24 05:18:21\n",
       "2      ADHTG300-R/B12      5 2019-10-24 05:18:21\n",
       "3  ADIH200PL-BLUE/R14      1 2019-10-24 05:18:21\n",
       "4       ADIACC052K-BG      3 2019-10-24 05:18:21"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "cur = mydb.cursor()\n",
    "warehouse = \"SELECT sku,stock,date_archive FROM warehouse_stock_archive\"\n",
    "cur.execute(warehouse)\n",
    "warehouse= pd.DataFrame(data=cur.fetchall(),columns=['sku','stock','date'])\n",
    "warehouse.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "99673438",
   "metadata": {},
   "outputs": [],
   "source": [
    "conditions = [\n",
    "    (warehouse['stock']==0),\n",
    "    (warehouse['stock']!=0)]\n",
    "values = ['out_of_stock', 'in_stock']\n",
    "import numpy as np\n",
    "warehouse['stock_status'] = np.select(conditions, values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "0830963e",
   "metadata": {},
   "outputs": [],
   "source": [
    "warehouse['date']=pd.to_datetime(warehouse['date']).dt.floor('d')\n",
    "#df['Date'] = pd.to_datetime(df['Date']).dt.floor('d')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "8e2b8fef",
   "metadata": {},
   "outputs": [],
   "source": [
    "grouped=warehouse.groupby(['sku','date','stock_status'])['stock'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "4699c66a",
   "metadata": {},
   "outputs": [],
   "source": [
    "grouped=pd.DataFrame(grouped)\n",
    "grouped.reset_index(inplace=True)\n",
    "grouped.columns=['sku','date','status','stocks']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "210c415d",
   "metadata": {},
   "outputs": [],
   "source": [
    "grouped['date_diff']=grouped.date.diff().dt.days"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "83d285cb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sku</th>\n",
       "      <th>date</th>\n",
       "      <th>status</th>\n",
       "      <th>stocks</th>\n",
       "      <th>date_diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0333-70STEAMIBOARDV2</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>033370STEAMIRBOARDV2</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0333BHS675/03</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0333BT5200/15</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0333FC6167/01</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0333GC1440/26</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0333GC350/46</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0333GC3929/66</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0333HD3119/60</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0333HD4825/91</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0333HR1603/00</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0333HR1608/00</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0333HR1833/00</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0333HR1889/71</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0333HR2059/90</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0333S777/12</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0333SCF180/26</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0333SCF798/00G</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0333SCF813/37</td>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-15</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>5</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-16</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-17</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-18</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-19</td>\n",
       "      <td>out_of_stock</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-20</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-21</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-22</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-23</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-24</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-25</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-26</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-27</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-28</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-29</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-11-30</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-02</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-03</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-04</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-05</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-06</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-07</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-08</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-09</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-10</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-11</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-12</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-13</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-14</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>0U-014X-8XHX</td>\n",
       "      <td>2019-12-15</td>\n",
       "      <td>in_stock</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     sku       date        status  stocks  date_diff\n",
       "0   0333-70STEAMIBOARDV2 2019-10-24      in_stock       9        NaN\n",
       "1   033370STEAMIRBOARDV2 2019-10-24  out_of_stock       0        0.0\n",
       "2          0333BHS675/03 2019-10-24  out_of_stock       0        0.0\n",
       "3          0333BT5200/15 2019-10-24  out_of_stock       0        0.0\n",
       "4          0333FC6167/01 2019-10-24  out_of_stock       0        0.0\n",
       "5          0333GC1440/26 2019-10-24  out_of_stock       0        0.0\n",
       "6           0333GC350/46 2019-10-24  out_of_stock       0        0.0\n",
       "7          0333GC3929/66 2019-10-24  out_of_stock       0        0.0\n",
       "8          0333HD3119/60 2019-10-24  out_of_stock       0        0.0\n",
       "9          0333HD4825/91 2019-10-24  out_of_stock       0        0.0\n",
       "10         0333HR1603/00 2019-10-24  out_of_stock       0        0.0\n",
       "11         0333HR1608/00 2019-10-24  out_of_stock       0        0.0\n",
       "12         0333HR1833/00 2019-10-24  out_of_stock       0        0.0\n",
       "13         0333HR1889/71 2019-10-24  out_of_stock       0        0.0\n",
       "14         0333HR2059/90 2019-10-24  out_of_stock       0        0.0\n",
       "15           0333S777/12 2019-10-24  out_of_stock       0        0.0\n",
       "16         0333SCF180/26 2019-10-24  out_of_stock       0        0.0\n",
       "17        0333SCF798/00G 2019-10-24  out_of_stock       0        0.0\n",
       "18         0333SCF813/37 2019-10-24  out_of_stock       0        0.0\n",
       "19          0U-014X-8XHX 2019-11-15      in_stock       5       22.0\n",
       "20          0U-014X-8XHX 2019-11-16      in_stock       5        1.0\n",
       "21          0U-014X-8XHX 2019-11-17      in_stock       5        1.0\n",
       "22          0U-014X-8XHX 2019-11-18      in_stock       4        1.0\n",
       "23          0U-014X-8XHX 2019-11-19  out_of_stock       0        1.0\n",
       "24          0U-014X-8XHX 2019-11-20      in_stock       5        1.0\n",
       "25          0U-014X-8XHX 2019-11-21      in_stock       5        1.0\n",
       "26          0U-014X-8XHX 2019-11-22      in_stock       5        1.0\n",
       "27          0U-014X-8XHX 2019-11-23      in_stock       5        1.0\n",
       "28          0U-014X-8XHX 2019-11-24      in_stock       5        1.0\n",
       "29          0U-014X-8XHX 2019-11-25      in_stock       4        1.0\n",
       "30          0U-014X-8XHX 2019-11-26      in_stock       4        1.0\n",
       "31          0U-014X-8XHX 2019-11-27      in_stock       4        1.0\n",
       "32          0U-014X-8XHX 2019-11-28      in_stock       4        1.0\n",
       "33          0U-014X-8XHX 2019-11-29      in_stock       4        1.0\n",
       "34          0U-014X-8XHX 2019-11-30      in_stock       4        1.0\n",
       "35          0U-014X-8XHX 2019-12-01      in_stock       4        1.0\n",
       "36          0U-014X-8XHX 2019-12-02      in_stock       4        1.0\n",
       "37          0U-014X-8XHX 2019-12-03      in_stock       4        1.0\n",
       "38          0U-014X-8XHX 2019-12-04      in_stock       4        1.0\n",
       "39          0U-014X-8XHX 2019-12-05      in_stock       4        1.0\n",
       "40          0U-014X-8XHX 2019-12-06      in_stock       4        1.0\n",
       "41          0U-014X-8XHX 2019-12-07      in_stock       4        1.0\n",
       "42          0U-014X-8XHX 2019-12-08      in_stock       4        1.0\n",
       "43          0U-014X-8XHX 2019-12-09      in_stock       4        1.0\n",
       "44          0U-014X-8XHX 2019-12-10      in_stock       4        1.0\n",
       "45          0U-014X-8XHX 2019-12-11      in_stock       4        1.0\n",
       "46          0U-014X-8XHX 2019-12-12      in_stock       4        1.0\n",
       "47          0U-014X-8XHX 2019-12-13      in_stock       4        1.0\n",
       "48          0U-014X-8XHX 2019-12-14      in_stock       4        1.0\n",
       "49          0U-014X-8XHX 2019-12-15      in_stock       4        1.0"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grouped.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "de70a54e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "94c4cde6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=grouped[grouped['sku'].isin(['0U-014X-8XHX'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "2daa5797",
   "metadata": {},
   "outputs": [],
   "source": [
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "5724b56e",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-61-5e484a0db830>:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['year']=df['date'].dt.year\n"
     ]
    }
   ],
   "source": [
    "df.head(50)\n",
    "df['year']=df['date'].dt.year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "8e625e6d",
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "33617208",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAlcAAAGFCAYAAADQJdY9AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8rg+JYAAAACXBIWXMAAAsTAAALEwEAmpwYAAAxGElEQVR4nO3dfZxdZX3v/c9vz4QEJJEEkjASQqIEDQGNNMiDiGLuiHBasKQ+0jZqPKlH+zp6c2yN9fYc9a6enB7tHVq5jyJRU8pBqVJoKWARgQoWEIo8BREqCIkhQAAh8hSS6/yx9p7s2ZmZzOyntdesz/v1Gvbstdde67pmhplvfte1rhUpJSRJktQelbwbIEmSNJEYriRJktrIcCVJktRGhitJkqQ2MlxJkiS1keFKkiSpjQxXksYkIlZFxDs6dOz3R0SKiH07cfxmRcRnI+Lxcb5nr+r7Fjdsn1ft42+3tZGSeo7hStJYrQLekXcjuuw84ORxvmcv4L8Bixu2bwaOA65vvVmSell/3g2QpF4TEZOAnSmljcDGdhwzpfQCcGM7jiWpt1m5kgRARCyKiCsj4omI+E1E3BMRH62+di3wW8CK6tBWioj3V1/rqw6DPRQRL0TE3RHxvmGOf2JEXBMR2yLi1xFxbUS8fpT2/ElEPB8Rp43w+rci4ifDbP9oRDwbEVOrz/9LRPykes4tEfGPEXFow3uujYjvVoc+/x14HnhF47BgRLwsIr4SEfdWz/FARJwTEdPqDvdM9fGbdV+recMNC47la1ft5y0RsSwi7qh+b66PiEUjfe0k5cvKlaSafwTuAX4feAF4NVALDR8Bvgf8Avh/q9v+vfr4eeBPgc8BPwGWAxdEREopXQgQEW8BrgKuAVYAvwHeCBwE3NbYkIj4r8Bq4LSU0j+P0N7vAJdHxPyU0gN1298NXJ5SqoWcOcBXgF9W+/Nh4McRsSCl9Ou6970ReBXwSeBZoP61mn2APuDTwGPAwdXP/45dw4dvBX4I/DnwT9Vtm4GBYY63x69d1VzgfwJfAJ4DvgR8JyKOTN7DTOo9KSU//PCj5B/AAUACjhxln1uAbzVsm0EWlP5bw/bLgXvrnv9r9f0xwrHfXz3/vsAXyao/b95Dm/uBx4HVddsOAnYCvzfCe/qAvavH/8O67deShZbZDft/Fnh8D214Y7Xtc6vb9q0+f3/DvvOq2397nF+7bwEvAQvqtr2jeqzX5P2z44cffuz+4bCgJIAngIeBr0bEuyNi1hjfdwRZNefvGrZ/BzgsImZGxMuAY4D1KaU9VVn+kqxK9raU0nWj7ZhSegm4mKxSVfNOssBSqxgREcdGxFURsZUspDxLFoAOazjkrSmlLXtoHxHxBxFxW0RsA7aza4J64/H2ZI9fu7ptD6aU7qt7vqH6OGec55TUBYYrSaSUdgJvAx4BvgE8EhE/Gm1OVFVtqKsxlNSezwCmA0E2NLYny4FbyYbIxuLbwOKIqAWbdwP/kFJ6DiAi5gL/XD3/H5FVmY4GHgWmjNDmEUXE7wJ/Q1aJeydwLPC71Zcbj7cnY/na1TzVsM+LTZ5TUhcYriQBkFL6WUppObAf8H+R/eH+p4gY7fdELTA1VrpmVx+fAJ4kG6obbs5Ro98mW8Lgb/Zw3prryMLIuyPiELKw8526199OVh06PaX03ZTSj4GfMjS41Ixl7tI7gZtSSh9JKV2RUrqJrH/NGMvXTlIBGa4kDZFS2p5S+iHZEN0AWdiCrFrSWCm5i2yY7Z0N298F/Dyl9FhK6TfATcAfRkTs4fR3AqeQhayvjqGtO8iG1d5dPedTwJV1u+xNFuxeamhbsxfz7E022b/emQ3Px1pV2uPXrqkWSsqdVwtKIiJeS/UKNLIrAqeTXTV3e0qpVkH5GXByRJwMbAUeSCltjYi1wP8TES+RTVo/AzgVeG/dKVYDPwCuiIhzyeZFHQfcklK6rL4tKaWbI+J3qvs+nVL6xB6a/x3gj4H/G7gkpfRi3Ws/JJvE/s2IWAcsAj7B7sNsY3UVcE5EfJosMJ4KLG1o/4sR8QDwroi4i2xZhzsaD5RSemKMXztJBWO4kgTZXKstZMsKvIIsfFxDFrBq/pxsSYCLyJY0+ADZlWz/lawy9J/IhrTuB34/pfTt2htTSv8SEcvIlnH4W7Lqzm3AJcM1JqV0XUScAVwaEc+klD43SttvIJuMfzDZHKz649xZXY/rs2Rzo24nqxR9h+Z8DXgl8DGyytRVwPvYfXHQD5OF1R8Ak4H5Ixxvj187ScUTe754R5IkSWPlnCtJkqQ2MlxJkiS1keFKkiSpjQxXkiRJbWS4kiRJaqOeWorhgAMOSPPmzcu7GZIkSXt06623Pp5Smtm4vafC1bx587jlllvyboYkSdIeRcQvh9vusKAkSVIbGa4kSZLayHAlSZLURj0150qSJPW27du3s3HjRp5//vm8m9I1U6ZMYc6cOUyaNGlM+xuuJEnSmG3cuJGpU6cyb948IiLv5nRcSomtW7eyceNG5s8f6R7sQzksKEmSxuz5559n//33L0WwAogI9t9//3FV6gxXkiRpXMoSrGrG21/DlSRJKpSHH36Yk046icMPP5xFixZx9tlnA/DEE0+wbNkyFixYwLJly3jyyScB+NnPfsZxxx3H5MmT+dKXvjTkWGeffTZHHHEEixYtYu3atW1pn+FKkiQVSn9/P1/+8pfZsGEDN954I+eccw4bNmxgzZo1LF26lPvuu4+lS5eyZs0aAGbMmMFf/dVf8YlPfGLIce666y6+/vWvc/PNN3P77bdz2WWXcf/997fcvo6Gq4h4MCLujIifRoRLr0uSpJYNDAxw1FFHATB16lQWLlzIpk2buPTSS1mxYgUAK1as4JJLLgFg1qxZHH300btd7XfPPfdwzDHHsM8++9Df38+b3/xmLr744pbb142rBU9KKT3ehfNIkqQu+skvX+CJZ3e29Zgz9qlw9CGTx7z/gw8+yG233cYxxxzDli1bGBgYAODAAw9ky5Yto773iCOO4NOf/jRbt25l77335vLLL2fJkiUttR9KthTDlmd28NKORCWCWVMr7Ezw6DM7Bl+vRDB7aoVKpfsT9Z55fifPbn2Emf2/oVKbONfXDzPmQjh6K0lSo23btrF8+XLWrl3LtGnThrwWEXuciL5w4UI++clP8ra3vY2XvexlLF68mL6+vpbb1elwlYB/jogEfC2ldG7jDhGxClgFMHfu3I425uZfvsiT1YR9wisn88wLO7l90/Yh+7zpVZOZv3/3M+cvn3iJyT+7idnP3zX0hTe8D2a+quvtkSRpT8ZTYWq37du3s3z5cs4880zOOOMMAGbPns3mzZsZGBhg8+bNzJo1a4/HWblyJStXrgTgz/7sz5gzZ07Lbet0SeSElNJRwCnARyPixMYdUkrnppSWpJSWzJw5s7ONeeVkTlqQ/SC8uCOxvVq0OuXwKbzl0Gz79h2po20YSQLu3OcN7DjuA3D8B2Hx72YvvPRCLu2RJKlXpZRYuXIlCxcu5Kyzzhrcftppp7F+/XoA1q9fz+mnn77HYz366KMAPPTQQ1x88cW8733va7l9HS3RpJQ2VR8fjYi/B94A/Esnzzma6ftU2HtSVNuWbeuvwMx9+3hue7ZhZz7Zip0JtvXtR2X6PhABk6r/GkjtHcuWJKnobrjhBs4//3yOPPJIFi9eDMAXv/hFVq9ezbve9S7WrVvHIYccwkUXXQTAI488wpIlS3j66aepVCqsXbuWDRs2MG3aNJYvX87WrVuZNGkS55xzDvvtt1/L7etYuIqIlwGVlNIz1c/fBny+U+cbq9p0qlT33yHbcwpXtfMOjg/X5lntNFxJklTvhBNOII3wB/vqq6/ebduBBx7Ixo0bh93/Rz/6UVvbBp2tXM0G/r4aFvqB/51SurKD5xuTWnbZ2fBNqU15yzNcDZl3FzmnPUmS1JSOhauU0i+A13Xq+M2qr1DV55bB0EU+YWYnDRPgapUrhwUlSSqU0l3j31gQqhWL8h8WTA2VK8OVJElFVL5wVX1snLie9yjc7sOChitJkoqofOEqgqBuKnsMecj1asHKsOHKOVeSJBVJ6cIVZBWixsyyW+jqspR2BbysQVauJEkqotKGq50pC1KNF+jlVrmCocv0VwxXkiQN5+GHH+akk07i8MMPZ9GiRZx99tkAPPHEEyxbtowFCxawbNkynnzySQAuuOACXvva13LkkUdy/PHHc/vttw8e68orr+TVr341hx56KGvWrGlL+0oZriow7PoYlWEqWt2SGocFa7HPcCVJ0hD9/f18+ctfZsOGDdx4442cc845bNiwgTVr1rB06VLuu+8+li5dOhiW5s+fz3XXXcedd97JZz7zGVatWgXAjh07+OhHP8oVV1zBhg0buPDCC9mwYUPL7StluIrIqla7Dw0OH7q6YberBa1cSZI0rIGBAY466igApk6dysKFC9m0aROXXnopK1asAGDFihVccsklABx//PFMnz4dgGOPPXZwQdGbb76ZQw89lFe+8pXstddevOc97+HSSy9tuX3dv0NxD6gN/zXeKzvId0L70PZYuZIk9bi7vw9Pb2nvMafNhkUnj3n3Bx98kNtuu41jjjmGLVu2MDAwAGSrsm/Zsnvb1q1bxymnnALApk2bOPjggwdfmzNnDjfddFOLHShpuKpE7L70AdVhwXyaRKLxasEYfua9JEkCYNu2bSxfvpy1a9cybdq0Ia9FxNC5zMA111zDunXruP766zvarlKGq8HMEkMDVlRDVx6GC3tExcqVJKl3jaPC1G7bt29n+fLlnHnmmZxxxhkAzJ49m82bNzMwMMDmzZuZNWvW4P533HEHH/rQh7jiiivYf//9ATjooIN4+OGHB/fZuHEjBx10UMttK+Wcqwq7rhasl+vVgondEjZR8cbNkiQ1SCmxcuVKFi5cyFlnnTW4/bTTTmP9+vUArF+/ntNPPx2Ahx56iDPOOIPzzz+fww47bHD/o48+mvvuu48HHniAF198kW9/+9ucdtppLbevvJWr6kIMQ+aQ00tXC2LlSpKkYdxwww2cf/75HHnkkSxevBiAL37xi6xevZp3vetdrFu3jkMOOYSLLroIgM9//vNs3bqVj3zkI0B2teEtt9xCf38/X/nKVzj55JPZsWMHH/zgB1m0aFHL7StvuBomRO0KXd033AT7LFw550qSpHonnHDCiFf3X3311bttO++88zjvvPOG3f/UU0/l1FNPbWv7yjksWBv+SyNsz0EiOedKkqQJoJThKsgmricYMos8z4vzhh8WDMOVJEkFU85wVbfkwtDVD/K7WnCnVwtKkjQhlDJcjTT8V7uKMA9Z5WqYqwUNV5IkFUopw1XtNjfDLcWQ2yKiw01orxiuJEkqmhKHq5G253S1IMMMC+IK7ZIkFU0pw1WFLMzA0GpRrlcLprT7hHYrV5Ik7ebhhx/mpJNO4vDDD2fRokWcffbZADzxxBMsW7aMBQsWsGzZMp588kkALrjgAl772tdy5JFHcvzxx3P77bcPHuuDH/wgs2bN4ogjjmhb+0oZrgYrVw1BKsj3akEntEuStGf9/f18+ctfZsOGDdx4442cc845bNiwgTVr1rB06VLuu+8+li5dypo1awCYP38+1113HXfeeSef+cxnWLVq1eCx3v/+93PllVe2tX0lDVex6/Y3Q+4tmPPtbxo3uoioJEm7GRgY4KijjgJg6tSpLFy4kE2bNnHppZeyYsUKAFasWMEll1wCwPHHH8/06dMBOPbYY9m4cePgsU488URmzJjR1vaVcoX2yghTmSoRua3QnvBqQUlSsVzz65/w2PYn2nrMmZNmcNLLjx7z/g8++CC33XYbxxxzDFu2bGFgYACAAw88kC1btuy2/7p16zjllFPa1t7hlDJc1U9ojxG2d9uI61x542ZJkoa1bds2li9fztq1a5k2bdqQ1yKCaPjDes0117Bu3Tquv/76jrarnOEK2DlMhSobFsypcjVsuHKFdklS7xpPhandtm/fzvLlyznzzDM544wzAJg9ezabN29mYGCAzZs3M2vWrMH977jjDj70oQ9xxRVXsP/++3e0baWcc1UbFmzMURXyXOdqmKsFHRaUJGk3KSVWrlzJwoULOeusswa3n3baaaxfvx6A9evXc/rppwPw0EMPccYZZ3D++edz2GGHdbx9pQxXPTss2LjRcCVJ0m5uuOEGzj//fH74wx+yePFiFi9ezOWXX87q1au56qqrWLBgAT/4wQ9YvXo1AJ///OfZunUrH/nIR1i8eDFLliwZPNZ73/tejjvuOO69917mzJnDunXrWm5fSYcFY9dVgT1ytWA2ob1ho+FKkqTdnHDCCSMu+n311Vfvtu28887jvPPOG3b/Cy+8sK1tg5JWriqDt7lJDdvzu3HzyHOuXIpBkqQiKWW4qmWWYe8tmOvVgi7FIElS0ZU2XNWuChwy54pdt8XptpSG+WYYriRJKpxShquRFxHN58bNKWVLl+42LOi9BSVJPSiPv5V5Gm9/SxmuavcQbPxa5TUsWDvl8BPay/UDLEnqbVOmTGHr1q2lCVgpJbZu3cqUKVPG/J5yXi0YMezwX5DP1YKDy0J4taAkqcfNmTOHjRs38thjj+XdlK6ZMmUKc+bMGfP+pQxX9cOC9YEmr6sFRw5XrtAuSeotkyZNYv78+Xk3o6eVc1hwhOG/iN2vIOyGWnyqNC4jauVKkqTCKWW4qq1z1RikKjktIjrqsKA3bpYkqVBKGa5qGSY13HKmFm66PUlv56hzrsoxYVCSpIminOGqGmIaq1S7wlV321MLc97+RpKk4itluKpUU1RjuKp9MbodZ5zQLknSxFHKcDVk+G/IjZujur277anFp8ZsZeVKkqTiKWe4qj7uHHHOVXfbUztfxXsLSpJUeKUMV5UR5lyNtL3TRhwWrFSG7iBJknpeKcPVSBWqXVcR9sjVgrUWWb2SJKkwSh2uRrxasLvNIVXPuNs3Y7ByZbiSJKkoShmuKnWVq6ibddVzw4JhuJIkqWhKGa5qgWrnblcLZo9dv1rQcCVJ0oRRznA10rAgw69/1Wm7rhZseCGc0C5JUtGUMlxVRqhQVfKaczVYuRpmKQbw/oKSJBVIKcPVYOWK3ljnqhaddvtmOCwoSVLhdDxcRURfRNwWEZd1+lxjVev0bksxDA4Xdjdd1ZZ+GPb2N2C4kiSpQLpRufoYcE8XzjNmI4WokYYLO82rBSVJmjg6Gq4iYg7wH4DzOnme8Yq6GzcPGRasPuZ1teDIE9oNV5IkFUV/h4+/FvhTYGqHzzMuQypUdYGmr/rCFfc8v/tNlDuoluV2u7dgpS97vO6rw9zVuUOiD45+Dxwwv0snlCRpYulYuIqI3wYeTSndGhFvGWW/VcAqgLlz53aqOcNqrFDN3LfC6+dM4qUcCkV79QUv37shQR3wSjjsLbDzpe40Ysd2eOAm+M1Ww5UkSU3qZOXqjcBpEXEqMAWYFhF/m1L6/fqdUkrnAucCLFmypCsDcoPDfw3b+yrBka/YqxtNGJtJk2HBm7p3vhefzcKVSz9IktS0js25Sil9KqU0J6U0D3gP8MPGYJWbuvWsujn81/Oc4yVJUstKuc7VIBc+Hyqvhb4kSZpAOj2hHYCU0rXAtd0413gYIRpYuZIkqWWlrFw5FDgCw5UkSS0rZbiqt9vCnWVmuJIkqWWlDFfmqRF4ux1JklpWynBluhpFVAxXkiS1oJzhSiOLilcLSpLUglKGq+HuJ6gqK1eSJLWklOFqCNPVUIYrSZJaYrjSUJWKt7+RJKkFpQxX9csvWLhqEIHLq0qS1LxShiuNIqxcSZLUCsOVhnLOlSRJLTFcaSjDlSRJLSlluHIphlFEGK4kSWpBKcOV6WoUVq4kSWpJKcNVmKhG5grtkiS1pJThSqOwciVJUktKH66sYTUwXEmS1JJShisD1SgMV5IktaSU4cp0NYqKc64kSWpFOcPVECatoVyKQZKkVpQyXA1ZicFsNZQ3bpYkqSWlDFcaRVQAw5UkSc0qZbiyWDUKb9wsSVJLShmu6tOVQauBt7+RJKkl5QxXGpkrtEuS1BLDlYZynStJklpSynDlUOAoDFeSJLWklOGqnksxNHBYUJKklpQzXBmoRmblSpKklpQyXJmtRuHVgpIktaSU4UqjsHIlSVJLSh+urGI1qBiuJElqRSnDVYz4RFauJElqTSnDlSu0j8Lb30iS1JJShisD1SgiAJdikCSpWaUMVxqFlStJklpiuNJQUQGSC4lKktQkw5WGiuqPhOFKkqSmlDJcxQifi7pw5dCgJEnNKGW4GnJDQdPVULWvjeFKkqSmlDNcaWRWriRJakkpw5XFqlEYriRJakkpw1U9g1YDw5UkSS0pfbhSg4pXC0qS1IpShquwXDUyK1eSJLWklOFKo/BqQUmSWlLKcDVknSurWEPVKlfeAkeSpKaUMlxpFA4LSpLUknKGK9cQHZnhSpKklpQyXBmoRuGcK0mSWlLKcDWUUWsIb9wsSVJLOhauImJKRNwcEbdHxN0R8blOnUtt5LCgJEkt6e/gsV8A3ppS2hYRk4DrI+KKlNKNHTznuHm1YIOK4UqSpFZ0LFyllBKwrfp0UvWjJ8aazFOjqYare6+BSXuPvNusBTD39d1pkiRJBdLJyhUR0QfcChwKnJNSummYfVYBqwDmzp3byebUnbQ7pymkqQfA9Dmw/fnsYzjPPQXPPpXtu+OlzrcpAqbNHj3sSZLUIzoarlJKO4DFEbEf8PcRcURK6a6Gfc4FzgVYsmRJVypbZqtRTN4Xjv/A6PvcchE8+yRsfwH26kLgeeE52Lmj8+eRJKkNOhqualJKT0XENcDbgbv2tH83GbSaELFrTlZ04YLToEcGlCVJ2rNOXi04s1qxIiL2BpYBP+vU+dRFUXGpBkmSRtDJytUAsL4676oCXJRSuqyD5xuzGPGJxiQih3BlmJMkFUMnrxa8A+jNy8kMVC3q8jid62VIkgrEFdo1fvVzrrrFdbckSQVRynAVI3yuMXLOlSRJIypluFKrcphzZZaTJBVE6cOVlasmRB5rI5iuJEnFUMpwFU6Qbk3XrxYMs5UkqTBKGa6GMGeNX7fnXAWAE9olScVguFITuj0saAKWJBVHacNVNDxqHHJZisFxQUlSMZQ2XKkFeazQbriSJBVEecOVJasWeCdlSZJGUtpwZbZqQbcrV7ks/SBJUnNKG65qXJWhCXnMuTJcSZIKYkzhKiImD7NtRvubo0KICoYdSZKGN9bK1cURMan2JCIGgKs606TusGDVChcRlSRpJGMNV5cAF0VEX0TMA74PfKpTjeqKGPKg8aiNpXYzYHV9GFKSpOb0j2WnlNLXI2IvspA1D/ijlNKPO9iujjNUtWBwoprlJEmSGo0ariLirPqnwFzgp8CxEXFsSukvO9g29aqoFjy7OjRokJMkFcOeKldTG55fPMJ2lUqXK1cuxSBJKpBRw1VK6XPdakheXIqhCYNzrrp4TrOVJKkgxroUw1URsV/d8+kR8f2OtaoLzFQtyGPOlbe/kSQVxFivFpyZUnqq9iSl9CQwqyMt6hbTVQu6fbWg3yxJUnGMNVztiIi5tScRcQgTZqDGP9zjVpvQ7rigJEm7GdNSDMCngesj4jqyNPImYFXHWtUF0fCocej2OlcBhitJUlGMdZ2rKyPiKODY6qaPp5Qe71yz1NNymXPVvVNJktSKsVauAI4HTqx7flmb25IPS1dNyGPOlSu0S5KKYaxXC64BPgZsqH58LCK+2MmGdZpLMLQgxjpVr428WlCSVBBjrVydCixOKbvBW0SsB24D/qxTDesWM1YT8ri3oCRJBTGeEsR+dZ+/vM3t6DpDVQu6PucqDHKSpMIYa+XqvwO3RcQ1ZLnkROBTHWuVelweVwtKklQMY71a8MKIuBY4urrpkymlRzrWqi7y73YT8rha0MsFJUkFMdYJ7VenlDanlP6h+vFIRFzd6cZ1VC0gmK7GL485Vw4LSpIKYtTKVURMAfYBDoiI6eyKItOAgzrcto4yU7Wg61cL+t2SJBXHnoYF/wj4OPAK4Fayv3IJeAb46462TD2sVrnq4tpTVq4kSQUxagkipXR2Smk+8AWypRjmA98EfgH8axfa13HWRJrQ7UXCopbpJUnqfWMd3/m9lNLTEXEC8FbgPOB/da5ZnWeoaoHrXEmSNKKxhqsd1cf/AHw9pfRPwF6daVKXmK5akFO4MsxJkgpgrOFqU0R8DXg3cHlETB7HezXRDE5o72LYMQxLkgpirAHpXcD3gZNTSk8BM4A/6VSjuqH2t9p7DDYhl6UYBv8jSVJPG+sios8CF9c93wxs7lSj1ONyWURUkqRiKO3QngWrVtQqV10+rVlOklQApQ1XuEB783KZc+VyDJKkYihvuFLzvP2NJEkjMlypCc65kiRpJKUNV7HbJxqzvBYRtXolSSqA0oarGrNVE/K4WtBvlCSpIEofrtSE2oT2rleSrFxJknpfacOVi4cWjLlKklQQpQ1XakFulStJknpfacNVNDxqHPJaod0wJ0kqgNKGq0GmqybkdLWgJEkF0LFwFREHR8Q1EbEhIu6OiI916lxNMVQ1z3sLSpI0ojHduLlJLwH/JaX0bxExFbg1Iq5KKW3o4DnHzGzVAq8WlCRpRB2rXKWUNqeU/q36+TPAPcBBnTpfs8KYNX65zbnq7ukkSWpGV+ZcRcQ84PXATcO8tioibomIWx577LFuNEcty2POVYLnnoJnn+riOSVJGr+Oh6uI2Bf4HvDxlNLTja+nlM5NKS1JKS2ZOXNmp5uzq11WrJqXxyJh/VPgxWdh2+PdP7ckSePQ0XAVEZPIgtUFKaWLO3mucYshDxqPPOZc9fXDpCndP68kSePUyasFA1gH3JNS+stOnadlpqsm5Hi1oN8vSVKP62Tl6o3AHwBvjYifVj9O7eD51C2R4zpXafA/kiT1pI4txZBSup4erjP0bMOKwHWuJEkaUelXaDdkNSHPyhWY6SRJPa204cpQ1Yraj00ec64in/NKkjRGpQ1XpqsWDFaucji3VwpKknpcecOVmuecK0mSRlTacFWLB3msh1l8ec+5MtRJknpXacOVWhB5zrnq/iklSRoPw5XGL++rBR2OlCT1sNKGK4cDW5DnnCtzlSSpx5U2XNWYsZoVBh1JkoZR+nBlumpSBKSd+ZzbCe2SpB5muFJzHFeVJGlYpQ1X0fCo8QorSJIkDaO04cpU1aKokM+kK29/I0nqbaUNV2arFkVelatktpIk9bTShiu1yBsoS5I0rNKHKytYzcpzzpWhTpLUu0obrmK3TzQuUdofHUmSRlXev5CGqtYE5FdBsnIlSepd5Q1XalHFpRgkSRpGacOV61y1KM8J7WY6SVIPK224UovyWorBqxQlST2uxOEq6v6r8cspXDkUKUnqcaUNV94ar0W5rdAuSVJv68+7AbkzZDUnAp7eAndd0flz9e8FC94MfdUfV6tXkqQeZrhSc15xBPzqbtixvbPneekFeOrXMOd1sO8BhmFJUs8rbbjadbWgf62bcugJsN8rYPLLOnueJzfC3VfCzh3Z8zT4H0mSelJp51ypICp92WMtXEmS1OMMV+ptMUy4snAlSephpQ1XXi1YELXKVaqvXJmuJEm9q7ThSgVRqf6IOiwoSSqI0ocrK1g9rnHOVV4rw0uSNEalDVdmqoKozblKO+s2Gq4kSb2rtOHKdFUQg5Wrl3ZtM1tJknpYacOV2aogBsOVlStJUjGUNlzVGLJ63G7rXIXZSpLU00ofrkxXPS4qZIGqNqEdTFeSpF5W+nBltiqASl/DUgyGK0lS7yptuDJUFciQcOV3TpLU20obrvwbXSBRabj9jZUrSVLvKm+4UnFU+oauc2W4kiT1sNKGq2h4VA+r9A1d58o5V5KkHlbacKUCib5d61x5vyJJUo8zXPm3uvd5taAkqUBKG64sgBRIpW/XOlcuIipJ6nGlDVc1ZqwCqDReLbhz5H0lScpZacOVoapAonFYUJKk3lXacGW8KpAhw4KSJPW2EoerjBGrAOontEcADgtKknpXacNVuNBVcTReLeiEdklSDyttuFKB1K9zBZiuJEm9rGPhKiK+ERGPRsRdnTqHSsKlGCRJBdLJytW3gLd38Pht4ahgAbiIqCSpQDoWrlJK/wI80anjt8pQVSBRyda2evG56k2bDVeSpN7Vn3cDcmO6Ko6+SdnjzRfAAa+EQ98E25/bw3smZ4uPSpLUZbmHq4hYBawCmDt3bs6tUU+afVgWsH51F7ywDXa8AE/+auT90w7Y7yCY/LLutVGSpKrc/2mfUjo3pbQkpbRk5syZXTvv4EoMVrB636QpMLAQpkzL5l5N3hcm7zPyR+T+Yy1JKjH/Cqk4XKldklQAnVyK4ULgX4FXR8TGiFjZqXM1I4b5TD2u0rjelSRJvadjc65SSu/t1LHbwkxVPJU+2PlS3q2QJGlUpR8WNGMViJUrSVIBlDZcGaoKKJxzJUnqfaUNV4NMWcWx20rtkiT1ntKHK7NVgVT6spXakyu0S5J6V+nDlQok+rJHq1eSpB5W2nDl4qEFVLudjfOuJEk9rLThSgVUsXIlSep9pQ1X0fCoAnBYUJJUAKUNV4NMV8VRq1wl17qSJPUuw5WKY3BY0FXaJUm9q7ThygntBTQYrqxcSZJ6V2nDVY0Zq0Cc0C5JKoAShytjVeHUJrS7FIMkqYeVNlwZrQqots6VlStJUg8rbbiqpStDVoE4LChJKoDyhqsa01VxuM6VJKkADFcqDte5kiQVQGnDlQWrAnKdK0lSAZQ2XNUYsgrEda4kSQVQ2nBlqCog51xJkgqgtOHKdFVAFde5kiT1vvKGKxVPRPZh5UqS1MNKG65qhSvvMVgwlX7DlSSpp/Xn3QBpXKIC2x6HX909+n7TDuxOeyRJamC4UrFMmQZPP5J9jGb2a2DKvt1pkyRJdUobrhwOLKjX/g7seHHk1598GH5+3ej7SJLUQaUNVzVmrIKpVKAyZeTXJ+2dPTovS5KUk9JPaDddTTBR/ZE2XEmSclLacKUJylvkSJJyVvpwFZauJpaKq7hLkvJV3nBlppqYDFeSpJyVNlyZrSYow5UkKWelDVeaoGo3d07OuZIk5aP04coK1gRTq1ztsHIlScpHacOVSzFMULVwlQxXkqR8lDZcGaomqNqw4A6HBSVJ+ShvuNLEVLuvkZUrSVJOShuuautbWcCaYCKyoUGvFpQk5aS04UoTWFRcoV2SlJvShisrVhNYWLmSJOWntOGqlq4MWROQw4KSpByVN1zVmK4mnkrFcCVJyo3hShNP9DnnSpKUm9KGKwtWE5iVK0lSjkobrmoMWROQE9olSTkqfbjSBFRxKQZJUn5KG65qC3lbupqArFxJknJU2nClCcw5V5KkHJU+XFm4moC8WlCSlKPShitD1QRm5UqSlKPShivT1QTmnCtJUo46Gq4i4u0RcW9E3B8Rqzt5rvEyW01g3v5GkpSjjoWriOgDzgFOAQ4H3hsRh3fqfM0yZE1A4bCgJCk//R089huA+1NKvwCIiG8DpwMbOnjO8TNdtSalvFuwu0oF0g644Rt5t0RSnWtmVHhs/1lZdVnqoJmTZnDSy4/O7fydDFcHAQ/XPd8IHNO4U0SsAlYBzJ07t4PNGeoVL+/jNbP72WeS6aopAfTtBS8+l3dLdrffwfDis5icpR5T2Zl3C6Su6GS4GpOU0rnAuQBLlizpWhlk38kV3nDI5G6dbuKJCuzfvTA8Pq+C+fn9i0XS8E7KuwFSl3RyQvsm4OC653Oq2yRJkiasToarnwALImJ+ROwFvAf4hw6eT5IkKXcdGxZMKb0UEX8MfB/oA76RUrq7U+eTJEnqBR2dc5VSuhy4vJPnkCRJ6iXlXaFdkiSpAwxXkiRJbWS4kiRJaiPDlSRJUhsZriRJktrIcCVJktRGhitJkqQ2MlxJkiS1keFKkiSpjSKllHcbBkXEY8Avx/m2A4DHO9CcvEyk/kykvtRMtD5NtP7AxOuT/eldE6kvYH+acUhKaWbjxp4KV82IiFtSSkvybke7TKT+TKS+1Ey0Pk20/sDE65P96V0TqS9gf9rJYUFJkqQ2MlxJkiS10UQIV+fm3YA2m0j9mUh9qZlofZpo/YGJ1yf707smUl/A/rRN4edcSZIk9ZKJULmSJEnqGV0PVxFxcERcExEbIuLuiPhYdfuMiLgqIu6rPk6vbn9NRPxrRLwQEZ9oONbHIuKu6nE+Pso5vxERj0bEXQ3b31l9786IaOqKgib6c2ZE3BERd0bEjyPidXXHentE3BsR90fE6lHOuaJ63PsiYkXd9i9ExMMRsa2ZvvRgf66MiNur7fhqRPQVvD/XVt//0+rHrKL2JyKm1vXjpxHxeESsHW9/eqlP1e3vrh777oj4HwXqz5UR8VREXNaw/Y+r700RcUAP9GfY38XDnHPYfrfanx7ry7rIfr/dERHfjYh9C96fb0XEA7Hrd8LigvfnR3V9+VVEXDKuzqSUuvoBDABHVT+fCvwcOBz4C2B1dftq4H9UP58FHA18AfhE3XGOAO4C9gH6gR8Ah45wzhOBo4C7GrYvBF4NXAss6VJ/jgemVz8/Bbip+nkf8O/AK4G9gNuBw4c53wzgF9XH6dXPa8c7ttqebV38/nSyP9OqjwF8D3hPwfvT9M9ZL/anYb9bgROL3Cdgf+AhYGZ1v/XA0l7vT3XfpcDvAJc1bH89MA94EDggz+9P9fmwv4sbzjdiv1vtT4/1ZVrdfn9ZO3+B+/Mt4Pea+Rnrxf407Pc94A/H1ZdWvhDt+AAuBZYB9wIDdV/gexv2+yxDw9U7gXV1zz8D/Oko55k30heZNvzRG29/qtunA5uqnx8HfL/utU8BnxrmPe8Fvlb3/GvAexv2aTpc9Wh/JgH/CLy7yP1p589ZL/SnbtthwMNU53AWtU9k/4i7um77HwD/f6/3p+71t9AQrupee5Amw1W7+lO3bR6j/8HbY7/b1Z8e6UsA/wv4ZJH7QxvCVS/1p27bNOBJ6sLwWD5ynXMVEfPI/iVyEzA7pbS5+tIjwOw9vP0u4E0RsX9E7AOcChzcqbaORRP9WQlcUf38ILI/UDUbq9sajXW/lvVCfyLi+8CjwDPAd8fdiTq90B/gm9Uy82ciIsbdiTo90h+A9wDfSdXfRK3IuU/3A6+OiHkR0Q+8gxZ/p3SpP13TYn/Gqiv97oW+RMQ3q+d7DfDX4zz2EL3QH+AL1WG6/y8iJo/z2EP0SH8g+z1wdUrp6fEcuH+cDWmb6vjy94CPp5Serv87k1JKETHqL+qU0j2RzYn4Z+A3wE+BHZ1r8ejG25+IOInsh+GErjZ0jHqlPymlkyNiCnAB8FbgqmaO0yP9OTOltCkiplbb8gfA3zRzoB7pT817yPrSkrz7lFJ6MiL+E/AdYCfwY+BVzR4v7/6020TqT6/0JaX0gcjmkv418G7gm80cp0f68ymy4LMX2RIInwQ+38yBeqQ/Ne8Fzhvvm3KpXEXEJLIv3AUppYurm7dExED19QGyasWoUkrrUkq/lVI6kaxs9/PqhLjaJLQPd6oP9cbbn4h4Ldk36/SU0tbq5k0M/VfyHGBTRBxT15/TRtpvIvcnpfQ8WXn49CL3J6VUe3wG+N/AG4rcn+qxXwf0p5RubaYvvdanlNI/ppSOSSkdRzYU8fMC9Kfj2tSfkY7d+Du7o7/jeq0vKaUdwLeB5UXuT0ppc8q8QBYS8/z91nJ/qvsfUO3HP427I+MZQ2zHB9n48t8Aaxu2/0+GTlj7i4bXP0vdnKvqtlnVx7nAz4D9RjnvPDow52q8/am29X7g+Ib9+8km1s5n18S6RcOcbwbwANn48vTq5zMa9mllQntP9AfYl11j7P1k1YQ/LnB/+qnOESGbQ/Zd4MNF7U/d62uAzzX789ZrfWLX75TpZNXww3q9P3X7v4UOzLlqV3/q3jeP0efB7LHfzfanV/pSbcehdW36EvClovan+tpAXZvWAmuK3J/q6x8G1jf1/00zb2rlg6xsl4A7yH55/ZRsvtT+wNXAfWRX/tV+2R1INg76NPBU9fPaVWQ/AjZUvyAjXtUDXAhsBrZX37+yuv13q89fALZQN7Gtg/05j6zKVtv3lrpjnUr2L+V/Bz49yjk/WP2Buh/4QN32v6j2Z2f18bNF7Q/ZmPpPqu24i6xs3l/g/ryM7Iq6O4C7gbOBvqL2p+61XwCv6fLvhE7+P3Qh2e+UDTRxdWqO/fkR8BjwHNn/+ydXt//n6vOXgF8B5+Xcn2F/Fw9zzmH73Wp/eqUvZKNGNwB3kv1+u4BxTpjupf5Ut/+wrj9/C+xb5P5UX7sWeHszvwdcoV2SJKmNXKFdkiSpjQxXkiRJbWS4kiRJaiPDlSRJUhsZriRJktrIcCVpQoiIz0bEJ0Z5/R0RcXg32ySpnAxXksriHYDhSlLHuc6VpMKKiE8DK8huh/Ew2UKtvwZWka24fD/ZfQ8XA5dVX/s1u241cg4wE3gW+I8ppZ91sfmSJijDlaRCiojfAr4FHEN2G4t/A74KfDNV7zEWEX8ObEkp/XVEfIvs9jDfrb52NdktiO6LiGOA/55Semv3eyJpounPuwGS1KQ3AX+fUnoWICL+obr9iGqo2o/sHpXfb3xjROwLHA/8XUTUNk/udIMllYPhStJE8y3gHSml2yPi/WQ3NG5UAZ5KKS3uXrMklYUT2iUV1b8A74iIvSNiKvA71e1Tgc0RMQk4s27/Z6qvkVJ6GnggIt4JEJnXda/pkiYyw5WkQkop/RvwHeB24ArgJ9WXPgPcBNwA1E9Q/zbwJxFxW0S8iix4rYyI24G7gdO71XZJE5sT2iVJktrIypUkSVIbGa4kSZLayHAlSZLURoYrSZKkNjJcSZIktZHhSpIkqY0MV5IkSW1kuJIkSWqj/wO/7MmFxR8b3QAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 720x432 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "line,ax = plt.subplots(figsize=(10,6))\n",
    "ax = sns.lineplot(x=\"date\", y=\"stocks\", data=df,palette=\"pastel\",hue='year')\n",
    "ax.set_title(\"stock variation\", fontsize=15)\n",
    "ax.set_xlabel (\"date\")\n",
    "ax.set_ylabel (\"stock\")\n",
    "ax.legend (loc=\"upper right\");"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d2ea3648",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}