Quantium_Data_Analysis.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Quantium_Data_Analysis .ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Kushagratandon12/Introduction_to_tensorflow/blob/master/Quantium_Data_Analysis.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gs2htGlvkzlI",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "sM-5Y_gPwb7B",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 128
        },
        "outputId": "9322ab58-5d03-4499-efc5-66f60964d11b"
      },
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Go to this URL in a browser: https://accounts.google.com/o/oauth2/auth?client_id=947318989803-6bn6qk8qdgf4n4g3pfee6491hc0brc4i.apps.googleusercontent.com&redirect_uri=urn%3aietf%3awg%3aoauth%3a2.0%3aoob&response_type=code&scope=email%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdocs.test%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive.photos.readonly%20https%3a%2f%2fwww.googleapis.com%2fauth%2fpeopleapi.readonly\n",
            "\n",
            "Enter your authorization code:\n",
            "··········\n",
            "Mounted at /content/drive\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xJRTEJm2lCo5",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 228
        },
        "outputId": "4769ba56-01eb-4307-9860-8c53b5415561"
      },
      "source": [
        "#Loading the data in the csv format and then reading and validating the data for data interpretation\n",
        "df = pd.read_csv('/content/drive/My Drive/Colab Notebooks/QVI_purchase_behaviour.csv',index_col = 0)\n",
        "df = pd.DataFrame(df)\n",
        "df.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>LIFESTAGE</th>\n",
              "      <th>PREMIUM_CUSTOMER</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>LYLTY_CARD_NBR</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1000</th>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1002</th>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Mainstream</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1003</th>\n",
              "      <td>YOUNG FAMILIES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1004</th>\n",
              "      <td>OLDER SINGLES/COUPLES</td>\n",
              "      <td>Mainstream</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1005</th>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Mainstream</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                             LIFESTAGE PREMIUM_CUSTOMER\n",
              "LYLTY_CARD_NBR                                         \n",
              "1000             YOUNG SINGLES/COUPLES          Premium\n",
              "1002             YOUNG SINGLES/COUPLES       Mainstream\n",
              "1003                    YOUNG FAMILIES           Budget\n",
              "1004             OLDER SINGLES/COUPLES       Mainstream\n",
              "1005            MIDAGE SINGLES/COUPLES       Mainstream"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "i-pSZwIVmV29",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        },
        "outputId": "6836dee0-2cf5-4df2-b927-26660e68d2c3"
      },
      "source": [
        "#size of the data_set present\n",
        "print(df.size) #bytes of data\n",
        "print(df.shape) #row and col in the data defined "
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "145274\n",
            "(72637, 2)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5BrfyL_gn1AQ",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 254
        },
        "outputId": "a4e9396b-24d2-4e44-be57-d97f2a50c8b6"
      },
      "source": [
        "df['LIFESTAGE']"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "LYLTY_CARD_NBR\n",
              "1000        YOUNG SINGLES/COUPLES\n",
              "1002        YOUNG SINGLES/COUPLES\n",
              "1003               YOUNG FAMILIES\n",
              "1004        OLDER SINGLES/COUPLES\n",
              "1005       MIDAGE SINGLES/COUPLES\n",
              "                    ...          \n",
              "2370651    MIDAGE SINGLES/COUPLES\n",
              "2370701            YOUNG FAMILIES\n",
              "2370751            YOUNG FAMILIES\n",
              "2370961            OLDER FAMILIES\n",
              "2373711     YOUNG SINGLES/COUPLES\n",
              "Name: LIFESTAGE, Length: 72637, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "z0CLf0nebjq3",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "outputId": "40d1ef94-e661-4094-9616-cf092f860dd6"
      },
      "source": [
        "new_df = df[(df['LIFESTAGE']=='YOUNG SINGLES/COUPLES') & (df['PREMIUM_CUSTOMER']=='Premium')]\n",
        "print(new_df)\n",
        "print('\\n\\nTotal number of data enteries for  YOUNG SINGLES/COUPLES which are Premium customers')\n",
        "print(new_df.shape)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "                            LIFESTAGE PREMIUM_CUSTOMER\n",
            "LYLTY_CARD_NBR                                        \n",
            "1000            YOUNG SINGLES/COUPLES          Premium\n",
            "1024            YOUNG SINGLES/COUPLES          Premium\n",
            "1042            YOUNG SINGLES/COUPLES          Premium\n",
            "1068            YOUNG SINGLES/COUPLES          Premium\n",
            "1146            YOUNG SINGLES/COUPLES          Premium\n",
            "...                               ...              ...\n",
            "272236          YOUNG SINGLES/COUPLES          Premium\n",
            "272319          YOUNG SINGLES/COUPLES          Premium\n",
            "272358          YOUNG SINGLES/COUPLES          Premium\n",
            "272379          YOUNG SINGLES/COUPLES          Premium\n",
            "272380          YOUNG SINGLES/COUPLES          Premium\n",
            "\n",
            "[2574 rows x 2 columns]\n",
            "\n",
            "\n",
            "Total number of data enteries for  YOUNG SINGLES/COUPLES which are Premium customers\n",
            "(2574, 2)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Gp2Haa-ZcSIX",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 228
        },
        "outputId": "c377d069-e771-4b24-c8c0-b56216ef16d8"
      },
      "source": [
        "trans_df = pd.read_csv('/content/drive/My Drive/Colab Notebooks/QVI_transaction_data.csv',index_col = 0)\n",
        "trans_df = pd.DataFrame(trans_df)\n",
        "trans_df.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>STORE_NBR</th>\n",
              "      <th>LYLTY_CARD_NBR</th>\n",
              "      <th>TXN_ID</th>\n",
              "      <th>PROD_NBR</th>\n",
              "      <th>PROD_NAME</th>\n",
              "      <th>PROD_QTY</th>\n",
              "      <th>TOT_SALES</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>DATE</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>43390</th>\n",
              "      <td>1</td>\n",
              "      <td>1000</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>Natural Chip        Compny SeaSalt175g</td>\n",
              "      <td>2</td>\n",
              "      <td>6.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43599</th>\n",
              "      <td>1</td>\n",
              "      <td>1307</td>\n",
              "      <td>348</td>\n",
              "      <td>66</td>\n",
              "      <td>CCs Nacho Cheese    175g</td>\n",
              "      <td>3</td>\n",
              "      <td>6.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43605</th>\n",
              "      <td>1</td>\n",
              "      <td>1343</td>\n",
              "      <td>383</td>\n",
              "      <td>61</td>\n",
              "      <td>Smiths Crinkle Cut  Chips Chicken 170g</td>\n",
              "      <td>2</td>\n",
              "      <td>2.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43329</th>\n",
              "      <td>2</td>\n",
              "      <td>2373</td>\n",
              "      <td>974</td>\n",
              "      <td>69</td>\n",
              "      <td>Smiths Chip Thinly  S/Cream&amp;Onion 175g</td>\n",
              "      <td>5</td>\n",
              "      <td>15.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43330</th>\n",
              "      <td>2</td>\n",
              "      <td>2426</td>\n",
              "      <td>1038</td>\n",
              "      <td>108</td>\n",
              "      <td>Kettle Tortilla ChpsHny&amp;Jlpno Chili 150g</td>\n",
              "      <td>3</td>\n",
              "      <td>13.8</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       STORE_NBR  LYLTY_CARD_NBR  ...  PROD_QTY  TOT_SALES\n",
              "DATE                              ...                     \n",
              "43390          1            1000  ...         2        6.0\n",
              "43599          1            1307  ...         3        6.3\n",
              "43605          1            1343  ...         2        2.9\n",
              "43329          2            2373  ...         5       15.0\n",
              "43330          2            2426  ...         3       13.8\n",
              "\n",
              "[5 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "fkvVJWkAjn9i",
        "colab_type": "text"
      },
      "source": [
        "MERGING THEE TWO DATASET THAT ARE PROVIDED FOR STUDY --- QUANTIUM DATASET\n",
        "\n",
        "ANALYZING THE DATASET BY JOINING THE BOTH DATASET "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "n19_gT0hg_Ta",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 407
        },
        "outputId": "cf9dd258-6583-4c2a-d6b2-0569097215ac"
      },
      "source": [
        "merged_data = pd.merge(trans_df,df,how='inner',left_on='LYLTY_CARD_NBR' , right_on='LYLTY_CARD_NBR')\n",
        "merged_data = pd.DataFrame(merged_data)\n",
        "merged_data"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>STORE_NBR</th>\n",
              "      <th>LYLTY_CARD_NBR</th>\n",
              "      <th>TXN_ID</th>\n",
              "      <th>PROD_NBR</th>\n",
              "      <th>PROD_NAME</th>\n",
              "      <th>PROD_QTY</th>\n",
              "      <th>TOT_SALES</th>\n",
              "      <th>LIFESTAGE</th>\n",
              "      <th>PREMIUM_CUSTOMER</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1000</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>Natural Chip        Compny SeaSalt175g</td>\n",
              "      <td>2</td>\n",
              "      <td>6.0</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>1307</td>\n",
              "      <td>348</td>\n",
              "      <td>66</td>\n",
              "      <td>CCs Nacho Cheese    175g</td>\n",
              "      <td>3</td>\n",
              "      <td>6.3</td>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1</td>\n",
              "      <td>1307</td>\n",
              "      <td>346</td>\n",
              "      <td>96</td>\n",
              "      <td>WW Original Stacked Chips 160g</td>\n",
              "      <td>2</td>\n",
              "      <td>3.8</td>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1</td>\n",
              "      <td>1307</td>\n",
              "      <td>347</td>\n",
              "      <td>54</td>\n",
              "      <td>CCs Original 175g</td>\n",
              "      <td>1</td>\n",
              "      <td>2.1</td>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1</td>\n",
              "      <td>1343</td>\n",
              "      <td>383</td>\n",
              "      <td>61</td>\n",
              "      <td>Smiths Crinkle Cut  Chips Chicken 170g</td>\n",
              "      <td>2</td>\n",
              "      <td>2.9</td>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>264831</th>\n",
              "      <td>272</td>\n",
              "      <td>272319</td>\n",
              "      <td>270088</td>\n",
              "      <td>89</td>\n",
              "      <td>Kettle Sweet Chilli And Sour Cream 175g</td>\n",
              "      <td>2</td>\n",
              "      <td>10.8</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>264832</th>\n",
              "      <td>272</td>\n",
              "      <td>272358</td>\n",
              "      <td>270154</td>\n",
              "      <td>74</td>\n",
              "      <td>Tostitos Splash Of  Lime 175g</td>\n",
              "      <td>1</td>\n",
              "      <td>4.4</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>264833</th>\n",
              "      <td>272</td>\n",
              "      <td>272379</td>\n",
              "      <td>270187</td>\n",
              "      <td>51</td>\n",
              "      <td>Doritos Mexicana    170g</td>\n",
              "      <td>2</td>\n",
              "      <td>8.8</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>264834</th>\n",
              "      <td>272</td>\n",
              "      <td>272379</td>\n",
              "      <td>270188</td>\n",
              "      <td>42</td>\n",
              "      <td>Doritos Corn Chip Mexican Jalapeno 150g</td>\n",
              "      <td>2</td>\n",
              "      <td>7.8</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>264835</th>\n",
              "      <td>272</td>\n",
              "      <td>272380</td>\n",
              "      <td>270189</td>\n",
              "      <td>74</td>\n",
              "      <td>Tostitos Splash Of  Lime 175g</td>\n",
              "      <td>2</td>\n",
              "      <td>8.8</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>264836 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        STORE_NBR  LYLTY_CARD_NBR  ...               LIFESTAGE  PREMIUM_CUSTOMER\n",
              "0               1            1000  ...   YOUNG SINGLES/COUPLES           Premium\n",
              "1               1            1307  ...  MIDAGE SINGLES/COUPLES            Budget\n",
              "2               1            1307  ...  MIDAGE SINGLES/COUPLES            Budget\n",
              "3               1            1307  ...  MIDAGE SINGLES/COUPLES            Budget\n",
              "4               1            1343  ...  MIDAGE SINGLES/COUPLES            Budget\n",
              "...           ...             ...  ...                     ...               ...\n",
              "264831        272          272319  ...   YOUNG SINGLES/COUPLES           Premium\n",
              "264832        272          272358  ...   YOUNG SINGLES/COUPLES           Premium\n",
              "264833        272          272379  ...   YOUNG SINGLES/COUPLES           Premium\n",
              "264834        272          272379  ...   YOUNG SINGLES/COUPLES           Premium\n",
              "264835        272          272380  ...   YOUNG SINGLES/COUPLES           Premium\n",
              "\n",
              "[264836 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FGQnWR8Zv40N",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 288
        },
        "outputId": "deb8516c-cc89-49bb-8adb-1462dce1503f"
      },
      "source": [
        "merged_data.describe()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>STORE_NBR</th>\n",
              "      <th>LYLTY_CARD_NBR</th>\n",
              "      <th>TXN_ID</th>\n",
              "      <th>PROD_NBR</th>\n",
              "      <th>PROD_QTY</th>\n",
              "      <th>TOT_SALES</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>264836.00000</td>\n",
              "      <td>2.648360e+05</td>\n",
              "      <td>2.648360e+05</td>\n",
              "      <td>264836.000000</td>\n",
              "      <td>264836.000000</td>\n",
              "      <td>264836.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>135.08011</td>\n",
              "      <td>1.355495e+05</td>\n",
              "      <td>1.351583e+05</td>\n",
              "      <td>56.583157</td>\n",
              "      <td>1.907309</td>\n",
              "      <td>7.304200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>76.78418</td>\n",
              "      <td>8.057998e+04</td>\n",
              "      <td>7.813303e+04</td>\n",
              "      <td>32.826638</td>\n",
              "      <td>0.643654</td>\n",
              "      <td>3.083226</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>1.00000</td>\n",
              "      <td>1.000000e+03</td>\n",
              "      <td>1.000000e+00</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.500000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>70.00000</td>\n",
              "      <td>7.002100e+04</td>\n",
              "      <td>6.760150e+04</td>\n",
              "      <td>28.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>5.400000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>130.00000</td>\n",
              "      <td>1.303575e+05</td>\n",
              "      <td>1.351375e+05</td>\n",
              "      <td>56.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>7.400000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>203.00000</td>\n",
              "      <td>2.030942e+05</td>\n",
              "      <td>2.027012e+05</td>\n",
              "      <td>85.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>9.200000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>272.00000</td>\n",
              "      <td>2.373711e+06</td>\n",
              "      <td>2.415841e+06</td>\n",
              "      <td>114.000000</td>\n",
              "      <td>200.000000</td>\n",
              "      <td>650.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          STORE_NBR  LYLTY_CARD_NBR  ...       PROD_QTY      TOT_SALES\n",
              "count  264836.00000    2.648360e+05  ...  264836.000000  264836.000000\n",
              "mean      135.08011    1.355495e+05  ...       1.907309       7.304200\n",
              "std        76.78418    8.057998e+04  ...       0.643654       3.083226\n",
              "min         1.00000    1.000000e+03  ...       1.000000       1.500000\n",
              "25%        70.00000    7.002100e+04  ...       2.000000       5.400000\n",
              "50%       130.00000    1.303575e+05  ...       2.000000       7.400000\n",
              "75%       203.00000    2.030942e+05  ...       2.000000       9.200000\n",
              "max       272.00000    2.373711e+06  ...     200.000000     650.000000\n",
              "\n",
              "[8 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ipY_DtASwySR",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 298
        },
        "outputId": "82089717-9452-4076-d93f-389e89af336c"
      },
      "source": [
        "#GRAPHICAL STUDY \n",
        "graph_sales  = pd.DataFrame(merged_data , columns=['TOT_SALES','PREMIUM_CUSTOMER'])\n",
        "import matplotlib.pyplot as plt\n",
        "\n",
        "graph_sales.plot(x='PREMIUM_CUSTOMER',y='TOT_SALES',kind='scatter')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f019b83a080>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZQAAAEHCAYAAACJN7BNAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAaTElEQVR4nO3dfZRlVX3m8e8joFFDaJC2hzSQJjZqiCKQkoEYJ0ZWGCEmYJavS0JriD3JYhBjnEgyrjiaZETFmDDJIkPAEfKiEpwEogRhWkwwAlpA0yiQoeTFbuSlaYHBoKD4mz/OruZSVHVVdZ3bVdX1/axV656zzz7n7Ft9+j51Xu7eqSokSZqrp813AyRJOwcDRZLUCwNFktQLA0WS1AsDRZLUi13nuwFztffee9eqVavmuxmStKhce+2191fV8j63uegDZdWqVYyOjs53MyRpUUlyZ9/b9JKXJKkXBookqRcGiiSpFwaKJKkXBookqRdLNlDG7n2YC0c3Mnbvw/PdFEnaKSz6x4a3x+/9/Y2cf/U3ts6feOT+vP+4F89jiyRp8VtyZyhj9z78pDABOP+qb3imIklztOQCZf3GB2dVLkmamSUXKIfst2xW5ZKkmVlygbJ6xe6ceOT+Tyo78cj9Wb1i93lqkSTtHJbkTfn3H/diTjxiFes3Psgh+y0zTCSpB0syUKA7UzFIJKk/S+6SlyRpOAwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSL4YeKEmWJbkwyS1Jbk5yZJK9klye5Nb2umermyRnJhlLsiHJYcNunySpHzviDOVPgEur6oXAS4CbgdOAdVV1ILCuzQMcAxzYftYCZ+2A9kmSejDUQEmyB/AfgHMBquqxqnoQOA44r1U7Dzi+TR8HnF+dq4FlSfYZZhslSf0Y9hnKAcBm4H8luT7JOUmeDayoqrtbnXuAFW16JbBxYP1NrUyStMANO1B2BQ4DzqqqQ4F/44nLWwBUVQE1m40mWZtkNMno5s2be2usJGn7DTtQNgGbquqaNn8hXcDcO34pq73e15bfBew3sP6+rexJqursqhqpqpHly5cPrfGSpJkbaqBU1T3AxiQvaEVHATcBFwNrWtka4KI2fTFwYnva6wjgoYFLY5KkBWxHdF9/CvDXSZ4O3Aa8lS7ILkhyEnAn8PpW9xLgWGAMeKTVlSQtAkMPlKpaD4xMsuioSeoWcPKw2yRJ6p/flJck9cJAkST1wkCRJPXCQJEk9cJAkST1wkCRJPXCQJEk9cJAkST1wkCRJPXCQJEk9cJAkST1wkCRJPXCQJEk9cJAkST1wkCRJPXCQJEk9cJAkST1wkCRJPXCQJEk9cJAkST1wkCRJPXCQJEk9WLogZLkjiQ3JlmfZLSV7ZXk8iS3ttc9W3mSnJlkLMmGJIcNu32SpH7sqDOUn6uqQ6pqpM2fBqyrqgOBdW0e4BjgwPazFjhrB7VPkjRH83XJ6zjgvDZ9HnD8QPn51bkaWJZkn/looCRpdnZEoBRwWZJrk6xtZSuq6u42fQ+wok2vBDYOrLuplT1JkrVJRpOMbt68eVjtliTNwq47YB8/U1V3JXkucHmSWwYXVlUlqdlssKrOBs4GGBkZmdW6kqThGPoZSlXd1V7vA/4OOBy4d/xSVnu9r1W/C9hvYPV9W5kkaYEbaqAkeXaS3cengaOBrwIXA2tatTXARW36YuDE9rTXEcBDA5fGJEkL2LAvea0A/i7J+L7+pqouTfIV4IIkJwF3Aq9v9S8BjgXGgEeAtw65fZKkngw1UKrqNuAlk5RvAY6apLyAk4fZJknScPhNeUlSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi+2GShJnpVkt4H5FyT5zSS/PJudJNklyfVJPtPmD0hyTZKxJJ9K8vRW/ow2P9aWr5r9W5IkzYfpzlAuBVYBJFkNXAX8OHBykg/MYj+nAjcPzH8Q+GhVrQYeAE5q5ScBD7Tyj7Z6kqRFYLpA2bOqbm3Ta4BPVNUpwDHAq2eygyT7Ar8AnNPmA7wSuLBVOQ84vk0f1+Zpy49q9SVJC9x0gVID068ELgeoqseAH8xwH38M/PZA/ecAD1bV99v8JmBlm14JbGz7+D7wUKsvSVrgdp1m+YYkZwB3AauBywCSLJvJxpO8Grivqq5N8oq5NHTCdtcCawH233//vjYrSZqD6c5Q3gbcT3cf5eiqeqSVHwScMYPtvwz4pSR3AJ+kO8v5E2BZkvEw25cusGiv+wG05XsAWyZutKrOrqqRqhpZvnz5DJohSRq26QJlt6o6vapOraobxgur6kvAP0238ar6narat6pWAW8EPl9VbwauAF7bqq0BLmrTF7d52vLPV9XgZTdJ0gI1XaB8YXwiyboJy/5+Dvt9N/DOJGN090jObeXnAs9p5e8ETpvDPiRJO9B091AGn7DaaxvLplVVX6AFVFXdBhw+SZ3vAq+bzXYlSQvDbJ7ymnjpyUtRkqStpjtDeW6Sd9KdjYxP0+a9Gy5J2mq6QPkLYPdJpqF9UVGSJJgmUKrqfVMtS/KO/psjSVqs5tLb8DunryJJWirmEij2sSVJ2mougeJTXpKkrbZ5DyXJw0weHAGeNZQWSZIWpeluyu++reWSJI2b9SWvJM9OckKSzw6jQZKkxWlGgZLk6Ulek+RvgbuBo4A/H2rLJEmLynT3UI4G3gQcTddD8PnAS6vqrTugbZKkRWQmY8r/OPAzVXVCVf0DMx+pUZK0hEzX9cphdOOY/J8kt9ENkrXL0FslSVp0tnmGUlXrq+q0qnoe8F7gEGC3JP/YhuGVJAmYxVNeVfWlqjqFbsjePwKOGFqrJEmLznQ35Z8FfK+qvtfmXwAcC9xZVb+6A9onSVokZnJTfhVAktXAVXQ36U9O8oHhNk2StJhMFyh7VtWtbXoN8Il22esY4NVDbZkkaVGZzRDArwQuB6iqx/DxYUnSgOkeG96Q5AzgLmA1cBlAkmXDbpgkaXGZ7gzlbcD9dPdRjq6qR1r5QcAZQ2yXJGmRme57KN+pqtOr6tSqumGg/EtV9Zfj80k+Pdn6SX4oyZeT3JDka0ne18oPSHJNkrEkn0ry9Fb+jDY/1pav6uNNSpKGby4DbA368SnKHwVeWVUvoftS5KuSHAF8EPhoVa0GHgBOavVPAh5o5R9t9SRJi0BfgTLp6I3V+Xab3a39FN0N/gtb+XnA8W36uDZPW35UEocalqRFoK9AmVKSXZKsB+6je0rs68CDVfX9VmUTsLJNrwQ2ArTlDwHPmWSba5OMJhndvHnzsN+CJGkG+gqUKc8iqurxqjqErsuWw4EXznVnVXV2VY1U1cjy5cvnujlJUg+2GShJPj7D7bx7ugpV9SDdmCpHAsuSjD+yvC/dY8m01/3avncF9gC2zLANkqR5NN0ZysEz2UhVXTZZeZLl499ZSfJM4OeBm+mC5bWt2hrgojZ9cZunLf98VU16f0aStLBM98XGZyU5lCkuaVXVddOsvw9wXpJd6MLrgqr6TJKbgE8m+QPgeuDcVv9c4C+TjAHfohuLRZK0CEwXKCuBjzB5oIw/rTWlqtoAHDpJ+W1091Mmln8XeN00bZIkLUDTBcpYVW0zNCRJgh3w2LAkaWmY7gzl3dB1oULXOSR0Zy3fHWqrJEmLznRnKFck+RDdlw/PA84HNib5UJLdht46SdKiMV2gfAjYCzigqn6qqg4Dngcsw96GJUkDpguUVwNvq6qHxwuq6v8Bv0E3trwkScAMRmyc7IuFVfU4U3QIKUlamqYLlJuSnDixMMkJwC3DaZIkaTGa7imvU4ALk/wqcG0rGwGeCbxmmA2TJC0u0wXKRVV1WJKj6Ib9BbikqtYNuV2SpEVmukAJQAsQQ0SSNKXpAmV5kndOtbCq/qjn9kiSFqnpAmUX4IfZxgBakiTB9IFyd1W9f4e0RJK0qE332LBnJpKkGZkuUI7aIa2QJC162wyUqvrWjmqIJGlxczwUSVIvDBRJUi8MFElSLwwUSVIvhhooSfZLckWSm5J8LcmprXyvJJcnubW97tnKk+TMJGNJNiQ5bJjtkyT1Z9hnKN8HfquqDgKOAE5OchBwGrCuqg6k6yPstFb/GODA9rMWOGvI7ZMk9WSogVJVd1fVdW36YeBmYCVwHN0Y9bTX49v0ccD51bkaWJZkn2G2UZLUjx12DyXJKuBQ4BpgRVXd3RbdA6xo0yuBjQOrbWplkqQFbocESpIfBj4NvKONSb9VG2J4VsMJJ1mbZDTJ6ObNm3tsqSRpew09UJLsRhcmf11V/7sV3zt+Kau93tfK7wL2G1h931b2JFV1dlWNVNXI8uXLh9d4SdKMDfsprwDnAjdPGDvlYmBNm14DXDRQfmJ72usI4KGBS2OSpAVsuu7r5+plwK8ANyZZ38p+FzgduCDJScCdwOvbskuAY4Ex4BHgrUNunySpJ0MNlKr6IlN3gf+Unozb/ZSTh9kmSdJw+E15SVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvhhooST6W5L4kXx0o2yvJ5Uluba97tvIkOTPJWJINSQ4bZtskSf0a9hnKx4FXTSg7DVhXVQcC69o8wDHAge1nLXDWkNsmSerRUAOlqv4Z+NaE4uOA89r0ecDxA+XnV+dqYFmSfYbZPklSf+bjHsqKqrq7Td8DrGjTK4GNA/U2tbKnSLI2yWiS0c2bNw+vpZKkGZvXm/JVVUBtx3pnV9VIVY0sX758CC2TJM3WfATKveOXstrrfa38LmC/gXr7tjJJ0iIwH4FyMbCmTa8BLhooP7E97XUE8NDApTFJ0gK36zA3nuQTwCuAvZNsAt4LnA5ckOQk4E7g9a36JcCxwBjwCPDWYbZNktSvoQZKVb1pikVHTVK3gJOH2R5J0vD4TXlJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvDBRJUi8MFElSLwwUSVIvlmygjN6+hT+67F8ZvX3LfDdFO6Et336UGzY+yJZvPzrfTdFOaiF+hg21t+GF6oRzruaLY90/wpmfH+Plq5/DX/7aEfPcKu0sLlp/F6d+cv3W+TPfeAi/dMiko1lL22WhfoYtuTOU0du3bP2HGHfl2JYFlfJavLZ8+9EnhQnA2z+53jMV9WYhf4YtuUA57dMbZlUuzcZr/uyLsyqXZuvkv7luVuU70pILlLH7H5lVuTQb33jgu7Mql2br3ocfm1X5jrTkAkWSNBwGiiSpFwaKJKkXBookqRcLLlCSvCrJvyYZS3LafLdHkjQzCypQkuwC/BlwDHAQ8KYkB81vqyRJM7GgAgU4HBirqtuq6jHgk8Bx89wmSdIMLLRAWQlsHJjf1MqeJMnaJKNJRjdv3rzDGidJmtpCC5QZqaqzq2qkqkaWL18+382RJLHwAuUuYL+B+X1bWW/uOP0XZlUuzYbHl4ZtIR9jCy1QvgIcmOSAJE8H3ghc3PdOJv7iF8I/hHYeHl8atoV6jKWq5rsNT5LkWOCPgV2Aj1XVH26r/sjISI2Oju6QtknSziLJtVU10uc2F9x4KFV1CXDJfLdDkjQ7C+2SlyRpkTJQJEm9MFAkSb0wUCRJvVhwT3nNVpLNwJ3bufrewP09Nkca5PGlYZvLMfZjVdXrN8MXfaDMRZLRvh+bk8Z5fGnYFtox5iUvSVIvDBRJUi+WeqCcPd8N0E7N40vDtqCOsSV9D0WS1J+lfoYiSeqJgSJJ6sWiCZQkjydZn+SrSf42ybOGsI9fT3Ji39vV4jNwvN2Q5LokPz3L9V+R5DNz2P/vbu+6mh9JKslfDczvmmTzdMdBkpEkZ27nPt8xjM/C7bVoAgX4TlUdUlUvAh4Dfn1wYZI595xcVX9eVefPdTvaKYwfby8Bfgf4wA7ev4Gy+Pwb8KIkz2zzP88MBgisqtGqevt27vMdwKSBkmSX7dzmdltMgTLoSmB1+yvwyiQXAzcl2SXJh5N8JcmGJP8Jtv61+E9JLkpyW5LTk7w5yZeT3Jjkea3ef0vyrjb9hSQjbXrvJHe06bck+fsklye5I8l/TvLOJNcnuTrJXvPyG9Ew/QjwADz1zCPJnyZ5S5t+VZJbklwH/PJAneXtePlaknOS3Jlk77bshHYcrk/yP9sxfDrwzFb21zvyjWrOLgHGR7t6E/CJ8QVJDk9yVfus+FKSF7TyrcdU+wz6WPv8uS3J21v5s5N8tp0xfzXJG9qyHwWuSHJFq/ftJB9JcgNw5GTHV6t3VpLRdky+b6CNdyT5QKs/muSwJJ9L8vUkT/ojfjKLLlDamcgxwI2t6DDg1Kp6PnAS8FBVvRR4KfC2JAe0ei+hO6v5CeBXgOdX1eHAOcAps2zGi+g+MF4K/CHwSFUdClwFeMls5zD+gX4L3THy+9uqnOSHgL8AfhH4KeDfDSx+L/D5qvpJ4EJg/7bOTwBvAF5WVYcAjwNvrqrTeOIM6c09vy8N1yeBN7bj4WDgmoFltwAvb58Vvwf89ym28ULgPwKHA+9NshvwKuCbVfWSdpXm0qo6E/gm8HNV9XNt3WcD17Qz6y1Mcny1ev+1fcP+YOBnkxw8sP9vtPpXAh8HXgscAbyPaSy4Aba24ZlJ1rfpK4FzgZ8GvlxVt7fyo4GDk7y2ze8BHEh3iewrVXU3QJKvA5e1OjcC4/8YM3VFVT0MPJzkIeAfBrZ18NSraRH5TvtPRZIjgfOTvGgb9V8I3F5Vt7Z1/gpY25b9DPAagKq6NMkDrfwouvD5ShKAZwL39f1GtONU1YYkq+jOTiYOFLgHcF6SA4ECdptiM5+tqkeBR5PcB6yg+2z5SJIPAp+pqiunWPdx4NNtelvH1+uTrKXLgH2Ag4ANbdn4sOs3Aj888Fn3aJJlVfXgVO9/MQXK1v/g49ov6d8Gi4BTqupzE+q9Anh0oOgHA/M/YPLfw/d54gzuhyYsm+22tIhV1VXtEtVynnxcwFOPjdkIcF5V/c5c2qcF52LgDOAVwHMGyn+f7o/R17TQ+cIU6w9+vjwO7FpV/zfJYcCxwB8kWVdV759k3e9W1eNtetLjq121eRfw0qp6IMnHefJxPPh5NvGzbpufb4vuktc0Pgf8RjtFJMnzkzx7O7d1B126Q3fKpyUqyQuBXeguIdwJHJTkGUmW0f0VCN3ljFXj9+Po/kId9y/A69u2jgb2bOXrgNcmeW5btleSH2vLvjd+HGvR+Rjwvqq6cUL5Hjxxk/4ts9lgkh+lu7T+V8CH6S71AzwM7D7FalMdXz9C94f4Q0lW0N1C6MXO9tf0OcAq4Lp0py+bgeO3c1tnABe008LP9tM8LSKDl1gDrGl/+W1McgHwVeB24HqAqvru+LGS5BG6y7Lj/9HfB3wiya/Q3We7B3i4qu5P8h7gsiRPA74HnEwXWmcDG5Jc532UxaWqNgGTPQb8IbpLXu9h9p8pLwY+nOQHdMfJb7Tys4FLk3xz4D7KeDtumuz4qqqrk1xP90fQRro/eHph1yvSkCV5BvB4VX2/3Y85a+LlW2lnsLOdoUgL0f50Z7tPo3tA5G3z3B5pKDxDkST1Yme7KS9JmicGiiSpFwaKJKkXBookqRcGihaMTDFEwYTyf2hfKCTJqiTfacvGf05sy+5IcuWE7a9P8tU2PbFDvndNqHtHnujAcXu7JT+mdbB3U7oOAT/Syj8+0D3QeN1vt9enJTmzvdcb03V0ekCSa1r7v9H2Pf5+VyXZI8n5ScbSdeJ3fpI9Bn5HleQPBva1d5LvJfnTgfd/14Tf47L2O3qozd+S5IyZ/2tqKTJQtJBMNUTBYPm36L78N+7rbdn4z+DwA7sn2Q+2dsS4vWbdLXm6fr/+FDihqg4CRoCxGezrDXQ9yB5cVS+m6wPswar69+27K78HfGrg/d5B16/dbVW1uqqeR/eFy3MGtnk7T/SAC/A64GsT9vvRCb/H8f6armz7PRR4dZKXzeA9aIkyULRQXQmsnqT8KmDlDLdxAd0HNEzoSnw7TNkt+RR+G/jDqroFoKoer6qzZrCffYC7q+oHbb1NVfXAVJWTrKbrImiwN+T3AyMD3cA8AtycNhwD3e/kghm0Zauq+g6wnpn/7rUEGShacPLUIQrGy3eh6zvr4oHi5024VPPygWWf5olxSX6RJ3qF3h7b6pZ8Mi8Crt2O/VwA/GJ7Lx9Jcug09Q8C1g90CEibXg/85EC98fbvR9fh4DcnbOc3B36HV0zcSZI96Xru/ufZvyUtFX5TXgvJZEMUDJavBG4GLh9Y5+vb6MZkC/BAkje29R6Zot5U3+7dWj5Nt+SzNdn+qu1nU7qBl17ZftYleV1VrZvjPi+lO4u5F/jUJMs/WlWT3SN5ebrBmg4E/riq7pljO7QT8wxFC8l3Bq7hn1JVjw2WAz9G11HjyVNv4ik+BfwZ275EtYUnegAetzswcdyH8W7JZ3Lp7Gs80Vv1NveXbpTP+8fnq+rRqvrHqvovdIMwbauD05uAQ1q3LuPbexpwSFs2vs3H6M6YfotukK+ZurIN1vSTwElJ7INMUzJQtGhU1SPA24HfapfFZuLv6Hp5/dw26vwz8EtJdgdI8svADYOXkZqpuiWfzIeB303y/LbNp+WJIVS/ALwhydPb/FuA8SFcD0vXVfl4MBxM1/vwpKpqjK7H4/cMFL8HuK4tG/QR4N1V9a0ZtH/ifm4HTgfePdt1tXR4yUuLSlVdn2QD3aWnK2n3UAaqfKwNjTpe/2Hgg7B1QLbJtrmhPUL7xSRFN6rdr01Sb6puyafa5jvouq1/Ft0lrc+0ZZ9J8lPAtUkeB77OE0+0PRf4i3Q9FAN8me5psW05Cfgf6UYihe7BhZMmadPXeOrTXeN+M8kJA/OTnRX9OfCuJKva02XSk9g5pCSpF17ykiT1wkte0hwkeStw6oTif6mq2Tw4IO0UvOQlSeqFl7wkSb0wUCRJvTBQJEm9MFAkSb34/5nC9pLr5KULAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5vyyO8J-gI6j",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 254
        },
        "outputId": "1513d0e7-217a-4acf-f49c-21933eadc4af"
      },
      "source": [
        "product_names = merged_data['PROD_NAME']\n",
        "print((product_names)) #-- Labeled Products that are provided\n",
        "print('TOTAL NUMBERS OF PRODUCTS SELLED IN THE STORE {}'.format(product_names.size))"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "0          Natural Chip        Compny SeaSalt175g\n",
            "1                        CCs Nacho Cheese    175g\n",
            "2                  WW Original Stacked Chips 160g\n",
            "3                               CCs Original 175g\n",
            "4          Smiths Crinkle Cut  Chips Chicken 170g\n",
            "                           ...                   \n",
            "264831    Kettle Sweet Chilli And Sour Cream 175g\n",
            "264832              Tostitos Splash Of  Lime 175g\n",
            "264833                   Doritos Mexicana    170g\n",
            "264834    Doritos Corn Chip Mexican Jalapeno 150g\n",
            "264835              Tostitos Splash Of  Lime 175g\n",
            "Name: PROD_NAME, Length: 264836, dtype: object\n",
            "TOTAL NUMBERS OF PRODUCTS SELLED IN THE STORE 264836\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "N7oNLKSDiNhx",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 228
        },
        "outputId": "4212346c-8ad8-49bc-8ae4-86daf12105a6"
      },
      "source": [
        "#analysis of the dataset is being done \n",
        "young_singles = merged_data[(merged_data['LIFESTAGE']=='YOUNG SINGLES/COUPLES') & (merged_data['PREMIUM_CUSTOMER']=='Premium')]\n",
        "young_singles.head(6)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>STORE_NBR</th>\n",
              "      <th>LYLTY_CARD_NBR</th>\n",
              "      <th>TXN_ID</th>\n",
              "      <th>PROD_NBR</th>\n",
              "      <th>PROD_NAME</th>\n",
              "      <th>PROD_QTY</th>\n",
              "      <th>TOT_SALES</th>\n",
              "      <th>LIFESTAGE</th>\n",
              "      <th>PREMIUM_CUSTOMER</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1000</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>Natural Chip        Compny SeaSalt175g</td>\n",
              "      <td>2</td>\n",
              "      <td>6.0</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>258556</th>\n",
              "      <td>77</td>\n",
              "      <td>77373</td>\n",
              "      <td>75311</td>\n",
              "      <td>40</td>\n",
              "      <td>Thins Chips Seasonedchicken 175g</td>\n",
              "      <td>2</td>\n",
              "      <td>6.6</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>258557</th>\n",
              "      <td>77</td>\n",
              "      <td>77373</td>\n",
              "      <td>75310</td>\n",
              "      <td>107</td>\n",
              "      <td>Smiths Crinkle Cut  French OnionDip 150g</td>\n",
              "      <td>1</td>\n",
              "      <td>2.6</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>258558</th>\n",
              "      <td>1</td>\n",
              "      <td>1289</td>\n",
              "      <td>329</td>\n",
              "      <td>96</td>\n",
              "      <td>WW Original Stacked Chips 160g</td>\n",
              "      <td>4</td>\n",
              "      <td>7.6</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>258559</th>\n",
              "      <td>1</td>\n",
              "      <td>1460</td>\n",
              "      <td>539</td>\n",
              "      <td>19</td>\n",
              "      <td>Smiths Crinkle Cut  Snag&amp;Sauce 150g</td>\n",
              "      <td>4</td>\n",
              "      <td>10.4</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>258560</th>\n",
              "      <td>1</td>\n",
              "      <td>1460</td>\n",
              "      <td>540</td>\n",
              "      <td>80</td>\n",
              "      <td>Natural ChipCo Sea  Salt &amp; Vinegr 175g</td>\n",
              "      <td>2</td>\n",
              "      <td>6.0</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        STORE_NBR  LYLTY_CARD_NBR  ...              LIFESTAGE  PREMIUM_CUSTOMER\n",
              "0               1            1000  ...  YOUNG SINGLES/COUPLES           Premium\n",
              "258556         77           77373  ...  YOUNG SINGLES/COUPLES           Premium\n",
              "258557         77           77373  ...  YOUNG SINGLES/COUPLES           Premium\n",
              "258558          1            1289  ...  YOUNG SINGLES/COUPLES           Premium\n",
              "258559          1            1460  ...  YOUNG SINGLES/COUPLES           Premium\n",
              "258560          1            1460  ...  YOUNG SINGLES/COUPLES           Premium\n",
              "\n",
              "[6 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "BZZ8XinRjwDP",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 407
        },
        "outputId": "d6f91b29-c1a5-4e34-cd1f-eb574e515340"
      },
      "source": [
        "#studying sales \n",
        "Total_Sales  = merged_data[(merged_data['TOT_SALES']>=6.0) & (merged_data['PREMIUM_CUSTOMER']=='Budget')]\n",
        "Total_Sales"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>STORE_NBR</th>\n",
              "      <th>LYLTY_CARD_NBR</th>\n",
              "      <th>TXN_ID</th>\n",
              "      <th>PROD_NBR</th>\n",
              "      <th>PROD_NAME</th>\n",
              "      <th>PROD_QTY</th>\n",
              "      <th>TOT_SALES</th>\n",
              "      <th>LIFESTAGE</th>\n",
              "      <th>PREMIUM_CUSTOMER</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>1307</td>\n",
              "      <td>348</td>\n",
              "      <td>66</td>\n",
              "      <td>CCs Nacho Cheese    175g</td>\n",
              "      <td>3</td>\n",
              "      <td>6.3</td>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>2</td>\n",
              "      <td>2373</td>\n",
              "      <td>974</td>\n",
              "      <td>69</td>\n",
              "      <td>Smiths Chip Thinly  S/Cream&amp;Onion 175g</td>\n",
              "      <td>5</td>\n",
              "      <td>15.0</td>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>2</td>\n",
              "      <td>2426</td>\n",
              "      <td>1038</td>\n",
              "      <td>108</td>\n",
              "      <td>Kettle Tortilla ChpsHny&amp;Jlpno Chili 150g</td>\n",
              "      <td>3</td>\n",
              "      <td>13.8</td>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>4</td>\n",
              "      <td>4074</td>\n",
              "      <td>2978</td>\n",
              "      <td>70</td>\n",
              "      <td>Tyrrells Crisps     Lightly Salted 165g</td>\n",
              "      <td>2</td>\n",
              "      <td>8.4</td>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>4</td>\n",
              "      <td>4074</td>\n",
              "      <td>2979</td>\n",
              "      <td>60</td>\n",
              "      <td>Kettle Tortilla ChpsFeta&amp;Garlic 150g</td>\n",
              "      <td>2</td>\n",
              "      <td>9.2</td>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>237697</th>\n",
              "      <td>272</td>\n",
              "      <td>272310</td>\n",
              "      <td>270079</td>\n",
              "      <td>40</td>\n",
              "      <td>Thins Chips Seasonedchicken 175g</td>\n",
              "      <td>2</td>\n",
              "      <td>6.6</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>237698</th>\n",
              "      <td>272</td>\n",
              "      <td>272329</td>\n",
              "      <td>270105</td>\n",
              "      <td>65</td>\n",
              "      <td>Old El Paso Salsa   Dip Chnky Tom Ht300g</td>\n",
              "      <td>2</td>\n",
              "      <td>10.2</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>237699</th>\n",
              "      <td>272</td>\n",
              "      <td>272329</td>\n",
              "      <td>270106</td>\n",
              "      <td>17</td>\n",
              "      <td>Kettle Sensations   BBQ&amp;Maple 150g</td>\n",
              "      <td>2</td>\n",
              "      <td>9.2</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>237700</th>\n",
              "      <td>272</td>\n",
              "      <td>272336</td>\n",
              "      <td>270113</td>\n",
              "      <td>42</td>\n",
              "      <td>Doritos Corn Chip Mexican Jalapeno 150g</td>\n",
              "      <td>2</td>\n",
              "      <td>7.8</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>237701</th>\n",
              "      <td>272</td>\n",
              "      <td>272336</td>\n",
              "      <td>270114</td>\n",
              "      <td>63</td>\n",
              "      <td>Kettle 135g Swt Pot Sea Salt</td>\n",
              "      <td>2</td>\n",
              "      <td>8.4</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>65597 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        STORE_NBR  LYLTY_CARD_NBR  ...               LIFESTAGE  PREMIUM_CUSTOMER\n",
              "1               1            1307  ...  MIDAGE SINGLES/COUPLES            Budget\n",
              "5               2            2373  ...  MIDAGE SINGLES/COUPLES            Budget\n",
              "6               2            2426  ...  MIDAGE SINGLES/COUPLES            Budget\n",
              "8               4            4074  ...  MIDAGE SINGLES/COUPLES            Budget\n",
              "9               4            4074  ...  MIDAGE SINGLES/COUPLES            Budget\n",
              "...           ...             ...  ...                     ...               ...\n",
              "237697        272          272310  ...   YOUNG SINGLES/COUPLES            Budget\n",
              "237698        272          272329  ...   YOUNG SINGLES/COUPLES            Budget\n",
              "237699        272          272329  ...   YOUNG SINGLES/COUPLES            Budget\n",
              "237700        272          272336  ...   YOUNG SINGLES/COUPLES            Budget\n",
              "237701        272          272336  ...   YOUNG SINGLES/COUPLES            Budget\n",
              "\n",
              "[65597 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZdEZFwPcoTbR",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 391
        },
        "outputId": "875156ba-41ac-4d90-ece7-8e4cda7a5e85"
      },
      "source": [
        "#TOTAL NUMBER'S OF SALES MADE BY THE SYSTEM IS  ----- 1934414\n",
        "print(\"TOTAL NUMBER'S OF SALE'S MADE BY THE SYSTEM IS {}\".format(int(merged_data['TOT_SALES'].sum())))\n",
        "max_sales = merged_data['TOT_SALES'].max()\n",
        "print('MAXIMUM SALES MADE BY THE STORE/SYSTEM IS -- {} $'.format(max_sales))\n",
        "min_sales = merged_data['TOT_SALES'].min()\n",
        "print(\"MINIMUM SALES MADE BY THE STORE/SYSTEM IS -- {} $ \".format(min_sales))\n",
        "print(merged_data['TOT_SALES'].idxmax())\n",
        "merged_data.iloc[71450:71459]"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "TOTAL NUMBER'S OF SALE'S MADE BY THE SYSTEM IS 1934414\n",
            "MAXIMUM SALES MADE BY THE STORE/SYSTEM IS -- 650.0 $\n",
            "MINIMUM SALES MADE BY THE STORE/SYSTEM IS -- 1.5 $ \n",
            "71456\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "execute_result",
          "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>STORE_NBR</th>\n",
              "      <th>LYLTY_CARD_NBR</th>\n",
              "      <th>TXN_ID</th>\n",
              "      <th>PROD_NBR</th>\n",
              "      <th>PROD_NAME</th>\n",
              "      <th>PROD_QTY</th>\n",
              "      <th>TOT_SALES</th>\n",
              "      <th>LIFESTAGE</th>\n",
              "      <th>PREMIUM_CUSTOMER</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>71450</th>\n",
              "      <td>225</td>\n",
              "      <td>225119</td>\n",
              "      <td>225386</td>\n",
              "      <td>87</td>\n",
              "      <td>Infuzions BBQ Rib   Prawn Crackers 110g</td>\n",
              "      <td>2</td>\n",
              "      <td>7.6</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71451</th>\n",
              "      <td>225</td>\n",
              "      <td>225119</td>\n",
              "      <td>225388</td>\n",
              "      <td>98</td>\n",
              "      <td>NCC Sour Cream &amp;    Garden Chives 175g</td>\n",
              "      <td>2</td>\n",
              "      <td>6.0</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71452</th>\n",
              "      <td>225</td>\n",
              "      <td>225119</td>\n",
              "      <td>225389</td>\n",
              "      <td>62</td>\n",
              "      <td>Pringles Mystery    Flavour 134g</td>\n",
              "      <td>2</td>\n",
              "      <td>7.4</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71453</th>\n",
              "      <td>225</td>\n",
              "      <td>225119</td>\n",
              "      <td>225390</td>\n",
              "      <td>47</td>\n",
              "      <td>Doritos Corn Chips  Original 170g</td>\n",
              "      <td>2</td>\n",
              "      <td>8.8</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71454</th>\n",
              "      <td>225</td>\n",
              "      <td>225119</td>\n",
              "      <td>225391</td>\n",
              "      <td>46</td>\n",
              "      <td>Kettle Original 175g</td>\n",
              "      <td>2</td>\n",
              "      <td>10.8</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71455</th>\n",
              "      <td>225</td>\n",
              "      <td>225119</td>\n",
              "      <td>225392</td>\n",
              "      <td>67</td>\n",
              "      <td>RRD Chilli&amp;         Coconut 150g</td>\n",
              "      <td>2</td>\n",
              "      <td>5.4</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71456</th>\n",
              "      <td>226</td>\n",
              "      <td>226000</td>\n",
              "      <td>226201</td>\n",
              "      <td>4</td>\n",
              "      <td>Dorito Corn Chp     Supreme 380g</td>\n",
              "      <td>200</td>\n",
              "      <td>650.0</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71457</th>\n",
              "      <td>226</td>\n",
              "      <td>226000</td>\n",
              "      <td>226210</td>\n",
              "      <td>4</td>\n",
              "      <td>Dorito Corn Chp     Supreme 380g</td>\n",
              "      <td>200</td>\n",
              "      <td>650.0</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71458</th>\n",
              "      <td>226</td>\n",
              "      <td>226101</td>\n",
              "      <td>226747</td>\n",
              "      <td>77</td>\n",
              "      <td>Doritos Corn Chips  Nacho Cheese 170g</td>\n",
              "      <td>1</td>\n",
              "      <td>4.4</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       STORE_NBR  LYLTY_CARD_NBR  ...       LIFESTAGE  PREMIUM_CUSTOMER\n",
              "71450        225          225119  ...  OLDER FAMILIES           Premium\n",
              "71451        225          225119  ...  OLDER FAMILIES           Premium\n",
              "71452        225          225119  ...  OLDER FAMILIES           Premium\n",
              "71453        225          225119  ...  OLDER FAMILIES           Premium\n",
              "71454        225          225119  ...  OLDER FAMILIES           Premium\n",
              "71455        225          225119  ...  OLDER FAMILIES           Premium\n",
              "71456        226          226000  ...  OLDER FAMILIES           Premium\n",
              "71457        226          226000  ...  OLDER FAMILIES           Premium\n",
              "71458        226          226101  ...  OLDER FAMILIES           Premium\n",
              "\n",
              "[9 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rHaNhHKjrRHU",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 198
        },
        "outputId": "c0af93fd-e8f0-4be8-8916-5ed0dd13b760"
      },
      "source": [
        "lifestages = merged_data.sort_values('PROD_QTY',ascending=False).groupby('LIFESTAGE').head(3)\n",
        "lifestages.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>STORE_NBR</th>\n",
              "      <th>LYLTY_CARD_NBR</th>\n",
              "      <th>TXN_ID</th>\n",
              "      <th>PROD_NBR</th>\n",
              "      <th>PROD_NAME</th>\n",
              "      <th>PROD_QTY</th>\n",
              "      <th>TOT_SALES</th>\n",
              "      <th>LIFESTAGE</th>\n",
              "      <th>PREMIUM_CUSTOMER</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>71456</th>\n",
              "      <td>226</td>\n",
              "      <td>226000</td>\n",
              "      <td>226201</td>\n",
              "      <td>4</td>\n",
              "      <td>Dorito Corn Chp     Supreme 380g</td>\n",
              "      <td>200</td>\n",
              "      <td>650.00</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71457</th>\n",
              "      <td>226</td>\n",
              "      <td>226000</td>\n",
              "      <td>226210</td>\n",
              "      <td>4</td>\n",
              "      <td>Dorito Corn Chp     Supreme 380g</td>\n",
              "      <td>200</td>\n",
              "      <td>650.00</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34105</th>\n",
              "      <td>97</td>\n",
              "      <td>97211</td>\n",
              "      <td>97600</td>\n",
              "      <td>11</td>\n",
              "      <td>RRD Pc Sea Salt     165g</td>\n",
              "      <td>5</td>\n",
              "      <td>15.00</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>102451</th>\n",
              "      <td>235</td>\n",
              "      <td>235164</td>\n",
              "      <td>238117</td>\n",
              "      <td>4</td>\n",
              "      <td>Dorito Corn Chp     Supreme 380g</td>\n",
              "      <td>5</td>\n",
              "      <td>16.25</td>\n",
              "      <td>OLDER SINGLES/COUPLES</td>\n",
              "      <td>Mainstream</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>259068</th>\n",
              "      <td>183</td>\n",
              "      <td>183032</td>\n",
              "      <td>184969</td>\n",
              "      <td>21</td>\n",
              "      <td>WW Sour Cream &amp;OnionStacked Chips 160g</td>\n",
              "      <td>5</td>\n",
              "      <td>9.50</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Premium</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        STORE_NBR  LYLTY_CARD_NBR  ...              LIFESTAGE  PREMIUM_CUSTOMER\n",
              "71456         226          226000  ...         OLDER FAMILIES           Premium\n",
              "71457         226          226000  ...         OLDER FAMILIES           Premium\n",
              "34105          97           97211  ...         OLDER FAMILIES            Budget\n",
              "102451        235          235164  ...  OLDER SINGLES/COUPLES        Mainstream\n",
              "259068        183          183032  ...  YOUNG SINGLES/COUPLES           Premium\n",
              "\n",
              "[5 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "woObov9NrB1h",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "outputId": "892e104f-e797-412b-e641-fbe84e49fd90"
      },
      "source": [
        "merged_data = merged_data[merged_data['PROD_QTY']>2]\n",
        "merged_data.head()\n",
        "merged_data.shape\n",
        "#TOTAL NUMBER OF ENTERIES WHERE PROD_QTY IS MORE THAN 3"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(1279, 9)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "2YvmWzmzsOiK",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 290
        },
        "outputId": "dc89b221-87ca-4736-a30f-e0311686a362"
      },
      "source": [
        "prod_nbr = Total_Sales['PROD_NBR']\n",
        "print(prod_nbr.duplicated(keep=False))\n",
        "print(\"\\n\\n\\tTOTAL NUMBER OF PRODUCTS REMOVING THE DUPLICATES ARE ---- {}\".format(prod_nbr.size))"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "1         True\n",
            "5         True\n",
            "6         True\n",
            "8         True\n",
            "9         True\n",
            "          ... \n",
            "237697    True\n",
            "237698    True\n",
            "237699    True\n",
            "237700    True\n",
            "237701    True\n",
            "Name: PROD_NBR, Length: 65597, dtype: bool\n",
            "\n",
            "\n",
            "\tTOTAL NUMBER OF PRODUCTS REMOVING THE DUPLICATES ARE ---- 65597\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KHF6y-vhs0pC",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 407
        },
        "outputId": "42c6cc49-4bb0-4917-870c-371511ae6b82"
      },
      "source": [
        "data_point = merged_data[(merged_data['PREMIUM_CUSTOMER']=='Budget') & (merged_data['TOT_SALES']>20)]\n",
        "data_point"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>STORE_NBR</th>\n",
              "      <th>LYLTY_CARD_NBR</th>\n",
              "      <th>TXN_ID</th>\n",
              "      <th>PROD_NBR</th>\n",
              "      <th>PROD_NAME</th>\n",
              "      <th>PROD_QTY</th>\n",
              "      <th>TOT_SALES</th>\n",
              "      <th>LIFESTAGE</th>\n",
              "      <th>PREMIUM_CUSTOMER</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>8</td>\n",
              "      <td>8294</td>\n",
              "      <td>8221</td>\n",
              "      <td>114</td>\n",
              "      <td>Kettle Sensations   Siracha Lime 150g</td>\n",
              "      <td>5</td>\n",
              "      <td>23.0</td>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>315</th>\n",
              "      <td>96</td>\n",
              "      <td>96203</td>\n",
              "      <td>96025</td>\n",
              "      <td>7</td>\n",
              "      <td>Smiths Crinkle      Original 330g</td>\n",
              "      <td>5</td>\n",
              "      <td>28.5</td>\n",
              "      <td>MIDAGE SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25141</th>\n",
              "      <td>19</td>\n",
              "      <td>19186</td>\n",
              "      <td>16424</td>\n",
              "      <td>15</td>\n",
              "      <td>Twisties Cheese     270g</td>\n",
              "      <td>5</td>\n",
              "      <td>23.0</td>\n",
              "      <td>NEW FAMILIES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25188</th>\n",
              "      <td>49</td>\n",
              "      <td>49360</td>\n",
              "      <td>45992</td>\n",
              "      <td>46</td>\n",
              "      <td>Kettle Original 175g</td>\n",
              "      <td>5</td>\n",
              "      <td>27.0</td>\n",
              "      <td>NEW FAMILIES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32423</th>\n",
              "      <td>27</td>\n",
              "      <td>27179</td>\n",
              "      <td>24216</td>\n",
              "      <td>20</td>\n",
              "      <td>Doritos Cheese      Supreme 330g</td>\n",
              "      <td>4</td>\n",
              "      <td>22.8</td>\n",
              "      <td>OLDER FAMILIES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>188305</th>\n",
              "      <td>227</td>\n",
              "      <td>227174</td>\n",
              "      <td>229329</td>\n",
              "      <td>17</td>\n",
              "      <td>Kettle Sensations   BBQ&amp;Maple 150g</td>\n",
              "      <td>5</td>\n",
              "      <td>23.0</td>\n",
              "      <td>YOUNG FAMILIES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>188556</th>\n",
              "      <td>240</td>\n",
              "      <td>240096</td>\n",
              "      <td>244141</td>\n",
              "      <td>59</td>\n",
              "      <td>Old El Paso Salsa   Dip Tomato Med 300g</td>\n",
              "      <td>4</td>\n",
              "      <td>20.4</td>\n",
              "      <td>YOUNG FAMILIES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>188876</th>\n",
              "      <td>270</td>\n",
              "      <td>270127</td>\n",
              "      <td>267461</td>\n",
              "      <td>46</td>\n",
              "      <td>Kettle Original 175g</td>\n",
              "      <td>5</td>\n",
              "      <td>27.0</td>\n",
              "      <td>YOUNG FAMILIES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>228636</th>\n",
              "      <td>36</td>\n",
              "      <td>36221</td>\n",
              "      <td>32861</td>\n",
              "      <td>88</td>\n",
              "      <td>Kettle Honey Soy    Chicken 175g</td>\n",
              "      <td>5</td>\n",
              "      <td>27.0</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>228825</th>\n",
              "      <td>79</td>\n",
              "      <td>79169</td>\n",
              "      <td>77499</td>\n",
              "      <td>108</td>\n",
              "      <td>Kettle Tortilla ChpsHny&amp;Jlpno Chili 150g</td>\n",
              "      <td>5</td>\n",
              "      <td>23.0</td>\n",
              "      <td>YOUNG SINGLES/COUPLES</td>\n",
              "      <td>Budget</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>86 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        STORE_NBR  LYLTY_CARD_NBR  ...               LIFESTAGE  PREMIUM_CUSTOMER\n",
              "37              8            8294  ...  MIDAGE SINGLES/COUPLES            Budget\n",
              "315            96           96203  ...  MIDAGE SINGLES/COUPLES            Budget\n",
              "25141          19           19186  ...            NEW FAMILIES            Budget\n",
              "25188          49           49360  ...            NEW FAMILIES            Budget\n",
              "32423          27           27179  ...          OLDER FAMILIES            Budget\n",
              "...           ...             ...  ...                     ...               ...\n",
              "188305        227          227174  ...          YOUNG FAMILIES            Budget\n",
              "188556        240          240096  ...          YOUNG FAMILIES            Budget\n",
              "188876        270          270127  ...          YOUNG FAMILIES            Budget\n",
              "228636         36           36221  ...   YOUNG SINGLES/COUPLES            Budget\n",
              "228825         79           79169  ...   YOUNG SINGLES/COUPLES            Budget\n",
              "\n",
              "[86 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "m2kz7gg0yO-6",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ptJrfK62yhcs",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}