drug_interaction_api.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### NIH RxNorm API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import json\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_interactions_fromlist(source : str, rxnorm_code_list : list):\n",
    "    if not isinstance(rxnorm_code_list, list) :\n",
    "        print(\"Instance is not a list.\")\n",
    "        return 0\n",
    "\n",
    "    else : \n",
    "        rxnorm_code = \"%20\".join(rxnorm_code_list)\n",
    "        API_HOST = \"https://rxnav.nlm.nih.gov\"\n",
    "        path = f\"/REST/interaction/list.json?rxcuis={rxnorm_code}&sources={source}\"\n",
    "        \n",
    "        url = API_HOST + path\n",
    "        headers = {'Content-Type': 'application/json', 'charset': 'UTF-8', 'Accept': '*/*'}\n",
    "        \n",
    "        try:\n",
    "            response = requests.get(url, headers=headers)\n",
    "            print(\"response status %r\" % response.status_code)\n",
    "            print(\"response text %r\" % response.text)\n",
    "            data = response.json()\n",
    "            return data\n",
    "\n",
    "        except Exception as ex:\n",
    "            print(ex)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_rxnorm_code(drug_name):\n",
    "    base_url = \"https://rxnav.nlm.nih.gov/REST/rxcui.json\"\n",
    "    params = {\n",
    "        \"name\": drug_name\n",
    "    }\n",
    "\n",
    "    response = requests.get(base_url, params=params)\n",
    "\n",
    "    if response.status_code == 200:\n",
    "        data = response.json()\n",
    "        if \"idGroup\" in data:\n",
    "            if \"rxnormId\" in data[\"idGroup\"]:\n",
    "                rxnorm_code = data[\"idGroup\"][\"rxnormId\"][0]\n",
    "                return rxnorm_code\n",
    "    else:\n",
    "        print(\"Error: Failed to retrieve RxNORM code.\")\n",
    "\n",
    "    return None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "response status 200\n",
      "response text '{\"nlmDisclaimer\":\"It is not the intention of NLM to provide specific medical advice, but rather to provide users with information to better understand their health and their medications. NLM urges you to consult with a qualified physician for advice about medications.\",\"fullInteractionTypeGroup\":[{\"sourceDisclaimer\":\"DrugBank is intended for educational and scientific research purposes only and you expressly acknowledge and agree that use of DrugBank is at your sole risk. The accuracy of DrugBank information is not guaranteed and reliance on DrugBank shall be at your sole risk. DrugBank is not intended as a substitute for professional medical advice, diagnosis or treatment..[www.drugbank.ca]\",\"sourceName\":\"DrugBank\",\"fullInteractionType\":[{\"comment\":\"Drug1 (rxcui = 135446, name = Aricept, tty = BN). Drug2 (rxcui = 202433, name = Tylenol, tty = BN). Drug1 is resolved to donepezil, Drug2 is resolved to acetaminophen and interaction asserted in DrugBank between Donepezil and Acetaminophen.\",\"minConcept\":[{\"rxcui\":\"135446\",\"name\":\"Aricept\",\"tty\":\"BN\"},{\"rxcui\":\"202433\",\"name\":\"Tylenol\",\"tty\":\"BN\"}],\"interactionPair\":[{\"interactionConcept\":[{\"minConceptItem\":{\"rxcui\":\"135447\",\"name\":\"donepezil\",\"tty\":\"IN\"},\"sourceConceptItem\":{\"id\":\"DB00843\",\"name\":\"Donepezil\",\"url\":\"https://go.drugbank.com/drugs/DB00843#interactions\"}},{\"minConceptItem\":{\"rxcui\":\"161\",\"name\":\"acetaminophen\",\"tty\":\"IN\"},\"sourceConceptItem\":{\"id\":\"DB00316\",\"name\":\"Acetaminophen\",\"url\":\"https://go.drugbank.com/drugs/DB00316#interactions\"}}],\"severity\":\"N/A\",\"description\":\"The metabolism of Donepezil can be decreased when combined with Acetaminophen.\"}]}]}]}'\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'nlmDisclaimer': 'It is not the intention of NLM to provide specific medical advice, but rather to provide users with information to better understand their health and their medications. NLM urges you to consult with a qualified physician for advice about medications.',\n",
       " 'fullInteractionTypeGroup': [{'sourceDisclaimer': 'DrugBank is intended for educational and scientific research purposes only and you expressly acknowledge and agree that use of DrugBank is at your sole risk. The accuracy of DrugBank information is not guaranteed and reliance on DrugBank shall be at your sole risk. DrugBank is not intended as a substitute for professional medical advice, diagnosis or treatment..[www.drugbank.ca]',\n",
       "   'sourceName': 'DrugBank',\n",
       "   'fullInteractionType': [{'comment': 'Drug1 (rxcui = 135446, name = Aricept, tty = BN). Drug2 (rxcui = 202433, name = Tylenol, tty = BN). Drug1 is resolved to donepezil, Drug2 is resolved to acetaminophen and interaction asserted in DrugBank between Donepezil and Acetaminophen.',\n",
       "     'minConcept': [{'rxcui': '135446', 'name': 'Aricept', 'tty': 'BN'},\n",
       "      {'rxcui': '202433', 'name': 'Tylenol', 'tty': 'BN'}],\n",
       "     'interactionPair': [{'interactionConcept': [{'minConceptItem': {'rxcui': '135447',\n",
       "          'name': 'donepezil',\n",
       "          'tty': 'IN'},\n",
       "         'sourceConceptItem': {'id': 'DB00843',\n",
       "          'name': 'Donepezil',\n",
       "          'url': 'https://go.drugbank.com/drugs/DB00843#interactions'}},\n",
       "        {'minConceptItem': {'rxcui': '161',\n",
       "          'name': 'acetaminophen',\n",
       "          'tty': 'IN'},\n",
       "         'sourceConceptItem': {'id': 'DB00316',\n",
       "          'name': 'Acetaminophen',\n",
       "          'url': 'https://go.drugbank.com/drugs/DB00316#interactions'}}],\n",
       "       'severity': 'N/A',\n",
       "       'description': 'The metabolism of Donepezil can be decreased when combined with Acetaminophen.'}]}]}]}"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sources = [\"DrugBank\", \"ONCHigh\"]\n",
    "rxnorm_code_list = [\"202433\",\"135446\"]\n",
    "\n",
    "response = get_interactions_fromlist(sources[0], rxnorm_code_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "N/A The metabolism of Donepezil can be decreased when combined with Acetaminophen.\n"
     ]
    }
   ],
   "source": [
    "severity = response['fullInteractionTypeGroup'][0]['fullInteractionType'][0]['interactionPair'][0]['severity']\n",
    "description = response['fullInteractionTypeGroup'][0]['fullInteractionType'][0]['interactionPair'][0]['description']\n",
    "print(severity, description)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "RxNORM code for aricept: 135446\n"
     ]
    }
   ],
   "source": [
    "drug_name = \"aricept\"\n",
    "rxnorm_code = get_rxnorm_code(drug_name)\n",
    "if rxnorm_code:\n",
    "    print(f\"RxNORM code for {drug_name}: {rxnorm_code}\")\n",
    "else:\n",
    "    print(\"RxNORM code not found.\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "202433 135446"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "response status 200\n",
      "response text '<?xml version=\"1.0\" ?><interactiondata><nlmDisclaimer>It is not the intention of NLM to provide specific medical advice, but rather to provide users with information to better understand their health and their medications. NLM urges you to consult with a qualified physician for advice about medications.</nlmDisclaimer><interactionTypeGroup><sourceDisclaimer>https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3422823/</sourceDisclaimer><sourceName>ONCHigh</sourceName><interactionType><comment>Aricept (135446) is resolved to donepezil (135447)</comment><minConceptItem><rxcui>135446</rxcui><name>Aricept</name><tty>BN</tty></minConceptItem><interactionPair><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>10239</rxcui><name>sulpiride</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>sulpiride</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>10502</rxcui><name>thioridazine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>thioridazine</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>1098413</rxcui><name>vandetanib</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>vandetanib</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>139462</rxcui><name>moxifloxacin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>moxifloxacin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>1436</rxcui><name>bepridil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>bepridil</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>18330</rxcui><name>arsenic trioxide</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>arsenic trioxide</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>18469</rxcui><name>sparfloxacin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>sparfloxacin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>18631</rxcui><name>azithromycin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>azithromycin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>20599</rxcui><name>cesium chloride</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>cesium chloride</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>21107</rxcui><name>cilostazol</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>cilostazol</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>21212</rxcui><name>clarithromycin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>clarithromycin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>228476</rxcui><name>gatifloxacin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>gatifloxacin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>233698</rxcui><name>dronedarone</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>dronedarone</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>239</rxcui><name>aclarubicin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>aclarubicin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>2393</rxcui><name>chloroquine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>chloroquine</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>2403</rxcui><name>chlorpromazine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>chlorpromazine</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>2406</rxcui><name>chlorprothixene</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>chlorprothixene</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>2551</rxcui><name>ciprofloxacin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>ciprofloxacin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>2556</rxcui><name>citalopram</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>citalopram</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>2570736</rxcui><name>mobocertinib</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>mobocertinib</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>26225</rxcui><name>ondansetron</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>ondansetron</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>2653</rxcui><name>cocaine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>cocaine</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>27220</rxcui><name>hydroquinidine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>hydroquinidine</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>319866</rxcui><name>meglumine antimoniate</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>meglumine antimoniate</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>32592</rxcui><name>oxaliplatin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>oxaliplatin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>35255</rxcui><name>cisapride</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>cisapride</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>3541</rxcui><name>disopyramide</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>disopyramide</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>3626</rxcui><name>domperidone</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>domperidone</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>36453</rxcui><name>sevoflurane</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>sevoflurane</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>3648</rxcui><name>droperidol</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>droperidol</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>37416</rxcui><name>sultopride</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>sultopride</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>37815</rxcui><name>terodiline</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>terodiline</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>4053</rxcui><name>erythromycin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>erythromycin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>41289</rxcui><name>ibutilide</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>ibutilide</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>41996</rxcui><name>sertindole</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>sertindole</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>42328</rxcui><name>astemizole</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>astemizole</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>42330</rxcui><name>terfenadine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>terfenadine</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>4441</rxcui><name>flecainide</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>flecainide</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>4450</rxcui><name>fluconazole</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>fluconazole</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>49247</rxcui><name>dofetilide</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>dofetilide</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>50749</rxcui><name>halofantrine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>halofantrine</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>5093</rxcui><name>haloperidol</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>haloperidol</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>5521</rxcui><name>hydroxychloroquine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>hydroxychloroquine</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>57048</rxcui><name>terlipressin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>terlipressin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>596724</rxcui><name>anagrelide</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>anagrelide</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>6779</rxcui><name>mesoridazine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>mesoridazine</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>6813</rxcui><name>methadone</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>methadone</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>6852</rxcui><name>methotrimeprazine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>methotrimeprazine</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>703</rxcui><name>amiodarone</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>amiodarone</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>203132</rxcui><name>papaverine hydrochloride</name><tty>PIN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>papaverine hydrochloride</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>7994</rxcui><name>pentamidine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>pentamidine</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>82122</rxcui><name>levofloxacin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>levofloxacin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>8331</rxcui><name>pimozide</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>pimozide</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>83719</rxcui><name>grepafloxacin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>grepafloxacin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>8699</rxcui><name>probucol</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>probucol</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>8700</rxcui><name>procainamide</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>procainamide</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>8782</rxcui><name>propofol</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>propofol</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>9068</rxcui><name>quinidine</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>quinidine</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>9478</rxcui><name>roxithromycin</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>roxithromycin</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair><interactionPair><interactionConcept><minConceptItem><rxcui>9947</rxcui><name>sotalol</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>sotalol</name><url>NA</url></sourceConceptItem></interactionConcept><interactionConcept><minConceptItem><rxcui>135447</rxcui><name>donepezil</name><tty>IN</tty></minConceptItem><sourceConceptItem><id>NA</id><name>donepezil</name><url>NA</url></sourceConceptItem></interactionConcept><severity>high</severity><description>QT prolonging agents - QT prolonging agents</description></interactionPair></interactionType></interactionTypeGroup></interactiondata>'\n"
     ]
    }
   ],
   "source": [
    "url = f\"/REST/interaction/interaction.xml?rxcui={rxnorm_code}&sources={sources[1]}\" \n",
    "get_interactions(url)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 한국 API : DUR 품목정보 API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "base_url = \"apis.data.go.kr/1471000/DURPrdlstInfoService02\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "response = requests.get(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "if response.status_code == 200 :\n",
    "   data = response.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>ITEM_SEQ</th>\n",
       "      <th>ITEM_NAME</th>\n",
       "      <th>ENTP_NAME</th>\n",
       "      <th>ITEM_PERMIT_DATE</th>\n",
       "      <th>ETC_OTC_CODE</th>\n",
       "      <th>CLASS_NO</th>\n",
       "      <th>CHART</th>\n",
       "      <th>BAR_CODE</th>\n",
       "      <th>MATERIAL_NAME</th>\n",
       "      <th>EE_DOC_ID</th>\n",
       "      <th>...</th>\n",
       "      <th>REEXAM_TARGET</th>\n",
       "      <th>REEXAM_DATE</th>\n",
       "      <th>PACK_UNIT</th>\n",
       "      <th>EDI_CODE</th>\n",
       "      <th>CANCEL_DATE</th>\n",
       "      <th>CANCEL_NAME</th>\n",
       "      <th>TYPE_CODE</th>\n",
       "      <th>TYPE_NAME</th>\n",
       "      <th>CHANGE_DATE</th>\n",
       "      <th>BIZRNO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>195700013</td>\n",
       "      <td>제일에페드린염산염주사액4%</td>\n",
       "      <td>(주)제일제약</td>\n",
       "      <td>1957April26th</td>\n",
       "      <td>전문의약품</td>\n",
       "      <td>[222]진해거담제</td>\n",
       "      <td>무색 투명한 액이 든 갈색 투명한 앰플주사제</td>\n",
       "      <td>8806505004626</td>\n",
       "      <td>에페드린염산염,,40,밀리그램,KP,</td>\n",
       "      <td>HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1mL × 10앰플, 1mL × 50앰플</td>\n",
       "      <td>650500461</td>\n",
       "      <td>None</td>\n",
       "      <td>정상</td>\n",
       "      <td>C</td>\n",
       "      <td>임부금기</td>\n",
       "      <td>2018June14th</td>\n",
       "      <td>5148126323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>195700015</td>\n",
       "      <td>안나카주사액20%(제일벤조산나트륨카페인주)(수출용)</td>\n",
       "      <td>(주)제일제약</td>\n",
       "      <td>1957April27th</td>\n",
       "      <td>전문의약품</td>\n",
       "      <td>[211]강심제</td>\n",
       "      <td>무색~거의 투명한 액이 든 무색 투명한 앰플주사제</td>\n",
       "      <td>8806505002325</td>\n",
       "      <td>벤조산나트륨카페인,,0.2,그램,KP,</td>\n",
       "      <td>HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1mL, 2mL/앰플 × 자사포장단위</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>정상</td>\n",
       "      <td>I</td>\n",
       "      <td>첨가제주의</td>\n",
       "      <td>2018September17th</td>\n",
       "      <td>5148126323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>195700016</td>\n",
       "      <td>안나카주사액10%(제일벤조산나트륨카페인주)(수출용)</td>\n",
       "      <td>(주)제일제약</td>\n",
       "      <td>1957April27th</td>\n",
       "      <td>전문의약품</td>\n",
       "      <td>[211]강심제</td>\n",
       "      <td>무색~거의 투명한 액이 든 무색 투명한 앰플주사제</td>\n",
       "      <td>8806505002226</td>\n",
       "      <td>벤조산나트륨카페인,,0.1,그램,KP,</td>\n",
       "      <td>HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1mL, 2mL/앰플 × 자사포장단위</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>정상</td>\n",
       "      <td>I</td>\n",
       "      <td>첨가제주의</td>\n",
       "      <td>2018September17th</td>\n",
       "      <td>5148126323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>195700020</td>\n",
       "      <td>활명수</td>\n",
       "      <td>동화약품(주)</td>\n",
       "      <td>1957January31st</td>\n",
       "      <td>일반의약품</td>\n",
       "      <td>[233]건위소화제</td>\n",
       "      <td>이약은 적갈색의 액제이다.</td>\n",
       "      <td>8806427038921</td>\n",
       "      <td>아선약, - 제1법 75mL,100.0,밀리그램,KP,/진피, - 제1법 75mL,...</td>\n",
       "      <td>HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>75mL/병, 450mL/병</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>정상</td>\n",
       "      <td>I</td>\n",
       "      <td>첨가제주의</td>\n",
       "      <td>2019June20th</td>\n",
       "      <td>1108100102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>195800018</td>\n",
       "      <td>대원염산에페드린주사액[수출명:에린주사(에페드린염산염)(ErineInj.)]</td>\n",
       "      <td>대원제약(주)</td>\n",
       "      <td>1958December7th</td>\n",
       "      <td>전문의약품</td>\n",
       "      <td>[222]진해거담제</td>\n",
       "      <td>무색투명한 액이 든 갈색앰플제 수출용 : 무색투명한 액이 든 앰플제</td>\n",
       "      <td>8806718007339</td>\n",
       "      <td>에페드린염산염,,40,밀리그램,KP,</td>\n",
       "      <td>HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>내수용 : 1mL/앰플 X 50, 수출용 : 1mL/앰플 X 50</td>\n",
       "      <td>671800730</td>\n",
       "      <td>None</td>\n",
       "      <td>정상</td>\n",
       "      <td>C</td>\n",
       "      <td>임부금기</td>\n",
       "      <td>2015December17th</td>\n",
       "      <td>2078136336</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",
       "      <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>95</th>\n",
       "      <td>197500015</td>\n",
       "      <td>아목사펜캡슐(아목시실린수화물)(수출명:아드목스캡슐,에프페닉스캡슐)</td>\n",
       "      <td>(주)종근당</td>\n",
       "      <td>1975September6th</td>\n",
       "      <td>전문의약품</td>\n",
       "      <td>[618]주로 그람양성, 음성균에 작용하는 것</td>\n",
       "      <td>내수용 및 수출용(아드목스캡슐) : 백색 내지 황백색의 결정 또는 결정성가루를 함유...</td>\n",
       "      <td>8806433016746</td>\n",
       "      <td>아목시실린수화물, - 내수용 및 수출용1 (아드목스캡슐),250.0,밀리그램,KP,...</td>\n",
       "      <td>HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>643301670</td>\n",
       "      <td>None</td>\n",
       "      <td>정상</td>\n",
       "      <td>I</td>\n",
       "      <td>첨가제주의</td>\n",
       "      <td>2018January1st</td>\n",
       "      <td>3128560679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>197500135</td>\n",
       "      <td>키목신캡슐250밀리그램(아목시실린수화물)</td>\n",
       "      <td>(주)유한양행</td>\n",
       "      <td>1975September8th</td>\n",
       "      <td>전문의약품</td>\n",
       "      <td>[618]주로 그람양성, 음성균에 작용하는 것</td>\n",
       "      <td>백색-담황색의 결정성 또는 과립상분말을 충진한 상부 암갈색 하부 미황색 캡슐제(수출...</td>\n",
       "      <td>8806421024036</td>\n",
       "      <td>아목시실린수화물, - 내수용,250,밀리그램,KP,역가/아목시실린수화물, - 수출용...</td>\n",
       "      <td>HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>500캡슐/병</td>\n",
       "      <td>642102400</td>\n",
       "      <td>None</td>\n",
       "      <td>정상</td>\n",
       "      <td>I</td>\n",
       "      <td>첨가제주의</td>\n",
       "      <td>2019April26th</td>\n",
       "      <td>1188100601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>197500144</td>\n",
       "      <td>제일아미노필린주사액</td>\n",
       "      <td>(주)제일제약</td>\n",
       "      <td>1975October29th</td>\n",
       "      <td>전문의약품</td>\n",
       "      <td>[211]강심제</td>\n",
       "      <td>무색 투명한 액이 든 갈색 투명한 앰플주사제</td>\n",
       "      <td>8806505004138</td>\n",
       "      <td>아미노필린수화물,,25,밀리그램,KP,</td>\n",
       "      <td>HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>10mL × 50앰플</td>\n",
       "      <td>650500411</td>\n",
       "      <td>None</td>\n",
       "      <td>정상</td>\n",
       "      <td>C</td>\n",
       "      <td>임부금기</td>\n",
       "      <td>2019September25th</td>\n",
       "      <td>5148126323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>197500145</td>\n",
       "      <td>제일덱사메타손주사액(덱사메타손포스페이트이나트륨)</td>\n",
       "      <td>(주)제일제약</td>\n",
       "      <td>1975October29th</td>\n",
       "      <td>전문의약품</td>\n",
       "      <td>[245]부신호르몬제</td>\n",
       "      <td>무색 투명한 액이 든 갈색 투명한 앰플주사제(수출용 : 무색 투명한 액이 든 무색 ...</td>\n",
       "      <td>8806505013925</td>\n",
       "      <td>덱사메타손포스페이트이나트륨,,5,밀리그램,USP,</td>\n",
       "      <td>HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1mL×50앰플, 4mL×50앰플</td>\n",
       "      <td>650501391</td>\n",
       "      <td>None</td>\n",
       "      <td>정상</td>\n",
       "      <td>C,I</td>\n",
       "      <td>임부금기,첨가제주의</td>\n",
       "      <td>2023January13th</td>\n",
       "      <td>5148126323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>197500146</td>\n",
       "      <td>제일티아민염산염주사액</td>\n",
       "      <td>(주)제일제약</td>\n",
       "      <td>1975October29th</td>\n",
       "      <td>전문의약품</td>\n",
       "      <td>[312]비타민 B1제</td>\n",
       "      <td>무색 투명한 액이 든 갈색 투명한 앰플주사제</td>\n",
       "      <td>8806505004725</td>\n",
       "      <td>티아민염산염,,25,밀리그램,KP,</td>\n",
       "      <td>HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2mLx50앰플</td>\n",
       "      <td>650500471</td>\n",
       "      <td>None</td>\n",
       "      <td>정상</td>\n",
       "      <td>I</td>\n",
       "      <td>첨가제주의</td>\n",
       "      <td>2008April10th</td>\n",
       "      <td>5148126323</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ITEM_SEQ                                  ITEM_NAME ENTP_NAME   \n",
       "0   195700013                             제일에페드린염산염주사액4%   (주)제일제약  \\\n",
       "1   195700015               안나카주사액20%(제일벤조산나트륨카페인주)(수출용)   (주)제일제약   \n",
       "2   195700016               안나카주사액10%(제일벤조산나트륨카페인주)(수출용)   (주)제일제약   \n",
       "3   195700020                                        활명수   동화약품(주)   \n",
       "4   195800018  대원염산에페드린주사액[수출명:에린주사(에페드린염산염)(ErineInj.)]   대원제약(주)   \n",
       "..        ...                                        ...       ...   \n",
       "95  197500015       아목사펜캡슐(아목시실린수화물)(수출명:아드목스캡슐,에프페닉스캡슐)    (주)종근당   \n",
       "96  197500135                     키목신캡슐250밀리그램(아목시실린수화물)   (주)유한양행   \n",
       "97  197500144                                 제일아미노필린주사액   (주)제일제약   \n",
       "98  197500145                 제일덱사메타손주사액(덱사메타손포스페이트이나트륨)   (주)제일제약   \n",
       "99  197500146                                제일티아민염산염주사액   (주)제일제약   \n",
       "\n",
       "    ITEM_PERMIT_DATE ETC_OTC_CODE                   CLASS_NO   \n",
       "0      1957April26th        전문의약품                 [222]진해거담제  \\\n",
       "1      1957April27th        전문의약품                   [211]강심제   \n",
       "2      1957April27th        전문의약품                   [211]강심제   \n",
       "3    1957January31st        일반의약품                 [233]건위소화제   \n",
       "4    1958December7th        전문의약품                 [222]진해거담제   \n",
       "..               ...          ...                        ...   \n",
       "95  1975September6th        전문의약품  [618]주로 그람양성, 음성균에 작용하는 것   \n",
       "96  1975September8th        전문의약품  [618]주로 그람양성, 음성균에 작용하는 것   \n",
       "97   1975October29th        전문의약품                   [211]강심제   \n",
       "98   1975October29th        전문의약품                [245]부신호르몬제   \n",
       "99   1975October29th        전문의약품               [312]비타민 B1제   \n",
       "\n",
       "                                                CHART       BAR_CODE   \n",
       "0                            무색 투명한 액이 든 갈색 투명한 앰플주사제  8806505004626  \\\n",
       "1                         무색~거의 투명한 액이 든 무색 투명한 앰플주사제  8806505002325   \n",
       "2                         무색~거의 투명한 액이 든 무색 투명한 앰플주사제  8806505002226   \n",
       "3                                      이약은 적갈색의 액제이다.  8806427038921   \n",
       "4               무색투명한 액이 든 갈색앰플제 수출용 : 무색투명한 액이 든 앰플제  8806718007339   \n",
       "..                                                ...            ...   \n",
       "95  내수용 및 수출용(아드목스캡슐) : 백색 내지 황백색의 결정 또는 결정성가루를 함유...  8806433016746   \n",
       "96  백색-담황색의 결정성 또는 과립상분말을 충진한 상부 암갈색 하부 미황색 캡슐제(수출...  8806421024036   \n",
       "97                           무색 투명한 액이 든 갈색 투명한 앰플주사제  8806505004138   \n",
       "98  무색 투명한 액이 든 갈색 투명한 앰플주사제(수출용 : 무색 투명한 액이 든 무색 ...  8806505013925   \n",
       "99                           무색 투명한 액이 든 갈색 투명한 앰플주사제  8806505004725   \n",
       "\n",
       "                                        MATERIAL_NAME   \n",
       "0                                에페드린염산염,,40,밀리그램,KP,  \\\n",
       "1                               벤조산나트륨카페인,,0.2,그램,KP,   \n",
       "2                               벤조산나트륨카페인,,0.1,그램,KP,   \n",
       "3   아선약, - 제1법 75mL,100.0,밀리그램,KP,/진피, - 제1법 75mL,...   \n",
       "4                                에페드린염산염,,40,밀리그램,KP,   \n",
       "..                                                ...   \n",
       "95  아목시실린수화물, - 내수용 및 수출용1 (아드목스캡슐),250.0,밀리그램,KP,...   \n",
       "96  아목시실린수화물, - 내수용,250,밀리그램,KP,역가/아목시실린수화물, - 수출용...   \n",
       "97                              아미노필린수화물,,25,밀리그램,KP,   \n",
       "98                        덱사메타손포스페이트이나트륨,,5,밀리그램,USP,   \n",
       "99                                티아민염산염,,25,밀리그램,KP,   \n",
       "\n",
       "                                            EE_DOC_ID  ... REEXAM_TARGET   \n",
       "0   HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...  ...          None  \\\n",
       "1   HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...  ...          None   \n",
       "2   HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...  ...          None   \n",
       "3   HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...  ...          None   \n",
       "4   HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...  ...          None   \n",
       "..                                                ...  ...           ...   \n",
       "95  HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...  ...          None   \n",
       "96  HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...  ...          None   \n",
       "97  HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...  ...          None   \n",
       "98  HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...  ...          None   \n",
       "99  HTTPS://NEDRUG.MFDS.GO.KR/PBP/CMN/PDFVIEWER/19...  ...          None   \n",
       "\n",
       "   REEXAM_DATE                             PACK_UNIT   EDI_CODE CANCEL_DATE   \n",
       "0         None                1mL × 10앰플, 1mL × 50앰플  650500461        None  \\\n",
       "1         None                  1mL, 2mL/앰플 × 자사포장단위       None        None   \n",
       "2         None                  1mL, 2mL/앰플 × 자사포장단위       None        None   \n",
       "3         None                       75mL/병, 450mL/병       None        None   \n",
       "4         None  내수용 : 1mL/앰플 X 50, 수출용 : 1mL/앰플 X 50  671800730        None   \n",
       "..         ...                                   ...        ...         ...   \n",
       "95        None                                  None  643301670        None   \n",
       "96        None                               500캡슐/병  642102400        None   \n",
       "97        None                           10mL × 50앰플  650500411        None   \n",
       "98        None                    1mL×50앰플, 4mL×50앰플  650501391        None   \n",
       "99        None                              2mLx50앰플  650500471        None   \n",
       "\n",
       "   CANCEL_NAME TYPE_CODE TYPE_NAME          CHANGE_DATE      BIZRNO  \n",
       "0           정상         C        임부금기       2018June14th  5148126323  \n",
       "1           정상         I       첨가제주의  2018September17th  5148126323  \n",
       "2           정상         I       첨가제주의  2018September17th  5148126323  \n",
       "3           정상         I       첨가제주의       2019June20th  1108100102  \n",
       "4           정상         C        임부금기   2015December17th  2078136336  \n",
       "..         ...       ...         ...                ...         ...  \n",
       "95          정상         I       첨가제주의     2018January1st  3128560679  \n",
       "96          정상         I       첨가제주의      2019April26th  1188100601  \n",
       "97          정상         C        임부금기  2019September25th  5148126323  \n",
       "98          정상       C,I  임부금기,첨가제주의    2023January13th  5148126323  \n",
       "99          정상         I       첨가제주의      2008April10th  5148126323  \n",
       "\n",
       "[100 rows x 25 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(data['body']['items'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n",
      "2\n",
      "3\n",
      "4\n",
      "5\n",
      "6\n",
      "7\n",
      "8\n",
      "9\n",
      "10\n",
      "11\n",
      "12\n",
      "13\n",
      "14\n",
      "15\n",
      "16\n",
      "17\n",
      "18\n",
      "19\n",
      "20\n",
      "21\n",
      "22\n",
      "23\n",
      "24\n",
      "25\n",
      "26\n",
      "27\n",
      "28\n",
      "29\n",
      "30\n",
      "31\n",
      "32\n",
      "33\n",
      "34\n",
      "35\n",
      "36\n",
      "37\n",
      "38\n",
      "39\n",
      "40\n",
      "41\n",
      "42\n",
      "43\n",
      "44\n",
      "45\n",
      "46\n",
      "47\n",
      "48\n",
      "49\n",
      "50\n",
      "51\n",
      "52\n",
      "53\n",
      "54\n",
      "55\n",
      "56\n",
      "57\n",
      "58\n",
      "59\n",
      "60\n",
      "61\n",
      "62\n",
      "63\n",
      "64\n",
      "65\n",
      "66\n",
      "67\n",
      "68\n",
      "69\n",
      "70\n",
      "71\n",
      "72\n",
      "73\n",
      "74\n",
      "75\n",
      "76\n",
      "77\n",
      "78\n",
      "79\n",
      "80\n",
      "81\n",
      "82\n",
      "83\n",
      "84\n",
      "85\n",
      "86\n",
      "87\n",
      "88\n",
      "89\n",
      "90\n",
      "91\n",
      "92\n",
      "93\n",
      "94\n",
      "95\n",
      "96\n",
      "97\n",
      "98\n",
      "99\n",
      "100\n",
      "101\n",
      "102\n",
      "103\n",
      "104\n",
      "105\n",
      "106\n",
      "107\n",
      "108\n",
      "109\n",
      "110\n",
      "111\n",
      "112\n",
      "113\n",
      "114\n",
      "115\n",
      "116\n",
      "117\n",
      "118\n",
      "119\n",
      "120\n",
      "121\n",
      "122\n",
      "123\n",
      "124\n",
      "125\n",
      "126\n",
      "127\n",
      "128\n",
      "129\n",
      "130\n",
      "131\n",
      "132\n",
      "133\n",
      "134\n",
      "135\n",
      "136\n",
      "137\n",
      "138\n",
      "139\n",
      "140\n",
      "141\n",
      "142\n",
      "143\n",
      "144\n",
      "145\n",
      "146\n",
      "147\n",
      "148\n",
      "149\n",
      "150\n",
      "151\n",
      "152\n",
      "153\n",
      "154\n",
      "155\n",
      "156\n",
      "157\n",
      "158\n",
      "159\n",
      "160\n",
      "161\n",
      "162\n",
      "163\n",
      "164\n",
      "165\n",
      "166\n",
      "167\n",
      "168\n",
      "169\n",
      "170\n",
      "171\n",
      "172\n",
      "173\n",
      "174\n",
      "175\n",
      "176\n",
      "177\n",
      "178\n",
      "179\n",
      "180\n",
      "181\n",
      "182\n",
      "183\n",
      "184\n",
      "185\n",
      "186\n",
      "187\n",
      "188\n",
      "189\n",
      "190\n",
      "191\n",
      "192\n",
      "193\n",
      "194\n",
      "195\n",
      "196\n",
      "197\n",
      "198\n",
      "199\n",
      "200\n",
      "201\n",
      "202\n",
      "203\n",
      "204\n",
      "205\n",
      "206\n",
      "207\n",
      "208\n",
      "209\n",
      "210\n",
      "211\n",
      "212\n",
      "213\n",
      "214\n",
      "215\n",
      "216\n",
      "217\n",
      "218\n",
      "219\n",
      "220\n",
      "221\n",
      "222\n",
      "223\n",
      "224\n",
      "225\n",
      "226\n",
      "227\n",
      "228\n",
      "229\n",
      "230\n",
      "231\n",
      "232\n",
      "233\n",
      "234\n",
      "235\n",
      "236\n",
      "237\n",
      "238\n",
      "239\n",
      "240\n",
      "241\n",
      "242\n",
      "243\n",
      "244\n",
      "245\n",
      "246\n",
      "247\n",
      "248\n",
      "249\n",
      "250\n",
      "251\n",
      "252\n",
      "253\n",
      "254\n",
      "255\n",
      "256\n",
      "257\n",
      "258\n",
      "259\n",
      "260\n",
      "261\n",
      "262\n",
      "263\n",
      "264\n"
     ]
    }
   ],
   "source": [
    "total_counts = 26387\n",
    "num_of_rows = 100 # maximum : 100\n",
    "Iter = total_counts // num_of_rows + 1\n",
    "Type = 'json'\n",
    "service_key = \"%2BttwG7y4NLRZVaNWJH7nc4Ef%2BbS3wzqC5XSditeU2rbv2xJs9mxI5RC%2FFqaTim4Eyiz2POD3t%2FGGg76DgR%2BvPg%3D%3D\"\n",
    "\n",
    "result = pd.DataFrame()\n",
    "\n",
    "for i in range(1,Iter+1):\n",
    "    print(i)\n",
    "    url = f\"https://apis.data.go.kr/1471000/DURPrdlstInfoService02/getDurPrdlstInfoList2?serviceKey={service_key}&pageNo={i}&numOfRows={num_of_rows}&type={Type}\"\n",
    "    response = requests.get(url)\n",
    "\n",
    "    if response.status_code == 200:\n",
    "        data = response.json()\n",
    "        df = pd.DataFrame(data[\"body\"][\"items\"])\n",
    "        result = pd.concat([result, df], axis=0)\n",
    "    else : \n",
    "        print(f\"{i}th page not loaded\")\n",
    "        continue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "result.reset_index(drop=True, inplace=True)\n",
    "result.to_csv(\"DUR_품목정보.csv\", index=False)"
   ]
  }
 ],
 "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.9.12"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}