icd_who_web_scrap.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "651fa80a",
   "metadata": {},
   "source": [
    "## International Statistical Classification of Diseases and Related Health Problems 10th Revision"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9bf91429",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "027fe4f1",
   "metadata": {},
   "outputs": [],
   "source": [
    "# url='https://icd.who.int/browse10/2019/en'\n",
    "# params ={'selectplane':'Cessna 208 Caravan',\n",
    "#         'submit':''}\n",
    "# response=requests.post(url, data=params)\n",
    "# soup = BeautifulSoup(response.text, 'html5lib')\n",
    "# print(soup)\n",
    "\n",
    "# import requests\n",
    "\n",
    "# chapter_url = 'https://icd.who.int/browse10/2016/en/JsonGetRootConcepts?useHtml=false'\n",
    "# chapters = requests.get(chapter_url).json()\n",
    "# chapter_IDS = [chapter['ID'] for chapter in chapters]\n",
    "\n",
    "# inner_section_names = []\n",
    "# section_url = 'https://icd.who.int/browse10/2016/en/JsonGetChildrenConcepts?ConceptId={}&useHtml=false'\n",
    "# for ID in chapter_IDS:\n",
    "#     sections = requests.get(section_url.format(ID)).json()\n",
    "#     section_IDS = [section['ID'] for section in sections]\n",
    "\n",
    "#     for inner_ID in section_IDS:\n",
    "#         inner_sections = requests.get(section_url.format(inner_ID)).json()\n",
    "#         temp = [inner_section['label'] for inner_section in inner_sections]\n",
    "#         inner_section_names.extend(temp)\n",
    "\n",
    "# print(inner_section_names)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "79ccb5c1",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "None\n",
      "/browse10/2019/en\n",
      "None\n",
      "/browse10/2016/en\n",
      "/browse10/2015/en\n",
      "/browse10/2014/en\n",
      "/browse10/2010/en\n",
      "/browse10/2008/en\n",
      "/browse10/2008/fr\n",
      "http://www.who.int/classifications/icd/icdonlineversions/en/index.html\n",
      "None\n",
      "/browse10/Help/en\n",
      "/browse10/Content/statichtml/ICD10Volume2_en_2019.pdf\n",
      "/browse10/Help/Get/diff-files/en\n",
      "https://www.who.int/standards/classifications/classification-of-diseases\n",
      "http://apps.who.int/classifications/apps/icd/icd10training\n"
     ]
    }
   ],
   "source": [
    "url = 'http://icd.who.int/browse10/2019/en'\n",
    "reqs = requests.get(url)\n",
    "soup = BeautifulSoup(reqs.text, 'html.parser')\n",
    " \n",
    "urls = []\n",
    "for link in soup.find_all('a'):\n",
    "    print(link.get('href'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "7163ea45",
   "metadata": {},
   "outputs": [],
   "source": [
    "chapter_url = 'https://icd.who.int/browse10/2019/en/JsonGetRootConcepts?useHtml=false'\n",
    "chapters = requests.get(chapter_url).json()\n",
    "chapter_IDS = [chapter['ID'] for chapter in chapters]\n",
    "\n",
    "missed=[]\n",
    "inner_section_names = []\n",
    "section_url = 'https://icd.who.int/browse10/2019/en/JsonGetChildrenConcepts?ConceptId={}&useHtml=false'\n",
    "print(chapter_IDS)\n",
    "for ID in chapter_IDS:\n",
    "    sections = requests.get(section_url.format(ID)).json()\n",
    "    section_IDS = [section['ID'] for section in sections]\n",
    "    print(section_IDS)\n",
    "    for inner_ID in section_IDS:\n",
    "        inner_sections = requests.get(section_url.format(inner_ID)).json()\n",
    "        for i in range(0,len(inner_sections)):\n",
    "            if(len(inner_sections[i][\"ID\"])>3):\n",
    "                print((inner_sections[i][\"ID\"]))\n",
    "            else:\n",
    "                temp = [inner_section['label'] for inner_section in inner_sections]\n",
    "                inner_section_names.extend(temp)\n",
    "        \n",
    "\n",
    "# print(inner_section_names)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "0fd479ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1660"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(inner_section_names)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "4b793adc",
   "metadata": {},
   "outputs": [],
   "source": [
    "lst=inner_section_names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "2096def1",
   "metadata": {},
   "outputs": [],
   "source": [
    "# lst\n",
    "a=lst"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "323873e7",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "def lsttotable(lst):\n",
    "    ids=[]\n",
    "    description=[]\n",
    "    for i in range(0,len(lst)):\n",
    "        x=\"\"\n",
    "        cnt=0\n",
    "        for j in range(0,len(lst[i])):\n",
    "            x+=lst[i][j]\n",
    "            if(lst[i][j]==\" \" and cnt<1):\n",
    "                cnt+=1\n",
    "                ids.append(x)\n",
    "                description.append(lst[i][j+1:])\n",
    "            else:\n",
    "                continue\n",
    "    print(len(ids),len(description))\n",
    "    return [ids,description]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "2ac42334",
   "metadata": {},
   "outputs": [],
   "source": [
    "icd=lsttotable(lst)\n",
    "len(icd)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "aad0f259",
   "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>Ids</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A00</td>\n",
       "      <td>Cholera</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A01</td>\n",
       "      <td>Typhoid and paratyphoid fevers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A02</td>\n",
       "      <td>Other salmonella infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A03</td>\n",
       "      <td>Shigellosis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A04</td>\n",
       "      <td>Other bacterial intestinal infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1655</th>\n",
       "      <td>U49</td>\n",
       "      <td>Emergency use of U49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1656</th>\n",
       "      <td>U82</td>\n",
       "      <td>Resistance to betalactam antibiotics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1657</th>\n",
       "      <td>U83</td>\n",
       "      <td>Resistance to other antibiotics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1658</th>\n",
       "      <td>U84</td>\n",
       "      <td>Resistance to other antimicrobial drugs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659</th>\n",
       "      <td>U85</td>\n",
       "      <td>Resistance to antineoplastic drugs</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1660 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Ids                              Description\n",
       "0     A00                                   Cholera\n",
       "1     A01            Typhoid and paratyphoid fevers\n",
       "2     A02               Other salmonella infections\n",
       "3     A03                               Shigellosis\n",
       "4     A04     Other bacterial intestinal infections\n",
       "...    ...                                      ...\n",
       "1655  U49                      Emergency use of U49\n",
       "1656  U82      Resistance to betalactam antibiotics\n",
       "1657  U83           Resistance to other antibiotics\n",
       "1658  U84   Resistance to other antimicrobial drugs\n",
       "1659  U85        Resistance to antineoplastic drugs\n",
       "\n",
       "[1660 rows x 2 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "icdd = [icd[0], icd[1]] \n",
    "df = pd.DataFrame(list(zip(icd[0], icd[1])),columns =['Ids', 'Description'])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "a148dec2",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"icd_10_2019.csv\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "3ffb545a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"icd_10_2019.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "283720b6",
   "metadata": {},
   "outputs": [],
   "source": [
    "# df[df.Ids == \"A00\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "487a490b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "180aff51",
   "metadata": {},
   "outputs": [],
   "source": [
    "missed=[\"C00-C75\",\n",
    "\"C76-C80\",\n",
    "\"C81-C96\",\n",
    "\"C97-C97\",\n",
    "\"M00-M03\",\n",
    "\"M05-M14\",\n",
    "\"M15-M19\",\n",
    "\"M20-M25\",\n",
    "\"M40-M43\",\n",
    "\"M45-M49\",\n",
    "\"M50-M54\",\n",
    "\"M60-M63\",\n",
    "\"M65-M68\",\n",
    "\"M70-M79\",\n",
    "\"M80-M85\",\n",
    "\"M86-M90\",\n",
    "\"M91-M94\",\n",
    "\"T20-T25\",\n",
    "\"T26-T28\",\n",
    "\"T29-T32\",\n",
    "\"V01-V99\",\n",
    "\"W00-X59\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "5a9ab0a9",
   "metadata": {},
   "outputs": [],
   "source": [
    "cx=missed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "781db643",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['C00-C14 Malignant neoplasms of lip, oral cavity and pharynx', 'C15-C26 Malignant neoplasms of digestive organs', 'C30-C39 Malignant neoplasms of respiratory and intrathoracic organs', 'C40-C41 Malignant neoplasms of bone and articular cartilage', 'C43-C44 Melanoma and other malignant neoplasms of skin', 'C45-C49 Malignant neoplasms of mesothelial and soft tissue', 'C50-C50 Malignant neoplasm of breast', 'C51-C58 Malignant neoplasms of female genital organs', 'C60-C63 Malignant neoplasms of male genital organs', 'C64-C68 Malignant neoplasms of urinary tract', 'C69-C72 Malignant neoplasms of eye, brain and other parts of central nervous system', 'C73-C75 Malignant neoplasms of thyroid and other endocrine glands']\n",
      "['C76 Malignant neoplasm of other and ill-defined sites', 'C77 Secondary and unspecified malignant neoplasm of lymph nodes', 'C78 Secondary malignant neoplasm of respiratory and digestive organs', 'C79 Secondary malignant neoplasm of other and unspecified sites', 'C80 Malignant neoplasm, without specification of site']\n",
      "['C81 Hodgkin lymphoma', 'C82 Follicular lymphoma', 'C83 Non-follicular lymphoma', 'C84 Mature T/NK-cell lymphomas', 'C85 Other and unspecified types of non-Hodgkin lymphoma', 'C86 Other specified types of T/NK-cell lymphoma', 'C88 Malignant immunoproliferative diseases', 'C90 Multiple myeloma and malignant plasma cell neoplasms', 'C91 Lymphoid leukaemia', 'C92 Myeloid leukaemia', 'C93 Monocytic leukaemia', 'C94 Other leukaemias of specified cell type', 'C95 Leukaemia of unspecified cell type', 'C96 Other and unspecified malignant neoplasms of lymphoid, haematopoietic and related tissue']\n",
      "['C97 Malignant neoplasms of independent (primary) multiple sites']\n",
      "['M00 Pyogenic arthritis', 'M01 Direct infections of joint in infectious and parasitic diseases classified elsewhere', 'M02 Reactive arthropathies', 'M03 Postinfective and reactive arthropathies in diseases classified elsewhere']\n",
      "['M05 Seropositive rheumatoid arthritis', 'M06 Other rheumatoid arthritis', 'M07 Psoriatic and enteropathic arthropathies', 'M08 Juvenile arthritis', 'M09 Juvenile arthritis in diseases classified elsewhere', 'M10 Gout', 'M11 Other crystal arthropathies', 'M12 Other specific arthropathies', 'M13 Other arthritis', 'M14 Arthropathies in other diseases classified elsewhere']\n",
      "['M15 Polyarthrosis', 'M16 Coxarthrosis [arthrosis of hip]', 'M17 Gonarthrosis [arthrosis of knee]', 'M18 Arthrosis of first carpometacarpal joint', 'M19 Other arthrosis']\n",
      "['M20 Acquired deformities of fingers and toes', 'M21 Other acquired deformities of limbs', 'M22 Disorders of patella', 'M23 Internal derangement of knee', 'M24 Other specific joint derangements', 'M25 Other joint disorders, not elsewhere classified']\n",
      "['M40 Kyphosis and lordosis', 'M41 Scoliosis', 'M42 Spinal osteochondrosis', 'M43 Other deforming dorsopathies']\n",
      "['M45 Ankylosing spondylitis', 'M46 Other inflammatory spondylopathies', 'M47 Spondylosis', 'M48 Other spondylopathies', 'M49 Spondylopathies in diseases classified elsewhere']\n",
      "['M50 Cervical disc disorders', 'M51 Other intervertebral disc disorders', 'M53 Other dorsopathies, not elsewhere classified', 'M54 Dorsalgia']\n",
      "['M60 Myositis', 'M61 Calcification and ossification of muscle', 'M62 Other disorders of muscle', 'M63 Disorders of muscle in diseases classified elsewhere']\n",
      "['M65 Synovitis and tenosynovitis', 'M66 Spontaneous rupture of synovium and tendon', 'M67 Other disorders of synovium and tendon', 'M68 Disorders of synovium and tendon in diseases classified elsewhere']\n",
      "['M70 Soft tissue disorders related to use, overuse and pressure', 'M71 Other bursopathies', 'M72 Fibroblastic disorders', 'M73 Soft tissue disorders in diseases classified elsewhere', 'M75 Shoulder lesions', 'M76 Enthesopathies of lower limb, excluding foot', 'M77 Other enthesopathies', 'M79 Other soft tissue disorders, not elsewhere classified']\n",
      "['M80 Osteoporosis with pathological fracture', 'M81 Osteoporosis without pathological fracture', 'M82 Osteoporosis in diseases classified elsewhere', 'M83 Adult osteomalacia', 'M84 Disorders of continuity of bone', 'M85 Other disorders of bone density and structure']\n",
      "['M86 Osteomyelitis', 'M87 Osteonecrosis', 'M88 Paget disease of bone [osteitis deformans]', 'M89 Other disorders of bone', 'M90 Osteopathies in diseases classified elsewhere']\n",
      "['M91 Juvenile osteochondrosis of hip and pelvis', 'M92 Other juvenile osteochondrosis', 'M93 Other osteochondropathies', 'M94 Other disorders of cartilage']\n",
      "['T20 Burn and corrosion of head and neck', 'T21 Burn and corrosion of trunk', 'T22 Burn and corrosion of shoulder and upper limb, except wrist and hand', 'T23 Burn and corrosion of wrist and hand', 'T24 Burn and corrosion of hip and lower limb, except ankle and foot', 'T25 Burn and corrosion of ankle and foot']\n",
      "['T26 Burn and corrosion confined to eye and adnexa', 'T27 Burn and corrosion of respiratory tract', 'T28 Burn and corrosion of other internal organs']\n",
      "['T29 Burns and corrosions of multiple body regions', 'T30 Burn and corrosion, body region unspecified', 'T31 Burns classified according to extent of body surface involved', 'T32 Corrosions classified according to extent of body surface involved']\n",
      "['V01-V09 Pedestrian injured in transport accident', 'V10-V19 Pedal cyclist injured in transport accident', 'V20-V29 Motorcycle rider injured in transport accident', 'V30-V39 Occupant of three-wheeled motor vehicle injured in transport accident', 'V40-V49 Car occupant injured in transport accident', 'V50-V59 Occupant of pick-up truck or van injured in transport accident', 'V60-V69 Occupant of heavy transport vehicle injured in transport accident', 'V70-V79 Bus occupant injured in transport accident', 'V80-V89 Other land transport accidents', 'V90-V94 Water transport accidents', 'V95-V97 Air and space transport accidents', 'V98-V99 Other and unspecified transport accidents']\n",
      "['W00-W19 Falls', 'W20-W49 Exposure to inanimate mechanical forces', 'W50-W64 Exposure to animate mechanical forces', 'W65-W74 Accidental drowning and submersion', 'W75-W84 Other accidental threats to breathing', 'W85-W99 Exposure to electric current, radiation and extreme ambient air temperature and pressure', 'X00-X09 Exposure to smoke, fire and flames', 'X10-X19 Contact with heat and hot substances', 'X20-X29 Contact with venomous animals and plants', 'X30-X39 Exposure to forces of nature', 'X40-X49 Accidental poisoning by and exposure to noxious substances', 'X50-X57 Overexertion, travel and privation', 'X58-X59 Accidental exposure to other and unspecified factors']\n"
     ]
    }
   ],
   "source": [
    "inner_section_names2=[]\n",
    "for inner_ID in cx:\n",
    "        inner_sections = requests.get(section_url.format(inner_ID)).json()\n",
    "        temp = [inner_section['label'] for inner_section in inner_sections]\n",
    "        print(temp)\n",
    "        inner_section_names2.extend(temp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "d1758cee",
   "metadata": {},
   "outputs": [],
   "source": [
    "lst1=inner_section_names2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c485f008",
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'lsttotable' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "Input \u001b[0;32mIn [2]\u001b[0m, in \u001b[0;36m<cell line: 1>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0m second2\u001b[38;5;241m=\u001b[39m\u001b[43mlsttotable\u001b[49m(lst1)\n",
      "\u001b[0;31mNameError\u001b[0m: name 'lsttotable' is not defined"
     ]
    }
   ],
   "source": [
    "second2=lsttotable(lst1)\n",
    "# second2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "30bdb975",
   "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>Ids</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>C00-C14</td>\n",
       "      <td>Malignant neoplasms of lip, oral cavity and ph...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>C15-C26</td>\n",
       "      <td>Malignant neoplasms of digestive organs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>C30-C39</td>\n",
       "      <td>Malignant neoplasms of respiratory and intrath...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>C40-C41</td>\n",
       "      <td>Malignant neoplasms of bone and articular cart...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>C43-C44</td>\n",
       "      <td>Melanoma and other malignant neoplasms of skin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>X20-X29</td>\n",
       "      <td>Contact with venomous animals and plants</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>X30-X39</td>\n",
       "      <td>Exposure to forces of nature</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>X40-X49</td>\n",
       "      <td>Accidental poisoning by and exposure to noxiou...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>X50-X57</td>\n",
       "      <td>Overexertion, travel and privation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>X58-X59</td>\n",
       "      <td>Accidental exposure to other and unspecified f...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>139 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Ids                                        Description\n",
       "0    C00-C14   Malignant neoplasms of lip, oral cavity and ph...\n",
       "1    C15-C26             Malignant neoplasms of digestive organs\n",
       "2    C30-C39   Malignant neoplasms of respiratory and intrath...\n",
       "3    C40-C41   Malignant neoplasms of bone and articular cart...\n",
       "4    C43-C44      Melanoma and other malignant neoplasms of skin\n",
       "..        ...                                                ...\n",
       "134  X20-X29            Contact with venomous animals and plants\n",
       "135  X30-X39                        Exposure to forces of nature\n",
       "136  X40-X49   Accidental poisoning by and exposure to noxiou...\n",
       "137  X50-X57                  Overexertion, travel and privation\n",
       "138  X58-X59   Accidental exposure to other and unspecified f...\n",
       "\n",
       "[139 rows x 2 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second = [second2[0], second2[1]] \n",
    "df1 = pd.DataFrame(list(zip(second2[0], second2[1])),columns =['Ids', 'Description'])\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "01739554",
   "metadata": {},
   "outputs": [],
   "source": [
    "srt=['C00-C14','C15-C26','C30-C39',\n",
    "  'C40-C41',\n",
    "  'C43-C44',\n",
    "  'C45-C49',\n",
    "  'C50-C50',\n",
    "  'C51-C58',\n",
    "  'C60-C63',\n",
    "  'C64-C68',\n",
    "  'C69-C72',\n",
    "  'C73-C75',\n",
    "     'V01-V09',\n",
    "  'V10-V19',\n",
    "  'V20-V29',\n",
    "  'V30-V39',\n",
    "  'V40-V49',\n",
    "  'V50-V59',\n",
    "  'V60-V69',\n",
    "  'V70-V79',\n",
    "  'V80-V89',\n",
    "  'V90-V94',\n",
    "  'V95-V97',\n",
    "  'V98-V99',\n",
    "  'W00-W19',\n",
    "  'W20-W49',\n",
    "  'W50-W64',\n",
    "  'W65-W74',\n",
    "  'W75-W84',\n",
    "  'W85-W99',\n",
    "  'X00-X09',\n",
    "  'X10-X19',\n",
    "  'X20-X29',\n",
    "  'X30-X39',\n",
    "  'X40-X49',\n",
    "  'X50-X57',\n",
    "  'X58-X59']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "356285b7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['C00-C14',\n",
       " 'C15-C26',\n",
       " 'C30-C39',\n",
       " 'C40-C41',\n",
       " 'C43-C44',\n",
       " 'C45-C49',\n",
       " 'C50-C50',\n",
       " 'C51-C58',\n",
       " 'C60-C63',\n",
       " 'C64-C68',\n",
       " 'C69-C72',\n",
       " 'C73-C75',\n",
       " 'V01-V09',\n",
       " 'V10-V19',\n",
       " 'V20-V29',\n",
       " 'V30-V39',\n",
       " 'V40-V49',\n",
       " 'V50-V59',\n",
       " 'V60-V69',\n",
       " 'V70-V79',\n",
       " 'V80-V89',\n",
       " 'V90-V94',\n",
       " 'V95-V97',\n",
       " 'V98-V99',\n",
       " 'W00-W19',\n",
       " 'W20-W49',\n",
       " 'W50-W64',\n",
       " 'W65-W74',\n",
       " 'W75-W84',\n",
       " 'W85-W99',\n",
       " 'X00-X09',\n",
       " 'X10-X19',\n",
       " 'X20-X29',\n",
       " 'X30-X39',\n",
       " 'X40-X49',\n",
       " 'X50-X57',\n",
       " 'X58-X59']"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# srt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "e0bf1066",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['C00 Malignant neoplasm of lip', 'C01 Malignant neoplasm of base of tongue', 'C02 Malignant neoplasm of other and unspecified parts of tongue', 'C03 Malignant neoplasm of gum', 'C04 Malignant neoplasm of floor of mouth', 'C05 Malignant neoplasm of palate', 'C06 Malignant neoplasm of other and unspecified parts of mouth', 'C07 Malignant neoplasm of parotid gland', 'C08 Malignant neoplasm of other and unspecified major salivary glands', 'C09 Malignant neoplasm of tonsil', 'C10 Malignant neoplasm of oropharynx', 'C11 Malignant neoplasm of nasopharynx', 'C12 Malignant neoplasm of piriform sinus', 'C13 Malignant neoplasm of hypopharynx', 'C14 Malignant neoplasm of other and ill-defined sites in the lip, oral cavity and pharynx']\n",
      "['C15 Malignant neoplasm of oesophagus', 'C16 Malignant neoplasm of stomach', 'C17 Malignant neoplasm of small intestine', 'C18 Malignant neoplasm of colon', 'C19 Malignant neoplasm of rectosigmoid junction', 'C20 Malignant neoplasm of rectum', 'C21 Malignant neoplasm of anus and anal canal', 'C22 Malignant neoplasm of liver and intrahepatic bile ducts', 'C23 Malignant neoplasm of gallbladder', 'C24 Malignant neoplasm of other and unspecified parts of biliary tract', 'C25 Malignant neoplasm of pancreas', 'C26 Malignant neoplasm of other and ill-defined digestive organs']\n",
      "['C30 Malignant neoplasm of nasal cavity and middle ear', 'C31 Malignant neoplasm of accessory sinuses', 'C32 Malignant neoplasm of larynx', 'C33 Malignant neoplasm of trachea', 'C34 Malignant neoplasm of bronchus and lung', 'C37 Malignant neoplasm of thymus', 'C38 Malignant neoplasm of heart, mediastinum and pleura', 'C39 Malignant neoplasm of other and ill-defined sites in the respiratory system and intrathoracic organs']\n",
      "['C40 Malignant neoplasm of bone and articular cartilage of limbs', 'C41 Malignant neoplasm of bone and articular cartilage of other and unspecified sites']\n",
      "['C43 Malignant melanoma of skin', 'C44 Other malignant neoplasms of skin']\n",
      "['C45 Mesothelioma', 'C46 Kaposi sarcoma', 'C47 Malignant neoplasm of peripheral nerves and autonomic nervous system', 'C48 Malignant neoplasm of retroperitoneum and peritoneum', 'C49 Malignant neoplasm of other connective and soft tissue']\n",
      "['C50 Malignant neoplasm of breast']\n",
      "['C51 Malignant neoplasm of vulva', 'C52 Malignant neoplasm of vagina', 'C53 Malignant neoplasm of cervix uteri', 'C54 Malignant neoplasm of corpus uteri', 'C55 Malignant neoplasm of uterus, part unspecified', 'C56 Malignant neoplasm of ovary', 'C57 Malignant neoplasm of other and unspecified female genital organs', 'C58 Malignant neoplasm of placenta']\n",
      "['C60 Malignant neoplasm of penis', 'C61 Malignant neoplasm of prostate', 'C62 Malignant neoplasm of testis', 'C63 Malignant neoplasm of other and unspecified male genital organs']\n",
      "['C64 Malignant neoplasm of kidney, except renal pelvis', 'C65 Malignant neoplasm of renal pelvis', 'C66 Malignant neoplasm of ureter', 'C67 Malignant neoplasm of bladder', 'C68 Malignant neoplasm of other and unspecified urinary organs']\n",
      "['C69 Malignant neoplasm of eye and adnexa', 'C70 Malignant neoplasm of meninges', 'C71 Malignant neoplasm of brain', 'C72 Malignant neoplasm of spinal cord, cranial nerves and other parts of central nervous system']\n",
      "['C73 Malignant neoplasm of thyroid gland', 'C74 Malignant neoplasm of adrenal gland', 'C75 Malignant neoplasm of other endocrine glands and related structures']\n",
      "['V01 Pedestrian injured in collision with pedal cycle', 'V02 Pedestrian injured in collision with two- or three-wheeled motor vehicle', 'V03 Pedestrian injured in collision with car, pick-up truck or van', 'V04 Pedestrian injured in collision with heavy transport vehicle or bus', 'V05 Pedestrian injured in collision with railway train or railway vehicle', 'V06 Pedestrian injured in collision with other nonmotor vehicle', 'V09 Pedestrian injured in other and unspecified transport accidents']\n",
      "['V10 Pedal cyclist injured in collision with pedestrian or animal', 'V11 Pedal cyclist injured in collision with other pedal cycle', 'V12 Pedal cyclist injured in collision with two- or three-wheeled motor vehicle', 'V13 Pedal cyclist injured in collision with car, pick-up truck or van', 'V14 Pedal cyclist injured in collision with heavy transport vehicle or bus', 'V15 Pedal cyclist injured in collision with railway train or railway vehicle', 'V16 Pedal cyclist injured in collision with other nonmotor vehicle', 'V17 Pedal cyclist injured in collision with fixed or stationary object', 'V18 Pedal cyclist injured in noncollision transport accident', 'V19 Pedal cyclist injured in other and unspecified transport accidents']\n",
      "['V20 Motorcycle rider injured in collision with pedestrian or animal', 'V21 Motorcycle rider injured in collision with pedal cycle', 'V22 Motorcycle rider injured in collision with two- or three-wheeled motor vehicle', 'V23 Motorcycle rider injured in collision with car, pick-up truck or van', 'V24 Motorcycle rider injured in collision with heavy transport vehicle or bus', 'V25 Motorcycle rider injured in collision with railway train or railway vehicle', 'V26 Motorcycle rider injured in collision with other nonmotor vehicle', 'V27 Motorcycle rider injured in collision with fixed or stationary object', 'V28 Motorcycle rider injured in noncollision transport accident', 'V29 Motorcycle rider injured in other and unspecified transport accidents']\n",
      "['V30 Occupant of three-wheeled motor vehicle injured in collision with pedestrian or animal', 'V31 Occupant of three-wheeled motor vehicle injured in collision with pedal cycle', 'V32 Occupant of three-wheeled motor vehicle injured in collision with two- or three-wheeled motor vehicle', 'V33 Occupant of three-wheeled motor vehicle injured in collision with car, pick-up truck or van', 'V34 Occupant of three-wheeled motor vehicle injured in collision with heavy transport vehicle or bus', 'V35 Occupant of three-wheeled motor vehicle injured in collision with railway train or railway vehicle', 'V36 Occupant of three-wheeled motor vehicle injured in collision with other nonmotor vehicle', 'V37 Occupant of three-wheeled motor vehicle injured in collision with fixed or stationary object', 'V38 Occupant of three-wheeled motor vehicle injured in noncollision transport accident', 'V39 Occupant of three-wheeled motor vehicle injured in other and unspecified transport accidents']\n",
      "['V40 Car occupant injured in collision with pedestrian or animal', 'V41 Car occupant injured in collision with pedal cycle', 'V42 Car occupant injured in collision with two- or three-wheeled motor vehicle', 'V43 Car occupant injured in collision with car, pick-up truck or van', 'V44 Car occupant injured in collision with heavy transport vehicle or bus', 'V45 Car occupant injured in collision with railway train or railway vehicle', 'V46 Car occupant injured in collision with other nonmotor vehicle', 'V47 Car occupant injured in collision with fixed or stationary object', 'V48 Car occupant injured in noncollision transport accident', 'V49 Car occupant injured in other and unspecified transport accidents']\n",
      "['V50 Occupant of pick-up truck or van injured in collision with pedestrian or animal', 'V51 Occupant of pick-up truck or van injured in collision with pedal cycle', 'V52 Occupant of pick-up truck or van injured in collision with two- or three-wheeled motor vehicle', 'V53 Occupant of pick-up truck or van injured in collision with car, pick-up truck or van', 'V54 Occupant of pick-up truck or van injured in collision with heavy transport vehicle or bus', 'V55 Occupant of pick-up truck or van injured in collision with railway train or railway vehicle', 'V56 Occupant of pick-up truck or van injured in collision with other nonmotor vehicle', 'V57 Occupant of pick-up truck or van injured in collision with fixed or stationary object', 'V58 Occupant of pick-up truck or van injured in noncollision transport accident', 'V59 Occupant of pick-up truck or van injured in other and unspecified transport accidents']\n",
      "['V60 Occupant of heavy transport vehicle injured in collision with pedestrian or animal', 'V61 Occupant of heavy transport vehicle injured in collision with pedal cycle', 'V62 Occupant of heavy transport vehicle injured in collision with two- or three-wheeled motor vehicle', 'V63 Occupant of heavy transport vehicle injured in collision with car, pick-up truck or van', 'V64 Occupant of heavy transport vehicle injured in collision with heavy transport vehicle or bus', 'V65 Occupant of heavy transport vehicle injured in collision with railway train or railway vehicle', 'V66 Occupant of heavy transport vehicle injured in collision with other nonmotor vehicle', 'V67 Occupant of heavy transport vehicle injured in collision with fixed or stationary object', 'V68 Occupant of heavy transport vehicle injured in noncollision transport accident', 'V69 Occupant of heavy transport vehicle injured in other and unspecified transport accidents']\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['V70 Bus occupant injured in collision with pedestrian or animal', 'V71 Bus occupant injured in collision with pedal cycle', 'V72 Bus occupant injured in collision with two- or three-wheeled motor vehicle', 'V73 Bus occupant injured in collision with car, pick-up truck or van', 'V74 Bus occupant injured in collision with heavy transport vehicle or bus', 'V75 Bus occupant injured in collision with railway train or railway vehicle', 'V76 Bus occupant injured in collision with other nonmotor vehicle', 'V77 Bus occupant injured in collision with fixed or stationary object', 'V78 Bus occupant injured in noncollision transport accident', 'V79 Bus occupant injured in other and unspecified transport accidents']\n",
      "['V80 Animal-rider or occupant of animal-drawn vehicle injured in transport accident', 'V81 Occupant of railway train or railway vehicle injured in transport accident', 'V82 Occupant of streetcar injured in transport accident', 'V83 Occupant of special vehicle mainly used on industrial premises injured in transport accident', 'V84 Occupant of special vehicle mainly used in agriculture injured in transport accident', 'V85 Occupant of special construction vehicle injured in transport accident', 'V86 Occupant of special all-terrain or other motor vehicle designed primarily for off-road use, injured in transport accident', \"V87 Traffic accident of specified type but victim's mode of transport unknown\", \"V88 Nontraffic accident of specified type but victim's mode of transport unknown\", 'V89 Motor- or nonmotor-vehicle accident, type of vehicle unspecified']\n",
      "['V90 Accident to watercraft causing drowning and submersion', 'V91 Accident to watercraft causing other injury', 'V92 Water-transport-related drowning and submersion without accident to watercraft', 'V93 Accident on board watercraft without accident to watercraft, not causing drowning and submersion', 'V94 Other and unspecified water transport accidents']\n",
      "['V95 Accident to powered aircraft causing injury to occupant', 'V96 Accident to nonpowered aircraft causing injury to occupant', 'V97 Other specified air transport accidents']\n",
      "['V98 Other specified transport accidents', 'V99 Unspecified transport accident']\n",
      "['W00 Fall on same level involving ice and snow', 'W01 Fall on same level from slipping, tripping and stumbling', 'W02 Fall involving ice-skates, skis, roller-skates or skateboards', 'W03 Other fall on same level due to collision with, or pushing by, another person', 'W04 Fall while being carried or supported by other persons', 'W05 Fall involving wheelchair', 'W06 Fall involving bed', 'W07 Fall involving chair', 'W08 Fall involving other furniture', 'W09 Fall involving playground equipment', 'W10 Fall on and from stairs and steps', 'W11 Fall on and from ladder', 'W12 Fall on and from scaffolding', 'W13 Fall from, out of or through building or structure', 'W14 Fall from tree', 'W15 Fall from cliff', 'W16 Diving or jumping into water causing injury other than drowning or submersion', 'W17 Other fall from one level to another', 'W18 Other fall on same level', 'W19 Unspecified fall']\n",
      "['W20 Struck by thrown, projected or falling object(s)', 'W21 Striking against or struck by sports equipment', 'W22 Striking against or struck by other object(s)', 'W23 Caught, crushed, jammed or pinched in or between objects', 'W24 Contact with lifting and transmission device(s), not elsewhere classified', 'W25 Contact with sharp glass', 'W26 Contact with other sharp object(s)', 'W27 Contact with nonpowered hand tool', 'W28 Contact with powered lawnmower', 'W29 Contact with other powered hand tools and household machinery', 'W30 Contact with agricultural machinery', 'W31 Contact with other and unspecified machinery', 'W32 Handgun discharge', 'W33 Rifle, shotgun and larger firearm discharge', 'W34 Discharge from other and unspecified firearms', 'W35 Explosion and rupture of boiler', 'W36 Explosion and rupture of gas cylinder', 'W37 Explosion and rupture of pressurized tyre, pipe or hose', 'W38 Explosion and rupture of other specified pressurized devices', 'W39 Discharge of firework', 'W40 Explosion of other materials', 'W41 Exposure to high-pressure jet', 'W42 Exposure to noise', 'W43 Exposure to vibration', 'W44 Foreign body entering into or through eye or natural orifice', 'W45 Foreign body or object entering through skin', 'W46 Contact with hypodermic needle', 'W49 Exposure to other and unspecified inanimate mechanical forces']\n",
      "['W50 Hit, struck, kicked, twisted, bitten or scratched by another person', 'W51 Striking against or bumped into by another person', 'W52 Crushed, pushed or stepped on by crowd or human stampede', 'W53 Bitten by rat', 'W54 Bitten or struck by dog', 'W55 Bitten or struck by other mammals', 'W56 Contact with marine animal', 'W57 Bitten or stung by nonvenomous insect and other nonvenomous arthropods', 'W58 Bitten or struck by crocodile or alligator', 'W59 Bitten or crushed by other reptiles', 'W60 Contact with plant thorns and spines and sharp leaves', 'W64 Exposure to other and unspecified animate mechanical forces']\n",
      "['W65 Drowning and submersion while in bath-tub', 'W66 Drowning and submersion following fall into bath-tub', 'W67 Drowning and submersion while in swimming-pool', 'W68 Drowning and submersion following fall into swimming-pool', 'W69 Drowning and submersion while in natural water', 'W70 Drowning and submersion following fall into natural water', 'W73 Other specified drowning and submersion', 'W74 Unspecified drowning and submersion']\n",
      "['W75 Accidental suffocation and strangulation in bed', 'W76 Other accidental hanging and strangulation', 'W77 Threat to breathing due to cave-in, falling earth and other substances', 'W78 Inhalation of gastric contents', 'W79 Inhalation and ingestion of food causing obstruction of respiratory tract', 'W80 Inhalation and ingestion of other objects causing obstruction of respiratory tract', 'W81 Confined to or trapped in a low-oxygen environment', 'W83 Other specified threats to breathing', 'W84 Unspecified threat to breathing']\n",
      "['W85 Exposure to electric transmission lines', 'W86 Exposure to other specified electric current', 'W87 Exposure to unspecified electric current', 'W88 Exposure to ionizing radiation', 'W89 Exposure to man-made visible and ultraviolet light', 'W90 Exposure to other nonionizing radiation', 'W91 Exposure to unspecified type of radiation', 'W92 Exposure to excessive heat of man-made origin', 'W93 Exposure to excessive cold of man-made origin', 'W94 Exposure to high and low air pressure and changes in air pressure', 'W99 Exposure to other and unspecified man-made environmental factors']\n",
      "['X00 Exposure to uncontrolled fire in building or structure', 'X01 Exposure to uncontrolled fire, not in building or structure', 'X02 Exposure to controlled fire in building or structure', 'X03 Exposure to controlled fire, not in building or structure', 'X04 Exposure to ignition of highly flammable material', 'X05 Exposure to ignition or melting of nightwear', 'X06 Exposure to ignition or melting of other clothing and apparel', 'X08 Exposure to other specified smoke, fire and flames', 'X09 Exposure to unspecified smoke, fire and flames']\n",
      "['X10 Contact with hot drinks, food, fats and cooking oils', 'X11 Contact with hot tap-water', 'X12 Contact with other hot fluids', 'X13 Contact with steam and hot vapours', 'X14 Contact with hot air and gases', 'X15 Contact with hot household appliances', 'X16 Contact with hot heating appliances, radiators and pipes', 'X17 Contact with hot engines, machinery and tools', 'X18 Contact with other hot metals', 'X19 Contact with other and unspecified heat and hot substances']\n",
      "['X20 Contact with venomous snakes and lizards', 'X21 Contact with venomous spiders', 'X22 Contact with scorpions', 'X23 Contact with hornets, wasps and bees', 'X24 Contact with centipedes and venomous millipedes (tropical)', 'X25 Contact with other venomous arthropods', 'X26 Contact with venomous marine animals and plants', 'X27 Contact with other specified venomous animals', 'X28 Contact with other specified venomous plants', 'X29 Contact with unspecified venomous animal or plant']\n",
      "['X30 Exposure to excessive natural heat', 'X31 Exposure to excessive natural cold', 'X32 Exposure to sunlight', 'X33 Victim of lightning', 'X34 Victim of earthquake', 'X35 Victim of volcanic eruption', 'X36 Victim of avalanche, landslide and other earth movements', 'X37 Victim of cataclysmic storm', 'X38 Victim of flood', 'X39 Exposure to other and unspecified forces of nature']\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['X40 Accidental poisoning by and exposure to nonopioid analgesics, antipyretics and antirheumatics', 'X41 Accidental poisoning by and exposure to antiepileptic, sedative-hypnotic, antiparkinsonism and psychotropic drugs, not elsewhere classified', 'X42 Accidental poisoning by and exposure to narcotics and psychodysleptics [hallucinogens], not elsewhere classified', 'X43 Accidental poisoning by and exposure to other drugs acting on the autonomic nervous system', 'X44 Accidental poisoning by and exposure to other and unspecified drugs, medicaments and biological substances', 'X45 Accidental poisoning by and exposure to alcohol', 'X46 Accidental poisoning by and exposure to organic solvents and halogenated hydrocarbons and their vapours', 'X47 Accidental poisoning by and exposure to carbon monoxide and other gases and vapours', 'X48 Accidental poisoning by and exposure to pesticides', 'X49 Accidental poisoning by and exposure to other and unspecified chemicals and noxious substances']\n",
      "['X50 Overexertion and strenuous or repetitive movements', 'X51 Travel and motion', 'X52 Prolonged stay in weightless environment', 'X53 Lack of food', 'X54 Lack of water', 'X57 Unspecified privation']\n",
      "['X58 Exposure to other specified factors', 'X59 Exposure to unspecified factor']\n"
     ]
    }
   ],
   "source": [
    "inner_section_names3=[]\n",
    "for inner_ID in srt:\n",
    "        inner_sections = requests.get(section_url.format(inner_ID)).json()\n",
    "        temp = [inner_section['label'] for inner_section in inner_sections]\n",
    "#         print(temp)\n",
    "        inner_section_names3.extend(temp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "ba949175",
   "metadata": {},
   "outputs": [],
   "source": [
    "lst4=inner_section_names3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "dbcf1a70",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "311 311\n"
     ]
    }
   ],
   "source": [
    "third3=lsttotable(lst4)\n",
    "# third3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "68c86104",
   "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>Ids</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>C00</td>\n",
       "      <td>Malignant neoplasm of lip</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>C01</td>\n",
       "      <td>Malignant neoplasm of base of tongue</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>C02</td>\n",
       "      <td>Malignant neoplasm of other and unspecified pa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>C03</td>\n",
       "      <td>Malignant neoplasm of gum</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>C04</td>\n",
       "      <td>Malignant neoplasm of floor of mouth</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>X53</td>\n",
       "      <td>Lack of food</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>X54</td>\n",
       "      <td>Lack of water</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>X57</td>\n",
       "      <td>Unspecified privation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>X58</td>\n",
       "      <td>Exposure to other specified factors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>X59</td>\n",
       "      <td>Exposure to unspecified factor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>311 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Ids                                        Description\n",
       "0    C00                           Malignant neoplasm of lip\n",
       "1    C01                Malignant neoplasm of base of tongue\n",
       "2    C02   Malignant neoplasm of other and unspecified pa...\n",
       "3    C03                           Malignant neoplasm of gum\n",
       "4    C04                Malignant neoplasm of floor of mouth\n",
       "..    ...                                                ...\n",
       "306  X53                                        Lack of food\n",
       "307  X54                                       Lack of water\n",
       "308  X57                               Unspecified privation\n",
       "309  X58                 Exposure to other specified factors\n",
       "310  X59                      Exposure to unspecified factor\n",
       "\n",
       "[311 rows x 2 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "third = [third3[0], third3[1]] \n",
    "df2 = pd.DataFrame(list(zip(third3[0], third3[1])),columns =['Ids', 'Description'])\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "id": "8d2bdb17",
   "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>Ids</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A00</td>\n",
       "      <td>Cholera</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A01</td>\n",
       "      <td>Typhoid and paratyphoid fevers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A02</td>\n",
       "      <td>Other salmonella infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A03</td>\n",
       "      <td>Shigellosis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A04</td>\n",
       "      <td>Other bacterial intestinal infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>X53</td>\n",
       "      <td>Lack of food</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>X54</td>\n",
       "      <td>Lack of water</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>X57</td>\n",
       "      <td>Unspecified privation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>X58</td>\n",
       "      <td>Exposure to other specified factors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>X59</td>\n",
       "      <td>Exposure to unspecified factor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2110 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Ids                            Description\n",
       "0    A00                                 Cholera\n",
       "1    A01          Typhoid and paratyphoid fevers\n",
       "2    A02             Other salmonella infections\n",
       "3    A03                             Shigellosis\n",
       "4    A04   Other bacterial intestinal infections\n",
       "..    ...                                    ...\n",
       "306  X53                            Lack of food\n",
       "307  X54                           Lack of water\n",
       "308  X57                   Unspecified privation\n",
       "309  X58     Exposure to other specified factors\n",
       "310  X59          Exposure to unspecified factor\n",
       "\n",
       "[2110 rows x 2 columns]"
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frames = [df, df1, df2]\n",
    "frames1=pd.concat(frames)\n",
    "frames1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "id": "437e85a2",
   "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>Ids</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A00</td>\n",
       "      <td>Cholera</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A01</td>\n",
       "      <td>Typhoid and paratyphoid fevers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A02</td>\n",
       "      <td>Other salmonella infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A03</td>\n",
       "      <td>Shigellosis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A04</td>\n",
       "      <td>Other bacterial intestinal infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>X53</td>\n",
       "      <td>Lack of food</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>X54</td>\n",
       "      <td>Lack of water</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>X57</td>\n",
       "      <td>Unspecified privation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>X58</td>\n",
       "      <td>Exposure to other specified factors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>X59</td>\n",
       "      <td>Exposure to unspecified factor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2110 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Ids                            Description\n",
       "0    A00                                 Cholera\n",
       "1    A01          Typhoid and paratyphoid fevers\n",
       "2    A02             Other salmonella infections\n",
       "3    A03                             Shigellosis\n",
       "4    A04   Other bacterial intestinal infections\n",
       "..    ...                                    ...\n",
       "306  X53                            Lack of food\n",
       "307  X54                           Lack of water\n",
       "308  X57                   Unspecified privation\n",
       "309  X58     Exposure to other specified factors\n",
       "310  X59          Exposure to unspecified factor\n",
       "\n",
       "[2110 rows x 2 columns]"
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frames1[\"Ids\"]=frames1[\"Ids\"].apply(str)\n",
    "fz=frames1\n",
    "fz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9e0c39a4",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "id": "a25e5248",
   "metadata": {},
   "outputs": [],
   "source": [
    "fz = fz.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "id": "db414b2d",
   "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>Ids</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A00</td>\n",
       "      <td>Cholera</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A01</td>\n",
       "      <td>Typhoid and paratyphoid fevers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A02</td>\n",
       "      <td>Other salmonella infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A03</td>\n",
       "      <td>Shigellosis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A04</td>\n",
       "      <td>Other bacterial intestinal infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2105</th>\n",
       "      <td>X53</td>\n",
       "      <td>Lack of food</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2106</th>\n",
       "      <td>X54</td>\n",
       "      <td>Lack of water</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2107</th>\n",
       "      <td>X57</td>\n",
       "      <td>Unspecified privation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2108</th>\n",
       "      <td>X58</td>\n",
       "      <td>Exposure to other specified factors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2109</th>\n",
       "      <td>X59</td>\n",
       "      <td>Exposure to unspecified factor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2110 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Ids                            Description\n",
       "0     A00                                 Cholera\n",
       "1     A01          Typhoid and paratyphoid fevers\n",
       "2     A02             Other salmonella infections\n",
       "3     A03                             Shigellosis\n",
       "4     A04   Other bacterial intestinal infections\n",
       "...    ...                                    ...\n",
       "2105  X53                            Lack of food\n",
       "2106  X54                           Lack of water\n",
       "2107  X57                   Unspecified privation\n",
       "2108  X58     Exposure to other specified factors\n",
       "2109  X59          Exposure to unspecified factor\n",
       "\n",
       "[2110 rows x 2 columns]"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "id": "f4e7e88a",
   "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>Ids</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A00</td>\n",
       "      <td>Cholera</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A01</td>\n",
       "      <td>Typhoid and paratyphoid fevers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A02</td>\n",
       "      <td>Other salmonella infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A03</td>\n",
       "      <td>Shigellosis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A04</td>\n",
       "      <td>Other bacterial intestinal infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2105</th>\n",
       "      <td>X53</td>\n",
       "      <td>Lack of food</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2106</th>\n",
       "      <td>X54</td>\n",
       "      <td>Lack of water</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2107</th>\n",
       "      <td>X57</td>\n",
       "      <td>Unspecified privation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2108</th>\n",
       "      <td>X58</td>\n",
       "      <td>Exposure to other specified factors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2109</th>\n",
       "      <td>X59</td>\n",
       "      <td>Exposure to unspecified factor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2110 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Ids                            Description\n",
       "0     A00                                 Cholera\n",
       "1     A01          Typhoid and paratyphoid fevers\n",
       "2     A02             Other salmonella infections\n",
       "3     A03                             Shigellosis\n",
       "4     A04   Other bacterial intestinal infections\n",
       "...    ...                                    ...\n",
       "2105  X53                            Lack of food\n",
       "2106  X54                           Lack of water\n",
       "2107  X57                   Unspecified privation\n",
       "2108  X58     Exposure to other specified factors\n",
       "2109  X59          Exposure to unspecified factor\n",
       "\n",
       "[2110 rows x 2 columns]"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cz=fz\n",
    "cz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "id": "fd9349e6",
   "metadata": {},
   "outputs": [],
   "source": [
    "def filterdframe(fz):\n",
    "    idx=[]\n",
    "    for i in range(0,fz.shape[0]):\n",
    "        if(len(fz.loc[i][\"Ids\"])>4):\n",
    "            idx.append(i)\n",
    "    return idx"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "id": "f824a5ed",
   "metadata": {},
   "outputs": [],
   "source": [
    "idxxx=filterdframe(cz)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "88e452f0",
   "metadata": {},
   "outputs": [],
   "source": [
    "# idxxx"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "id": "2468a506",
   "metadata": {},
   "outputs": [],
   "source": [
    "cz.drop(idxxx,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "id": "e825d742",
   "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>Ids</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A00</td>\n",
       "      <td>Cholera</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A01</td>\n",
       "      <td>Typhoid and paratyphoid fevers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A02</td>\n",
       "      <td>Other salmonella infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A03</td>\n",
       "      <td>Shigellosis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A04</td>\n",
       "      <td>Other bacterial intestinal infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2105</th>\n",
       "      <td>X53</td>\n",
       "      <td>Lack of food</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2106</th>\n",
       "      <td>X54</td>\n",
       "      <td>Lack of water</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2107</th>\n",
       "      <td>X57</td>\n",
       "      <td>Unspecified privation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2108</th>\n",
       "      <td>X58</td>\n",
       "      <td>Exposure to other specified factors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2109</th>\n",
       "      <td>X59</td>\n",
       "      <td>Exposure to unspecified factor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2047 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Ids                            Description\n",
       "0     A00                                 Cholera\n",
       "1     A01          Typhoid and paratyphoid fevers\n",
       "2     A02             Other salmonella infections\n",
       "3     A03                             Shigellosis\n",
       "4     A04   Other bacterial intestinal infections\n",
       "...    ...                                    ...\n",
       "2105  X53                            Lack of food\n",
       "2106  X54                           Lack of water\n",
       "2107  X57                   Unspecified privation\n",
       "2108  X58     Exposure to other specified factors\n",
       "2109  X59          Exposure to unspecified factor\n",
       "\n",
       "[2047 rows x 2 columns]"
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "id": "9153c560",
   "metadata": {},
   "outputs": [],
   "source": [
    "cz=cz.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "id": "69478f01",
   "metadata": {},
   "outputs": [],
   "source": [
    "cz.to_csv(\"icd_10_2019_final.csv\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "id": "86fbb918",
   "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>Ids</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A00</td>\n",
       "      <td>Cholera</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A01</td>\n",
       "      <td>Typhoid and paratyphoid fevers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A02</td>\n",
       "      <td>Other salmonella infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A03</td>\n",
       "      <td>Shigellosis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A04</td>\n",
       "      <td>Other bacterial intestinal infections</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2042</th>\n",
       "      <td>X53</td>\n",
       "      <td>Lack of food</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2043</th>\n",
       "      <td>X54</td>\n",
       "      <td>Lack of water</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2044</th>\n",
       "      <td>X57</td>\n",
       "      <td>Unspecified privation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2045</th>\n",
       "      <td>X58</td>\n",
       "      <td>Exposure to other specified factors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2046</th>\n",
       "      <td>X59</td>\n",
       "      <td>Exposure to unspecified factor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2047 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Ids                            Description\n",
       "0     A00                                 Cholera\n",
       "1     A01          Typhoid and paratyphoid fevers\n",
       "2     A02             Other salmonella infections\n",
       "3     A03                             Shigellosis\n",
       "4     A04   Other bacterial intestinal infections\n",
       "...    ...                                    ...\n",
       "2042  X53                            Lack of food\n",
       "2043  X54                           Lack of water\n",
       "2044  X57                   Unspecified privation\n",
       "2045  X58     Exposure to other specified factors\n",
       "2046  X59          Exposure to unspecified factor\n",
       "\n",
       "[2047 rows x 2 columns]"
      ]
     },
     "execution_count": 149,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv(\"icd_10_2019_final.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "id": "715b50ab",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sorted = cz.sort_values('Ids')\n",
    "df_sorted = df_sorted.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "id": "a37a5b5c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sorted.to_csv(\"icd_10_2019_final.csv\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e2279fc4",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}