11-21-2020_Fuzzy-Matcher_Accelerator_v0.1_SD.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Importing Modules"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-21T00:44:50.489501Z",
     "start_time": "2020-11-21T00:44:49.976316Z"
    }
   },
   "outputs": [],
   "source": [
    "from fuzzy_matcher import FuzzyMatcher\n",
    "\n",
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Preping a demo example"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-21T00:44:50.505504Z",
     "start_time": "2020-11-21T00:44:50.491504Z"
    }
   },
   "outputs": [],
   "source": [
    "string_1 = 'Sparsh Dutta'\n",
    "string_2 = 'Sparsh Dutta rocks!!!'\n",
    "n1 = 400\n",
    "n2 = int(n1/8)\n",
    "\n",
    "base_data = pd.DataFrame()\n",
    "base_data['sess_id'] = range(n1)\n",
    "base_data['Combined_Drug'] = [string_1] * n1\n",
    "\n",
    "comparator_data = pd.DataFrame()\n",
    "comparator_data['drug_id'] = range(n2)\n",
    "comparator_data['Asset_Name'] = [string_2] * n2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-21T00:44:50.536509Z",
     "start_time": "2020-11-21T00:44:50.508187Z"
    }
   },
   "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>sess_id</th>\n",
       "      <th>Combined_Drug</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395</th>\n",
       "      <td>395</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>396</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397</th>\n",
       "      <td>397</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398</th>\n",
       "      <td>398</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>399</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     sess_id Combined_Drug\n",
       "0          0  Sparsh Dutta\n",
       "1          1  Sparsh Dutta\n",
       "2          2  Sparsh Dutta\n",
       "3          3  Sparsh Dutta\n",
       "4          4  Sparsh Dutta\n",
       "..       ...           ...\n",
       "395      395  Sparsh Dutta\n",
       "396      396  Sparsh Dutta\n",
       "397      397  Sparsh Dutta\n",
       "398      398  Sparsh Dutta\n",
       "399      399  Sparsh Dutta\n",
       "\n",
       "[400 rows x 2 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "base_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-21T00:44:50.551601Z",
     "start_time": "2020-11-21T00:44:50.538474Z"
    },
    "scrolled": true
   },
   "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>drug_id</th>\n",
       "      <th>Asset_Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>30</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>31</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>32</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>33</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>34</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>35</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>36</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>37</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>38</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>39</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>40</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>41</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>42</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>43</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>44</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>45</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>46</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>47</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>48</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>49</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    drug_id             Asset_Name\n",
       "0         0  Sparsh Dutta rocks!!!\n",
       "1         1  Sparsh Dutta rocks!!!\n",
       "2         2  Sparsh Dutta rocks!!!\n",
       "3         3  Sparsh Dutta rocks!!!\n",
       "4         4  Sparsh Dutta rocks!!!\n",
       "5         5  Sparsh Dutta rocks!!!\n",
       "6         6  Sparsh Dutta rocks!!!\n",
       "7         7  Sparsh Dutta rocks!!!\n",
       "8         8  Sparsh Dutta rocks!!!\n",
       "9         9  Sparsh Dutta rocks!!!\n",
       "10       10  Sparsh Dutta rocks!!!\n",
       "11       11  Sparsh Dutta rocks!!!\n",
       "12       12  Sparsh Dutta rocks!!!\n",
       "13       13  Sparsh Dutta rocks!!!\n",
       "14       14  Sparsh Dutta rocks!!!\n",
       "15       15  Sparsh Dutta rocks!!!\n",
       "16       16  Sparsh Dutta rocks!!!\n",
       "17       17  Sparsh Dutta rocks!!!\n",
       "18       18  Sparsh Dutta rocks!!!\n",
       "19       19  Sparsh Dutta rocks!!!\n",
       "20       20  Sparsh Dutta rocks!!!\n",
       "21       21  Sparsh Dutta rocks!!!\n",
       "22       22  Sparsh Dutta rocks!!!\n",
       "23       23  Sparsh Dutta rocks!!!\n",
       "24       24  Sparsh Dutta rocks!!!\n",
       "25       25  Sparsh Dutta rocks!!!\n",
       "26       26  Sparsh Dutta rocks!!!\n",
       "27       27  Sparsh Dutta rocks!!!\n",
       "28       28  Sparsh Dutta rocks!!!\n",
       "29       29  Sparsh Dutta rocks!!!\n",
       "30       30  Sparsh Dutta rocks!!!\n",
       "31       31  Sparsh Dutta rocks!!!\n",
       "32       32  Sparsh Dutta rocks!!!\n",
       "33       33  Sparsh Dutta rocks!!!\n",
       "34       34  Sparsh Dutta rocks!!!\n",
       "35       35  Sparsh Dutta rocks!!!\n",
       "36       36  Sparsh Dutta rocks!!!\n",
       "37       37  Sparsh Dutta rocks!!!\n",
       "38       38  Sparsh Dutta rocks!!!\n",
       "39       39  Sparsh Dutta rocks!!!\n",
       "40       40  Sparsh Dutta rocks!!!\n",
       "41       41  Sparsh Dutta rocks!!!\n",
       "42       42  Sparsh Dutta rocks!!!\n",
       "43       43  Sparsh Dutta rocks!!!\n",
       "44       44  Sparsh Dutta rocks!!!\n",
       "45       45  Sparsh Dutta rocks!!!\n",
       "46       46  Sparsh Dutta rocks!!!\n",
       "47       47  Sparsh Dutta rocks!!!\n",
       "48       48  Sparsh Dutta rocks!!!\n",
       "49       49  Sparsh Dutta rocks!!!"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comparator_data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Intiating the Config for Fuzzy Matcher"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-21T00:44:50.864012Z",
     "start_time": "2020-11-21T00:44:50.553572Z"
    }
   },
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "44c1cf1389864960950c4299ef970ccf",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "HBox(children=(HTML(value=''), FloatProgress(value=0.0, max=400.0), HTML(value='')))"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    }
   ],
   "source": [
    "fuzzy_config = {\n",
    "                'base' : {\n",
    "                    'data' : base_data,\n",
    "                    'identifier' : 'sess_id' ,\n",
    "                    'column' : 'Combined_Drug'\n",
    "                },\n",
    "                'comparator' : {\n",
    "                    'data' : comparator_data,\n",
    "                    'identifier' : 'drug_id' ,\n",
    "                    'column' : 'Asset_Name'\n",
    "                },\n",
    "                'top_n' : 2, \n",
    "                'metric' : 'jaro-winkler'\n",
    "                }\n",
    "\n",
    "# Initiating the class\n",
    "fm_extractor = FuzzyMatcher(config=fuzzy_config)\n",
    "# Running the module\n",
    "fm_extractor.run_accelerator()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Viewing the results of fuzzy matcher"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-21T00:44:50.894198Z",
     "start_time": "2020-11-21T00:44:50.866167Z"
    }
   },
   "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>sess_id</th>\n",
       "      <th>Combined_Drug</th>\n",
       "      <th>drug_id_Match_1</th>\n",
       "      <th>Asset_Name_Match_1</th>\n",
       "      <th>Score_Match_1</th>\n",
       "      <th>drug_id_Match_2</th>\n",
       "      <th>Asset_Name_Match_2</th>\n",
       "      <th>Score_Match_2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "      <td>49</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "      <td>12</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "      <td>49</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "      <td>12</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "      <td>49</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "      <td>12</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "      <td>49</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "      <td>12</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "      <td>49</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "      <td>12</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395</th>\n",
       "      <td>395</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "      <td>49</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "      <td>12</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>396</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "      <td>49</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "      <td>12</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397</th>\n",
       "      <td>397</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "      <td>49</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "      <td>12</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398</th>\n",
       "      <td>398</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "      <td>49</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "      <td>12</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>399</td>\n",
       "      <td>Sparsh Dutta</td>\n",
       "      <td>49</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "      <td>12</td>\n",
       "      <td>Sparsh Dutta rocks!!!</td>\n",
       "      <td>0.91</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     sess_id Combined_Drug  drug_id_Match_1     Asset_Name_Match_1  \\\n",
       "0          0  Sparsh Dutta               49  Sparsh Dutta rocks!!!   \n",
       "1          1  Sparsh Dutta               49  Sparsh Dutta rocks!!!   \n",
       "2          2  Sparsh Dutta               49  Sparsh Dutta rocks!!!   \n",
       "3          3  Sparsh Dutta               49  Sparsh Dutta rocks!!!   \n",
       "4          4  Sparsh Dutta               49  Sparsh Dutta rocks!!!   \n",
       "..       ...           ...              ...                    ...   \n",
       "395      395  Sparsh Dutta               49  Sparsh Dutta rocks!!!   \n",
       "396      396  Sparsh Dutta               49  Sparsh Dutta rocks!!!   \n",
       "397      397  Sparsh Dutta               49  Sparsh Dutta rocks!!!   \n",
       "398      398  Sparsh Dutta               49  Sparsh Dutta rocks!!!   \n",
       "399      399  Sparsh Dutta               49  Sparsh Dutta rocks!!!   \n",
       "\n",
       "     Score_Match_1  drug_id_Match_2     Asset_Name_Match_2  Score_Match_2  \n",
       "0             0.91               12  Sparsh Dutta rocks!!!           0.91  \n",
       "1             0.91               12  Sparsh Dutta rocks!!!           0.91  \n",
       "2             0.91               12  Sparsh Dutta rocks!!!           0.91  \n",
       "3             0.91               12  Sparsh Dutta rocks!!!           0.91  \n",
       "4             0.91               12  Sparsh Dutta rocks!!!           0.91  \n",
       "..             ...              ...                    ...            ...  \n",
       "395           0.91               12  Sparsh Dutta rocks!!!           0.91  \n",
       "396           0.91               12  Sparsh Dutta rocks!!!           0.91  \n",
       "397           0.91               12  Sparsh Dutta rocks!!!           0.91  \n",
       "398           0.91               12  Sparsh Dutta rocks!!!           0.91  \n",
       "399           0.91               12  Sparsh Dutta rocks!!!           0.91  \n",
       "\n",
       "[400 rows x 8 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fm_extractor.result_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Checking onto the cache reserve"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-21T00:44:50.909723Z",
     "start_time": "2020-11-21T00:44:50.897167Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "CacheInfo(hits=19999, misses=1, maxsize=100000, currsize=1)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fm_extractor.get_fuzzy_distance.cache_info()"
   ]
  }
 ],
 "metadata": {
  "hide_input": false,
  "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}