Clustering based on Price.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import pandas as pd\n",
    "from sklearn.cluster import KMeans\n",
    "from sklearn.preprocessing import MinMaxScaler\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>names</th>\n",
       "      <th>alias</th>\n",
       "      <th>unit</th>\n",
       "      <th>price</th>\n",
       "      <th>MTL_CODE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0-15 AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>NO</td>\n",
       "      <td>1.81</td>\n",
       "      <td>9029262907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0-150A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>NO</td>\n",
       "      <td>55.03</td>\n",
       "      <td>4970090140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0-150-300A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>NO</td>\n",
       "      <td>99.58</td>\n",
       "      <td>9029108100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0-1000A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>NO</td>\n",
       "      <td>215.35</td>\n",
       "      <td>9099432089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0-150-600-1250 AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>NO</td>\n",
       "      <td>740.95</td>\n",
       "      <td>9049251230</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    names     alias unit   price    MTL_CODE\n",
       "0            0-15 AMMETER   AMMETER   NO    1.81  9029262907\n",
       "1          0-150A AMMETER   AMMETER   NO   55.03  4970090140\n",
       "2      0-150-300A AMMETER   AMMETER   NO   99.58  9029108100\n",
       "3         0-1000A AMMETER   AMMETER   NO  215.35  9099432089\n",
       "4  0-150-600-1250 AMMETER   AMMETER   NO  740.95  9049251230"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.read_excel(\"VIGNESH121.xlsx\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>names</th>\n",
       "      <th>alias</th>\n",
       "      <th>unit</th>\n",
       "      <th>price</th>\n",
       "      <th>MTL_CODE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0-15 AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.81</td>\n",
       "      <td>9029262907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0-150A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>55.03</td>\n",
       "      <td>4970090140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0-150-300A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.58</td>\n",
       "      <td>9029108100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0-1000A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>215.35</td>\n",
       "      <td>9099432089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0-150-600-1250 AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>740.95</td>\n",
       "      <td>9049251230</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    names     alias   unit   price    MTL_CODE\n",
       "0            0-15 AMMETER   AMMETER  100.0    1.81  9029262907\n",
       "1          0-150A AMMETER   AMMETER  100.0   55.03  4970090140\n",
       "2      0-150-300A AMMETER   AMMETER  100.0   99.58  9029108100\n",
       "3         0-1000A AMMETER   AMMETER  100.0  215.35  9099432089\n",
       "4  0-150-600-1250 AMMETER   AMMETER  100.0  740.95  9049251230"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d={\"NO\":100,\"MR\":80,\"KG\":60,\"ST\":45,\"LT\":35,\"SM\":25,\"LO\":17,\"MT\":15,\"RL\":13,\"QM\":11,\"SH\":9,\"PR\":7,\"PK\":6,\"PD\":5,\"CM\":4,\"KL\":3,\"HN\":2,\"RM\":1,\"LB\":0.5,\"GM\":0.25}\n",
    "df['unit']=df['unit'].map(d)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "features=['unit','price']\n",
    "df1=df[features]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2=df[:1000]\n",
    "df3=df1[:1000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "scaler = MinMaxScaler()\n",
    "X_scaled = scaler.fit_transform(df3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Acer\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>names</th>\n",
       "      <th>alias</th>\n",
       "      <th>unit</th>\n",
       "      <th>price</th>\n",
       "      <th>MTL_CODE</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0-15 AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.81</td>\n",
       "      <td>9029262907</td>\n",
       "      <td>390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0-150A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>55.03</td>\n",
       "      <td>4970090140</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0-150-300A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.58</td>\n",
       "      <td>9029108100</td>\n",
       "      <td>280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0-1000A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>215.35</td>\n",
       "      <td>9099432089</td>\n",
       "      <td>285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0-150-600-1250 AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>740.95</td>\n",
       "      <td>9049251230</td>\n",
       "      <td>259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.50X780XCOIL,CRNGO,SPEC-AA10916.</td>\n",
       "      <td>COIL</td>\n",
       "      <td>80.0</td>\n",
       "      <td>10.65</td>\n",
       "      <td>2851244930</td>\n",
       "      <td>339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.50X615MMXCOIL,CRNGO,SPEC-AA10915.</td>\n",
       "      <td>COIL</td>\n",
       "      <td>80.0</td>\n",
       "      <td>11.09</td>\n",
       "      <td>2851244922</td>\n",
       "      <td>339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.50X985XCOIL,CRNGO,SHT,SPEC-HG10062</td>\n",
       "      <td>COIL</td>\n",
       "      <td>80.0</td>\n",
       "      <td>11.80</td>\n",
       "      <td>2851244949</td>\n",
       "      <td>339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.50X785XCOIL,SPEC-AA10915.</td>\n",
       "      <td>COIL</td>\n",
       "      <td>80.0</td>\n",
       "      <td>12.98</td>\n",
       "      <td>2851244930</td>\n",
       "      <td>224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.35 X 540 X COIL</td>\n",
       "      <td>COIL</td>\n",
       "      <td>80.0</td>\n",
       "      <td>22053.92</td>\n",
       "      <td>4670274090</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.50 X 892 X COIL</td>\n",
       "      <td>COIL</td>\n",
       "      <td>100.0</td>\n",
       "      <td>26.74</td>\n",
       "      <td>9099468784</td>\n",
       "      <td>398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.50 X 892 X COIL</td>\n",
       "      <td>COIL</td>\n",
       "      <td>100.0</td>\n",
       "      <td>372.71</td>\n",
       "      <td>9069461102</td>\n",
       "      <td>303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.50 X 892 X COIL</td>\n",
       "      <td>COIL</td>\n",
       "      <td>100.0</td>\n",
       "      <td>376.06</td>\n",
       "      <td>9069432803</td>\n",
       "      <td>303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.35 X 780 X COIL</td>\n",
       "      <td>COIL</td>\n",
       "      <td>100.0</td>\n",
       "      <td>612.10</td>\n",
       "      <td>4323027923</td>\n",
       "      <td>352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.50 X 495 MM X COILCRNGO (AA10901)</td>\n",
       "      <td>COIL</td>\n",
       "      <td>100.0</td>\n",
       "      <td>3743.12</td>\n",
       "      <td>4981667030</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.4TKX50 COTTON TAPE</td>\n",
       "      <td>COTTON TAPE</td>\n",
       "      <td>60.0</td>\n",
       "      <td>116.00</td>\n",
       "      <td>2289026018</td>\n",
       "      <td>116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.4TKX50 COTTON TAPE</td>\n",
       "      <td>COTTON TAPE</td>\n",
       "      <td>60.0</td>\n",
       "      <td>10356.78</td>\n",
       "      <td>7701505010</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.4X200 MM COPPER SHEET</td>\n",
       "      <td>COTTON TAPE</td>\n",
       "      <td>60.0</td>\n",
       "      <td>43050.00</td>\n",
       "      <td>1477806010</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.4TKX50 COTTON TAPE</td>\n",
       "      <td>COTTON TAPE</td>\n",
       "      <td>80.0</td>\n",
       "      <td>3.31</td>\n",
       "      <td>2851244850</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.4TKX50 COTTON TAPE</td>\n",
       "      <td>COTTON TAPE</td>\n",
       "      <td>80.0</td>\n",
       "      <td>5.43</td>\n",
       "      <td>2851244850</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   names         alias   unit     price  \\\n",
       "0                           0-15 AMMETER       AMMETER  100.0      1.81   \n",
       "1                         0-150A AMMETER       AMMETER  100.0     55.03   \n",
       "2                     0-150-300A AMMETER       AMMETER  100.0     99.58   \n",
       "3                        0-1000A AMMETER       AMMETER  100.0    215.35   \n",
       "4                 0-150-600-1250 AMMETER       AMMETER  100.0    740.95   \n",
       "5      0.50X780XCOIL,CRNGO,SPEC-AA10916.          COIL   80.0     10.65   \n",
       "6    0.50X615MMXCOIL,CRNGO,SPEC-AA10915.          COIL   80.0     11.09   \n",
       "7   0.50X985XCOIL,CRNGO,SHT,SPEC-HG10062          COIL   80.0     11.80   \n",
       "8            0.50X785XCOIL,SPEC-AA10915.          COIL   80.0     12.98   \n",
       "9                      0.35 X 540 X COIL          COIL   80.0  22053.92   \n",
       "10                     0.50 X 892 X COIL          COIL  100.0     26.74   \n",
       "11                     0.50 X 892 X COIL          COIL  100.0    372.71   \n",
       "12                     0.50 X 892 X COIL          COIL  100.0    376.06   \n",
       "13                     0.35 X 780 X COIL          COIL  100.0    612.10   \n",
       "14   0.50 X 495 MM X COILCRNGO (AA10901)          COIL  100.0   3743.12   \n",
       "15                  0.4TKX50 COTTON TAPE   COTTON TAPE   60.0    116.00   \n",
       "16                  0.4TKX50 COTTON TAPE   COTTON TAPE   60.0  10356.78   \n",
       "17               0.4X200 MM COPPER SHEET   COTTON TAPE   60.0  43050.00   \n",
       "18                  0.4TKX50 COTTON TAPE   COTTON TAPE   80.0      3.31   \n",
       "19                  0.4TKX50 COTTON TAPE   COTTON TAPE   80.0      5.43   \n",
       "\n",
       "      MTL_CODE  cluster  \n",
       "0   9029262907      390  \n",
       "1   4970090140      208  \n",
       "2   9029108100      280  \n",
       "3   9099432089      285  \n",
       "4   9049251230      259  \n",
       "5   2851244930      339  \n",
       "6   2851244922      339  \n",
       "7   2851244949      339  \n",
       "8   2851244930      224  \n",
       "9   4670274090       21  \n",
       "10  9099468784      398  \n",
       "11  9069461102      303  \n",
       "12  9069432803      303  \n",
       "13  4323027923      352  \n",
       "14  4981667030       22  \n",
       "15  2289026018      116  \n",
       "16  7701505010       37  \n",
       "17  1477806010       19  \n",
       "18  2851244850      145  \n",
       "19  2851244850      145  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "km=KMeans(n_clusters=400,init='k-means++',n_init=10,algorithm = 'auto',max_iter=400)\n",
    "km.fit(X_scaled)\n",
    "df2['cluster']=km.fit_predict(X_scaled)\n",
    "df2[:20]"
   ]
  },
  {
   "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></th>\n",
       "      <th>names</th>\n",
       "      <th>alias</th>\n",
       "      <th>unit</th>\n",
       "      <th>price</th>\n",
       "      <th>MTL_CODE</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0-15 AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1.81</td>\n",
       "      <td>9029262907</td>\n",
       "      <td>383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0-150A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>55.03</td>\n",
       "      <td>4970090140</td>\n",
       "      <td>341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0-150-300A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.58</td>\n",
       "      <td>9029108100</td>\n",
       "      <td>216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0-1000A AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>215.35</td>\n",
       "      <td>9099432089</td>\n",
       "      <td>303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0-150-600-1250 AMMETER</td>\n",
       "      <td>AMMETER</td>\n",
       "      <td>100.0</td>\n",
       "      <td>740.95</td>\n",
       "      <td>9049251230</td>\n",
       "      <td>252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.50X780XCOIL,CRNGO,SPEC-AA10916.</td>\n",
       "      <td>COIL</td>\n",
       "      <td>80.0</td>\n",
       "      <td>10.65</td>\n",
       "      <td>2851244930</td>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.50X615MMXCOIL,CRNGO,SPEC-AA10915.</td>\n",
       "      <td>COIL</td>\n",
       "      <td>80.0</td>\n",
       "      <td>11.09</td>\n",
       "      <td>2851244922</td>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.50X985XCOIL,CRNGO,SHT,SPEC-HG10062</td>\n",
       "      <td>COIL</td>\n",
       "      <td>80.0</td>\n",
       "      <td>11.80</td>\n",
       "      <td>2851244949</td>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.50X785XCOIL,SPEC-AA10915.</td>\n",
       "      <td>COIL</td>\n",
       "      <td>80.0</td>\n",
       "      <td>12.98</td>\n",
       "      <td>2851244930</td>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.35 X 540 X COIL</td>\n",
       "      <td>COIL</td>\n",
       "      <td>80.0</td>\n",
       "      <td>22053.92</td>\n",
       "      <td>4670274090</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.50 X 892 X COIL</td>\n",
       "      <td>COIL</td>\n",
       "      <td>100.0</td>\n",
       "      <td>26.74</td>\n",
       "      <td>9099468784</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.50 X 892 X COIL</td>\n",
       "      <td>COIL</td>\n",
       "      <td>100.0</td>\n",
       "      <td>372.71</td>\n",
       "      <td>9069461102</td>\n",
       "      <td>316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.50 X 892 X COIL</td>\n",
       "      <td>COIL</td>\n",
       "      <td>100.0</td>\n",
       "      <td>376.06</td>\n",
       "      <td>9069432803</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.35 X 780 X COIL</td>\n",
       "      <td>COIL</td>\n",
       "      <td>100.0</td>\n",
       "      <td>612.10</td>\n",
       "      <td>4323027923</td>\n",
       "      <td>315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.50 X 495 MM X COILCRNGO (AA10901)</td>\n",
       "      <td>COIL</td>\n",
       "      <td>100.0</td>\n",
       "      <td>3743.12</td>\n",
       "      <td>4981667030</td>\n",
       "      <td>373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.4TKX50 COTTON TAPE</td>\n",
       "      <td>COTTON TAPE</td>\n",
       "      <td>60.0</td>\n",
       "      <td>116.00</td>\n",
       "      <td>2289026018</td>\n",
       "      <td>248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.4TKX50 COTTON TAPE</td>\n",
       "      <td>COTTON TAPE</td>\n",
       "      <td>60.0</td>\n",
       "      <td>10356.78</td>\n",
       "      <td>7701505010</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.4X200 MM COPPER SHEET</td>\n",
       "      <td>COTTON TAPE</td>\n",
       "      <td>60.0</td>\n",
       "      <td>43050.00</td>\n",
       "      <td>1477806010</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.4TKX50 COTTON TAPE</td>\n",
       "      <td>COTTON TAPE</td>\n",
       "      <td>80.0</td>\n",
       "      <td>3.31</td>\n",
       "      <td>2851244850</td>\n",
       "      <td>199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.4TKX50 COTTON TAPE</td>\n",
       "      <td>COTTON TAPE</td>\n",
       "      <td>80.0</td>\n",
       "      <td>5.43</td>\n",
       "      <td>2851244850</td>\n",
       "      <td>371</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   names         alias   unit     price  \\\n",
       "0                           0-15 AMMETER       AMMETER  100.0      1.81   \n",
       "1                         0-150A AMMETER       AMMETER  100.0     55.03   \n",
       "2                     0-150-300A AMMETER       AMMETER  100.0     99.58   \n",
       "3                        0-1000A AMMETER       AMMETER  100.0    215.35   \n",
       "4                 0-150-600-1250 AMMETER       AMMETER  100.0    740.95   \n",
       "5      0.50X780XCOIL,CRNGO,SPEC-AA10916.          COIL   80.0     10.65   \n",
       "6    0.50X615MMXCOIL,CRNGO,SPEC-AA10915.          COIL   80.0     11.09   \n",
       "7   0.50X985XCOIL,CRNGO,SHT,SPEC-HG10062          COIL   80.0     11.80   \n",
       "8            0.50X785XCOIL,SPEC-AA10915.          COIL   80.0     12.98   \n",
       "9                      0.35 X 540 X COIL          COIL   80.0  22053.92   \n",
       "10                     0.50 X 892 X COIL          COIL  100.0     26.74   \n",
       "11                     0.50 X 892 X COIL          COIL  100.0    372.71   \n",
       "12                     0.50 X 892 X COIL          COIL  100.0    376.06   \n",
       "13                     0.35 X 780 X COIL          COIL  100.0    612.10   \n",
       "14   0.50 X 495 MM X COILCRNGO (AA10901)          COIL  100.0   3743.12   \n",
       "15                  0.4TKX50 COTTON TAPE   COTTON TAPE   60.0    116.00   \n",
       "16                  0.4TKX50 COTTON TAPE   COTTON TAPE   60.0  10356.78   \n",
       "17               0.4X200 MM COPPER SHEET   COTTON TAPE   60.0  43050.00   \n",
       "18                  0.4TKX50 COTTON TAPE   COTTON TAPE   80.0      3.31   \n",
       "19                  0.4TKX50 COTTON TAPE   COTTON TAPE   80.0      5.43   \n",
       "\n",
       "      MTL_CODE  cluster  \n",
       "0   9029262907      383  \n",
       "1   4970090140      341  \n",
       "2   9029108100      216  \n",
       "3   9099432089      303  \n",
       "4   9049251230      252  \n",
       "5   2851244930      251  \n",
       "6   2851244922      251  \n",
       "7   2851244949      251  \n",
       "8   2851244930      251  \n",
       "9   4670274090       25  \n",
       "10  9099468784      208  \n",
       "11  9069461102      316  \n",
       "12  9069432803      104  \n",
       "13  4323027923      315  \n",
       "14  4981667030      373  \n",
       "15  2289026018      248  \n",
       "16  7701505010       39  \n",
       "17  1477806010       17  \n",
       "18  2851244850      199  \n",
       "19  2851244850      371  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.sort_values([\"alias\",\"unit\",\"price\",\"MTL_CODE\"])[:20]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}