RFM_online_retail_ii.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[]},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"markdown","source":["## Import necessary libraries"],"metadata":{"id":"Ebm1fTNnyl2d"}},{"cell_type":"code","execution_count":2,"metadata":{"id":"riTEAHzEcQYn","executionInfo":{"status":"ok","timestamp":1705042698006,"user_tz":-180,"elapsed":993,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"outputs":[],"source":["import pandas as pd\n","import numpy as np\n","import datetime as dt\n","pd.set_option(\"display.max_columns\",None)\n","pd.set_option(\"display.width\",500)\n","pd.set_option(\"display.float_format\", lambda x: '%.3f' % x)\n"]},{"cell_type":"markdown","source":["# Import Dataset"],"metadata":{"id":"HM-MI7f1ICJj"}},{"cell_type":"code","source":["online_retail = pd.read_excel(\"/content/drive/MyDrive/Colab Notebooks/online_retail_II.xlsx\",sheet_name=\"Year 2009-2010\")\n","df = online_retail.copy()\n","df.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"dnaK4AJXIFPM","executionInfo":{"status":"ok","timestamp":1705042781061,"user_tz":-180,"elapsed":80408,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}},"outputId":"21b3ab10-52ce-44cf-864e-5b4baa556f68"},"execution_count":3,"outputs":[{"output_type":"execute_result","data":{"text/plain":["  Invoice StockCode                          Description  Quantity         InvoiceDate  Price  Customer ID         Country\n","0  489434     85048  15CM CHRISTMAS GLASS BALL 20 LIGHTS        12 2009-12-01 07:45:00  6.950    13085.000  United Kingdom\n","1  489434    79323P                   PINK CHERRY LIGHTS        12 2009-12-01 07:45:00  6.750    13085.000  United Kingdom\n","2  489434    79323W                  WHITE CHERRY LIGHTS        12 2009-12-01 07:45:00  6.750    13085.000  United Kingdom\n","3  489434     22041         RECORD FRAME 7\" SINGLE SIZE         48 2009-12-01 07:45:00  2.100    13085.000  United Kingdom\n","4  489434     21232       STRAWBERRY CERAMIC TRINKET BOX        24 2009-12-01 07:45:00  1.250    13085.000  United Kingdom"],"text/html":["\n","  <div id=\"df-b347d9c9-203a-4e39-ac4a-56d205d894d2\" class=\"colab-df-container\">\n","    <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>Invoice</th>\n","      <th>StockCode</th>\n","      <th>Description</th>\n","      <th>Quantity</th>\n","      <th>InvoiceDate</th>\n","      <th>Price</th>\n","      <th>Customer ID</th>\n","      <th>Country</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>489434</td>\n","      <td>85048</td>\n","      <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n","      <td>12</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>6.950</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>489434</td>\n","      <td>79323P</td>\n","      <td>PINK CHERRY LIGHTS</td>\n","      <td>12</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>6.750</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>489434</td>\n","      <td>79323W</td>\n","      <td>WHITE CHERRY LIGHTS</td>\n","      <td>12</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>6.750</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>489434</td>\n","      <td>22041</td>\n","      <td>RECORD FRAME 7\" SINGLE SIZE</td>\n","      <td>48</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>2.100</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>489434</td>\n","      <td>21232</td>\n","      <td>STRAWBERRY CERAMIC TRINKET BOX</td>\n","      <td>24</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>1.250</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b347d9c9-203a-4e39-ac4a-56d205d894d2')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-b347d9c9-203a-4e39-ac4a-56d205d894d2 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-b347d9c9-203a-4e39-ac4a-56d205d894d2');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-0afc4f4a-c388-4382-bd52-2ba73695a660\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-0afc4f4a-c388-4382-bd52-2ba73695a660')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-0afc4f4a-c388-4382-bd52-2ba73695a660 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":3}]},{"cell_type":"markdown","source":["## general information about dataset"],"metadata":{"id":"goGHWapzysB8"}},{"cell_type":"code","source":["def check_df(dataframe,head=5):\n","  print(\"################################ Head ################################\\n\")\n","  print(dataframe.head(head))\n","  print(\"################################ Tail ################################\\n\")\n","  print(dataframe.tail(head))\n","  print(\"################################ Shape ################################\\n\")\n","  print(dataframe.shape)\n","  print(\"################################ Types ################################\\n\")\n","  print(dataframe.dtypes)\n","  print(\"################################ NA ################################\\n\")\n","  print(dataframe.isnull().sum())\n","  print(\"################################ Qurtiles ################################\\n\")\n","  print(dataframe.describe([0, 0.05, 0.50, 0.95, 0.99, 1]).T)\n","\n","check_df(df)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"4NZ7WBLnfEWj","outputId":"cd95912b-ef13-456b-94e5-d2c0cd5887e2","executionInfo":{"status":"ok","timestamp":1705043110384,"user_tz":-180,"elapsed":1074,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":4,"outputs":[{"output_type":"stream","name":"stdout","text":["################################ Head ################################\n","\n","  Invoice StockCode                          Description  Quantity         InvoiceDate  Price  Customer ID         Country\n","0  489434     85048  15CM CHRISTMAS GLASS BALL 20 LIGHTS        12 2009-12-01 07:45:00  6.950    13085.000  United Kingdom\n","1  489434    79323P                   PINK CHERRY LIGHTS        12 2009-12-01 07:45:00  6.750    13085.000  United Kingdom\n","2  489434    79323W                  WHITE CHERRY LIGHTS        12 2009-12-01 07:45:00  6.750    13085.000  United Kingdom\n","3  489434     22041         RECORD FRAME 7\" SINGLE SIZE         48 2009-12-01 07:45:00  2.100    13085.000  United Kingdom\n","4  489434     21232       STRAWBERRY CERAMIC TRINKET BOX        24 2009-12-01 07:45:00  1.250    13085.000  United Kingdom\n","################################ Tail ################################\n","\n","       Invoice StockCode                         Description  Quantity         InvoiceDate  Price  Customer ID         Country\n","525456  538171     22271                FELTCRAFT DOLL ROSIE         2 2010-12-09 20:01:00  2.950    17530.000  United Kingdom\n","525457  538171     22750        FELTCRAFT PRINCESS LOLA DOLL         1 2010-12-09 20:01:00  3.750    17530.000  United Kingdom\n","525458  538171     22751      FELTCRAFT PRINCESS OLIVIA DOLL         1 2010-12-09 20:01:00  3.750    17530.000  United Kingdom\n","525459  538171     20970  PINK FLORAL FELTCRAFT SHOULDER BAG         2 2010-12-09 20:01:00  3.750    17530.000  United Kingdom\n","525460  538171     21931              JUMBO STORAGE BAG SUKI         2 2010-12-09 20:01:00  1.950    17530.000  United Kingdom\n","################################ Shape ################################\n","\n","(525461, 8)\n","################################ Types ################################\n","\n","Invoice                object\n","StockCode              object\n","Description            object\n","Quantity                int64\n","InvoiceDate    datetime64[ns]\n","Price                 float64\n","Customer ID           float64\n","Country                object\n","dtype: object\n","################################ NA ################################\n","\n","Invoice             0\n","StockCode           0\n","Description      2928\n","Quantity            0\n","InvoiceDate         0\n","Price               0\n","Customer ID    107927\n","Country             0\n","dtype: int64\n","################################ Qurtiles ################################\n","\n","                 count      mean      std        min         0%        5%       50%       95%       99%      100%       max\n","Quantity    525461.000    10.338  107.424  -9600.000  -9600.000     1.000     3.000    30.000   120.000 19152.000 19152.000\n","Price       525461.000     4.689  146.127 -53594.360 -53594.360     0.420     2.100    10.170    19.950 25111.090 25111.090\n","Customer ID 417534.000 15360.645 1680.811  12346.000  12346.000 12725.000 15311.000 17913.000 18196.000 18287.000 18287.000\n"]}]},{"cell_type":"code","source":["df[\"Description\"].nunique() # eşsiz ürün sayısı"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"q_GysFxQklZe","outputId":"bcf7bc2d-6e49-4e91-8038-970931d63671","executionInfo":{"status":"ok","timestamp":1705043111803,"user_tz":-180,"elapsed":8,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":5,"outputs":[{"output_type":"execute_result","data":{"text/plain":["4681"]},"metadata":{},"execution_count":5}]},{"cell_type":"code","source":["df[\"Description\"].value_counts().head() # her üründen kaçar tane satılmış"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"48YZ_RUUkzOK","outputId":"44cb0c34-246e-4292-90b9-11913deaf62c","executionInfo":{"status":"ok","timestamp":1705043113194,"user_tz":-180,"elapsed":17,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":6,"outputs":[{"output_type":"execute_result","data":{"text/plain":["WHITE HANGING HEART T-LIGHT HOLDER    3549\n","REGENCY CAKESTAND 3 TIER              2212\n","STRAWBERRY CERAMIC TRINKET BOX        1843\n","PACK OF 72 RETRO SPOT CAKE CASES      1466\n","ASSORTED COLOUR BIRD ORNAMENT         1457\n","Name: Description, dtype: int64"]},"metadata":{},"execution_count":6}]},{"cell_type":"code","source":["df.groupby([\"Description\"]).agg({'Quantity':'sum'}).sort_values(by=\"Quantity\",ascending=False).head() # en fazla hangi üründen kaç tane sayılmış"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":237},"id":"Y9zrGM5-k4eo","outputId":"3e00e80f-e44c-4077-984f-541ee6af3939","executionInfo":{"status":"ok","timestamp":1705043117022,"user_tz":-180,"elapsed":395,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":7,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                                    Quantity\n","Description                                 \n","WHITE HANGING HEART T-LIGHT HOLDER     57733\n","WORLD WAR 2 GLIDERS ASSTD DESIGNS      54698\n","BROCADE RING PURSE                     47647\n","PACK OF 72 RETRO SPOT CAKE CASES       46106\n","ASSORTED COLOUR BIRD ORNAMENT          44925"],"text/html":["\n","  <div id=\"df-e87c52c9-a273-46f2-9e96-f1a8f802a9ff\" class=\"colab-df-container\">\n","    <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>Quantity</th>\n","    </tr>\n","    <tr>\n","      <th>Description</th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>WHITE HANGING HEART T-LIGHT HOLDER</th>\n","      <td>57733</td>\n","    </tr>\n","    <tr>\n","      <th>WORLD WAR 2 GLIDERS ASSTD DESIGNS</th>\n","      <td>54698</td>\n","    </tr>\n","    <tr>\n","      <th>BROCADE RING PURSE</th>\n","      <td>47647</td>\n","    </tr>\n","    <tr>\n","      <th>PACK OF 72 RETRO SPOT CAKE CASES</th>\n","      <td>46106</td>\n","    </tr>\n","    <tr>\n","      <th>ASSORTED COLOUR BIRD ORNAMENT</th>\n","      <td>44925</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e87c52c9-a273-46f2-9e96-f1a8f802a9ff')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-e87c52c9-a273-46f2-9e96-f1a8f802a9ff button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-e87c52c9-a273-46f2-9e96-f1a8f802a9ff');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-ffd71a1c-a45d-43dd-b2ca-dff31a1a52d9\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ffd71a1c-a45d-43dd-b2ca-dff31a1a52d9')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-ffd71a1c-a45d-43dd-b2ca-dff31a1a52d9 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":7}]},{"cell_type":"code","source":["df[\"Invoice\"].nunique() # eşsiz fatura sayısı"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"83qMFPKQlDal","outputId":"23e6271a-8a16-451e-92f6-ebad2d26f5c0","executionInfo":{"status":"ok","timestamp":1705043121645,"user_tz":-180,"elapsed":484,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":8,"outputs":[{"output_type":"execute_result","data":{"text/plain":["28816"]},"metadata":{},"execution_count":8}]},{"cell_type":"markdown","source":["### Calculate Total Price for any quantity"],"metadata":{"id":"vnZ5P5kgyxo5"}},{"cell_type":"code","source":["df[\"TotalPrice\"] = df[\"Quantity\"] * df[\"Price\"] # her bir ürünün fiyat bilgisi"],"metadata":{"id":"a5itNrkalkzC","executionInfo":{"status":"ok","timestamp":1705043126213,"user_tz":-180,"elapsed":536,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":9,"outputs":[]},{"cell_type":"code","source":["df.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"kUZHmFGOl9yl","outputId":"bcd47fd9-982f-4d31-9844-9b1c2881fa6b","executionInfo":{"status":"ok","timestamp":1705043127868,"user_tz":-180,"elapsed":25,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":10,"outputs":[{"output_type":"execute_result","data":{"text/plain":["  Invoice StockCode                          Description  Quantity         InvoiceDate  Price  Customer ID         Country  TotalPrice\n","0  489434     85048  15CM CHRISTMAS GLASS BALL 20 LIGHTS        12 2009-12-01 07:45:00  6.950    13085.000  United Kingdom      83.400\n","1  489434    79323P                   PINK CHERRY LIGHTS        12 2009-12-01 07:45:00  6.750    13085.000  United Kingdom      81.000\n","2  489434    79323W                  WHITE CHERRY LIGHTS        12 2009-12-01 07:45:00  6.750    13085.000  United Kingdom      81.000\n","3  489434     22041         RECORD FRAME 7\" SINGLE SIZE         48 2009-12-01 07:45:00  2.100    13085.000  United Kingdom     100.800\n","4  489434     21232       STRAWBERRY CERAMIC TRINKET BOX        24 2009-12-01 07:45:00  1.250    13085.000  United Kingdom      30.000"],"text/html":["\n","  <div id=\"df-5ac473aa-ceee-4575-aefa-4951cc62fd9f\" class=\"colab-df-container\">\n","    <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>Invoice</th>\n","      <th>StockCode</th>\n","      <th>Description</th>\n","      <th>Quantity</th>\n","      <th>InvoiceDate</th>\n","      <th>Price</th>\n","      <th>Customer ID</th>\n","      <th>Country</th>\n","      <th>TotalPrice</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>489434</td>\n","      <td>85048</td>\n","      <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n","      <td>12</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>6.950</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","      <td>83.400</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>489434</td>\n","      <td>79323P</td>\n","      <td>PINK CHERRY LIGHTS</td>\n","      <td>12</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>6.750</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","      <td>81.000</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>489434</td>\n","      <td>79323W</td>\n","      <td>WHITE CHERRY LIGHTS</td>\n","      <td>12</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>6.750</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","      <td>81.000</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>489434</td>\n","      <td>22041</td>\n","      <td>RECORD FRAME 7\" SINGLE SIZE</td>\n","      <td>48</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>2.100</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","      <td>100.800</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>489434</td>\n","      <td>21232</td>\n","      <td>STRAWBERRY CERAMIC TRINKET BOX</td>\n","      <td>24</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>1.250</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","      <td>30.000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5ac473aa-ceee-4575-aefa-4951cc62fd9f')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-5ac473aa-ceee-4575-aefa-4951cc62fd9f button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-5ac473aa-ceee-4575-aefa-4951cc62fd9f');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-12f104d5-62a1-4c87-87ad-15dd56140a06\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-12f104d5-62a1-4c87-87ad-15dd56140a06')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-12f104d5-62a1-4c87-87ad-15dd56140a06 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":10}]},{"cell_type":"code","source":["df.groupby([\"Invoice\"]).agg({'TotalPrice':'sum'}).head() # fatura başına toplam kazanılan miktar"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":237},"id":"paMFvHiOmBxa","outputId":"0a73e4b1-e028-469a-b200-c1686b7c97d1","executionInfo":{"status":"ok","timestamp":1705043129867,"user_tz":-180,"elapsed":608,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":11,"outputs":[{"output_type":"execute_result","data":{"text/plain":["         TotalPrice\n","Invoice            \n","489434      505.300\n","489435      145.800\n","489436      630.330\n","489437      310.750\n","489438     2286.240"],"text/html":["\n","  <div id=\"df-e6744224-d4bd-4175-93fe-48710c5ffe57\" class=\"colab-df-container\">\n","    <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>TotalPrice</th>\n","    </tr>\n","    <tr>\n","      <th>Invoice</th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>489434</th>\n","      <td>505.300</td>\n","    </tr>\n","    <tr>\n","      <th>489435</th>\n","      <td>145.800</td>\n","    </tr>\n","    <tr>\n","      <th>489436</th>\n","      <td>630.330</td>\n","    </tr>\n","    <tr>\n","      <th>489437</th>\n","      <td>310.750</td>\n","    </tr>\n","    <tr>\n","      <th>489438</th>\n","      <td>2286.240</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e6744224-d4bd-4175-93fe-48710c5ffe57')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-e6744224-d4bd-4175-93fe-48710c5ffe57 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-e6744224-d4bd-4175-93fe-48710c5ffe57');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-0863c219-d3cf-4022-a7bf-349de519b5c4\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-0863c219-d3cf-4022-a7bf-349de519b5c4')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-0863c219-d3cf-4022-a7bf-349de519b5c4 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":11}]},{"cell_type":"markdown","source":["# Data Preprocessing\n","\n","outlier detection yapılması RFM analizinde pekte mantıklı değil çünkü ne kaadar outlier leri baskılarsanız baskılayın zaten 5 puana denk gelceği için gerek yok böyle bir işleme, zaten aykırı değerler 5 puan alacaktır."],"metadata":{"id":"rumc5J3HLCA2"}},{"cell_type":"code","source":["df.isnull().sum() # boş değerleri silmemiz lazım çünkü Customer İD gibi segmentasyon yapacağımız kısım boş olmaması lazım"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"2K3kepejm3jc","outputId":"08d2c19b-898a-4113-d049-865fe8aa6b97","executionInfo":{"status":"ok","timestamp":1705043132892,"user_tz":-180,"elapsed":758,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":12,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Invoice             0\n","StockCode           0\n","Description      2928\n","Quantity            0\n","InvoiceDate         0\n","Price               0\n","Customer ID    107927\n","Country             0\n","TotalPrice          0\n","dtype: int64"]},"metadata":{},"execution_count":12}]},{"cell_type":"code","source":["df.dropna(inplace=True)"],"metadata":{"id":"FOTBXSuXsRlK","executionInfo":{"status":"ok","timestamp":1705043135390,"user_tz":-180,"elapsed":531,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":13,"outputs":[]},{"cell_type":"code","source":["df.isnull().sum()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"TXnjF_PjsVjk","outputId":"b7fa9dc1-6f07-4e97-8dec-57d28c79cbb4","executionInfo":{"status":"ok","timestamp":1705043136767,"user_tz":-180,"elapsed":912,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":14,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Invoice        0\n","StockCode      0\n","Description    0\n","Quantity       0\n","InvoiceDate    0\n","Price          0\n","Customer ID    0\n","Country        0\n","TotalPrice     0\n","dtype: int64"]},"metadata":{},"execution_count":14}]},{"cell_type":"code","source":["df.describe().T # gördüğünüz üzere min, max sütunlarımızda eksili değerler var. bunlar iade edilen ürünlerden kaynaklıdır.\n","                # dolayısıyla onlar kaldırmamız gerekir"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":175},"id":"4vSiLIsVMd5y","executionInfo":{"status":"ok","timestamp":1705043138521,"user_tz":-180,"elapsed":12,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}},"outputId":"3ff95ee0-89aa-4e29-cb14-f7a32ae971e3"},"execution_count":15,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                 count      mean      std        min       25%       50%       75%       max\n","Quantity    417534.000    12.759  101.220  -9360.000     2.000     4.000    12.000 19152.000\n","Price       417534.000     3.888   71.132      0.000     1.250     1.950     3.750 25111.090\n","Customer ID 417534.000 15360.645 1680.811  12346.000 13983.000 15311.000 16799.000 18287.000\n","TotalPrice  417534.000    19.994   99.916 -25111.090     4.250    11.250    19.350 15818.400"],"text/html":["\n","  <div id=\"df-b995c71a-e08b-4f05-a394-fa408ddb6b6d\" class=\"colab-df-container\">\n","    <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>count</th>\n","      <th>mean</th>\n","      <th>std</th>\n","      <th>min</th>\n","      <th>25%</th>\n","      <th>50%</th>\n","      <th>75%</th>\n","      <th>max</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>Quantity</th>\n","      <td>417534.000</td>\n","      <td>12.759</td>\n","      <td>101.220</td>\n","      <td>-9360.000</td>\n","      <td>2.000</td>\n","      <td>4.000</td>\n","      <td>12.000</td>\n","      <td>19152.000</td>\n","    </tr>\n","    <tr>\n","      <th>Price</th>\n","      <td>417534.000</td>\n","      <td>3.888</td>\n","      <td>71.132</td>\n","      <td>0.000</td>\n","      <td>1.250</td>\n","      <td>1.950</td>\n","      <td>3.750</td>\n","      <td>25111.090</td>\n","    </tr>\n","    <tr>\n","      <th>Customer ID</th>\n","      <td>417534.000</td>\n","      <td>15360.645</td>\n","      <td>1680.811</td>\n","      <td>12346.000</td>\n","      <td>13983.000</td>\n","      <td>15311.000</td>\n","      <td>16799.000</td>\n","      <td>18287.000</td>\n","    </tr>\n","    <tr>\n","      <th>TotalPrice</th>\n","      <td>417534.000</td>\n","      <td>19.994</td>\n","      <td>99.916</td>\n","      <td>-25111.090</td>\n","      <td>4.250</td>\n","      <td>11.250</td>\n","      <td>19.350</td>\n","      <td>15818.400</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b995c71a-e08b-4f05-a394-fa408ddb6b6d')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-b995c71a-e08b-4f05-a394-fa408ddb6b6d button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-b995c71a-e08b-4f05-a394-fa408ddb6b6d');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-bdb4c184-8813-4d27-9675-4be8135467c8\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-bdb4c184-8813-4d27-9675-4be8135467c8')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-bdb4c184-8813-4d27-9675-4be8135467c8 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":15}]},{"cell_type":"code","source":["df = df[~df[\"Invoice\"].str.contains(\"C\",na=False)]"],"metadata":{"id":"X7hJEKLLsXcQ","executionInfo":{"status":"ok","timestamp":1705043141504,"user_tz":-180,"elapsed":1216,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":16,"outputs":[]},{"cell_type":"code","source":["df[\"InvoiceDate\"].max() # en son satın alınan tarihi belirleriz.\n","                        # daha sonrasında üzerine 1-2 gün koyarak analiz tarihi sanki o günde yapılıyormuşcasına düşünürüz."],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"Ir_yyRNssvPt","outputId":"d2fd9398-ee0a-4225-fbf3-18e802f6643e","executionInfo":{"status":"ok","timestamp":1705043142967,"user_tz":-180,"elapsed":12,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":17,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Timestamp('2010-12-09 20:01:00')"]},"metadata":{},"execution_count":17}]},{"cell_type":"code","source":["today_date = dt.datetime(2010,12,11)\n","today_date"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"XXf6DbRetrGr","outputId":"6a2175b0-bbf2-412d-f523-7c6ce78da58d","executionInfo":{"status":"ok","timestamp":1705043145909,"user_tz":-180,"elapsed":520,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":18,"outputs":[{"output_type":"execute_result","data":{"text/plain":["datetime.datetime(2010, 12, 11, 0, 0)"]},"metadata":{},"execution_count":18}]},{"cell_type":"markdown","source":["### Calculating RFM Metrics"],"metadata":{"id":"6CVZnRLdy7HI"}},{"cell_type":"code","source":["rfm = df.groupby([\"Customer ID\"]).agg({'InvoiceDate':lambda InvoiceDate: (today_date - InvoiceDate.max()).days,\n","                                       'Invoice': lambda Invoice: Invoice.nunique(),\n","                                       'TotalPrice': lambda TotalPrice: TotalPrice.sum()})\n","rfm.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":237},"id":"_eE9QugxvxRf","outputId":"29d61fb9-65e7-4e23-a504-fa79d0b68361","executionInfo":{"status":"ok","timestamp":1705043150880,"user_tz":-180,"elapsed":1975,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":19,"outputs":[{"output_type":"execute_result","data":{"text/plain":["             InvoiceDate  Invoice  TotalPrice\n","Customer ID                                  \n","12346.000            165       11     372.860\n","12347.000              3        2    1323.320\n","12348.000             74        1     222.160\n","12349.000             43        3    2671.140\n","12351.000             11        1     300.930"],"text/html":["\n","  <div id=\"df-1ffc481d-54e5-446e-9c68-258cab846f5a\" class=\"colab-df-container\">\n","    <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>InvoiceDate</th>\n","      <th>Invoice</th>\n","      <th>TotalPrice</th>\n","    </tr>\n","    <tr>\n","      <th>Customer ID</th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>12346.000</th>\n","      <td>165</td>\n","      <td>11</td>\n","      <td>372.860</td>\n","    </tr>\n","    <tr>\n","      <th>12347.000</th>\n","      <td>3</td>\n","      <td>2</td>\n","      <td>1323.320</td>\n","    </tr>\n","    <tr>\n","      <th>12348.000</th>\n","      <td>74</td>\n","      <td>1</td>\n","      <td>222.160</td>\n","    </tr>\n","    <tr>\n","      <th>12349.000</th>\n","      <td>43</td>\n","      <td>3</td>\n","      <td>2671.140</td>\n","    </tr>\n","    <tr>\n","      <th>12351.000</th>\n","      <td>11</td>\n","      <td>1</td>\n","      <td>300.930</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1ffc481d-54e5-446e-9c68-258cab846f5a')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-1ffc481d-54e5-446e-9c68-258cab846f5a button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-1ffc481d-54e5-446e-9c68-258cab846f5a');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-8e47d14e-13f9-41de-a9eb-5e40a4a7cb24\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-8e47d14e-13f9-41de-a9eb-5e40a4a7cb24')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-8e47d14e-13f9-41de-a9eb-5e40a4a7cb24 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":19}]},{"cell_type":"code","source":["rfm.columns = [\"recency\",\"frequency\",\"monetary\"]"],"metadata":{"id":"mKPg1rKjwipN","executionInfo":{"status":"ok","timestamp":1705043152460,"user_tz":-180,"elapsed":4,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":20,"outputs":[]},{"cell_type":"code","source":["rfm.describe().T"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":143},"id":"m5LkT6_cxQ7R","outputId":"750cd7a3-cacb-4938-8754-0eb6aaa41ec6","executionInfo":{"status":"ok","timestamp":1705043154068,"user_tz":-180,"elapsed":21,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":21,"outputs":[{"output_type":"execute_result","data":{"text/plain":["             count     mean      std   min     25%     50%      75%        max\n","recency   4314.000   91.270   96.944 1.000  18.000  53.000  136.000    374.000\n","frequency 4314.000    4.454    8.169 1.000   1.000   2.000    5.000    205.000\n","monetary  4314.000 2047.289 8912.523 0.000 307.950 705.550 1722.802 349164.350"],"text/html":["\n","  <div id=\"df-b9feeb5a-4c66-4469-990e-94286bd74d1e\" class=\"colab-df-container\">\n","    <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>count</th>\n","      <th>mean</th>\n","      <th>std</th>\n","      <th>min</th>\n","      <th>25%</th>\n","      <th>50%</th>\n","      <th>75%</th>\n","      <th>max</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>recency</th>\n","      <td>4314.000</td>\n","      <td>91.270</td>\n","      <td>96.944</td>\n","      <td>1.000</td>\n","      <td>18.000</td>\n","      <td>53.000</td>\n","      <td>136.000</td>\n","      <td>374.000</td>\n","    </tr>\n","    <tr>\n","      <th>frequency</th>\n","      <td>4314.000</td>\n","      <td>4.454</td>\n","      <td>8.169</td>\n","      <td>1.000</td>\n","      <td>1.000</td>\n","      <td>2.000</td>\n","      <td>5.000</td>\n","      <td>205.000</td>\n","    </tr>\n","    <tr>\n","      <th>monetary</th>\n","      <td>4314.000</td>\n","      <td>2047.289</td>\n","      <td>8912.523</td>\n","      <td>0.000</td>\n","      <td>307.950</td>\n","      <td>705.550</td>\n","      <td>1722.802</td>\n","      <td>349164.350</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b9feeb5a-4c66-4469-990e-94286bd74d1e')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-b9feeb5a-4c66-4469-990e-94286bd74d1e button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-b9feeb5a-4c66-4469-990e-94286bd74d1e');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-049f37e1-8aac-4b0f-86c0-98d5c5340cc9\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-049f37e1-8aac-4b0f-86c0-98d5c5340cc9')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-049f37e1-8aac-4b0f-86c0-98d5c5340cc9 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":21}]},{"cell_type":"code","source":["rfm = rfm[rfm[\"monetary\"]>0] # monetary değeri sıfırdan fazla olanları rfm analizine dahil etmemiz daha mantıklı olacaktır."],"metadata":{"id":"hrhjt_6BxSkD","executionInfo":{"status":"ok","timestamp":1705043157948,"user_tz":-180,"elapsed":362,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":22,"outputs":[]},{"cell_type":"code","source":["rfm.describe().T"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":143},"id":"z7FlYxNWxXAT","outputId":"f59bf5a3-edf1-4124-fa96-f89f96eba97d","executionInfo":{"status":"ok","timestamp":1705043159580,"user_tz":-180,"elapsed":14,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":23,"outputs":[{"output_type":"execute_result","data":{"text/plain":["             count     mean      std   min     25%     50%      75%        max\n","recency   4312.000   91.173   96.861 1.000  18.000  53.000  136.000    374.000\n","frequency 4312.000    4.456    8.170 1.000   1.000   2.000    5.000    205.000\n","monetary  4312.000 2048.238 8914.481 2.950 307.988 706.020 1723.142 349164.350"],"text/html":["\n","  <div id=\"df-935f364d-eaa4-45e1-9188-699d5095f2bf\" class=\"colab-df-container\">\n","    <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>count</th>\n","      <th>mean</th>\n","      <th>std</th>\n","      <th>min</th>\n","      <th>25%</th>\n","      <th>50%</th>\n","      <th>75%</th>\n","      <th>max</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>recency</th>\n","      <td>4312.000</td>\n","      <td>91.173</td>\n","      <td>96.861</td>\n","      <td>1.000</td>\n","      <td>18.000</td>\n","      <td>53.000</td>\n","      <td>136.000</td>\n","      <td>374.000</td>\n","    </tr>\n","    <tr>\n","      <th>frequency</th>\n","      <td>4312.000</td>\n","      <td>4.456</td>\n","      <td>8.170</td>\n","      <td>1.000</td>\n","      <td>1.000</td>\n","      <td>2.000</td>\n","      <td>5.000</td>\n","      <td>205.000</td>\n","    </tr>\n","    <tr>\n","      <th>monetary</th>\n","      <td>4312.000</td>\n","      <td>2048.238</td>\n","      <td>8914.481</td>\n","      <td>2.950</td>\n","      <td>307.988</td>\n","      <td>706.020</td>\n","      <td>1723.142</td>\n","      <td>349164.350</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-935f364d-eaa4-45e1-9188-699d5095f2bf')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-935f364d-eaa4-45e1-9188-699d5095f2bf button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-935f364d-eaa4-45e1-9188-699d5095f2bf');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-baab5186-a4ed-43a9-bda4-7cc19662cd7f\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-baab5186-a4ed-43a9-bda4-7cc19662cd7f')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-baab5186-a4ed-43a9-bda4-7cc19662cd7f button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":23}]},{"cell_type":"code","source":["rfm.shape # 4312 müşterinin Recency, Frequency ve Monetary değerlerini gösteriyor"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"m8u-apUxzdW3","executionInfo":{"status":"ok","timestamp":1705043161664,"user_tz":-180,"elapsed":709,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}},"outputId":"c2521484-df2b-447d-deec-7a6e968a3ce8"},"execution_count":24,"outputs":[{"output_type":"execute_result","data":{"text/plain":["(4312, 3)"]},"metadata":{},"execution_count":24}]},{"cell_type":"markdown","source":["### Calculating RFM Scores"],"metadata":{"id":"No5NDPfzzJsG"}},{"cell_type":"code","source":["rfm[\"recency_score\"] = pd.qcut(rfm[\"recency\"],5,labels=[5,4,3,2,1])"],"metadata":{"id":"jFcKGP_gxdef","executionInfo":{"status":"ok","timestamp":1705043164774,"user_tz":-180,"elapsed":488,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":25,"outputs":[]},{"cell_type":"code","source":["# rank burada ne işe yarıyor? örneğin birden fazla aralık aynı yere denk geldiği için ilk gördüğünü sınıfa atasın anlamına geliyor.\n","# örnek 5 parçaya bölmüşüz ilk parçaya 1 ler var ikinci parçayada denk gelcek şekilde birler var bu ilk gördüğü birleri birinci sınıfa diğerlerini ikinci sınıfa atasın anlamındadır.\n","rfm[\"frequency_score\"] = pd.qcut(rfm[\"frequency\"].rank(method=\"first\"),5,labels=[1,2,3,4,5])"],"metadata":{"id":"Tc1HF4qW0pss","executionInfo":{"status":"ok","timestamp":1705043165989,"user_tz":-180,"elapsed":4,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":26,"outputs":[]},{"cell_type":"code","source":["rfm[\"monetary_score\"] = pd.qcut(rfm[\"monetary\"],5,labels=[1,2,3,4,5])"],"metadata":{"id":"SXWwYXwPz_HV","executionInfo":{"status":"ok","timestamp":1705043167664,"user_tz":-180,"elapsed":7,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":27,"outputs":[]},{"cell_type":"code","source":["rfm[\"RFM_SCORE\"] = rfm[\"recency_score\"].astype(str) + rfm[\"frequency_score\"].astype(str)"],"metadata":{"id":"kYHTbZOU1v4E","executionInfo":{"status":"ok","timestamp":1705043169272,"user_tz":-180,"elapsed":4,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":28,"outputs":[]},{"cell_type":"code","source":["rfm.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":237},"id":"cs5jypGH1uBW","outputId":"5819eec4-e1fb-4d25-b72b-555f65a7d232","executionInfo":{"status":"ok","timestamp":1705043170830,"user_tz":-180,"elapsed":14,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":29,"outputs":[{"output_type":"execute_result","data":{"text/plain":["             recency  frequency  monetary recency_score frequency_score monetary_score RFM_SCORE\n","Customer ID                                                                                     \n","12346.000        165         11   372.860             2               5              2        25\n","12347.000          3          2  1323.320             5               2              4        52\n","12348.000         74          1   222.160             2               1              1        21\n","12349.000         43          3  2671.140             3               3              5        33\n","12351.000         11          1   300.930             5               1              2        51"],"text/html":["\n","  <div id=\"df-5eb2f5fd-fa0d-4870-9447-ee2e49a86f5e\" class=\"colab-df-container\">\n","    <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>recency</th>\n","      <th>frequency</th>\n","      <th>monetary</th>\n","      <th>recency_score</th>\n","      <th>frequency_score</th>\n","      <th>monetary_score</th>\n","      <th>RFM_SCORE</th>\n","    </tr>\n","    <tr>\n","      <th>Customer ID</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>12346.000</th>\n","      <td>165</td>\n","      <td>11</td>\n","      <td>372.860</td>\n","      <td>2</td>\n","      <td>5</td>\n","      <td>2</td>\n","      <td>25</td>\n","    </tr>\n","    <tr>\n","      <th>12347.000</th>\n","      <td>3</td>\n","      <td>2</td>\n","      <td>1323.320</td>\n","      <td>5</td>\n","      <td>2</td>\n","      <td>4</td>\n","      <td>52</td>\n","    </tr>\n","    <tr>\n","      <th>12348.000</th>\n","      <td>74</td>\n","      <td>1</td>\n","      <td>222.160</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>21</td>\n","    </tr>\n","    <tr>\n","      <th>12349.000</th>\n","      <td>43</td>\n","      <td>3</td>\n","      <td>2671.140</td>\n","      <td>3</td>\n","      <td>3</td>\n","      <td>5</td>\n","      <td>33</td>\n","    </tr>\n","    <tr>\n","      <th>12351.000</th>\n","      <td>11</td>\n","      <td>1</td>\n","      <td>300.930</td>\n","      <td>5</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>51</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5eb2f5fd-fa0d-4870-9447-ee2e49a86f5e')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-5eb2f5fd-fa0d-4870-9447-ee2e49a86f5e button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-5eb2f5fd-fa0d-4870-9447-ee2e49a86f5e');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-94f53ae8-073e-4787-b45c-1dbaf673898b\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-94f53ae8-073e-4787-b45c-1dbaf673898b')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-94f53ae8-073e-4787-b45c-1dbaf673898b button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":29}]},{"cell_type":"code","source":["rfm[rfm[\"RFM_SCORE\"] == \"55\"] # şampiyonlar grubunu gözlemledik"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":455},"id":"JPREgl474qoq","executionInfo":{"status":"ok","timestamp":1705043173269,"user_tz":-180,"elapsed":531,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}},"outputId":"4b3b2d53-b8ab-4107-c2d7-1fda676bfc48"},"execution_count":30,"outputs":[{"output_type":"execute_result","data":{"text/plain":["             recency  frequency  monetary recency_score frequency_score monetary_score RFM_SCORE\n","Customer ID                                                                                     \n","12415.000         11          7 19543.840             5               5              5        55\n","12431.000          9         13  4370.520             5               5              5        55\n","12471.000         10         49 20139.740             5               5              5        55\n","12472.000          5         13 11308.480             5               5              5        55\n","12474.000         14         13  5048.660             5               5              5        55\n","...              ...        ...       ...           ...             ...            ...       ...\n","18225.000          1         15  7545.140             5               5              5        55\n","18226.000         14         15  6650.830             5               5              5        55\n","18229.000          2         10  3526.810             5               5              5        55\n","18245.000         15         13  3757.920             5               5              5        55\n","18260.000         10         17  7318.910             5               5              5        55\n","\n","[457 rows x 7 columns]"],"text/html":["\n","  <div id=\"df-3e63c5e5-f819-4df7-9ce1-f43660daf416\" class=\"colab-df-container\">\n","    <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>recency</th>\n","      <th>frequency</th>\n","      <th>monetary</th>\n","      <th>recency_score</th>\n","      <th>frequency_score</th>\n","      <th>monetary_score</th>\n","      <th>RFM_SCORE</th>\n","    </tr>\n","    <tr>\n","      <th>Customer ID</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>12415.000</th>\n","      <td>11</td>\n","      <td>7</td>\n","      <td>19543.840</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>55</td>\n","    </tr>\n","    <tr>\n","      <th>12431.000</th>\n","      <td>9</td>\n","      <td>13</td>\n","      <td>4370.520</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>55</td>\n","    </tr>\n","    <tr>\n","      <th>12471.000</th>\n","      <td>10</td>\n","      <td>49</td>\n","      <td>20139.740</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>55</td>\n","    </tr>\n","    <tr>\n","      <th>12472.000</th>\n","      <td>5</td>\n","      <td>13</td>\n","      <td>11308.480</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>55</td>\n","    </tr>\n","    <tr>\n","      <th>12474.000</th>\n","      <td>14</td>\n","      <td>13</td>\n","      <td>5048.660</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>55</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","    </tr>\n","    <tr>\n","      <th>18225.000</th>\n","      <td>1</td>\n","      <td>15</td>\n","      <td>7545.140</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>55</td>\n","    </tr>\n","    <tr>\n","      <th>18226.000</th>\n","      <td>14</td>\n","      <td>15</td>\n","      <td>6650.830</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>55</td>\n","    </tr>\n","    <tr>\n","      <th>18229.000</th>\n","      <td>2</td>\n","      <td>10</td>\n","      <td>3526.810</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>55</td>\n","    </tr>\n","    <tr>\n","      <th>18245.000</th>\n","      <td>15</td>\n","      <td>13</td>\n","      <td>3757.920</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>55</td>\n","    </tr>\n","    <tr>\n","      <th>18260.000</th>\n","      <td>10</td>\n","      <td>17</td>\n","      <td>7318.910</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>55</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>457 rows × 7 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3e63c5e5-f819-4df7-9ce1-f43660daf416')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-3e63c5e5-f819-4df7-9ce1-f43660daf416 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-3e63c5e5-f819-4df7-9ce1-f43660daf416');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-a01f0c49-083c-4a5d-baf5-6f57dc60b7d7\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-a01f0c49-083c-4a5d-baf5-6f57dc60b7d7')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-a01f0c49-083c-4a5d-baf5-6f57dc60b7d7 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":30}]},{"cell_type":"code","source":["rfm[rfm['RFM_SCORE'] == \"11\"] # kaybedebileceğimiz grup"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":455},"id":"hQMCDhXU43Te","executionInfo":{"status":"ok","timestamp":1705043174776,"user_tz":-180,"elapsed":16,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}},"outputId":"715f646a-d6ec-4df1-e32c-e7d4e5b98609"},"execution_count":31,"outputs":[{"output_type":"execute_result","data":{"text/plain":["             recency  frequency  monetary recency_score frequency_score monetary_score RFM_SCORE\n","Customer ID                                                                                     \n","12355.000        203          1   488.210             1               1              2        11\n","12362.000        374          1   130.000             1               1              1        11\n","12366.000        269          1   500.240             1               1              2        11\n","12368.000        264          1   917.700             1               1              3        11\n","12378.000        198          1  1407.700             1               1              4        11\n","...              ...        ...       ...           ...             ...            ...       ...\n","15928.000        292          1   293.530             1               1              2        11\n","15929.000        280          1   594.000             1               1              3        11\n","15941.000        273          1   405.000             1               1              2        11\n","15954.000        225          1   190.750             1               1              1        11\n","15964.000        299          1   272.960             1               1              2        11\n","\n","[358 rows x 7 columns]"],"text/html":["\n","  <div id=\"df-cee340cb-8d4d-42ae-b486-451897c95644\" class=\"colab-df-container\">\n","    <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>recency</th>\n","      <th>frequency</th>\n","      <th>monetary</th>\n","      <th>recency_score</th>\n","      <th>frequency_score</th>\n","      <th>monetary_score</th>\n","      <th>RFM_SCORE</th>\n","    </tr>\n","    <tr>\n","      <th>Customer ID</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>12355.000</th>\n","      <td>203</td>\n","      <td>1</td>\n","      <td>488.210</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>11</td>\n","    </tr>\n","    <tr>\n","      <th>12362.000</th>\n","      <td>374</td>\n","      <td>1</td>\n","      <td>130.000</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>11</td>\n","    </tr>\n","    <tr>\n","      <th>12366.000</th>\n","      <td>269</td>\n","      <td>1</td>\n","      <td>500.240</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>11</td>\n","    </tr>\n","    <tr>\n","      <th>12368.000</th>\n","      <td>264</td>\n","      <td>1</td>\n","      <td>917.700</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>3</td>\n","      <td>11</td>\n","    </tr>\n","    <tr>\n","      <th>12378.000</th>\n","      <td>198</td>\n","      <td>1</td>\n","      <td>1407.700</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>4</td>\n","      <td>11</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","    </tr>\n","    <tr>\n","      <th>15928.000</th>\n","      <td>292</td>\n","      <td>1</td>\n","      <td>293.530</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>11</td>\n","    </tr>\n","    <tr>\n","      <th>15929.000</th>\n","      <td>280</td>\n","      <td>1</td>\n","      <td>594.000</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>3</td>\n","      <td>11</td>\n","    </tr>\n","    <tr>\n","      <th>15941.000</th>\n","      <td>273</td>\n","      <td>1</td>\n","      <td>405.000</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>11</td>\n","    </tr>\n","    <tr>\n","      <th>15954.000</th>\n","      <td>225</td>\n","      <td>1</td>\n","      <td>190.750</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>11</td>\n","    </tr>\n","    <tr>\n","      <th>15964.000</th>\n","      <td>299</td>\n","      <td>1</td>\n","      <td>272.960</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>11</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>358 rows × 7 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-cee340cb-8d4d-42ae-b486-451897c95644')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-cee340cb-8d4d-42ae-b486-451897c95644 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-cee340cb-8d4d-42ae-b486-451897c95644');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-ba3c9d16-1231-47aa-b9c0-e35369d016c4\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ba3c9d16-1231-47aa-b9c0-e35369d016c4')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-ba3c9d16-1231-47aa-b9c0-e35369d016c4 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":31}]},{"cell_type":"markdown","source":["### Set RFM Names"],"metadata":{"id":"N3DNNmkZuj35"}},{"cell_type":"code","source":["seg_map = {\n","    r'[1-2][1-2]': 'hibernating',\n","    r'[1-2][3-4]': 'at_risk',\n","    r'[1-2]5': 'cant_loose',\n","    r'3[1-2]': 'about_to_sleep',\n","    r'33': 'need_to_attention',\n","    r'[3-4][4-5]': 'loyal_customers',\n","    r'41': 'promising',\n","    r'51': 'new_customers',\n","    r'[4-5][2-3]': 'potential_loaylists',\n","    r'5[4-5]': 'champions'\n","}\n","\n","rfm[\"segment\"] = rfm[\"RFM_SCORE\"].replace(seg_map,regex=True)\n","rfm.head()"],"metadata":{"id":"3U4qk0VG2gEE","colab":{"base_uri":"https://localhost:8080/","height":237},"outputId":"fdc35a56-e191-4cef-d6de-d2c4a033ffb4","executionInfo":{"status":"ok","timestamp":1705043181415,"user_tz":-180,"elapsed":389,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":32,"outputs":[{"output_type":"execute_result","data":{"text/plain":["             recency  frequency  monetary recency_score frequency_score monetary_score RFM_SCORE              segment\n","Customer ID                                                                                                          \n","12346.000        165         11   372.860             2               5              2        25           cant_loose\n","12347.000          3          2  1323.320             5               2              4        52  potential_loaylists\n","12348.000         74          1   222.160             2               1              1        21          hibernating\n","12349.000         43          3  2671.140             3               3              5        33    need_to_attention\n","12351.000         11          1   300.930             5               1              2        51        new_customers"],"text/html":["\n","  <div id=\"df-52609361-0708-4884-9100-92d50ef184a4\" class=\"colab-df-container\">\n","    <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>recency</th>\n","      <th>frequency</th>\n","      <th>monetary</th>\n","      <th>recency_score</th>\n","      <th>frequency_score</th>\n","      <th>monetary_score</th>\n","      <th>RFM_SCORE</th>\n","      <th>segment</th>\n","    </tr>\n","    <tr>\n","      <th>Customer ID</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>12346.000</th>\n","      <td>165</td>\n","      <td>11</td>\n","      <td>372.860</td>\n","      <td>2</td>\n","      <td>5</td>\n","      <td>2</td>\n","      <td>25</td>\n","      <td>cant_loose</td>\n","    </tr>\n","    <tr>\n","      <th>12347.000</th>\n","      <td>3</td>\n","      <td>2</td>\n","      <td>1323.320</td>\n","      <td>5</td>\n","      <td>2</td>\n","      <td>4</td>\n","      <td>52</td>\n","      <td>potential_loaylists</td>\n","    </tr>\n","    <tr>\n","      <th>12348.000</th>\n","      <td>74</td>\n","      <td>1</td>\n","      <td>222.160</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>21</td>\n","      <td>hibernating</td>\n","    </tr>\n","    <tr>\n","      <th>12349.000</th>\n","      <td>43</td>\n","      <td>3</td>\n","      <td>2671.140</td>\n","      <td>3</td>\n","      <td>3</td>\n","      <td>5</td>\n","      <td>33</td>\n","      <td>need_to_attention</td>\n","    </tr>\n","    <tr>\n","      <th>12351.000</th>\n","      <td>11</td>\n","      <td>1</td>\n","      <td>300.930</td>\n","      <td>5</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>51</td>\n","      <td>new_customers</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-52609361-0708-4884-9100-92d50ef184a4')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-52609361-0708-4884-9100-92d50ef184a4 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-52609361-0708-4884-9100-92d50ef184a4');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-c5cd09cd-8459-4948-a815-cf9dce1dd26f\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-c5cd09cd-8459-4948-a815-cf9dce1dd26f')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-c5cd09cd-8459-4948-a815-cf9dce1dd26f button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":32}]},{"cell_type":"code","source":["rfm[[\"segment\",\"recency\",\"frequency\",\"monetary\"]].groupby([\"segment\"]).agg([\"mean\",\"count\"])"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":426},"id":"--SY0ztzw1hw","outputId":"b1eafd49-34b4-458b-a761-c92ff59bc46c","executionInfo":{"status":"ok","timestamp":1705043184410,"user_tz":-180,"elapsed":510,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":33,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                    recency       frequency       monetary      \n","                       mean count      mean count     mean count\n","segment                                                         \n","about_to_sleep       53.819   343     1.201   343  441.320   343\n","at_risk             152.159   611     3.074   611 1188.878   611\n","cant_loose          124.117    77     9.117    77 4099.450    77\n","champions             7.119   663    12.554   663 6852.264   663\n","hibernating         213.886  1015     1.126  1015  403.978  1015\n","loyal_customers      36.287   742     6.830   742 2746.067   742\n","need_to_attention    53.266   207     2.449   207 1060.357   207\n","new_customers         8.580    50     1.000    50  386.199    50\n","potential_loaylists  18.793   517     2.017   517  729.511   517\n","promising            25.747    87     1.000    87  367.087    87"],"text/html":["\n","  <div id=\"df-b9808a73-b0f4-4f4e-abda-e89b655103b8\" class=\"colab-df-container\">\n","    <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 tr th {\n","        text-align: left;\n","    }\n","\n","    .dataframe thead tr:last-of-type th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr>\n","      <th></th>\n","      <th colspan=\"2\" halign=\"left\">recency</th>\n","      <th colspan=\"2\" halign=\"left\">frequency</th>\n","      <th colspan=\"2\" halign=\"left\">monetary</th>\n","    </tr>\n","    <tr>\n","      <th></th>\n","      <th>mean</th>\n","      <th>count</th>\n","      <th>mean</th>\n","      <th>count</th>\n","      <th>mean</th>\n","      <th>count</th>\n","    </tr>\n","    <tr>\n","      <th>segment</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>about_to_sleep</th>\n","      <td>53.819</td>\n","      <td>343</td>\n","      <td>1.201</td>\n","      <td>343</td>\n","      <td>441.320</td>\n","      <td>343</td>\n","    </tr>\n","    <tr>\n","      <th>at_risk</th>\n","      <td>152.159</td>\n","      <td>611</td>\n","      <td>3.074</td>\n","      <td>611</td>\n","      <td>1188.878</td>\n","      <td>611</td>\n","    </tr>\n","    <tr>\n","      <th>cant_loose</th>\n","      <td>124.117</td>\n","      <td>77</td>\n","      <td>9.117</td>\n","      <td>77</td>\n","      <td>4099.450</td>\n","      <td>77</td>\n","    </tr>\n","    <tr>\n","      <th>champions</th>\n","      <td>7.119</td>\n","      <td>663</td>\n","      <td>12.554</td>\n","      <td>663</td>\n","      <td>6852.264</td>\n","      <td>663</td>\n","    </tr>\n","    <tr>\n","      <th>hibernating</th>\n","      <td>213.886</td>\n","      <td>1015</td>\n","      <td>1.126</td>\n","      <td>1015</td>\n","      <td>403.978</td>\n","      <td>1015</td>\n","    </tr>\n","    <tr>\n","      <th>loyal_customers</th>\n","      <td>36.287</td>\n","      <td>742</td>\n","      <td>6.830</td>\n","      <td>742</td>\n","      <td>2746.067</td>\n","      <td>742</td>\n","    </tr>\n","    <tr>\n","      <th>need_to_attention</th>\n","      <td>53.266</td>\n","      <td>207</td>\n","      <td>2.449</td>\n","      <td>207</td>\n","      <td>1060.357</td>\n","      <td>207</td>\n","    </tr>\n","    <tr>\n","      <th>new_customers</th>\n","      <td>8.580</td>\n","      <td>50</td>\n","      <td>1.000</td>\n","      <td>50</td>\n","      <td>386.199</td>\n","      <td>50</td>\n","    </tr>\n","    <tr>\n","      <th>potential_loaylists</th>\n","      <td>18.793</td>\n","      <td>517</td>\n","      <td>2.017</td>\n","      <td>517</td>\n","      <td>729.511</td>\n","      <td>517</td>\n","    </tr>\n","    <tr>\n","      <th>promising</th>\n","      <td>25.747</td>\n","      <td>87</td>\n","      <td>1.000</td>\n","      <td>87</td>\n","      <td>367.087</td>\n","      <td>87</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b9808a73-b0f4-4f4e-abda-e89b655103b8')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-b9808a73-b0f4-4f4e-abda-e89b655103b8 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-b9808a73-b0f4-4f4e-abda-e89b655103b8');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-3af30e7b-55cc-461b-8278-ffca94abd40d\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-3af30e7b-55cc-461b-8278-ffca94abd40d')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-3af30e7b-55cc-461b-8278-ffca94abd40d button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":33}]},{"cell_type":"code","source":["new_df = pd.DataFrame()\n","new_df[\"new_customer_id\"] = rfm[rfm[\"segment\"] == \"new_customers\"].index\n","new_df[\"new_customer_id\"] = new_df[\"new_customer_id\"].astype(int)"],"metadata":{"id":"Se6uWo8NxYBH","executionInfo":{"status":"ok","timestamp":1705043750275,"user_tz":-180,"elapsed":525,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":34,"outputs":[]},{"cell_type":"code","source":["new_df.to_csv(\"new_customers.csv\")"],"metadata":{"id":"_-LwWJXUzEBQ","executionInfo":{"status":"ok","timestamp":1705043759388,"user_tz":-180,"elapsed":509,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":35,"outputs":[]},{"cell_type":"code","source":["rfm.to_csv(\"rfm.csv\")"],"metadata":{"id":"Cj_siAHXznQK","executionInfo":{"status":"ok","timestamp":1705043761560,"user_tz":-180,"elapsed":529,"user":{"displayName":"tohid yousefi","userId":"09164737776488206070"}}},"execution_count":36,"outputs":[]},{"cell_type":"markdown","source":["## writing the all process as a single function"],"metadata":{"id":"3RoKGwGNGrUR"}},{"cell_type":"code","source":["def create_rfm(dataframe,csv=False):\n","  # Data Preprocessing\n","  dataframe[\"TotalPrice\"] = dataframe[\"Quantity\"] * dataframe[\"Price\"]\n","  dataframe.dropna(inplace=True)\n","  dataframe = dataframe[~dataframe[\"Invoice\"].str.contains(\"C\",na=False)]\n","  dataframe = dataframe[(dataframe[\"Quantity\"] > 0)]\n","\n","  # Calculating RFM Metrics\n","  today_date = dt.datetime(2011,12,11)\n","  rfm = dataframe.groupby([\"Customer ID\"]).agg({'InvoiceDate': lambda InvoiceDate: (today_date - InvoiceDate.max()).days,\n","                                                'Invoice': lambda Invoice: Invoice.nunique(),\n","                                                'TotalPrice': lambda TotalPrice: TotalPrice.sum()})\n","  rfm.columns = [\"recency\",\"frequency\",\"monetary\"]\n","  rfm = rfm[rfm[\"monetary\"]>0]\n","\n","  # Calculating RFM Scores\n","  rfm[\"recency_score\"] = pd.qcut(rfm[\"recency\"],5,labels=[5,4,3,2,1])\n","  rfm[\"frequency_score\"] = pd.qcut(rfm[\"frequency\"].rank(method=\"first\"),5,labels=[1,2,3,4,5])\n","  rfm[\"monetary_score\"] = pd.qcut(rfm[\"monetary\"],5,labels=[1,2,3,4,5])\n","  rfm[\"RFM_SCORE\"] = rfm[\"recency_score\"].astype(str) + rfm[\"frequency_score\"].astype(str)\n","\n","  # Set RFM Names\n","  seg_map = {\n","    r'[1-2][1-2]': 'hibernating',\n","    r'[1-2][3-4]': 'at_risk',\n","    r'[1-2]5': 'cant_loose',\n","    r'3[1-2]': 'about_to_sleep',\n","    r'33': 'need_to_attention',\n","    r'[3-4][4-5]': 'loyal_customers',\n","    r'41': 'promising',\n","    r'51': 'new_customers',\n","    r'[4-5][2-3]': 'potential_loaylists',\n","    r'5[4-5]': 'champions'\n","  }\n","  rfm[\"segment\"] = rfm[\"RFM_SCORE\"].replace(seg_map,regex=True)\n","  rfm.index = rfm.index.astype(int)\n","\n","  # Save Results to CSV File\n","  if csv:\n","    rfm.to_csv(\"rfm.csv\")\n","\n","  return rfm"],"metadata":{"id":"RnWOcF3108xd"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["df = online_retail.copy()\n","df.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"QjT_6RuyLifX","outputId":"42cf4e96-6bc6-4287-ee1c-2e486f345d7d"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["  Invoice StockCode                          Description  Quantity         InvoiceDate  Price  Customer ID         Country\n","0  489434     85048  15CM CHRISTMAS GLASS BALL 20 LIGHTS        12 2009-12-01 07:45:00  6.950    13085.000  United Kingdom\n","1  489434    79323P                   PINK CHERRY LIGHTS        12 2009-12-01 07:45:00  6.750    13085.000  United Kingdom\n","2  489434    79323W                  WHITE CHERRY LIGHTS        12 2009-12-01 07:45:00  6.750    13085.000  United Kingdom\n","3  489434     22041         RECORD FRAME 7\" SINGLE SIZE         48 2009-12-01 07:45:00  2.100    13085.000  United Kingdom\n","4  489434     21232       STRAWBERRY CERAMIC TRINKET BOX        24 2009-12-01 07:45:00  1.250    13085.000  United Kingdom"],"text/html":["\n","  <div id=\"df-bfc41746-3493-4c0c-ae96-3857c482e551\">\n","    <div class=\"colab-df-container\">\n","      <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>Invoice</th>\n","      <th>StockCode</th>\n","      <th>Description</th>\n","      <th>Quantity</th>\n","      <th>InvoiceDate</th>\n","      <th>Price</th>\n","      <th>Customer ID</th>\n","      <th>Country</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>489434</td>\n","      <td>85048</td>\n","      <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n","      <td>12</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>6.950</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>489434</td>\n","      <td>79323P</td>\n","      <td>PINK CHERRY LIGHTS</td>\n","      <td>12</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>6.750</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>489434</td>\n","      <td>79323W</td>\n","      <td>WHITE CHERRY LIGHTS</td>\n","      <td>12</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>6.750</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>489434</td>\n","      <td>22041</td>\n","      <td>RECORD FRAME 7\" SINGLE SIZE</td>\n","      <td>48</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>2.100</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>489434</td>\n","      <td>21232</td>\n","      <td>STRAWBERRY CERAMIC TRINKET BOX</td>\n","      <td>24</td>\n","      <td>2009-12-01 07:45:00</td>\n","      <td>1.250</td>\n","      <td>13085.000</td>\n","      <td>United Kingdom</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bfc41746-3493-4c0c-ae96-3857c482e551')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","        \n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-bfc41746-3493-4c0c-ae96-3857c482e551 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-bfc41746-3493-4c0c-ae96-3857c482e551');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":12}]},{"cell_type":"code","source":["create_rfm(df,csv=True)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":455},"id":"B52gcrf-MOMN","outputId":"4471e667-440b-46ca-cd24-5c6cb4891fe7"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["             recency  frequency  monetary recency_score frequency_score monetary_score RFM_SCORE              segment\n","Customer ID                                                                                                          \n","12346            530         11   372.860             2               5              2        25           cant_loose\n","12347            368          2  1323.320             5               2              4        52  potential_loaylists\n","12348            439          1   222.160             2               1              1        21          hibernating\n","12349            408          3  2671.140             3               3              5        33    need_to_attention\n","12351            376          1   300.930             5               1              2        51        new_customers\n","...              ...        ...       ...           ...             ...            ...       ...                  ...\n","18283            383          6   641.770             4               5              3        45      loyal_customers\n","18284            432          1   461.680             3               2              2        32       about_to_sleep\n","18285            661          1   427.000             1               2              2        12          hibernating\n","18286            477          2  1296.430             2               3              4        23              at_risk\n","18287            383          4  2345.710             4               4              5        44      loyal_customers\n","\n","[4312 rows x 8 columns]"],"text/html":["\n","  <div id=\"df-d637e139-c45e-436e-ad10-44651e59ce56\">\n","    <div class=\"colab-df-container\">\n","      <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>recency</th>\n","      <th>frequency</th>\n","      <th>monetary</th>\n","      <th>recency_score</th>\n","      <th>frequency_score</th>\n","      <th>monetary_score</th>\n","      <th>RFM_SCORE</th>\n","      <th>segment</th>\n","    </tr>\n","    <tr>\n","      <th>Customer ID</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>12346</th>\n","      <td>530</td>\n","      <td>11</td>\n","      <td>372.860</td>\n","      <td>2</td>\n","      <td>5</td>\n","      <td>2</td>\n","      <td>25</td>\n","      <td>cant_loose</td>\n","    </tr>\n","    <tr>\n","      <th>12347</th>\n","      <td>368</td>\n","      <td>2</td>\n","      <td>1323.320</td>\n","      <td>5</td>\n","      <td>2</td>\n","      <td>4</td>\n","      <td>52</td>\n","      <td>potential_loaylists</td>\n","    </tr>\n","    <tr>\n","      <th>12348</th>\n","      <td>439</td>\n","      <td>1</td>\n","      <td>222.160</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>21</td>\n","      <td>hibernating</td>\n","    </tr>\n","    <tr>\n","      <th>12349</th>\n","      <td>408</td>\n","      <td>3</td>\n","      <td>2671.140</td>\n","      <td>3</td>\n","      <td>3</td>\n","      <td>5</td>\n","      <td>33</td>\n","      <td>need_to_attention</td>\n","    </tr>\n","    <tr>\n","      <th>12351</th>\n","      <td>376</td>\n","      <td>1</td>\n","      <td>300.930</td>\n","      <td>5</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>51</td>\n","      <td>new_customers</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","    </tr>\n","    <tr>\n","      <th>18283</th>\n","      <td>383</td>\n","      <td>6</td>\n","      <td>641.770</td>\n","      <td>4</td>\n","      <td>5</td>\n","      <td>3</td>\n","      <td>45</td>\n","      <td>loyal_customers</td>\n","    </tr>\n","    <tr>\n","      <th>18284</th>\n","      <td>432</td>\n","      <td>1</td>\n","      <td>461.680</td>\n","      <td>3</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>32</td>\n","      <td>about_to_sleep</td>\n","    </tr>\n","    <tr>\n","      <th>18285</th>\n","      <td>661</td>\n","      <td>1</td>\n","      <td>427.000</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>12</td>\n","      <td>hibernating</td>\n","    </tr>\n","    <tr>\n","      <th>18286</th>\n","      <td>477</td>\n","      <td>2</td>\n","      <td>1296.430</td>\n","      <td>2</td>\n","      <td>3</td>\n","      <td>4</td>\n","      <td>23</td>\n","      <td>at_risk</td>\n","    </tr>\n","    <tr>\n","      <th>18287</th>\n","      <td>383</td>\n","      <td>4</td>\n","      <td>2345.710</td>\n","      <td>4</td>\n","      <td>4</td>\n","      <td>5</td>\n","      <td>44</td>\n","      <td>loyal_customers</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>4312 rows × 8 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-d637e139-c45e-436e-ad10-44651e59ce56')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","        \n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-d637e139-c45e-436e-ad10-44651e59ce56 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-d637e139-c45e-436e-ad10-44651e59ce56');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":13}]}]}