Wikipedia Parser Test.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import xml.etree.ElementTree as etree\n",
    "import codecs\n",
    "import csv\n",
    "import time\n",
    "import os\n",
    "import re\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "PATH_WIKI_XML = os.getcwd()\n",
    "FILENAME_WIKI = 'enwiki-latest-pages-articles.xml'\n",
    "FILENAME_ARTICLES = 'articles.csv'\n",
    "FILENAME_REDIRECT = 'articles_redirect.csv'\n",
    "FILENAME_TEMPLATE = 'articles_template.csv'\n",
    "FILENAME_DRUG = 'articles_drugs.csv'\n",
    "FILENAME_DISEASE = 'articles_diseases.csv'\n",
    "ENCODING = \"utf-8\"\n",
    "\n",
    "pathWikiXML =FILENAME_WIKI\n",
    "pathArticles = FILENAME_ARTICLES\n",
    "pathArticlesRedirect =  FILENAME_REDIRECT\n",
    "pathTemplateRedirect =  FILENAME_TEMPLATE\n",
    "pathDrugsArticles =FILENAME_DRUG\n",
    "pathDiseaseArticles = FILENAME_DISEASE"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
=======
   "execution_count": 4,
   "metadata": {},
>>>>>>> master
   "outputs": [],
   "source": [
    "# Nicely formatted time string\n",
    "def hms_string(sec_elapsed):\n",
    "    h = int(sec_elapsed / (60 * 60))\n",
    "    m = int((sec_elapsed % (60 * 60)) / 60)\n",
    "    s = sec_elapsed % 60\n",
    "    return \"{}:{:>02}:{:>05.2f}\".format(h, m, s)\n",
    "def strip_tag_name(t):\n",
    "    t = elem.tag\n",
    "    idx = k = t.rfind(\"}\")\n",
    "    if idx != -1:\n",
    "        t = t[idx + 1:]\n",
    "    return t\n",
    "def get_drugbox(s):\n",
    "    beg = (s.rfind('{{Drugbox'))\n",
    "    end  =(s.rfind('\\n}}'))\n",
    "    if( end == -1):\n",
    "        end = end =(s.rfind('}}\\n'))\n",
    "    if( end == -1):\n",
    "        end = end =(s.rfind('}}\\n<!--'))\n",
    "    if( end == -1):\n",
    "        end = end =(s.rfind('}}\\n=='))\n",
    "    if( end == -1):\n",
    "        end = end =(s.rfind('}}\\n\\d'))\n",
    "    s = s[beg: end+2]\n",
    "    return s\n",
    "def get_med_cond(s):\n",
    "    beg = (s.rfind('{{Infobox medical condition'))\n",
    "    end  =(s.rfind('\\n}}'))\n",
    "    if( end == -1):\n",
    "        end = end =(s.rfind('}}\\n'))\n",
    "    if( end == -1):\n",
    "        end = end =(s.rfind('}}\\n<!--'))\n",
    "    if( end == -1):\n",
    "        end = end =(s.rfind('}}\\n=='))\n",
    "    if( end == -1):\n",
    "        end = end =(s.rfind('}}\\n\\d'))\n",
    "    s = s[beg: end+2]\n",
    "    return s\n",
    "def get_medical(s):\n",
    "    beg = (s.rfind('{{Medical resources'))\n",
    "    end  =(s.rfind('\\n}}'))\n",
    "    s = s[beg: end+3]\n",
    "    return s\n",
    "def find_unii(s):\n",
    "    s = re.findall(r'UNII\\s*?=\\s?.*',s)\n",
    "    if(len(s)>0):   \n",
    "        s = s[0]\n",
    "        equal = s.rfind('=')\n",
    "        #if there is a space after the equal remove it\n",
    "        try:\n",
    "            if(s[equal+1]==' '):\n",
    "                s = s[equal+2:]\n",
    "            else: \n",
    "                s = s[equal+1:]\n",
    "        except:\n",
    "            s = ''\n",
    "    else:\n",
    "        s = ''\n",
    "    return s\n",
    "def find_icd10(s):\n",
    "    s = s.replace('|','')\n",
    "    s = s.replace('{{ICD10',\"\")\n",
    "    icd10 = re.findall('\\w{1}\\d{2,6}',s)\n",
    "    return icd10\n",
    "\n",
    "def find_medication(s):\n",
    "    s = re.findall(r'medication\\s*?=.*<',s)\n",
    "    if(len(s)== 0 ):\n",
    "        s = []\n",
    "    else:\n",
    "        s = s[0]\n",
    "        s = s[:-1]\n",
    "        s = s[s.find('=')+2:]\n",
    "        s = s.replace('[[','')\n",
    "        s = s.replace(']]','')\n",
    "        s = s.split(',')\n",
    "        s\n",
    "    return s\n",
    "def pad_array(arr,length):\n",
    "    for i in range(0,length-len(arr)):\n",
    "        arr.append(np.NaN)\n",
    "    return arr\n",
    "def find_max_medications(df):\n",
    "    return max([len(x) for x in df[df.medications.map(len) > 0].medications.values])\n",
    "def get_row_with_medications(df):\n",
    "    df =  df[df.medications.map(len) > 0]\n",
    "    df.reset_index(drop=True,inplace=True)\n",
    "    return df\n",
    "def get_row_with_unii(df):\n",
    "    df =  df[df.unii.map(len) > 0]\n",
    "    df.reset_index(drop=True,inplace=True)\n",
    "    return df\n",
    "def set_meds_columns(df,max_col):\n",
    "    current_meds = df.medications.values\n",
    "    padded_meds = [pad_array(el,max_col) for el in current_meds]\n",
    "    cols = [f\"medication_{i}\" for i in range(max_col)]\n",
    "    col_df = pd.DataFrame(padded_meds, columns=cols)\n",
    "    final = pd.concat([df,col_df], axis=1)\n",
    "    return final\n",
    "def clean_row(row):\n",
    "    for i in range (len(row)):\n",
    "        el = row[i]\n",
    "        end = el.rfind('<')\n",
    "        if end !=-1:\n",
    "            new_el = el[:end]\n",
    "            row[i]=new_el\n",
    "        if i>0:\n",
    "            row[i]= row[i][:]\n",
    "        end = el.rfind('(')\n",
    "        if end !=-1:\n",
    "            new_el = el[:end]\n",
    "            row[i]=new_el\n",
    "        if i>0:\n",
    "            row[i]= row[i][:]   \n",
    "    return row\n",
    "def clean_links(dirty_links):\n",
    "    clean_links = []\n",
    "    for el in dirty_links:\n",
    "        if(el.rfind(\"|\")>-1):\n",
    "            el = el[:el.rfind(\"|\")]\n",
    "        clean_links.append(el[2:-2])\n",
    "    return clean_links"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pathWikiXML =FILENAME_WIKI\n",
    "pathArticles = FILENAME_ARTICLES\n",
    "pathArticlesRedirect =  FILENAME_REDIRECT\n",
    "pathTemplateRedirect =  FILENAME_TEMPLATE\n",
    "pathDrugsArticles =FILENAME_DRUG\n",
    "pathDiseaseArticles = FILENAME_DISEASE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "created arrays at id: 400000\n",
      "created arrays at id: 600000\n",
      "created arrays at id: 1300000\n",
      "created arrays at id: 1400000\n",
      "created arrays at id: 1500000\n",
      "created arrays at id: 1700000\n",
      "created arrays at id: 1800000\n",
      "created arrays at id: 1900000\n",
      "created arrays at id: 2000000\n",
      "created arrays at id: 2100000\n",
      "created arrays at id: 2200000\n",
      "created arrays at id: 2300000\n",
<<<<<<< HEAD
      "created arrays at id: 2600000\n",
      "created arrays at id: 2800000\n",
      "created arrays at id: 3700000\n",
      "created arrays at id: 4200000\n",
      "created arrays at id: 4300000\n",
      "created arrays at id: 4600000\n",
      "created arrays at id: 5000000\n",
      "created arrays at id: 5400000\n",
      "created arrays at id: 5500000\n",
      "created arrays at id: 5900000\n",
      "created arrays at id: 6000000\n",
      "created arrays at id: 6700000\n",
      "created arrays at id: 7500000\n",
      "created arrays at id: 8000000\n",
      "created arrays at id: 9100000\n",
      "created arrays at id: 9200000\n",
      "created arrays at id: 9400000\n",
      "created arrays at id: 10200000\n",
      "created arrays at id: 10800000\n",
      "created arrays at id: 11300000\n",
      "created arrays at id: 11600000\n",
      "created arrays at id: 11700000\n",
      "created arrays at id: 11800000\n",
      "created arrays at id: 11900000\n",
      "created arrays at id: 12500000\n",
      "created arrays at id: 13100000\n",
      "created arrays at id: 13500000\n",
      "created arrays at id: 14500000\n",
      "created arrays at id: 14700000\n",
      "created arrays at id: 15000000\n",
      "created arrays at id: 15600000\n",
      "created arrays at id: 15800000\n",
      "created arrays at id: 15900000\n",
      "created arrays at id: 16100000\n",
      "created arrays at id: 16300000\n",
      "created arrays at id: 16400000\n",
      "created arrays at id: 16500000\n",
      "created arrays at id: 16600000\n",
      "created arrays at id: 16900000\n",
      "created arrays at id: 18000000\n",
      "created arrays at id: 18300000\n",
      "created arrays at id: 18500000\n",
      "created arrays at id: 18900000\n",
      "created arrays at id: 19700000\n",
      "created arrays at id: 19800000\n",
      "created arrays at id: 19900000\n",
      "created arrays at id: 20300000\n",
      "created arrays at id: 20400000\n",
      "created arrays at id: 20600000\n",
      "created arrays at id: 21100000\n",
      "created arrays at id: 22000000\n",
      "created arrays at id: 22800000\n",
      "created arrays at id: 22900000\n",
      "created arrays at id: 23000000\n",
      "created arrays at id: 23700000\n",
      "created arrays at id: 23800000\n",
      "created arrays at id: 24000000\n",
      "created arrays at id: 24100000\n",
      "created arrays at id: 25000000\n",
      "created arrays at id: 25300000\n",
      "created arrays at id: 25800000\n",
      "created arrays at id: 25900000\n",
      "created arrays at id: 26400000\n",
      "created arrays at id: 26800000\n",
      "created arrays at id: 27000000\n",
      "created arrays at id: 27100000\n",
      "created arrays at id: 27200000\n",
      "created arrays at id: 28300000\n",
      "created arrays at id: 28400000\n",
      "created arrays at id: 28600000\n",
      "created arrays at id: 28700000\n",
      "created arrays at id: 29400000\n",
      "created arrays at id: 30300000\n",
      "created arrays at id: 30500000\n",
      "created arrays at id: 30800000\n",
      "created arrays at id: 31000000\n",
      "created arrays at id: 31400000\n",
      "created arrays at id: 31700000\n",
      "created arrays at id: 31800000\n",
      "created arrays at id: 32200000\n",
      "created arrays at id: 32700000\n",
      "created arrays at id: 32800000\n",
      "created arrays at id: 33400000\n",
      "created arrays at id: 34000000\n",
      "created arrays at id: 34200000\n",
      "created arrays at id: 34400000\n",
      "created arrays at id: 34500000\n",
      "created arrays at id: 34600000\n",
      "created arrays at id: 34700000\n",
      "created arrays at id: 34900000\n",
      "created arrays at id: 35200000\n",
      "created arrays at id: 35300000\n",
      "created arrays at id: 35700000\n",
      "created arrays at id: 35900000\n",
      "created arrays at id: 36100000\n",
      "created arrays at id: 36400000\n",
      "created arrays at id: 36600000\n",
      "created arrays at id: 36800000\n",
      "created arrays at id: 36900000\n",
      "created arrays at id: 37000000\n",
      "created arrays at id: 37800000\n",
      "created arrays at id: 38300000\n",
      "created arrays at id: 38500000\n",
      "created arrays at id: 38700000\n",
      "created arrays at id: 38800000\n",
      "created arrays at id: 38900000\n",
      "created arrays at id: 39100000\n",
      "created arrays at id: 39500000\n",
      "created arrays at id: 39800000\n",
      "created arrays at id: 39900000\n",
      "created arrays at id: 40000000\n",
      "created arrays at id: 40500000\n",
      "created arrays at id: 41200000\n",
      "created arrays at id: 41300000\n"
=======
      "created arrays at id: 2600000\n"
>>>>>>> master
     ]
    }
   ],
   "source": [
    "totalCount = 0\n",
    "title = None\n",
    "icd9=[]\n",
    "icd10=[]\n",
    "#-----------arrays for drugs_df----------------DO NOT CHANGE NAMES\n",
    "drugs_name = []\n",
    "drugs_id = []\n",
    "drugs_unii = []\n",
    "drugs_links = []\n",
    "#----arrays for diseases_df---------------------DO NOT CHANGE NAMES\n",
    "diseases_name = []\n",
    "diseases_id = []\n",
    "diseases_icd9 = []\n",
    "diseases_icd10 = []\n",
    "diseases_meds = []\n",
    "diseases_links = []\n",
    "#-------------------------------------------\n",
    "start_time = time.time()\n",
    "for event, elem in etree.iterparse(pathWikiXML, events=('start', 'end')):\n",
    "    tname = strip_tag_name(elem.tag)\n",
    "\n",
    "    if event == 'start':\n",
    "        if tname == 'page':\n",
    "            title = ''\n",
    "            id = -1\n",
    "            redirect = ''\n",
    "            inrevision = False\n",
    "            ns = 0\n",
    "        elif tname == 'revision':\n",
    "            # Do not pick up on revision id's\n",
    "            inrevision = True\n",
    "    else:\n",
    "        if tname == 'title':\n",
    "            title = elem.text\n",
    "        elif tname == 'id' and not inrevision:\n",
    "            id = int(elem.text)\n",
    "        elif tname == 'redirect':\n",
    "            redirect = elem.attrib['title']\n",
    "        elif tname == 'ns':\n",
    "            ns = int(elem.text)\n",
    "        elif tname == 'page':\n",
    "            totalCount += 1\n",
    "        elif(tname =='text'):\n",
    "            cont = elem.text\n",
    "            #check if cont exists\n",
    "            if(type(cont)==type('alex')):\n",
    "                #check if the drugbox template exists \n",
    "                if (cont.find('Drugbox')>-1 ):\n",
    "                    #get the drugbox template\n",
    "                    result = get_drugbox(cont)\n",
    "                    #get the CAS number\n",
    "                    unii = find_unii(result)\n",
    "                    links = re.findall(\"\\[\\[.*?\\]\\]\",cont)\n",
    "                    clean = clean_links(links)\n",
    "                    #drugsWriter.writerow([id, title, cas])\n",
    "                    drugs_name.append(title)\n",
    "                    drugs_id.append(id)\n",
    "                    drugs_unii.append(unii)\n",
    "                    drugs_links.append(clean)\n",
    "                    #print('done Drug')\n",
    "                if (cont.find('Infobox medical condition')>-1 ):\n",
    "                    #get the drugbox template\n",
    "                    result = get_med_cond(cont)\n",
    "                    #get the CAS number\n",
    "                    meds = find_medication(result)\n",
    "                    #drugsWriter.writerow([id, title, meds])\n",
    "                    #print('done condition')\n",
    "                    if (cont.find('Medical resources')>-1):\n",
    "                        #get the drugbox template\n",
    "                        result = get_medical(cont)\n",
    "                        #get ICD 9 and ICD 10\n",
    "                        tempICD9 = re.findall('{{ICD9.*',result)\n",
    "                        tempICD10 = re.findall('{{ICD10.*',result)\n",
    "                        if len(tempICD9)>0:\n",
    "                            icd9 = re.findall('\\w?\\d{3}\\.?\\d?',tempICD9[0])\n",
    "                        if len(tempICD10)>0:\n",
    "                            icd10 = find_icd10(tempICD10[0])\n",
    "                    links = re.findall(\"\\[\\[.*?\\]\\]\",cont)\n",
    "                    clean = clean_links(links)\n",
    "                    diseases_name.append(title)\n",
    "                    diseases_id.append(id )\n",
    "                    diseases_meds.append(meds)\n",
    "                    diseases_icd9.append(icd9)\n",
    "                    diseases_icd10.append(icd10)\n",
    "                    diseases_links.append(clean)\n",
    "            if (id%100000 ==0):\n",
<<<<<<< HEAD
    "                drugs_df = pd.DataFrame({ \"id\": drugs_id,\"name\": drugs_name,\"UNII\":drugs_unii})\n",
    "                diseases_df = pd.DataFrame({\"id\":diseases_id , \"name\": diseases_name , \"icd9\": diseases_icd9 , \"icd10\": diseases_icd10, \"medications\": diseases_meds })\n",
    "                diseases_with_meds = get_row_with_medications(diseases_df)\n",
    "                diseases_with_meds.to_csv('final_diseases.csv')\n",
    "                drugs_df.to_csv('final_drugs.csv')\n",
=======
    "                drugs_df = pd.DataFrame({ \"id\": drugs_id,\"name\": drugs_name, \"unii\": drugs_unii, \"links\":drugs_links})\n",
    "                diseases_df = pd.DataFrame({\"id\":diseases_id , \"name\": diseases_name , \"icd9\": diseases_icd9 , \"icd10\": diseases_icd10, \"medications\": diseases_meds, \"links\" : diseases_links })\n",
    "                diseases_with_meds = get_row_with_medications(diseases_df)\n",
    "                drugs_df.to_csv('new_drugs_with_unii.csv')\n",
    "                diseases_with_meds.to_csv('new_diseases_with_med.csv')\n",
>>>>>>> master
    "                print(f'created arrays at id: {id}')\n",
    "                    #diseaseWriter.writerow([id, title, icd9, icd10])\n",
    "        elem.clear()\n",
    "elapsed_time = time.time() - start_time\n",
    "print(\"Elapsed time: {}\".format(hms_string(elapsed_time)))"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "print(\"done\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
=======
   "execution_count": 6,
>>>>>>> master
   "metadata": {
    "collapsed": true,
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "drugs_df = pd.DataFrame({ \"id\": drugs_id,\"name\": drugs_name, \"unii\": drugs_unii})\n",
    "drugs_with_unii = get_row_with_unii(drugs_df)"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
=======
   "execution_count": 7,
   "metadata": {},
>>>>>>> master
   "outputs": [],
   "source": [
    "diseases_df = pd.DataFrame({\"id\":diseases_id , \"name\": diseases_name , \"icd9\": diseases_icd9 , \"icd10\": diseases_icd10, \"medications\": diseases_meds })"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "diseases_with_meds = get_row_with_medications(diseases_df)\n",
    "diseases_with_meds.medications.apply(clean_row)\n",
    "max_meds = find_max_medications(diseases_with_meds)\n",
    "test = set_meds_columns(diseases_with_meds, max_meds)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>icd9</th>\n",
       "      <th>icd10</th>\n",
       "      <th>medications</th>\n",
       "      <th>medication_0</th>\n",
       "      <th>medication_1</th>\n",
       "      <th>medication_2</th>\n",
       "      <th>medication_3</th>\n",
       "      <th>medication_4</th>\n",
       "      <th>medication_5</th>\n",
       "      <th>medication_6</th>\n",
       "      <th>medication_7</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1776</td>\n",
       "      <td>Arthritis</td>\n",
       "      <td>[710, 719]</td>\n",
       "      <td>[M00, m00, M25, m20]</td>\n",
       "      <td>[Ibuprofen,  paracetamol , nan, nan, nan, nan,...</td>\n",
       "      <td>Ibuprofen</td>\n",
       "      <td>paracetamol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4531</td>\n",
       "      <td>Bipolar disorder</td>\n",
       "      <td>[324.0]</td>\n",
       "      <td>[Q273, q20, Q280, q20, Q282, q20]</td>\n",
       "      <td>[Lithium ,  antipsychotics,  anticonvulsants, ...</td>\n",
       "      <td>Lithium</td>\n",
       "      <td>antipsychotics</td>\n",
       "      <td>anticonvulsants</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4581</td>\n",
       "      <td>Bacterial vaginosis</td>\n",
       "      <td>[616.1]</td>\n",
       "      <td>[N76]</td>\n",
       "      <td>[Clindamycin or metronidazole, nan, nan, nan, ...</td>\n",
       "      <td>Clindamycin or metronidazole</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4746</td>\n",
       "      <td>Plague (disease)</td>\n",
       "      <td>[020]</td>\n",
       "      <td>[A20]</td>\n",
       "      <td>[Gentamicin and a fluoroquinolone, nan, nan, n...</td>\n",
       "      <td>Gentamicin and a fluoroquinolone</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5876</td>\n",
       "      <td>Coronary artery disease</td>\n",
       "      <td>[780.0]</td>\n",
       "      <td>[R402, r40]</td>\n",
       "      <td>[Aspirin,  beta blockers,  Medical use of nitr...</td>\n",
       "      <td>Aspirin</td>\n",
       "      <td>beta blockers</td>\n",
       "      <td>Medical use of nitroglycerin|nitroglycerin</td>\n",
       "      <td>statins</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7012</td>\n",
       "      <td>Chagas disease</td>\n",
       "      <td>[243]</td>\n",
       "      <td>[E00, e00]</td>\n",
       "      <td>[Benznidazole,  nifurtimox, nan, nan, nan, nan...</td>\n",
       "      <td>Benznidazole</td>\n",
       "      <td>nifurtimox</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7038</td>\n",
       "      <td>Candidiasis</td>\n",
       "      <td>[112]</td>\n",
       "      <td>[B37, b35]</td>\n",
       "      <td>[Clotrimazole,  nystatin,  fluconazole, nan, n...</td>\n",
       "      <td>Clotrimazole</td>\n",
       "      <td>nystatin</td>\n",
       "      <td>fluconazole</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>10528</td>\n",
       "      <td>Essential tremor</td>\n",
       "      <td>[333.1]</td>\n",
       "      <td>[G250, g20]</td>\n",
       "      <td>[Beta blockers; propranolol,  nadolol,  timolo...</td>\n",
       "      <td>Beta blockers; propranolol</td>\n",
       "      <td>nadolol</td>\n",
       "      <td>timolol</td>\n",
       "      <td>primidone</td>\n",
       "      <td>anti-epileptics; topiramate</td>\n",
       "      <td>gabapentin</td>\n",
       "      <td>levetiracetam; benzodiazepines</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>13492</td>\n",
       "      <td>Hyperthyroidism</td>\n",
       "      <td>[240.9]</td>\n",
       "      <td>[E01, e00, E05, e00]</td>\n",
       "      <td>[Beta blockers,  methimazole, nan, nan, nan, n...</td>\n",
       "      <td>Beta blockers</td>\n",
       "      <td>methimazole</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>15354</td>\n",
       "      <td>Interstitial cystitis</td>\n",
       "      <td>[595.1]</td>\n",
       "      <td>[N301, n30]</td>\n",
       "      <td>[Ibuprofen,  pentosan polysulfate,  amitriptyl...</td>\n",
       "      <td>Ibuprofen</td>\n",
       "      <td>pentosan polysulfate</td>\n",
       "      <td>amitriptyline</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>18998</td>\n",
       "      <td>Myasthenia gravis</td>\n",
       "      <td>[359.0, 359.1]</td>\n",
       "      <td>[G710, g70]</td>\n",
       "      <td>[Acetylcholinesterase inhibitors ,  pyridostig...</td>\n",
       "      <td>Acetylcholinesterase inhibitors</td>\n",
       "      <td>pyridostigmine)</td>\n",
       "      <td>immunosuppressants</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>20423</td>\n",
       "      <td>Malaria</td>\n",
       "      <td>[359.0, 359.1]</td>\n",
       "      <td>[G710, g70]</td>\n",
       "      <td>[Antimalarial medication, nan, nan, nan, nan, ...</td>\n",
       "      <td>Antimalarial medication</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>21035</td>\n",
       "      <td>Migraine</td>\n",
       "      <td>[359.0, 359.1]</td>\n",
       "      <td>[G710, g70]</td>\n",
       "      <td>[Ibuprofen,  paracetamol ,  triptans,  ergotam...</td>\n",
       "      <td>Ibuprofen</td>\n",
       "      <td>paracetamol</td>\n",
       "      <td>triptans</td>\n",
       "      <td>ergotamines</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>22461</td>\n",
       "      <td>Osteoporosis</td>\n",
       "      <td>[733.0]</td>\n",
       "      <td>[M80, m80, M82, m80]</td>\n",
       "      <td>[Bisphosphonates, nan, nan, nan, nan, nan, nan...</td>\n",
       "      <td>Bisphosphonates</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>23251</td>\n",
       "      <td>Phenylketonuria</td>\n",
       "      <td>[270.1]</td>\n",
       "      <td>[E700, e70]</td>\n",
       "      <td>[Sapropterin dihydrochloride, nan, nan, nan, n...</td>\n",
       "      <td>Sapropterin dihydrochloride</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>23337</td>\n",
       "      <td>Phobia</td>\n",
       "      <td>[300.2]</td>\n",
       "      <td>[F40]</td>\n",
       "      <td>[Antidepressants,  benzodiazepines,  beta-bloc...</td>\n",
       "      <td>Antidepressants</td>\n",
       "      <td>benzodiazepines</td>\n",
       "      <td>beta-blockers</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>25161</td>\n",
       "      <td>Idiopathic intracranial hypertension</td>\n",
       "      <td>[348.2]</td>\n",
       "      <td>[G932, g90]</td>\n",
       "      <td>[Acetazolamide, nan, nan, nan, nan, nan, nan, ...</td>\n",
       "      <td>Acetazolamide</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>25875</td>\n",
       "      <td>Rheumatoid arthritis</td>\n",
       "      <td>[E927.1, E927.3, E927.9, 727.2]</td>\n",
       "      <td>[M70, X50, Z57]</td>\n",
       "      <td>[Analgesics|Pain medications,  glucocorticoid|...</td>\n",
       "      <td>Analgesics|Pain medications</td>\n",
       "      <td>glucocorticoid|steroids</td>\n",
       "      <td>Nonsteroidal anti-inflammatory drugs</td>\n",
       "      <td>disease-modifying antirheumatic drugs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>27790</td>\n",
       "      <td>Schizophrenia</td>\n",
       "      <td>[345.9, 780.3]</td>\n",
       "      <td>[G40, g40, P90, p90, R56, r56]</td>\n",
       "      <td>[Antipsychotics, nan, nan, nan, nan, nan, nan,...</td>\n",
       "      <td>Antipsychotics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>28649</td>\n",
       "      <td>Stevens–Johnson syndrome</td>\n",
       "      <td>[307.0]</td>\n",
       "      <td>[F985, f90]</td>\n",
       "      <td>[Pain medication,  antihistamines,  antibiotic...</td>\n",
       "      <td>Pain medication</td>\n",
       "      <td>antihistamines</td>\n",
       "      <td>antibiotics</td>\n",
       "      <td>corticosteroids</td>\n",
       "      <td>intravenous immunoglobulins</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>28848</td>\n",
       "      <td>Scabies</td>\n",
       "      <td>[307.0]</td>\n",
       "      <td>[F985, f90]</td>\n",
       "      <td>[Permethrin,  crotamiton,  lindane,  ivermecti...</td>\n",
       "      <td>Permethrin</td>\n",
       "      <td>crotamiton</td>\n",
       "      <td>lindane</td>\n",
       "      <td>ivermectin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>29500</td>\n",
       "      <td>Serotonin syndrome</td>\n",
       "      <td>[307.0]</td>\n",
       "      <td>[F985, f90]</td>\n",
       "      <td>[Benzodiazepines,  cyproheptadine, nan, nan, n...</td>\n",
       "      <td>Benzodiazepines</td>\n",
       "      <td>cyproheptadine</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>37284</td>\n",
       "      <td>Brain tumor</td>\n",
       "      <td>[191, 225.0]</td>\n",
       "      <td>[C71, D33]</td>\n",
       "      <td>[Anticonvulsants,  dexamethasone,  furosemide,...</td>\n",
       "      <td>Anticonvulsants</td>\n",
       "      <td>dexamethasone</td>\n",
       "      <td>furosemide</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>38390</td>\n",
       "      <td>Dementia</td>\n",
       "      <td>[066.4]</td>\n",
       "      <td>[A923]</td>\n",
       "      <td>[Acetylcholinesterase inhibitor|Cholinesterase...</td>\n",
       "      <td>Acetylcholinesterase inhibitor|Cholinesterase ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>44700</td>\n",
       "      <td>Leprosy</td>\n",
       "      <td>[125.7]</td>\n",
       "      <td>[R56]</td>\n",
       "      <td>[Rifampicin,  dapsone,  clofazimine, nan, nan,...</td>\n",
       "      <td>Rifampicin</td>\n",
       "      <td>dapsone</td>\n",
       "      <td>clofazimine</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>44738</td>\n",
       "      <td>Diabetes insipidus</td>\n",
       "      <td>[253.5, 588.1]</td>\n",
       "      <td>[E232, e20, N251, n25]</td>\n",
       "      <td>[Desmopressin,  thiazides,  aspirin, nan, nan,...</td>\n",
       "      <td>Desmopressin</td>\n",
       "      <td>thiazides</td>\n",
       "      <td>aspirin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>45475</td>\n",
       "      <td>Marfan syndrome</td>\n",
       "      <td>[253.5, 588.1]</td>\n",
       "      <td>[E232, e20, N251, n25]</td>\n",
       "      <td>[Beta blockers,  calcium channel blockers,  AC...</td>\n",
       "      <td>Beta blockers</td>\n",
       "      <td>calcium channel blockers</td>\n",
       "      <td>ACE inhibitors</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>46253</td>\n",
       "      <td>Fever</td>\n",
       "      <td>[780.6]</td>\n",
       "      <td>[R50, r50]</td>\n",
       "      <td>[Ibuprofen,  paracetamol , nan, nan, nan, nan,...</td>\n",
       "      <td>Ibuprofen</td>\n",
       "      <td>paracetamol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>47878</td>\n",
       "      <td>Huntington's disease</td>\n",
       "      <td>[307.4, 327, 780.5]</td>\n",
       "      <td>[F40, f40, F40, f40]</td>\n",
       "      <td>[Tetrabenazine, nan, nan, nan, nan, nan, nan, ...</td>\n",
       "      <td>Tetrabenazine</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>49364</td>\n",
       "      <td>Turner syndrome</td>\n",
       "      <td>[307.4, 327, 780.5]</td>\n",
       "      <td>[F40, f40, F40, f40]</td>\n",
       "      <td>[Human growth hormone,  estrogen replacement t...</td>\n",
       "      <td>Human growth hormone</td>\n",
       "      <td>estrogen replacement therapy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>413928</td>\n",
       "      <td>Ascariasis</td>\n",
       "      <td>[704.8]</td>\n",
       "      <td>[L739, l60, L73]</td>\n",
       "      <td>[Albendazole,  mebendazole,  levamisole,  pyra...</td>\n",
       "      <td>Albendazole</td>\n",
       "      <td>mebendazole</td>\n",
       "      <td>levamisole</td>\n",
       "      <td>pyrantel pamoate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>414280</td>\n",
       "      <td>Bad breath</td>\n",
       "      <td>[784.9]</td>\n",
       "      <td>[R196, r10]</td>\n",
       "      <td>[Mouthwash containing chlorhexidine or cetylpy...</td>\n",
       "      <td>Mouthwash containing chlorhexidine or cetylpyr...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>414350</td>\n",
       "      <td>Tooth decay</td>\n",
       "      <td>[784.9]</td>\n",
       "      <td>[R196, r10]</td>\n",
       "      <td>[Paracetamol ,  ibuprofen, nan, nan, nan, nan,...</td>\n",
       "      <td>Paracetamol</td>\n",
       "      <td>ibuprofen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>414967</td>\n",
       "      <td>Pre-eclampsia</td>\n",
       "      <td>[784.9]</td>\n",
       "      <td>[R196, r10]</td>\n",
       "      <td>[Labetalol,  methyldopa,  magnesium sulfate, n...</td>\n",
       "      <td>Labetalol</td>\n",
       "      <td>methyldopa</td>\n",
       "      <td>magnesium sulfate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>429592</td>\n",
       "      <td>Harlequin-type ichthyosis</td>\n",
       "      <td>[644, 765]</td>\n",
       "      <td>[O601, o60, P073, p05]</td>\n",
       "      <td>[Antibiotics,  etretinate,  retinoids, nan, na...</td>\n",
       "      <td>Antibiotics</td>\n",
       "      <td>etretinate</td>\n",
       "      <td>retinoids</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>443800</td>\n",
       "      <td>Shingles</td>\n",
       "      <td>[386.9, 961.4]</td>\n",
       "      <td>[E830, e83]</td>\n",
       "      <td>[Aciclovir ,  pain medication, nan, nan, nan, ...</td>\n",
       "      <td>Aciclovir</td>\n",
       "      <td>pain medication</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>452461</td>\n",
       "      <td>Myocarditis</td>\n",
       "      <td>[391.2, 422, 429.0]</td>\n",
       "      <td>[I090, i05, I514, i30]</td>\n",
       "      <td>[ACE inhibitors,  beta blockers,  diuretics,  ...</td>\n",
       "      <td>ACE inhibitors</td>\n",
       "      <td>beta blockers</td>\n",
       "      <td>diuretics</td>\n",
       "      <td>corticosteroids</td>\n",
       "      <td>intravenous immunoglobulin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>465863</td>\n",
       "      <td>Seborrhoeic dermatitis</td>\n",
       "      <td>[690.1]</td>\n",
       "      <td>[L21, l20]</td>\n",
       "      <td>[antifungal medications|Antifungal cream,  ant...</td>\n",
       "      <td>antifungal medications|Antifungal cream</td>\n",
       "      <td>anti-inflammatory agents</td>\n",
       "      <td>coal tar</td>\n",
       "      <td>phototherapy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>489173</td>\n",
       "      <td>Peripheral artery disease</td>\n",
       "      <td>[443.9]</td>\n",
       "      <td>[I739, i70]</td>\n",
       "      <td>[Statins,  ACE inhibitors,  cilostazol, nan, n...</td>\n",
       "      <td>Statins</td>\n",
       "      <td>ACE inhibitors</td>\n",
       "      <td>cilostazol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>491494</td>\n",
       "      <td>Ankylosing spondylitis</td>\n",
       "      <td>[443.9]</td>\n",
       "      <td>[I739, i70]</td>\n",
       "      <td>[NSAIDs,  corticosteroids|steroids,  Disease-m...</td>\n",
       "      <td>NSAIDs</td>\n",
       "      <td>corticosteroids|steroids</td>\n",
       "      <td>Disease-modifying antirheumatic drug|DMARDs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>493567</td>\n",
       "      <td>Epididymitis</td>\n",
       "      <td>[604]</td>\n",
       "      <td>[N450, n40]</td>\n",
       "      <td>[NSAIDs,  ceftriaxone and doxycycline,  ofloxa...</td>\n",
       "      <td>NSAIDs</td>\n",
       "      <td>ceftriaxone and doxycycline</td>\n",
       "      <td>ofloxacin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>546881</td>\n",
       "      <td>Septic arthritis</td>\n",
       "      <td>[711.0]</td>\n",
       "      <td>[M00, m00, M03, m00]</td>\n",
       "      <td>[Vancomycin,  ceftriaxone,  ceftazidime, nan, ...</td>\n",
       "      <td>Vancomycin</td>\n",
       "      <td>ceftriaxone</td>\n",
       "      <td>ceftazidime</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>570153</td>\n",
       "      <td>Deep vein thrombosis</td>\n",
       "      <td>[453.4]</td>\n",
       "      <td>[I802, i80]</td>\n",
       "      <td>[Low-molecular-weight heparin,  warfarin,  dir...</td>\n",
       "      <td>Low-molecular-weight heparin</td>\n",
       "      <td>warfarin</td>\n",
       "      <td>direct oral anticoagulant</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>578144</td>\n",
       "      <td>Hidradenitis suppurativa</td>\n",
       "      <td>[705.8]</td>\n",
       "      <td>[L732, l60]</td>\n",
       "      <td>[Antibiotics,  immunosuppressive medication, n...</td>\n",
       "      <td>Antibiotics</td>\n",
       "      <td>immunosuppressive medication</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>593388</td>\n",
       "      <td>Iron-deficiency anemia</td>\n",
       "      <td>[311]</td>\n",
       "      <td>[F388]</td>\n",
       "      <td>[Iron supplements,  vitamin C,  blood transfus...</td>\n",
       "      <td>Iron supplements</td>\n",
       "      <td>vitamin C</td>\n",
       "      <td>blood transfusions</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>606009</td>\n",
       "      <td>Hypertrophic cardiomyopathy</td>\n",
       "      <td>[425.1]</td>\n",
       "      <td>[I421, i30, I422, i30]</td>\n",
       "      <td>[Beta blockers,  diuretics,  disopyramide, nan...</td>\n",
       "      <td>Beta blockers</td>\n",
       "      <td>diuretics</td>\n",
       "      <td>disopyramide</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>606011</td>\n",
       "      <td>Dilated cardiomyopathy</td>\n",
       "      <td>[425.4]</td>\n",
       "      <td>[I420, i30]</td>\n",
       "      <td>[ACE inhibitor,  beta blocker,  diuretic,  ant...</td>\n",
       "      <td>ACE inhibitor</td>\n",
       "      <td>beta blocker</td>\n",
       "      <td>diuretic</td>\n",
       "      <td>anticoagulants|blood thinners</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>638645</td>\n",
       "      <td>Short QT syndrome</td>\n",
       "      <td>[426.0]</td>\n",
       "      <td>[R943, r94]</td>\n",
       "      <td>[Quinidine,  Flecainide , nan, nan, nan, nan, ...</td>\n",
       "      <td>Quinidine</td>\n",
       "      <td>Flecainide</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>674529</td>\n",
       "      <td>Pulmonary hypertension</td>\n",
       "      <td>[416.0, 416.8]</td>\n",
       "      <td>[I270, i26, I272, i26]</td>\n",
       "      <td>[Epoprostenol,  treprostinil,  iloprost,  bose...</td>\n",
       "      <td>Epoprostenol</td>\n",
       "      <td>treprostinil</td>\n",
       "      <td>iloprost</td>\n",
       "      <td>bosentan</td>\n",
       "      <td>ambrisentan</td>\n",
       "      <td>macitentan</td>\n",
       "      <td>sildenafil</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>679350</td>\n",
       "      <td>Food allergy</td>\n",
       "      <td>[]</td>\n",
       "      <td>[T780, t66]</td>\n",
       "      <td>[Adrenaline , nan, nan, nan, nan, nan, nan, nan]</td>\n",
       "      <td>Adrenaline</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>718521</td>\n",
       "      <td>Subarachnoid hemorrhage</td>\n",
       "      <td>[430, 852.0, 852.1]</td>\n",
       "      <td>[I60, i60, P103, p10, S066, s00]</td>\n",
       "      <td>[Labetalol,  nimodipine, nan, nan, nan, nan, n...</td>\n",
       "      <td>Labetalol</td>\n",
       "      <td>nimodipine</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>732173</td>\n",
       "      <td>Cellulitis</td>\n",
       "      <td>[728.6]</td>\n",
       "      <td>[M720, m70]</td>\n",
       "      <td>[Antibiotics such as cephalexin, nan, nan, nan...</td>\n",
       "      <td>Antibiotics such as cephalexin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>741847</td>\n",
       "      <td>Hyperkalemia</td>\n",
       "      <td>[276.7]</td>\n",
       "      <td>[E875, e70]</td>\n",
       "      <td>[Calcium gluconate,  dextrose with insulin,  s...</td>\n",
       "      <td>Calcium gluconate</td>\n",
       "      <td>dextrose with insulin</td>\n",
       "      <td>salbutamol</td>\n",
       "      <td>sodium bicarbonate&lt;ref name=Leh2011/&gt;</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>760951</td>\n",
       "      <td>Cysticercosis</td>\n",
       "      <td>[748.0]</td>\n",
       "      <td>[S525, s50]</td>\n",
       "      <td>[Praziquantel,  albendazole,  corticosteroids,...</td>\n",
       "      <td>Praziquantel</td>\n",
       "      <td>albendazole</td>\n",
       "      <td>corticosteroids</td>\n",
       "      <td>anti seizure medications</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>768604</td>\n",
       "      <td>Reflex syncope</td>\n",
       "      <td>[]</td>\n",
       "      <td>[R55, r50]</td>\n",
       "      <td>[Midodrine,  fludrocortisone, nan, nan, nan, n...</td>\n",
       "      <td>Midodrine</td>\n",
       "      <td>fludrocortisone</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>772724</td>\n",
       "      <td>Opioid use disorder</td>\n",
       "      <td>[304.0]</td>\n",
       "      <td>[F11, f10]</td>\n",
       "      <td>[Buprenorphine,  methadone,  naltrexone&lt;ref na...</td>\n",
       "      <td>Buprenorphine</td>\n",
       "      <td>methadone</td>\n",
       "      <td>naltrexone&lt;ref name=BMJ2017Re/&gt;</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>792524</td>\n",
       "      <td>Rosacea</td>\n",
       "      <td>[695.3]</td>\n",
       "      <td>[L71, l60]</td>\n",
       "      <td>[Antibiotics either by mouth or applied to the...</td>\n",
       "      <td>Antibiotics either by mouth or applied to the ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>794008</td>\n",
       "      <td>Dry eye syndrome</td>\n",
       "      <td>[370.3]</td>\n",
       "      <td>[H193, h15]</td>\n",
       "      <td>[Ciclosporin,  corticosteroid|steroid eye drop...</td>\n",
       "      <td>Ciclosporin</td>\n",
       "      <td>corticosteroid|steroid eye drops</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>903516</td>\n",
       "      <td>Tonsillitis</td>\n",
       "      <td>[697.0]</td>\n",
       "      <td>[L43, l40]</td>\n",
       "      <td>[Paracetamol ,  ibuprofen,  penicillin, nan, n...</td>\n",
       "      <td>Paracetamol</td>\n",
       "      <td>ibuprofen</td>\n",
       "      <td>penicillin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>904585</td>\n",
       "      <td>Gastrointestinal bleeding</td>\n",
       "      <td>[578.9]</td>\n",
       "      <td>[K922, k90]</td>\n",
       "      <td>[Proton pump inhibitors,  octreotide,  antibio...</td>\n",
       "      <td>Proton pump inhibitors</td>\n",
       "      <td>octreotide</td>\n",
       "      <td>antibiotics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>133 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         id                                  name  \\\n",
       "0      1776                             Arthritis   \n",
       "1      4531                      Bipolar disorder   \n",
       "2      4581                   Bacterial vaginosis   \n",
       "3      4746                      Plague (disease)   \n",
       "4      5876               Coronary artery disease   \n",
       "5      7012                        Chagas disease   \n",
       "6      7038                           Candidiasis   \n",
       "7     10528                      Essential tremor   \n",
       "8     13492                       Hyperthyroidism   \n",
       "9     15354                 Interstitial cystitis   \n",
       "10    18998                     Myasthenia gravis   \n",
       "11    20423                               Malaria   \n",
       "12    21035                              Migraine   \n",
       "13    22461                          Osteoporosis   \n",
       "14    23251                       Phenylketonuria   \n",
       "15    23337                                Phobia   \n",
       "16    25161  Idiopathic intracranial hypertension   \n",
       "17    25875                  Rheumatoid arthritis   \n",
       "18    27790                         Schizophrenia   \n",
       "19    28649              Stevens–Johnson syndrome   \n",
       "20    28848                               Scabies   \n",
       "21    29500                    Serotonin syndrome   \n",
       "22    37284                           Brain tumor   \n",
       "23    38390                              Dementia   \n",
       "24    44700                               Leprosy   \n",
       "25    44738                    Diabetes insipidus   \n",
       "26    45475                       Marfan syndrome   \n",
       "27    46253                                 Fever   \n",
       "28    47878                  Huntington's disease   \n",
       "29    49364                       Turner syndrome   \n",
       "..      ...                                   ...   \n",
       "103  413928                            Ascariasis   \n",
       "104  414280                            Bad breath   \n",
       "105  414350                           Tooth decay   \n",
       "106  414967                         Pre-eclampsia   \n",
       "107  429592             Harlequin-type ichthyosis   \n",
       "108  443800                              Shingles   \n",
       "109  452461                           Myocarditis   \n",
       "110  465863                Seborrhoeic dermatitis   \n",
       "111  489173             Peripheral artery disease   \n",
       "112  491494                Ankylosing spondylitis   \n",
       "113  493567                          Epididymitis   \n",
       "114  546881                      Septic arthritis   \n",
       "115  570153                  Deep vein thrombosis   \n",
       "116  578144              Hidradenitis suppurativa   \n",
       "117  593388                Iron-deficiency anemia   \n",
       "118  606009           Hypertrophic cardiomyopathy   \n",
       "119  606011                Dilated cardiomyopathy   \n",
       "120  638645                     Short QT syndrome   \n",
       "121  674529                Pulmonary hypertension   \n",
       "122  679350                          Food allergy   \n",
       "123  718521               Subarachnoid hemorrhage   \n",
       "124  732173                            Cellulitis   \n",
       "125  741847                          Hyperkalemia   \n",
       "126  760951                         Cysticercosis   \n",
       "127  768604                        Reflex syncope   \n",
       "128  772724                   Opioid use disorder   \n",
       "129  792524                               Rosacea   \n",
       "130  794008                      Dry eye syndrome   \n",
       "131  903516                           Tonsillitis   \n",
       "132  904585             Gastrointestinal bleeding   \n",
       "\n",
       "                                icd9                              icd10  \\\n",
       "0                         [710, 719]               [M00, m00, M25, m20]   \n",
       "1                            [324.0]  [Q273, q20, Q280, q20, Q282, q20]   \n",
       "2                            [616.1]                              [N76]   \n",
       "3                              [020]                              [A20]   \n",
       "4                            [780.0]                        [R402, r40]   \n",
       "5                              [243]                         [E00, e00]   \n",
       "6                              [112]                         [B37, b35]   \n",
       "7                            [333.1]                        [G250, g20]   \n",
       "8                            [240.9]               [E01, e00, E05, e00]   \n",
       "9                            [595.1]                        [N301, n30]   \n",
       "10                    [359.0, 359.1]                        [G710, g70]   \n",
       "11                    [359.0, 359.1]                        [G710, g70]   \n",
       "12                    [359.0, 359.1]                        [G710, g70]   \n",
       "13                           [733.0]               [M80, m80, M82, m80]   \n",
       "14                           [270.1]                        [E700, e70]   \n",
       "15                           [300.2]                              [F40]   \n",
       "16                           [348.2]                        [G932, g90]   \n",
       "17   [E927.1, E927.3, E927.9, 727.2]                    [M70, X50, Z57]   \n",
       "18                    [345.9, 780.3]     [G40, g40, P90, p90, R56, r56]   \n",
       "19                           [307.0]                        [F985, f90]   \n",
       "20                           [307.0]                        [F985, f90]   \n",
       "21                           [307.0]                        [F985, f90]   \n",
       "22                      [191, 225.0]                         [C71, D33]   \n",
       "23                           [066.4]                             [A923]   \n",
       "24                           [125.7]                              [R56]   \n",
       "25                    [253.5, 588.1]             [E232, e20, N251, n25]   \n",
       "26                    [253.5, 588.1]             [E232, e20, N251, n25]   \n",
       "27                           [780.6]                         [R50, r50]   \n",
       "28               [307.4, 327, 780.5]               [F40, f40, F40, f40]   \n",
       "29               [307.4, 327, 780.5]               [F40, f40, F40, f40]   \n",
       "..                               ...                                ...   \n",
       "103                          [704.8]                   [L739, l60, L73]   \n",
       "104                          [784.9]                        [R196, r10]   \n",
       "105                          [784.9]                        [R196, r10]   \n",
       "106                          [784.9]                        [R196, r10]   \n",
       "107                       [644, 765]             [O601, o60, P073, p05]   \n",
       "108                   [386.9, 961.4]                        [E830, e83]   \n",
       "109              [391.2, 422, 429.0]             [I090, i05, I514, i30]   \n",
       "110                          [690.1]                         [L21, l20]   \n",
       "111                          [443.9]                        [I739, i70]   \n",
       "112                          [443.9]                        [I739, i70]   \n",
       "113                            [604]                        [N450, n40]   \n",
       "114                          [711.0]               [M00, m00, M03, m00]   \n",
       "115                          [453.4]                        [I802, i80]   \n",
       "116                          [705.8]                        [L732, l60]   \n",
       "117                            [311]                             [F388]   \n",
       "118                          [425.1]             [I421, i30, I422, i30]   \n",
       "119                          [425.4]                        [I420, i30]   \n",
       "120                          [426.0]                        [R943, r94]   \n",
       "121                   [416.0, 416.8]             [I270, i26, I272, i26]   \n",
       "122                               []                        [T780, t66]   \n",
       "123              [430, 852.0, 852.1]   [I60, i60, P103, p10, S066, s00]   \n",
       "124                          [728.6]                        [M720, m70]   \n",
       "125                          [276.7]                        [E875, e70]   \n",
       "126                          [748.0]                        [S525, s50]   \n",
       "127                               []                         [R55, r50]   \n",
       "128                          [304.0]                         [F11, f10]   \n",
       "129                          [695.3]                         [L71, l60]   \n",
       "130                          [370.3]                        [H193, h15]   \n",
       "131                          [697.0]                         [L43, l40]   \n",
       "132                          [578.9]                        [K922, k90]   \n",
       "\n",
       "                                           medications  \\\n",
       "0    [Ibuprofen,  paracetamol , nan, nan, nan, nan,...   \n",
       "1    [Lithium ,  antipsychotics,  anticonvulsants, ...   \n",
       "2    [Clindamycin or metronidazole, nan, nan, nan, ...   \n",
       "3    [Gentamicin and a fluoroquinolone, nan, nan, n...   \n",
       "4    [Aspirin,  beta blockers,  Medical use of nitr...   \n",
       "5    [Benznidazole,  nifurtimox, nan, nan, nan, nan...   \n",
       "6    [Clotrimazole,  nystatin,  fluconazole, nan, n...   \n",
       "7    [Beta blockers; propranolol,  nadolol,  timolo...   \n",
       "8    [Beta blockers,  methimazole, nan, nan, nan, n...   \n",
       "9    [Ibuprofen,  pentosan polysulfate,  amitriptyl...   \n",
       "10   [Acetylcholinesterase inhibitors ,  pyridostig...   \n",
       "11   [Antimalarial medication, nan, nan, nan, nan, ...   \n",
       "12   [Ibuprofen,  paracetamol ,  triptans,  ergotam...   \n",
       "13   [Bisphosphonates, nan, nan, nan, nan, nan, nan...   \n",
       "14   [Sapropterin dihydrochloride, nan, nan, nan, n...   \n",
       "15   [Antidepressants,  benzodiazepines,  beta-bloc...   \n",
       "16   [Acetazolamide, nan, nan, nan, nan, nan, nan, ...   \n",
       "17   [Analgesics|Pain medications,  glucocorticoid|...   \n",
       "18   [Antipsychotics, nan, nan, nan, nan, nan, nan,...   \n",
       "19   [Pain medication,  antihistamines,  antibiotic...   \n",
       "20   [Permethrin,  crotamiton,  lindane,  ivermecti...   \n",
       "21   [Benzodiazepines,  cyproheptadine, nan, nan, n...   \n",
       "22   [Anticonvulsants,  dexamethasone,  furosemide,...   \n",
       "23   [Acetylcholinesterase inhibitor|Cholinesterase...   \n",
       "24   [Rifampicin,  dapsone,  clofazimine, nan, nan,...   \n",
       "25   [Desmopressin,  thiazides,  aspirin, nan, nan,...   \n",
       "26   [Beta blockers,  calcium channel blockers,  AC...   \n",
       "27   [Ibuprofen,  paracetamol , nan, nan, nan, nan,...   \n",
       "28   [Tetrabenazine, nan, nan, nan, nan, nan, nan, ...   \n",
       "29   [Human growth hormone,  estrogen replacement t...   \n",
       "..                                                 ...   \n",
       "103  [Albendazole,  mebendazole,  levamisole,  pyra...   \n",
       "104  [Mouthwash containing chlorhexidine or cetylpy...   \n",
       "105  [Paracetamol ,  ibuprofen, nan, nan, nan, nan,...   \n",
       "106  [Labetalol,  methyldopa,  magnesium sulfate, n...   \n",
       "107  [Antibiotics,  etretinate,  retinoids, nan, na...   \n",
       "108  [Aciclovir ,  pain medication, nan, nan, nan, ...   \n",
       "109  [ACE inhibitors,  beta blockers,  diuretics,  ...   \n",
       "110  [antifungal medications|Antifungal cream,  ant...   \n",
       "111  [Statins,  ACE inhibitors,  cilostazol, nan, n...   \n",
       "112  [NSAIDs,  corticosteroids|steroids,  Disease-m...   \n",
       "113  [NSAIDs,  ceftriaxone and doxycycline,  ofloxa...   \n",
       "114  [Vancomycin,  ceftriaxone,  ceftazidime, nan, ...   \n",
       "115  [Low-molecular-weight heparin,  warfarin,  dir...   \n",
       "116  [Antibiotics,  immunosuppressive medication, n...   \n",
       "117  [Iron supplements,  vitamin C,  blood transfus...   \n",
       "118  [Beta blockers,  diuretics,  disopyramide, nan...   \n",
       "119  [ACE inhibitor,  beta blocker,  diuretic,  ant...   \n",
       "120  [Quinidine,  Flecainide , nan, nan, nan, nan, ...   \n",
       "121  [Epoprostenol,  treprostinil,  iloprost,  bose...   \n",
       "122   [Adrenaline , nan, nan, nan, nan, nan, nan, nan]   \n",
       "123  [Labetalol,  nimodipine, nan, nan, nan, nan, n...   \n",
       "124  [Antibiotics such as cephalexin, nan, nan, nan...   \n",
       "125  [Calcium gluconate,  dextrose with insulin,  s...   \n",
       "126  [Praziquantel,  albendazole,  corticosteroids,...   \n",
       "127  [Midodrine,  fludrocortisone, nan, nan, nan, n...   \n",
       "128  [Buprenorphine,  methadone,  naltrexone<ref na...   \n",
       "129  [Antibiotics either by mouth or applied to the...   \n",
       "130  [Ciclosporin,  corticosteroid|steroid eye drop...   \n",
       "131  [Paracetamol ,  ibuprofen,  penicillin, nan, n...   \n",
       "132  [Proton pump inhibitors,  octreotide,  antibio...   \n",
       "\n",
       "                                          medication_0  \\\n",
       "0                                            Ibuprofen   \n",
       "1                                             Lithium    \n",
       "2                         Clindamycin or metronidazole   \n",
       "3                     Gentamicin and a fluoroquinolone   \n",
       "4                                              Aspirin   \n",
       "5                                         Benznidazole   \n",
       "6                                         Clotrimazole   \n",
       "7                           Beta blockers; propranolol   \n",
       "8                                        Beta blockers   \n",
       "9                                            Ibuprofen   \n",
       "10                    Acetylcholinesterase inhibitors    \n",
       "11                             Antimalarial medication   \n",
       "12                                           Ibuprofen   \n",
       "13                                     Bisphosphonates   \n",
       "14                         Sapropterin dihydrochloride   \n",
       "15                                     Antidepressants   \n",
       "16                                       Acetazolamide   \n",
       "17                         Analgesics|Pain medications   \n",
       "18                                      Antipsychotics   \n",
       "19                                     Pain medication   \n",
       "20                                          Permethrin   \n",
       "21                                     Benzodiazepines   \n",
       "22                                     Anticonvulsants   \n",
       "23   Acetylcholinesterase inhibitor|Cholinesterase ...   \n",
       "24                                          Rifampicin   \n",
       "25                                        Desmopressin   \n",
       "26                                       Beta blockers   \n",
       "27                                           Ibuprofen   \n",
       "28                                       Tetrabenazine   \n",
       "29                                Human growth hormone   \n",
       "..                                                 ...   \n",
       "103                                        Albendazole   \n",
       "104  Mouthwash containing chlorhexidine or cetylpyr...   \n",
       "105                                       Paracetamol    \n",
       "106                                          Labetalol   \n",
       "107                                        Antibiotics   \n",
       "108                                         Aciclovir    \n",
       "109                                     ACE inhibitors   \n",
       "110            antifungal medications|Antifungal cream   \n",
       "111                                            Statins   \n",
       "112                                             NSAIDs   \n",
       "113                                             NSAIDs   \n",
       "114                                         Vancomycin   \n",
       "115                       Low-molecular-weight heparin   \n",
       "116                                        Antibiotics   \n",
       "117                                   Iron supplements   \n",
       "118                                      Beta blockers   \n",
       "119                                      ACE inhibitor   \n",
       "120                                          Quinidine   \n",
       "121                                       Epoprostenol   \n",
       "122                                        Adrenaline    \n",
       "123                                          Labetalol   \n",
       "124                     Antibiotics such as cephalexin   \n",
       "125                                  Calcium gluconate   \n",
       "126                                       Praziquantel   \n",
       "127                                          Midodrine   \n",
       "128                                      Buprenorphine   \n",
       "129  Antibiotics either by mouth or applied to the ...   \n",
       "130                                        Ciclosporin   \n",
       "131                                       Paracetamol    \n",
       "132                             Proton pump inhibitors   \n",
       "\n",
       "                          medication_1  \\\n",
       "0                         paracetamol    \n",
       "1                       antipsychotics   \n",
       "2                                  NaN   \n",
       "3                                  NaN   \n",
       "4                        beta blockers   \n",
       "5                           nifurtimox   \n",
       "6                             nystatin   \n",
       "7                              nadolol   \n",
       "8                          methimazole   \n",
       "9                 pentosan polysulfate   \n",
       "10                     pyridostigmine)   \n",
       "11                                 NaN   \n",
       "12                        paracetamol    \n",
       "13                                 NaN   \n",
       "14                                 NaN   \n",
       "15                     benzodiazepines   \n",
       "16                                 NaN   \n",
       "17             glucocorticoid|steroids   \n",
       "18                                 NaN   \n",
       "19                      antihistamines   \n",
       "20                          crotamiton   \n",
       "21                      cyproheptadine   \n",
       "22                       dexamethasone   \n",
       "23                                 NaN   \n",
       "24                             dapsone   \n",
       "25                           thiazides   \n",
       "26            calcium channel blockers   \n",
       "27                        paracetamol    \n",
       "28                                 NaN   \n",
       "29        estrogen replacement therapy   \n",
       "..                                 ...   \n",
       "103                        mebendazole   \n",
       "104                                NaN   \n",
       "105                          ibuprofen   \n",
       "106                         methyldopa   \n",
       "107                         etretinate   \n",
       "108                    pain medication   \n",
       "109                      beta blockers   \n",
       "110           anti-inflammatory agents   \n",
       "111                     ACE inhibitors   \n",
       "112           corticosteroids|steroids   \n",
       "113        ceftriaxone and doxycycline   \n",
       "114                        ceftriaxone   \n",
       "115                           warfarin   \n",
       "116       immunosuppressive medication   \n",
       "117                          vitamin C   \n",
       "118                          diuretics   \n",
       "119                       beta blocker   \n",
       "120                        Flecainide    \n",
       "121                       treprostinil   \n",
       "122                                NaN   \n",
       "123                         nimodipine   \n",
       "124                                NaN   \n",
       "125              dextrose with insulin   \n",
       "126                        albendazole   \n",
       "127                    fludrocortisone   \n",
       "128                          methadone   \n",
       "129                                NaN   \n",
       "130   corticosteroid|steroid eye drops   \n",
       "131                          ibuprofen   \n",
       "132                         octreotide   \n",
       "\n",
       "                                     medication_2  \\\n",
       "0                                             NaN   \n",
       "1                                 anticonvulsants   \n",
       "2                                             NaN   \n",
       "3                                             NaN   \n",
       "4      Medical use of nitroglycerin|nitroglycerin   \n",
       "5                                             NaN   \n",
       "6                                     fluconazole   \n",
       "7                                         timolol   \n",
       "8                                             NaN   \n",
       "9                                   amitriptyline   \n",
       "10                             immunosuppressants   \n",
       "11                                            NaN   \n",
       "12                                       triptans   \n",
       "13                                            NaN   \n",
       "14                                            NaN   \n",
       "15                                  beta-blockers   \n",
       "16                                            NaN   \n",
       "17           Nonsteroidal anti-inflammatory drugs   \n",
       "18                                            NaN   \n",
       "19                                    antibiotics   \n",
       "20                                        lindane   \n",
       "21                                            NaN   \n",
       "22                                     furosemide   \n",
       "23                                            NaN   \n",
       "24                                    clofazimine   \n",
       "25                                        aspirin   \n",
       "26                                 ACE inhibitors   \n",
       "27                                            NaN   \n",
       "28                                            NaN   \n",
       "29                                            NaN   \n",
       "..                                            ...   \n",
       "103                                    levamisole   \n",
       "104                                           NaN   \n",
       "105                                           NaN   \n",
       "106                             magnesium sulfate   \n",
       "107                                     retinoids   \n",
       "108                                           NaN   \n",
       "109                                     diuretics   \n",
       "110                                      coal tar   \n",
       "111                                    cilostazol   \n",
       "112   Disease-modifying antirheumatic drug|DMARDs   \n",
       "113                                     ofloxacin   \n",
       "114                                   ceftazidime   \n",
       "115                     direct oral anticoagulant   \n",
       "116                                           NaN   \n",
       "117                            blood transfusions   \n",
       "118                                  disopyramide   \n",
       "119                                      diuretic   \n",
       "120                                           NaN   \n",
       "121                                      iloprost   \n",
       "122                                           NaN   \n",
       "123                                           NaN   \n",
       "124                                           NaN   \n",
       "125                                    salbutamol   \n",
       "126                               corticosteroids   \n",
       "127                                           NaN   \n",
       "128               naltrexone<ref name=BMJ2017Re/>   \n",
       "129                                           NaN   \n",
       "130                                           NaN   \n",
       "131                                    penicillin   \n",
       "132                                   antibiotics   \n",
       "\n",
       "                               medication_3                  medication_4  \\\n",
       "0                                       NaN                           NaN   \n",
       "1                                       NaN                           NaN   \n",
       "2                                       NaN                           NaN   \n",
       "3                                       NaN                           NaN   \n",
       "4                                   statins                           NaN   \n",
       "5                                       NaN                           NaN   \n",
       "6                                       NaN                           NaN   \n",
       "7                                 primidone   anti-epileptics; topiramate   \n",
       "8                                       NaN                           NaN   \n",
       "9                                       NaN                           NaN   \n",
       "10                                      NaN                           NaN   \n",
       "11                                      NaN                           NaN   \n",
       "12                              ergotamines                           NaN   \n",
       "13                                      NaN                           NaN   \n",
       "14                                      NaN                           NaN   \n",
       "15                                      NaN                           NaN   \n",
       "16                                      NaN                           NaN   \n",
       "17    disease-modifying antirheumatic drugs                           NaN   \n",
       "18                                      NaN                           NaN   \n",
       "19                          corticosteroids   intravenous immunoglobulins   \n",
       "20                               ivermectin                           NaN   \n",
       "21                                      NaN                           NaN   \n",
       "22                                      NaN                           NaN   \n",
       "23                                      NaN                           NaN   \n",
       "24                                      NaN                           NaN   \n",
       "25                                      NaN                           NaN   \n",
       "26                                      NaN                           NaN   \n",
       "27                                      NaN                           NaN   \n",
       "28                                      NaN                           NaN   \n",
       "29                                      NaN                           NaN   \n",
       "..                                      ...                           ...   \n",
       "103                        pyrantel pamoate                           NaN   \n",
       "104                                     NaN                           NaN   \n",
       "105                                     NaN                           NaN   \n",
       "106                                     NaN                           NaN   \n",
       "107                                     NaN                           NaN   \n",
       "108                                     NaN                           NaN   \n",
       "109                         corticosteroids    intravenous immunoglobulin   \n",
       "110                            phototherapy                           NaN   \n",
       "111                                     NaN                           NaN   \n",
       "112                                     NaN                           NaN   \n",
       "113                                     NaN                           NaN   \n",
       "114                                     NaN                           NaN   \n",
       "115                                     NaN                           NaN   \n",
       "116                                     NaN                           NaN   \n",
       "117                                     NaN                           NaN   \n",
       "118                                     NaN                           NaN   \n",
       "119           anticoagulants|blood thinners                           NaN   \n",
       "120                                     NaN                           NaN   \n",
       "121                                bosentan                   ambrisentan   \n",
       "122                                     NaN                           NaN   \n",
       "123                                     NaN                           NaN   \n",
       "124                                     NaN                           NaN   \n",
       "125   sodium bicarbonate<ref name=Leh2011/>                           NaN   \n",
       "126                anti seizure medications                           NaN   \n",
       "127                                     NaN                           NaN   \n",
       "128                                     NaN                           NaN   \n",
       "129                                     NaN                           NaN   \n",
       "130                                     NaN                           NaN   \n",
       "131                                     NaN                           NaN   \n",
       "132                                     NaN                           NaN   \n",
       "\n",
       "    medication_5                      medication_6 medication_7  \n",
       "0            NaN                               NaN          NaN  \n",
       "1            NaN                               NaN          NaN  \n",
       "2            NaN                               NaN          NaN  \n",
       "3            NaN                               NaN          NaN  \n",
       "4            NaN                               NaN          NaN  \n",
       "5            NaN                               NaN          NaN  \n",
       "6            NaN                               NaN          NaN  \n",
       "7     gabapentin    levetiracetam; benzodiazepines          NaN  \n",
       "8            NaN                               NaN          NaN  \n",
       "9            NaN                               NaN          NaN  \n",
       "10           NaN                               NaN          NaN  \n",
       "11           NaN                               NaN          NaN  \n",
       "12           NaN                               NaN          NaN  \n",
       "13           NaN                               NaN          NaN  \n",
       "14           NaN                               NaN          NaN  \n",
       "15           NaN                               NaN          NaN  \n",
       "16           NaN                               NaN          NaN  \n",
       "17           NaN                               NaN          NaN  \n",
       "18           NaN                               NaN          NaN  \n",
       "19           NaN                               NaN          NaN  \n",
       "20           NaN                               NaN          NaN  \n",
       "21           NaN                               NaN          NaN  \n",
       "22           NaN                               NaN          NaN  \n",
       "23           NaN                               NaN          NaN  \n",
       "24           NaN                               NaN          NaN  \n",
       "25           NaN                               NaN          NaN  \n",
       "26           NaN                               NaN          NaN  \n",
       "27           NaN                               NaN          NaN  \n",
       "28           NaN                               NaN          NaN  \n",
       "29           NaN                               NaN          NaN  \n",
       "..           ...                               ...          ...  \n",
       "103          NaN                               NaN          NaN  \n",
       "104          NaN                               NaN          NaN  \n",
       "105          NaN                               NaN          NaN  \n",
       "106          NaN                               NaN          NaN  \n",
       "107          NaN                               NaN          NaN  \n",
       "108          NaN                               NaN          NaN  \n",
       "109          NaN                               NaN          NaN  \n",
       "110          NaN                               NaN          NaN  \n",
       "111          NaN                               NaN          NaN  \n",
       "112          NaN                               NaN          NaN  \n",
       "113          NaN                               NaN          NaN  \n",
       "114          NaN                               NaN          NaN  \n",
       "115          NaN                               NaN          NaN  \n",
       "116          NaN                               NaN          NaN  \n",
       "117          NaN                               NaN          NaN  \n",
       "118          NaN                               NaN          NaN  \n",
       "119          NaN                               NaN          NaN  \n",
       "120          NaN                               NaN          NaN  \n",
       "121   macitentan                        sildenafil          NaN  \n",
       "122          NaN                               NaN          NaN  \n",
       "123          NaN                               NaN          NaN  \n",
       "124          NaN                               NaN          NaN  \n",
       "125          NaN                               NaN          NaN  \n",
       "126          NaN                               NaN          NaN  \n",
       "127          NaN                               NaN          NaN  \n",
       "128          NaN                               NaN          NaN  \n",
       "129          NaN                               NaN          NaN  \n",
       "130          NaN                               NaN          NaN  \n",
       "131          NaN                               NaN          NaN  \n",
       "132          NaN                               NaN          NaN  \n",
       "\n",
       "[133 rows x 13 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}