Untitled1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import sqlite3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "con = sqlite3.connect(\"shop/test.db\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "addproduct=pd.read_sql_query(\"SELECT * from addproduct\", con)\n",
    "brand=pd.read_sql_query(\"SELECT * from brand\", con)\n",
    "events=pd.read_sql_query(\"SELECT * from events\", con)\n",
    "specsvalues=pd.read_sql_query(\"SELECT * from specsvalues\", con)\n",
    "category=pd.read_sql_query(\"SELECT * from category\", con)\n",
    "subcategories=pd.read_sql_query(\"SELECT * from subcategories\", con)\n",
    "specs=pd.read_sql_query(\"SELECT * from specs\", con)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "cat_subcat=pd.merge(category,subcategories,how='left',left_on='id',right_on='category_id')\n",
    "cat_subcat=cat_subcat[['category_id','name_x','id_y','name_y']]\n",
    "cat_subcat.columns=['category_id','category','subcategory_id','subcategory']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>price</th>\n",
       "      <th>discount</th>\n",
       "      <th>stock</th>\n",
       "      <th>colors</th>\n",
       "      <th>desc</th>\n",
       "      <th>pub_date</th>\n",
       "      <th>category_id</th>\n",
       "      <th>subcategory_id</th>\n",
       "      <th>brand_id</th>\n",
       "      <th>category</th>\n",
       "      <th>subcategory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Allen Solly Men's Plain Slim Fit Casual Shirt</td>\n",
       "      <td>699</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>Blue, Purple, Black</td>\n",
       "      <td>Allen solly Mens Cotton Full sleeve Overdyed s...</td>\n",
       "      <td>2020-07-08 15:54:29.990947</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Men's Clothing</td>\n",
       "      <td>Shirt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Park Avenue Men's Solid Slim Fit Formal Shirt</td>\n",
       "      <td>563</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>White, Blue, Khaki</td>\n",
       "      <td>This classic shirt from Park Avenue is a versa...</td>\n",
       "      <td>2020-07-08 15:57:00.755305</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>Men's Clothing</td>\n",
       "      <td>Shirt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Park Avenue Men's Plain Slim Fit Formal Shirt</td>\n",
       "      <td>654</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>White, Blue, Black</td>\n",
       "      <td>Be noticed at work by enhancing your looks wit...</td>\n",
       "      <td>2020-07-08 15:58:57.811980</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>Men's Clothing</td>\n",
       "      <td>Shirt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Wrangler Men's Relaxed Fit Jeans</td>\n",
       "      <td>1198</td>\n",
       "      <td>5</td>\n",
       "      <td>25</td>\n",
       "      <td>Blue, Black</td>\n",
       "      <td>Wrangler is the everyday performance denim bra...</td>\n",
       "      <td>2020-07-08 16:02:12.713819</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>Men's Clothing</td>\n",
       "      <td>Jeans</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Casio G-Shock Analog-Digital Blue Dial Men's W...</td>\n",
       "      <td>6396</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>Blue, Black</td>\n",
       "      <td>Mineral Glass Magnetic Resistant Shock Resista...</td>\n",
       "      <td>2020-07-08 16:05:11.097813</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>13</td>\n",
       "      <td>Men's Clothing</td>\n",
       "      <td>Watch</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id                                               name  price  discount  \\\n",
       "0   1      Allen Solly Men's Plain Slim Fit Casual Shirt    699         0   \n",
       "1   2      Park Avenue Men's Solid Slim Fit Formal Shirt    563         0   \n",
       "2   3      Park Avenue Men's Plain Slim Fit Formal Shirt    654         0   \n",
       "3   4                   Wrangler Men's Relaxed Fit Jeans   1198         5   \n",
       "4   5  Casio G-Shock Analog-Digital Blue Dial Men's W...   6396         0   \n",
       "\n",
       "   stock               colors  \\\n",
       "0     25  Blue, Purple, Black   \n",
       "1     15   White, Blue, Khaki   \n",
       "2     15   White, Blue, Black   \n",
       "3     25          Blue, Black   \n",
       "4     25          Blue, Black   \n",
       "\n",
       "                                                desc  \\\n",
       "0  Allen solly Mens Cotton Full sleeve Overdyed s...   \n",
       "1  This classic shirt from Park Avenue is a versa...   \n",
       "2  Be noticed at work by enhancing your looks wit...   \n",
       "3  Wrangler is the everyday performance denim bra...   \n",
       "4  Mineral Glass Magnetic Resistant Shock Resista...   \n",
       "\n",
       "                     pub_date  category_id  subcategory_id  brand_id  \\\n",
       "0  2020-07-08 15:54:29.990947            1               2         8   \n",
       "1  2020-07-08 15:57:00.755305            1               2        11   \n",
       "2  2020-07-08 15:58:57.811980            1               2        11   \n",
       "3  2020-07-08 16:02:12.713819            1               3        12   \n",
       "4  2020-07-08 16:05:11.097813            1               4        13   \n",
       "\n",
       "         category subcategory  \n",
       "0  Men's Clothing       Shirt  \n",
       "1  Men's Clothing       Shirt  \n",
       "2  Men's Clothing       Shirt  \n",
       "3  Men's Clothing       Jeans  \n",
       "4  Men's Clothing       Watch  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "product=pd.merge(addproduct,cat_subcat[['category','subcategory_id','subcategory']],how='left',on='subcategory_id')\n",
    "product=product.drop(['image_1','image_2','image_3'],axis='columns')\n",
    "product.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>product_id</th>\n",
       "      <th>spec_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Fit : Regular Fit</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Fit : Regular Fit</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Fit : Regular Fit</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>Fit : Regular Fit</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>Fit : Regular Fit</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Sleeve Length : Long Sleeves</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id                          name  product_id  spec_id\n",
       "0   1             Fit : Regular Fit           1        1\n",
       "1   1             Fit : Regular Fit          31        1\n",
       "2   1             Fit : Regular Fit          32        1\n",
       "3   1             Fit : Regular Fit          33        1\n",
       "4   1             Fit : Regular Fit          10        1\n",
       "5   2  Sleeve Length : Long Sleeves           1        2"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "specifications=pd.merge(specs[['id','name']],specsvalues[['product_id','spec_id']],left_on='id',right_on='spec_id')\n",
    "specifications.drop('id',axis='columns')\n",
    "specifications.head(6)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Fit : Regular Fit', 'Sleeve Length : Long Sleeves',\n",
       "       'Material : Cotton', 'Collar : Button-Down Collar',\n",
       "       'Pattern : Solid', 'Occasion : Formal', 'Collar : Spread Collar',\n",
       "       'Fit : Slim Fit', 'Pattern : Textured', 'Occasion : Casual',\n",
       "       'Pattern : Buffalo Checks', 'Pattern : Tartan Checks',\n",
       "       'Neck : Round Neck', 'Pattern : Printed', 'Sleeves : Half Sleeves',\n",
       "       'Collar : Mandarin Collar', 'Collar : Ainsley Collar',\n",
       "       'Distress: Clean Look', 'Fade: Heavy Fade', 'Fit: Slim Fit',\n",
       "       'Waist Rise: Mid-Rise', 'Length: Regular', 'Strech: Strechable',\n",
       "       'Display: Analogue and Digital', 'Movement : Automatic',\n",
       "       'Type: Hybrid', 'Features: Multi Function', 'Dial Shape: Round',\n",
       "       'Dial Pattern: Round', 'Length: Short',\n",
       "       'Number of Compartments: 2', 'Number of Slip Pockets: 1',\n",
       "       'Material: Leather', 'Number of Card Holder: 4',\n",
       "       'Toe Shape: Round Toe', 'Ankle Height: Mid Top',\n",
       "       'Warranty: 2 months', 'Pattern: Solid', 'Sole Material: TPR',\n",
       "       'Fastening: Lace Ups', 'Sport: Running', 'Outsole Type: Marking',\n",
       "       'Material: Mesh', 'Ankle Height: Regular', 'Neck: Pollo Collar',\n",
       "       'Sleeves Length: Three-Quarter Sleeves', 'Type: Peplum',\n",
       "       'Transparency: Opaque', 'Print or Pattern Type: Self Design',\n",
       "       'Length:Regular', 'Distress: Clean  Look', 'Fade: Light Fade',\n",
       "       'Fit: Skinny Fit', 'Waistbend: With Belt Loops', 'Waist: Low-Rise',\n",
       "       'Shade: Dark', 'Length: Cropped', 'Strech:  Strechable',\n",
       "       'Top Fabric:Net| Bottom Fabric: Santoon | Dupatta Fabric: Net| Inner Fabric: Santoon',\n",
       "       'Work: Embroidered', 'Sleeve: Full Sleeve', 'Neck: Round Neck',\n",
       "       'Style: Anarkali Gown with Dupatta and Bottom', 'Size: Free Size',\n",
       "       'Dial Color: Blue', ' Case Shape: Tonneau',\n",
       "       ' Band Material: Patent Leather', 'Case Shape: Special',\n",
       "       'water-resistant for up to 3 ATM', 'Watch Movement Type: Quartz',\n",
       "       'Watch Display Type: Analog', 'Sport:  Running',\n",
       "       'Fastening: Lace-Ups', 'Outsole Type: Non-Marking',\n",
       "       'Pronation for Running Shoes: Neutral', 'Material:  Mesh',\n",
       "       'Ankle Height:  Regular', 'Cleats: No Cleats', 'Arch Type: Medium',\n",
       "       'Sleeve Length: Long Sleeves', 'Fit: Regular Fit',\n",
       "       'Occasion: Casual', 'Hemline: Curved', 'Collar: Spread Collar',\n",
       "       'Print or Pattern Type: Solid', 'Length:  Regular',\n",
       "       'Distress:  Clean Look', 'Fade:  Light Fade', 'Fit:  Regular Fit',\n",
       "       'Waistband:  With belt loops', 'Shade:  Medium',\n",
       "       'Stretch:  Stretchable', 'Sleeve Length: No Sleeves',\n",
       "       'Type: Regular', 'Lining: Has a lining', 'Neck: Shoulder Straps',\n",
       "       'Print or Pattern Type:  Polka Dots', 'Transparency:  Opaque',\n",
       "       'Type: Flatforms', 'Pattern: Printed', 'Shoe Width: Regular',\n",
       "       'Insole: Comfort Insole', 'Toe Shape:  Round Toe',\n",
       "       'Ankle Height:   Regular', 'Sole Material:  TPR',\n",
       "       'Letter Recognition', 'Letter Sounds', 'Spelling',\n",
       "       'Reading Skills'], dtype=object)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "specifications['name'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Fit : Regular Fit</th>\n",
       "      <th>Sleeve Length : Long Sleeves</th>\n",
       "      <th>Material : Cotton</th>\n",
       "      <th>Collar : Button-Down Collar</th>\n",
       "      <th>Pattern : Solid</th>\n",
       "      <th>Occasion : Formal</th>\n",
       "      <th>Collar : Spread Collar</th>\n",
       "      <th>Fit : Slim Fit</th>\n",
       "      <th>Pattern : Textured</th>\n",
       "      <th>Occasion : Casual</th>\n",
       "      <th>...</th>\n",
       "      <th>Insole: Comfort Insole</th>\n",
       "      <th>Toe Shape:  Round Toe</th>\n",
       "      <th>Ankle Height:   Regular</th>\n",
       "      <th>Sole Material:  TPR</th>\n",
       "      <th>Letter Recognition</th>\n",
       "      <th>Letter Sounds</th>\n",
       "      <th>Spelling</th>\n",
       "      <th>Reading Skills</th>\n",
       "      <th>id</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>1198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>6396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>6496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>1099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>1599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "      <td>385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>1200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>1399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>1599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>1199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>1799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "      <td>1599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "      <td>566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23</td>\n",
       "      <td>566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "      <td>1799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "      <td>2499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26</td>\n",
       "      <td>495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27</td>\n",
       "      <td>1499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28</td>\n",
       "      <td>1200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30</td>\n",
       "      <td>599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31</td>\n",
       "      <td>649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32</td>\n",
       "      <td>649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33</td>\n",
       "      <td>350</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33 rows × 111 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Fit : Regular Fit Sleeve Length : Long Sleeves Material : Cotton  \\\n",
       "0                NaN                          NaN               NaN   \n",
       "1                NaN                          NaN               NaN   \n",
       "2                NaN                          NaN               NaN   \n",
       "3                NaN                          NaN               NaN   \n",
       "4                NaN                          NaN               NaN   \n",
       "5                NaN                          NaN               NaN   \n",
       "6                NaN                          NaN               NaN   \n",
       "7                NaN                          NaN               NaN   \n",
       "8                NaN                          NaN               NaN   \n",
       "9                NaN                          NaN               NaN   \n",
       "10               NaN                          NaN               NaN   \n",
       "11               NaN                          NaN               NaN   \n",
       "12               NaN                          NaN               NaN   \n",
       "13               NaN                          NaN               NaN   \n",
       "14               NaN                          NaN               NaN   \n",
       "15               NaN                          NaN               NaN   \n",
       "16               NaN                          NaN               NaN   \n",
       "17               NaN                          NaN               NaN   \n",
       "18               NaN                          NaN               NaN   \n",
       "19               NaN                          NaN               NaN   \n",
       "20               NaN                          NaN               NaN   \n",
       "21               NaN                          NaN               NaN   \n",
       "22               NaN                          NaN               NaN   \n",
       "23               NaN                          NaN               NaN   \n",
       "24               NaN                          NaN               NaN   \n",
       "25               NaN                          NaN               NaN   \n",
       "26               NaN                          NaN               NaN   \n",
       "27               NaN                          NaN               NaN   \n",
       "28               NaN                          NaN               NaN   \n",
       "29               NaN                          NaN               NaN   \n",
       "30               NaN                          NaN               NaN   \n",
       "31               NaN                          NaN               NaN   \n",
       "32               NaN                          NaN               NaN   \n",
       "\n",
       "   Collar : Button-Down Collar Pattern : Solid Occasion : Formal  \\\n",
       "0                          NaN             NaN               NaN   \n",
       "1                          NaN             NaN               NaN   \n",
       "2                          NaN             NaN               NaN   \n",
       "3                          NaN             NaN               NaN   \n",
       "4                          NaN             NaN               NaN   \n",
       "5                          NaN             NaN               NaN   \n",
       "6                          NaN             NaN               NaN   \n",
       "7                          NaN             NaN               NaN   \n",
       "8                          NaN             NaN               NaN   \n",
       "9                          NaN             NaN               NaN   \n",
       "10                         NaN             NaN               NaN   \n",
       "11                         NaN             NaN               NaN   \n",
       "12                         NaN             NaN               NaN   \n",
       "13                         NaN             NaN               NaN   \n",
       "14                         NaN             NaN               NaN   \n",
       "15                         NaN             NaN               NaN   \n",
       "16                         NaN             NaN               NaN   \n",
       "17                         NaN             NaN               NaN   \n",
       "18                         NaN             NaN               NaN   \n",
       "19                         NaN             NaN               NaN   \n",
       "20                         NaN             NaN               NaN   \n",
       "21                         NaN             NaN               NaN   \n",
       "22                         NaN             NaN               NaN   \n",
       "23                         NaN             NaN               NaN   \n",
       "24                         NaN             NaN               NaN   \n",
       "25                         NaN             NaN               NaN   \n",
       "26                         NaN             NaN               NaN   \n",
       "27                         NaN             NaN               NaN   \n",
       "28                         NaN             NaN               NaN   \n",
       "29                         NaN             NaN               NaN   \n",
       "30                         NaN             NaN               NaN   \n",
       "31                         NaN             NaN               NaN   \n",
       "32                         NaN             NaN               NaN   \n",
       "\n",
       "   Collar : Spread Collar Fit : Slim Fit Pattern : Textured Occasion : Casual  \\\n",
       "0                     NaN            NaN                NaN               NaN   \n",
       "1                     NaN            NaN                NaN               NaN   \n",
       "2                     NaN            NaN                NaN               NaN   \n",
       "3                     NaN            NaN                NaN               NaN   \n",
       "4                     NaN            NaN                NaN               NaN   \n",
       "5                     NaN            NaN                NaN               NaN   \n",
       "6                     NaN            NaN                NaN               NaN   \n",
       "7                     NaN            NaN                NaN               NaN   \n",
       "8                     NaN            NaN                NaN               NaN   \n",
       "9                     NaN            NaN                NaN               NaN   \n",
       "10                    NaN            NaN                NaN               NaN   \n",
       "11                    NaN            NaN                NaN               NaN   \n",
       "12                    NaN            NaN                NaN               NaN   \n",
       "13                    NaN            NaN                NaN               NaN   \n",
       "14                    NaN            NaN                NaN               NaN   \n",
       "15                    NaN            NaN                NaN               NaN   \n",
       "16                    NaN            NaN                NaN               NaN   \n",
       "17                    NaN            NaN                NaN               NaN   \n",
       "18                    NaN            NaN                NaN               NaN   \n",
       "19                    NaN            NaN                NaN               NaN   \n",
       "20                    NaN            NaN                NaN               NaN   \n",
       "21                    NaN            NaN                NaN               NaN   \n",
       "22                    NaN            NaN                NaN               NaN   \n",
       "23                    NaN            NaN                NaN               NaN   \n",
       "24                    NaN            NaN                NaN               NaN   \n",
       "25                    NaN            NaN                NaN               NaN   \n",
       "26                    NaN            NaN                NaN               NaN   \n",
       "27                    NaN            NaN                NaN               NaN   \n",
       "28                    NaN            NaN                NaN               NaN   \n",
       "29                    NaN            NaN                NaN               NaN   \n",
       "30                    NaN            NaN                NaN               NaN   \n",
       "31                    NaN            NaN                NaN               NaN   \n",
       "32                    NaN            NaN                NaN               NaN   \n",
       "\n",
       "    ... Insole: Comfort Insole Toe Shape:  Round Toe Ankle Height:   Regular  \\\n",
       "0   ...                    NaN                   NaN                     NaN   \n",
       "1   ...                    NaN                   NaN                     NaN   \n",
       "2   ...                    NaN                   NaN                     NaN   \n",
       "3   ...                    NaN                   NaN                     NaN   \n",
       "4   ...                    NaN                   NaN                     NaN   \n",
       "5   ...                    NaN                   NaN                     NaN   \n",
       "6   ...                    NaN                   NaN                     NaN   \n",
       "7   ...                    NaN                   NaN                     NaN   \n",
       "8   ...                    NaN                   NaN                     NaN   \n",
       "9   ...                    NaN                   NaN                     NaN   \n",
       "10  ...                    NaN                   NaN                     NaN   \n",
       "11  ...                    NaN                   NaN                     NaN   \n",
       "12  ...                    NaN                   NaN                     NaN   \n",
       "13  ...                    NaN                   NaN                     NaN   \n",
       "14  ...                    NaN                   NaN                     NaN   \n",
       "15  ...                    NaN                   NaN                     NaN   \n",
       "16  ...                    NaN                   NaN                     NaN   \n",
       "17  ...                    NaN                   NaN                     NaN   \n",
       "18  ...                    NaN                   NaN                     NaN   \n",
       "19  ...                    NaN                   NaN                     NaN   \n",
       "20  ...                    NaN                   NaN                     NaN   \n",
       "21  ...                    NaN                   NaN                     NaN   \n",
       "22  ...                    NaN                   NaN                     NaN   \n",
       "23  ...                    NaN                   NaN                     NaN   \n",
       "24  ...                    NaN                   NaN                     NaN   \n",
       "25  ...                    NaN                   NaN                     NaN   \n",
       "26  ...                    NaN                   NaN                     NaN   \n",
       "27  ...                    NaN                   NaN                     NaN   \n",
       "28  ...                    NaN                   NaN                     NaN   \n",
       "29  ...                    NaN                   NaN                     NaN   \n",
       "30  ...                    NaN                   NaN                     NaN   \n",
       "31  ...                    NaN                   NaN                     NaN   \n",
       "32  ...                    NaN                   NaN                     NaN   \n",
       "\n",
       "   Sole Material:  TPR Letter Recognition Letter Sounds Spelling  \\\n",
       "0                  NaN                NaN           NaN      NaN   \n",
       "1                  NaN                NaN           NaN      NaN   \n",
       "2                  NaN                NaN           NaN      NaN   \n",
       "3                  NaN                NaN           NaN      NaN   \n",
       "4                  NaN                NaN           NaN      NaN   \n",
       "5                  NaN                NaN           NaN      NaN   \n",
       "6                  NaN                NaN           NaN      NaN   \n",
       "7                  NaN                NaN           NaN      NaN   \n",
       "8                  NaN                NaN           NaN      NaN   \n",
       "9                  NaN                NaN           NaN      NaN   \n",
       "10                 NaN                NaN           NaN      NaN   \n",
       "11                 NaN                NaN           NaN      NaN   \n",
       "12                 NaN                NaN           NaN      NaN   \n",
       "13                 NaN                NaN           NaN      NaN   \n",
       "14                 NaN                NaN           NaN      NaN   \n",
       "15                 NaN                NaN           NaN      NaN   \n",
       "16                 NaN                NaN           NaN      NaN   \n",
       "17                 NaN                NaN           NaN      NaN   \n",
       "18                 NaN                NaN           NaN      NaN   \n",
       "19                 NaN                NaN           NaN      NaN   \n",
       "20                 NaN                NaN           NaN      NaN   \n",
       "21                 NaN                NaN           NaN      NaN   \n",
       "22                 NaN                NaN           NaN      NaN   \n",
       "23                 NaN                NaN           NaN      NaN   \n",
       "24                 NaN                NaN           NaN      NaN   \n",
       "25                 NaN                NaN           NaN      NaN   \n",
       "26                 NaN                NaN           NaN      NaN   \n",
       "27                 NaN                NaN           NaN      NaN   \n",
       "28                 NaN                NaN           NaN      NaN   \n",
       "29                 NaN                NaN           NaN      NaN   \n",
       "30                 NaN                NaN           NaN      NaN   \n",
       "31                 NaN                NaN           NaN      NaN   \n",
       "32                 NaN                NaN           NaN      NaN   \n",
       "\n",
       "   Reading Skills  id price  \n",
       "0             NaN   1   699  \n",
       "1             NaN   2   563  \n",
       "2             NaN   3   654  \n",
       "3             NaN   4  1198  \n",
       "4             NaN   5  6396  \n",
       "5             NaN   6  6496  \n",
       "6             NaN   7  1099  \n",
       "7             NaN   8   999  \n",
       "8             NaN   9  1599  \n",
       "9             NaN  10   585  \n",
       "10            NaN  11   385  \n",
       "11            NaN  12   585  \n",
       "12            NaN  13  1200  \n",
       "13            NaN  14  1399  \n",
       "14            NaN  15   575  \n",
       "15            NaN  16   625  \n",
       "16            NaN  17   799  \n",
       "17            NaN  18  1599  \n",
       "18            NaN  19  1199  \n",
       "19            NaN  20  1799  \n",
       "20            NaN  21  1599  \n",
       "21            NaN  22   566  \n",
       "22            NaN  23   566  \n",
       "23            NaN  24  1799  \n",
       "24            NaN  25  2499  \n",
       "25            NaN  26   495  \n",
       "26            NaN  27  1499  \n",
       "27            NaN  28  1200  \n",
       "28            NaN  29   213  \n",
       "29            NaN  30   599  \n",
       "30            NaN  31   649  \n",
       "31            NaN  32   649  \n",
       "32            NaN  33   350  \n",
       "\n",
       "[33 rows x 111 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "specs=pd.DataFrame(index=range(len(product)),columns=specifications['name'].unique())\n",
    "specs['id']=product['id']\n",
    "specs['price']=addproduct['price']\n",
    "specs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "spec_list=specifications.groupby('product_id')['name'].groups\n",
    "for product in spec_list:\n",
    "    for spec in spec_list[product]:\n",
    "        specs.loc[specs[specs['id']==product].index,[specifications['name'][spec]]]=1        \n",
    "        #print(product,spec)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>Sleeves : Half Sleeves</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Sleeves : Half Sleeves\n",
       "32                      1"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "specs.loc[specs[specs['id']==product].index,[specifications['name'][spec]]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>Fit : Regular Fit</th>\n",
       "      <th>Sleeve Length : Long Sleeves</th>\n",
       "      <th>Material : Cotton</th>\n",
       "      <th>Collar : Button-Down Collar</th>\n",
       "      <th>Pattern : Solid</th>\n",
       "      <th>Occasion : Formal</th>\n",
       "      <th>Collar : Spread Collar</th>\n",
       "      <th>Fit : Slim Fit</th>\n",
       "      <th>Pattern : Textured</th>\n",
       "      <th>Occasion : Casual</th>\n",
       "      <th>...</th>\n",
       "      <th>Insole: Comfort Insole</th>\n",
       "      <th>Toe Shape:  Round Toe</th>\n",
       "      <th>Ankle Height:   Regular</th>\n",
       "      <th>Sole Material:  TPR</th>\n",
       "      <th>Letter Recognition</th>\n",
       "      <th>Letter Sounds</th>\n",
       "      <th>Spelling</th>\n",
       "      <th>Reading Skills</th>\n",
       "      <th>id</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>6396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>6496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>1099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>1599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>1200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>1399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>1599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>1199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>1799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>1599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>1799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>2499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>1499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>1200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>350</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33 rows × 111 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Fit : Regular Fit  Sleeve Length : Long Sleeves  Material : Cotton  \\\n",
       "0                   1                             1                  0   \n",
       "1                   0                             1                  1   \n",
       "2                   0                             1                  1   \n",
       "3                   0                             0                  0   \n",
       "4                   0                             0                  0   \n",
       "5                   0                             0                  0   \n",
       "6                   0                             0                  0   \n",
       "7                   0                             0                  0   \n",
       "8                   0                             0                  0   \n",
       "9                   1                             0                  1   \n",
       "10                  0                             0                  0   \n",
       "11                  0                             0                  0   \n",
       "12                  0                             0                  0   \n",
       "13                  0                             0                  0   \n",
       "14                  0                             0                  0   \n",
       "15                  0                             0                  0   \n",
       "16                  0                             0                  0   \n",
       "17                  0                             0                  0   \n",
       "18                  0                             0                  0   \n",
       "19                  0                             0                  0   \n",
       "20                  0                             0                  0   \n",
       "21                  0                             0                  0   \n",
       "22                  0                             0                  0   \n",
       "23                  0                             0                  0   \n",
       "24                  0                             0                  0   \n",
       "25                  0                             0                  0   \n",
       "26                  0                             0                  0   \n",
       "27                  0                             0                  0   \n",
       "28                  0                             0                  0   \n",
       "29                  0                             0                  0   \n",
       "30                  1                             1                  1   \n",
       "31                  1                             1                  1   \n",
       "32                  1                             0                  1   \n",
       "\n",
       "    Collar : Button-Down Collar  Pattern : Solid  Occasion : Formal  \\\n",
       "0                             0                0                  0   \n",
       "1                             1                1                  1   \n",
       "2                             0                1                  1   \n",
       "3                             0                0                  0   \n",
       "4                             0                0                  0   \n",
       "5                             0                0                  0   \n",
       "6                             0                0                  0   \n",
       "7                             0                0                  0   \n",
       "8                             0                0                  0   \n",
       "9                             0                1                  0   \n",
       "10                            0                0                  0   \n",
       "11                            0                0                  0   \n",
       "12                            0                0                  0   \n",
       "13                            0                0                  0   \n",
       "14                            0                0                  0   \n",
       "15                            0                0                  0   \n",
       "16                            0                0                  0   \n",
       "17                            0                0                  0   \n",
       "18                            0                0                  0   \n",
       "19                            0                0                  0   \n",
       "20                            0                0                  0   \n",
       "21                            0                0                  0   \n",
       "22                            0                0                  0   \n",
       "23                            0                0                  0   \n",
       "24                            0                0                  0   \n",
       "25                            0                0                  0   \n",
       "26                            0                0                  0   \n",
       "27                            0                0                  0   \n",
       "28                            0                0                  0   \n",
       "29                            0                0                  0   \n",
       "30                            0                0                  0   \n",
       "31                            0                0                  0   \n",
       "32                            0                0                  0   \n",
       "\n",
       "    Collar : Spread Collar  Fit : Slim Fit  Pattern : Textured  \\\n",
       "0                        0               0                   0   \n",
       "1                        0               1                   0   \n",
       "2                        0               1                   0   \n",
       "3                        0               0                   0   \n",
       "4                        0               0                   0   \n",
       "5                        0               0                   0   \n",
       "6                        0               0                   0   \n",
       "7                        0               0                   0   \n",
       "8                        0               0                   0   \n",
       "9                        0               0                   0   \n",
       "10                       0               0                   0   \n",
       "11                       0               0                   0   \n",
       "12                       0               0                   0   \n",
       "13                       0               0                   0   \n",
       "14                       0               0                   0   \n",
       "15                       0               0                   0   \n",
       "16                       0               0                   0   \n",
       "17                       0               0                   0   \n",
       "18                       0               0                   0   \n",
       "19                       0               0                   0   \n",
       "20                       0               0                   0   \n",
       "21                       0               0                   0   \n",
       "22                       0               0                   0   \n",
       "23                       0               0                   0   \n",
       "24                       0               0                   0   \n",
       "25                       0               0                   0   \n",
       "26                       0               0                   0   \n",
       "27                       0               0                   0   \n",
       "28                       0               0                   0   \n",
       "29                       0               0                   0   \n",
       "30                       1               0                   0   \n",
       "31                       1               0                   1   \n",
       "32                       0               0                   0   \n",
       "\n",
       "    Occasion : Casual  ...  Insole: Comfort Insole  Toe Shape:  Round Toe  \\\n",
       "0                   0  ...                       0                      0   \n",
       "1                   0  ...                       0                      0   \n",
       "2                   0  ...                       0                      0   \n",
       "3                   0  ...                       0                      0   \n",
       "4                   0  ...                       0                      0   \n",
       "5                   0  ...                       0                      0   \n",
       "6                   0  ...                       0                      0   \n",
       "7                   0  ...                       0                      0   \n",
       "8                   0  ...                       0                      0   \n",
       "9                   1  ...                       0                      0   \n",
       "10                  0  ...                       0                      0   \n",
       "11                  0  ...                       0                      0   \n",
       "12                  0  ...                       0                      0   \n",
       "13                  0  ...                       0                      0   \n",
       "14                  0  ...                       0                      0   \n",
       "15                  0  ...                       0                      0   \n",
       "16                  0  ...                       0                      0   \n",
       "17                  0  ...                       0                      0   \n",
       "18                  0  ...                       0                      0   \n",
       "19                  0  ...                       0                      0   \n",
       "20                  0  ...                       0                      0   \n",
       "21                  0  ...                       0                      0   \n",
       "22                  0  ...                       0                      0   \n",
       "23                  0  ...                       0                      0   \n",
       "24                  0  ...                       1                      1   \n",
       "25                  0  ...                       1                      1   \n",
       "26                  0  ...                       1                      1   \n",
       "27                  0  ...                       1                      1   \n",
       "28                  0  ...                       0                      0   \n",
       "29                  0  ...                       0                      0   \n",
       "30                  1  ...                       0                      0   \n",
       "31                  0  ...                       0                      0   \n",
       "32                  1  ...                       0                      0   \n",
       "\n",
       "    Ankle Height:   Regular  Sole Material:  TPR  Letter Recognition  \\\n",
       "0                         0                    0                   0   \n",
       "1                         0                    0                   0   \n",
       "2                         0                    0                   0   \n",
       "3                         0                    0                   0   \n",
       "4                         0                    0                   0   \n",
       "5                         0                    0                   0   \n",
       "6                         0                    0                   0   \n",
       "7                         0                    0                   0   \n",
       "8                         0                    0                   0   \n",
       "9                         0                    0                   0   \n",
       "10                        0                    0                   0   \n",
       "11                        0                    0                   0   \n",
       "12                        0                    0                   0   \n",
       "13                        0                    0                   0   \n",
       "14                        0                    0                   0   \n",
       "15                        0                    0                   0   \n",
       "16                        0                    0                   0   \n",
       "17                        0                    0                   0   \n",
       "18                        0                    0                   0   \n",
       "19                        0                    0                   0   \n",
       "20                        0                    0                   0   \n",
       "21                        0                    0                   0   \n",
       "22                        0                    0                   0   \n",
       "23                        0                    0                   0   \n",
       "24                        1                    1                   0   \n",
       "25                        1                    1                   0   \n",
       "26                        1                    1                   0   \n",
       "27                        1                    1                   0   \n",
       "28                        0                    0                   1   \n",
       "29                        0                    0                   1   \n",
       "30                        0                    0                   0   \n",
       "31                        0                    0                   0   \n",
       "32                        0                    0                   0   \n",
       "\n",
       "    Letter Sounds  Spelling  Reading Skills  id  price  \n",
       "0               0         0               0   1    699  \n",
       "1               0         0               0   2    563  \n",
       "2               0         0               0   3    654  \n",
       "3               0         0               0   4   1198  \n",
       "4               0         0               0   5   6396  \n",
       "5               0         0               0   6   6496  \n",
       "6               0         0               0   7   1099  \n",
       "7               0         0               0   8    999  \n",
       "8               0         0               0   9   1599  \n",
       "9               0         0               0  10    585  \n",
       "10              0         0               0  11    385  \n",
       "11              0         0               0  12    585  \n",
       "12              0         0               0  13   1200  \n",
       "13              0         0               0  14   1399  \n",
       "14              0         0               0  15    575  \n",
       "15              0         0               0  16    625  \n",
       "16              0         0               0  17    799  \n",
       "17              0         0               0  18   1599  \n",
       "18              0         0               0  19   1199  \n",
       "19              0         0               0  20   1799  \n",
       "20              0         0               0  21   1599  \n",
       "21              0         0               0  22    566  \n",
       "22              0         0               0  23    566  \n",
       "23              0         0               0  24   1799  \n",
       "24              0         0               0  25   2499  \n",
       "25              0         0               0  26    495  \n",
       "26              0         0               0  27   1499  \n",
       "27              0         0               0  28   1200  \n",
       "28              1         1               1  29    213  \n",
       "29              1         1               1  30    599  \n",
       "30              0         0               0  31    649  \n",
       "31              0         0               0  32    649  \n",
       "32              0         0               0  33    350  \n",
       "\n",
       "[33 rows x 111 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "specs.fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "specs.index=specs['id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>Fit : Regular Fit</th>\n",
       "      <th>Sleeve Length : Long Sleeves</th>\n",
       "      <th>Material : Cotton</th>\n",
       "      <th>Collar : Button-Down Collar</th>\n",
       "      <th>Pattern : Solid</th>\n",
       "      <th>Occasion : Formal</th>\n",
       "      <th>Collar : Spread Collar</th>\n",
       "      <th>Fit : Slim Fit</th>\n",
       "      <th>Pattern : Textured</th>\n",
       "      <th>Occasion : Casual</th>\n",
       "      <th>...</th>\n",
       "      <th>Shoe Width: Regular</th>\n",
       "      <th>Insole: Comfort Insole</th>\n",
       "      <th>Toe Shape:  Round Toe</th>\n",
       "      <th>Ankle Height:   Regular</th>\n",
       "      <th>Sole Material:  TPR</th>\n",
       "      <th>Letter Recognition</th>\n",
       "      <th>Letter Sounds</th>\n",
       "      <th>Spelling</th>\n",
       "      <th>Reading Skills</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <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",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>350</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33 rows × 110 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Fit : Regular Fit  Sleeve Length : Long Sleeves  Material : Cotton  \\\n",
       "id                                                                       \n",
       "1                   1                             1                  0   \n",
       "2                   0                             1                  1   \n",
       "3                   0                             1                  1   \n",
       "4                   0                             0                  0   \n",
       "5                   0                             0                  0   \n",
       "6                   0                             0                  0   \n",
       "7                   0                             0                  0   \n",
       "8                   0                             0                  0   \n",
       "9                   0                             0                  0   \n",
       "10                  1                             0                  1   \n",
       "11                  0                             0                  0   \n",
       "12                  0                             0                  0   \n",
       "13                  0                             0                  0   \n",
       "14                  0                             0                  0   \n",
       "15                  0                             0                  0   \n",
       "16                  0                             0                  0   \n",
       "17                  0                             0                  0   \n",
       "18                  0                             0                  0   \n",
       "19                  0                             0                  0   \n",
       "20                  0                             0                  0   \n",
       "21                  0                             0                  0   \n",
       "22                  0                             0                  0   \n",
       "23                  0                             0                  0   \n",
       "24                  0                             0                  0   \n",
       "25                  0                             0                  0   \n",
       "26                  0                             0                  0   \n",
       "27                  0                             0                  0   \n",
       "28                  0                             0                  0   \n",
       "29                  0                             0                  0   \n",
       "30                  0                             0                  0   \n",
       "31                  1                             1                  1   \n",
       "32                  1                             1                  1   \n",
       "33                  1                             0                  1   \n",
       "\n",
       "    Collar : Button-Down Collar  Pattern : Solid  Occasion : Formal  \\\n",
       "id                                                                    \n",
       "1                             0                0                  0   \n",
       "2                             1                1                  1   \n",
       "3                             0                1                  1   \n",
       "4                             0                0                  0   \n",
       "5                             0                0                  0   \n",
       "6                             0                0                  0   \n",
       "7                             0                0                  0   \n",
       "8                             0                0                  0   \n",
       "9                             0                0                  0   \n",
       "10                            0                1                  0   \n",
       "11                            0                0                  0   \n",
       "12                            0                0                  0   \n",
       "13                            0                0                  0   \n",
       "14                            0                0                  0   \n",
       "15                            0                0                  0   \n",
       "16                            0                0                  0   \n",
       "17                            0                0                  0   \n",
       "18                            0                0                  0   \n",
       "19                            0                0                  0   \n",
       "20                            0                0                  0   \n",
       "21                            0                0                  0   \n",
       "22                            0                0                  0   \n",
       "23                            0                0                  0   \n",
       "24                            0                0                  0   \n",
       "25                            0                0                  0   \n",
       "26                            0                0                  0   \n",
       "27                            0                0                  0   \n",
       "28                            0                0                  0   \n",
       "29                            0                0                  0   \n",
       "30                            0                0                  0   \n",
       "31                            0                0                  0   \n",
       "32                            0                0                  0   \n",
       "33                            0                0                  0   \n",
       "\n",
       "    Collar : Spread Collar  Fit : Slim Fit  Pattern : Textured  \\\n",
       "id                                                               \n",
       "1                        0               0                   0   \n",
       "2                        0               1                   0   \n",
       "3                        0               1                   0   \n",
       "4                        0               0                   0   \n",
       "5                        0               0                   0   \n",
       "6                        0               0                   0   \n",
       "7                        0               0                   0   \n",
       "8                        0               0                   0   \n",
       "9                        0               0                   0   \n",
       "10                       0               0                   0   \n",
       "11                       0               0                   0   \n",
       "12                       0               0                   0   \n",
       "13                       0               0                   0   \n",
       "14                       0               0                   0   \n",
       "15                       0               0                   0   \n",
       "16                       0               0                   0   \n",
       "17                       0               0                   0   \n",
       "18                       0               0                   0   \n",
       "19                       0               0                   0   \n",
       "20                       0               0                   0   \n",
       "21                       0               0                   0   \n",
       "22                       0               0                   0   \n",
       "23                       0               0                   0   \n",
       "24                       0               0                   0   \n",
       "25                       0               0                   0   \n",
       "26                       0               0                   0   \n",
       "27                       0               0                   0   \n",
       "28                       0               0                   0   \n",
       "29                       0               0                   0   \n",
       "30                       0               0                   0   \n",
       "31                       1               0                   0   \n",
       "32                       1               0                   1   \n",
       "33                       0               0                   0   \n",
       "\n",
       "    Occasion : Casual  ...  Shoe Width: Regular  Insole: Comfort Insole  \\\n",
       "id                     ...                                                \n",
       "1                   0  ...                    0                       0   \n",
       "2                   0  ...                    0                       0   \n",
       "3                   0  ...                    0                       0   \n",
       "4                   0  ...                    0                       0   \n",
       "5                   0  ...                    0                       0   \n",
       "6                   0  ...                    0                       0   \n",
       "7                   0  ...                    0                       0   \n",
       "8                   0  ...                    0                       0   \n",
       "9                   0  ...                    0                       0   \n",
       "10                  1  ...                    0                       0   \n",
       "11                  0  ...                    0                       0   \n",
       "12                  0  ...                    0                       0   \n",
       "13                  0  ...                    0                       0   \n",
       "14                  0  ...                    0                       0   \n",
       "15                  0  ...                    0                       0   \n",
       "16                  0  ...                    0                       0   \n",
       "17                  0  ...                    0                       0   \n",
       "18                  0  ...                    0                       0   \n",
       "19                  0  ...                    0                       0   \n",
       "20                  0  ...                    0                       0   \n",
       "21                  0  ...                    0                       0   \n",
       "22                  0  ...                    0                       0   \n",
       "23                  0  ...                    0                       0   \n",
       "24                  0  ...                    0                       0   \n",
       "25                  0  ...                    1                       1   \n",
       "26                  0  ...                    1                       1   \n",
       "27                  0  ...                    1                       1   \n",
       "28                  0  ...                    1                       1   \n",
       "29                  0  ...                    0                       0   \n",
       "30                  0  ...                    0                       0   \n",
       "31                  1  ...                    0                       0   \n",
       "32                  0  ...                    0                       0   \n",
       "33                  1  ...                    0                       0   \n",
       "\n",
       "    Toe Shape:  Round Toe  Ankle Height:   Regular  Sole Material:  TPR  \\\n",
       "id                                                                        \n",
       "1                       0                        0                    0   \n",
       "2                       0                        0                    0   \n",
       "3                       0                        0                    0   \n",
       "4                       0                        0                    0   \n",
       "5                       0                        0                    0   \n",
       "6                       0                        0                    0   \n",
       "7                       0                        0                    0   \n",
       "8                       0                        0                    0   \n",
       "9                       0                        0                    0   \n",
       "10                      0                        0                    0   \n",
       "11                      0                        0                    0   \n",
       "12                      0                        0                    0   \n",
       "13                      0                        0                    0   \n",
       "14                      0                        0                    0   \n",
       "15                      0                        0                    0   \n",
       "16                      0                        0                    0   \n",
       "17                      0                        0                    0   \n",
       "18                      0                        0                    0   \n",
       "19                      0                        0                    0   \n",
       "20                      0                        0                    0   \n",
       "21                      0                        0                    0   \n",
       "22                      0                        0                    0   \n",
       "23                      0                        0                    0   \n",
       "24                      0                        0                    0   \n",
       "25                      1                        1                    1   \n",
       "26                      1                        1                    1   \n",
       "27                      1                        1                    1   \n",
       "28                      1                        1                    1   \n",
       "29                      0                        0                    0   \n",
       "30                      0                        0                    0   \n",
       "31                      0                        0                    0   \n",
       "32                      0                        0                    0   \n",
       "33                      0                        0                    0   \n",
       "\n",
       "    Letter Recognition  Letter Sounds  Spelling  Reading Skills  price  \n",
       "id                                                                      \n",
       "1                    0              0         0               0    699  \n",
       "2                    0              0         0               0    563  \n",
       "3                    0              0         0               0    654  \n",
       "4                    0              0         0               0   1198  \n",
       "5                    0              0         0               0   6396  \n",
       "6                    0              0         0               0   6496  \n",
       "7                    0              0         0               0   1099  \n",
       "8                    0              0         0               0    999  \n",
       "9                    0              0         0               0   1599  \n",
       "10                   0              0         0               0    585  \n",
       "11                   0              0         0               0    385  \n",
       "12                   0              0         0               0    585  \n",
       "13                   0              0         0               0   1200  \n",
       "14                   0              0         0               0   1399  \n",
       "15                   0              0         0               0    575  \n",
       "16                   0              0         0               0    625  \n",
       "17                   0              0         0               0    799  \n",
       "18                   0              0         0               0   1599  \n",
       "19                   0              0         0               0   1199  \n",
       "20                   0              0         0               0   1799  \n",
       "21                   0              0         0               0   1599  \n",
       "22                   0              0         0               0    566  \n",
       "23                   0              0         0               0    566  \n",
       "24                   0              0         0               0   1799  \n",
       "25                   0              0         0               0   2499  \n",
       "26                   0              0         0               0    495  \n",
       "27                   0              0         0               0   1499  \n",
       "28                   0              0         0               0   1200  \n",
       "29                   1              1         1               1    213  \n",
       "30                   1              1         1               1    599  \n",
       "31                   0              0         0               0    649  \n",
       "32                   0              0         0               0    649  \n",
       "33                   0              0         0               0    350  \n",
       "\n",
       "[33 rows x 110 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "specs=specs.drop('id',axis='columns').fillna(0)\n",
    "specs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0.99998945, 1.        , 0.99999552, 0.99998687, 0.99998888,\n",
       "       0.99998889, 0.99998689, 0.99998595, 0.99998798, 0.99998626,\n",
       "       0.99997209, 0.99998165, 0.99998618, 0.99998743, 0.99997837,\n",
       "       0.99998128, 0.99998269, 0.99998759, 0.99998652, 0.99998788,\n",
       "       0.99998778, 0.99997959, 0.99997959, 0.99998803, 0.9999884 ,\n",
       "       0.99997671, 0.99998762, 0.99998687, 0.99994488, 0.99998338,\n",
       "       0.99998731, 0.99998731, 0.99996954])"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.metrics.pairwise import cosine_similarity\n",
    "cosine_similarity(specs)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>product_id</th>\n",
       "      <th>spec_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>Sleeve Length : Long Sleeves</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>3</td>\n",
       "      <td>Material : Cotton</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>4</td>\n",
       "      <td>Collar : Button-Down Collar</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>5</td>\n",
       "      <td>Pattern : Solid</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>6</td>\n",
       "      <td>Occasion : Formal</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>10</td>\n",
       "      <td>Fit : Slim Fit</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>36</td>\n",
       "      <td>19</td>\n",
       "      <td>Collar : Mandarin Collar</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id                          name  product_id  spec_id\n",
       "8    2  Sleeve Length : Long Sleeves           2        2\n",
       "13   3             Material : Cotton           2        3\n",
       "16   4   Collar : Button-Down Collar           2        4\n",
       "17   5               Pattern : Solid           2        5\n",
       "20   6             Occasion : Formal           2        6\n",
       "24  10                Fit : Slim Fit           2       10\n",
       "36  19      Collar : Mandarin Collar           2       19"
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "specifications[specifications['product_id']==2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id\n",
       "2     7.0\n",
       "3     5.0\n",
       "10    2.0\n",
       "32    2.0\n",
       "31    2.0\n",
       "1     1.0\n",
       "33    1.0\n",
       "Name: similarity, dtype: float64"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "product_id=2\n",
    "import numpy as np\n",
    "specs['similarity']=np.zeros(len(specs))\n",
    "for i in specs.index:\n",
    "    specs.loc[i,'similarity']=specs.loc[product_id].dot(specs.loc[i])\n",
    "specs.sort_values(by='similarity',ascending=False)[:7]['similarity']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "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>id</th>\n",
       "      <th>desc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Allen solly Mens Cotton Full sleeve Overdyed s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>This classic shirt from Park Avenue is a versa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Be noticed at work by enhancing your looks wit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Wrangler is the everyday performance denim bra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Mineral Glass Magnetic Resistant Shock Resista...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>Mineral Glass Magnetic Resistant Shock Resista...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>ACTIMOB MKTD Allen Solly Men's genuine leather...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>Add a stylish touch to your look when you ador...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>The navy blue propel EL mu idp is from the run...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>Allen Solly Men's Plain Regular Fit Polo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>Shop from a wide range of Top from GMI. Perfec...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>The Vanca light blue top with a round neck at ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>Wrangler is the everyday performance denim bra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>This Anarkali Semi Stitched Gown is Made From ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "      <td>Technical information\\r\\n\\r\\nGeneral\\r\\nBrand ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>16</td>\n",
       "      <td>Keeping in mind her need for the perfect blend...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>17</td>\n",
       "      <td>Campus sport shoes are premium quality light w...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "      <td>Blue solid casual shirt with applique detail, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>White and Blue striped casual shirt, has a spr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>20</td>\n",
       "      <td>Blue medium acid wash 5-pocket mid-rise jeans,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>21</td>\n",
       "      <td>Blue medium wash 5-pocket mid-rise jeans, mild...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>21</td>\n",
       "      <td>22</td>\n",
       "      <td>Red printed woven regular top, has a shoulder ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22</td>\n",
       "      <td>23</td>\n",
       "      <td>Navy Blue printed woven tiered top, has should...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>24</td>\n",
       "      <td>Blue dark wash 5-pocket mid-rise jeans with em...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>25</td>\n",
       "      <td>A pair of round-toe black and white printed fl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25</td>\n",
       "      <td>26</td>\n",
       "      <td>A pair of round-toe black sneakers, has regula...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>26</td>\n",
       "      <td>27</td>\n",
       "      <td>DETAILS\\r\\nSynthetic upper\\r\\nNon-marking rubb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27</td>\n",
       "      <td>28</td>\n",
       "      <td>A pair of round-toe pink shimmer sneakers, has...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28</td>\n",
       "      <td>29</td>\n",
       "      <td>Educational Objective(s)\\t\"Fun with Words\" is ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>29</td>\n",
       "      <td>30</td>\n",
       "      <td>Assembly Required\\tNo\\r\\nBatteries Required\\tN...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>30</td>\n",
       "      <td>31</td>\n",
       "      <td>Maroon and black checked casual shirt, has a s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>31</td>\n",
       "      <td>32</td>\n",
       "      <td>Black and grey checked casual shirt, has a spr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32</td>\n",
       "      <td>33</td>\n",
       "      <td>Brown printed T-shirt, has a round neck, short...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id                                               desc\n",
       "0    1  Allen solly Mens Cotton Full sleeve Overdyed s...\n",
       "1    2  This classic shirt from Park Avenue is a versa...\n",
       "2    3  Be noticed at work by enhancing your looks wit...\n",
       "3    4  Wrangler is the everyday performance denim bra...\n",
       "4    5  Mineral Glass Magnetic Resistant Shock Resista...\n",
       "5    6  Mineral Glass Magnetic Resistant Shock Resista...\n",
       "6    7  ACTIMOB MKTD Allen Solly Men's genuine leather...\n",
       "7    8  Add a stylish touch to your look when you ador...\n",
       "8    9  The navy blue propel EL mu idp is from the run...\n",
       "9   10           Allen Solly Men's Plain Regular Fit Polo\n",
       "10  11  Shop from a wide range of Top from GMI. Perfec...\n",
       "11  12  The Vanca light blue top with a round neck at ...\n",
       "12  13  Wrangler is the everyday performance denim bra...\n",
       "13  14  This Anarkali Semi Stitched Gown is Made From ...\n",
       "14  15  Technical information\\r\\n\\r\\nGeneral\\r\\nBrand ...\n",
       "15  16  Keeping in mind her need for the perfect blend...\n",
       "16  17  Campus sport shoes are premium quality light w...\n",
       "17  18  Blue solid casual shirt with applique detail, ...\n",
       "18  19  White and Blue striped casual shirt, has a spr...\n",
       "19  20  Blue medium acid wash 5-pocket mid-rise jeans,...\n",
       "20  21  Blue medium wash 5-pocket mid-rise jeans, mild...\n",
       "21  22  Red printed woven regular top, has a shoulder ...\n",
       "22  23  Navy Blue printed woven tiered top, has should...\n",
       "23  24  Blue dark wash 5-pocket mid-rise jeans with em...\n",
       "24  25  A pair of round-toe black and white printed fl...\n",
       "25  26  A pair of round-toe black sneakers, has regula...\n",
       "26  27  DETAILS\\r\\nSynthetic upper\\r\\nNon-marking rubb...\n",
       "27  28  A pair of round-toe pink shimmer sneakers, has...\n",
       "28  29  Educational Objective(s)\\t\"Fun with Words\" is ...\n",
       "29  30  Assembly Required\\tNo\\r\\nBatteries Required\\tN...\n",
       "30  31  Maroon and black checked casual shirt, has a s...\n",
       "31  32  Black and grey checked casual shirt, has a spr...\n",
       "32  33  Brown printed T-shirt, has a round neck, short..."
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "addproduct[['id','desc']]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "done!\n",
      "Recommending 5 products similar to This classic shirt from Park Avenue is a versatile style to own in your formal wardrobe. Cut from a cotton blend in a slim fit silhouette, the shirt is finished with a mandarin collar, a barrel cuff, a button placket, and full sleeves. Work it with lighter-hued tailored pants and leather shoes for a smart look....\n",
      "-------\n",
      "Recommended: Be noticed at work by enhancing your looks with this white formal shirt designed by Park Avenue. Made from 100% cotton, this slim-fit shirt features Ainsley collar, barrel cuff, and full sleeves. For a sophisticated look, you can pair it with beige, grey, navy blue or black trousers, leather shoes, and a belt.\r\n",
      "\r\n",
      " (score:0.17689917124825666)\n",
      "Recommended: Maroon and black checked casual shirt, has a spread collar, button placket, 1 pocket, long sleeves, curved hem\r\n",
      "\r\n",
      " (score:0.06065478061486408)\n",
      "Recommended: White and Blue striped casual shirt, has a spread collar, long sleeves, button placket, and curved hem\r\n",
      "\r\n",
      "Material & Care\r\n",
      "Material: Cotton\r\n",
      "Machine Wash (score:0.06043480567007861)\n",
      "Recommended: Blue solid casual shirt with applique detail, has a spread collar, long sleeves, button placket, and curved hem\r\n",
      "\r\n",
      "Material & Care\r\n",
      "Material: 100% cotton\r\n",
      "Machine Wash (score:0.057640426432625166)\n",
      "Recommended: Black and grey checked casual shirt, has a spread collar, button placket, long sleeves with roll-up tabs, a chest pocket, curved hem\r\n",
      "\r\n",
      " (score:0.053011052183530076)\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "from sklearn.metrics.pairwise import linear_kernel\n",
    "\n",
    "ds = addproduct[['id','desc']]\n",
    "\n",
    "tf = TfidfVectorizer(analyzer='word', ngram_range=(1, 3), min_df=0, stop_words='english')\n",
    "tfidf_matrix = tf.fit_transform(ds['desc'])\n",
    "\n",
    "cosine_similarities = linear_kernel(tfidf_matrix, tfidf_matrix)\n",
    "\n",
    "results = {}\n",
    "\n",
    "for idx, row in ds.iterrows():\n",
    "    similar_indices = cosine_similarities[idx].argsort()[:-100:-1]\n",
    "    similar_items = [(cosine_similarities[idx][i], ds['id'][i]) for i in similar_indices]\n",
    "\n",
    "    results[row['id']] = similar_items[1:]\n",
    "    \n",
    "print('done!')\n",
    "\n",
    "def item(id):\n",
    "    return ds.loc[ds['id'] == id]['desc'].tolist()[0].split(' - ')[0]\n",
    "\n",
    "# Just reads the results out of the dictionary.\n",
    "def recommend(item_id, num):\n",
    "    print(\"Recommending \" + str(num) + \" products similar to \" + item(item_id) + \"...\")\n",
    "    print(\"-------\")\n",
    "    recs = results[item_id][:num]\n",
    "    for rec in recs:\n",
    "        print(\"Recommended: \" + item(rec[1]) + \" (score:\" + str(rec[0]) + \")\")\n",
    "\n",
    "recommend(item_id=2, num=5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Fit : Regular Fit               1\n",
       "Sleeve Length : Long Sleeves    1\n",
       "Material : Cotton               0\n",
       "Collar : Button-Down Collar     0\n",
       "Pattern : Solid                 0\n",
       "                               ..\n",
       "Sole Material:  TPR             0\n",
       "Letter Recognition              0\n",
       "Letter Sounds                   0\n",
       "Spelling                        0\n",
       "Reading Skills                  0\n",
       "Name: 1, Length: 109, dtype: int64"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "specifications[specifications['product_id']==]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Fit : Regular Fit               1\n",
       "Sleeve Length : Long Sleeves    1\n",
       "Material : Cotton               0\n",
       "Collar : Button-Down Collar     0\n",
       "Pattern : Solid                 0\n",
       "                               ..\n",
       "Sole Material:  TPR             0\n",
       "Letter Recognition              0\n",
       "Letter Sounds                   0\n",
       "Spelling                        0\n",
       "Reading Skills                  0\n",
       "Name: 1, Length: 109, dtype: int64"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "specs.iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.series.Series"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(specs.iloc[2])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1.0"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "specs.loc[1]['Fit : Regular Fit']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "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>id</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>customer_id</th>\n",
       "      <th>event</th>\n",
       "      <th>product_id</th>\n",
       "      <th>transaction_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [id, timestamp, customer_id, event, product_id, transaction_id]\n",
       "Index: []"
      ]
     },
     "execution_count": 141,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "events"
   ]
  }
 ],
 "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}