shampoo_by_product_name.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import necessary libraries\n",
    "import openai\n",
    "from openai.embeddings_utils import get_embedding, cosine_similarity\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Load the csv file as dataframe.\n",
    "df = pd.read_csv('./data/shampoo_products_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 21 entries, 0 to 20\n",
      "Data columns (total 7 columns):\n",
      " #   Column            Non-Null Count  Dtype \n",
      "---  ------            --------------  ----- \n",
      " 0   Product_ID        21 non-null     int64 \n",
      " 1   Product_Category  21 non-null     object\n",
      " 2   Brand_Name        21 non-null     object\n",
      " 3   Product_Name      21 non-null     object\n",
      " 4   Product_Details   21 non-null     object\n",
      " 5   Origin            21 non-null     object\n",
      " 6   Ingredients       21 non-null     object\n",
      "dtypes: int64(1), object(6)\n",
      "memory usage: 1.3+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Configure the baseline configuration of the OpenAI library.\n",
    "openai.api_type = \"azure\"\n",
    "openai.api_base = \"https://PLESAE_ENTER_YOUR_OWNED_AOAI_RESOURCE_NAME.openai.azure.com/\"\n",
    "openai.api_version = \"2022-12-01\"\n",
    "openai.api_key = \"PLEASE_ENTER_YOUR_OWNED_AOAI_SERVICE_KEY\"\n",
    "engine = \"PLEASE_ENTER_YOUR_OWNED_AOAI_TEXT_EMBEDDING_MODEL_NAME\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Perform word embedding for each product name in the dataframe in vector form.\n",
    "embeddings = [get_embedding(text, engine=engine) for text in df['Product_Name'].values]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Calculate the cosine similarity between each product name.\n",
    "similarity_matrix = np.zeros((len(embeddings), len(embeddings)))\n",
    "for i in range(len(embeddings)):\n",
    "    for j in range(len(embeddings)):\n",
    "        if i == j:\n",
    "            similarity_matrix[i,j] = 1.0\n",
    "        elif i < j:\n",
    "            similarity_matrix[i,j] = cosine_similarity(embeddings[i], embeddings[j])\n",
    "        else:\n",
    "            similarity_matrix[i,j] = similarity_matrix[j,i]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Save the similarity matrix to a CSV file.\n",
    "np.savetxt('./data/similarity_matrix_sp_n.csv', similarity_matrix, delimiter=',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Reload the similarity matrix from the CSV file.\n",
    "# similarity_matrix = np.loadtxt('./data/similarity_matrix_sp_n.csv', delimiter=',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                 DOVE BOTANIC BREAKAGE PROTECT SHAMPOO\n",
       "1               DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO\n",
       "2                         DOVE LIGHT MOIST PURE SHAMPOO\n",
       "3                      DOVE JAPAN AIRY MOISTURE SHAMPOO\n",
       "4                      DOVE JAPAN RICH MOISTURE SHAMPOO\n",
       "5                           DOVE SHAMPOO STRAIGHT&SILKY\n",
       "6             VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO\n",
       "7                 VIDAL SASSOON MOISTURIZING AD SHAMPOO\n",
       "8             VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO\n",
       "9           VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO\n",
       "10                         REJOICE VOLUME FRESH SHAMPOO\n",
       "11                                  REJOICE OIL REMOVAL\n",
       "12                            REJOICE OLIVE OIL SHAMPOO\n",
       "13                      REJOICE MINT REFRESHING SHAMPOO\n",
       "14                       REJOICE LEMON BALANCED SHAMPOO\n",
       "15                            REJOICE 3IN1 CARE SHAMPOO\n",
       "16        ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO\n",
       "17            ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO\n",
       "18         Essential Purify Deep Cleansing Care Shampoo\n",
       "19    Essential Purify Weightlessly Smooth Care Shampoo\n",
       "20               Essential Purify Anti Dandruff Shampoo\n",
       "Name: Product_Name, dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a list of Product_Name.\n",
    "p_name = pd.Series(df['Product_Name'])\n",
    "p_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create function for Product Recommendations.\n",
    "def product_recommendations(Product_Name, cos_sim = similarity_matrix):\n",
    "    recommended_product = []\n",
    "    idx = p_name[p_name == Product_Name].index[0]\n",
    "    score_series = pd.Series(cos_sim[idx]).sort_values(ascending = False)\n",
    "    top_10_indexes = list(score_series.iloc[1:11].index)\n",
    "    for i in top_10_indexes:\n",
    "        recommended_product.append(list(df['Product_Name'])[i])\n",
    "    return recommended_product"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO',\n",
       " 'ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO',\n",
       " 'DOVE LIGHT MOIST PURE SHAMPOO',\n",
       " 'DOVE SHAMPOO STRAIGHT&SILKY',\n",
       " 'DOVE JAPAN AIRY MOISTURE SHAMPOO',\n",
       " 'DOVE JAPAN RICH MOISTURE SHAMPOO',\n",
       " 'ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO',\n",
       " 'VIDAL SASSOON MOISTURIZING AD SHAMPOO',\n",
       " 'VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO',\n",
       " 'VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO']"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Perform Product Recommendations. It is based on Product Name to figure out the similarity.\n",
    "product_recommendations('DOVE BOTANIC BREAKAGE PROTECT SHAMPOO')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Product_Name</th>\n",
       "      <th>DOVE BOTANIC BREAKAGE PROTECT SHAMPOO</th>\n",
       "      <th>DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO</th>\n",
       "      <th>DOVE LIGHT MOIST PURE SHAMPOO</th>\n",
       "      <th>DOVE JAPAN AIRY MOISTURE SHAMPOO</th>\n",
       "      <th>DOVE JAPAN RICH MOISTURE SHAMPOO</th>\n",
       "      <th>DOVE SHAMPOO STRAIGHT&amp;SILKY</th>\n",
       "      <th>VIDAL SASSOON LIGHT &amp; SOFT SMOOTH SHAMPOO</th>\n",
       "      <th>VIDAL SASSOON MOISTURIZING AD SHAMPOO</th>\n",
       "      <th>VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO</th>\n",
       "      <th>VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO</th>\n",
       "      <th>...</th>\n",
       "      <th>REJOICE OIL REMOVAL</th>\n",
       "      <th>REJOICE OLIVE OIL SHAMPOO</th>\n",
       "      <th>REJOICE MINT REFRESHING SHAMPOO</th>\n",
       "      <th>REJOICE LEMON BALANCED SHAMPOO</th>\n",
       "      <th>REJOICE 3IN1 CARE SHAMPOO</th>\n",
       "      <th>ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO</th>\n",
       "      <th>ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO</th>\n",
       "      <th>Essential Purify Deep Cleansing Care Shampoo</th>\n",
       "      <th>Essential Purify Weightlessly Smooth Care Shampoo</th>\n",
       "      <th>Essential Purify Anti Dandruff Shampoo</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Product_Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>DOVE BOTANIC BREAKAGE PROTECT SHAMPOO</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.951075</td>\n",
       "      <td>0.920772</td>\n",
       "      <td>0.886769</td>\n",
       "      <td>0.884122</td>\n",
       "      <td>0.888769</td>\n",
       "      <td>0.867286</td>\n",
       "      <td>0.872807</td>\n",
       "      <td>0.868178</td>\n",
       "      <td>0.862930</td>\n",
       "      <td>...</td>\n",
       "      <td>0.776927</td>\n",
       "      <td>0.865434</td>\n",
       "      <td>0.846735</td>\n",
       "      <td>0.850273</td>\n",
       "      <td>0.860685</td>\n",
       "      <td>0.924257</td>\n",
       "      <td>0.878188</td>\n",
       "      <td>0.851140</td>\n",
       "      <td>0.841178</td>\n",
       "      <td>0.846370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO</th>\n",
       "      <td>0.951075</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.911165</td>\n",
       "      <td>0.877366</td>\n",
       "      <td>0.877768</td>\n",
       "      <td>0.888563</td>\n",
       "      <td>0.862063</td>\n",
       "      <td>0.865566</td>\n",
       "      <td>0.860589</td>\n",
       "      <td>0.853410</td>\n",
       "      <td>...</td>\n",
       "      <td>0.766043</td>\n",
       "      <td>0.859416</td>\n",
       "      <td>0.839893</td>\n",
       "      <td>0.849201</td>\n",
       "      <td>0.857253</td>\n",
       "      <td>0.884962</td>\n",
       "      <td>0.869227</td>\n",
       "      <td>0.848767</td>\n",
       "      <td>0.833516</td>\n",
       "      <td>0.845442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOVE LIGHT MOIST PURE SHAMPOO</th>\n",
       "      <td>0.920772</td>\n",
       "      <td>0.911165</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.923337</td>\n",
       "      <td>0.922760</td>\n",
       "      <td>0.924643</td>\n",
       "      <td>0.904011</td>\n",
       "      <td>0.893816</td>\n",
       "      <td>0.882420</td>\n",
       "      <td>0.867455</td>\n",
       "      <td>...</td>\n",
       "      <td>0.781793</td>\n",
       "      <td>0.879512</td>\n",
       "      <td>0.871090</td>\n",
       "      <td>0.868557</td>\n",
       "      <td>0.873267</td>\n",
       "      <td>0.872767</td>\n",
       "      <td>0.894854</td>\n",
       "      <td>0.866695</td>\n",
       "      <td>0.866285</td>\n",
       "      <td>0.863525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOVE JAPAN AIRY MOISTURE SHAMPOO</th>\n",
       "      <td>0.886769</td>\n",
       "      <td>0.877366</td>\n",
       "      <td>0.923337</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.973375</td>\n",
       "      <td>0.896943</td>\n",
       "      <td>0.859337</td>\n",
       "      <td>0.878374</td>\n",
       "      <td>0.853405</td>\n",
       "      <td>0.853351</td>\n",
       "      <td>...</td>\n",
       "      <td>0.769998</td>\n",
       "      <td>0.848976</td>\n",
       "      <td>0.851141</td>\n",
       "      <td>0.845329</td>\n",
       "      <td>0.859864</td>\n",
       "      <td>0.846011</td>\n",
       "      <td>0.871093</td>\n",
       "      <td>0.834592</td>\n",
       "      <td>0.831249</td>\n",
       "      <td>0.832639</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOVE JAPAN RICH MOISTURE SHAMPOO</th>\n",
       "      <td>0.884122</td>\n",
       "      <td>0.877768</td>\n",
       "      <td>0.922760</td>\n",
       "      <td>0.973375</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.889428</td>\n",
       "      <td>0.853184</td>\n",
       "      <td>0.875891</td>\n",
       "      <td>0.850733</td>\n",
       "      <td>0.851722</td>\n",
       "      <td>...</td>\n",
       "      <td>0.764310</td>\n",
       "      <td>0.849720</td>\n",
       "      <td>0.841929</td>\n",
       "      <td>0.837105</td>\n",
       "      <td>0.853478</td>\n",
       "      <td>0.845813</td>\n",
       "      <td>0.864332</td>\n",
       "      <td>0.830423</td>\n",
       "      <td>0.824960</td>\n",
       "      <td>0.824417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOVE SHAMPOO STRAIGHT&amp;SILKY</th>\n",
       "      <td>0.888769</td>\n",
       "      <td>0.888563</td>\n",
       "      <td>0.924643</td>\n",
       "      <td>0.896943</td>\n",
       "      <td>0.889428</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.876112</td>\n",
       "      <td>0.864327</td>\n",
       "      <td>0.894281</td>\n",
       "      <td>0.843654</td>\n",
       "      <td>...</td>\n",
       "      <td>0.768486</td>\n",
       "      <td>0.855975</td>\n",
       "      <td>0.844240</td>\n",
       "      <td>0.834801</td>\n",
       "      <td>0.850460</td>\n",
       "      <td>0.842561</td>\n",
       "      <td>0.864034</td>\n",
       "      <td>0.825953</td>\n",
       "      <td>0.840335</td>\n",
       "      <td>0.830869</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VIDAL SASSOON LIGHT &amp; SOFT SMOOTH SHAMPOO</th>\n",
       "      <td>0.867286</td>\n",
       "      <td>0.862063</td>\n",
       "      <td>0.904011</td>\n",
       "      <td>0.859337</td>\n",
       "      <td>0.853184</td>\n",
       "      <td>0.876112</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.959386</td>\n",
       "      <td>0.957166</td>\n",
       "      <td>0.927222</td>\n",
       "      <td>...</td>\n",
       "      <td>0.801224</td>\n",
       "      <td>0.894415</td>\n",
       "      <td>0.881989</td>\n",
       "      <td>0.885769</td>\n",
       "      <td>0.884277</td>\n",
       "      <td>0.881596</td>\n",
       "      <td>0.898368</td>\n",
       "      <td>0.869253</td>\n",
       "      <td>0.880745</td>\n",
       "      <td>0.859773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VIDAL SASSOON MOISTURIZING AD SHAMPOO</th>\n",
       "      <td>0.872807</td>\n",
       "      <td>0.865566</td>\n",
       "      <td>0.893816</td>\n",
       "      <td>0.878374</td>\n",
       "      <td>0.875891</td>\n",
       "      <td>0.864327</td>\n",
       "      <td>0.959386</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.946349</td>\n",
       "      <td>0.947564</td>\n",
       "      <td>...</td>\n",
       "      <td>0.806771</td>\n",
       "      <td>0.896637</td>\n",
       "      <td>0.885238</td>\n",
       "      <td>0.879517</td>\n",
       "      <td>0.888808</td>\n",
       "      <td>0.888777</td>\n",
       "      <td>0.917806</td>\n",
       "      <td>0.868749</td>\n",
       "      <td>0.863139</td>\n",
       "      <td>0.865371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO</th>\n",
       "      <td>0.868178</td>\n",
       "      <td>0.860589</td>\n",
       "      <td>0.882420</td>\n",
       "      <td>0.853405</td>\n",
       "      <td>0.850733</td>\n",
       "      <td>0.894281</td>\n",
       "      <td>0.957166</td>\n",
       "      <td>0.946349</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.923800</td>\n",
       "      <td>...</td>\n",
       "      <td>0.790846</td>\n",
       "      <td>0.883214</td>\n",
       "      <td>0.871391</td>\n",
       "      <td>0.868196</td>\n",
       "      <td>0.877006</td>\n",
       "      <td>0.885546</td>\n",
       "      <td>0.897822</td>\n",
       "      <td>0.865653</td>\n",
       "      <td>0.867489</td>\n",
       "      <td>0.861210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO</th>\n",
       "      <td>0.862930</td>\n",
       "      <td>0.853410</td>\n",
       "      <td>0.867455</td>\n",
       "      <td>0.853351</td>\n",
       "      <td>0.851722</td>\n",
       "      <td>0.843654</td>\n",
       "      <td>0.927222</td>\n",
       "      <td>0.947564</td>\n",
       "      <td>0.923800</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.807779</td>\n",
       "      <td>0.878431</td>\n",
       "      <td>0.860655</td>\n",
       "      <td>0.860212</td>\n",
       "      <td>0.873718</td>\n",
       "      <td>0.881113</td>\n",
       "      <td>0.890774</td>\n",
       "      <td>0.844203</td>\n",
       "      <td>0.842487</td>\n",
       "      <td>0.839164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REJOICE VOLUME FRESH SHAMPOO</th>\n",
       "      <td>0.862483</td>\n",
       "      <td>0.851843</td>\n",
       "      <td>0.882646</td>\n",
       "      <td>0.860737</td>\n",
       "      <td>0.851995</td>\n",
       "      <td>0.855621</td>\n",
       "      <td>0.897251</td>\n",
       "      <td>0.894593</td>\n",
       "      <td>0.889068</td>\n",
       "      <td>0.875441</td>\n",
       "      <td>...</td>\n",
       "      <td>0.852649</td>\n",
       "      <td>0.932182</td>\n",
       "      <td>0.946490</td>\n",
       "      <td>0.926646</td>\n",
       "      <td>0.934782</td>\n",
       "      <td>0.877596</td>\n",
       "      <td>0.893514</td>\n",
       "      <td>0.856006</td>\n",
       "      <td>0.851834</td>\n",
       "      <td>0.846628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REJOICE OIL REMOVAL</th>\n",
       "      <td>0.776927</td>\n",
       "      <td>0.766043</td>\n",
       "      <td>0.781793</td>\n",
       "      <td>0.769998</td>\n",
       "      <td>0.764310</td>\n",
       "      <td>0.768486</td>\n",
       "      <td>0.801224</td>\n",
       "      <td>0.806771</td>\n",
       "      <td>0.790846</td>\n",
       "      <td>0.807779</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.890969</td>\n",
       "      <td>0.844191</td>\n",
       "      <td>0.842765</td>\n",
       "      <td>0.849548</td>\n",
       "      <td>0.787944</td>\n",
       "      <td>0.802307</td>\n",
       "      <td>0.792615</td>\n",
       "      <td>0.781201</td>\n",
       "      <td>0.786655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REJOICE OLIVE OIL SHAMPOO</th>\n",
       "      <td>0.865434</td>\n",
       "      <td>0.859416</td>\n",
       "      <td>0.879512</td>\n",
       "      <td>0.848976</td>\n",
       "      <td>0.849720</td>\n",
       "      <td>0.855975</td>\n",
       "      <td>0.894415</td>\n",
       "      <td>0.896637</td>\n",
       "      <td>0.883214</td>\n",
       "      <td>0.878431</td>\n",
       "      <td>...</td>\n",
       "      <td>0.890969</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.918704</td>\n",
       "      <td>0.923994</td>\n",
       "      <td>0.924271</td>\n",
       "      <td>0.881533</td>\n",
       "      <td>0.892782</td>\n",
       "      <td>0.853199</td>\n",
       "      <td>0.846758</td>\n",
       "      <td>0.848473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REJOICE MINT REFRESHING SHAMPOO</th>\n",
       "      <td>0.846735</td>\n",
       "      <td>0.839893</td>\n",
       "      <td>0.871090</td>\n",
       "      <td>0.851141</td>\n",
       "      <td>0.841929</td>\n",
       "      <td>0.844240</td>\n",
       "      <td>0.881989</td>\n",
       "      <td>0.885238</td>\n",
       "      <td>0.871391</td>\n",
       "      <td>0.860655</td>\n",
       "      <td>...</td>\n",
       "      <td>0.844191</td>\n",
       "      <td>0.918704</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.926781</td>\n",
       "      <td>0.922874</td>\n",
       "      <td>0.868481</td>\n",
       "      <td>0.886483</td>\n",
       "      <td>0.846358</td>\n",
       "      <td>0.836916</td>\n",
       "      <td>0.842991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REJOICE LEMON BALANCED SHAMPOO</th>\n",
       "      <td>0.850273</td>\n",
       "      <td>0.849201</td>\n",
       "      <td>0.868557</td>\n",
       "      <td>0.845329</td>\n",
       "      <td>0.837105</td>\n",
       "      <td>0.834801</td>\n",
       "      <td>0.885769</td>\n",
       "      <td>0.879517</td>\n",
       "      <td>0.868196</td>\n",
       "      <td>0.860212</td>\n",
       "      <td>...</td>\n",
       "      <td>0.842765</td>\n",
       "      <td>0.923994</td>\n",
       "      <td>0.926781</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.917610</td>\n",
       "      <td>0.871245</td>\n",
       "      <td>0.883390</td>\n",
       "      <td>0.845871</td>\n",
       "      <td>0.847894</td>\n",
       "      <td>0.844697</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REJOICE 3IN1 CARE SHAMPOO</th>\n",
       "      <td>0.860685</td>\n",
       "      <td>0.857253</td>\n",
       "      <td>0.873267</td>\n",
       "      <td>0.859864</td>\n",
       "      <td>0.853478</td>\n",
       "      <td>0.850460</td>\n",
       "      <td>0.884277</td>\n",
       "      <td>0.888808</td>\n",
       "      <td>0.877006</td>\n",
       "      <td>0.873718</td>\n",
       "      <td>...</td>\n",
       "      <td>0.849548</td>\n",
       "      <td>0.924271</td>\n",
       "      <td>0.922874</td>\n",
       "      <td>0.917610</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.876396</td>\n",
       "      <td>0.886652</td>\n",
       "      <td>0.867030</td>\n",
       "      <td>0.856519</td>\n",
       "      <td>0.843663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO</th>\n",
       "      <td>0.924257</td>\n",
       "      <td>0.884962</td>\n",
       "      <td>0.872767</td>\n",
       "      <td>0.846011</td>\n",
       "      <td>0.845813</td>\n",
       "      <td>0.842561</td>\n",
       "      <td>0.881596</td>\n",
       "      <td>0.888777</td>\n",
       "      <td>0.885546</td>\n",
       "      <td>0.881113</td>\n",
       "      <td>...</td>\n",
       "      <td>0.787944</td>\n",
       "      <td>0.881533</td>\n",
       "      <td>0.868481</td>\n",
       "      <td>0.871245</td>\n",
       "      <td>0.876396</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.926292</td>\n",
       "      <td>0.892641</td>\n",
       "      <td>0.884400</td>\n",
       "      <td>0.886914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO</th>\n",
       "      <td>0.878188</td>\n",
       "      <td>0.869227</td>\n",
       "      <td>0.894854</td>\n",
       "      <td>0.871093</td>\n",
       "      <td>0.864332</td>\n",
       "      <td>0.864034</td>\n",
       "      <td>0.898368</td>\n",
       "      <td>0.917806</td>\n",
       "      <td>0.897822</td>\n",
       "      <td>0.890774</td>\n",
       "      <td>...</td>\n",
       "      <td>0.802307</td>\n",
       "      <td>0.892782</td>\n",
       "      <td>0.886483</td>\n",
       "      <td>0.883390</td>\n",
       "      <td>0.886652</td>\n",
       "      <td>0.926292</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.890178</td>\n",
       "      <td>0.893907</td>\n",
       "      <td>0.899378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Essential Purify Deep Cleansing Care Shampoo</th>\n",
       "      <td>0.851140</td>\n",
       "      <td>0.848767</td>\n",
       "      <td>0.866695</td>\n",
       "      <td>0.834592</td>\n",
       "      <td>0.830423</td>\n",
       "      <td>0.825953</td>\n",
       "      <td>0.869253</td>\n",
       "      <td>0.868749</td>\n",
       "      <td>0.865653</td>\n",
       "      <td>0.844203</td>\n",
       "      <td>...</td>\n",
       "      <td>0.792615</td>\n",
       "      <td>0.853199</td>\n",
       "      <td>0.846358</td>\n",
       "      <td>0.845871</td>\n",
       "      <td>0.867030</td>\n",
       "      <td>0.892641</td>\n",
       "      <td>0.890178</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.948462</td>\n",
       "      <td>0.943356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Essential Purify Weightlessly Smooth Care Shampoo</th>\n",
       "      <td>0.841178</td>\n",
       "      <td>0.833516</td>\n",
       "      <td>0.866285</td>\n",
       "      <td>0.831249</td>\n",
       "      <td>0.824960</td>\n",
       "      <td>0.840335</td>\n",
       "      <td>0.880745</td>\n",
       "      <td>0.863139</td>\n",
       "      <td>0.867489</td>\n",
       "      <td>0.842487</td>\n",
       "      <td>...</td>\n",
       "      <td>0.781201</td>\n",
       "      <td>0.846758</td>\n",
       "      <td>0.836916</td>\n",
       "      <td>0.847894</td>\n",
       "      <td>0.856519</td>\n",
       "      <td>0.884400</td>\n",
       "      <td>0.893907</td>\n",
       "      <td>0.948462</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.925887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Essential Purify Anti Dandruff Shampoo</th>\n",
       "      <td>0.846370</td>\n",
       "      <td>0.845442</td>\n",
       "      <td>0.863525</td>\n",
       "      <td>0.832639</td>\n",
       "      <td>0.824417</td>\n",
       "      <td>0.830869</td>\n",
       "      <td>0.859773</td>\n",
       "      <td>0.865371</td>\n",
       "      <td>0.861210</td>\n",
       "      <td>0.839164</td>\n",
       "      <td>...</td>\n",
       "      <td>0.786655</td>\n",
       "      <td>0.848473</td>\n",
       "      <td>0.842991</td>\n",
       "      <td>0.844697</td>\n",
       "      <td>0.843663</td>\n",
       "      <td>0.886914</td>\n",
       "      <td>0.899378</td>\n",
       "      <td>0.943356</td>\n",
       "      <td>0.925887</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Product_Name                                       DOVE BOTANIC BREAKAGE PROTECT SHAMPOO  \\\n",
       "Product_Name                                                                               \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                           1.000000   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                         0.951075   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                                   0.920772   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                                0.886769   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                                0.884122   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                     0.888769   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                       0.867286   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                           0.872807   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                       0.868178   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                     0.862930   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                                    0.862483   \n",
       "REJOICE OIL REMOVAL                                                             0.776927   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                       0.865434   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                                 0.846735   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                                  0.850273   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                       0.860685   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                                   0.924257   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                       0.878188   \n",
       "Essential Purify Deep Cleansing Care Shampoo                                    0.851140   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                               0.841178   \n",
       "Essential Purify Anti Dandruff Shampoo                                          0.846370   \n",
       "\n",
       "Product_Name                                       DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO  \\\n",
       "Product_Name                                                                                 \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                             0.951075   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                           1.000000   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                                     0.911165   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                                  0.877366   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                                  0.877768   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                       0.888563   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                         0.862063   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                             0.865566   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                         0.860589   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                       0.853410   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                                      0.851843   \n",
       "REJOICE OIL REMOVAL                                                               0.766043   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                         0.859416   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                                   0.839893   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                                    0.849201   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                         0.857253   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                                     0.884962   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                         0.869227   \n",
       "Essential Purify Deep Cleansing Care Shampoo                                      0.848767   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                                 0.833516   \n",
       "Essential Purify Anti Dandruff Shampoo                                            0.845442   \n",
       "\n",
       "Product_Name                                       DOVE LIGHT MOIST PURE SHAMPOO  \\\n",
       "Product_Name                                                                       \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                   0.920772   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                 0.911165   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                           1.000000   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                        0.923337   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                        0.922760   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                             0.924643   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                               0.904011   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                   0.893816   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                               0.882420   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                             0.867455   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                            0.882646   \n",
       "REJOICE OIL REMOVAL                                                     0.781793   \n",
       "REJOICE OLIVE OIL SHAMPOO                                               0.879512   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                         0.871090   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                          0.868557   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                               0.873267   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                           0.872767   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                               0.894854   \n",
       "Essential Purify Deep Cleansing Care Shampoo                            0.866695   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                       0.866285   \n",
       "Essential Purify Anti Dandruff Shampoo                                  0.863525   \n",
       "\n",
       "Product_Name                                       DOVE JAPAN AIRY MOISTURE SHAMPOO  \\\n",
       "Product_Name                                                                          \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                      0.886769   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                    0.877366   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                              0.923337   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                           1.000000   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                           0.973375   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                0.896943   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                  0.859337   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                      0.878374   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                  0.853405   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                0.853351   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                               0.860737   \n",
       "REJOICE OIL REMOVAL                                                        0.769998   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                  0.848976   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                            0.851141   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                             0.845329   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                  0.859864   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                              0.846011   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                  0.871093   \n",
       "Essential Purify Deep Cleansing Care Shampoo                               0.834592   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                          0.831249   \n",
       "Essential Purify Anti Dandruff Shampoo                                     0.832639   \n",
       "\n",
       "Product_Name                                       DOVE JAPAN RICH MOISTURE SHAMPOO  \\\n",
       "Product_Name                                                                          \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                      0.884122   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                    0.877768   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                              0.922760   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                           0.973375   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                           1.000000   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                0.889428   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                  0.853184   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                      0.875891   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                  0.850733   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                0.851722   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                               0.851995   \n",
       "REJOICE OIL REMOVAL                                                        0.764310   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                  0.849720   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                            0.841929   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                             0.837105   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                  0.853478   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                              0.845813   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                  0.864332   \n",
       "Essential Purify Deep Cleansing Care Shampoo                               0.830423   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                          0.824960   \n",
       "Essential Purify Anti Dandruff Shampoo                                     0.824417   \n",
       "\n",
       "Product_Name                                       DOVE SHAMPOO STRAIGHT&SILKY  \\\n",
       "Product_Name                                                                     \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                 0.888769   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                               0.888563   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                         0.924643   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                      0.896943   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                      0.889428   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                           1.000000   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                             0.876112   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                 0.864327   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                             0.894281   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                           0.843654   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                          0.855621   \n",
       "REJOICE OIL REMOVAL                                                   0.768486   \n",
       "REJOICE OLIVE OIL SHAMPOO                                             0.855975   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                       0.844240   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                        0.834801   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                             0.850460   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                         0.842561   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                             0.864034   \n",
       "Essential Purify Deep Cleansing Care Shampoo                          0.825953   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                     0.840335   \n",
       "Essential Purify Anti Dandruff Shampoo                                0.830869   \n",
       "\n",
       "Product_Name                                       VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO  \\\n",
       "Product_Name                                                                                   \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                               0.867286   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                             0.862063   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                                       0.904011   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                                    0.859337   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                                    0.853184   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                         0.876112   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                           1.000000   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                               0.959386   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                           0.957166   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                         0.927222   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                                        0.897251   \n",
       "REJOICE OIL REMOVAL                                                                 0.801224   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                           0.894415   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                                     0.881989   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                                      0.885769   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                           0.884277   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                                       0.881596   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                           0.898368   \n",
       "Essential Purify Deep Cleansing Care Shampoo                                        0.869253   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                                   0.880745   \n",
       "Essential Purify Anti Dandruff Shampoo                                              0.859773   \n",
       "\n",
       "Product_Name                                       VIDAL SASSOON MOISTURIZING AD SHAMPOO  \\\n",
       "Product_Name                                                                               \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                           0.872807   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                         0.865566   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                                   0.893816   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                                0.878374   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                                0.875891   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                     0.864327   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                       0.959386   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                           1.000000   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                       0.946349   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                     0.947564   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                                    0.894593   \n",
       "REJOICE OIL REMOVAL                                                             0.806771   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                       0.896637   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                                 0.885238   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                                  0.879517   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                       0.888808   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                                   0.888777   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                       0.917806   \n",
       "Essential Purify Deep Cleansing Care Shampoo                                    0.868749   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                               0.863139   \n",
       "Essential Purify Anti Dandruff Shampoo                                          0.865371   \n",
       "\n",
       "Product_Name                                       VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO  \\\n",
       "Product_Name                                                                                   \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                               0.868178   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                             0.860589   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                                       0.882420   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                                    0.853405   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                                    0.850733   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                         0.894281   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                           0.957166   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                               0.946349   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                           1.000000   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                         0.923800   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                                        0.889068   \n",
       "REJOICE OIL REMOVAL                                                                 0.790846   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                           0.883214   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                                     0.871391   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                                      0.868196   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                           0.877006   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                                       0.885546   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                           0.897822   \n",
       "Essential Purify Deep Cleansing Care Shampoo                                        0.865653   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                                   0.867489   \n",
       "Essential Purify Anti Dandruff Shampoo                                              0.861210   \n",
       "\n",
       "Product_Name                                       VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO  \\\n",
       "Product_Name                                                                                     \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                                 0.862930   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                               0.853410   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                                         0.867455   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                                      0.853351   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                                      0.851722   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                           0.843654   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                             0.927222   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                                 0.947564   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                             0.923800   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                           1.000000   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                                          0.875441   \n",
       "REJOICE OIL REMOVAL                                                                   0.807779   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                             0.878431   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                                       0.860655   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                                        0.860212   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                             0.873718   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                                         0.881113   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                             0.890774   \n",
       "Essential Purify Deep Cleansing Care Shampoo                                          0.844203   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                                     0.842487   \n",
       "Essential Purify Anti Dandruff Shampoo                                                0.839164   \n",
       "\n",
       "Product_Name                                       ...  REJOICE OIL REMOVAL  \\\n",
       "Product_Name                                       ...                        \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO              ...             0.776927   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO            ...             0.766043   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                      ...             0.781793   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                   ...             0.769998   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                   ...             0.764310   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                        ...             0.768486   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO          ...             0.801224   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO              ...             0.806771   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO          ...             0.790846   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO        ...             0.807779   \n",
       "REJOICE VOLUME FRESH SHAMPOO                       ...             0.852649   \n",
       "REJOICE OIL REMOVAL                                ...             1.000000   \n",
       "REJOICE OLIVE OIL SHAMPOO                          ...             0.890969   \n",
       "REJOICE MINT REFRESHING SHAMPOO                    ...             0.844191   \n",
       "REJOICE LEMON BALANCED SHAMPOO                     ...             0.842765   \n",
       "REJOICE 3IN1 CARE SHAMPOO                          ...             0.849548   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO      ...             0.787944   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO          ...             0.802307   \n",
       "Essential Purify Deep Cleansing Care Shampoo       ...             0.792615   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo  ...             0.781201   \n",
       "Essential Purify Anti Dandruff Shampoo             ...             0.786655   \n",
       "\n",
       "Product_Name                                       REJOICE OLIVE OIL SHAMPOO  \\\n",
       "Product_Name                                                                   \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                               0.865434   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                             0.859416   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                       0.879512   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                    0.848976   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                    0.849720   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                         0.855975   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                           0.894415   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                               0.896637   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                           0.883214   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                         0.878431   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                        0.932182   \n",
       "REJOICE OIL REMOVAL                                                 0.890969   \n",
       "REJOICE OLIVE OIL SHAMPOO                                           1.000000   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                     0.918704   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                      0.923994   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                           0.924271   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                       0.881533   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                           0.892782   \n",
       "Essential Purify Deep Cleansing Care Shampoo                        0.853199   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                   0.846758   \n",
       "Essential Purify Anti Dandruff Shampoo                              0.848473   \n",
       "\n",
       "Product_Name                                       REJOICE MINT REFRESHING SHAMPOO  \\\n",
       "Product_Name                                                                         \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                     0.846735   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                   0.839893   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                             0.871090   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                          0.851141   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                          0.841929   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                               0.844240   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                 0.881989   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                     0.885238   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                 0.871391   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                               0.860655   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                              0.946490   \n",
       "REJOICE OIL REMOVAL                                                       0.844191   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                 0.918704   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                           1.000000   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                            0.926781   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                 0.922874   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                             0.868481   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                 0.886483   \n",
       "Essential Purify Deep Cleansing Care Shampoo                              0.846358   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                         0.836916   \n",
       "Essential Purify Anti Dandruff Shampoo                                    0.842991   \n",
       "\n",
       "Product_Name                                       REJOICE LEMON BALANCED SHAMPOO  \\\n",
       "Product_Name                                                                        \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                    0.850273   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                  0.849201   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                            0.868557   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                         0.845329   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                         0.837105   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                              0.834801   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                0.885769   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                    0.879517   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                0.868196   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                              0.860212   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                             0.926646   \n",
       "REJOICE OIL REMOVAL                                                      0.842765   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                0.923994   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                          0.926781   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                           1.000000   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                0.917610   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                            0.871245   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                0.883390   \n",
       "Essential Purify Deep Cleansing Care Shampoo                             0.845871   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                        0.847894   \n",
       "Essential Purify Anti Dandruff Shampoo                                   0.844697   \n",
       "\n",
       "Product_Name                                       REJOICE 3IN1 CARE SHAMPOO  \\\n",
       "Product_Name                                                                   \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                               0.860685   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                             0.857253   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                       0.873267   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                    0.859864   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                    0.853478   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                         0.850460   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                           0.884277   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                               0.888808   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                           0.877006   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                         0.873718   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                        0.934782   \n",
       "REJOICE OIL REMOVAL                                                 0.849548   \n",
       "REJOICE OLIVE OIL SHAMPOO                                           0.924271   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                     0.922874   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                      0.917610   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                           1.000000   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                       0.876396   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                           0.886652   \n",
       "Essential Purify Deep Cleansing Care Shampoo                        0.867030   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                   0.856519   \n",
       "Essential Purify Anti Dandruff Shampoo                              0.843663   \n",
       "\n",
       "Product_Name                                       ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO  \\\n",
       "Product_Name                                                                                       \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                                   0.924257   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                                 0.884962   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                                           0.872767   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                                        0.846011   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                                        0.845813   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                             0.842561   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                               0.881596   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                                   0.888777   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                               0.885546   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                             0.881113   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                                            0.877596   \n",
       "REJOICE OIL REMOVAL                                                                     0.787944   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                               0.881533   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                                         0.868481   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                                          0.871245   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                               0.876396   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                                           1.000000   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                               0.926292   \n",
       "Essential Purify Deep Cleansing Care Shampoo                                            0.892641   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                                       0.884400   \n",
       "Essential Purify Anti Dandruff Shampoo                                                  0.886914   \n",
       "\n",
       "Product_Name                                       ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO  \\\n",
       "Product_Name                                                                                   \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                               0.878188   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                             0.869227   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                                       0.894854   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                                    0.871093   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                                    0.864332   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                         0.864034   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                           0.898368   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                               0.917806   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                           0.897822   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                         0.890774   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                                        0.893514   \n",
       "REJOICE OIL REMOVAL                                                                 0.802307   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                           0.892782   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                                     0.886483   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                                      0.883390   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                           0.886652   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                                       0.926292   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                           1.000000   \n",
       "Essential Purify Deep Cleansing Care Shampoo                                        0.890178   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                                   0.893907   \n",
       "Essential Purify Anti Dandruff Shampoo                                              0.899378   \n",
       "\n",
       "Product_Name                                       Essential Purify Deep Cleansing Care Shampoo  \\\n",
       "Product_Name                                                                                      \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                                  0.851140   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                                0.848767   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                                          0.866695   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                                       0.834592   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                                       0.830423   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                            0.825953   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                              0.869253   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                                  0.868749   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                              0.865653   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                            0.844203   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                                           0.856006   \n",
       "REJOICE OIL REMOVAL                                                                    0.792615   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                              0.853199   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                                        0.846358   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                                         0.845871   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                              0.867030   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                                          0.892641   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                              0.890178   \n",
       "Essential Purify Deep Cleansing Care Shampoo                                           1.000000   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                                      0.948462   \n",
       "Essential Purify Anti Dandruff Shampoo                                                 0.943356   \n",
       "\n",
       "Product_Name                                       Essential Purify Weightlessly Smooth Care Shampoo  \\\n",
       "Product_Name                                                                                           \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                                       0.841178   \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                                     0.833516   \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                                               0.866285   \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                                            0.831249   \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                                            0.824960   \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                                 0.840335   \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                                   0.880745   \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                                       0.863139   \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                                   0.867489   \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                                 0.842487   \n",
       "REJOICE VOLUME FRESH SHAMPOO                                                                0.851834   \n",
       "REJOICE OIL REMOVAL                                                                         0.781201   \n",
       "REJOICE OLIVE OIL SHAMPOO                                                                   0.846758   \n",
       "REJOICE MINT REFRESHING SHAMPOO                                                             0.836916   \n",
       "REJOICE LEMON BALANCED SHAMPOO                                                              0.847894   \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                                   0.856519   \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                                               0.884400   \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                                   0.893907   \n",
       "Essential Purify Deep Cleansing Care Shampoo                                                0.948462   \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                                           1.000000   \n",
       "Essential Purify Anti Dandruff Shampoo                                                      0.925887   \n",
       "\n",
       "Product_Name                                       Essential Purify Anti Dandruff Shampoo  \n",
       "Product_Name                                                                               \n",
       "DOVE BOTANIC BREAKAGE PROTECT SHAMPOO                                            0.846370  \n",
       "DOVE BOTANIC SPLIT ENDS PROTECT SHAMPOO                                          0.845442  \n",
       "DOVE LIGHT MOIST PURE SHAMPOO                                                    0.863525  \n",
       "DOVE JAPAN AIRY MOISTURE SHAMPOO                                                 0.832639  \n",
       "DOVE JAPAN RICH MOISTURE SHAMPOO                                                 0.824417  \n",
       "DOVE SHAMPOO STRAIGHT&SILKY                                                      0.830869  \n",
       "VIDAL SASSOON LIGHT & SOFT SMOOTH SHAMPOO                                        0.859773  \n",
       "VIDAL SASSOON MOISTURIZING AD SHAMPOO                                            0.865371  \n",
       "VIDAL SASSOON TEXTURIZED STRAIGHT SHAMPOO                                        0.861210  \n",
       "VIDAL SASSOON MOISTURING TRT REPAIR SHAMPOO                                      0.839164  \n",
       "REJOICE VOLUME FRESH SHAMPOO                                                     0.846628  \n",
       "REJOICE OIL REMOVAL                                                              0.786655  \n",
       "REJOICE OLIVE OIL SHAMPOO                                                        0.848473  \n",
       "REJOICE MINT REFRESHING SHAMPOO                                                  0.842991  \n",
       "REJOICE LEMON BALANCED SHAMPOO                                                   0.844697  \n",
       "REJOICE 3IN1 CARE SHAMPOO                                                        0.843663  \n",
       "ESSENTIAL NOURISHING BREAKAGE DEFENSE SHAMPOO                                    0.886914  \n",
       "ESSENTIAL MOISTURIZING FRIZZ FREE SHAMPOO                                        0.899378  \n",
       "Essential Purify Deep Cleansing Care Shampoo                                     0.943356  \n",
       "Essential Purify Weightlessly Smooth Care Shampoo                                0.925887  \n",
       "Essential Purify Anti Dandruff Shampoo                                           1.000000  \n",
       "\n",
       "[21 rows x 21 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_product_sim_matrix = pd.DataFrame(similarity_matrix, index = p_name, columns = p_name)\n",
    "df_product_sim_matrix"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.9"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}