0_5_Overview_of_Subsetting_in_Pandas.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/kopiladevkota/Python/blob/main/0_5_Overview_of_Subsetting_in_Pandas.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Tp7sihlhfWhz"
      },
      "source": [
        "---\n",
        "---\n",
        "\n",
        "<center><h1>📍 📍 Overview of Subsetting in Pandas 📍 📍</h1></center>\n",
        "\n",
        "\n",
        "\n",
        "---\n",
        "\n",
        "#### `TABLE OF CONTENTS`\n",
        "\n",
        "- What is an index?\n",
        "- How to subset first N rows based on their position index?\n",
        "- Can we change the index?\n",
        "- Will the index be always numeric?\n",
        "- How to subset the data based on a label of the index?\n",
        "- Can we reset the index?\n",
        "- How to subset the data based on a value of a column?\n",
        "\n",
        "---\n",
        "\n",
        "\n",
        "#### `READ THE DATA`\n",
        "\n",
        "- In this notebook, we are going to use the big mart sales data that we have used previously. It is stored in the folder name `datasets`.\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "GNzgL1OUfWh2"
      },
      "outputs": [],
      "source": [
        "# import the pandas library\n",
        "import pandas as pd"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "TfYYrQk3fWh9"
      },
      "outputs": [],
      "source": [
        "# read the big mart sales data\n",
        "data = pd.read_csv('datasets/big_mart_sales.csv')"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "YPSFrdFsfWiK"
      },
      "source": [
        "#### `WHAT IS INDEX?`\n",
        "\n",
        "![](index.png)\n",
        "\n",
        "-  You can see the index object by `DataFrame.index`."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "cU4EzMq6fWiM",
        "outputId": "6d2b0fde-9318-42a8-b452-9219ec73b1c6"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "RangeIndex(start=0, stop=8523, step=1)"
            ]
          },
          "execution_count": 6,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# index of the dataframe\n",
        "data.index"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Z6GJTK5WynnJ"
      },
      "source": [
        "***So, In this case, we have the numeric index value start from the 0 and ends at 8523.***\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "cpGWKUdHynnJ",
        "outputId": "34cbf48d-5725-4d05-8add-9e2e22e6b365"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "(8523, 12)"
            ]
          },
          "execution_count": 5,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# no. of rows and columns in the data\n",
        "data.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Rc0XklWtynnK",
        "outputId": "0bd01b3c-8022-4d6a-ffdc-30ede386e685"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "Index(['Item_Identifier', 'Item_Weight', 'Item_Fat_Content', 'Item_Visibility',\n",
              "       'Item_Type', 'Item_MRP', 'Outlet_Identifier',\n",
              "       'Outlet_Establishment_Year', 'Outlet_Size', 'Outlet_Location_Type',\n",
              "       'Outlet_Type', 'Item_Outlet_Sales'],\n",
              "      dtype='object')"
            ]
          },
          "execution_count": 11,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# column index\n",
        "data.columns"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "__jreZ4pynnK"
      },
      "source": [
        "#### `HOW TO SUBSET FIRST 'N' ROWS BASED ON THEIR POSITION INDEX?`\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "u7xKfup_fWiD",
        "outputId": "6033cae3-01df-4531-d357-988d4eca3b52"
      },
      "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>Item_Identifier</th>\n",
              "      <th>Item_Weight</th>\n",
              "      <th>Item_Fat_Content</th>\n",
              "      <th>Item_Visibility</th>\n",
              "      <th>Item_Type</th>\n",
              "      <th>Item_MRP</th>\n",
              "      <th>Outlet_Identifier</th>\n",
              "      <th>Outlet_Establishment_Year</th>\n",
              "      <th>Outlet_Size</th>\n",
              "      <th>Outlet_Location_Type</th>\n",
              "      <th>Outlet_Type</th>\n",
              "      <th>Item_Outlet_Sales</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <td>0</td>\n",
              "      <td>FDA15</td>\n",
              "      <td>9.30</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016047</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>249.8092</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>1999</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>3735.1380</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>1</td>\n",
              "      <td>DRC01</td>\n",
              "      <td>5.92</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.019278</td>\n",
              "      <td>Soft Drinks</td>\n",
              "      <td>48.2692</td>\n",
              "      <td>OUT018</td>\n",
              "      <td>2009</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type2</td>\n",
              "      <td>443.4228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>2</td>\n",
              "      <td>FDN15</td>\n",
              "      <td>17.50</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016760</td>\n",
              "      <td>Meat</td>\n",
              "      <td>141.6180</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>1999</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>2097.2700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>3</td>\n",
              "      <td>FDX07</td>\n",
              "      <td>19.20</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Fruits and Vegetables</td>\n",
              "      <td>182.0950</td>\n",
              "      <td>OUT010</td>\n",
              "      <td>1998</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Grocery Store</td>\n",
              "      <td>732.3800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>4</td>\n",
              "      <td>NCD19</td>\n",
              "      <td>8.93</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Household</td>\n",
              "      <td>53.8614</td>\n",
              "      <td>OUT013</td>\n",
              "      <td>1987</td>\n",
              "      <td>High</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>994.7052</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  Item_Identifier  Item_Weight Item_Fat_Content  Item_Visibility  \\\n",
              "0           FDA15         9.30          Low Fat         0.016047   \n",
              "1           DRC01         5.92          Regular         0.019278   \n",
              "2           FDN15        17.50          Low Fat         0.016760   \n",
              "3           FDX07        19.20          Regular         0.000000   \n",
              "4           NCD19         8.93          Low Fat         0.000000   \n",
              "\n",
              "               Item_Type  Item_MRP Outlet_Identifier  \\\n",
              "0                  Dairy  249.8092            OUT049   \n",
              "1            Soft Drinks   48.2692            OUT018   \n",
              "2                   Meat  141.6180            OUT049   \n",
              "3  Fruits and Vegetables  182.0950            OUT010   \n",
              "4              Household   53.8614            OUT013   \n",
              "\n",
              "   Outlet_Establishment_Year Outlet_Size Outlet_Location_Type  \\\n",
              "0                       1999      Medium               Tier 1   \n",
              "1                       2009      Medium               Tier 3   \n",
              "2                       1999      Medium               Tier 1   \n",
              "3                       1998         NaN               Tier 3   \n",
              "4                       1987        High               Tier 3   \n",
              "\n",
              "         Outlet_Type  Item_Outlet_Sales  \n",
              "0  Supermarket Type1          3735.1380  \n",
              "1  Supermarket Type2           443.4228  \n",
              "2  Supermarket Type1          2097.2700  \n",
              "3      Grocery Store           732.3800  \n",
              "4  Supermarket Type1           994.7052  "
            ]
          },
          "execution_count": 4,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# view the top rows of the data\n",
        "data.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "5LCJsNZdfWiR"
      },
      "source": [
        "---\n",
        "\n",
        "#### `CAN WE CHANGE THE INDEX?`\n",
        "\n",
        "---\n",
        "\n",
        "***The answer is `Yes`. We can change the index. Let's see how?***\n",
        "\n",
        "---"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "TIuqwsEsfWiT"
      },
      "source": [
        "#### Create a random list of 8523 numbers and set it as the index\n",
        "---"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "XG8pFSWrfWiV"
      },
      "outputs": [],
      "source": [
        "# create random list\n",
        "import random\n",
        "random_list = [random.randint(1, 8523) for i in range(8523)]\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "yKudIDRgynnK",
        "outputId": "07bc1d58-ab19-4e95-f3a6-bd9891d946f1"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "[4333,\n",
              " 7000,\n",
              " 5232,\n",
              " 594,\n",
              " 3804,\n",
              " 8379,\n",
              " 1082,\n",
              " 1692,\n",
              " 3619,\n",
              " 1221,\n",
              " 1648,\n",
              " 411,\n",
              " 5784,\n",
              " 4393,\n",
              " 2508,\n",
              " 3838,\n",
              " 7774,\n",
              " 6119,\n",
              " 4274,\n",
              " 959,\n",
              " 5002,\n",
              " 175,\n",
              " 4129,\n",
              " 2874,\n",
              " 735,\n",
              " 8214,\n",
              " 3790,\n",
              " 4001,\n",
              " 1619,\n",
              " 587,\n",
              " 6241,\n",
              " 8175,\n",
              " 3936,\n",
              " 707,\n",
              " 8448,\n",
              " 4959,\n",
              " 7196,\n",
              " 4769,\n",
              " 3185,\n",
              " 8107,\n",
              " 885,\n",
              " 4643,\n",
              " 7950,\n",
              " 8106,\n",
              " 652,\n",
              " 7615,\n",
              " 5992,\n",
              " 32,\n",
              " 2234,\n",
              " 2629,\n",
              " 5066,\n",
              " 1179,\n",
              " 4643,\n",
              " 971,\n",
              " 8183,\n",
              " 2457,\n",
              " 7761,\n",
              " 5543,\n",
              " 7170,\n",
              " 2372,\n",
              " 6692,\n",
              " 8452,\n",
              " 5168,\n",
              " 5065,\n",
              " 9,\n",
              " 3997,\n",
              " 8142,\n",
              " 986,\n",
              " 1814,\n",
              " 7913,\n",
              " 7308,\n",
              " 6346,\n",
              " 1188,\n",
              " 687,\n",
              " 3869,\n",
              " 5375,\n",
              " 7888,\n",
              " 2069,\n",
              " 260,\n",
              " 6094,\n",
              " 3089,\n",
              " 8070,\n",
              " 7998,\n",
              " 947,\n",
              " 7619,\n",
              " 3112,\n",
              " 3053,\n",
              " 1304,\n",
              " 6546,\n",
              " 2706,\n",
              " 5403,\n",
              " 3553,\n",
              " 826,\n",
              " 1891,\n",
              " 6974,\n",
              " 1696,\n",
              " 7180,\n",
              " 1874,\n",
              " 7365,\n",
              " 404,\n",
              " 847,\n",
              " 1118,\n",
              " 5922,\n",
              " 2319,\n",
              " 609,\n",
              " 7913,\n",
              " 2322,\n",
              " 8079,\n",
              " 1206,\n",
              " 2205,\n",
              " 2029,\n",
              " 3554,\n",
              " 7089,\n",
              " 4048,\n",
              " 4814,\n",
              " 4654,\n",
              " 7879,\n",
              " 2746,\n",
              " 2798,\n",
              " 2421,\n",
              " 6159,\n",
              " 5626,\n",
              " 7234,\n",
              " 7270,\n",
              " 3443,\n",
              " 7274,\n",
              " 4023,\n",
              " 3255,\n",
              " 3782,\n",
              " 3678,\n",
              " 7488,\n",
              " 3204,\n",
              " 2399,\n",
              " 2385,\n",
              " 3648,\n",
              " 4739,\n",
              " 8387,\n",
              " 1255,\n",
              " 7859,\n",
              " 261,\n",
              " 4796,\n",
              " 4583,\n",
              " 8179,\n",
              " 7803,\n",
              " 2772,\n",
              " 8064,\n",
              " 8144,\n",
              " 5099,\n",
              " 3427,\n",
              " 275,\n",
              " 3250,\n",
              " 3580,\n",
              " 4748,\n",
              " 310,\n",
              " 8048,\n",
              " 4181,\n",
              " 7104,\n",
              " 567,\n",
              " 7539,\n",
              " 309,\n",
              " 6035,\n",
              " 7105,\n",
              " 1229,\n",
              " 2188,\n",
              " 8238,\n",
              " 1458,\n",
              " 2755,\n",
              " 6185,\n",
              " 616,\n",
              " 3166,\n",
              " 6123,\n",
              " 5447,\n",
              " 4085,\n",
              " 834,\n",
              " 7453,\n",
              " 4501,\n",
              " 2043,\n",
              " 5474,\n",
              " 789,\n",
              " 6158,\n",
              " 3564,\n",
              " 5777,\n",
              " 6414,\n",
              " 7629,\n",
              " 2294,\n",
              " 3862,\n",
              " 5726,\n",
              " 4416,\n",
              " 7145,\n",
              " 4634,\n",
              " 1757,\n",
              " 2059,\n",
              " 5433,\n",
              " 6553,\n",
              " 6182,\n",
              " 5348,\n",
              " 4833,\n",
              " 5180,\n",
              " 6242,\n",
              " 2412,\n",
              " 6500,\n",
              " 4336,\n",
              " 5520,\n",
              " 2055,\n",
              " 2935,\n",
              " 2260,\n",
              " 6422,\n",
              " 902,\n",
              " 8114,\n",
              " 1821,\n",
              " 976,\n",
              " 5609,\n",
              " 8075,\n",
              " 4727,\n",
              " 1820,\n",
              " 6113,\n",
              " 6488,\n",
              " 1996,\n",
              " 884,\n",
              " 4287,\n",
              " 3365,\n",
              " 1979,\n",
              " 7456,\n",
              " 7495,\n",
              " 8152,\n",
              " 6396,\n",
              " 7428,\n",
              " 7460,\n",
              " 5672,\n",
              " 6492,\n",
              " 3514,\n",
              " 4212,\n",
              " 3124,\n",
              " 3172,\n",
              " 7636,\n",
              " 7733,\n",
              " 3914,\n",
              " 2218,\n",
              " 5061,\n",
              " 7421,\n",
              " 3851,\n",
              " 2831,\n",
              " 3438,\n",
              " 7283,\n",
              " 1736,\n",
              " 4968,\n",
              " 1310,\n",
              " 359,\n",
              " 2734,\n",
              " 1447,\n",
              " 5649,\n",
              " 745,\n",
              " 2872,\n",
              " 7995,\n",
              " 1503,\n",
              " 6775,\n",
              " 5786,\n",
              " 6679,\n",
              " 5968,\n",
              " 6710,\n",
              " 2276,\n",
              " 5508,\n",
              " 5934,\n",
              " 8364,\n",
              " 5173,\n",
              " 2864,\n",
              " 3582,\n",
              " 1287,\n",
              " 6440,\n",
              " 6494,\n",
              " 1626,\n",
              " 2163,\n",
              " 5268,\n",
              " 3094,\n",
              " 3992,\n",
              " 1392,\n",
              " 3373,\n",
              " 191,\n",
              " 59,\n",
              " 7245,\n",
              " 4846,\n",
              " 7742,\n",
              " 5335,\n",
              " 3322,\n",
              " 2316,\n",
              " 1192,\n",
              " 7921,\n",
              " 7720,\n",
              " 342,\n",
              " 6872,\n",
              " 5643,\n",
              " 5548,\n",
              " 5584,\n",
              " 5714,\n",
              " 2105,\n",
              " 5214,\n",
              " 1149,\n",
              " 6620,\n",
              " 5511,\n",
              " 2738,\n",
              " 3537,\n",
              " 7423,\n",
              " 6812,\n",
              " 5574,\n",
              " 61,\n",
              " 2892,\n",
              " 7304,\n",
              " 4446,\n",
              " 4102,\n",
              " 4537,\n",
              " 3759,\n",
              " 7373,\n",
              " 1325,\n",
              " 1005,\n",
              " 7202,\n",
              " 5160,\n",
              " 5937,\n",
              " 4478,\n",
              " 2659,\n",
              " 3256,\n",
              " 4079,\n",
              " 4791,\n",
              " 7849,\n",
              " 1944,\n",
              " 5084,\n",
              " 6597,\n",
              " 8318,\n",
              " 5540,\n",
              " 4518,\n",
              " 7054,\n",
              " 3293,\n",
              " 8184,\n",
              " 206,\n",
              " 2850,\n",
              " 3404,\n",
              " 7821,\n",
              " 1826,\n",
              " 4127,\n",
              " 1065,\n",
              " 6848,\n",
              " 7058,\n",
              " 484,\n",
              " 2974,\n",
              " 639,\n",
              " 5540,\n",
              " 5746,\n",
              " 647,\n",
              " 684,\n",
              " 813,\n",
              " 792,\n",
              " 4623,\n",
              " 6718,\n",
              " 2652,\n",
              " 7066,\n",
              " 8015,\n",
              " 8010,\n",
              " 4465,\n",
              " 1348,\n",
              " 2875,\n",
              " 4175,\n",
              " 5114,\n",
              " 6455,\n",
              " 553,\n",
              " 3735,\n",
              " 451,\n",
              " 7897,\n",
              " 2110,\n",
              " 4576,\n",
              " 5634,\n",
              " 6687,\n",
              " 3638,\n",
              " 6218,\n",
              " 3145,\n",
              " 3993,\n",
              " 6607,\n",
              " 8062,\n",
              " 7518,\n",
              " 6996,\n",
              " 1022,\n",
              " 2684,\n",
              " 1924,\n",
              " 3191,\n",
              " 6425,\n",
              " 37,\n",
              " 2130,\n",
              " 2345,\n",
              " 4767,\n",
              " 4774,\n",
              " 6160,\n",
              " 2838,\n",
              " 5326,\n",
              " 5100,\n",
              " 1058,\n",
              " 4866,\n",
              " 7385,\n",
              " 8506,\n",
              " 3832,\n",
              " 3274,\n",
              " 1060,\n",
              " 6296,\n",
              " 6734,\n",
              " 481,\n",
              " 2522,\n",
              " 384,\n",
              " 6911,\n",
              " 7778,\n",
              " 7836,\n",
              " 3131,\n",
              " 5937,\n",
              " 4800,\n",
              " 1881,\n",
              " 1804,\n",
              " 5605,\n",
              " 484,\n",
              " 6305,\n",
              " 5015,\n",
              " 8086,\n",
              " 3630,\n",
              " 6611,\n",
              " 7702,\n",
              " 6434,\n",
              " 387,\n",
              " 7196,\n",
              " 8094,\n",
              " 7278,\n",
              " 5647,\n",
              " 8036,\n",
              " 5587,\n",
              " 1034,\n",
              " 1878,\n",
              " 5785,\n",
              " 1106,\n",
              " 4863,\n",
              " 6428,\n",
              " 3642,\n",
              " 8361,\n",
              " 6212,\n",
              " 271,\n",
              " 1755,\n",
              " 1888,\n",
              " 7752,\n",
              " 1030,\n",
              " 251,\n",
              " 3705,\n",
              " 2502,\n",
              " 1036,\n",
              " 1088,\n",
              " 539,\n",
              " 227,\n",
              " 4351,\n",
              " 8024,\n",
              " 3466,\n",
              " 634,\n",
              " 3926,\n",
              " 7644,\n",
              " 3260,\n",
              " 6376,\n",
              " 7961,\n",
              " 4174,\n",
              " 7792,\n",
              " 7620,\n",
              " 7566,\n",
              " 2946,\n",
              " 5997,\n",
              " 1984,\n",
              " 8301,\n",
              " 5985,\n",
              " 1397,\n",
              " 854,\n",
              " 4919,\n",
              " 1994,\n",
              " 7536,\n",
              " 2699,\n",
              " 6316,\n",
              " 2497,\n",
              " 6889,\n",
              " 470,\n",
              " 5435,\n",
              " 5721,\n",
              " 2922,\n",
              " 7844,\n",
              " 4308,\n",
              " 221,\n",
              " 3619,\n",
              " 826,\n",
              " 2693,\n",
              " 5101,\n",
              " 1104,\n",
              " 3060,\n",
              " 8292,\n",
              " 933,\n",
              " 5457,\n",
              " 2845,\n",
              " 4604,\n",
              " 3739,\n",
              " 3250,\n",
              " 1809,\n",
              " 4028,\n",
              " 327,\n",
              " 3625,\n",
              " 826,\n",
              " 6462,\n",
              " 8055,\n",
              " 24,\n",
              " 5301,\n",
              " 1784,\n",
              " 2223,\n",
              " 3434,\n",
              " 5399,\n",
              " 6515,\n",
              " 6968,\n",
              " 3623,\n",
              " 676,\n",
              " 8311,\n",
              " 5783,\n",
              " 119,\n",
              " 5454,\n",
              " 4435,\n",
              " 434,\n",
              " 3187,\n",
              " 1863,\n",
              " 1508,\n",
              " 171,\n",
              " 6754,\n",
              " 2972,\n",
              " 1415,\n",
              " 2271,\n",
              " 490,\n",
              " 3986,\n",
              " 740,\n",
              " 6907,\n",
              " 2062,\n",
              " 6760,\n",
              " 6954,\n",
              " 4768,\n",
              " 3880,\n",
              " 3939,\n",
              " 96,\n",
              " 549,\n",
              " 7300,\n",
              " 783,\n",
              " 1639,\n",
              " 4196,\n",
              " 4364,\n",
              " 2059,\n",
              " 2255,\n",
              " 4072,\n",
              " 2161,\n",
              " 4903,\n",
              " 1523,\n",
              " 5030,\n",
              " 495,\n",
              " 3620,\n",
              " 3861,\n",
              " 1199,\n",
              " 4924,\n",
              " 6059,\n",
              " 2807,\n",
              " 2609,\n",
              " 4903,\n",
              " 3042,\n",
              " 6855,\n",
              " 4655,\n",
              " 1209,\n",
              " 2058,\n",
              " 1236,\n",
              " 713,\n",
              " 62,\n",
              " 910,\n",
              " 5963,\n",
              " 1085,\n",
              " 5219,\n",
              " 963,\n",
              " 1730,\n",
              " 6494,\n",
              " 5796,\n",
              " 3083,\n",
              " 4874,\n",
              " 379,\n",
              " 4295,\n",
              " 6789,\n",
              " 4940,\n",
              " 7714,\n",
              " 41,\n",
              " 7644,\n",
              " 76,\n",
              " 21,\n",
              " 2299,\n",
              " 8453,\n",
              " 7627,\n",
              " 1476,\n",
              " 4349,\n",
              " 197,\n",
              " 4381,\n",
              " 6255,\n",
              " 8520,\n",
              " 5684,\n",
              " 3260,\n",
              " 2110,\n",
              " 8408,\n",
              " 6606,\n",
              " 8142,\n",
              " 4633,\n",
              " 8124,\n",
              " 4147,\n",
              " 2397,\n",
              " 236,\n",
              " 4568,\n",
              " 1213,\n",
              " 5685,\n",
              " 2732,\n",
              " 5515,\n",
              " 6846,\n",
              " 88,\n",
              " 2590,\n",
              " 7491,\n",
              " 502,\n",
              " 6301,\n",
              " 3593,\n",
              " 997,\n",
              " 4236,\n",
              " 410,\n",
              " 6509,\n",
              " 5593,\n",
              " 5965,\n",
              " 8255,\n",
              " 6370,\n",
              " 1964,\n",
              " 4275,\n",
              " 8430,\n",
              " 5732,\n",
              " 3928,\n",
              " 4422,\n",
              " 3272,\n",
              " 4370,\n",
              " 3621,\n",
              " 252,\n",
              " 4474,\n",
              " 4106,\n",
              " 5917,\n",
              " 803,\n",
              " 1947,\n",
              " 4725,\n",
              " 8212,\n",
              " 4037,\n",
              " 6205,\n",
              " 5323,\n",
              " 6505,\n",
              " 6266,\n",
              " 5475,\n",
              " 1091,\n",
              " 3297,\n",
              " 4119,\n",
              " 6018,\n",
              " 2833,\n",
              " 2710,\n",
              " 3603,\n",
              " 6094,\n",
              " 1997,\n",
              " 4981,\n",
              " 458,\n",
              " 698,\n",
              " 2158,\n",
              " 5072,\n",
              " 3367,\n",
              " 927,\n",
              " 6380,\n",
              " 4693,\n",
              " 4522,\n",
              " 7100,\n",
              " 6550,\n",
              " 6848,\n",
              " 41,\n",
              " 3167,\n",
              " 1271,\n",
              " 487,\n",
              " 7083,\n",
              " 7081,\n",
              " 1743,\n",
              " 3583,\n",
              " 8461,\n",
              " 4254,\n",
              " 8511,\n",
              " 4921,\n",
              " 8017,\n",
              " 5164,\n",
              " 6927,\n",
              " 5831,\n",
              " 5641,\n",
              " 1676,\n",
              " 2429,\n",
              " 5259,\n",
              " 2617,\n",
              " 7099,\n",
              " 2695,\n",
              " 2956,\n",
              " 3735,\n",
              " 8329,\n",
              " 623,\n",
              " 2181,\n",
              " 6405,\n",
              " 2277,\n",
              " 5399,\n",
              " 2321,\n",
              " 8095,\n",
              " 5432,\n",
              " 1226,\n",
              " 8473,\n",
              " 4365,\n",
              " 2406,\n",
              " 8375,\n",
              " 7893,\n",
              " 8013,\n",
              " 376,\n",
              " 5786,\n",
              " 3664,\n",
              " 3125,\n",
              " 7679,\n",
              " 2589,\n",
              " 4320,\n",
              " 3768,\n",
              " 1100,\n",
              " 4116,\n",
              " 940,\n",
              " 4928,\n",
              " 3567,\n",
              " 3505,\n",
              " 2357,\n",
              " 6469,\n",
              " 3992,\n",
              " 6212,\n",
              " 5109,\n",
              " 6098,\n",
              " 1133,\n",
              " 1836,\n",
              " 1599,\n",
              " 5134,\n",
              " 3013,\n",
              " 2862,\n",
              " 5378,\n",
              " 595,\n",
              " 1797,\n",
              " 1011,\n",
              " 7306,\n",
              " 1388,\n",
              " 1283,\n",
              " 3511,\n",
              " 4270,\n",
              " 5238,\n",
              " 7367,\n",
              " 3861,\n",
              " 5168,\n",
              " 5064,\n",
              " 5446,\n",
              " 332,\n",
              " 2946,\n",
              " 8279,\n",
              " 4701,\n",
              " 6360,\n",
              " 8007,\n",
              " 2871,\n",
              " 913,\n",
              " 6993,\n",
              " 3702,\n",
              " 2812,\n",
              " 7541,\n",
              " 1269,\n",
              " 4717,\n",
              " 942,\n",
              " 6303,\n",
              " 8102,\n",
              " 7100,\n",
              " 8145,\n",
              " 6589,\n",
              " 3007,\n",
              " 6374,\n",
              " 4358,\n",
              " 8343,\n",
              " 596,\n",
              " 4001,\n",
              " 7560,\n",
              " 6828,\n",
              " 2759,\n",
              " 5322,\n",
              " 678,\n",
              " 4003,\n",
              " 7343,\n",
              " 6883,\n",
              " 2239,\n",
              " 394,\n",
              " 5608,\n",
              " 3361,\n",
              " 7560,\n",
              " 3955,\n",
              " 4879,\n",
              " 6859,\n",
              " 8064,\n",
              " 4559,\n",
              " 3967,\n",
              " 3687,\n",
              " 285,\n",
              " 3827,\n",
              " 1079,\n",
              " 6146,\n",
              " 6680,\n",
              " 2493,\n",
              " 3759,\n",
              " 6136,\n",
              " 7764,\n",
              " 6316,\n",
              " 1220,\n",
              " 1074,\n",
              " 6064,\n",
              " 7165,\n",
              " 1305,\n",
              " 6354,\n",
              " 583,\n",
              " 6728,\n",
              " 8215,\n",
              " 3986,\n",
              " 1031,\n",
              " 6917,\n",
              " 4180,\n",
              " 2974,\n",
              " 3276,\n",
              " 3735,\n",
              " 1449,\n",
              " 4400,\n",
              " 1251,\n",
              " 7314,\n",
              " 1834,\n",
              " 4996,\n",
              " 2501,\n",
              " 7288,\n",
              " 8465,\n",
              " 4899,\n",
              " 3170,\n",
              " 6275,\n",
              " 92,\n",
              " 2729,\n",
              " 2183,\n",
              " 4965,\n",
              " 3918,\n",
              " 7235,\n",
              " 4408,\n",
              " 1580,\n",
              " 1467,\n",
              " 7584,\n",
              " 5206,\n",
              " 8240,\n",
              " 516,\n",
              " 6373,\n",
              " 3414,\n",
              " 5510,\n",
              " 6032,\n",
              " 4620,\n",
              " 3836,\n",
              " 7872,\n",
              " 3383,\n",
              " 7641,\n",
              " 4980,\n",
              " 5225,\n",
              " 1965,\n",
              " 6577,\n",
              " 1640,\n",
              " 5222,\n",
              " 4829,\n",
              " 4866,\n",
              " 3941,\n",
              " 7183,\n",
              " 2303,\n",
              " 2716,\n",
              " 6428,\n",
              " 338,\n",
              " 6155,\n",
              " 6392,\n",
              " 1832,\n",
              " 3673,\n",
              " 1775,\n",
              " 2333,\n",
              " 2086,\n",
              " 6541,\n",
              " 2441,\n",
              " 1489,\n",
              " 1184,\n",
              " 4001,\n",
              " 1706,\n",
              " 6898,\n",
              " 4789,\n",
              " 5182,\n",
              " 3280,\n",
              " 2453,\n",
              " 6169,\n",
              " 3697,\n",
              " 7129,\n",
              " 5571,\n",
              " 7830,\n",
              " 442,\n",
              " 7696,\n",
              " 4499,\n",
              " 1348,\n",
              " 5351,\n",
              " 863,\n",
              " 2175,\n",
              " 671,\n",
              " 2691,\n",
              " 7576,\n",
              " 8353,\n",
              " 6616,\n",
              " 5749,\n",
              " 5896,\n",
              " 7638,\n",
              " 2904,\n",
              " 5039,\n",
              " 407,\n",
              " 3798,\n",
              " 7416,\n",
              " 361,\n",
              " 6292,\n",
              " 5002,\n",
              " 5446,\n",
              " 251,\n",
              " 1217,\n",
              " 249,\n",
              " 640,\n",
              " 7172,\n",
              " 6603,\n",
              " 4346,\n",
              " 877,\n",
              " 5461,\n",
              " 6282,\n",
              " 2592,\n",
              " 4460,\n",
              " 3565,\n",
              " 3847,\n",
              " 375,\n",
              " 6125,\n",
              " 4642,\n",
              " 4819,\n",
              " 70,\n",
              " 7420,\n",
              " 1587,\n",
              " 3980,\n",
              " 4898,\n",
              " 2166,\n",
              " 6389,\n",
              " 6350,\n",
              " 1305,\n",
              " 6020,\n",
              " 2124,\n",
              " 7233,\n",
              " 5986,\n",
              " 6627,\n",
              " 7053,\n",
              " 6275,\n",
              " 6487,\n",
              " 2922,\n",
              " 5389,\n",
              " 3462,\n",
              " 5426,\n",
              " 3240,\n",
              " 1903,\n",
              " 2248,\n",
              " 1726,\n",
              " 4047,\n",
              " 726,\n",
              " 6404,\n",
              " 1634,\n",
              " 2232,\n",
              " 5486,\n",
              " 3015,\n",
              " 7020,\n",
              " 6893,\n",
              " 2598,\n",
              " 2914,\n",
              " 4684,\n",
              " 1475,\n",
              " 3014,\n",
              " 7526,\n",
              " 1193,\n",
              " 4619,\n",
              " 6692,\n",
              " 4848,\n",
              " 6713,\n",
              " 5052,\n",
              " 7771,\n",
              " 6688,\n",
              " 1332,\n",
              " 7800,\n",
              " 7439,\n",
              " 24,\n",
              " 7126,\n",
              " 478,\n",
              " 6042,\n",
              " 5856,\n",
              " 3332,\n",
              " 5333,\n",
              " 444,\n",
              " 7881,\n",
              " 1910,\n",
              " ...]"
            ]
          },
          "execution_count": 8,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "random_list"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "wBx6V72kynnL"
      },
      "outputs": [],
      "source": [
        "# set the index\n",
        "data.index = random_list"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Yo3Bbw97fWib",
        "outputId": "8c0b9be9-9f76-4e87-ce7c-caf6a6724ace"
      },
      "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>Item_Identifier</th>\n",
              "      <th>Item_Weight</th>\n",
              "      <th>Item_Fat_Content</th>\n",
              "      <th>Item_Visibility</th>\n",
              "      <th>Item_Type</th>\n",
              "      <th>Item_MRP</th>\n",
              "      <th>Outlet_Identifier</th>\n",
              "      <th>Outlet_Establishment_Year</th>\n",
              "      <th>Outlet_Size</th>\n",
              "      <th>Outlet_Location_Type</th>\n",
              "      <th>Outlet_Type</th>\n",
              "      <th>Item_Outlet_Sales</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <td>4333</td>\n",
              "      <td>FDA15</td>\n",
              "      <td>9.30</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016047</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>249.8092</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>1999</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>3735.1380</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>7000</td>\n",
              "      <td>DRC01</td>\n",
              "      <td>5.92</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.019278</td>\n",
              "      <td>Soft Drinks</td>\n",
              "      <td>48.2692</td>\n",
              "      <td>OUT018</td>\n",
              "      <td>2009</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type2</td>\n",
              "      <td>443.4228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>5232</td>\n",
              "      <td>FDN15</td>\n",
              "      <td>17.50</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016760</td>\n",
              "      <td>Meat</td>\n",
              "      <td>141.6180</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>1999</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>2097.2700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>594</td>\n",
              "      <td>FDX07</td>\n",
              "      <td>19.20</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Fruits and Vegetables</td>\n",
              "      <td>182.0950</td>\n",
              "      <td>OUT010</td>\n",
              "      <td>1998</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Grocery Store</td>\n",
              "      <td>732.3800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>3804</td>\n",
              "      <td>NCD19</td>\n",
              "      <td>8.93</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Household</td>\n",
              "      <td>53.8614</td>\n",
              "      <td>OUT013</td>\n",
              "      <td>1987</td>\n",
              "      <td>High</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>994.7052</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     Item_Identifier  Item_Weight Item_Fat_Content  Item_Visibility  \\\n",
              "4333           FDA15         9.30          Low Fat         0.016047   \n",
              "7000           DRC01         5.92          Regular         0.019278   \n",
              "5232           FDN15        17.50          Low Fat         0.016760   \n",
              "594            FDX07        19.20          Regular         0.000000   \n",
              "3804           NCD19         8.93          Low Fat         0.000000   \n",
              "\n",
              "                  Item_Type  Item_MRP Outlet_Identifier  \\\n",
              "4333                  Dairy  249.8092            OUT049   \n",
              "7000            Soft Drinks   48.2692            OUT018   \n",
              "5232                   Meat  141.6180            OUT049   \n",
              "594   Fruits and Vegetables  182.0950            OUT010   \n",
              "3804              Household   53.8614            OUT013   \n",
              "\n",
              "      Outlet_Establishment_Year Outlet_Size Outlet_Location_Type  \\\n",
              "4333                       1999      Medium               Tier 1   \n",
              "7000                       2009      Medium               Tier 3   \n",
              "5232                       1999      Medium               Tier 1   \n",
              "594                        1998         NaN               Tier 3   \n",
              "3804                       1987        High               Tier 3   \n",
              "\n",
              "            Outlet_Type  Item_Outlet_Sales  \n",
              "4333  Supermarket Type1          3735.1380  \n",
              "7000  Supermarket Type2           443.4228  \n",
              "5232  Supermarket Type1          2097.2700  \n",
              "594       Grocery Store           732.3800  \n",
              "3804  Supermarket Type1           994.7052  "
            ]
          },
          "execution_count": 10,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "data.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "BVUnMqHufWig"
      },
      "source": [
        "***Set another column of the dataframe as the index. We will use the set_index function. You can read more about here: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.set_index.html'***\n",
        "\n",
        "---"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "9ZSKPwbDfWih"
      },
      "outputs": [],
      "source": [
        "# 1. change the index of the dataframe\n",
        "# 2. drop=True is used to drop the column that's set as index\n",
        "# 3. inplace=True is used to make changes in the original dataframe\n",
        "# data = pd.read_csv('datasets/big_mart_sales.csv')\n",
        "\n",
        "data.set_index('Outlet_Establishment_Year', drop=True, inplace=True)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "rTxf34CsfWim",
        "outputId": "4d71bf3e-0de8-4a22-a34f-146546d2266a"
      },
      "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>Item_Identifier</th>\n",
              "      <th>Item_Weight</th>\n",
              "      <th>Item_Fat_Content</th>\n",
              "      <th>Item_Visibility</th>\n",
              "      <th>Item_Type</th>\n",
              "      <th>Item_MRP</th>\n",
              "      <th>Outlet_Identifier</th>\n",
              "      <th>Outlet_Size</th>\n",
              "      <th>Outlet_Location_Type</th>\n",
              "      <th>Outlet_Type</th>\n",
              "      <th>Item_Outlet_Sales</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Outlet_Establishment_Year</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></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",
              "      <td>1999</td>\n",
              "      <td>FDA15</td>\n",
              "      <td>9.30</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016047</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>249.8092</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>3735.1380</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>2009</td>\n",
              "      <td>DRC01</td>\n",
              "      <td>5.92</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.019278</td>\n",
              "      <td>Soft Drinks</td>\n",
              "      <td>48.2692</td>\n",
              "      <td>OUT018</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type2</td>\n",
              "      <td>443.4228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>1999</td>\n",
              "      <td>FDN15</td>\n",
              "      <td>17.50</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016760</td>\n",
              "      <td>Meat</td>\n",
              "      <td>141.6180</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>2097.2700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>1998</td>\n",
              "      <td>FDX07</td>\n",
              "      <td>19.20</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Fruits and Vegetables</td>\n",
              "      <td>182.0950</td>\n",
              "      <td>OUT010</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Grocery Store</td>\n",
              "      <td>732.3800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <td>1987</td>\n",
              "      <td>NCD19</td>\n",
              "      <td>8.93</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Household</td>\n",
              "      <td>53.8614</td>\n",
              "      <td>OUT013</td>\n",
              "      <td>High</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>994.7052</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                          Item_Identifier  Item_Weight Item_Fat_Content  \\\n",
              "Outlet_Establishment_Year                                                 \n",
              "1999                                FDA15         9.30          Low Fat   \n",
              "2009                                DRC01         5.92          Regular   \n",
              "1999                                FDN15        17.50          Low Fat   \n",
              "1998                                FDX07        19.20          Regular   \n",
              "1987                                NCD19         8.93          Low Fat   \n",
              "\n",
              "                           Item_Visibility              Item_Type  Item_MRP  \\\n",
              "Outlet_Establishment_Year                                                     \n",
              "1999                              0.016047                  Dairy  249.8092   \n",
              "2009                              0.019278            Soft Drinks   48.2692   \n",
              "1999                              0.016760                   Meat  141.6180   \n",
              "1998                              0.000000  Fruits and Vegetables  182.0950   \n",
              "1987                              0.000000              Household   53.8614   \n",
              "\n",
              "                          Outlet_Identifier Outlet_Size Outlet_Location_Type  \\\n",
              "Outlet_Establishment_Year                                                      \n",
              "1999                                 OUT049      Medium               Tier 1   \n",
              "2009                                 OUT018      Medium               Tier 3   \n",
              "1999                                 OUT049      Medium               Tier 1   \n",
              "1998                                 OUT010         NaN               Tier 3   \n",
              "1987                                 OUT013        High               Tier 3   \n",
              "\n",
              "                                 Outlet_Type  Item_Outlet_Sales  \n",
              "Outlet_Establishment_Year                                        \n",
              "1999                       Supermarket Type1          3735.1380  \n",
              "2009                       Supermarket Type2           443.4228  \n",
              "1999                       Supermarket Type1          2097.2700  \n",
              "1998                           Grocery Store           732.3800  \n",
              "1987                       Supermarket Type1           994.7052  "
            ]
          },
          "execution_count": 23,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# example of a label based index\n",
        "data.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "054SCKpufWir",
        "outputId": "050ced56-1fa7-4c30-cbe7-f2dadbe2d710"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "Int64Index([1999, 2009, 1999, 1998, 1987, 2009, 1987, 1985, 2002, 2007,\n",
              "            ...\n",
              "            2004, 2002, 2009, 2009, 1997, 1987, 2002, 2004, 2009, 1997],\n",
              "           dtype='int64', name='Outlet_Establishment_Year', length=8523)"
            ]
          },
          "execution_count": 10,
          "metadata": {
            "tags": []
          },
          "output_type": "execute_result"
        }
      ],
      "source": [
        "data.index"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "-w-aCfHmfWiw"
      },
      "source": [
        "---\n",
        "\n",
        "### `WILL THE INDEX BE ALWAYS NUMERIC?`\n",
        "\n",
        "---\n",
        "\n",
        "\n",
        "***No, We can also have categorical variables as the index of a dataframe.***\n",
        "\n",
        "---"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "4rSQoldwfWiy"
      },
      "outputs": [],
      "source": [
        "# reset the index\n",
        "data.set_index('Item_Identifier', drop= True, inplace=True)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "On0La0qTfWi2",
        "outputId": "f32b034c-39d3-4f8c-f7f0-ade68dbeb1ce"
      },
      "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>Item_Weight</th>\n",
              "      <th>Item_Fat_Content</th>\n",
              "      <th>Item_Visibility</th>\n",
              "      <th>Item_Type</th>\n",
              "      <th>Item_MRP</th>\n",
              "      <th>Outlet_Identifier</th>\n",
              "      <th>Outlet_Size</th>\n",
              "      <th>Outlet_Location_Type</th>\n",
              "      <th>Outlet_Type</th>\n",
              "      <th>Item_Outlet_Sales</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Item_Identifier</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></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>FDA15</th>\n",
              "      <td>9.30</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016047</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>249.8092</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>3735.1380</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>DRC01</th>\n",
              "      <td>5.92</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.019278</td>\n",
              "      <td>Soft Drinks</td>\n",
              "      <td>48.2692</td>\n",
              "      <td>OUT018</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type2</td>\n",
              "      <td>443.4228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FDN15</th>\n",
              "      <td>17.50</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016760</td>\n",
              "      <td>Meat</td>\n",
              "      <td>141.6180</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>2097.2700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FDX07</th>\n",
              "      <td>19.20</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Fruits and Vegetables</td>\n",
              "      <td>182.0950</td>\n",
              "      <td>OUT010</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Grocery Store</td>\n",
              "      <td>732.3800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NCD19</th>\n",
              "      <td>8.93</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Household</td>\n",
              "      <td>53.8614</td>\n",
              "      <td>OUT013</td>\n",
              "      <td>High</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>994.7052</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                 Item_Weight Item_Fat_Content  Item_Visibility  \\\n",
              "Item_Identifier                                                  \n",
              "FDA15                   9.30          Low Fat         0.016047   \n",
              "DRC01                   5.92          Regular         0.019278   \n",
              "FDN15                  17.50          Low Fat         0.016760   \n",
              "FDX07                  19.20          Regular         0.000000   \n",
              "NCD19                   8.93          Low Fat         0.000000   \n",
              "\n",
              "                             Item_Type  Item_MRP Outlet_Identifier  \\\n",
              "Item_Identifier                                                      \n",
              "FDA15                            Dairy  249.8092            OUT049   \n",
              "DRC01                      Soft Drinks   48.2692            OUT018   \n",
              "FDN15                             Meat  141.6180            OUT049   \n",
              "FDX07            Fruits and Vegetables  182.0950            OUT010   \n",
              "NCD19                        Household   53.8614            OUT013   \n",
              "\n",
              "                Outlet_Size Outlet_Location_Type        Outlet_Type  \\\n",
              "Item_Identifier                                                       \n",
              "FDA15                Medium               Tier 1  Supermarket Type1   \n",
              "DRC01                Medium               Tier 3  Supermarket Type2   \n",
              "FDN15                Medium               Tier 1  Supermarket Type1   \n",
              "FDX07                   NaN               Tier 3      Grocery Store   \n",
              "NCD19                  High               Tier 3  Supermarket Type1   \n",
              "\n",
              "                 Item_Outlet_Sales  \n",
              "Item_Identifier                     \n",
              "FDA15                    3735.1380  \n",
              "DRC01                     443.4228  \n",
              "FDN15                    2097.2700  \n",
              "FDX07                     732.3800  \n",
              "NCD19                     994.7052  "
            ]
          },
          "execution_count": 12,
          "metadata": {
            "tags": []
          },
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# view the top rows of the data\n",
        "data.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "p7Ad4b0JfWi7",
        "outputId": "dc6c7b61-5025-4ac0-e056-db299bcb0df4"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "Index(['FDA15', 'DRC01', 'FDN15', 'FDX07', 'NCD19', 'FDP36', 'FDO10', 'FDP10',\n",
              "       'FDH17', 'FDU28',\n",
              "       ...\n",
              "       'FDH31', 'FDA01', 'FDH24', 'NCJ19', 'FDF53', 'FDF22', 'FDS36', 'NCJ29',\n",
              "       'FDN46', 'DRG01'],\n",
              "      dtype='object', name='Item_Identifier', length=8523)"
            ]
          },
          "execution_count": 13,
          "metadata": {
            "tags": []
          },
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# index of the data\n",
        "data.index"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "hpC22dT8fWi_"
      },
      "source": [
        "---\n",
        "\n",
        "#### `HOW TO SUBSET THE DATA BASED ON THE LABEL OF THE INDEX?`\n",
        "\n",
        "- We can subset the data based on the label of the index using the loc function.\n",
        "---"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "q2otzN4jfWjB",
        "outputId": "8aabe7ce-f4a9-4db1-e64d-58bbf6067f23"
      },
      "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>Item_Weight</th>\n",
              "      <th>Item_Fat_Content</th>\n",
              "      <th>Item_Visibility</th>\n",
              "      <th>Item_Type</th>\n",
              "      <th>Item_MRP</th>\n",
              "      <th>Outlet_Identifier</th>\n",
              "      <th>Outlet_Size</th>\n",
              "      <th>Outlet_Location_Type</th>\n",
              "      <th>Outlet_Type</th>\n",
              "      <th>Item_Outlet_Sales</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Item_Identifier</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></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>FDA15</th>\n",
              "      <td>9.3</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016047</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>249.8092</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>3735.1380</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FDA15</th>\n",
              "      <td>9.3</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016055</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>250.2092</td>\n",
              "      <td>OUT045</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Tier 2</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>5976.2208</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FDA15</th>\n",
              "      <td>9.3</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016019</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>248.5092</td>\n",
              "      <td>OUT035</td>\n",
              "      <td>Small</td>\n",
              "      <td>Tier 2</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>6474.2392</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FDA15</th>\n",
              "      <td>9.3</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016088</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>249.6092</td>\n",
              "      <td>OUT018</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type2</td>\n",
              "      <td>5976.2208</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FDA15</th>\n",
              "      <td>9.3</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.026818</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>248.9092</td>\n",
              "      <td>OUT010</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Grocery Store</td>\n",
              "      <td>498.0184</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FDA15</th>\n",
              "      <td>9.3</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016009</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>250.6092</td>\n",
              "      <td>OUT013</td>\n",
              "      <td>High</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>6474.2392</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FDA15</th>\n",
              "      <td>NaN</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.015945</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>249.5092</td>\n",
              "      <td>OUT027</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type3</td>\n",
              "      <td>6474.2392</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>FDA15</th>\n",
              "      <td>9.3</td>\n",
              "      <td>LF</td>\n",
              "      <td>0.016113</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>248.8092</td>\n",
              "      <td>OUT017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Tier 2</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>5976.2208</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                 Item_Weight Item_Fat_Content  Item_Visibility Item_Type  \\\n",
              "Item_Identifier                                                            \n",
              "FDA15                    9.3          Low Fat         0.016047     Dairy   \n",
              "FDA15                    9.3          Low Fat         0.016055     Dairy   \n",
              "FDA15                    9.3          Low Fat         0.016019     Dairy   \n",
              "FDA15                    9.3          Low Fat         0.016088     Dairy   \n",
              "FDA15                    9.3          Low Fat         0.026818     Dairy   \n",
              "FDA15                    9.3          Low Fat         0.016009     Dairy   \n",
              "FDA15                    NaN          Low Fat         0.015945     Dairy   \n",
              "FDA15                    9.3               LF         0.016113     Dairy   \n",
              "\n",
              "                 Item_MRP Outlet_Identifier Outlet_Size Outlet_Location_Type  \\\n",
              "Item_Identifier                                                                \n",
              "FDA15            249.8092            OUT049      Medium               Tier 1   \n",
              "FDA15            250.2092            OUT045         NaN               Tier 2   \n",
              "FDA15            248.5092            OUT035       Small               Tier 2   \n",
              "FDA15            249.6092            OUT018      Medium               Tier 3   \n",
              "FDA15            248.9092            OUT010         NaN               Tier 3   \n",
              "FDA15            250.6092            OUT013        High               Tier 3   \n",
              "FDA15            249.5092            OUT027      Medium               Tier 3   \n",
              "FDA15            248.8092            OUT017         NaN               Tier 2   \n",
              "\n",
              "                       Outlet_Type  Item_Outlet_Sales  \n",
              "Item_Identifier                                        \n",
              "FDA15            Supermarket Type1          3735.1380  \n",
              "FDA15            Supermarket Type1          5976.2208  \n",
              "FDA15            Supermarket Type1          6474.2392  \n",
              "FDA15            Supermarket Type2          5976.2208  \n",
              "FDA15                Grocery Store           498.0184  \n",
              "FDA15            Supermarket Type1          6474.2392  \n",
              "FDA15            Supermarket Type3          6474.2392  \n",
              "FDA15            Supermarket Type1          5976.2208  "
            ]
          },
          "execution_count": 14,
          "metadata": {
            "tags": []
          },
          "output_type": "execute_result"
        }
      ],
      "source": [
        "data.loc['FDA15']"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "R1GV_5WSfWjH"
      },
      "source": [
        "***What if we want to change the index back to positional?***\n",
        "\n",
        "---\n",
        "\n",
        "#### `CAN WE RESET THE INDEX?`\n",
        "\n",
        "***Yes, we can reset the index. We will use the reset_index function. You can read more about here: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.reset_index.html***\n",
        "\n",
        "---"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "cZXnKiv6fWjJ"
      },
      "outputs": [],
      "source": [
        "# reset the index\n",
        "data.reset_index(inplace=True)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "cEbuLWgJfWjN",
        "outputId": "734fd7d4-dcf5-42b6-f75e-d7515c423c56"
      },
      "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>Item_Identifier</th>\n",
              "      <th>Item_Weight</th>\n",
              "      <th>Item_Fat_Content</th>\n",
              "      <th>Item_Visibility</th>\n",
              "      <th>Item_Type</th>\n",
              "      <th>Item_MRP</th>\n",
              "      <th>Outlet_Identifier</th>\n",
              "      <th>Outlet_Size</th>\n",
              "      <th>Outlet_Location_Type</th>\n",
              "      <th>Outlet_Type</th>\n",
              "      <th>Item_Outlet_Sales</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>FDA15</td>\n",
              "      <td>9.30</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016047</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>249.8092</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>3735.1380</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>DRC01</td>\n",
              "      <td>5.92</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.019278</td>\n",
              "      <td>Soft Drinks</td>\n",
              "      <td>48.2692</td>\n",
              "      <td>OUT018</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type2</td>\n",
              "      <td>443.4228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>FDN15</td>\n",
              "      <td>17.50</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016760</td>\n",
              "      <td>Meat</td>\n",
              "      <td>141.6180</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>2097.2700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>FDX07</td>\n",
              "      <td>19.20</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Fruits and Vegetables</td>\n",
              "      <td>182.0950</td>\n",
              "      <td>OUT010</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Grocery Store</td>\n",
              "      <td>732.3800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NCD19</td>\n",
              "      <td>8.93</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>Household</td>\n",
              "      <td>53.8614</td>\n",
              "      <td>OUT013</td>\n",
              "      <td>High</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>994.7052</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  Item_Identifier  Item_Weight Item_Fat_Content  Item_Visibility  \\\n",
              "0           FDA15         9.30          Low Fat         0.016047   \n",
              "1           DRC01         5.92          Regular         0.019278   \n",
              "2           FDN15        17.50          Low Fat         0.016760   \n",
              "3           FDX07        19.20          Regular         0.000000   \n",
              "4           NCD19         8.93          Low Fat         0.000000   \n",
              "\n",
              "               Item_Type  Item_MRP Outlet_Identifier Outlet_Size  \\\n",
              "0                  Dairy  249.8092            OUT049      Medium   \n",
              "1            Soft Drinks   48.2692            OUT018      Medium   \n",
              "2                   Meat  141.6180            OUT049      Medium   \n",
              "3  Fruits and Vegetables  182.0950            OUT010         NaN   \n",
              "4              Household   53.8614            OUT013        High   \n",
              "\n",
              "  Outlet_Location_Type        Outlet_Type  Item_Outlet_Sales  \n",
              "0               Tier 1  Supermarket Type1          3735.1380  \n",
              "1               Tier 3  Supermarket Type2           443.4228  \n",
              "2               Tier 1  Supermarket Type1          2097.2700  \n",
              "3               Tier 3      Grocery Store           732.3800  \n",
              "4               Tier 3  Supermarket Type1           994.7052  "
            ]
          },
          "execution_count": 16,
          "metadata": {
            "tags": []
          },
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# view the top rows of the data\n",
        "data.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "GS4BcHdKfWjR"
      },
      "source": [
        "#### `HOW TO SUBSET THE DATA BASED ON A VALUE OF A COLUMN?`\n",
        "\n",
        "---"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "_bgNcT8YfWjS",
        "outputId": "aae278e5-f2ef-4ecf-df71-9497a9ee5ee1"
      },
      "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>Item_Identifier</th>\n",
              "      <th>Item_Weight</th>\n",
              "      <th>Item_Fat_Content</th>\n",
              "      <th>Item_Visibility</th>\n",
              "      <th>Item_Type</th>\n",
              "      <th>Item_MRP</th>\n",
              "      <th>Outlet_Identifier</th>\n",
              "      <th>Outlet_Size</th>\n",
              "      <th>Outlet_Location_Type</th>\n",
              "      <th>Outlet_Type</th>\n",
              "      <th>Item_Outlet_Sales</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>FDA15</td>\n",
              "      <td>9.300</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.016047</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>249.8092</td>\n",
              "      <td>OUT049</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>3735.1380</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>FDA03</td>\n",
              "      <td>18.500</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.045464</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>144.1102</td>\n",
              "      <td>OUT046</td>\n",
              "      <td>Small</td>\n",
              "      <td>Tier 1</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>2187.1530</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>FDU02</td>\n",
              "      <td>13.350</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.102492</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>230.5352</td>\n",
              "      <td>OUT035</td>\n",
              "      <td>Small</td>\n",
              "      <td>Tier 2</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>2748.4224</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>FDE51</td>\n",
              "      <td>5.925</td>\n",
              "      <td>Regular</td>\n",
              "      <td>0.161467</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>45.5086</td>\n",
              "      <td>OUT010</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Grocery Store</td>\n",
              "      <td>178.4344</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>FDV38</td>\n",
              "      <td>19.250</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.170349</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>55.7956</td>\n",
              "      <td>OUT010</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Grocery Store</td>\n",
              "      <td>163.7868</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",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8424</th>\n",
              "      <td>FDC39</td>\n",
              "      <td>7.405</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.159165</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>207.1296</td>\n",
              "      <td>OUT035</td>\n",
              "      <td>Small</td>\n",
              "      <td>Tier 2</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>3739.1328</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8447</th>\n",
              "      <td>FDS26</td>\n",
              "      <td>20.350</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.089975</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>261.6594</td>\n",
              "      <td>OUT017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Tier 2</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>7588.1226</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8448</th>\n",
              "      <td>FDV50</td>\n",
              "      <td>14.300</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.123071</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>121.1730</td>\n",
              "      <td>OUT018</td>\n",
              "      <td>Medium</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type2</td>\n",
              "      <td>2093.9410</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8457</th>\n",
              "      <td>FDY50</td>\n",
              "      <td>5.800</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.130931</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>89.9172</td>\n",
              "      <td>OUT035</td>\n",
              "      <td>Small</td>\n",
              "      <td>Tier 2</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>1516.6924</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8512</th>\n",
              "      <td>FDR26</td>\n",
              "      <td>20.700</td>\n",
              "      <td>Low Fat</td>\n",
              "      <td>0.042801</td>\n",
              "      <td>Dairy</td>\n",
              "      <td>178.3028</td>\n",
              "      <td>OUT013</td>\n",
              "      <td>High</td>\n",
              "      <td>Tier 3</td>\n",
              "      <td>Supermarket Type1</td>\n",
              "      <td>2479.4392</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>682 rows × 11 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     Item_Identifier  Item_Weight Item_Fat_Content  Item_Visibility Item_Type  \\\n",
              "0              FDA15        9.300          Low Fat         0.016047     Dairy   \n",
              "11             FDA03       18.500          Regular         0.045464     Dairy   \n",
              "19             FDU02       13.350          Low Fat         0.102492     Dairy   \n",
              "28             FDE51        5.925          Regular         0.161467     Dairy   \n",
              "30             FDV38       19.250          Low Fat         0.170349     Dairy   \n",
              "...              ...          ...              ...              ...       ...   \n",
              "8424           FDC39        7.405          Low Fat         0.159165     Dairy   \n",
              "8447           FDS26       20.350          Low Fat         0.089975     Dairy   \n",
              "8448           FDV50       14.300          Low Fat         0.123071     Dairy   \n",
              "8457           FDY50        5.800          Low Fat         0.130931     Dairy   \n",
              "8512           FDR26       20.700          Low Fat         0.042801     Dairy   \n",
              "\n",
              "      Item_MRP Outlet_Identifier Outlet_Size Outlet_Location_Type  \\\n",
              "0     249.8092            OUT049      Medium               Tier 1   \n",
              "11    144.1102            OUT046       Small               Tier 1   \n",
              "19    230.5352            OUT035       Small               Tier 2   \n",
              "28     45.5086            OUT010         NaN               Tier 3   \n",
              "30     55.7956            OUT010         NaN               Tier 3   \n",
              "...        ...               ...         ...                  ...   \n",
              "8424  207.1296            OUT035       Small               Tier 2   \n",
              "8447  261.6594            OUT017         NaN               Tier 2   \n",
              "8448  121.1730            OUT018      Medium               Tier 3   \n",
              "8457   89.9172            OUT035       Small               Tier 2   \n",
              "8512  178.3028            OUT013        High               Tier 3   \n",
              "\n",
              "            Outlet_Type  Item_Outlet_Sales  \n",
              "0     Supermarket Type1          3735.1380  \n",
              "11    Supermarket Type1          2187.1530  \n",
              "19    Supermarket Type1          2748.4224  \n",
              "28        Grocery Store           178.4344  \n",
              "30        Grocery Store           163.7868  \n",
              "...                 ...                ...  \n",
              "8424  Supermarket Type1          3739.1328  \n",
              "8447  Supermarket Type1          7588.1226  \n",
              "8448  Supermarket Type2          2093.9410  \n",
              "8457  Supermarket Type1          1516.6924  \n",
              "8512  Supermarket Type1          2479.4392  \n",
              "\n",
              "[682 rows x 11 columns]"
            ]
          },
          "execution_count": 17,
          "metadata": {
            "tags": []
          },
          "output_type": "execute_result"
        }
      ],
      "source": [
        "data[data['Item_Type'] == 'Dairy']"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "fmr0TiPrfWjX"
      },
      "source": []
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "LVyTkUEXfWjY"
      },
      "outputs": [],
      "source": []
    }
  ],
  "metadata": {
    "colab": {
      "provenance": [],
      "include_colab_link": true
    },
    "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.7.4"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}