tathasthu-Copy1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from fuzzywuzzy import fuzz\n",
    "from fuzzywuzzy import process\n",
    "from fuzzysearch import find_near_matches\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                    article_name\n",
      "0                    Chicken Burger Patty (250G)\n",
      "1              BRITANNIA DAILY FAMILY LONG BREAD\n",
      "2  POOOF POTATO KETTLE CHIPS ZESTY MASALA PP 30g\n",
      "3                            FEVIBOND TUBE 20 ML\n",
      "4             KITKAT DESSERT DELIGHT TRUFFLE 50g\n",
      "         brand_name\n",
      "0     ORGANIC INDIA\n",
      "1  head & shoulders\n",
      "2          Sunfeast\n",
      "3            Unibic\n",
      "4           CREMICA\n"
     ]
    }
   ],
   "source": [
    "train = pd.read_csv('refined.csv')\n",
    "manufacturers = pd.read_csv(\"manufacturer_list.csv\")\n",
    "print(train.head())\n",
    "print(manufacturers.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "train['transformed'] = train['article_name'].str.lower()\n",
    "train['transformed'] = train['transformed'].str.replace(\"'\",\"\")\n",
    "train['transformed'] = train['transformed'].str.replace(\"(\",\"\")\n",
    "train['transformed'] = train['transformed'].str.replace(\")\",\"\")\n",
    "train['transformed'] = train['transformed'].str.replace(\")\",\"\")\n",
    "train['transformed'] = train['transformed'].str.replace(\"/\",\" \")\n",
    "train['transformed'] = train['transformed'].str.replace(\"-\",\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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>article_name</th>\n",
       "      <th>transformed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chicken Burger Patty (250G)</td>\n",
       "      <td>chicken burger patty 250g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BRITANNIA DAILY FAMILY LONG BREAD</td>\n",
       "      <td>britannia daily family long bread</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>POOOF POTATO KETTLE CHIPS ZESTY MASALA PP 30g</td>\n",
       "      <td>pooof potato kettle chips zesty masala pp 30g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FEVIBOND TUBE 20 ML</td>\n",
       "      <td>fevibond tube 20 ml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>KITKAT DESSERT DELIGHT TRUFFLE 50g</td>\n",
       "      <td>kitkat dessert delight truffle 50g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BLUE BIRD SPAGHETTI PASTA 200G</td>\n",
       "      <td>blue bird spaghetti pasta 200g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NIRAPARA AVALOSE PODI 500GM</td>\n",
       "      <td>nirapara avalose podi 500gm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NIVEA ROLL ON FRESH NATURAL 50ml</td>\n",
       "      <td>nivea roll on fresh natural 50ml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FIAMA DW SOAP EXOTIC DREAM BX 115g</td>\n",
       "      <td>fiama dw soap exotic dream bx 115g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SANGIS KTCN PERI PERI MAYONNAISE BT 200g</td>\n",
       "      <td>sangis ktcn peri peri mayonnaise bt 200g</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    article_name  \\\n",
       "0                    Chicken Burger Patty (250G)   \n",
       "1              BRITANNIA DAILY FAMILY LONG BREAD   \n",
       "2  POOOF POTATO KETTLE CHIPS ZESTY MASALA PP 30g   \n",
       "3                            FEVIBOND TUBE 20 ML   \n",
       "4             KITKAT DESSERT DELIGHT TRUFFLE 50g   \n",
       "5                 BLUE BIRD SPAGHETTI PASTA 200G   \n",
       "6                    NIRAPARA AVALOSE PODI 500GM   \n",
       "7               NIVEA ROLL ON FRESH NATURAL 50ml   \n",
       "8             FIAMA DW SOAP EXOTIC DREAM BX 115g   \n",
       "9       SANGIS KTCN PERI PERI MAYONNAISE BT 200g   \n",
       "\n",
       "                                     transformed  \n",
       "0                      chicken burger patty 250g  \n",
       "1              britannia daily family long bread  \n",
       "2  pooof potato kettle chips zesty masala pp 30g  \n",
       "3                            fevibond tube 20 ml  \n",
       "4             kitkat dessert delight truffle 50g  \n",
       "5                 blue bird spaghetti pasta 200g  \n",
       "6                    nirapara avalose podi 500gm  \n",
       "7               nivea roll on fresh natural 50ml  \n",
       "8             fiama dw soap exotic dream bx 115g  \n",
       "9       sangis ktcn peri peri mayonnaise bt 200g  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "train['quantity'] = train['transformed'].str.extract(r'([0-9].*(ml|g|kg|l|s|p))')[0]\n",
    "#train['quantity'] = train['transformed'].str.extract(r'([0-9].*(ml|g|kg|l|s|p))')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>article_name</th>\n",
       "      <th>transformed</th>\n",
       "      <th>quantity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chicken Burger Patty (250G)</td>\n",
       "      <td>chicken burger patty 250g</td>\n",
       "      <td>250g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BRITANNIA DAILY FAMILY LONG BREAD</td>\n",
       "      <td>britannia daily family long bread</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>POOOF POTATO KETTLE CHIPS ZESTY MASALA PP 30g</td>\n",
       "      <td>pooof potato kettle chips zesty masala pp 30g</td>\n",
       "      <td>30g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FEVIBOND TUBE 20 ML</td>\n",
       "      <td>fevibond tube 20 ml</td>\n",
       "      <td>20 ml</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>KITKAT DESSERT DELIGHT TRUFFLE 50g</td>\n",
       "      <td>kitkat dessert delight truffle 50g</td>\n",
       "      <td>50g</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    article_name  \\\n",
       "0                    Chicken Burger Patty (250G)   \n",
       "1              BRITANNIA DAILY FAMILY LONG BREAD   \n",
       "2  POOOF POTATO KETTLE CHIPS ZESTY MASALA PP 30g   \n",
       "3                            FEVIBOND TUBE 20 ML   \n",
       "4             KITKAT DESSERT DELIGHT TRUFFLE 50g   \n",
       "\n",
       "                                     transformed quantity  \n",
       "0                      chicken burger patty 250g     250g  \n",
       "1              britannia daily family long bread      NaN  \n",
       "2  pooof potato kettle chips zesty masala pp 30g      30g  \n",
       "3                            fevibond tube 20 ml    20 ml  \n",
       "4             kitkat dessert delight truffle 50g      50g  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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>brand_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>organic india</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>head &amp; shoulders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>sunfeast</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>unibic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>cremica</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         brand_name\n",
       "0     organic india\n",
       "1  head & shoulders\n",
       "2          sunfeast\n",
       "3            unibic\n",
       "4           cremica"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_small = train.head(100)\n",
    "manufacturers['brand_name'] = manufacturers['brand_name'].str.lower()\n",
    "manufacturers['brand_name'] = manufacturers['brand_name'].str.replace(\"'\",\"\")\n",
    "manufacturers['brand_name'] = manufacturers['brand_name'].str.replace(\"(\",\"\")\n",
    "manufacturers['brand_name'] = manufacturers['brand_name'].str.replace(\")\",\"\")\n",
    "manufacturers['brand_name'] = manufacturers['brand_name'].str.replace(\")\",\"\")\n",
    "manufacturers['brand_name'] = manufacturers['brand_name'].str.replace(\"/\",\" \")\n",
    "manufacturers['brand_name'] = manufacturers['brand_name'].str.replace(\"-\",\"\")\n",
    "manufacturers.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_brand_name(article_name, choices):\n",
    "    brand_name, score, _ = process.extractOne(article_name, choices)\n",
    "    return brand_name, score\n",
    "\n",
    "def get_strict(article_name, choices):\n",
    "    matches = []\n",
    "    for choice in choices:\n",
    "        choice1 = choice + \" \"\n",
    "        choice2 = \" \" + choice + \" \"\n",
    "        choice3 = \" \" + choice\n",
    "        if article_name.startswith(choice1) or article_name.endswith(choice3) or choice2 in article_name:\n",
    "            matches.append(choice)\n",
    "    return matches\n",
    "            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "train_small['strict'] = train_small['transformed'].apply(lambda x: get_strict(x, manufacturers['brand_name']))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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>article_name</th>\n",
       "      <th>transformed</th>\n",
       "      <th>quantity</th>\n",
       "      <th>strict</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chicken Burger Patty (250G)</td>\n",
       "      <td>chicken burger patty 250g</td>\n",
       "      <td>250g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BRITANNIA DAILY FAMILY LONG BREAD</td>\n",
       "      <td>britannia daily family long bread</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[britannia]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>POOOF POTATO KETTLE CHIPS ZESTY MASALA PP 30g</td>\n",
       "      <td>pooof potato kettle chips zesty masala pp 30g</td>\n",
       "      <td>30g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FEVIBOND TUBE 20 ML</td>\n",
       "      <td>fevibond tube 20 ml</td>\n",
       "      <td>20 ml</td>\n",
       "      <td>[fevibond]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>KITKAT DESSERT DELIGHT TRUFFLE 50g</td>\n",
       "      <td>kitkat dessert delight truffle 50g</td>\n",
       "      <td>50g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BLUE BIRD SPAGHETTI PASTA 200G</td>\n",
       "      <td>blue bird spaghetti pasta 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[blue bird]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NIRAPARA AVALOSE PODI 500GM</td>\n",
       "      <td>nirapara avalose podi 500gm</td>\n",
       "      <td>500g</td>\n",
       "      <td>[nirapara]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NIVEA ROLL ON FRESH NATURAL 50ml</td>\n",
       "      <td>nivea roll on fresh natural 50ml</td>\n",
       "      <td>50ml</td>\n",
       "      <td>[nivea]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FIAMA DW SOAP EXOTIC DREAM BX 115g</td>\n",
       "      <td>fiama dw soap exotic dream bx 115g</td>\n",
       "      <td>115g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SANGIS KTCN PERI PERI MAYONNAISE BT 200g</td>\n",
       "      <td>sangis ktcn peri peri mayonnaise bt 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Lakme Absolute Youth Infinity Skin Sculpting S...</td>\n",
       "      <td>lakme absolute youth infinity skin sculpting s...</td>\n",
       "      <td>30 ml</td>\n",
       "      <td>[lakme]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Lakme Absolute Perfect Radiance Skin Lightenin...</td>\n",
       "      <td>lakme absolute perfect radiance skin lightenin...</td>\n",
       "      <td>30 ml</td>\n",
       "      <td>[lakme]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>JALARAM KHAKHRA MOBILE JEERA 180g</td>\n",
       "      <td>jalaram khakhra mobile jeera 180g</td>\n",
       "      <td>180g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>SUPER GUMMY C&amp;L IRON &amp; VITAMINS PP 102g</td>\n",
       "      <td>super gummy c&amp;l iron &amp; vitamins pp 102g</td>\n",
       "      <td>102g</td>\n",
       "      <td>[super gummy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CANTINA H&amp;E 6 TORTILLAS XL PP 360g</td>\n",
       "      <td>cantina h&amp;e 6 tortillas xl pp 360g</td>\n",
       "      <td>6 tortillas xl pp 360g</td>\n",
       "      <td>[cantina]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>DANISA COOKIES BUTTER TN 200g</td>\n",
       "      <td>danisa cookies butter tn 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[danisa]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>SAFFOLA MASALA OATS ITALIAN 39G</td>\n",
       "      <td>saffola masala oats italian 39g</td>\n",
       "      <td>39g</td>\n",
       "      <td>[saffola]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>COLOUR NAT HRCLR DRKEST BRWN NO3 100ml</td>\n",
       "      <td>colour nat hrclr drkest brwn no3 100ml</td>\n",
       "      <td>3 100ml</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>FOODEX SOYA KATORI CHATPATI NAMKEEN 100G</td>\n",
       "      <td>foodex soya katori chatpati namkeen 100g</td>\n",
       "      <td>100g</td>\n",
       "      <td>[foodex]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>SUNFEAST FARMLITE OATS &amp; ALMOND BISCUITS 75G</td>\n",
       "      <td>sunfeast farmlite oats &amp; almond biscuits 75g</td>\n",
       "      <td>75g</td>\n",
       "      <td>[sunfeast]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>UNIBIC SUGARFREE OATMEAL COOKIES 75G</td>\n",
       "      <td>unibic sugarfree oatmeal cookies 75g</td>\n",
       "      <td>75g</td>\n",
       "      <td>[unibic]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>GLUCON-D ORANGE DRINK MIX 100G</td>\n",
       "      <td>glucond orange drink mix 100g</td>\n",
       "      <td>100g</td>\n",
       "      <td>[glucond]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>GLUCON D NIMBU PANI 450G</td>\n",
       "      <td>glucon d nimbu pani 450g</td>\n",
       "      <td>450g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>ORGANIC INDIA ORGAIN TULSI TEA BAG 25G</td>\n",
       "      <td>organic india orgain tulsi tea bag 25g</td>\n",
       "      <td>25g</td>\n",
       "      <td>[organic india]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>THINS ORIGINAL FLAVOUR RICE WAFERS 100G</td>\n",
       "      <td>thins original flavour rice wafers 100g</td>\n",
       "      <td>100g</td>\n",
       "      <td>[thins]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>ROSTAA MORNING BERRIES PP 35g</td>\n",
       "      <td>rostaa morning berries pp 35g</td>\n",
       "      <td>35g</td>\n",
       "      <td>[rostaa]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>ROSTAA ROASTED SALTED PISTACHIO PP 35g</td>\n",
       "      <td>rostaa roasted salted pistachio pp 35g</td>\n",
       "      <td>35g</td>\n",
       "      <td>[rostaa]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>FLYING BIRD KEWRA ESSENCE 20ML</td>\n",
       "      <td>flying bird kewra essence 20ml</td>\n",
       "      <td>20ml</td>\n",
       "      <td>[flying bird]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>FLYING BIRD RIPE MANGO ESSENCE 20ML</td>\n",
       "      <td>flying bird ripe mango essence 20ml</td>\n",
       "      <td>20ml</td>\n",
       "      <td>[flying bird]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>MAGGI NDL CUPPA CHILI CHOW 70g</td>\n",
       "      <td>maggi ndl cuppa chili chow 70g</td>\n",
       "      <td>70g</td>\n",
       "      <td>[maggi]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>GH DAILY URAD DAL PREM 500g</td>\n",
       "      <td>gh daily urad dal prem 500g</td>\n",
       "      <td>500g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>CADBURY BOURNVITA  LIL CHAMP HEALTH DRINK JAR ...</td>\n",
       "      <td>cadbury bournvita  lil champ health drink jar ...</td>\n",
       "      <td>200g</td>\n",
       "      <td>[cadbury]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>GH WHO SPICE BLACK CARDAMM 20g</td>\n",
       "      <td>gh who spice black cardamm 20g</td>\n",
       "      <td>20g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>GH DAILY WHO SPICE RAI 100g</td>\n",
       "      <td>gh daily who spice rai 100g</td>\n",
       "      <td>100g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Sunsilk Nourishing Soft &amp; Smooth Conditioner 8...</td>\n",
       "      <td>sunsilk nourishing soft &amp; smooth conditioner 8...</td>\n",
       "      <td>80 ml</td>\n",
       "      <td>[sunsilk]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>MAYB LIP SMOOTH BALM BERRY CRUSH 4.5g</td>\n",
       "      <td>mayb lip smooth balm berry crush 4.5g</td>\n",
       "      <td>4.5g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>MAGGI SAUCE TOMATO 200g</td>\n",
       "      <td>maggi sauce tomato 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[maggi]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>BOUNTY CHOCOLATES VALUE PACK PP 171g</td>\n",
       "      <td>bounty chocolates value pack pp 171g</td>\n",
       "      <td>171g</td>\n",
       "      <td>[bounty]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>DELICIOUS FROZEN POP CORN BONLESS 250g</td>\n",
       "      <td>delicious frozen pop corn bonless 250g</td>\n",
       "      <td>250g</td>\n",
       "      <td>[delicious, frozen]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>DELICIOUS FROZEN NUGGETS CLASSIC 500g</td>\n",
       "      <td>delicious frozen nuggets classic 500g</td>\n",
       "      <td>500g</td>\n",
       "      <td>[delicious, frozen]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>DAAWAT BASMATI RICE PULAV PP 1kg</td>\n",
       "      <td>daawat basmati rice pulav pp 1kg</td>\n",
       "      <td>1kg</td>\n",
       "      <td>[daawat]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>DAWAT BASMATI RICE BIRYANI PP 1kg</td>\n",
       "      <td>dawat basmati rice biryani pp 1kg</td>\n",
       "      <td>1kg</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>DESI ATTA BHAGAR/SHAMAK/VARAI PP 200g</td>\n",
       "      <td>desi atta bhagar shamak varai pp 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>DESI ATTA RAVA DOSA PP 500g</td>\n",
       "      <td>desi atta rava dosa pp 500g</td>\n",
       "      <td>500g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>JOHNSONS SHMP ACTV KIDS SFT&amp;SMTH BT 100m</td>\n",
       "      <td>johnsons shmp actv kids sft&amp;smth bt 100m</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[johnsons]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>DESI ATTA CO PERI PERI IDLI MIX PP 200g</td>\n",
       "      <td>desi atta co peri peri idli mix pp 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>HALDIRAM NAMKEEN LEMON BHEL PP 150g</td>\n",
       "      <td>haldiram namkeen lemon bhel pp 150g</td>\n",
       "      <td>150g</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>DOVE SHMP REGENERATIVE REPAIR TUBE 240ml</td>\n",
       "      <td>dove shmp regenerative repair tube 240ml</td>\n",
       "      <td>240ml</td>\n",
       "      <td>[dove]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>KWALITY WA ICE CRM TUTI FRTY 700m 1+1 OP</td>\n",
       "      <td>kwality wa ice crm tuti frty 700m 1+1 op</td>\n",
       "      <td>700m 1+1 op</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Kw Magnum Chotruffle 90M</td>\n",
       "      <td>kw magnum chotruffle 90m</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>IMPORTED TWININGS CRANBERRY &amp; RASPBERRY 20PCS</td>\n",
       "      <td>imported twinings cranberry &amp; raspberry 20pcs</td>\n",
       "      <td>20pcs</td>\n",
       "      <td>[twinings]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>IMPORTED TWININGS BLACKCURRANT BURST 20PCS</td>\n",
       "      <td>imported twinings blackcurrant burst 20pcs</td>\n",
       "      <td>20pcs</td>\n",
       "      <td>[twinings]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>TWININGS TEA BAG GREEN TEA JASMINE 25PCS</td>\n",
       "      <td>twinings tea bag green tea jasmine 25pcs</td>\n",
       "      <td>25pcs</td>\n",
       "      <td>[twinings]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>LUX Sandal &amp; Cream Soap Bar 100 g</td>\n",
       "      <td>lux sandal &amp; cream soap bar 100 g</td>\n",
       "      <td>100 g</td>\n",
       "      <td>[lux]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>DILMAH LEMON TEA BAG 25 PCS</td>\n",
       "      <td>dilmah lemon tea bag 25 pcs</td>\n",
       "      <td>25 pcs</td>\n",
       "      <td>[dilmah]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>NILGIRIS CHEESE SPREAD SPICY PEPPER 180g</td>\n",
       "      <td>nilgiris cheese spread spicy pepper 180g</td>\n",
       "      <td>180g</td>\n",
       "      <td>[nilgiris]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>WAFER BISCUIT PINEAPPLE WAFFY</td>\n",
       "      <td>wafer biscuit pineapple waffy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>RiteBite Work out Choco Classic 50gm</td>\n",
       "      <td>ritebite work out choco classic 50gm</td>\n",
       "      <td>50g</td>\n",
       "      <td>[ritebite]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>NILGIRIS BUTTER CASHEW BISCUIT BX 100g</td>\n",
       "      <td>nilgiris butter cashew biscuit bx 100g</td>\n",
       "      <td>100g</td>\n",
       "      <td>[nilgiris]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>HE DEO PERFUMED PASSION SPRAY CN 122ml</td>\n",
       "      <td>he deo perfumed passion spray cn 122ml</td>\n",
       "      <td>122ml</td>\n",
       "      <td>[he]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         article_name  \\\n",
       "0                         Chicken Burger Patty (250G)   \n",
       "1                   BRITANNIA DAILY FAMILY LONG BREAD   \n",
       "2       POOOF POTATO KETTLE CHIPS ZESTY MASALA PP 30g   \n",
       "3                                 FEVIBOND TUBE 20 ML   \n",
       "4                  KITKAT DESSERT DELIGHT TRUFFLE 50g   \n",
       "5                      BLUE BIRD SPAGHETTI PASTA 200G   \n",
       "6                         NIRAPARA AVALOSE PODI 500GM   \n",
       "7                    NIVEA ROLL ON FRESH NATURAL 50ml   \n",
       "8                  FIAMA DW SOAP EXOTIC DREAM BX 115g   \n",
       "9            SANGIS KTCN PERI PERI MAYONNAISE BT 200g   \n",
       "10  Lakme Absolute Youth Infinity Skin Sculpting S...   \n",
       "11  Lakme Absolute Perfect Radiance Skin Lightenin...   \n",
       "12                  JALARAM KHAKHRA MOBILE JEERA 180g   \n",
       "13            SUPER GUMMY C&L IRON & VITAMINS PP 102g   \n",
       "14                 CANTINA H&E 6 TORTILLAS XL PP 360g   \n",
       "15                     DANISA COOKIES BUTTER TN 200g    \n",
       "16                    SAFFOLA MASALA OATS ITALIAN 39G   \n",
       "17             COLOUR NAT HRCLR DRKEST BRWN NO3 100ml   \n",
       "18           FOODEX SOYA KATORI CHATPATI NAMKEEN 100G   \n",
       "19       SUNFEAST FARMLITE OATS & ALMOND BISCUITS 75G   \n",
       "20               UNIBIC SUGARFREE OATMEAL COOKIES 75G   \n",
       "21                     GLUCON-D ORANGE DRINK MIX 100G   \n",
       "22                           GLUCON D NIMBU PANI 450G   \n",
       "23             ORGANIC INDIA ORGAIN TULSI TEA BAG 25G   \n",
       "24            THINS ORIGINAL FLAVOUR RICE WAFERS 100G   \n",
       "25                      ROSTAA MORNING BERRIES PP 35g   \n",
       "26             ROSTAA ROASTED SALTED PISTACHIO PP 35g   \n",
       "27                     FLYING BIRD KEWRA ESSENCE 20ML   \n",
       "28                FLYING BIRD RIPE MANGO ESSENCE 20ML   \n",
       "29                     MAGGI NDL CUPPA CHILI CHOW 70g   \n",
       "..                                                ...   \n",
       "70                        GH DAILY URAD DAL PREM 500g   \n",
       "71  CADBURY BOURNVITA  LIL CHAMP HEALTH DRINK JAR ...   \n",
       "72                     GH WHO SPICE BLACK CARDAMM 20g   \n",
       "73                        GH DAILY WHO SPICE RAI 100g   \n",
       "74  Sunsilk Nourishing Soft & Smooth Conditioner 8...   \n",
       "75              MAYB LIP SMOOTH BALM BERRY CRUSH 4.5g   \n",
       "76                            MAGGI SAUCE TOMATO 200g   \n",
       "77               BOUNTY CHOCOLATES VALUE PACK PP 171g   \n",
       "78             DELICIOUS FROZEN POP CORN BONLESS 250g   \n",
       "79              DELICIOUS FROZEN NUGGETS CLASSIC 500g   \n",
       "80                   DAAWAT BASMATI RICE PULAV PP 1kg   \n",
       "81                  DAWAT BASMATI RICE BIRYANI PP 1kg   \n",
       "82              DESI ATTA BHAGAR/SHAMAK/VARAI PP 200g   \n",
       "83                        DESI ATTA RAVA DOSA PP 500g   \n",
       "84           JOHNSONS SHMP ACTV KIDS SFT&SMTH BT 100m   \n",
       "85            DESI ATTA CO PERI PERI IDLI MIX PP 200g   \n",
       "86                HALDIRAM NAMKEEN LEMON BHEL PP 150g   \n",
       "87           DOVE SHMP REGENERATIVE REPAIR TUBE 240ml   \n",
       "88           KWALITY WA ICE CRM TUTI FRTY 700m 1+1 OP   \n",
       "89                           Kw Magnum Chotruffle 90M   \n",
       "90      IMPORTED TWININGS CRANBERRY & RASPBERRY 20PCS   \n",
       "91         IMPORTED TWININGS BLACKCURRANT BURST 20PCS   \n",
       "92           TWININGS TEA BAG GREEN TEA JASMINE 25PCS   \n",
       "93                  LUX Sandal & Cream Soap Bar 100 g   \n",
       "94                        DILMAH LEMON TEA BAG 25 PCS   \n",
       "95           NILGIRIS CHEESE SPREAD SPICY PEPPER 180g   \n",
       "96                      WAFER BISCUIT PINEAPPLE WAFFY   \n",
       "97               RiteBite Work out Choco Classic 50gm   \n",
       "98             NILGIRIS BUTTER CASHEW BISCUIT BX 100g   \n",
       "99             HE DEO PERFUMED PASSION SPRAY CN 122ml   \n",
       "\n",
       "                                          transformed                quantity  \\\n",
       "0                           chicken burger patty 250g                    250g   \n",
       "1                   britannia daily family long bread                     NaN   \n",
       "2       pooof potato kettle chips zesty masala pp 30g                     30g   \n",
       "3                                 fevibond tube 20 ml                   20 ml   \n",
       "4                  kitkat dessert delight truffle 50g                     50g   \n",
       "5                      blue bird spaghetti pasta 200g                    200g   \n",
       "6                         nirapara avalose podi 500gm                    500g   \n",
       "7                    nivea roll on fresh natural 50ml                    50ml   \n",
       "8                  fiama dw soap exotic dream bx 115g                    115g   \n",
       "9            sangis ktcn peri peri mayonnaise bt 200g                    200g   \n",
       "10  lakme absolute youth infinity skin sculpting s...                   30 ml   \n",
       "11  lakme absolute perfect radiance skin lightenin...                   30 ml   \n",
       "12                  jalaram khakhra mobile jeera 180g                    180g   \n",
       "13            super gummy c&l iron & vitamins pp 102g                    102g   \n",
       "14                 cantina h&e 6 tortillas xl pp 360g  6 tortillas xl pp 360g   \n",
       "15                     danisa cookies butter tn 200g                     200g   \n",
       "16                    saffola masala oats italian 39g                     39g   \n",
       "17             colour nat hrclr drkest brwn no3 100ml                 3 100ml   \n",
       "18           foodex soya katori chatpati namkeen 100g                    100g   \n",
       "19       sunfeast farmlite oats & almond biscuits 75g                     75g   \n",
       "20               unibic sugarfree oatmeal cookies 75g                     75g   \n",
       "21                      glucond orange drink mix 100g                    100g   \n",
       "22                           glucon d nimbu pani 450g                    450g   \n",
       "23             organic india orgain tulsi tea bag 25g                     25g   \n",
       "24            thins original flavour rice wafers 100g                    100g   \n",
       "25                      rostaa morning berries pp 35g                     35g   \n",
       "26             rostaa roasted salted pistachio pp 35g                     35g   \n",
       "27                     flying bird kewra essence 20ml                    20ml   \n",
       "28                flying bird ripe mango essence 20ml                    20ml   \n",
       "29                     maggi ndl cuppa chili chow 70g                     70g   \n",
       "..                                                ...                     ...   \n",
       "70                        gh daily urad dal prem 500g                    500g   \n",
       "71  cadbury bournvita  lil champ health drink jar ...                    200g   \n",
       "72                     gh who spice black cardamm 20g                     20g   \n",
       "73                        gh daily who spice rai 100g                    100g   \n",
       "74  sunsilk nourishing soft & smooth conditioner 8...                   80 ml   \n",
       "75              mayb lip smooth balm berry crush 4.5g                    4.5g   \n",
       "76                            maggi sauce tomato 200g                    200g   \n",
       "77               bounty chocolates value pack pp 171g                    171g   \n",
       "78             delicious frozen pop corn bonless 250g                    250g   \n",
       "79              delicious frozen nuggets classic 500g                    500g   \n",
       "80                   daawat basmati rice pulav pp 1kg                     1kg   \n",
       "81                  dawat basmati rice biryani pp 1kg                     1kg   \n",
       "82              desi atta bhagar shamak varai pp 200g                    200g   \n",
       "83                        desi atta rava dosa pp 500g                    500g   \n",
       "84           johnsons shmp actv kids sft&smth bt 100m                     NaN   \n",
       "85            desi atta co peri peri idli mix pp 200g                    200g   \n",
       "86                haldiram namkeen lemon bhel pp 150g                    150g   \n",
       "87           dove shmp regenerative repair tube 240ml                   240ml   \n",
       "88           kwality wa ice crm tuti frty 700m 1+1 op             700m 1+1 op   \n",
       "89                           kw magnum chotruffle 90m                     NaN   \n",
       "90      imported twinings cranberry & raspberry 20pcs                   20pcs   \n",
       "91         imported twinings blackcurrant burst 20pcs                   20pcs   \n",
       "92           twinings tea bag green tea jasmine 25pcs                   25pcs   \n",
       "93                  lux sandal & cream soap bar 100 g                   100 g   \n",
       "94                        dilmah lemon tea bag 25 pcs                  25 pcs   \n",
       "95           nilgiris cheese spread spicy pepper 180g                    180g   \n",
       "96                      wafer biscuit pineapple waffy                     NaN   \n",
       "97               ritebite work out choco classic 50gm                     50g   \n",
       "98             nilgiris butter cashew biscuit bx 100g                    100g   \n",
       "99             he deo perfumed passion spray cn 122ml                   122ml   \n",
       "\n",
       "                 strict  \n",
       "0                    []  \n",
       "1           [britannia]  \n",
       "2                    []  \n",
       "3            [fevibond]  \n",
       "4                    []  \n",
       "5           [blue bird]  \n",
       "6            [nirapara]  \n",
       "7               [nivea]  \n",
       "8                    []  \n",
       "9                    []  \n",
       "10              [lakme]  \n",
       "11              [lakme]  \n",
       "12                   []  \n",
       "13        [super gummy]  \n",
       "14            [cantina]  \n",
       "15             [danisa]  \n",
       "16            [saffola]  \n",
       "17                   []  \n",
       "18             [foodex]  \n",
       "19           [sunfeast]  \n",
       "20             [unibic]  \n",
       "21            [glucond]  \n",
       "22                   []  \n",
       "23      [organic india]  \n",
       "24              [thins]  \n",
       "25             [rostaa]  \n",
       "26             [rostaa]  \n",
       "27        [flying bird]  \n",
       "28        [flying bird]  \n",
       "29              [maggi]  \n",
       "..                  ...  \n",
       "70                   []  \n",
       "71            [cadbury]  \n",
       "72                   []  \n",
       "73                   []  \n",
       "74            [sunsilk]  \n",
       "75                   []  \n",
       "76              [maggi]  \n",
       "77             [bounty]  \n",
       "78  [delicious, frozen]  \n",
       "79  [delicious, frozen]  \n",
       "80             [daawat]  \n",
       "81                   []  \n",
       "82                   []  \n",
       "83                   []  \n",
       "84           [johnsons]  \n",
       "85                   []  \n",
       "86                   []  \n",
       "87               [dove]  \n",
       "88                   []  \n",
       "89                   []  \n",
       "90           [twinings]  \n",
       "91           [twinings]  \n",
       "92           [twinings]  \n",
       "93                [lux]  \n",
       "94             [dilmah]  \n",
       "95           [nilgiris]  \n",
       "96                   []  \n",
       "97           [ritebite]  \n",
       "98           [nilgiris]  \n",
       "99                 [he]  \n",
       "\n",
       "[100 rows x 4 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_small\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "train_small['fuzzy'] = train_small['transformed'].apply(lambda x: get_brand_name(x, manufacturers['brand_name']))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "train_small = train_small.filter(['article_name','transformed', 'quantity', 'strict']).join(train_small.fuzzy.apply(lambda loc: pd.Series(loc, index=['fuzzy_brand', 'score'])))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>article_name</th>\n",
       "      <th>transformed</th>\n",
       "      <th>quantity</th>\n",
       "      <th>strict</th>\n",
       "      <th>fuzzy_brand</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chicken Burger Patty (250G)</td>\n",
       "      <td>chicken burger patty 250g</td>\n",
       "      <td>250g</td>\n",
       "      <td>[]</td>\n",
       "      <td>chiko</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BRITANNIA DAILY FAMILY LONG BREAD</td>\n",
       "      <td>britannia daily family long bread</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[britannia]</td>\n",
       "      <td>britannia</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>POOOF POTATO KETTLE CHIPS ZESTY MASALA PP 30g</td>\n",
       "      <td>pooof potato kettle chips zesty masala pp 30g</td>\n",
       "      <td>30g</td>\n",
       "      <td>[]</td>\n",
       "      <td>kettle studio</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FEVIBOND TUBE 20 ML</td>\n",
       "      <td>fevibond tube 20 ml</td>\n",
       "      <td>20 ml</td>\n",
       "      <td>[fevibond]</td>\n",
       "      <td>fevibond</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>KITKAT DESSERT DELIGHT TRUFFLE 50g</td>\n",
       "      <td>kitkat dessert delight truffle 50g</td>\n",
       "      <td>50g</td>\n",
       "      <td>[]</td>\n",
       "      <td>set wet</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BLUE BIRD SPAGHETTI PASTA 200G</td>\n",
       "      <td>blue bird spaghetti pasta 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[blue bird]</td>\n",
       "      <td>blue bird</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NIRAPARA AVALOSE PODI 500GM</td>\n",
       "      <td>nirapara avalose podi 500gm</td>\n",
       "      <td>500g</td>\n",
       "      <td>[nirapara]</td>\n",
       "      <td>nirapara</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NIVEA ROLL ON FRESH NATURAL 50ml</td>\n",
       "      <td>nivea roll on fresh natural 50ml</td>\n",
       "      <td>50ml</td>\n",
       "      <td>[nivea]</td>\n",
       "      <td>nivea</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FIAMA DW SOAP EXOTIC DREAM BX 115g</td>\n",
       "      <td>fiama dw soap exotic dream bx 115g</td>\n",
       "      <td>115g</td>\n",
       "      <td>[]</td>\n",
       "      <td>fiama di wills</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SANGIS KTCN PERI PERI MAYONNAISE BT 200g</td>\n",
       "      <td>sangis ktcn peri peri mayonnaise bt 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[]</td>\n",
       "      <td>sangis kitchen</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Lakme Absolute Youth Infinity Skin Sculpting S...</td>\n",
       "      <td>lakme absolute youth infinity skin sculpting s...</td>\n",
       "      <td>30 ml</td>\n",
       "      <td>[lakme]</td>\n",
       "      <td>think skin</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Lakme Absolute Perfect Radiance Skin Lightenin...</td>\n",
       "      <td>lakme absolute perfect radiance skin lightenin...</td>\n",
       "      <td>30 ml</td>\n",
       "      <td>[lakme]</td>\n",
       "      <td>think skin</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>JALARAM KHAKHRA MOBILE JEERA 180g</td>\n",
       "      <td>jalaram khakhra mobile jeera 180g</td>\n",
       "      <td>180g</td>\n",
       "      <td>[]</td>\n",
       "      <td>jalaram foods</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>SUPER GUMMY C&amp;L IRON &amp; VITAMINS PP 102g</td>\n",
       "      <td>super gummy c&amp;l iron &amp; vitamins pp 102g</td>\n",
       "      <td>102g</td>\n",
       "      <td>[super gummy]</td>\n",
       "      <td>super gummy</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CANTINA H&amp;E 6 TORTILLAS XL PP 360g</td>\n",
       "      <td>cantina h&amp;e 6 tortillas xl pp 360g</td>\n",
       "      <td>6 tortillas xl pp 360g</td>\n",
       "      <td>[cantina]</td>\n",
       "      <td>cantina</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>DANISA COOKIES BUTTER TN 200g</td>\n",
       "      <td>danisa cookies butter tn 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[danisa]</td>\n",
       "      <td>danisa</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>SAFFOLA MASALA OATS ITALIAN 39G</td>\n",
       "      <td>saffola masala oats italian 39g</td>\n",
       "      <td>39g</td>\n",
       "      <td>[saffola]</td>\n",
       "      <td>saffola</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>COLOUR NAT HRCLR DRKEST BRWN NO3 100ml</td>\n",
       "      <td>colour nat hrclr drkest brwn no3 100ml</td>\n",
       "      <td>3 100ml</td>\n",
       "      <td>[]</td>\n",
       "      <td>dukes</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>FOODEX SOYA KATORI CHATPATI NAMKEEN 100G</td>\n",
       "      <td>foodex soya katori chatpati namkeen 100g</td>\n",
       "      <td>100g</td>\n",
       "      <td>[foodex]</td>\n",
       "      <td>foodex</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>SUNFEAST FARMLITE OATS &amp; ALMOND BISCUITS 75G</td>\n",
       "      <td>sunfeast farmlite oats &amp; almond biscuits 75g</td>\n",
       "      <td>75g</td>\n",
       "      <td>[sunfeast]</td>\n",
       "      <td>sunfeast</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>UNIBIC SUGARFREE OATMEAL COOKIES 75G</td>\n",
       "      <td>unibic sugarfree oatmeal cookies 75g</td>\n",
       "      <td>75g</td>\n",
       "      <td>[unibic]</td>\n",
       "      <td>unibic</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>GLUCON-D ORANGE DRINK MIX 100G</td>\n",
       "      <td>glucond orange drink mix 100g</td>\n",
       "      <td>100g</td>\n",
       "      <td>[glucond]</td>\n",
       "      <td>glucond</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>GLUCON D NIMBU PANI 450G</td>\n",
       "      <td>glucon d nimbu pani 450g</td>\n",
       "      <td>450g</td>\n",
       "      <td>[]</td>\n",
       "      <td>pan</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>ORGANIC INDIA ORGAIN TULSI TEA BAG 25G</td>\n",
       "      <td>organic india orgain tulsi tea bag 25g</td>\n",
       "      <td>25g</td>\n",
       "      <td>[organic india]</td>\n",
       "      <td>organic india</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>THINS ORIGINAL FLAVOUR RICE WAFERS 100G</td>\n",
       "      <td>thins original flavour rice wafers 100g</td>\n",
       "      <td>100g</td>\n",
       "      <td>[thins]</td>\n",
       "      <td>thins</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>ROSTAA MORNING BERRIES PP 35g</td>\n",
       "      <td>rostaa morning berries pp 35g</td>\n",
       "      <td>35g</td>\n",
       "      <td>[rostaa]</td>\n",
       "      <td>rostaa</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>ROSTAA ROASTED SALTED PISTACHIO PP 35g</td>\n",
       "      <td>rostaa roasted salted pistachio pp 35g</td>\n",
       "      <td>35g</td>\n",
       "      <td>[rostaa]</td>\n",
       "      <td>rostaa</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>FLYING BIRD KEWRA ESSENCE 20ML</td>\n",
       "      <td>flying bird kewra essence 20ml</td>\n",
       "      <td>20ml</td>\n",
       "      <td>[flying bird]</td>\n",
       "      <td>flying bird</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>FLYING BIRD RIPE MANGO ESSENCE 20ML</td>\n",
       "      <td>flying bird ripe mango essence 20ml</td>\n",
       "      <td>20ml</td>\n",
       "      <td>[flying bird]</td>\n",
       "      <td>flying bird</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>MAGGI NDL CUPPA CHILI CHOW 70g</td>\n",
       "      <td>maggi ndl cuppa chili chow 70g</td>\n",
       "      <td>70g</td>\n",
       "      <td>[maggi]</td>\n",
       "      <td>maggi</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>GH DAILY URAD DAL PREM 500g</td>\n",
       "      <td>gh daily urad dal prem 500g</td>\n",
       "      <td>500g</td>\n",
       "      <td>[]</td>\n",
       "      <td>prim</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>CADBURY BOURNVITA  LIL CHAMP HEALTH DRINK JAR ...</td>\n",
       "      <td>cadbury bournvita  lil champ health drink jar ...</td>\n",
       "      <td>200g</td>\n",
       "      <td>[cadbury]</td>\n",
       "      <td>cadbury</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>GH WHO SPICE BLACK CARDAMM 20g</td>\n",
       "      <td>gh who spice black cardamm 20g</td>\n",
       "      <td>20g</td>\n",
       "      <td>[]</td>\n",
       "      <td>old spice</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>GH DAILY WHO SPICE RAI 100g</td>\n",
       "      <td>gh daily who spice rai 100g</td>\n",
       "      <td>100g</td>\n",
       "      <td>[]</td>\n",
       "      <td>old spice</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Sunsilk Nourishing Soft &amp; Smooth Conditioner 8...</td>\n",
       "      <td>sunsilk nourishing soft &amp; smooth conditioner 8...</td>\n",
       "      <td>80 ml</td>\n",
       "      <td>[sunsilk]</td>\n",
       "      <td>sunsilk</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>MAYB LIP SMOOTH BALM BERRY CRUSH 4.5g</td>\n",
       "      <td>mayb lip smooth balm berry crush 4.5g</td>\n",
       "      <td>4.5g</td>\n",
       "      <td>[]</td>\n",
       "      <td>rr</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>MAGGI SAUCE TOMATO 200g</td>\n",
       "      <td>maggi sauce tomato 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[maggi]</td>\n",
       "      <td>maggi</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>BOUNTY CHOCOLATES VALUE PACK PP 171g</td>\n",
       "      <td>bounty chocolates value pack pp 171g</td>\n",
       "      <td>171g</td>\n",
       "      <td>[bounty]</td>\n",
       "      <td>bounty</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>DELICIOUS FROZEN POP CORN BONLESS 250g</td>\n",
       "      <td>delicious frozen pop corn bonless 250g</td>\n",
       "      <td>250g</td>\n",
       "      <td>[delicious, frozen]</td>\n",
       "      <td>delicious</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>DELICIOUS FROZEN NUGGETS CLASSIC 500g</td>\n",
       "      <td>delicious frozen nuggets classic 500g</td>\n",
       "      <td>500g</td>\n",
       "      <td>[delicious, frozen]</td>\n",
       "      <td>delicious</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>DAAWAT BASMATI RICE PULAV PP 1kg</td>\n",
       "      <td>daawat basmati rice pulav pp 1kg</td>\n",
       "      <td>1kg</td>\n",
       "      <td>[daawat]</td>\n",
       "      <td>daawat</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>DAWAT BASMATI RICE BIRYANI PP 1kg</td>\n",
       "      <td>dawat basmati rice biryani pp 1kg</td>\n",
       "      <td>1kg</td>\n",
       "      <td>[]</td>\n",
       "      <td>yan yan</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>DESI ATTA BHAGAR/SHAMAK/VARAI PP 200g</td>\n",
       "      <td>desi atta bhagar shamak varai pp 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[]</td>\n",
       "      <td>desi atta company</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>DESI ATTA RAVA DOSA PP 500g</td>\n",
       "      <td>desi atta rava dosa pp 500g</td>\n",
       "      <td>500g</td>\n",
       "      <td>[]</td>\n",
       "      <td>desi atta company</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>JOHNSONS SHMP ACTV KIDS SFT&amp;SMTH BT 100m</td>\n",
       "      <td>johnsons shmp actv kids sft&amp;smth bt 100m</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[johnsons]</td>\n",
       "      <td>johnsons</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>DESI ATTA CO PERI PERI IDLI MIX PP 200g</td>\n",
       "      <td>desi atta co peri peri idli mix pp 200g</td>\n",
       "      <td>200g</td>\n",
       "      <td>[]</td>\n",
       "      <td>the green snack co.</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>HALDIRAM NAMKEEN LEMON BHEL PP 150g</td>\n",
       "      <td>haldiram namkeen lemon bhel pp 150g</td>\n",
       "      <td>150g</td>\n",
       "      <td>[]</td>\n",
       "      <td>aakash namkeen</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>DOVE SHMP REGENERATIVE REPAIR TUBE 240ml</td>\n",
       "      <td>dove shmp regenerative repair tube 240ml</td>\n",
       "      <td>240ml</td>\n",
       "      <td>[dove]</td>\n",
       "      <td>baby dove</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>KWALITY WA ICE CRM TUTI FRTY 700m 1+1 OP</td>\n",
       "      <td>kwality wa ice crm tuti frty 700m 1+1 op</td>\n",
       "      <td>700m 1+1 op</td>\n",
       "      <td>[]</td>\n",
       "      <td>kwality walls</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Kw Magnum Chotruffle 90M</td>\n",
       "      <td>kw magnum chotruffle 90m</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>ragu</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>IMPORTED TWININGS CRANBERRY &amp; RASPBERRY 20PCS</td>\n",
       "      <td>imported twinings cranberry &amp; raspberry 20pcs</td>\n",
       "      <td>20pcs</td>\n",
       "      <td>[twinings]</td>\n",
       "      <td>twinings</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>IMPORTED TWININGS BLACKCURRANT BURST 20PCS</td>\n",
       "      <td>imported twinings blackcurrant burst 20pcs</td>\n",
       "      <td>20pcs</td>\n",
       "      <td>[twinings]</td>\n",
       "      <td>twinings</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>TWININGS TEA BAG GREEN TEA JASMINE 25PCS</td>\n",
       "      <td>twinings tea bag green tea jasmine 25pcs</td>\n",
       "      <td>25pcs</td>\n",
       "      <td>[twinings]</td>\n",
       "      <td>twinings</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>LUX Sandal &amp; Cream Soap Bar 100 g</td>\n",
       "      <td>lux sandal &amp; cream soap bar 100 g</td>\n",
       "      <td>100 g</td>\n",
       "      <td>[lux]</td>\n",
       "      <td>g bakers</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>DILMAH LEMON TEA BAG 25 PCS</td>\n",
       "      <td>dilmah lemon tea bag 25 pcs</td>\n",
       "      <td>25 pcs</td>\n",
       "      <td>[dilmah]</td>\n",
       "      <td>dilmah</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>NILGIRIS CHEESE SPREAD SPICY PEPPER 180g</td>\n",
       "      <td>nilgiris cheese spread spicy pepper 180g</td>\n",
       "      <td>180g</td>\n",
       "      <td>[nilgiris]</td>\n",
       "      <td>nilgiris</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>WAFER BISCUIT PINEAPPLE WAFFY</td>\n",
       "      <td>wafer biscuit pineapple waffy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>appy</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>RiteBite Work out Choco Classic 50gm</td>\n",
       "      <td>ritebite work out choco classic 50gm</td>\n",
       "      <td>50g</td>\n",
       "      <td>[ritebite]</td>\n",
       "      <td>ritebite</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>NILGIRIS BUTTER CASHEW BISCUIT BX 100g</td>\n",
       "      <td>nilgiris butter cashew biscuit bx 100g</td>\n",
       "      <td>100g</td>\n",
       "      <td>[nilgiris]</td>\n",
       "      <td>nilgiris</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>HE DEO PERFUMED PASSION SPRAY CN 122ml</td>\n",
       "      <td>he deo perfumed passion spray cn 122ml</td>\n",
       "      <td>122ml</td>\n",
       "      <td>[he]</td>\n",
       "      <td>pass pass</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         article_name  \\\n",
       "0                         Chicken Burger Patty (250G)   \n",
       "1                   BRITANNIA DAILY FAMILY LONG BREAD   \n",
       "2       POOOF POTATO KETTLE CHIPS ZESTY MASALA PP 30g   \n",
       "3                                 FEVIBOND TUBE 20 ML   \n",
       "4                  KITKAT DESSERT DELIGHT TRUFFLE 50g   \n",
       "5                      BLUE BIRD SPAGHETTI PASTA 200G   \n",
       "6                         NIRAPARA AVALOSE PODI 500GM   \n",
       "7                    NIVEA ROLL ON FRESH NATURAL 50ml   \n",
       "8                  FIAMA DW SOAP EXOTIC DREAM BX 115g   \n",
       "9            SANGIS KTCN PERI PERI MAYONNAISE BT 200g   \n",
       "10  Lakme Absolute Youth Infinity Skin Sculpting S...   \n",
       "11  Lakme Absolute Perfect Radiance Skin Lightenin...   \n",
       "12                  JALARAM KHAKHRA MOBILE JEERA 180g   \n",
       "13            SUPER GUMMY C&L IRON & VITAMINS PP 102g   \n",
       "14                 CANTINA H&E 6 TORTILLAS XL PP 360g   \n",
       "15                     DANISA COOKIES BUTTER TN 200g    \n",
       "16                    SAFFOLA MASALA OATS ITALIAN 39G   \n",
       "17             COLOUR NAT HRCLR DRKEST BRWN NO3 100ml   \n",
       "18           FOODEX SOYA KATORI CHATPATI NAMKEEN 100G   \n",
       "19       SUNFEAST FARMLITE OATS & ALMOND BISCUITS 75G   \n",
       "20               UNIBIC SUGARFREE OATMEAL COOKIES 75G   \n",
       "21                     GLUCON-D ORANGE DRINK MIX 100G   \n",
       "22                           GLUCON D NIMBU PANI 450G   \n",
       "23             ORGANIC INDIA ORGAIN TULSI TEA BAG 25G   \n",
       "24            THINS ORIGINAL FLAVOUR RICE WAFERS 100G   \n",
       "25                      ROSTAA MORNING BERRIES PP 35g   \n",
       "26             ROSTAA ROASTED SALTED PISTACHIO PP 35g   \n",
       "27                     FLYING BIRD KEWRA ESSENCE 20ML   \n",
       "28                FLYING BIRD RIPE MANGO ESSENCE 20ML   \n",
       "29                     MAGGI NDL CUPPA CHILI CHOW 70g   \n",
       "..                                                ...   \n",
       "70                        GH DAILY URAD DAL PREM 500g   \n",
       "71  CADBURY BOURNVITA  LIL CHAMP HEALTH DRINK JAR ...   \n",
       "72                     GH WHO SPICE BLACK CARDAMM 20g   \n",
       "73                        GH DAILY WHO SPICE RAI 100g   \n",
       "74  Sunsilk Nourishing Soft & Smooth Conditioner 8...   \n",
       "75              MAYB LIP SMOOTH BALM BERRY CRUSH 4.5g   \n",
       "76                            MAGGI SAUCE TOMATO 200g   \n",
       "77               BOUNTY CHOCOLATES VALUE PACK PP 171g   \n",
       "78             DELICIOUS FROZEN POP CORN BONLESS 250g   \n",
       "79              DELICIOUS FROZEN NUGGETS CLASSIC 500g   \n",
       "80                   DAAWAT BASMATI RICE PULAV PP 1kg   \n",
       "81                  DAWAT BASMATI RICE BIRYANI PP 1kg   \n",
       "82              DESI ATTA BHAGAR/SHAMAK/VARAI PP 200g   \n",
       "83                        DESI ATTA RAVA DOSA PP 500g   \n",
       "84           JOHNSONS SHMP ACTV KIDS SFT&SMTH BT 100m   \n",
       "85            DESI ATTA CO PERI PERI IDLI MIX PP 200g   \n",
       "86                HALDIRAM NAMKEEN LEMON BHEL PP 150g   \n",
       "87           DOVE SHMP REGENERATIVE REPAIR TUBE 240ml   \n",
       "88           KWALITY WA ICE CRM TUTI FRTY 700m 1+1 OP   \n",
       "89                           Kw Magnum Chotruffle 90M   \n",
       "90      IMPORTED TWININGS CRANBERRY & RASPBERRY 20PCS   \n",
       "91         IMPORTED TWININGS BLACKCURRANT BURST 20PCS   \n",
       "92           TWININGS TEA BAG GREEN TEA JASMINE 25PCS   \n",
       "93                  LUX Sandal & Cream Soap Bar 100 g   \n",
       "94                        DILMAH LEMON TEA BAG 25 PCS   \n",
       "95           NILGIRIS CHEESE SPREAD SPICY PEPPER 180g   \n",
       "96                      WAFER BISCUIT PINEAPPLE WAFFY   \n",
       "97               RiteBite Work out Choco Classic 50gm   \n",
       "98             NILGIRIS BUTTER CASHEW BISCUIT BX 100g   \n",
       "99             HE DEO PERFUMED PASSION SPRAY CN 122ml   \n",
       "\n",
       "                                          transformed                quantity  \\\n",
       "0                           chicken burger patty 250g                    250g   \n",
       "1                   britannia daily family long bread                     NaN   \n",
       "2       pooof potato kettle chips zesty masala pp 30g                     30g   \n",
       "3                                 fevibond tube 20 ml                   20 ml   \n",
       "4                  kitkat dessert delight truffle 50g                     50g   \n",
       "5                      blue bird spaghetti pasta 200g                    200g   \n",
       "6                         nirapara avalose podi 500gm                    500g   \n",
       "7                    nivea roll on fresh natural 50ml                    50ml   \n",
       "8                  fiama dw soap exotic dream bx 115g                    115g   \n",
       "9            sangis ktcn peri peri mayonnaise bt 200g                    200g   \n",
       "10  lakme absolute youth infinity skin sculpting s...                   30 ml   \n",
       "11  lakme absolute perfect radiance skin lightenin...                   30 ml   \n",
       "12                  jalaram khakhra mobile jeera 180g                    180g   \n",
       "13            super gummy c&l iron & vitamins pp 102g                    102g   \n",
       "14                 cantina h&e 6 tortillas xl pp 360g  6 tortillas xl pp 360g   \n",
       "15                     danisa cookies butter tn 200g                     200g   \n",
       "16                    saffola masala oats italian 39g                     39g   \n",
       "17             colour nat hrclr drkest brwn no3 100ml                 3 100ml   \n",
       "18           foodex soya katori chatpati namkeen 100g                    100g   \n",
       "19       sunfeast farmlite oats & almond biscuits 75g                     75g   \n",
       "20               unibic sugarfree oatmeal cookies 75g                     75g   \n",
       "21                      glucond orange drink mix 100g                    100g   \n",
       "22                           glucon d nimbu pani 450g                    450g   \n",
       "23             organic india orgain tulsi tea bag 25g                     25g   \n",
       "24            thins original flavour rice wafers 100g                    100g   \n",
       "25                      rostaa morning berries pp 35g                     35g   \n",
       "26             rostaa roasted salted pistachio pp 35g                     35g   \n",
       "27                     flying bird kewra essence 20ml                    20ml   \n",
       "28                flying bird ripe mango essence 20ml                    20ml   \n",
       "29                     maggi ndl cuppa chili chow 70g                     70g   \n",
       "..                                                ...                     ...   \n",
       "70                        gh daily urad dal prem 500g                    500g   \n",
       "71  cadbury bournvita  lil champ health drink jar ...                    200g   \n",
       "72                     gh who spice black cardamm 20g                     20g   \n",
       "73                        gh daily who spice rai 100g                    100g   \n",
       "74  sunsilk nourishing soft & smooth conditioner 8...                   80 ml   \n",
       "75              mayb lip smooth balm berry crush 4.5g                    4.5g   \n",
       "76                            maggi sauce tomato 200g                    200g   \n",
       "77               bounty chocolates value pack pp 171g                    171g   \n",
       "78             delicious frozen pop corn bonless 250g                    250g   \n",
       "79              delicious frozen nuggets classic 500g                    500g   \n",
       "80                   daawat basmati rice pulav pp 1kg                     1kg   \n",
       "81                  dawat basmati rice biryani pp 1kg                     1kg   \n",
       "82              desi atta bhagar shamak varai pp 200g                    200g   \n",
       "83                        desi atta rava dosa pp 500g                    500g   \n",
       "84           johnsons shmp actv kids sft&smth bt 100m                     NaN   \n",
       "85            desi atta co peri peri idli mix pp 200g                    200g   \n",
       "86                haldiram namkeen lemon bhel pp 150g                    150g   \n",
       "87           dove shmp regenerative repair tube 240ml                   240ml   \n",
       "88           kwality wa ice crm tuti frty 700m 1+1 op             700m 1+1 op   \n",
       "89                           kw magnum chotruffle 90m                     NaN   \n",
       "90      imported twinings cranberry & raspberry 20pcs                   20pcs   \n",
       "91         imported twinings blackcurrant burst 20pcs                   20pcs   \n",
       "92           twinings tea bag green tea jasmine 25pcs                   25pcs   \n",
       "93                  lux sandal & cream soap bar 100 g                   100 g   \n",
       "94                        dilmah lemon tea bag 25 pcs                  25 pcs   \n",
       "95           nilgiris cheese spread spicy pepper 180g                    180g   \n",
       "96                      wafer biscuit pineapple waffy                     NaN   \n",
       "97               ritebite work out choco classic 50gm                     50g   \n",
       "98             nilgiris butter cashew biscuit bx 100g                    100g   \n",
       "99             he deo perfumed passion spray cn 122ml                   122ml   \n",
       "\n",
       "                 strict          fuzzy_brand  score  \n",
       "0                    []                chiko     72  \n",
       "1           [britannia]            britannia     90  \n",
       "2                    []        kettle studio     86  \n",
       "3            [fevibond]             fevibond     90  \n",
       "4                    []              set wet     64  \n",
       "5           [blue bird]            blue bird     90  \n",
       "6            [nirapara]             nirapara     90  \n",
       "7               [nivea]                nivea     90  \n",
       "8                    []       fiama di wills     86  \n",
       "9                    []       sangis kitchen     86  \n",
       "10              [lakme]           think skin     86  \n",
       "11              [lakme]           think skin     86  \n",
       "12                   []        jalaram foods     86  \n",
       "13        [super gummy]          super gummy     90  \n",
       "14            [cantina]              cantina     90  \n",
       "15             [danisa]               danisa     90  \n",
       "16            [saffola]              saffola     90  \n",
       "17                   []                dukes     72  \n",
       "18             [foodex]               foodex     90  \n",
       "19           [sunfeast]             sunfeast     90  \n",
       "20             [unibic]               unibic     90  \n",
       "21            [glucond]              glucond     90  \n",
       "22                   []                  pan     90  \n",
       "23      [organic india]        organic india     90  \n",
       "24              [thins]                thins     90  \n",
       "25             [rostaa]               rostaa     90  \n",
       "26             [rostaa]               rostaa     90  \n",
       "27        [flying bird]          flying bird     90  \n",
       "28        [flying bird]          flying bird     90  \n",
       "29              [maggi]                maggi     90  \n",
       "..                  ...                  ...    ...  \n",
       "70                   []                 prim     68  \n",
       "71            [cadbury]              cadbury     90  \n",
       "72                   []            old spice     86  \n",
       "73                   []            old spice     86  \n",
       "74            [sunsilk]              sunsilk     90  \n",
       "75                   []                   rr     60  \n",
       "76              [maggi]                maggi     90  \n",
       "77             [bounty]               bounty     90  \n",
       "78  [delicious, frozen]            delicious     90  \n",
       "79  [delicious, frozen]            delicious     90  \n",
       "80             [daawat]               daawat     90  \n",
       "81                   []              yan yan     86  \n",
       "82                   []    desi atta company     86  \n",
       "83                   []    desi atta company     86  \n",
       "84           [johnsons]             johnsons     90  \n",
       "85                   []  the green snack co.     86  \n",
       "86                   []       aakash namkeen     86  \n",
       "87               [dove]            baby dove     86  \n",
       "88                   []        kwality walls     86  \n",
       "89                   []                 ragu     68  \n",
       "90           [twinings]             twinings     90  \n",
       "91           [twinings]             twinings     90  \n",
       "92           [twinings]             twinings     90  \n",
       "93                [lux]             g bakers     86  \n",
       "94             [dilmah]               dilmah     90  \n",
       "95           [nilgiris]             nilgiris     90  \n",
       "96                   []                 appy     68  \n",
       "97           [ritebite]             ritebite     90  \n",
       "98           [nilgiris]             nilgiris     90  \n",
       "99                 [he]            pass pass     86  \n",
       "\n",
       "[100 rows x 6 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_small"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}