rec-med.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "4b121deb",
   "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>drug_name</th>\n",
       "      <th>medical_condition</th>\n",
       "      <th>activity</th>\n",
       "      <th>rt_otc</th>\n",
       "      <th>pregnancy</th>\n",
       "      <th>csa</th>\n",
       "      <th>alcohol</th>\n",
       "      <th>rating</th>\n",
       "      <th>no_of_reviews</th>\n",
       "      <th>drug_link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>phenobarbital</td>\n",
       "      <td>Jaundice</td>\n",
       "      <td>1.00</td>\n",
       "      <td>Rx</td>\n",
       "      <td>D</td>\n",
       "      <td>4</td>\n",
       "      <td>X</td>\n",
       "      <td>9.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>nitrofurantoin</td>\n",
       "      <td>Urinary tract infection</td>\n",
       "      <td>0.85</td>\n",
       "      <td>Rx</td>\n",
       "      <td>B</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.2</td>\n",
       "      <td>1275.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ciprofloxacin</td>\n",
       "      <td>Urinary tract infection</td>\n",
       "      <td>0.80</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.8</td>\n",
       "      <td>397.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>macrobid</td>\n",
       "      <td>Urinary tract infection</td>\n",
       "      <td>0.40</td>\n",
       "      <td>Rx</td>\n",
       "      <td>B</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.3</td>\n",
       "      <td>564.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>cipro</td>\n",
       "      <td>Urinary tract infection</td>\n",
       "      <td>0.35</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.5</td>\n",
       "      <td>171.0</td>\n",
       "      <td>NaN</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>615</th>\n",
       "      <td>Tylenol Plus Children's Cold</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>616</th>\n",
       "      <td>Vanacof</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>617</th>\n",
       "      <td>Vi-Sudo</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>C</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>618</th>\n",
       "      <td>Vicks Formula 44 Custom Care Cough &amp; Cold PM</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.00</td>\n",
       "      <td>OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>Zodryl DAC</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>620 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        drug_name        medical_condition  \\\n",
       "0                                   phenobarbital                 Jaundice   \n",
       "1                                  nitrofurantoin  Urinary tract infection   \n",
       "2                                   ciprofloxacin  Urinary tract infection   \n",
       "3                                        macrobid  Urinary tract infection   \n",
       "4                                           cipro  Urinary tract infection   \n",
       "..                                            ...                      ...   \n",
       "615                  Tylenol Plus Children's Cold              Common Cold   \n",
       "616                                       Vanacof              Common Cold   \n",
       "617                                       Vi-Sudo              Common Cold   \n",
       "618  Vicks Formula 44 Custom Care Cough & Cold PM              Common Cold   \n",
       "619                                    Zodryl DAC              Common Cold   \n",
       "\n",
       "     activity  rt_otc pregnancy csa alcohol  rating  no_of_reviews  drug_link  \n",
       "0        1.00      Rx         D   4       X     9.5            2.0        NaN  \n",
       "1        0.85      Rx         B   N     NaN     4.2         1275.0        NaN  \n",
       "2        0.80      Rx         C   N     NaN     4.8          397.0        NaN  \n",
       "3        0.40     Rx          B   N     NaN     4.3          564.0        NaN  \n",
       "4        0.35     Rx          C   N     NaN     5.5          171.0        NaN  \n",
       "..        ...     ...       ...  ..     ...     ...            ...        ...  \n",
       "615      0.00  Rx/OTC         N   N       N     NaN            NaN        NaN  \n",
       "616      0.00      Rx         C   N       N     NaN            NaN        NaN  \n",
       "617      0.00  Rx/OTC         C   N       X     NaN            NaN        NaN  \n",
       "618      0.00     OTC         N   N       X     NaN            NaN        NaN  \n",
       "619      0.00  Rx/OTC         N   N       X     NaN            NaN        NaN  \n",
       "\n",
       "[620 rows x 10 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df1 = pd.read_csv(r'E:datasets\\drugs_for_common_treatments.csv')\n",
    "df2=pd.read_excel(r'E:datasets\\drugsss.xlsx') #scrapped dataset from internet(drugs.com)\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "35484a71",
   "metadata": {
    "scrolled": false
   },
   "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_name</th>\n",
       "      <th>medical_condition</th>\n",
       "      <th>activity</th>\n",
       "      <th>rt_otc</th>\n",
       "      <th>pregnancy</th>\n",
       "      <th>csa</th>\n",
       "      <th>alcohol</th>\n",
       "      <th>rating</th>\n",
       "      <th>no_of_reviews</th>\n",
       "      <th>drug_link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>phenobarbital</td>\n",
       "      <td>Jaundice</td>\n",
       "      <td>1.00</td>\n",
       "      <td>Rx</td>\n",
       "      <td>D</td>\n",
       "      <td>4</td>\n",
       "      <td>X</td>\n",
       "      <td>9.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>nitrofurantoin</td>\n",
       "      <td>Urinary tract infection</td>\n",
       "      <td>0.85</td>\n",
       "      <td>Rx</td>\n",
       "      <td>B</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.2</td>\n",
       "      <td>1275.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ciprofloxacin</td>\n",
       "      <td>Urinary tract infection</td>\n",
       "      <td>0.80</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.8</td>\n",
       "      <td>397.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>macrobid</td>\n",
       "      <td>Urinary tract infection</td>\n",
       "      <td>0.40</td>\n",
       "      <td>Rx</td>\n",
       "      <td>B</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.3</td>\n",
       "      <td>564.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>cipro</td>\n",
       "      <td>Urinary tract infection</td>\n",
       "      <td>0.35</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.5</td>\n",
       "      <td>171.0</td>\n",
       "      <td>NaN</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>615</th>\n",
       "      <td>Tylenol Plus Children's Cold</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>616</th>\n",
       "      <td>Vanacof</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>617</th>\n",
       "      <td>Vi-Sudo</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>C</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>618</th>\n",
       "      <td>Vicks Formula 44 Custom Care Cough &amp; Cold PM</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.00</td>\n",
       "      <td>OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>Zodryl DAC</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.00</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>620 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        drug_name        medical_condition  \\\n",
       "0                                   phenobarbital                 Jaundice   \n",
       "1                                  nitrofurantoin  Urinary tract infection   \n",
       "2                                   ciprofloxacin  Urinary tract infection   \n",
       "3                                        macrobid  Urinary tract infection   \n",
       "4                                           cipro  Urinary tract infection   \n",
       "..                                            ...                      ...   \n",
       "615                  Tylenol Plus Children's Cold              Common Cold   \n",
       "616                                       Vanacof              Common Cold   \n",
       "617                                       Vi-Sudo              Common Cold   \n",
       "618  Vicks Formula 44 Custom Care Cough & Cold PM              Common Cold   \n",
       "619                                    Zodryl DAC              Common Cold   \n",
       "\n",
       "     activity  rt_otc pregnancy csa alcohol  rating  no_of_reviews  drug_link  \n",
       "0        1.00      Rx         D   4       X     9.5            2.0        NaN  \n",
       "1        0.85      Rx         B   N     NaN     4.2         1275.0        NaN  \n",
       "2        0.80      Rx         C   N     NaN     4.8          397.0        NaN  \n",
       "3        0.40     Rx          B   N     NaN     4.3          564.0        NaN  \n",
       "4        0.35     Rx          C   N     NaN     5.5          171.0        NaN  \n",
       "..        ...     ...       ...  ..     ...     ...            ...        ...  \n",
       "615      0.00  Rx/OTC         N   N       N     NaN            NaN        NaN  \n",
       "616      0.00      Rx         C   N       N     NaN            NaN        NaN  \n",
       "617      0.00  Rx/OTC         C   N       X     NaN            NaN        NaN  \n",
       "618      0.00     OTC         N   N       X     NaN            NaN        NaN  \n",
       "619      0.00  Rx/OTC         N   N       X     NaN            NaN        NaN  \n",
       "\n",
       "[620 rows x 10 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df2.dropna(subset=[\"drug_name\",\"medical_condition\"])\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "3f38e068",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['drug_name', 'medical_condition', 'medical_condition_description',\n",
      "       'activity', 'rx_otc', 'pregnancy_category', 'csa', 'alcohol', 'rating',\n",
      "       'no_of_reviews', 'medical_condition_url', 'drug_link', 'Unnamed: 12',\n",
      "       'Unnamed: 13', 'Unnamed: 14', 'Unnamed: 15', 'Unnamed: 16',\n",
      "       'Unnamed: 17', 'Unnamed: 18', 'Unnamed: 19', 'Unnamed: 20',\n",
      "       'Unnamed: 21', 'Unnamed: 22', 'Unnamed: 23', 'Unnamed: 24',\n",
      "       'Unnamed: 25', 'Unnamed: 26', 'Unnamed: 27', 'Unnamed: 28',\n",
      "       'Unnamed: 29', 'Unnamed: 30', 'Unnamed: 31', 'Unnamed: 32',\n",
      "       'Unnamed: 33', 'Unnamed: 34', 'Unnamed: 35', 'Unnamed: 36',\n",
      "       'Unnamed: 37', 'Unnamed: 38', 'Unnamed: 39', 'Unnamed: 40',\n",
      "       'Unnamed: 41', 'Unnamed: 42', 'Unnamed: 43', 'Unnamed: 44',\n",
      "       'Unnamed: 45', 'Unnamed: 46', 'Unnamed: 47', 'Unnamed: 48',\n",
      "       'Unnamed: 49', 'Unnamed: 50', 'Unnamed: 51', 'Unnamed: 52',\n",
      "       'Unnamed: 53', 'Unnamed: 54', 'Unnamed: 55', 'Unnamed: 56',\n",
      "       'Unnamed: 57', 'Unnamed: 58', 'Unnamed: 59'],\n",
      "      dtype='object')\n",
      "Index(['drug_name', 'medical_condition', 'activity', 'rt_otc', 'pregnancy',\n",
      "       'csa', 'alcohol', 'rating', 'no_of_reviews', 'drug_link'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "print(df1.columns)\n",
    "print(df2.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "c56dd623",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['drug_name', 'medical_condition', 'activity', 'rx_otc',\n",
      "       'pregnancy_category', 'alcohol'],\n",
      "      dtype='object')\n",
      "Index(['drug_name', 'medical_condition', 'activity', 'rt_otc', 'pregnancy',\n",
      "       'alcohol'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "df1=df1.drop(columns=['Unnamed: 12',\n",
    "       'Unnamed: 13', 'Unnamed: 14', 'Unnamed: 15', 'Unnamed: 16',\n",
    "       'Unnamed: 17', 'Unnamed: 18', 'Unnamed: 19', 'Unnamed: 20',\n",
    "       'Unnamed: 21', 'Unnamed: 22', 'Unnamed: 23', 'Unnamed: 24',\n",
    "       'Unnamed: 25', 'Unnamed: 26', 'Unnamed: 27', 'Unnamed: 28',\n",
    "       'Unnamed: 29', 'Unnamed: 30', 'Unnamed: 31', 'Unnamed: 32',\n",
    "       'Unnamed: 33', 'Unnamed: 34', 'Unnamed: 35', 'Unnamed: 36',\n",
    "       'Unnamed: 37', 'Unnamed: 38', 'Unnamed: 39', 'Unnamed: 40',\n",
    "       'Unnamed: 41', 'Unnamed: 42', 'Unnamed: 43', 'Unnamed: 44',\n",
    "       'Unnamed: 45', 'Unnamed: 46', 'Unnamed: 47', 'Unnamed: 48',\n",
    "       'Unnamed: 49', 'Unnamed: 50', 'Unnamed: 51', 'Unnamed: 52',\n",
    "       'Unnamed: 53', 'Unnamed: 54', 'Unnamed: 55', 'Unnamed: 56',\n",
    "       'Unnamed: 57', 'Unnamed: 58', 'Unnamed: 59','medical_condition_description','csa','medical_condition_url', 'drug_link','rating', 'no_of_reviews'])\n",
    "print(df1.columns)\n",
    "\n",
    "df2=df2.drop(columns=['csa', 'rating', 'no_of_reviews', 'drug_link'])\n",
    "print(df2.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "f2c4e480",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['drug_name', 'medical_condition', 'activity', 'rx_otc',\n",
      "       'pregnancy_category', 'alcohol'],\n",
      "      dtype='object')\n",
      "Index(['drug_name', 'medical_condition', 'activity', 'rx_otc',\n",
      "       'pregnancy_category', 'alcohol'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "# Rename the columns\n",
    "df2 = df2.rename(columns={'rt_otc':'rx_otc','pregnancy':'pregnancy_category'})\n",
    "print(df1.columns)\n",
    "print(df2.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "db9998c6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "drug_name             object\n",
      "medical_condition     object\n",
      "activity              object\n",
      "rx_otc                object\n",
      "pregnancy_category    object\n",
      "alcohol               object\n",
      "dtype: object\n",
      "_______________________\n",
      "drug_name              object\n",
      "medical_condition      object\n",
      "activity              float64\n",
      "rx_otc                 object\n",
      "pregnancy_category     object\n",
      "alcohol                object\n",
      "dtype: object\n"
     ]
    }
   ],
   "source": [
    "print(df1.dtypes)\n",
    "print(\"_______________________\")\n",
    "print(df2.dtypes)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "d5d52d1d",
   "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>drug_name</th>\n",
       "      <th>medical_condition</th>\n",
       "      <th>activity</th>\n",
       "      <th>rx_otc</th>\n",
       "      <th>pregnancy_category</th>\n",
       "      <th>alcohol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>doxycycline</td>\n",
       "      <td>Acne</td>\n",
       "      <td>87</td>\n",
       "      <td>Rx</td>\n",
       "      <td>D</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>spironolactone</td>\n",
       "      <td>Acne</td>\n",
       "      <td>82</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>minocycline</td>\n",
       "      <td>Acne</td>\n",
       "      <td>48</td>\n",
       "      <td>Rx</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Accutane</td>\n",
       "      <td>Acne</td>\n",
       "      <td>41</td>\n",
       "      <td>Rx</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>clindamycin</td>\n",
       "      <td>Acne</td>\n",
       "      <td>39</td>\n",
       "      <td>Rx</td>\n",
       "      <td>B</td>\n",
       "      <td>NaN</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>3988</th>\n",
       "      <td>fenfluramine</td>\n",
       "      <td>Weight Loss</td>\n",
       "      <td>1</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3989</th>\n",
       "      <td>Fendique ER</td>\n",
       "      <td>Weight Loss</td>\n",
       "      <td>0</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3990</th>\n",
       "      <td>Imcivree</td>\n",
       "      <td>Weight Loss</td>\n",
       "      <td>0</td>\n",
       "      <td>Rx</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3991</th>\n",
       "      <td>setmelanotide</td>\n",
       "      <td>Weight Loss</td>\n",
       "      <td>0</td>\n",
       "      <td>Rx</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3992</th>\n",
       "      <td>tirzepatide</td>\n",
       "      <td>Weight Loss</td>\n",
       "      <td>0</td>\n",
       "      <td>Rx</td>\n",
       "      <td>NaN</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3993 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           drug_name medical_condition activity rx_otc pregnancy_category  \\\n",
       "0        doxycycline              Acne       87     Rx                  D   \n",
       "1     spironolactone              Acne       82     Rx                  C   \n",
       "2        minocycline              Acne       48     Rx                  D   \n",
       "3           Accutane              Acne       41     Rx                  X   \n",
       "4        clindamycin              Acne       39     Rx                  B   \n",
       "...              ...               ...      ...    ...                ...   \n",
       "3988    fenfluramine       Weight Loss        1     Rx                  C   \n",
       "3989     Fendique ER       Weight Loss        0     Rx                  C   \n",
       "3990        Imcivree       Weight Loss        0     Rx                NaN   \n",
       "3991   setmelanotide       Weight Loss        0     Rx                NaN   \n",
       "3992     tirzepatide       Weight Loss        0     Rx                NaN   \n",
       "\n",
       "     alcohol  \n",
       "0          X  \n",
       "1          X  \n",
       "2        NaN  \n",
       "3          X  \n",
       "4        NaN  \n",
       "...      ...  \n",
       "3988       X  \n",
       "3989       X  \n",
       "3990     NaN  \n",
       "3991     NaN  \n",
       "3992       X  \n",
       "\n",
       "[3993 rows x 6 columns]"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Remove the percentage symbol\n",
    "df1['activity'] = df1['activity'].str.replace('%', '')\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "ec88f5b1",
   "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>drug_name</th>\n",
       "      <th>medical_condition</th>\n",
       "      <th>activity</th>\n",
       "      <th>rx_otc</th>\n",
       "      <th>pregnancy_category</th>\n",
       "      <th>alcohol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>doxycycline</td>\n",
       "      <td>Acne</td>\n",
       "      <td>87</td>\n",
       "      <td>Rx</td>\n",
       "      <td>D</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>spironolactone</td>\n",
       "      <td>Acne</td>\n",
       "      <td>82</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>minocycline</td>\n",
       "      <td>Acne</td>\n",
       "      <td>48</td>\n",
       "      <td>Rx</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Accutane</td>\n",
       "      <td>Acne</td>\n",
       "      <td>41</td>\n",
       "      <td>Rx</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>clindamycin</td>\n",
       "      <td>Acne</td>\n",
       "      <td>39</td>\n",
       "      <td>Rx</td>\n",
       "      <td>B</td>\n",
       "      <td>NaN</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>615</th>\n",
       "      <td>Tylenol Plus Children's Cold</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>616</th>\n",
       "      <td>Vanacof</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>617</th>\n",
       "      <td>Vi-Sudo</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>C</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>618</th>\n",
       "      <td>Vicks Formula 44 Custom Care Cough &amp; Cold PM</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.0</td>\n",
       "      <td>OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>Zodryl DAC</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4613 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        drug_name medical_condition activity  \\\n",
       "0                                     doxycycline              Acne       87   \n",
       "1                                  spironolactone              Acne       82   \n",
       "2                                     minocycline              Acne       48   \n",
       "3                                        Accutane              Acne       41   \n",
       "4                                     clindamycin              Acne       39   \n",
       "..                                            ...               ...      ...   \n",
       "615                  Tylenol Plus Children's Cold       Common Cold      0.0   \n",
       "616                                       Vanacof       Common Cold      0.0   \n",
       "617                                       Vi-Sudo       Common Cold      0.0   \n",
       "618  Vicks Formula 44 Custom Care Cough & Cold PM       Common Cold      0.0   \n",
       "619                                    Zodryl DAC       Common Cold      0.0   \n",
       "\n",
       "     rx_otc pregnancy_category alcohol  \n",
       "0        Rx                  D       X  \n",
       "1        Rx                  C       X  \n",
       "2        Rx                  D     NaN  \n",
       "3        Rx                  X       X  \n",
       "4        Rx                  B     NaN  \n",
       "..      ...                ...     ...  \n",
       "615  Rx/OTC                  N       N  \n",
       "616      Rx                  C       N  \n",
       "617  Rx/OTC                  C       X  \n",
       "618     OTC                  N       X  \n",
       "619  Rx/OTC                  N       X  \n",
       "\n",
       "[4613 rows x 6 columns]"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Merge the datasets based on a common key or index\n",
    "md = pd.concat([df1, df2])\n",
    "md"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "486a5149",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4613"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "3993+620"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "5c56bdbb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of NaN values in : 34\n"
     ]
    }
   ],
   "source": [
    "# Count the number of NaN values in the column\n",
    "nan_count = md['activity'].isna().sum()\n",
    "\n",
    "# Print the number of NaN values\n",
    "print(\"Number of NaN values in :\", nan_count)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "79402c3d",
   "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>drug_name</th>\n",
       "      <th>medical_condition</th>\n",
       "      <th>activity</th>\n",
       "      <th>rx_otc</th>\n",
       "      <th>pregnancy_category</th>\n",
       "      <th>alcohol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>doxycycline</td>\n",
       "      <td>Acne</td>\n",
       "      <td>87</td>\n",
       "      <td>Rx</td>\n",
       "      <td>D</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>spironolactone</td>\n",
       "      <td>Acne</td>\n",
       "      <td>82</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>minocycline</td>\n",
       "      <td>Acne</td>\n",
       "      <td>48</td>\n",
       "      <td>Rx</td>\n",
       "      <td>D</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Accutane</td>\n",
       "      <td>Acne</td>\n",
       "      <td>41</td>\n",
       "      <td>Rx</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>clindamycin</td>\n",
       "      <td>Acne</td>\n",
       "      <td>39</td>\n",
       "      <td>Rx</td>\n",
       "      <td>B</td>\n",
       "      <td>NaN</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>615</th>\n",
       "      <td>Tylenol Plus Children's Cold</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>616</th>\n",
       "      <td>Vanacof</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>617</th>\n",
       "      <td>Vi-Sudo</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>C</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>618</th>\n",
       "      <td>Vicks Formula 44 Custom Care Cough &amp; Cold PM</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.0</td>\n",
       "      <td>OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>Zodryl DAC</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4330 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        drug_name medical_condition activity  \\\n",
       "0                                     doxycycline              Acne       87   \n",
       "1                                  spironolactone              Acne       82   \n",
       "2                                     minocycline              Acne       48   \n",
       "3                                        Accutane              Acne       41   \n",
       "4                                     clindamycin              Acne       39   \n",
       "..                                            ...               ...      ...   \n",
       "615                  Tylenol Plus Children's Cold       Common Cold      0.0   \n",
       "616                                       Vanacof       Common Cold      0.0   \n",
       "617                                       Vi-Sudo       Common Cold      0.0   \n",
       "618  Vicks Formula 44 Custom Care Cough & Cold PM       Common Cold      0.0   \n",
       "619                                    Zodryl DAC       Common Cold      0.0   \n",
       "\n",
       "     rx_otc pregnancy_category alcohol  \n",
       "0        Rx                  D       X  \n",
       "1        Rx                  C       X  \n",
       "2        Rx                  D     NaN  \n",
       "3        Rx                  X       X  \n",
       "4        Rx                  B     NaN  \n",
       "..      ...                ...     ...  \n",
       "615  Rx/OTC                  N       N  \n",
       "616      Rx                  C       N  \n",
       "617  Rx/OTC                  C       X  \n",
       "618     OTC                  N       X  \n",
       "619  Rx/OTC                  N       X  \n",
       "\n",
       "[4330 rows x 6 columns]"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "md=md.dropna(subset=['activity','pregnancy_category'])\n",
    "md"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "508f89fd",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Rx_OTC\n",
    "\n",
    "# Rx-to-OTC switch is the transfer of proven prescription drugs to nonprescription, where\n",
    "# OTC (Over-the-counter) = Medication that can be purchased without a medical prescription\n",
    "# Rx = Prescription Needed\n",
    "# Rx/OTC = Prescription or Over-the-counter.\n",
    "\n",
    "# pregnancy:\n",
    "\n",
    "# A- no risk at first trimester of pregnancy by that drug\n",
    "# B- by Animal studies:no risk on fetus (pregnant women)--no sufficient studies conducted in humans. \n",
    "# C- by Animal studies:risk on fetus but can use for potential benefits --no sufficient studies conducted in humans. \n",
    "# D- by Human studies: risk on fetus but can use for potential benefits\n",
    "# X- Should not use by pregnant women\n",
    "# N- not been classified by the FDA in terms of its safety during pregnancy\n",
    "\n",
    "# PRIORITY(from safe to harmful):\n",
    "#     A-B-C/D-N-X \n",
    "    \n",
    "# alchohol:\n",
    "    \n",
    "# X- interacts with alcohol\n",
    "# N -no alcohol interaction"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "adfa5ac7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Rx                                                            2734\n",
       "Rx/OTC                                                        1032\n",
       "OTC                                                            479\n",
       " 2021 Clover Pharmaceuticals announced that the randomized      34\n",
       "Rx                                                              34\n",
       "OTC                                                             15\n",
       "Rx                                                               1\n",
       "Name: rx_otc, dtype: int64"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "md.rx_otc.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "2f9bdd09",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\python\\lib\\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: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Rx                                                           2769\n",
       "Rx/OTC                                                       1032\n",
       "OTC                                                           494\n",
       "2021 Clover Pharmaceuticals announced that the randomized      34\n",
       "Name: rx_otc, dtype: int64"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "md['rx_otc'] = md['rx_otc'].str.strip()\n",
    "md.rx_otc.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "0b2af48f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Rx        2769\n",
       "Rx/OTC    1032\n",
       "OTC        494\n",
       "Name: rx_otc, dtype: int64"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Drop rows based on the specified condition\n",
    "md = md[md['rx_otc'] != \"2021 Clover Pharmaceuticals announced that the randomized\"]\n",
    "md.rx_otc.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "fc1ef887",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "X    2205\n",
       "N      56\n",
       "Name: alcohol, dtype: int64"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "md.alcohol.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "31759a91",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\python\\lib\\site-packages\\pandas\\core\\generic.py:6392: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  return self._update_inplace(result)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "X    2205\n",
       "N    2091\n",
       "Name: alcohol, dtype: int64"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "md['alcohol'].fillna(\"N\", inplace=True)\n",
    "md.alcohol.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "460f8f80",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "drug_name             object\n",
      "medical_condition     object\n",
      "activity               int32\n",
      "rx_otc                object\n",
      "pregnancy_category    object\n",
      "alcohol               object\n",
      "dtype: object\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\python\\lib\\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: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "md['activity'] = md['activity'].astype(int)\n",
    "print(md.dtypes)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "id": "60891c55",
   "metadata": {},
   "outputs": [],
   "source": [
    "md.to_csv('E:/datasets/rec-med.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bc36708e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "efc48f95",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0a1d9f96",
   "metadata": {},
   "outputs": [],
   "source": [
    "#finding how many diseases are covered(after scrapping(rec-med.csv) and before scrapping(dis-sym-cat))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "4b3ef3d2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "61\n",
      "['Acne' 'ADHD' 'AIDS/HIV' 'Allergies' \"Alzheimer's\" 'Angina' 'Anxiety'\n",
      " 'Asthma' 'Bipolar Disorder' 'Bronchitis' 'Cancer' 'Cholesterol'\n",
      " 'Colds & Flu' 'Constipation' 'COPD' 'Depression' 'Diabetes (Type 1)'\n",
      " 'Diabetes (Type 2)' 'Diarrhea' 'Eczema' 'Erectile Dysfunction'\n",
      " 'Gastrointestinal' 'GERD (Heartburn)' 'Gout' 'Hair Loss' 'Hayfever'\n",
      " 'Herpes' 'Hypertension' 'Hypothyroidism' 'IBD (Bowel)' 'Incontinence'\n",
      " 'Insomnia' 'Menopause' 'Migraine' 'Osteoarthritis' 'Osteoporosis' 'Pain'\n",
      " 'Pneumonia' 'Psoriasis' 'Rheumatoid Arthritis' 'Schizophrenia' 'Seizures'\n",
      " 'Stroke' 'Swine Flu' 'UTI' 'Weight Loss' 'Jaundice'\n",
      " 'Urinary tract infection' 'Hepatitis A' 'Malaria' 'Peptic ulcer'\n",
      " 'Hypoglycemia' 'Hepatitis C' 'Varicose veins' 'Impetigo' 'Vertigo'\n",
      " 'Fungal Infections' 'Hepatitis B' 'Hemorrhoids' 'Myocardial infarction'\n",
      " 'Common Cold']\n",
      "41\n",
      "['Fungal infection' 'Allergy' 'GERD' 'Chronic cholestasis' 'Drug Reaction'\n",
      " 'Peptic ulcer diseae' 'AIDS' 'Diabetes ' 'Gastroenteritis'\n",
      " 'Bronchial Asthma' 'Hypertension ' 'Migraine' 'Cervical spondylosis'\n",
      " 'Paralysis (brain hemorrhage)' 'Jaundice' 'Malaria' 'Chicken pox'\n",
      " 'Dengue' 'Typhoid' 'hepatitis A' 'Hepatitis B' 'Hepatitis C'\n",
      " 'Hepatitis D' 'Hepatitis E' 'Alcoholic hepatitis' 'Tuberculosis'\n",
      " 'Common Cold' 'Pneumonia' 'Dimorphic hemmorhoids(piles)' 'Heart attack'\n",
      " 'Varicose veins' 'Hypothyroidism' 'Hyperthyroidism' 'Hypoglycemia'\n",
      " 'Osteoarthristis' 'Arthritis' '(vertigo) Paroymsal  Positional Vertigo'\n",
      " 'Acne' 'Urinary tract infection' 'Psoriasis' 'Impetigo']\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "md=pd.read_csv(\"E:/datasets/rec-med.csv\")\n",
    "list1=md.medical_condition.unique()\n",
    "print(len(list1))\n",
    "print(list1)\n",
    "df=pd.read_csv(\"E:\\datasets\\dis-sym-cat.csv\")\n",
    "list2=df.Disease.unique()\n",
    "print(len(list2))\n",
    "print(list2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "6442da2b",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\python\\lib\\site-packages\\fuzzywuzzy\\fuzz.py:11: UserWarning: Using slow pure-python SequenceMatcher. Install python-Levenshtein to remove this warning\n",
      "  warnings.warn('Using slow pure-python SequenceMatcher. Install python-Levenshtein to remove this warning')\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Fungal infection -- Fungal Infections\n",
      "GERD -- GERD (Heartburn)\n",
      "Peptic ulcer diseae -- Peptic ulcer\n",
      "AIDS -- AIDS/HIV\n",
      "Diabetes  -- Diabetes (Type 1)\n",
      "Bronchial Asthma -- Asthma\n",
      "Hypertension  -- Hypertension\n",
      "Migraine -- Migraine\n",
      "Jaundice -- Jaundice\n",
      "Malaria -- Malaria\n",
      "hepatitis A -- Hepatitis A\n",
      "Hepatitis B -- Hepatitis A\n",
      "Hepatitis C -- Hepatitis A\n",
      "Hepatitis D -- Hepatitis A\n",
      "Hepatitis E -- Hepatitis A\n",
      "Alcoholic hepatitis -- Hepatitis A\n",
      "Common Cold -- Common Cold\n",
      "Pneumonia -- Pneumonia\n",
      "Dimorphic hemmorhoids(piles) -- Hemorrhoids\n",
      "Varicose veins -- Varicose veins\n",
      "Hypothyroidism -- Hypothyroidism\n",
      "Hyperthyroidism -- Hypothyroidism\n",
      "Hypoglycemia -- Hypoglycemia\n",
      "Osteoarthristis -- Osteoarthritis\n",
      "Arthritis -- Osteoarthritis\n",
      "(vertigo) Paroymsal  Positional Vertigo -- Vertigo\n",
      "Acne -- Acne\n",
      "Urinary tract infection -- Urinary tract infection\n",
      "Psoriasis -- Psoriasis\n",
      "Impetigo -- Impetigo\n",
      "count: 30\n",
      "['Fungal infection', 'GERD', 'Peptic ulcer diseae', 'AIDS', 'Diabetes ', 'Bronchial Asthma', 'Hypertension ', 'Migraine', 'Jaundice', 'Malaria', 'hepatitis A', 'Hepatitis B', 'Hepatitis C', 'Hepatitis D', 'Hepatitis E', 'Alcoholic hepatitis', 'Common Cold', 'Pneumonia', 'Dimorphic hemmorhoids(piles)', 'Varicose veins', 'Hypothyroidism', 'Hyperthyroidism', 'Hypoglycemia', 'Osteoarthristis', 'Arthritis', '(vertigo) Paroymsal  Positional Vertigo', 'Acne', 'Urinary tract infection', 'Psoriasis', 'Impetigo']\n"
     ]
    }
   ],
   "source": [
    "from fuzzywuzzy import fuzz\n",
    "\n",
    "temp=[]\n",
    "def print_similar_elements(list1, list2, similarity_threshold,c=0):\n",
    "\n",
    "    for elmt1 in list1:\n",
    "        for elmt2 in list2:\n",
    "            token_set_ratio = fuzz.token_set_ratio(elmt1, elmt2)\n",
    "            token_sort_ratio = fuzz.token_sort_ratio(elmt1, elmt2)\n",
    "            wratio = fuzz.WRatio(elmt1, elmt2)\n",
    "\n",
    "            # Return the maximum similarity score\n",
    "            similarity_score=max(token_set_ratio, token_sort_ratio, wratio)\n",
    "            if similarity_score > similarity_threshold:\n",
    "                c+=1\n",
    "                temp.append(elmt1)\n",
    "                print(elmt1, \"--\", elmt2)\n",
    "                break  # Break out of the inner loop after finding a match\n",
    "    print(\"count:\",c)\n",
    "# Print similar elements with similarity above 70\n",
    "similarity_threshold = 75\n",
    "print_similar_elements(list2, list1, similarity_threshold,c=0)\n",
    "\n",
    "print(temp)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0d5db7c4",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0d4e1a3c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4f001fe5",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b6cc53a1",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4b0ee486",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "21cadd0b",
   "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>drug_name</th>\n",
       "      <th>medical_condition</th>\n",
       "      <th>activity</th>\n",
       "      <th>rx_otc</th>\n",
       "      <th>pregnancy_category</th>\n",
       "      <th>alcohol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>doxycycline</td>\n",
       "      <td>Acne</td>\n",
       "      <td>87</td>\n",
       "      <td>Rx</td>\n",
       "      <td>D</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>spironolactone</td>\n",
       "      <td>Acne</td>\n",
       "      <td>82</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>minocycline</td>\n",
       "      <td>Acne</td>\n",
       "      <td>48</td>\n",
       "      <td>Rx</td>\n",
       "      <td>D</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Accutane</td>\n",
       "      <td>Acne</td>\n",
       "      <td>41</td>\n",
       "      <td>Rx</td>\n",
       "      <td>X</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>clindamycin</td>\n",
       "      <td>Acne</td>\n",
       "      <td>39</td>\n",
       "      <td>Rx</td>\n",
       "      <td>B</td>\n",
       "      <td>N</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>4291</th>\n",
       "      <td>Tylenol Plus Children's Cold</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4292</th>\n",
       "      <td>Vanacof</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0</td>\n",
       "      <td>Rx</td>\n",
       "      <td>C</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4293</th>\n",
       "      <td>Vi-Sudo</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>C</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4294</th>\n",
       "      <td>Vicks Formula 44 Custom Care Cough &amp; Cold PM</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0</td>\n",
       "      <td>OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4295</th>\n",
       "      <td>Zodryl DAC</td>\n",
       "      <td>Common Cold</td>\n",
       "      <td>0</td>\n",
       "      <td>Rx/OTC</td>\n",
       "      <td>N</td>\n",
       "      <td>X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4296 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         drug_name medical_condition  \\\n",
       "0                                      doxycycline              Acne   \n",
       "1                                   spironolactone              Acne   \n",
       "2                                      minocycline              Acne   \n",
       "3                                         Accutane              Acne   \n",
       "4                                      clindamycin              Acne   \n",
       "...                                            ...               ...   \n",
       "4291                  Tylenol Plus Children's Cold       Common Cold   \n",
       "4292                                       Vanacof       Common Cold   \n",
       "4293                                       Vi-Sudo       Common Cold   \n",
       "4294  Vicks Formula 44 Custom Care Cough & Cold PM       Common Cold   \n",
       "4295                                    Zodryl DAC       Common Cold   \n",
       "\n",
       "      activity  rx_otc pregnancy_category alcohol  \n",
       "0           87      Rx                  D       X  \n",
       "1           82      Rx                  C       X  \n",
       "2           48      Rx                  D       N  \n",
       "3           41      Rx                  X       X  \n",
       "4           39      Rx                  B       N  \n",
       "...        ...     ...                ...     ...  \n",
       "4291         0  Rx/OTC                  N       N  \n",
       "4292         0      Rx                  C       N  \n",
       "4293         0  Rx/OTC                  C       X  \n",
       "4294         0     OTC                  N       X  \n",
       "4295         0  Rx/OTC                  N       X  \n",
       "\n",
       "[4296 rows x 6 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "md=pd.read_csv('E:/datasets/rec-med.csv')\n",
    "md"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "56581cf3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "What is your age? 10\n",
      "What is your gender? male\n",
      "Please enter the name of the disease: Acne\n",
      "How long have you been facing this disease? (in days)3\n",
      "Acne 10 male ['A', 'B', 'C', 'D', 'N', 'X'] None 3\n",
      "             drug_name medical_condition  activity  rx_otc pregnancy_category  \\\n",
      "110           Acetoxyl              Acne         0  Rx/OTC                  C   \n",
      "111            Acne-10              Acne         0     OTC                  C   \n",
      "112         Acne-Clear              Acne         0      Rx                  C   \n",
      "113            Acnevir              Acne         0  Rx/OTC                  C   \n",
      "114            Acnomel              Acne         0     OTC                  N   \n",
      "115  Acnomel Acne Mask              Acne         0  Rx/OTC                  C   \n",
      "116       Acnomel BP 5              Acne         0  Rx/OTC                  C   \n",
      "117            Aktipak              Acne         0      Rx                  C   \n",
      "118             Akurza              Acne         0  Rx/OTC                  C   \n",
      "119            Aliclen              Acne         0  Rx/OTC                  C   \n",
      "\n",
      "    alcohol  \n",
      "110       N  \n",
      "111       N  \n",
      "112       N  \n",
      "113       N  \n",
      "114       N  \n",
      "115       N  \n",
      "116       N  \n",
      "117       N  \n",
      "118       N  \n",
      "119       N  \n"
     ]
    }
   ],
   "source": [
    "def recmedicine(disease,age,gender,pregnancy_condition,alcohol,duration):\n",
    "    print(disease,age,gender,pregnancy_condition,alcohol,duration)\n",
    "    \n",
    "    \n",
    "    # Filter the DataFrame based on the disease\n",
    "    filtered_df = md[md['medical_condition'] == disease]\n",
    "   \n",
    "\n",
    "    if pregnancy_condition is not None:\n",
    "        # Filter the DataFrame based on the allowed pregnancy categories\n",
    "        filtered_df = filtered_df[filtered_df['pregnancy_category'].isin(allowed_pregnancy_category)]\n",
    "    \n",
    "    if alcohol is not None:\n",
    "        # Filter the DataFrame based on alcohol interaction\n",
    "        filtered_df = filtered_df[filtered_df['alcohol'].isin(alcohol)]\n",
    "        \n",
    "    if age < 10:\n",
    "        # Filter dataset for users under 10 with at least 5 activity values\n",
    "        filtered_df = filtered_df.nsmallest(5, 'activity')\n",
    "        \n",
    "    elif 10 <= age <= 15:\n",
    "        # Filter dataset for users between 10 and 15 with at least 10 activity values\n",
    "        filtered_df = filtered_df.nsmallest(10, 'activity')\n",
    "    \n",
    "    # Print the resulting recommendations\n",
    "    print(filtered_df[:10])\n",
    "\n",
    "probability = 50  \n",
    "age = int(input(\"What is your age? \"))\n",
    "\n",
    "if(age>50):\n",
    "    print(\"PLEASE GO TO A DOCTOR....BOODAAA admi he re thuuu!!!\")\n",
    "else:\n",
    "    gender = input(\"What is your gender? \")\n",
    "    if gender.lower() == \"female\":\n",
    "        pregnant = input('Are you currently pregnant? (YES/NO): ')\n",
    "        allowed_pregnancy_category=None\n",
    "        if pregnant.upper() == 'YES':\n",
    "            a=input(\"Which trimester are you in? (First/Second/Third)-mention(1/2/3):\")\n",
    "            if(a=='1'):\n",
    "                allowed_pregnancy_category = ['A','B','C','D']\n",
    "\n",
    "            elif(a=='2' or a=='3'):\n",
    "                if(a=='2'):\n",
    "                    allowed_pregnancy_category = ['A','B','C']\n",
    "                else:\n",
    "                    print('PLS GO TO DOCTOR !!!')\n",
    "        \n",
    "    else:\n",
    "        allowed_pregnancy_category = ['A','B','C','D','N','X']\n",
    "\n",
    "\n",
    "\n",
    "    if int(age) > 16 :\n",
    "        alcohol_drinking = input(\"Do you drink alcohol? (YES/NO) \")\n",
    "        if(alcohol_drinking=='YES'):\n",
    "            alcohol=['N']\n",
    "        else:\n",
    "            alcohol=['X','N']\n",
    "    else:\n",
    "        alcohol=None\n",
    "        \n",
    "\n",
    "\n",
    "    if probability < 30:\n",
    "        # Symptoms as input\n",
    "        symptoms = input(\"Please enter your symptoms, separated by commas: \")\n",
    "        duration = int(input(\"How long have you been experiencing symptoms? (in days)\"))\n",
    "\n",
    "    else:\n",
    "        # Disease as input\n",
    "        disease = input(\"Please enter the name of the disease: \")\n",
    "        duration = int(input(\"How long have you been facing this disease? (in days)\"))\n",
    "        if(duration>15):\n",
    "            print('pls go to DOCTOR')\n",
    "            gotohospital=input('want to know nearest hospital:YES/NO')\n",
    "            print(\"go to this hospital\")\n",
    "        elif(duration>7):\n",
    "            print(f'------As u r facing this disease for {duration} days,we recommend to go to DOCTOR------')\n",
    "            recmedicine(disease,age,gender,allowed_pregnancy_category,alcohol,duration)\n",
    "        else:\n",
    "            recmedicine(disease,age,gender,allowed_pregnancy_category,alcohol,duration)\n",
    "      \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "abd10f2a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}