prob.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import fitz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "page 0 of problem.pdf\n",
      "page 1 of problem.pdf\n",
      "page 2 of problem.pdf\n",
      "page 3 of problem.pdf\n",
      "page 4 of problem.pdf\n",
      "page 5 of problem.pdf\n",
      "page 6 of problem.pdf\n",
      "page 7 of problem.pdf\n",
      "page 8 of problem.pdf\n",
      "page 9 of problem.pdf\n",
      "page 10 of problem.pdf\n",
      "page 11 of problem.pdf\n",
      "page 12 of problem.pdf\n",
      "page 13 of problem.pdf\n",
      "page 14 of problem.pdf\n",
      "page 15 of problem.pdf\n",
      "page 16 of problem.pdf\n"
     ]
    }
   ],
   "source": [
    "doc=fitz.open('problem.pdf')\n",
    "for num_pages in doc:\n",
    "    print(num_pages)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "17\n"
     ]
    }
   ],
   "source": [
    "print(len(doc))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This pdf has got a total of 17 0 to 16 pages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Organization\n",
      "Problem Statement Title\n",
      "Category\n",
      "PS Number\n",
      "Domain Bucket\n",
      "1\n",
      "Ministry of \n",
      "Chemicals and \n",
      "Fertilizers\n",
      "International Comparative \n",
      "System to Launch Integrated \n",
      "Real-Time Data Management \n",
      "System (IDMS) for Chemical \n",
      "and Petrochemicals Sector.\n",
      "Software\n",
      "SIH1278\n",
      "Miscellaneous\n",
      "2\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Development of software for \n",
      "streamlining the listing of \n",
      "cases through Differentiated \n",
      "Case Flow Management\n",
      "Software\n",
      "SIH1279\n",
      "Miscellaneous\n",
      "3\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Development of e-Portal for \n",
      "facilitating Case Management \n",
      "Hearing of various types of \n",
      "cases\n",
      "Software\n",
      "SIH1280\n",
      "Miscellaneous\n",
      "4\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Development of gamified \n",
      "platform on Children's Rights \n",
      "to increase legal literacy and \n",
      "awareness among children in \n",
      "India\n",
      "Software\n",
      "SIH1281\n",
      "Smart \n",
      "Education\n",
      "5\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Tech-Driven Solutions for \n",
      "Undertrial Prisoners in India\n",
      "Software\n",
      "SIH1282\n",
      "Miscellaneous\n",
      "6\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Digital Assistant for Legal \n",
      "Awareness and Designing a \n",
      "KYC framework in India\n",
      "Software\n",
      "SIH1283\n",
      "Smart \n",
      "Education\n",
      "7\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Developing a Blockchain-\n",
      "Based eVault for Legal \n",
      "Records\n",
      "Software\n",
      "SIH1284\n",
      "Blockchain & \n",
      "Cybersecurity\n",
      "8\n",
      "Ministry of Law and \n",
      "Justice\n",
      "AI-powered Legal \n",
      "Documentation Assistant\n",
      "Software\n",
      "SIH1285\n",
      "Miscellaneous\n",
      "9\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Incentives based Design for \n",
      "onboarding Legal Service \n",
      "Providers such as Advocates, \n",
      "Arbitrators, Mediators, \n",
      "Notaries, Document Writers, \n",
      "etc on eMarket Place for \n",
      "extending Legal Services to \n",
      "Citizens in India\n",
      "Software\n",
      "SIH1286\n",
      "Miscellaneous\n",
      "10\n",
      "Ministry of Jal \n",
      "Shakti\n",
      "Use of Digital Technology to \n",
      "calculate water footprints for \n",
      "different daily use items.\n",
      "Software\n",
      "SIH1287\n",
      "Clean & Green \n",
      "Technology\n",
      "11\n",
      "Ministry of Jal \n",
      "Shakti\n",
      "Use of Digital Technology in \n",
      "addressing Non-Revenue \n",
      "Water (NRW)\n",
      "Software\n",
      "SIH1288\n",
      "Clean & Green \n",
      "Technology\n",
      "12\n",
      "Ministry of Jal \n",
      "Shakti\n",
      "Projection of the extent of \n",
      "inundation corresponding to \n",
      "the forecasts of flood levels in \n",
      "a river.\n",
      "Software\n",
      "SIH1289\n",
      "Disaster \n",
      "Management\n",
      "10\n",
      "\n"
     ]
    }
   ],
   "source": [
    "first_n_lines=[]\n",
    "for page_num in range(len(doc)):\n",
    "    page=doc.load_page(page_num)\n",
    "    text = page.get_text()\n",
    "    print(text)\n",
    "    break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Organization\n",
      "Problem Statement Title\n",
      "Category\n",
      "PS Number\n",
      "Domain Bucket\n",
      "1\n",
      "Ministry of \n",
      "Chemicals and \n",
      "Fertilizers\n",
      "International Comparative \n",
      "System to Launch Integrated \n",
      "Real-Time Data Management \n",
      "System (IDMS) for Chemical \n",
      "and Petrochemicals Sector.\n",
      "Software\n",
      "SIH1278\n",
      "Miscellaneous\n",
      "2\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Development of software for \n",
      "streamlining the listing of \n",
      "cases through Differentiated \n",
      "Case Flow Management\n",
      "Software\n",
      "SIH1279\n",
      "Miscellaneous\n",
      "3\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Development of e-Portal for \n",
      "facilitating Case Management \n",
      "Hearing of various types of \n",
      "cases\n",
      "Software\n",
      "SIH1280\n",
      "Miscellaneous\n",
      "4\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Development of gamified \n",
      "platform on Children's Rights \n",
      "to increase legal literacy and \n",
      "awareness among children in \n",
      "India\n",
      "Software\n",
      "SIH1281\n",
      "Smart \n",
      "Education\n",
      "5\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Tech-Driven Solutions for \n",
      "Undertrial Prisoners in India\n",
      "Software\n",
      "SIH1282\n",
      "Miscellaneous\n",
      "6\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Digital Assistant for Legal \n",
      "Awareness and Designing a \n",
      "KYC framework in India\n",
      "Software\n",
      "SIH1283\n",
      "Smart \n",
      "Education\n",
      "7\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Developing a Blockchain-\n",
      "Based eVault for Legal \n",
      "Records\n",
      "Software\n",
      "SIH1284\n",
      "Blockchain & \n",
      "Cybersecurity\n",
      "8\n",
      "Ministry of Law and \n",
      "Justice\n",
      "AI-powered Legal \n",
      "Documentation Assistant\n",
      "Software\n",
      "SIH1285\n",
      "Miscellaneous\n",
      "9\n",
      "Ministry of Law and \n",
      "Justice\n",
      "Incentives based Design for \n",
      "onboarding Legal Service \n",
      "Providers such as Advocates, \n",
      "Arbitrators, Mediators, \n",
      "Notaries, Document Writers, \n",
      "etc on eMarket Place for \n",
      "extending Legal Services to \n",
      "Citizens in India\n",
      "Software\n",
      "SIH1286\n",
      "Miscellaneous\n",
      "10\n",
      "Ministry of Jal \n",
      "Shakti\n",
      "Use of Digital Technology to \n",
      "calculate water footprints for \n",
      "different daily use items.\n",
      "Software\n",
      "SIH1287\n",
      "Clean & Green \n",
      "Technology\n",
      "11\n",
      "Ministry of Jal \n",
      "Shakti\n",
      "Use of Digital Technology in \n",
      "addressing Non-Revenue \n",
      "Water (NRW)\n",
      "Software\n",
      "SIH1288\n",
      "Clean & Green \n",
      "Technology\n",
      "12\n",
      "Ministry of Jal \n",
      "Shakti\n",
      "Projection of the extent of \n",
      "inundation corresponding to \n",
      "the forecasts of flood levels in \n",
      "a river.\n",
      "Software\n",
      "SIH1289\n",
      "Disaster \n",
      "Management\n",
      "10\n",
      "\n"
     ]
    }
   ],
   "source": [
    "page=doc.load_page(0)\n",
    "text=page.get_text()\n",
    "print(text)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "module 'tabula' has no attribute 'read_pdf'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[6], line 9\u001b[0m\n\u001b[0;32m      6\u001b[0m pdf_path \u001b[38;5;241m=\u001b[39m \u001b[38;5;124m'\u001b[39m\u001b[38;5;124mproblem.pdf\u001b[39m\u001b[38;5;124m'\u001b[39m\n\u001b[0;32m      8\u001b[0m \u001b[38;5;66;03m# Extract tables from the PDF\u001b[39;00m\n\u001b[1;32m----> 9\u001b[0m tables \u001b[38;5;241m=\u001b[39m \u001b[43mtabula\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mread_pdf\u001b[49m(pdf_path, pages\u001b[38;5;241m=\u001b[39m\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mall\u001b[39m\u001b[38;5;124m'\u001b[39m, multiple_tables\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mTrue\u001b[39;00m)\n\u001b[0;32m     11\u001b[0m dfs \u001b[38;5;241m=\u001b[39m []\n\u001b[0;32m     13\u001b[0m \u001b[38;5;28;01mfor\u001b[39;00m table \u001b[38;5;129;01min\u001b[39;00m tables:\n",
      "\u001b[1;31mAttributeError\u001b[0m: module 'tabula' has no attribute 'read_pdf'"
     ]
    }
   ],
   "source": [
    "import fitz  # PyMuPDF\n",
    "import pandas as pd\n",
    "import tabula\n",
    "\n",
    "# Define the path to the PDF file\n",
    "pdf_path = 'problem.pdf'\n",
    "\n",
    "# Extract tables from the PDF\n",
    "tables = tabula.read_pdf(pdf_path, pages='all', multiple_tables=True)\n",
    "\n",
    "dfs = []\n",
    "\n",
    "for table in tables:\n",
    "    df = pd.DataFrame(table)\n",
    "    dfs.append(df)\n",
    "\n",
    "final_df = pd.concat(dfs, ignore_index=True)\n",
    "\n",
    "csv_path = '/mnt/data/ProblemStatements.csv'\n",
    "\n",
    "final_df.to_csv(csv_path, index=False)\n",
    "\n",
    "csv_path\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Organization',\n",
       " 'Problem Statement Title',\n",
       " 'Category',\n",
       " 'PS Number',\n",
       " 'Domain Bucket',\n",
       " '1',\n",
       " 'Ministry of ',\n",
       " 'Chemicals and ',\n",
       " 'Fertilizers',\n",
       " 'International Comparative ',\n",
       " 'System to Launch Integrated ',\n",
       " 'Real-Time Data Management ',\n",
       " 'System (IDMS) for Chemical ',\n",
       " 'and Petrochemicals Sector.',\n",
       " 'Software',\n",
       " 'SIH1278',\n",
       " 'Miscellaneous',\n",
       " '2',\n",
       " 'Ministry of Law and ',\n",
       " 'Justice',\n",
       " 'Development of software for ',\n",
       " 'streamlining the listing of ',\n",
       " 'cases through Differentiated ',\n",
       " 'Case Flow Management',\n",
       " 'Software',\n",
       " 'SIH1279',\n",
       " 'Miscellaneous',\n",
       " '3',\n",
       " 'Ministry of Law and ',\n",
       " 'Justice',\n",
       " 'Development of e-Portal for ',\n",
       " 'facilitating Case Management ',\n",
       " 'Hearing of various types of ',\n",
       " 'cases',\n",
       " 'Software',\n",
       " 'SIH1280',\n",
       " 'Miscellaneous',\n",
       " '4',\n",
       " 'Ministry of Law and ',\n",
       " 'Justice',\n",
       " 'Development of gamified ',\n",
       " \"platform on Children's Rights \",\n",
       " 'to increase legal literacy and ',\n",
       " 'awareness among children in ',\n",
       " 'India',\n",
       " 'Software',\n",
       " 'SIH1281',\n",
       " 'Smart ',\n",
       " 'Education',\n",
       " '5',\n",
       " 'Ministry of Law and ',\n",
       " 'Justice',\n",
       " 'Tech-Driven Solutions for ',\n",
       " 'Undertrial Prisoners in India',\n",
       " 'Software',\n",
       " 'SIH1282',\n",
       " 'Miscellaneous',\n",
       " '6',\n",
       " 'Ministry of Law and ',\n",
       " 'Justice',\n",
       " 'Digital Assistant for Legal ',\n",
       " 'Awareness and Designing a ',\n",
       " 'KYC framework in India',\n",
       " 'Software',\n",
       " 'SIH1283',\n",
       " 'Smart ',\n",
       " 'Education',\n",
       " '7',\n",
       " 'Ministry of Law and ',\n",
       " 'Justice',\n",
       " 'Developing a Blockchain-',\n",
       " 'Based eVault for Legal ',\n",
       " 'Records',\n",
       " 'Software',\n",
       " 'SIH1284',\n",
       " 'Blockchain & ',\n",
       " 'Cybersecurity',\n",
       " '8',\n",
       " 'Ministry of Law and ',\n",
       " 'Justice',\n",
       " 'AI-powered Legal ',\n",
       " 'Documentation Assistant',\n",
       " 'Software',\n",
       " 'SIH1285',\n",
       " 'Miscellaneous',\n",
       " '9',\n",
       " 'Ministry of Law and ',\n",
       " 'Justice',\n",
       " 'Incentives based Design for ',\n",
       " 'onboarding Legal Service ',\n",
       " 'Providers such as Advocates, ',\n",
       " 'Arbitrators, Mediators, ',\n",
       " 'Notaries, Document Writers, ',\n",
       " 'etc on eMarket Place for ',\n",
       " 'extending Legal Services to ',\n",
       " 'Citizens in India',\n",
       " 'Software',\n",
       " 'SIH1286',\n",
       " 'Miscellaneous',\n",
       " '10',\n",
       " 'Ministry of Jal ',\n",
       " 'Shakti',\n",
       " 'Use of Digital Technology to ',\n",
       " 'calculate water footprints for ',\n",
       " 'different daily use items.',\n",
       " 'Software',\n",
       " 'SIH1287',\n",
       " 'Clean & Green ',\n",
       " 'Technology',\n",
       " '11',\n",
       " 'Ministry of Jal ',\n",
       " 'Shakti',\n",
       " 'Use of Digital Technology in ',\n",
       " 'addressing Non-Revenue ',\n",
       " 'Water (NRW)',\n",
       " 'Software',\n",
       " 'SIH1288',\n",
       " 'Clean & Green ',\n",
       " 'Technology',\n",
       " '12',\n",
       " 'Ministry of Jal ',\n",
       " 'Shakti',\n",
       " 'Projection of the extent of ',\n",
       " 'inundation corresponding to ',\n",
       " 'the forecasts of flood levels in ',\n",
       " 'a river.',\n",
       " 'Software',\n",
       " 'SIH1289',\n",
       " 'Disaster ',\n",
       " 'Management',\n",
       " '10']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lines = text.strip().split('\\n')\n",
    "lines"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pdfplumber\n",
    "import csv\n",
    "pdf_path = \"problem.pdf\"\n",
    "with pdfplumber.open(pdf_path) as pdf:\n",
    "    text_pages = [page.extract_text() for page in pdf.pages]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Current index0\n",
      "Table['', '10', '', '', '', 'Organization', 'Problem Statement Title', 'Category', 'PS Number', 'Domain Bucket']\n",
      "Current index1\n",
      "Table['1', None, None, 'Ministry of\\nChemicals and\\nFertilizers', None, None, 'International Comparative\\nSystem to Launch Integrated\\nReal-Time Data Management\\nSystem (IDMS) for Chemical\\nand Petrochemicals Sector.', 'Software', 'SIH1278', 'Miscellaneous']\n",
      "Current index2\n",
      "Table['2', None, None, 'Ministry of Law and\\nJustice', None, None, 'Development of software for\\nstreamlining the listing of\\ncases through Differentiated\\nCase Flow Management', 'Software', 'SIH1279', 'Miscellaneous']\n",
      "Current index3\n",
      "Table['3', None, None, 'Ministry of Law and\\nJustice', None, None, 'Development of e-Portal for\\nfacilitating Case Management\\nHearing of various types of\\ncases', 'Software', 'SIH1280', 'Miscellaneous']\n",
      "Current index4\n",
      "Table['4', None, None, 'Ministry of Law and\\nJustice', None, None, \"Development of gamified\\nplatform on Children's Rights\\nto increase legal literacy and\\nawareness among children in\\nIndia\", 'Software', 'SIH1281', 'Smart\\nEducation']\n",
      "Current index5\n",
      "Table['5', None, None, 'Ministry of Law and\\nJustice', None, None, 'Tech-Driven Solutions for\\nUndertrial Prisoners in India', 'Software', 'SIH1282', 'Miscellaneous']\n",
      "Current index6\n",
      "Table['6', None, None, 'Ministry of Law and\\nJustice', None, None, 'Digital Assistant for Legal\\nAwareness and Designing a\\nKYC framework in India', 'Software', 'SIH1283', 'Smart\\nEducation']\n",
      "Current index7\n",
      "Table['7', None, None, 'Ministry of Law and\\nJustice', None, None, 'Developing a Blockchain-\\nBased eVault for Legal\\nRecords', 'Software', 'SIH1284', 'Blockchain &\\nCybersecurity']\n",
      "Current index8\n",
      "Table['8', None, None, 'Ministry of Law and\\nJustice', None, None, 'AI-powered Legal\\nDocumentation Assistant', 'Software', 'SIH1285', 'Miscellaneous']\n",
      "Current index9\n",
      "Table['9', None, None, 'Ministry of Law and\\nJustice', None, None, 'Incentives based Design for\\nonboarding Legal Service\\nProviders such as Advocates,\\nArbitrators, Mediators,\\nNotaries, Document Writers,\\netc on eMarket Place for\\nextending Legal Services to\\nCitizens in India', 'Software', 'SIH1286', 'Miscellaneous']\n",
      "Current index10\n",
      "Table['10', None, None, 'Ministry of Jal\\nShakti', None, None, 'Use of Digital Technology to\\ncalculate water footprints for\\ndifferent daily use items.', 'Software', 'SIH1287', 'Clean & Green\\nTechnology']\n",
      "Current index11\n",
      "Table['', None, None, '', None, None, '', '', '', '']\n",
      "Current index12\n",
      "Table['11', '', '', 'Mi', 'nis', None, 'Use of Digital Technology in\\naddressing Non-Revenue\\nWater (NRW)', 'Software', 'SIH1288', 'Clean & Green\\nTechnology']\n",
      "Current index13\n",
      "Table['', None, None, None, None, None, None, None, None, None]\n",
      "Current index14\n",
      "Table['12', None, None, 'Ministry of Jal\\nShakti', None, None, 'Projection of the extent of\\ninundation corresponding to\\nthe forecasts of flood levels in\\na river.', 'Software', 'SIH1289', 'Disaster\\nManagement']\n",
      "Current index0\n",
      "Table['13', None, None, 'Ministry of Jal\\nShakti', None, 'Development of AI, ML and\\nChat boat-powered Interactive\\nRobot Mascot (Chacha\\nChaudhary) and digital avatar\\nto strengthen the river people\\nconnect component of\\nNamami Gange.', 'Software', 'SIH1290', 'Smart\\nEducation']\n",
      "Current index1\n",
      "Table['14', None, None, 'Ministry of Jal\\nShakti', None, 'A mobile app that crowd\\nsources water-related\\nproblems from around a\\ncommunity, open sources\\ndata, etc. and display them on\\na map.', 'Software', 'SIH1291', 'Disaster\\nManagement']\n",
      "Current index2\n",
      "Table['15', None, None, 'Ministry of Jal\\nShakti', None, 'AI-enabled water well\\npredictor', 'Software', 'SIH1292', 'Clean & Green\\nTechnology']\n",
      "Current index3\n",
      "Table['16', None, None, 'Ministry of power', None, 'Dashboard for real-time\\nmonitoring of construction\\nprojects.', 'Software', 'SIH1295', 'Transportation\\n& Logistics']\n",
      "Current index4\n",
      "Table['17', None, None, 'Ministry of power', None, 'Al-based Generative design of\\nHydro power plants.', 'Software', 'SIH1296', 'Renewable /\\nSustainable\\nEnergy']\n",
      "Current index5\n",
      "Table['18', None, None, 'Ministry of power', None, 'Al Based Drone Application', 'Software', 'SIH1297', 'Robotics and\\nDrones']\n",
      "Current index6\n",
      "Table['19', None, None, 'Ministry of power', None, 'Language translator tool to\\nconvert English to Hindi\\n(official Language) which can\\nbe used by all the government\\norganizations websites\\nofficially.', 'Software', 'SIH1301', 'Smart\\nAutomation']\n",
      "Current index7\n",
      "Table['20', None, None, 'Ministry of Power', None, 'Design of CYBER-\\nSECURITY ENABLED\\nSMART CONTROLLER for\\ngrid-connected Microgrid', 'Software', 'SIH1302', 'Blockchain &\\nCybersecurity']\n",
      "Current index8\n",
      "Table['21', '', '', 'Go', 've', 'PGRKAM web application (\\nwww.pgrkam.com) and the\\nPGRKAM Android\\napplication of the Punjab\\nGovernment provides\\nemployment data to the\\nprospective candidates.', 'Software', 'SIH1303', 'Miscellaneous']\n",
      "Current index9\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index10\n",
      "Table['22', None, None, 'Government of\\nPunjab', None, 'PGRKAM web application (\\nwww.pgrkam.com) and the\\nPGRKAM Android\\napplication of the Punjab\\nGovernment provides\\nemployment data to the\\nprospective candidates. The\\nplatform has a sizeable\\nnumber of user base but it\\nlacks integrated analytics\\ntools to understand how the\\nusers are consuming the', 'Software', 'SIH1304', 'Miscellaneous']\n",
      "Current index0\n",
      "Table['23', 'Government of\\nPunjab', 'The Employment Department\\nat present has a digital\\nplatform www.pgrkam.com\\nand its mobile application to\\nprovide almost all services\\noffered to job seekers and\\nemployers through digital\\nmeans. The portal has\\nmultiple modules like private\\nsector jobs, government jobs,\\nself-employment avenues,\\nforeign jobs, foreign study,\\ncounseling, guidance,\\ninduction into armed forces,\\njob melas, etc. Currently,\\nwhen a user visits the\\nportal/app, there is no hand-\\nholding mechanism to help\\nthe user get to the part of the\\ndigital platform which will\\nresolve his queries. The user\\nis required to navigate across\\nmultiple modules on the\\nportal/ app to search for\\nanswers.', 'Software', 'SIH1305', 'Smart\\nAutomation']\n",
      "Current index1\n",
      "Table['24', 'Ministry of Social\\nJustice and\\nEmpowerment', 'Computerized cognitive\\nRetraining Program for Home\\ntraining of Children with\\nDisabilities.', 'Software', 'SIH1307', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index2\n",
      "Table['25', 'Ministry of Home\\nAffairs', 'Threat zone of an explosion\\nparticularly in oil and gas\\nhandling industries or\\nrefineries', 'Software', 'SIH1308', 'Disaster\\nManagement']\n",
      "Current index3\n",
      "Table['26', 'Ministry of Textiles', 'Application Development for\\nmonitoring of wool from\\nFarm to fabric', 'Software', 'SIH1309', 'Transportation\\n& Logistics']\n",
      "Current index4\n",
      "Table['27', 'Ministry of Ports,\\nShipping and\\nWaterways', 'Dredging Analysis and\\nDecision Support System.', 'Software', 'SIH1311', 'Transportation\\n& Logistics']\n",
      "Current index5\n",
      "Table['28', 'Ministry of coal', 'Chatbot to respond to text\\nqueries pertaining to various\\nActs, Rules, and Regulations\\napplicable to Mining\\nindustries', 'Software', 'SIH1312', 'Smart\\nAutomation']\n",
      "Current index6\n",
      "Table['29', 'Ministry of coal', 'Real-time visibility of\\nDumper load status to Shovel\\noperator', 'Software', 'SIH1314', 'Smart\\nAutomation']\n",
      "Current index7\n",
      "Table['30', 'Ministry of coal', 'Application of Image\\nAnalytics for Tree\\nenumeration for diversion of\\nForest Land.', 'Software', 'SIH1316', 'Miscellaneous']\n",
      "Current index0\n",
      "Table['31', '', '', 'Mi', 'nis', 'Development of a Digital\\nPlatform for multi-modal\\nvisibility of coal transportation', 'Software', 'SIH1317', 'Smart\\nAutomation']\n",
      "Current index1\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index2\n",
      "Table['32', None, None, 'Ministry of coal', None, 'Analytics based on Govt.\\nLand Information\\nSystem(GLIS) Data', 'Software', 'SIH1318', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index3\n",
      "Table['33', None, None, 'Ministry of coal', None, 'Forecasting and scheduling of\\nrailway rakes.', 'Software', 'SIH1319', 'Smart\\nAutomation']\n",
      "Current index4\n",
      "Table['34', None, None, 'Ministry of coal', None, 'In-cab smart guidance and\\nsupport system for Dragline\\nOperator', 'Software', 'SIH1320', 'Smart Vehicles']\n",
      "Current index5\n",
      "Table['35', None, None, 'Ministry of\\nChemicals and\\nFertilizers', None, 'Compilation and Collection\\nof optimum Level (variable)\\nof data set from the Chemical\\nand Petrochemical Industries\\nin the country, aiming to\\nsmoothen the decision-\\nmaking and insight\\ngeneration in the strategic', 'Software', 'SIH1321', 'Smart\\nAutomation']\n",
      "Current index6\n",
      "Table['36', None, None, 'Government of\\nKerala', None, 'initiative.\\nDomestic Waste Management', 'Software', 'SIH1322', 'Clean & Green\\nTechnology']\n",
      "Current index7\n",
      "Table['37', None, None, 'Government of\\nKerala', None, 'Air and water quality index\\nand environment monitoring', 'Software', 'SIH1324', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index8\n",
      "Table['38', None, None, 'Government of\\nKerala', None, 'AI Assisted Tele-medicine\\nKIOSK for Rural India', 'Software', 'SIH1325', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index9\n",
      "Table['39', None, None, 'Government of\\nKerala', None, 'Ideate and implement a\\nsystem to enhance the quality\\nof education in rural areas.', 'Software', 'SIH1326', 'Smart\\nEducation']\n",
      "Current index10\n",
      "Table['40', None, None, 'Ministry of\\nInformation and\\nBroadcasting', None, '360-degree feedback software\\nfor the Government of India\\nrelated News Stories in\\nRegional Media using\\nArtificial Intelligence /\\nMachine Learning', 'Software', 'SIH1329', 'Smart\\nAutomation']\n",
      "Current index11\n",
      "Table['41', '10', '', 'Mi', 'nis', 'Text to Video of various PIB\\nPress Releases using\\nArtificial Intelligence /\\nMachine Learning /\\nGenerative Adversarial\\nNetworks in English and 13\\nRegional Languages viz.\\nHindi, Urdu, Punjabi,\\nGujarati, Marathi, Telugu,\\nKannada, Malayalam, Tamil,\\nOdia, Bengali, Assamese and', 'Software', 'SIH1330', 'Smart\\nAutomation']\n",
      "Current index12\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index0\n",
      "Table['42', None, None, 'Ministry of\\nInformation and\\nBroadcasting', None, 'A complete Digital Marketing\\nsolution for visible increase in\\nonline sale of\\nDPDÃƒÂ¢Ã¢â€šÂ¬Ã¢â€žÂ¢\\ns journals and Employment\\nNews issues through various\\navailable/new online sale\\nchannels (like website, apps ,\\namazon, social media) by\\noptimising various available\\nor new digital marketing tools\\nlike email marketing, SEO,\\nanalytics, etc., subject to\\nsuitability, sustainability and\\ncost-effectiveness.', 'Software', 'SIH1331', 'Miscellaneous']\n",
      "Current index1\n",
      "Table['43', None, None, 'Rashtriya Ispat\\nNigam Limited,\\nVisakhapatnam\\nSteel Plant', None, 'Hot metal, Steel Ladle, and\\nScrap pot Tracking by auto-\\ncapturing the Ladle number\\nand locations at SMS-1 and\\nSMS-2.', 'Software', 'SIH1332', 'Transportation\\n& Logistics']\n",
      "Current index2\n",
      "Table['44', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Udyog Saarthi App -\\n(Progressive Web-based\\nApplication) for Adults\\nundergoing Job coaching for\\nopportunities under 4%\\nreservation in NIEPMD and\\nother Institutions.', 'Software', 'SIH1333', 'Smart\\nAutomation']\n",
      "Current index3\n",
      "Table['45', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Software for intervention of\\nspeech sound disorders in\\nHindi and English.', 'Software', 'SIH1334', 'Smart\\nEducation']\n",
      "Current index4\n",
      "Table['46', None, None, 'Ministry of Mines', None, 'Unpredictable failure of poly\\npulleys along cable belt\\nconveyor system for pulley\\nchanging', 'Software', 'SIH1338', 'Transportation\\n& Logistics']\n",
      "Current index5\n",
      "Table['47', None, None, 'Ministry of Mines', None, 'Automation of drill core rock\\nsample lithology logging.', 'Software', 'SIH1339', 'Transportation\\n& Logistics']\n",
      "Current index6\n",
      "Table['48', None, None, 'Ministry of AYUSH', None, 'Application for Assessment of\\nQuality of Textbook/\\nReference Books/ E- Book', 'Software', 'SIH1340', 'Smart\\nEducation']\n",
      "Current index7\n",
      "Table['49', None, None, 'Ministry of AYUSH', None, 'PG dissertation Management\\nSystem Description.', 'Software', 'SIH1341', 'Smart\\nEducation']\n",
      "Current index8\n",
      "Table['50', None, None, 'Ministry of AYUSH', None, 'Development of a prototype\\ninstrument (sensor based) for\\nassessment and quantification\\nof rasas (taste) in crude herbs.', 'Software', 'SIH1342', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index9\n",
      "Table['51', '', '', 'Mi', 'nis', 'Identification of Different\\nMedicinal Plants/Raw\\nmaterials through Image\\nProcessing Using Machine\\nLearning Algorithms', 'Software', 'SIH1343', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index10\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index0\n",
      "Table['52', None, None, 'Ministry of AYUSH', None, 'Al-based tool for preliminary\\ndiagnosis of Dermatological\\nmanifestations', 'Software', 'SIH1344', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index1\n",
      "Table['53', None, None, 'Ministry of AYUSH', None, 'Startup-AYUSH Portal', 'Software', 'SIH1345', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index2\n",
      "Table['54', None, None, 'Ministry of AYUSH', None, 'Chatbot to Known Individual\\nPrakriti (Phenotype)', 'Software', 'SIH1346', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index3\n",
      "Table['55', None, None, 'Ministry of AYUSH', None, 'A software that suggests\\ndrugs and formulations for a\\ndisease/pharmacological\\nproperty based on the\\nAyurvedic classical\\nbooks/Repositories.', 'Software', 'SIH1347', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index4\n",
      "Table['56', None, None, 'Ministry of Railways', None, 'Natural language translation\\nengine for announcements\\nand information\\ndissemination at stations', 'Software', 'SIH1348', 'Smart\\nAutomation']\n",
      "Current index5\n",
      "Table['57', None, None, 'Ministry of Railways', None, 'Using existing CCTV\\nnetwork for crowd\\nmanagement, crime\\nprevention, and work\\nmonitoring using AIiML', 'Software', 'SIH1349', 'Smart\\nAutomation']\n",
      "Current index6\n",
      "Table['58', None, None, 'Government of\\nJammu and Kashmir', None, 'Artificial Intelligence Driven\\nDigitization of Cadastral\\nMaps', 'Software', 'SIH1350', 'Smart\\nAutomation']\n",
      "Current index7\n",
      "Table['59', None, None, 'Government of\\nJammu and Kashmir', None, 'Digital Generator Monitoring\\nDiesel generators are widely\\nused as backup power sources\\nin industries, homes, and\\nremote locations', 'Software', 'SIH1351', 'Smart\\nAutomation']\n",
      "Current index8\n",
      "Table['60', None, None, 'Government of\\nJammu and Kashmir', None, 'Traditional agriculture\\npractices lack real-time\\nmonitoring and efficient\\noperation on fields This leads\\nto inefficiencies and low\\nproduction levels.', 'Software', 'SIH1352', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index9\n",
      "Table['61', '', '', 'Go', 've', 'Using technology to develop a\\nmoving/mobile education\\nsystem/software or equipment\\nso that the children of\\nnomadic communities such as\\nBakarwals /Gujjars can have\\nproper education at least till\\nprimary.', 'Software', 'SIH1354', 'Smart\\nEducation']\n",
      "Current index10\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index11\n",
      "Table['62', None, None, 'Government of\\nJammu and Kashmir', None, 'Developing solutions to\\neffective market linkage and\\npromotion of One District\\nOne Product.', 'Software', 'SIH1355', 'Heritage &\\nCulture']\n",
      "Current index0\n",
      "Table['63', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Sentiment Analysis of\\nIncoming calls on helpdesk', 'Software', 'SIH1356', 'Miscellaneous']\n",
      "Current index1\n",
      "Table['64', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Sentiment analysis of Social\\nMedia presence', 'Software', 'SIH1357', 'Miscellaneous']\n",
      "Current index2\n",
      "Table['65', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Image correctness for a\\nproduct on marketplace', 'Software', 'SIH1358', 'Miscellaneous']\n",
      "Current index3\n",
      "Table['66', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Contact center knowledge\\nmanagement tool with\\ndecision tree', 'Software', 'SIH1359', 'Smart\\nAutomation']\n",
      "Current index4\n",
      "Table['67', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Price comparison of GeM\\nproducts with other e-\\nmarketplaces', 'Software', 'SIH1360', 'Smart\\nAutomation']\n",
      "Current index5\n",
      "Table['68', None, None, 'Government of\\nGujarat', None, 'Student dropout analysis for\\nschool education', 'Software', 'SIH1362', 'Smart\\nEducation']\n",
      "Current index6\n",
      "Table['69', None, None, 'Government of\\nGujarat', None, 'Self-identifying the mental\\nhealth status and get guidance\\nfor support.', 'Software', 'SIH1363', 'Fitness &\\nSports']\n",
      "Current index7\n",
      "Table['70', None, None, 'Government of\\nGujarat', None, 'Fake Social Media Profile\\ndetection and reporting', 'Software', 'SIH1364', 'Blockchain &\\nCybersecurity']\n",
      "Current index8\n",
      "Table['71', '', '', 'Go', 've', 'Online Blockchain based\\ncertificate generation and\\nvalidation system for\\ngovernment organization.', 'Software', 'SIH1365', 'Blockchain &\\nCybersecurity']\n",
      "Current index9\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index10\n",
      "Table['72', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Centralised Nasha Mukti\\nDatabase', 'Software', 'SIH1366', 'Miscellaneous']\n",
      "Current index11\n",
      "Table['73', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'To develop a technical\\nsolution for enabling\\nInstitution level verification\\nof students of one State\\nstudying in other State/s, who\\nare at present generally\\ndenied benefits under the\\nScholarship scheme as the\\nInstitutions in which they are\\nstudying are not registered on\\nthe portal/s of their home', 'Software', 'SIH1367', 'Smart\\nEducation']\n",
      "Current index12\n",
      "Table['74', None, None, 'Government of\\nJharkhand', None, 'State.\\nOnline integrated platform\\nfor projects taken up by the\\nstudents of various\\nuniversities/colleges', 'Software', 'SIH1369', 'Smart\\nEducation']\n",
      "Current index13\n",
      "Table['75', None, None, 'Government of\\nJharkhand', None, 'Real time monitoring of\\ninfrastructure development', 'Software', 'SIH1370', 'Smart\\nAutomation']\n",
      "Current index14\n",
      "Table['76', None, None, 'Government of\\nJharkhand', None, \"Community Based Reporting\\nand Monitoring Tool for\\nWomen's Safety in\\nColleges/Universities.\", 'Software', 'SIH1371', 'Miscellaneous']\n",
      "Current index0\n",
      "Table['77', None, None, 'Government of\\nJharkhand', None, 'development of systems for\\neffective Environmental,\\nSocial and Governance (ESG)\\nIntervention in Higher\\nEducation', 'Software', 'SIH1372', 'Renewable /\\nSustainable\\nEnergy']\n",
      "Current index1\n",
      "Table['78', None, None, 'Ministry of Power', None, 'Cloudburst prediction system', 'Software', 'SIH1374', 'Disaster\\nManagement']\n",
      "Current index2\n",
      "Table['79', None, None, 'Ministry of Power', None, 'Creation of Live Digital\\nTwins for the power Projects\\nand integration with all\\nexisting monitoring and\\ndatabase system which will\\ngive a holistic real time\\napproach to the project and\\nplant from all aspect of\\nconstruction, operation and', 'Software', 'SIH1377', 'Smart\\nAutomation']\n",
      "Current index3\n",
      "Table['80', None, None, 'Ministry of Power', None, 'maintenance.\\nSegregating and information\\non regulatory / Gofi.\\nPolicieVGuidelines/Office\\nMemorauda etc. related to\\nContract and Procurement\\nissues for proper compliance\\nand reporting of the same.', 'Software', 'SIH1378', 'Miscellaneous']\n",
      "Current index4\n",
      "Table['81', '', '', 'Mi', 'nis', 'Vegetation measurement\\nalong the line corridor using\\nsatellite imagery', 'Software', 'SIH1379', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index5\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index6\n",
      "Table['82', None, None, 'Ministry of Power', None, 'lntelligent chatbot to answer\\nqueries pertaining to various\\nMaintenance Processes within\\nSubstation', 'Software', 'SIH1380', 'Smart\\nEducation']\n",
      "Current index7\n",
      "Table['83', None, None, 'Ministry of Power', None, 'Analysis and identification of\\nmalicious mobile applications', 'Software', 'SIH1381', 'Blockchain &\\nCybersecurity']\n",
      "Current index8\n",
      "Table['84', None, None, 'Govt of Himachal\\nPradesh', None, 'Real-Time Vehicle Tracking\\nsystem.', 'Software', 'SIH1382', 'Smart Vehicles']\n",
      "Current index9\n",
      "Table['85', None, None, 'Govt of Himachal\\nPradesh', None, 'Optimizing Doctor\\nAvailability and Appointment\\nAllocation in Hospitals\\nthrough Digital Technology\\nand Al Integration.', 'Software', 'SIH1383', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index10\n",
      "Table['86', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Developing an interactive\\ngaming software / mobile\\napplication on Inteliectual\\nProperty Awareness for\\nschool students', 'Software', 'SIH1384', 'Smart\\nEducation']\n",
      "Current index11\n",
      "Table['87', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Developing a software that\\ncan translate resource\\nmaterial and other texts from\\nEnglish to other Indian\\nregional languages.', 'Software', 'SIH1385', 'Smart\\nEducation']\n",
      "Current index0\n",
      "Table['88', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, None, 'Developing a software for\\ndubbing of videos from\\nEnglish to other Indian\\nregional languages.', 'Software', 'SIH1386', 'Smart\\nEducation']\n",
      "Current index1\n",
      "Table['89', None, None, 'Ministry of power', None, None, 'Detection of Malwarei Trojan\\nin softwares used in Power\\nSector.', 'Software', 'SIH1388', 'Blockchain &\\nCybersecurity']\n",
      "Current index2\n",
      "Table['90', None, None, 'Ministry of power', None, None, \"To develop centralised\\ninformation security .Log-\\ncollection facility' or 'security\\noperation centre (soc)' in the\\npower sector, considering\\ncEA cybersecurity (Power\\nsector) Guidelines, 2021to\\nkeep lr and or networking\\nSystem isolated and air-\\ngapped.\", 'Software', 'SIH1389', 'Blockchain &\\nCybersecurity']\n",
      "Current index3\n",
      "Table['91', '10', '', 'Mi\\nEn', 'nis\\nvir', 'try of\\nonment', 'Pro Planet Person App', 'Software', 'SIH1390', 'Clean & Green\\nTechnology']\n",
      "Current index4\n",
      "Table['92', None, None, 'Ministry of\\nEnvironment', None, None, 'Behavioural change\\nmonitoring software', 'Software', 'SIH1391', 'Smart\\nAutomation']\n",
      "Current index5\n",
      "Table['93', None, None, 'Ministry of\\nEnvironment', None, None, 'E-Waste Facility Locator', 'Software', 'SIH1392', 'Smart\\nAutomation']\n",
      "Current index6\n",
      "Table['94', None, None, 'Ministry of\\nEnvironment', None, None, 'Water and Electricity\\nTracking App', 'Software', 'SIH1393', 'Smart\\nAutomation']\n",
      "Current index7\n",
      "Table['95', None, None, 'Ministry of\\nEnvironment', None, None, 'Virtual Zoo', 'Software', 'SIH1394', 'Smart\\nEducation']\n",
      "Current index8\n",
      "Table['96', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'IoT based sensors can be used\\nto determine the Machine\\nRuntime', 'Software', 'SIH1395', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index9\n",
      "Table['97', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'Developing Virtual Reality\\nbased solutions', 'Software', 'SIH1396', 'Disaster\\nManagement']\n",
      "Current index10\n",
      "Table['98', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'Development of business\\nmodels for collection and\\nutilization of single usc\\nplastics and various other\\nindustrial wastes', 'Software', 'SIH1397', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index11\n",
      "Table['99', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'lntegration and Utilization of\\ndata-based being maintained\\nby various\\nMinistries/Departments for\\nbetter utilization of raw\\nmaterials and production\\ncapacity.', 'Software', 'SIH1398', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index12\n",
      "Table['100', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'App-Based Solution to\\nidentify and solve disease in\\nplants/crops', 'Software', 'SIH1401', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index0\n",
      "Table['10', '1', '', 'Mi', 'nis', 'Ear Electronic Device for\\nTinnitus Frequency Finding\\nand Adjusting to Provide\\nRelief to Tinnitus Suffering\\nPatient', 'Software', 'SIH1402', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index1\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index2\n",
      "Table['102', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'APP Based Digital\\nAudiometer', 'Software', 'SIH1403', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index3\n",
      "Table['103', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Develop therapy materials in\\nHindi for misarticulation\\nchildren', 'Software', 'SIH1405', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index4\n",
      "Table['104', None, None, 'Ministry of Home\\nAffairs', None, 'Chatbot based helpdesk for\\ngovt employees and\\ndepartments', 'Software', 'SIH1407', 'Smart\\nAutomation']\n",
      "Current index5\n",
      "Table['105', None, None, 'Ministry of Home\\nAffairs', None, 'IT System log analyzer', 'Software', 'SIH1408', 'Blockchain &\\nCybersecurity']\n",
      "Current index6\n",
      "Table['106', None, None, 'Ministry of Home\\nAffairs', None, 'AI based IT training system', 'Software', 'SIH1409', 'Smart\\nEducation']\n",
      "Current index7\n",
      "Table['107', None, None, 'Ministry of Home\\nAffairs', None, 'Augmented/ Virtual reality\\nsystem for the live training of\\ntroops', 'Software', 'SIH1410', 'Smart\\nAutomation']\n",
      "Current index8\n",
      "Table['108', None, None, 'Ministry of Home\\nAffairs', None, 'Simulator system for counter\\nHijack and sky Marshalling\\noperations', 'Software', 'SIH1411', 'Blockchain &\\nCybersecurity']\n",
      "Current index9\n",
      "Table['109', None, None, 'Ministry of Home\\nAffairs', None, 'Data Compression for\\nbackbone network', 'Software', 'SIH1412', 'Blockchain &\\nCybersecurity']\n",
      "Current index10\n",
      "Table['110', None, None, 'Ministry of\\nCommunications', None, 'Dak Ghar Niryat Kendra', 'Software', 'SIH1413', 'Transportation\\n& Logistics']\n",
      "Current index11\n",
      "Table['11', '1', '', 'Mi', 'nis', 'Development of motion\\namplification video\\ntechniques for vibration\\nanalysis', 'Software', 'SIH1415', 'Smart\\nAutomation']\n",
      "Current index12\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index13\n",
      "Table['112', None, None, 'Ministry of Defence', None, 'AI based Automatic alarm\\ngeneration and dropping of\\npayload at a particular object\\nthrough a Drone.', 'Software', 'SIH1416', 'Disaster\\nManagement']\n",
      "Current index14\n",
      "Table['113', None, None, 'Ministry of Defence', None, 'AI-ML based intelligent de-\\nsmoking/de-hazing algorithm', 'Software', 'SIH1417', 'Disaster\\nManagement']\n",
      "Current index15\n",
      "Table['114', None, None, 'Ministry of Defence', None, 'Deep learning for terrain\\nrecognition', 'Software', 'SIH1418', 'Miscellaneous']\n",
      "Current index16\n",
      "Table['115', None, None, 'Ministry of Defence', None, 'Robust human target\\ndetection and acquisition', 'Software', 'SIH1419', 'Miscellaneous']\n",
      "Current index17\n",
      "Table['116', None, None, 'Ministry of Defence', None, 'Lean module for reasoning\\nabout computational\\ncomplexity in GPTs.', 'Software', 'SIH1420', 'Miscellaneous']\n",
      "Current index18\n",
      "Table['117', None, None, 'Ministry of Defence', None, 'Novel Technologies for Early\\nDetection and Mitigation of\\nAvalanches', 'Software', 'SIH1421', 'Disaster\\nManagement']\n",
      "Current index19\n",
      "Table['118', None, None, 'Ministry of Defence', None, 'Devise the method for\\nidentification of victims\\nburied under avalanches.', 'Software', 'SIH1422', 'Disaster\\nManagement']\n",
      "Current index20\n",
      "Table['119', None, None, 'Ministry of Jal\\nShakti', None, 'Web /Mobile based tool for\\nmapping of Water supply\\nnetwork', 'Software', 'SIH1423', 'Miscellaneous']\n",
      "Current index0\n",
      "Table['120', None, None, 'Ministry of Rural\\nDevelopment', None, \"AR/VR based application\\nwhich helps visualize the\\ncomplete house virtually at an\\nearly stage, which can help in\\ncost estimation, planning and\\ncompletion of the house in\\ntime'\", 'Software', 'SIH1428', 'Smart\\nAutomation']\n",
      "Current index1\n",
      "Table['12', '1', '', 'Mi', 'nis', 'Develop a solution to identifo\\ndiscrepancies in Quality\\nMonitoring Data on OMMAS\\nand generate reports that\\nhighlight areas where\\ncorrective action is Required.', 'Software', 'SIH1429', 'Smart\\nAutomation']\n",
      "Current index2\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index3\n",
      "Table['122', None, None, 'Ministry of\\nEducation', None, 'Online personalized learning\\nremediation/tutoring tool.\\nSearch for best teacher for\\nspecific topics.', 'Software', 'SIH1431', 'Smart\\nEducation']\n",
      "Current index4\n",
      "Table['123', None, None, 'Ministry of\\nEducation', None, 'Identify slow learners for\\nremedial teaching and\\ncapacity building for\\ninnovative methods.', 'Software', 'SIH1432', 'Smart\\nEducation']\n",
      "Current index5\n",
      "Table['124', None, None, 'Ministry of\\nEducation', None, 'Mental health and well-being\\nsurveillance, assessment and\\ntracking solution among\\nchildren.', 'Software', 'SIH1433', 'Smart\\nEducation']\n",
      "Current index6\n",
      "Table['125', None, None, 'Ministry of\\nEducation', None, 'Making career choices and AI\\nbased counselling accessible\\nto every child at secondary\\nlevel along with aptitude tests\\nand detailed career paths.', 'Software', 'SIH1434', 'Smart\\nEducation']\n",
      "Current index7\n",
      "Table['126', None, None, 'Ministry of Rural\\nDevelopment', None, 'Developing an algotithim /\\nprogramme to measure\\nincrease in income of FPOs\\non account of project\\ninterventions under WDC 2.0.', 'Software', 'SIH1435', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index8\n",
      "Table['127', None, None, 'Ministry of Rural\\nDevelopment', None, 'Number of persons benefitted\\nfrom using the Water\\nHarvesting Structures (WHS)\\ncreated / rejuvenated in the\\nproject areas under WDC 2.0\\nfor economic activities like\\nfisheries etc for alternate\\nsource of income generation.', 'Software', 'SIH1436', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index9\n",
      "Table['128', None, None, 'Ministry of Rural\\nDevelopment', None, 'Development of suitable\\nSoftware and Hardware\\ncomponents/sensors for\\nspringshed mapping,\\nmonitoring and management.', 'Software', 'SIH1437', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index0\n",
      "Table['129', None, None, 'Ministry of Home\\nAffairs', None, 'Virtual Reality-Based\\nTraining for CBRN Disaster\\nResponse', 'Software', 'SIH1438', 'Disaster\\nManagement']\n",
      "Current index1\n",
      "Table['130', None, None, 'Ministry of Home\\nAffairs', None, 'An application under which\\nall rescue agencies are\\nregistered and which can\\ndisplay the location of other\\nrescue relief agencies during\\nnatural/ man made calamities', 'Software', 'SIH1440', 'Disaster\\nManagement']\n",
      "Current index2\n",
      "Table['13', '1', '', 'Ba', 'jaj', 'Similar Document Template\\nMatching Algorithm', 'Software', 'SIH1441', 'Miscellaneous']\n",
      "Current index3\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index4\n",
      "Table['132', None, None, 'Autodesk Education\\nExperience', None, 'Students to use Autodesk\\nFusion 360 to research and\\nredesign a conventional\\nautomotive component\\ncommonly found in vehicles\\nand utilize generative design\\nto reimagine its design. For\\nadditional information and\\ndetailed problem statement,\\nplease visit:\\nhttps://damassets.autodesk.net\\n/content/dam/autodesk/www/p\\ndfs/sih-2023-hardware-\\nedition-additive-\\nmanufacturing.pdf', 'Software', 'SIH1442', 'Smart Vehicles']\n",
      "Current index5\n",
      "Table['133', None, None, 'Autodesk Education\\nExperience', None, 'Students to use Autodesk\\nFusion 360 to research and to\\ngenerate NC code with\\nmachine details and tool\\nlibrary for any industrial\\ncomponent. For additional\\ninformation and detailed\\nproblem statement, please\\nvisit:\\nhttps://damassets.autodesk.net\\n/content/dam/autodesk/www/p\\ndfs/sih-2023-hardware-', 'Software', 'SIH1443', 'Smart\\nAutomation']\n",
      "Current index6\n",
      "Table['134', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'edition-cnc.pdf\\nDe-anonymisation for\\nmonitoring and tracking of\\nillegal activities performed\\nusing cryptocurrency\\ntransaction technology', 'Software', 'SIH1445', 'Blockchain &\\nCybersecurity']\n",
      "Current index7\n",
      "Table['135', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Developing a GUI based\\nhardening script for Ubuntu\\noperating system with\\nflexibility to cater for\\norganisational security\\npolicies', 'Software', 'SIH1446', 'Miscellaneous']\n",
      "Current index0\n",
      "Table['136', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Identification and Extraction\\nof Forward Error Correction\\n(FEC) schemes of unknown\\ndemodulated signals', 'Software', 'SIH1447', 'Miscellaneous']\n",
      "Current index1\n",
      "Table['137', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Design, develop and\\nimplement a software bill of\\nmaterials (SBOM) generation\\ntool that can generate the\\ncomplete SBOM of custom-\\ndeveloped software (including\\nin-house developments by\\norganisations)', 'Software', 'SIH1449', 'Smart\\nAutomation']\n",
      "Current index2\n",
      "Table['138', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Develop and deploy a Large\\nLanguage Model (LLM)\\nbased tool for generating\\nhuman like responses to\\nnatural language inputs for\\nnetwork not connected over\\ninternet', 'Software', 'SIH1450', 'Smart\\nAutomation']\n",
      "Current index3\n",
      "Table['139', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Develop a AI/ML tool to\\ndetect whether a system /\\nfirewall /router / network is\\ncompromised. The technique\\nshould not rely only on IoCs\\n(Indicators of Compromises)\\ndetection.', 'Software', 'SIH1451', 'Blockchain &\\nCybersecurity']\n",
      "Current index4\n",
      "Table['140', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Develop Ransomware\\nReadiness Assessment tool.', 'Software', 'SIH1452', 'Blockchain &\\nCybersecurity']\n",
      "Current index5\n",
      "Table['14', '1', '', 'Na', 'tio', 'Investigation of\\nvulnerabilities in\\nimplementation of crypto\\nlibrary used by OpenVPN for\\nInternet Protocol Security\\n(IPsec), IPV6 deployment.', 'Software', 'SIH1453', 'Blockchain &\\nCybersecurity']\n",
      "Current index6\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index7\n",
      "Table['142', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Create an intelligent system\\nusing AI/ML to detect\\nphishing domains which\\nimitate look and feel of\\ngenuine domains', 'Software', 'SIH1454', 'Blockchain &\\nCybersecurity']\n",
      "Current index8\n",
      "Table['143', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Efficient enumeration of\\nURLs of active hidden servers\\nover anonymous channel\\n(TOR)', 'Software', 'SIH1455', 'Blockchain &\\nCybersecurity']\n",
      "Current index0\n",
      "Table['144', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Speech to text transcription\\nfor Indian languages. The\\nproblem entails transcription\\nin the native script and then\\ntranslation to English. The\\nlanguages of interest are\\nHindi, Indian English, Urdu,\\nBengali, Punjabi.', 'Software', 'SIH1456', 'Miscellaneous']\n",
      "Current index1\n",
      "Table['145', None, None, 'MathWorks India\\nPrivate Limited', None, 'Get Fit Faster with a High-\\nTech Tracker: Analyze\\nHuman Activity and GPS\\nData for Improved Results', 'Software', 'SIH1457', 'Smart\\nAutomation']\n",
      "Current index2\n",
      "Table['146', None, None, 'AICTE', None, 'AI Based - Designing of\\nAssistive portal for\\nStakeholders in Approval\\nProcess', 'Software', 'SIH1458', 'Miscellaneous']\n",
      "Current index3\n",
      "Table['147', None, None, 'AICTE', None, 'Integration of Multiple Data-\\nbases of AICTE in order to\\nfetch Coherent Information', 'Software', 'SIH1459', 'Miscellaneous']\n",
      "Current index4\n",
      "Table['148', None, None, 'AICTE', None, 'Integration of AI for Adaptive\\nLearning for MCQ Selection\\nin PARAKH', 'Software', 'SIH1460', 'Smart\\nAutomation']\n",
      "Current index5\n",
      "Table['149', None, None, 'AICTE', None, 'Cybersecurity Portal for\\nEffective Management of\\nServers and Firewalls', 'Software', 'SIH1461', 'Blockchain &\\nCybersecurity']\n",
      "Current index6\n",
      "Table['150', None, None, 'Ministry of Home\\nAffairs', None, 'Awareness and Preparedness\\nTowards Disaster\\nManagement', 'Software', 'SIH1462', 'Disaster\\nManagement']\n",
      "Current index7\n",
      "Table['15', '1', '', 'AI', 'CT', 'Establishing a Server log\\nsystem for E-governance with\\nappropriate notification and\\ncontent based classification of\\nlog AICTE', 'Software', 'SIH1463', 'Miscellaneous']\n",
      "Current index8\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index9\n",
      "Table['152', None, None, 'AICTE', None, 'Design and Developed a\\npersonalized online meeting\\nsystem for AICTE', 'Software', 'SIH1464', 'Blockchain &\\nCybersecurity']\n",
      "Current index10\n",
      "Table['153', None, None, 'AICTE', None, 'A unified portal for\\ndeveloping a model\\nCurriculum for all the AICTE\\nApproved Institutes', 'Software', 'SIH1465', 'Miscellaneous']\n",
      "Current index11\n",
      "Table['154', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1467', 'Smart\\nEducation']\n",
      "Current index12\n",
      "Table['155', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1468', 'Disaster\\nManagement']\n",
      "Current index13\n",
      "Table['156', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1483', 'Miscellaneous']\n",
      "Current index14\n",
      "Table['157', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1484', 'Blockchain &\\nCybersecurity']\n",
      "Current index15\n",
      "Table['158', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1485', 'Renewable /\\nSustainable\\nEnergy']\n",
      "Current index16\n",
      "Table['159', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1486', 'Transportation\\n& Logistics']\n",
      "Current index0\n",
      "Table['160', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1487', 'Clean & Green\\nTechnology']\n",
      "Current index1\n",
      "Table['16', '1', '', 'AI', 'CT', 'Student Innovation', 'Software', 'SIH1488', 'Robotics and\\nDrones']\n",
      "Current index2\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index3\n",
      "Table['162', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1489', 'Transportation\\n& Logistics']\n",
      "Current index4\n",
      "Table['163', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1490', 'Smart Vehicles']\n",
      "Current index5\n",
      "Table['164', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1491', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "Current index6\n",
      "Table['165', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1492', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index7\n",
      "Table['166', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1493', 'Heritage &\\nCulture']\n",
      "Current index8\n",
      "Table['167', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1494', 'Fitness &\\nSports']\n",
      "Current index9\n",
      "Table['168', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1495', 'Smart\\nAutomation']\n",
      "Current index10\n",
      "Table['169', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1496', 'Toys & Games']\n",
      "Current index11\n",
      "Table['170', None, None, 'AICTE, MIC', None, 'Develop a Proctored exam\\ntool for shortlisting the\\ncandidates for the national\\nand international level\\nhackathons.', 'Software', 'SIH1498', 'Smart\\nAutomation']\n",
      "Current index12\n",
      "Table['17', '1', '', 'Go', 've', 'Education ecosystem for\\nspecially abled student need\\nprovision and improvement to\\ntake care of compliance,\\ngovernance and conduct.', 'Software', 'SIH1500', 'Smart\\nEducation']\n",
      "Current index13\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index14\n",
      "Table['172', None, None, 'Ministry of AYUSH', None, 'Development of Virtual\\nReality (VR) technology for\\nDhatuposhana Nyaya', 'Software', 'SIH1501', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "Current index15\n",
      "Table['173', None, None, 'Government of\\nJharkhand', None, 'Blended Learning to\\novercome inadequate\\ninfrastructure', 'Software', 'SIH1502', 'Smart\\nEducation']\n",
      "Current index16\n",
      "Table['174', None, None, 'Government of\\nJharkhand', None, 'Capacity building,\\nperformance assessment and\\nmotivation driven tool for\\nfaculty upgradation', 'Software', 'SIH1504', 'Smart\\nEducation']\n",
      "Current index17\n",
      "Table['175', None, None, 'Ministry of Home\\nAffairs', None, 'Areal Location of Hazardous\\nAtmosphere in Industries', 'Software', 'SIH1505', 'Disaster\\nManagement']\n",
      "Current index18\n",
      "Table['176', None, None, 'Ministry of Ports,\\nShipping and\\nWaterways', None, 'Leveraging the power of deep\\nlearning to overcome the\\nchallenges of marine\\nengineering and improve\\nvessel operations:', 'Software', 'SIH1506', 'Smart\\nAutomation']\n",
      "Current index0\n",
      "Table['177', None, None, 'Ministry of Power', None, \"Creation of dedicated real\\ntime 'Procurement Data\\nPortal'as well as 'Vendor\\nPayment Data portal'to\\ncapture all related data in\\nrespect of NEEPCO,S\\nProcurements and Payments'\\nincluding Procurement from\\nMSE Sector and procurement\\nin GeM Portal\", 'Software', 'SIH1508', 'Miscellaneous']\n",
      "Current index1\n",
      "Table['178', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, 'App-Based Solution to\\nprovide market access to\\nmicro and small enterprises', 'Software', 'SIH1509', 'Miscellaneous']\n",
      "Current index2\n",
      "Table['179', None, None, 'Ministry of Rural\\nDevelopment', None, 'Land profiling of Asset\\nCreation process', 'Software', 'SIH1510', 'Miscellaneous']\n",
      "Current index3\n",
      "Table['180', None, None, 'Ministry of Housing\\nand Urban Affairs', None, 'Comprehensive lnspection\\nand Analysis of Water Supply\\nDistribution Lines', 'Software', 'SIH1514', 'Clean & Green\\nTechnology']\n",
      "Current index4\n",
      "Table['18', '1', '', 'Mi', 'nis', 'Smart and Effective realtime\\nManagement of street parking', 'Software', 'SIH1515', 'Smart\\nAutomation']\n",
      "Current index5\n",
      "Table['', None, None, None, None, None, None, None, None]\n",
      "Current index6\n",
      "Table['182', None, None, 'Ministry of Housing\\nand Urban Affairs', None, 'Suggest an Al-based solution\\nto enable ease of grievance\\nlodging and tracking for\\ncitizens across multiple\\ndepartments', 'Software', 'SIH1516', 'Smart\\nAutomation']\n",
      "Current index0\n",
      "Table['', '']\n"
     ]
    }
   ],
   "source": [
    "for page in pdf.pages:\n",
    "    table=page.extract_table()\n",
    "    for i,j in enumerate(table):\n",
    "        print(f\"Current index{i}\")\n",
    "        print(f\"Table{j}\")\n",
    "        \n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[['', '10', '', '', '', 'Organization', 'Problem Statement Title', 'Category', 'PS Number', 'Domain Bucket'], ['1', None, None, 'Ministry of\\nChemicals and\\nFertilizers', None, None, 'International Comparative\\nSystem to Launch Integrated\\nReal-Time Data Management\\nSystem (IDMS) for Chemical\\nand Petrochemicals Sector.', 'Software', 'SIH1278', 'Miscellaneous'], ['2', None, None, 'Ministry of Law and\\nJustice', None, None, 'Development of software for\\nstreamlining the listing of\\ncases through Differentiated\\nCase Flow Management', 'Software', 'SIH1279', 'Miscellaneous'], ['3', None, None, 'Ministry of Law and\\nJustice', None, None, 'Development of e-Portal for\\nfacilitating Case Management\\nHearing of various types of\\ncases', 'Software', 'SIH1280', 'Miscellaneous'], ['4', None, None, 'Ministry of Law and\\nJustice', None, None, \"Development of gamified\\nplatform on Children's Rights\\nto increase legal literacy and\\nawareness among children in\\nIndia\", 'Software', 'SIH1281', 'Smart\\nEducation'], ['5', None, None, 'Ministry of Law and\\nJustice', None, None, 'Tech-Driven Solutions for\\nUndertrial Prisoners in India', 'Software', 'SIH1282', 'Miscellaneous'], ['6', None, None, 'Ministry of Law and\\nJustice', None, None, 'Digital Assistant for Legal\\nAwareness and Designing a\\nKYC framework in India', 'Software', 'SIH1283', 'Smart\\nEducation'], ['7', None, None, 'Ministry of Law and\\nJustice', None, None, 'Developing a Blockchain-\\nBased eVault for Legal\\nRecords', 'Software', 'SIH1284', 'Blockchain &\\nCybersecurity'], ['8', None, None, 'Ministry of Law and\\nJustice', None, None, 'AI-powered Legal\\nDocumentation Assistant', 'Software', 'SIH1285', 'Miscellaneous'], ['9', None, None, 'Ministry of Law and\\nJustice', None, None, 'Incentives based Design for\\nonboarding Legal Service\\nProviders such as Advocates,\\nArbitrators, Mediators,\\nNotaries, Document Writers,\\netc on eMarket Place for\\nextending Legal Services to\\nCitizens in India', 'Software', 'SIH1286', 'Miscellaneous'], ['10', None, None, 'Ministry of Jal\\nShakti', None, None, 'Use of Digital Technology to\\ncalculate water footprints for\\ndifferent daily use items.', 'Software', 'SIH1287', 'Clean & Green\\nTechnology'], ['', None, None, '', None, None, '', '', '', ''], ['11', '', '', 'Mi', 'nis', None, 'Use of Digital Technology in\\naddressing Non-Revenue\\nWater (NRW)', 'Software', 'SIH1288', 'Clean & Green\\nTechnology'], ['', None, None, None, None, None, None, None, None, None], ['12', None, None, 'Ministry of Jal\\nShakti', None, None, 'Projection of the extent of\\ninundation corresponding to\\nthe forecasts of flood levels in\\na river.', 'Software', 'SIH1289', 'Disaster\\nManagement']], [['13', None, None, 'Ministry of Jal\\nShakti', None, 'Development of AI, ML and\\nChat boat-powered Interactive\\nRobot Mascot (Chacha\\nChaudhary) and digital avatar\\nto strengthen the river people\\nconnect component of\\nNamami Gange.', 'Software', 'SIH1290', 'Smart\\nEducation'], ['14', None, None, 'Ministry of Jal\\nShakti', None, 'A mobile app that crowd\\nsources water-related\\nproblems from around a\\ncommunity, open sources\\ndata, etc. and display them on\\na map.', 'Software', 'SIH1291', 'Disaster\\nManagement'], ['15', None, None, 'Ministry of Jal\\nShakti', None, 'AI-enabled water well\\npredictor', 'Software', 'SIH1292', 'Clean & Green\\nTechnology'], ['16', None, None, 'Ministry of power', None, 'Dashboard for real-time\\nmonitoring of construction\\nprojects.', 'Software', 'SIH1295', 'Transportation\\n& Logistics'], ['17', None, None, 'Ministry of power', None, 'Al-based Generative design of\\nHydro power plants.', 'Software', 'SIH1296', 'Renewable /\\nSustainable\\nEnergy'], ['18', None, None, 'Ministry of power', None, 'Al Based Drone Application', 'Software', 'SIH1297', 'Robotics and\\nDrones'], ['19', None, None, 'Ministry of power', None, 'Language translator tool to\\nconvert English to Hindi\\n(official Language) which can\\nbe used by all the government\\norganizations websites\\nofficially.', 'Software', 'SIH1301', 'Smart\\nAutomation'], ['20', None, None, 'Ministry of Power', None, 'Design of CYBER-\\nSECURITY ENABLED\\nSMART CONTROLLER for\\ngrid-connected Microgrid', 'Software', 'SIH1302', 'Blockchain &\\nCybersecurity'], ['21', '', '', 'Go', 've', 'PGRKAM web application (\\nwww.pgrkam.com) and the\\nPGRKAM Android\\napplication of the Punjab\\nGovernment provides\\nemployment data to the\\nprospective candidates.', 'Software', 'SIH1303', 'Miscellaneous'], ['', None, None, None, None, None, None, None, None], ['22', None, None, 'Government of\\nPunjab', None, 'PGRKAM web application (\\nwww.pgrkam.com) and the\\nPGRKAM Android\\napplication of the Punjab\\nGovernment provides\\nemployment data to the\\nprospective candidates. The\\nplatform has a sizeable\\nnumber of user base but it\\nlacks integrated analytics\\ntools to understand how the\\nusers are consuming the', 'Software', 'SIH1304', 'Miscellaneous']], [['23', 'Government of\\nPunjab', 'The Employment Department\\nat present has a digital\\nplatform www.pgrkam.com\\nand its mobile application to\\nprovide almost all services\\noffered to job seekers and\\nemployers through digital\\nmeans. The portal has\\nmultiple modules like private\\nsector jobs, government jobs,\\nself-employment avenues,\\nforeign jobs, foreign study,\\ncounseling, guidance,\\ninduction into armed forces,\\njob melas, etc. Currently,\\nwhen a user visits the\\nportal/app, there is no hand-\\nholding mechanism to help\\nthe user get to the part of the\\ndigital platform which will\\nresolve his queries. The user\\nis required to navigate across\\nmultiple modules on the\\nportal/ app to search for\\nanswers.', 'Software', 'SIH1305', 'Smart\\nAutomation'], ['24', 'Ministry of Social\\nJustice and\\nEmpowerment', 'Computerized cognitive\\nRetraining Program for Home\\ntraining of Children with\\nDisabilities.', 'Software', 'SIH1307', 'MedTech /\\nBioTech /\\nHealthTech'], ['25', 'Ministry of Home\\nAffairs', 'Threat zone of an explosion\\nparticularly in oil and gas\\nhandling industries or\\nrefineries', 'Software', 'SIH1308', 'Disaster\\nManagement'], ['26', 'Ministry of Textiles', 'Application Development for\\nmonitoring of wool from\\nFarm to fabric', 'Software', 'SIH1309', 'Transportation\\n& Logistics'], ['27', 'Ministry of Ports,\\nShipping and\\nWaterways', 'Dredging Analysis and\\nDecision Support System.', 'Software', 'SIH1311', 'Transportation\\n& Logistics'], ['28', 'Ministry of coal', 'Chatbot to respond to text\\nqueries pertaining to various\\nActs, Rules, and Regulations\\napplicable to Mining\\nindustries', 'Software', 'SIH1312', 'Smart\\nAutomation'], ['29', 'Ministry of coal', 'Real-time visibility of\\nDumper load status to Shovel\\noperator', 'Software', 'SIH1314', 'Smart\\nAutomation'], ['30', 'Ministry of coal', 'Application of Image\\nAnalytics for Tree\\nenumeration for diversion of\\nForest Land.', 'Software', 'SIH1316', 'Miscellaneous']], [['31', '', '', 'Mi', 'nis', 'Development of a Digital\\nPlatform for multi-modal\\nvisibility of coal transportation', 'Software', 'SIH1317', 'Smart\\nAutomation'], ['', None, None, None, None, None, None, None, None], ['32', None, None, 'Ministry of coal', None, 'Analytics based on Govt.\\nLand Information\\nSystem(GLIS) Data', 'Software', 'SIH1318', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment'], ['33', None, None, 'Ministry of coal', None, 'Forecasting and scheduling of\\nrailway rakes.', 'Software', 'SIH1319', 'Smart\\nAutomation'], ['34', None, None, 'Ministry of coal', None, 'In-cab smart guidance and\\nsupport system for Dragline\\nOperator', 'Software', 'SIH1320', 'Smart Vehicles'], ['35', None, None, 'Ministry of\\nChemicals and\\nFertilizers', None, 'Compilation and Collection\\nof optimum Level (variable)\\nof data set from the Chemical\\nand Petrochemical Industries\\nin the country, aiming to\\nsmoothen the decision-\\nmaking and insight\\ngeneration in the strategic', 'Software', 'SIH1321', 'Smart\\nAutomation'], ['36', None, None, 'Government of\\nKerala', None, 'initiative.\\nDomestic Waste Management', 'Software', 'SIH1322', 'Clean & Green\\nTechnology'], ['37', None, None, 'Government of\\nKerala', None, 'Air and water quality index\\nand environment monitoring', 'Software', 'SIH1324', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment'], ['38', None, None, 'Government of\\nKerala', None, 'AI Assisted Tele-medicine\\nKIOSK for Rural India', 'Software', 'SIH1325', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment'], ['39', None, None, 'Government of\\nKerala', None, 'Ideate and implement a\\nsystem to enhance the quality\\nof education in rural areas.', 'Software', 'SIH1326', 'Smart\\nEducation'], ['40', None, None, 'Ministry of\\nInformation and\\nBroadcasting', None, '360-degree feedback software\\nfor the Government of India\\nrelated News Stories in\\nRegional Media using\\nArtificial Intelligence /\\nMachine Learning', 'Software', 'SIH1329', 'Smart\\nAutomation'], ['41', '10', '', 'Mi', 'nis', 'Text to Video of various PIB\\nPress Releases using\\nArtificial Intelligence /\\nMachine Learning /\\nGenerative Adversarial\\nNetworks in English and 13\\nRegional Languages viz.\\nHindi, Urdu, Punjabi,\\nGujarati, Marathi, Telugu,\\nKannada, Malayalam, Tamil,\\nOdia, Bengali, Assamese and', 'Software', 'SIH1330', 'Smart\\nAutomation'], ['', None, None, None, None, None, None, None, None]], [['42', None, None, 'Ministry of\\nInformation and\\nBroadcasting', None, 'A complete Digital Marketing\\nsolution for visible increase in\\nonline sale of\\nDPDÃƒÂ¢Ã¢â€šÂ¬Ã¢â€žÂ¢\\ns journals and Employment\\nNews issues through various\\navailable/new online sale\\nchannels (like website, apps ,\\namazon, social media) by\\noptimising various available\\nor new digital marketing tools\\nlike email marketing, SEO,\\nanalytics, etc., subject to\\nsuitability, sustainability and\\ncost-effectiveness.', 'Software', 'SIH1331', 'Miscellaneous'], ['43', None, None, 'Rashtriya Ispat\\nNigam Limited,\\nVisakhapatnam\\nSteel Plant', None, 'Hot metal, Steel Ladle, and\\nScrap pot Tracking by auto-\\ncapturing the Ladle number\\nand locations at SMS-1 and\\nSMS-2.', 'Software', 'SIH1332', 'Transportation\\n& Logistics'], ['44', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Udyog Saarthi App -\\n(Progressive Web-based\\nApplication) for Adults\\nundergoing Job coaching for\\nopportunities under 4%\\nreservation in NIEPMD and\\nother Institutions.', 'Software', 'SIH1333', 'Smart\\nAutomation'], ['45', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Software for intervention of\\nspeech sound disorders in\\nHindi and English.', 'Software', 'SIH1334', 'Smart\\nEducation'], ['46', None, None, 'Ministry of Mines', None, 'Unpredictable failure of poly\\npulleys along cable belt\\nconveyor system for pulley\\nchanging', 'Software', 'SIH1338', 'Transportation\\n& Logistics'], ['47', None, None, 'Ministry of Mines', None, 'Automation of drill core rock\\nsample lithology logging.', 'Software', 'SIH1339', 'Transportation\\n& Logistics'], ['48', None, None, 'Ministry of AYUSH', None, 'Application for Assessment of\\nQuality of Textbook/\\nReference Books/ E- Book', 'Software', 'SIH1340', 'Smart\\nEducation'], ['49', None, None, 'Ministry of AYUSH', None, 'PG dissertation Management\\nSystem Description.', 'Software', 'SIH1341', 'Smart\\nEducation'], ['50', None, None, 'Ministry of AYUSH', None, 'Development of a prototype\\ninstrument (sensor based) for\\nassessment and quantification\\nof rasas (taste) in crude herbs.', 'Software', 'SIH1342', 'MedTech /\\nBioTech /\\nHealthTech'], ['51', '', '', 'Mi', 'nis', 'Identification of Different\\nMedicinal Plants/Raw\\nmaterials through Image\\nProcessing Using Machine\\nLearning Algorithms', 'Software', 'SIH1343', 'MedTech /\\nBioTech /\\nHealthTech'], ['', None, None, None, None, None, None, None, None]], [['52', None, None, 'Ministry of AYUSH', None, 'Al-based tool for preliminary\\ndiagnosis of Dermatological\\nmanifestations', 'Software', 'SIH1344', 'MedTech /\\nBioTech /\\nHealthTech'], ['53', None, None, 'Ministry of AYUSH', None, 'Startup-AYUSH Portal', 'Software', 'SIH1345', 'MedTech /\\nBioTech /\\nHealthTech'], ['54', None, None, 'Ministry of AYUSH', None, 'Chatbot to Known Individual\\nPrakriti (Phenotype)', 'Software', 'SIH1346', 'MedTech /\\nBioTech /\\nHealthTech'], ['55', None, None, 'Ministry of AYUSH', None, 'A software that suggests\\ndrugs and formulations for a\\ndisease/pharmacological\\nproperty based on the\\nAyurvedic classical\\nbooks/Repositories.', 'Software', 'SIH1347', 'MedTech /\\nBioTech /\\nHealthTech'], ['56', None, None, 'Ministry of Railways', None, 'Natural language translation\\nengine for announcements\\nand information\\ndissemination at stations', 'Software', 'SIH1348', 'Smart\\nAutomation'], ['57', None, None, 'Ministry of Railways', None, 'Using existing CCTV\\nnetwork for crowd\\nmanagement, crime\\nprevention, and work\\nmonitoring using AIiML', 'Software', 'SIH1349', 'Smart\\nAutomation'], ['58', None, None, 'Government of\\nJammu and Kashmir', None, 'Artificial Intelligence Driven\\nDigitization of Cadastral\\nMaps', 'Software', 'SIH1350', 'Smart\\nAutomation'], ['59', None, None, 'Government of\\nJammu and Kashmir', None, 'Digital Generator Monitoring\\nDiesel generators are widely\\nused as backup power sources\\nin industries, homes, and\\nremote locations', 'Software', 'SIH1351', 'Smart\\nAutomation'], ['60', None, None, 'Government of\\nJammu and Kashmir', None, 'Traditional agriculture\\npractices lack real-time\\nmonitoring and efficient\\noperation on fields This leads\\nto inefficiencies and low\\nproduction levels.', 'Software', 'SIH1352', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment'], ['61', '', '', 'Go', 've', 'Using technology to develop a\\nmoving/mobile education\\nsystem/software or equipment\\nso that the children of\\nnomadic communities such as\\nBakarwals /Gujjars can have\\nproper education at least till\\nprimary.', 'Software', 'SIH1354', 'Smart\\nEducation'], ['', None, None, None, None, None, None, None, None], ['62', None, None, 'Government of\\nJammu and Kashmir', None, 'Developing solutions to\\neffective market linkage and\\npromotion of One District\\nOne Product.', 'Software', 'SIH1355', 'Heritage &\\nCulture']], [['63', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Sentiment Analysis of\\nIncoming calls on helpdesk', 'Software', 'SIH1356', 'Miscellaneous'], ['64', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Sentiment analysis of Social\\nMedia presence', 'Software', 'SIH1357', 'Miscellaneous'], ['65', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Image correctness for a\\nproduct on marketplace', 'Software', 'SIH1358', 'Miscellaneous'], ['66', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Contact center knowledge\\nmanagement tool with\\ndecision tree', 'Software', 'SIH1359', 'Smart\\nAutomation'], ['67', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Price comparison of GeM\\nproducts with other e-\\nmarketplaces', 'Software', 'SIH1360', 'Smart\\nAutomation'], ['68', None, None, 'Government of\\nGujarat', None, 'Student dropout analysis for\\nschool education', 'Software', 'SIH1362', 'Smart\\nEducation'], ['69', None, None, 'Government of\\nGujarat', None, 'Self-identifying the mental\\nhealth status and get guidance\\nfor support.', 'Software', 'SIH1363', 'Fitness &\\nSports'], ['70', None, None, 'Government of\\nGujarat', None, 'Fake Social Media Profile\\ndetection and reporting', 'Software', 'SIH1364', 'Blockchain &\\nCybersecurity'], ['71', '', '', 'Go', 've', 'Online Blockchain based\\ncertificate generation and\\nvalidation system for\\ngovernment organization.', 'Software', 'SIH1365', 'Blockchain &\\nCybersecurity'], ['', None, None, None, None, None, None, None, None], ['72', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Centralised Nasha Mukti\\nDatabase', 'Software', 'SIH1366', 'Miscellaneous'], ['73', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'To develop a technical\\nsolution for enabling\\nInstitution level verification\\nof students of one State\\nstudying in other State/s, who\\nare at present generally\\ndenied benefits under the\\nScholarship scheme as the\\nInstitutions in which they are\\nstudying are not registered on\\nthe portal/s of their home', 'Software', 'SIH1367', 'Smart\\nEducation'], ['74', None, None, 'Government of\\nJharkhand', None, 'State.\\nOnline integrated platform\\nfor projects taken up by the\\nstudents of various\\nuniversities/colleges', 'Software', 'SIH1369', 'Smart\\nEducation'], ['75', None, None, 'Government of\\nJharkhand', None, 'Real time monitoring of\\ninfrastructure development', 'Software', 'SIH1370', 'Smart\\nAutomation'], ['76', None, None, 'Government of\\nJharkhand', None, \"Community Based Reporting\\nand Monitoring Tool for\\nWomen's Safety in\\nColleges/Universities.\", 'Software', 'SIH1371', 'Miscellaneous']], [['77', None, None, 'Government of\\nJharkhand', None, 'development of systems for\\neffective Environmental,\\nSocial and Governance (ESG)\\nIntervention in Higher\\nEducation', 'Software', 'SIH1372', 'Renewable /\\nSustainable\\nEnergy'], ['78', None, None, 'Ministry of Power', None, 'Cloudburst prediction system', 'Software', 'SIH1374', 'Disaster\\nManagement'], ['79', None, None, 'Ministry of Power', None, 'Creation of Live Digital\\nTwins for the power Projects\\nand integration with all\\nexisting monitoring and\\ndatabase system which will\\ngive a holistic real time\\napproach to the project and\\nplant from all aspect of\\nconstruction, operation and', 'Software', 'SIH1377', 'Smart\\nAutomation'], ['80', None, None, 'Ministry of Power', None, 'maintenance.\\nSegregating and information\\non regulatory / Gofi.\\nPolicieVGuidelines/Office\\nMemorauda etc. related to\\nContract and Procurement\\nissues for proper compliance\\nand reporting of the same.', 'Software', 'SIH1378', 'Miscellaneous'], ['81', '', '', 'Mi', 'nis', 'Vegetation measurement\\nalong the line corridor using\\nsatellite imagery', 'Software', 'SIH1379', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment'], ['', None, None, None, None, None, None, None, None], ['82', None, None, 'Ministry of Power', None, 'lntelligent chatbot to answer\\nqueries pertaining to various\\nMaintenance Processes within\\nSubstation', 'Software', 'SIH1380', 'Smart\\nEducation'], ['83', None, None, 'Ministry of Power', None, 'Analysis and identification of\\nmalicious mobile applications', 'Software', 'SIH1381', 'Blockchain &\\nCybersecurity'], ['84', None, None, 'Govt of Himachal\\nPradesh', None, 'Real-Time Vehicle Tracking\\nsystem.', 'Software', 'SIH1382', 'Smart Vehicles'], ['85', None, None, 'Govt of Himachal\\nPradesh', None, 'Optimizing Doctor\\nAvailability and Appointment\\nAllocation in Hospitals\\nthrough Digital Technology\\nand Al Integration.', 'Software', 'SIH1383', 'MedTech /\\nBioTech /\\nHealthTech'], ['86', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Developing an interactive\\ngaming software / mobile\\napplication on Inteliectual\\nProperty Awareness for\\nschool students', 'Software', 'SIH1384', 'Smart\\nEducation'], ['87', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Developing a software that\\ncan translate resource\\nmaterial and other texts from\\nEnglish to other Indian\\nregional languages.', 'Software', 'SIH1385', 'Smart\\nEducation']], [['88', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, None, 'Developing a software for\\ndubbing of videos from\\nEnglish to other Indian\\nregional languages.', 'Software', 'SIH1386', 'Smart\\nEducation'], ['89', None, None, 'Ministry of power', None, None, 'Detection of Malwarei Trojan\\nin softwares used in Power\\nSector.', 'Software', 'SIH1388', 'Blockchain &\\nCybersecurity'], ['90', None, None, 'Ministry of power', None, None, \"To develop centralised\\ninformation security .Log-\\ncollection facility' or 'security\\noperation centre (soc)' in the\\npower sector, considering\\ncEA cybersecurity (Power\\nsector) Guidelines, 2021to\\nkeep lr and or networking\\nSystem isolated and air-\\ngapped.\", 'Software', 'SIH1389', 'Blockchain &\\nCybersecurity'], ['91', '10', '', 'Mi\\nEn', 'nis\\nvir', 'try of\\nonment', 'Pro Planet Person App', 'Software', 'SIH1390', 'Clean & Green\\nTechnology'], ['92', None, None, 'Ministry of\\nEnvironment', None, None, 'Behavioural change\\nmonitoring software', 'Software', 'SIH1391', 'Smart\\nAutomation'], ['93', None, None, 'Ministry of\\nEnvironment', None, None, 'E-Waste Facility Locator', 'Software', 'SIH1392', 'Smart\\nAutomation'], ['94', None, None, 'Ministry of\\nEnvironment', None, None, 'Water and Electricity\\nTracking App', 'Software', 'SIH1393', 'Smart\\nAutomation'], ['95', None, None, 'Ministry of\\nEnvironment', None, None, 'Virtual Zoo', 'Software', 'SIH1394', 'Smart\\nEducation'], ['96', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'IoT based sensors can be used\\nto determine the Machine\\nRuntime', 'Software', 'SIH1395', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment'], ['97', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'Developing Virtual Reality\\nbased solutions', 'Software', 'SIH1396', 'Disaster\\nManagement'], ['98', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'Development of business\\nmodels for collection and\\nutilization of single usc\\nplastics and various other\\nindustrial wastes', 'Software', 'SIH1397', 'MedTech /\\nBioTech /\\nHealthTech'], ['99', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'lntegration and Utilization of\\ndata-based being maintained\\nby various\\nMinistries/Departments for\\nbetter utilization of raw\\nmaterials and production\\ncapacity.', 'Software', 'SIH1398', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment'], ['100', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'App-Based Solution to\\nidentify and solve disease in\\nplants/crops', 'Software', 'SIH1401', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']], [['10', '1', '', 'Mi', 'nis', 'Ear Electronic Device for\\nTinnitus Frequency Finding\\nand Adjusting to Provide\\nRelief to Tinnitus Suffering\\nPatient', 'Software', 'SIH1402', 'MedTech /\\nBioTech /\\nHealthTech'], ['', None, None, None, None, None, None, None, None], ['102', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'APP Based Digital\\nAudiometer', 'Software', 'SIH1403', 'MedTech /\\nBioTech /\\nHealthTech'], ['103', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Develop therapy materials in\\nHindi for misarticulation\\nchildren', 'Software', 'SIH1405', 'MedTech /\\nBioTech /\\nHealthTech'], ['104', None, None, 'Ministry of Home\\nAffairs', None, 'Chatbot based helpdesk for\\ngovt employees and\\ndepartments', 'Software', 'SIH1407', 'Smart\\nAutomation'], ['105', None, None, 'Ministry of Home\\nAffairs', None, 'IT System log analyzer', 'Software', 'SIH1408', 'Blockchain &\\nCybersecurity'], ['106', None, None, 'Ministry of Home\\nAffairs', None, 'AI based IT training system', 'Software', 'SIH1409', 'Smart\\nEducation'], ['107', None, None, 'Ministry of Home\\nAffairs', None, 'Augmented/ Virtual reality\\nsystem for the live training of\\ntroops', 'Software', 'SIH1410', 'Smart\\nAutomation'], ['108', None, None, 'Ministry of Home\\nAffairs', None, 'Simulator system for counter\\nHijack and sky Marshalling\\noperations', 'Software', 'SIH1411', 'Blockchain &\\nCybersecurity'], ['109', None, None, 'Ministry of Home\\nAffairs', None, 'Data Compression for\\nbackbone network', 'Software', 'SIH1412', 'Blockchain &\\nCybersecurity'], ['110', None, None, 'Ministry of\\nCommunications', None, 'Dak Ghar Niryat Kendra', 'Software', 'SIH1413', 'Transportation\\n& Logistics'], ['11', '1', '', 'Mi', 'nis', 'Development of motion\\namplification video\\ntechniques for vibration\\nanalysis', 'Software', 'SIH1415', 'Smart\\nAutomation'], ['', None, None, None, None, None, None, None, None], ['112', None, None, 'Ministry of Defence', None, 'AI based Automatic alarm\\ngeneration and dropping of\\npayload at a particular object\\nthrough a Drone.', 'Software', 'SIH1416', 'Disaster\\nManagement'], ['113', None, None, 'Ministry of Defence', None, 'AI-ML based intelligent de-\\nsmoking/de-hazing algorithm', 'Software', 'SIH1417', 'Disaster\\nManagement'], ['114', None, None, 'Ministry of Defence', None, 'Deep learning for terrain\\nrecognition', 'Software', 'SIH1418', 'Miscellaneous'], ['115', None, None, 'Ministry of Defence', None, 'Robust human target\\ndetection and acquisition', 'Software', 'SIH1419', 'Miscellaneous'], ['116', None, None, 'Ministry of Defence', None, 'Lean module for reasoning\\nabout computational\\ncomplexity in GPTs.', 'Software', 'SIH1420', 'Miscellaneous'], ['117', None, None, 'Ministry of Defence', None, 'Novel Technologies for Early\\nDetection and Mitigation of\\nAvalanches', 'Software', 'SIH1421', 'Disaster\\nManagement'], ['118', None, None, 'Ministry of Defence', None, 'Devise the method for\\nidentification of victims\\nburied under avalanches.', 'Software', 'SIH1422', 'Disaster\\nManagement'], ['119', None, None, 'Ministry of Jal\\nShakti', None, 'Web /Mobile based tool for\\nmapping of Water supply\\nnetwork', 'Software', 'SIH1423', 'Miscellaneous']], [['120', None, None, 'Ministry of Rural\\nDevelopment', None, \"AR/VR based application\\nwhich helps visualize the\\ncomplete house virtually at an\\nearly stage, which can help in\\ncost estimation, planning and\\ncompletion of the house in\\ntime'\", 'Software', 'SIH1428', 'Smart\\nAutomation'], ['12', '1', '', 'Mi', 'nis', 'Develop a solution to identifo\\ndiscrepancies in Quality\\nMonitoring Data on OMMAS\\nand generate reports that\\nhighlight areas where\\ncorrective action is Required.', 'Software', 'SIH1429', 'Smart\\nAutomation'], ['', None, None, None, None, None, None, None, None], ['122', None, None, 'Ministry of\\nEducation', None, 'Online personalized learning\\nremediation/tutoring tool.\\nSearch for best teacher for\\nspecific topics.', 'Software', 'SIH1431', 'Smart\\nEducation'], ['123', None, None, 'Ministry of\\nEducation', None, 'Identify slow learners for\\nremedial teaching and\\ncapacity building for\\ninnovative methods.', 'Software', 'SIH1432', 'Smart\\nEducation'], ['124', None, None, 'Ministry of\\nEducation', None, 'Mental health and well-being\\nsurveillance, assessment and\\ntracking solution among\\nchildren.', 'Software', 'SIH1433', 'Smart\\nEducation'], ['125', None, None, 'Ministry of\\nEducation', None, 'Making career choices and AI\\nbased counselling accessible\\nto every child at secondary\\nlevel along with aptitude tests\\nand detailed career paths.', 'Software', 'SIH1434', 'Smart\\nEducation'], ['126', None, None, 'Ministry of Rural\\nDevelopment', None, 'Developing an algotithim /\\nprogramme to measure\\nincrease in income of FPOs\\non account of project\\ninterventions under WDC 2.0.', 'Software', 'SIH1435', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment'], ['127', None, None, 'Ministry of Rural\\nDevelopment', None, 'Number of persons benefitted\\nfrom using the Water\\nHarvesting Structures (WHS)\\ncreated / rejuvenated in the\\nproject areas under WDC 2.0\\nfor economic activities like\\nfisheries etc for alternate\\nsource of income generation.', 'Software', 'SIH1436', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment'], ['128', None, None, 'Ministry of Rural\\nDevelopment', None, 'Development of suitable\\nSoftware and Hardware\\ncomponents/sensors for\\nspringshed mapping,\\nmonitoring and management.', 'Software', 'SIH1437', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']], [['129', None, None, 'Ministry of Home\\nAffairs', None, 'Virtual Reality-Based\\nTraining for CBRN Disaster\\nResponse', 'Software', 'SIH1438', 'Disaster\\nManagement'], ['130', None, None, 'Ministry of Home\\nAffairs', None, 'An application under which\\nall rescue agencies are\\nregistered and which can\\ndisplay the location of other\\nrescue relief agencies during\\nnatural/ man made calamities', 'Software', 'SIH1440', 'Disaster\\nManagement'], ['13', '1', '', 'Ba', 'jaj', 'Similar Document Template\\nMatching Algorithm', 'Software', 'SIH1441', 'Miscellaneous'], ['', None, None, None, None, None, None, None, None], ['132', None, None, 'Autodesk Education\\nExperience', None, 'Students to use Autodesk\\nFusion 360 to research and\\nredesign a conventional\\nautomotive component\\ncommonly found in vehicles\\nand utilize generative design\\nto reimagine its design. For\\nadditional information and\\ndetailed problem statement,\\nplease visit:\\nhttps://damassets.autodesk.net\\n/content/dam/autodesk/www/p\\ndfs/sih-2023-hardware-\\nedition-additive-\\nmanufacturing.pdf', 'Software', 'SIH1442', 'Smart Vehicles'], ['133', None, None, 'Autodesk Education\\nExperience', None, 'Students to use Autodesk\\nFusion 360 to research and to\\ngenerate NC code with\\nmachine details and tool\\nlibrary for any industrial\\ncomponent. For additional\\ninformation and detailed\\nproblem statement, please\\nvisit:\\nhttps://damassets.autodesk.net\\n/content/dam/autodesk/www/p\\ndfs/sih-2023-hardware-', 'Software', 'SIH1443', 'Smart\\nAutomation'], ['134', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'edition-cnc.pdf\\nDe-anonymisation for\\nmonitoring and tracking of\\nillegal activities performed\\nusing cryptocurrency\\ntransaction technology', 'Software', 'SIH1445', 'Blockchain &\\nCybersecurity'], ['135', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Developing a GUI based\\nhardening script for Ubuntu\\noperating system with\\nflexibility to cater for\\norganisational security\\npolicies', 'Software', 'SIH1446', 'Miscellaneous']], [['136', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Identification and Extraction\\nof Forward Error Correction\\n(FEC) schemes of unknown\\ndemodulated signals', 'Software', 'SIH1447', 'Miscellaneous'], ['137', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Design, develop and\\nimplement a software bill of\\nmaterials (SBOM) generation\\ntool that can generate the\\ncomplete SBOM of custom-\\ndeveloped software (including\\nin-house developments by\\norganisations)', 'Software', 'SIH1449', 'Smart\\nAutomation'], ['138', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Develop and deploy a Large\\nLanguage Model (LLM)\\nbased tool for generating\\nhuman like responses to\\nnatural language inputs for\\nnetwork not connected over\\ninternet', 'Software', 'SIH1450', 'Smart\\nAutomation'], ['139', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Develop a AI/ML tool to\\ndetect whether a system /\\nfirewall /router / network is\\ncompromised. The technique\\nshould not rely only on IoCs\\n(Indicators of Compromises)\\ndetection.', 'Software', 'SIH1451', 'Blockchain &\\nCybersecurity'], ['140', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Develop Ransomware\\nReadiness Assessment tool.', 'Software', 'SIH1452', 'Blockchain &\\nCybersecurity'], ['14', '1', '', 'Na', 'tio', 'Investigation of\\nvulnerabilities in\\nimplementation of crypto\\nlibrary used by OpenVPN for\\nInternet Protocol Security\\n(IPsec), IPV6 deployment.', 'Software', 'SIH1453', 'Blockchain &\\nCybersecurity'], ['', None, None, None, None, None, None, None, None], ['142', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Create an intelligent system\\nusing AI/ML to detect\\nphishing domains which\\nimitate look and feel of\\ngenuine domains', 'Software', 'SIH1454', 'Blockchain &\\nCybersecurity'], ['143', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Efficient enumeration of\\nURLs of active hidden servers\\nover anonymous channel\\n(TOR)', 'Software', 'SIH1455', 'Blockchain &\\nCybersecurity']], [['144', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Speech to text transcription\\nfor Indian languages. The\\nproblem entails transcription\\nin the native script and then\\ntranslation to English. The\\nlanguages of interest are\\nHindi, Indian English, Urdu,\\nBengali, Punjabi.', 'Software', 'SIH1456', 'Miscellaneous'], ['145', None, None, 'MathWorks India\\nPrivate Limited', None, 'Get Fit Faster with a High-\\nTech Tracker: Analyze\\nHuman Activity and GPS\\nData for Improved Results', 'Software', 'SIH1457', 'Smart\\nAutomation'], ['146', None, None, 'AICTE', None, 'AI Based - Designing of\\nAssistive portal for\\nStakeholders in Approval\\nProcess', 'Software', 'SIH1458', 'Miscellaneous'], ['147', None, None, 'AICTE', None, 'Integration of Multiple Data-\\nbases of AICTE in order to\\nfetch Coherent Information', 'Software', 'SIH1459', 'Miscellaneous'], ['148', None, None, 'AICTE', None, 'Integration of AI for Adaptive\\nLearning for MCQ Selection\\nin PARAKH', 'Software', 'SIH1460', 'Smart\\nAutomation'], ['149', None, None, 'AICTE', None, 'Cybersecurity Portal for\\nEffective Management of\\nServers and Firewalls', 'Software', 'SIH1461', 'Blockchain &\\nCybersecurity'], ['150', None, None, 'Ministry of Home\\nAffairs', None, 'Awareness and Preparedness\\nTowards Disaster\\nManagement', 'Software', 'SIH1462', 'Disaster\\nManagement'], ['15', '1', '', 'AI', 'CT', 'Establishing a Server log\\nsystem for E-governance with\\nappropriate notification and\\ncontent based classification of\\nlog AICTE', 'Software', 'SIH1463', 'Miscellaneous'], ['', None, None, None, None, None, None, None, None], ['152', None, None, 'AICTE', None, 'Design and Developed a\\npersonalized online meeting\\nsystem for AICTE', 'Software', 'SIH1464', 'Blockchain &\\nCybersecurity'], ['153', None, None, 'AICTE', None, 'A unified portal for\\ndeveloping a model\\nCurriculum for all the AICTE\\nApproved Institutes', 'Software', 'SIH1465', 'Miscellaneous'], ['154', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1467', 'Smart\\nEducation'], ['155', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1468', 'Disaster\\nManagement'], ['156', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1483', 'Miscellaneous'], ['157', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1484', 'Blockchain &\\nCybersecurity'], ['158', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1485', 'Renewable /\\nSustainable\\nEnergy'], ['159', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1486', 'Transportation\\n& Logistics']], [['160', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1487', 'Clean & Green\\nTechnology'], ['16', '1', '', 'AI', 'CT', 'Student Innovation', 'Software', 'SIH1488', 'Robotics and\\nDrones'], ['', None, None, None, None, None, None, None, None], ['162', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1489', 'Transportation\\n& Logistics'], ['163', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1490', 'Smart Vehicles'], ['164', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1491', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment'], ['165', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1492', 'MedTech /\\nBioTech /\\nHealthTech'], ['166', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1493', 'Heritage &\\nCulture'], ['167', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1494', 'Fitness &\\nSports'], ['168', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1495', 'Smart\\nAutomation'], ['169', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1496', 'Toys & Games'], ['170', None, None, 'AICTE, MIC', None, 'Develop a Proctored exam\\ntool for shortlisting the\\ncandidates for the national\\nand international level\\nhackathons.', 'Software', 'SIH1498', 'Smart\\nAutomation'], ['17', '1', '', 'Go', 've', 'Education ecosystem for\\nspecially abled student need\\nprovision and improvement to\\ntake care of compliance,\\ngovernance and conduct.', 'Software', 'SIH1500', 'Smart\\nEducation'], ['', None, None, None, None, None, None, None, None], ['172', None, None, 'Ministry of AYUSH', None, 'Development of Virtual\\nReality (VR) technology for\\nDhatuposhana Nyaya', 'Software', 'SIH1501', 'MedTech /\\nBioTech /\\nHealthTech'], ['173', None, None, 'Government of\\nJharkhand', None, 'Blended Learning to\\novercome inadequate\\ninfrastructure', 'Software', 'SIH1502', 'Smart\\nEducation'], ['174', None, None, 'Government of\\nJharkhand', None, 'Capacity building,\\nperformance assessment and\\nmotivation driven tool for\\nfaculty upgradation', 'Software', 'SIH1504', 'Smart\\nEducation'], ['175', None, None, 'Ministry of Home\\nAffairs', None, 'Areal Location of Hazardous\\nAtmosphere in Industries', 'Software', 'SIH1505', 'Disaster\\nManagement'], ['176', None, None, 'Ministry of Ports,\\nShipping and\\nWaterways', None, 'Leveraging the power of deep\\nlearning to overcome the\\nchallenges of marine\\nengineering and improve\\nvessel operations:', 'Software', 'SIH1506', 'Smart\\nAutomation']], [['177', None, None, 'Ministry of Power', None, \"Creation of dedicated real\\ntime 'Procurement Data\\nPortal'as well as 'Vendor\\nPayment Data portal'to\\ncapture all related data in\\nrespect of NEEPCO,S\\nProcurements and Payments'\\nincluding Procurement from\\nMSE Sector and procurement\\nin GeM Portal\", 'Software', 'SIH1508', 'Miscellaneous'], ['178', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, 'App-Based Solution to\\nprovide market access to\\nmicro and small enterprises', 'Software', 'SIH1509', 'Miscellaneous'], ['179', None, None, 'Ministry of Rural\\nDevelopment', None, 'Land profiling of Asset\\nCreation process', 'Software', 'SIH1510', 'Miscellaneous'], ['180', None, None, 'Ministry of Housing\\nand Urban Affairs', None, 'Comprehensive lnspection\\nand Analysis of Water Supply\\nDistribution Lines', 'Software', 'SIH1514', 'Clean & Green\\nTechnology'], ['18', '1', '', 'Mi', 'nis', 'Smart and Effective realtime\\nManagement of street parking', 'Software', 'SIH1515', 'Smart\\nAutomation'], ['', None, None, None, None, None, None, None, None], ['182', None, None, 'Ministry of Housing\\nand Urban Affairs', None, 'Suggest an Al-based solution\\nto enable ease of grievance\\nlodging and tracking for\\ncitizens across multiple\\ndepartments', 'Software', 'SIH1516', 'Smart\\nAutomation']], [['', '']]]\n"
     ]
    }
   ],
   "source": [
    "tables=[]\n",
    "for page in pdf.pages:\n",
    "    table=page.extract_table()\n",
    "    tables.append(table)\n",
    "print(tables)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "True\n"
     ]
    }
   ],
   "source": [
    "from collections.abc import Iterable\n",
    "def is_iterable(obj):\n",
    "    return isinstance(obj,Iterable)\n",
    "print(is_iterable(tables))\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Thus table is something which is iterable so,"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Lets see the structure of tables list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Length of table is 17\n"
     ]
    }
   ],
   "source": [
    "print(\"Length of table is\",len(tables))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The length was expected to be 17 due to 0 to 16 pages present"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Length of each subli"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[15, 11, 8, 13, 11, 12, 15, 12, 13, 21, 10, 8, 9, 17, 19, 7, 1]\n"
     ]
    }
   ],
   "source": [
    "sub_lengths=[len(sublist) for sublist in tables]\n",
    "print(sub_lengths)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['', '10', '', '', '', 'Organization', 'Problem Statement Title', 'Category', 'PS Number', 'Domain Bucket']\n",
      "['1', None, None, 'Ministry of\\nChemicals and\\nFertilizers', None, None, 'International Comparative\\nSystem to Launch Integrated\\nReal-Time Data Management\\nSystem (IDMS) for Chemical\\nand Petrochemicals Sector.', 'Software', 'SIH1278', 'Miscellaneous']\n",
      "['2', None, None, 'Ministry of Law and\\nJustice', None, None, 'Development of software for\\nstreamlining the listing of\\ncases through Differentiated\\nCase Flow Management', 'Software', 'SIH1279', 'Miscellaneous']\n",
      "['3', None, None, 'Ministry of Law and\\nJustice', None, None, 'Development of e-Portal for\\nfacilitating Case Management\\nHearing of various types of\\ncases', 'Software', 'SIH1280', 'Miscellaneous']\n",
      "['4', None, None, 'Ministry of Law and\\nJustice', None, None, \"Development of gamified\\nplatform on Children's Rights\\nto increase legal literacy and\\nawareness among children in\\nIndia\", 'Software', 'SIH1281', 'Smart\\nEducation']\n",
      "['5', None, None, 'Ministry of Law and\\nJustice', None, None, 'Tech-Driven Solutions for\\nUndertrial Prisoners in India', 'Software', 'SIH1282', 'Miscellaneous']\n",
      "['6', None, None, 'Ministry of Law and\\nJustice', None, None, 'Digital Assistant for Legal\\nAwareness and Designing a\\nKYC framework in India', 'Software', 'SIH1283', 'Smart\\nEducation']\n",
      "['7', None, None, 'Ministry of Law and\\nJustice', None, None, 'Developing a Blockchain-\\nBased eVault for Legal\\nRecords', 'Software', 'SIH1284', 'Blockchain &\\nCybersecurity']\n",
      "['8', None, None, 'Ministry of Law and\\nJustice', None, None, 'AI-powered Legal\\nDocumentation Assistant', 'Software', 'SIH1285', 'Miscellaneous']\n",
      "['9', None, None, 'Ministry of Law and\\nJustice', None, None, 'Incentives based Design for\\nonboarding Legal Service\\nProviders such as Advocates,\\nArbitrators, Mediators,\\nNotaries, Document Writers,\\netc on eMarket Place for\\nextending Legal Services to\\nCitizens in India', 'Software', 'SIH1286', 'Miscellaneous']\n",
      "['10', None, None, 'Ministry of Jal\\nShakti', None, None, 'Use of Digital Technology to\\ncalculate water footprints for\\ndifferent daily use items.', 'Software', 'SIH1287', 'Clean & Green\\nTechnology']\n",
      "['', None, None, '', None, None, '', '', '', '']\n",
      "['11', '', '', 'Mi', 'nis', None, 'Use of Digital Technology in\\naddressing Non-Revenue\\nWater (NRW)', 'Software', 'SIH1288', 'Clean & Green\\nTechnology']\n",
      "['', None, None, None, None, None, None, None, None, None]\n",
      "['12', None, None, 'Ministry of Jal\\nShakti', None, None, 'Projection of the extent of\\ninundation corresponding to\\nthe forecasts of flood levels in\\na river.', 'Software', 'SIH1289', 'Disaster\\nManagement']\n",
      "['13', None, None, 'Ministry of Jal\\nShakti', None, 'Development of AI, ML and\\nChat boat-powered Interactive\\nRobot Mascot (Chacha\\nChaudhary) and digital avatar\\nto strengthen the river people\\nconnect component of\\nNamami Gange.', 'Software', 'SIH1290', 'Smart\\nEducation']\n",
      "['14', None, None, 'Ministry of Jal\\nShakti', None, 'A mobile app that crowd\\nsources water-related\\nproblems from around a\\ncommunity, open sources\\ndata, etc. and display them on\\na map.', 'Software', 'SIH1291', 'Disaster\\nManagement']\n",
      "['15', None, None, 'Ministry of Jal\\nShakti', None, 'AI-enabled water well\\npredictor', 'Software', 'SIH1292', 'Clean & Green\\nTechnology']\n",
      "['16', None, None, 'Ministry of power', None, 'Dashboard for real-time\\nmonitoring of construction\\nprojects.', 'Software', 'SIH1295', 'Transportation\\n& Logistics']\n",
      "['17', None, None, 'Ministry of power', None, 'Al-based Generative design of\\nHydro power plants.', 'Software', 'SIH1296', 'Renewable /\\nSustainable\\nEnergy']\n",
      "['18', None, None, 'Ministry of power', None, 'Al Based Drone Application', 'Software', 'SIH1297', 'Robotics and\\nDrones']\n",
      "['19', None, None, 'Ministry of power', None, 'Language translator tool to\\nconvert English to Hindi\\n(official Language) which can\\nbe used by all the government\\norganizations websites\\nofficially.', 'Software', 'SIH1301', 'Smart\\nAutomation']\n",
      "['20', None, None, 'Ministry of Power', None, 'Design of CYBER-\\nSECURITY ENABLED\\nSMART CONTROLLER for\\ngrid-connected Microgrid', 'Software', 'SIH1302', 'Blockchain &\\nCybersecurity']\n",
      "['21', '', '', 'Go', 've', 'PGRKAM web application (\\nwww.pgrkam.com) and the\\nPGRKAM Android\\napplication of the Punjab\\nGovernment provides\\nemployment data to the\\nprospective candidates.', 'Software', 'SIH1303', 'Miscellaneous']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['22', None, None, 'Government of\\nPunjab', None, 'PGRKAM web application (\\nwww.pgrkam.com) and the\\nPGRKAM Android\\napplication of the Punjab\\nGovernment provides\\nemployment data to the\\nprospective candidates. The\\nplatform has a sizeable\\nnumber of user base but it\\nlacks integrated analytics\\ntools to understand how the\\nusers are consuming the', 'Software', 'SIH1304', 'Miscellaneous']\n",
      "['23', 'Government of\\nPunjab', 'The Employment Department\\nat present has a digital\\nplatform www.pgrkam.com\\nand its mobile application to\\nprovide almost all services\\noffered to job seekers and\\nemployers through digital\\nmeans. The portal has\\nmultiple modules like private\\nsector jobs, government jobs,\\nself-employment avenues,\\nforeign jobs, foreign study,\\ncounseling, guidance,\\ninduction into armed forces,\\njob melas, etc. Currently,\\nwhen a user visits the\\nportal/app, there is no hand-\\nholding mechanism to help\\nthe user get to the part of the\\ndigital platform which will\\nresolve his queries. The user\\nis required to navigate across\\nmultiple modules on the\\nportal/ app to search for\\nanswers.', 'Software', 'SIH1305', 'Smart\\nAutomation']\n",
      "['24', 'Ministry of Social\\nJustice and\\nEmpowerment', 'Computerized cognitive\\nRetraining Program for Home\\ntraining of Children with\\nDisabilities.', 'Software', 'SIH1307', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['25', 'Ministry of Home\\nAffairs', 'Threat zone of an explosion\\nparticularly in oil and gas\\nhandling industries or\\nrefineries', 'Software', 'SIH1308', 'Disaster\\nManagement']\n",
      "['26', 'Ministry of Textiles', 'Application Development for\\nmonitoring of wool from\\nFarm to fabric', 'Software', 'SIH1309', 'Transportation\\n& Logistics']\n",
      "['27', 'Ministry of Ports,\\nShipping and\\nWaterways', 'Dredging Analysis and\\nDecision Support System.', 'Software', 'SIH1311', 'Transportation\\n& Logistics']\n",
      "['28', 'Ministry of coal', 'Chatbot to respond to text\\nqueries pertaining to various\\nActs, Rules, and Regulations\\napplicable to Mining\\nindustries', 'Software', 'SIH1312', 'Smart\\nAutomation']\n",
      "['29', 'Ministry of coal', 'Real-time visibility of\\nDumper load status to Shovel\\noperator', 'Software', 'SIH1314', 'Smart\\nAutomation']\n",
      "['30', 'Ministry of coal', 'Application of Image\\nAnalytics for Tree\\nenumeration for diversion of\\nForest Land.', 'Software', 'SIH1316', 'Miscellaneous']\n",
      "['31', '', '', 'Mi', 'nis', 'Development of a Digital\\nPlatform for multi-modal\\nvisibility of coal transportation', 'Software', 'SIH1317', 'Smart\\nAutomation']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['32', None, None, 'Ministry of coal', None, 'Analytics based on Govt.\\nLand Information\\nSystem(GLIS) Data', 'Software', 'SIH1318', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['33', None, None, 'Ministry of coal', None, 'Forecasting and scheduling of\\nrailway rakes.', 'Software', 'SIH1319', 'Smart\\nAutomation']\n",
      "['34', None, None, 'Ministry of coal', None, 'In-cab smart guidance and\\nsupport system for Dragline\\nOperator', 'Software', 'SIH1320', 'Smart Vehicles']\n",
      "['35', None, None, 'Ministry of\\nChemicals and\\nFertilizers', None, 'Compilation and Collection\\nof optimum Level (variable)\\nof data set from the Chemical\\nand Petrochemical Industries\\nin the country, aiming to\\nsmoothen the decision-\\nmaking and insight\\ngeneration in the strategic', 'Software', 'SIH1321', 'Smart\\nAutomation']\n",
      "['36', None, None, 'Government of\\nKerala', None, 'initiative.\\nDomestic Waste Management', 'Software', 'SIH1322', 'Clean & Green\\nTechnology']\n",
      "['37', None, None, 'Government of\\nKerala', None, 'Air and water quality index\\nand environment monitoring', 'Software', 'SIH1324', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['38', None, None, 'Government of\\nKerala', None, 'AI Assisted Tele-medicine\\nKIOSK for Rural India', 'Software', 'SIH1325', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['39', None, None, 'Government of\\nKerala', None, 'Ideate and implement a\\nsystem to enhance the quality\\nof education in rural areas.', 'Software', 'SIH1326', 'Smart\\nEducation']\n",
      "['40', None, None, 'Ministry of\\nInformation and\\nBroadcasting', None, '360-degree feedback software\\nfor the Government of India\\nrelated News Stories in\\nRegional Media using\\nArtificial Intelligence /\\nMachine Learning', 'Software', 'SIH1329', 'Smart\\nAutomation']\n",
      "['41', '10', '', 'Mi', 'nis', 'Text to Video of various PIB\\nPress Releases using\\nArtificial Intelligence /\\nMachine Learning /\\nGenerative Adversarial\\nNetworks in English and 13\\nRegional Languages viz.\\nHindi, Urdu, Punjabi,\\nGujarati, Marathi, Telugu,\\nKannada, Malayalam, Tamil,\\nOdia, Bengali, Assamese and', 'Software', 'SIH1330', 'Smart\\nAutomation']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['42', None, None, 'Ministry of\\nInformation and\\nBroadcasting', None, 'A complete Digital Marketing\\nsolution for visible increase in\\nonline sale of\\nDPDÃƒÂ¢Ã¢â€šÂ¬Ã¢â€žÂ¢\\ns journals and Employment\\nNews issues through various\\navailable/new online sale\\nchannels (like website, apps ,\\namazon, social media) by\\noptimising various available\\nor new digital marketing tools\\nlike email marketing, SEO,\\nanalytics, etc., subject to\\nsuitability, sustainability and\\ncost-effectiveness.', 'Software', 'SIH1331', 'Miscellaneous']\n",
      "['43', None, None, 'Rashtriya Ispat\\nNigam Limited,\\nVisakhapatnam\\nSteel Plant', None, 'Hot metal, Steel Ladle, and\\nScrap pot Tracking by auto-\\ncapturing the Ladle number\\nand locations at SMS-1 and\\nSMS-2.', 'Software', 'SIH1332', 'Transportation\\n& Logistics']\n",
      "['44', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Udyog Saarthi App -\\n(Progressive Web-based\\nApplication) for Adults\\nundergoing Job coaching for\\nopportunities under 4%\\nreservation in NIEPMD and\\nother Institutions.', 'Software', 'SIH1333', 'Smart\\nAutomation']\n",
      "['45', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Software for intervention of\\nspeech sound disorders in\\nHindi and English.', 'Software', 'SIH1334', 'Smart\\nEducation']\n",
      "['46', None, None, 'Ministry of Mines', None, 'Unpredictable failure of poly\\npulleys along cable belt\\nconveyor system for pulley\\nchanging', 'Software', 'SIH1338', 'Transportation\\n& Logistics']\n",
      "['47', None, None, 'Ministry of Mines', None, 'Automation of drill core rock\\nsample lithology logging.', 'Software', 'SIH1339', 'Transportation\\n& Logistics']\n",
      "['48', None, None, 'Ministry of AYUSH', None, 'Application for Assessment of\\nQuality of Textbook/\\nReference Books/ E- Book', 'Software', 'SIH1340', 'Smart\\nEducation']\n",
      "['49', None, None, 'Ministry of AYUSH', None, 'PG dissertation Management\\nSystem Description.', 'Software', 'SIH1341', 'Smart\\nEducation']\n",
      "['50', None, None, 'Ministry of AYUSH', None, 'Development of a prototype\\ninstrument (sensor based) for\\nassessment and quantification\\nof rasas (taste) in crude herbs.', 'Software', 'SIH1342', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['51', '', '', 'Mi', 'nis', 'Identification of Different\\nMedicinal Plants/Raw\\nmaterials through Image\\nProcessing Using Machine\\nLearning Algorithms', 'Software', 'SIH1343', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['52', None, None, 'Ministry of AYUSH', None, 'Al-based tool for preliminary\\ndiagnosis of Dermatological\\nmanifestations', 'Software', 'SIH1344', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['53', None, None, 'Ministry of AYUSH', None, 'Startup-AYUSH Portal', 'Software', 'SIH1345', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['54', None, None, 'Ministry of AYUSH', None, 'Chatbot to Known Individual\\nPrakriti (Phenotype)', 'Software', 'SIH1346', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['55', None, None, 'Ministry of AYUSH', None, 'A software that suggests\\ndrugs and formulations for a\\ndisease/pharmacological\\nproperty based on the\\nAyurvedic classical\\nbooks/Repositories.', 'Software', 'SIH1347', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['56', None, None, 'Ministry of Railways', None, 'Natural language translation\\nengine for announcements\\nand information\\ndissemination at stations', 'Software', 'SIH1348', 'Smart\\nAutomation']\n",
      "['57', None, None, 'Ministry of Railways', None, 'Using existing CCTV\\nnetwork for crowd\\nmanagement, crime\\nprevention, and work\\nmonitoring using AIiML', 'Software', 'SIH1349', 'Smart\\nAutomation']\n",
      "['58', None, None, 'Government of\\nJammu and Kashmir', None, 'Artificial Intelligence Driven\\nDigitization of Cadastral\\nMaps', 'Software', 'SIH1350', 'Smart\\nAutomation']\n",
      "['59', None, None, 'Government of\\nJammu and Kashmir', None, 'Digital Generator Monitoring\\nDiesel generators are widely\\nused as backup power sources\\nin industries, homes, and\\nremote locations', 'Software', 'SIH1351', 'Smart\\nAutomation']\n",
      "['60', None, None, 'Government of\\nJammu and Kashmir', None, 'Traditional agriculture\\npractices lack real-time\\nmonitoring and efficient\\noperation on fields This leads\\nto inefficiencies and low\\nproduction levels.', 'Software', 'SIH1352', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['61', '', '', 'Go', 've', 'Using technology to develop a\\nmoving/mobile education\\nsystem/software or equipment\\nso that the children of\\nnomadic communities such as\\nBakarwals /Gujjars can have\\nproper education at least till\\nprimary.', 'Software', 'SIH1354', 'Smart\\nEducation']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['62', None, None, 'Government of\\nJammu and Kashmir', None, 'Developing solutions to\\neffective market linkage and\\npromotion of One District\\nOne Product.', 'Software', 'SIH1355', 'Heritage &\\nCulture']\n",
      "['63', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Sentiment Analysis of\\nIncoming calls on helpdesk', 'Software', 'SIH1356', 'Miscellaneous']\n",
      "['64', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Sentiment analysis of Social\\nMedia presence', 'Software', 'SIH1357', 'Miscellaneous']\n",
      "['65', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Image correctness for a\\nproduct on marketplace', 'Software', 'SIH1358', 'Miscellaneous']\n",
      "['66', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Contact center knowledge\\nmanagement tool with\\ndecision tree', 'Software', 'SIH1359', 'Smart\\nAutomation']\n",
      "['67', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Price comparison of GeM\\nproducts with other e-\\nmarketplaces', 'Software', 'SIH1360', 'Smart\\nAutomation']\n",
      "['68', None, None, 'Government of\\nGujarat', None, 'Student dropout analysis for\\nschool education', 'Software', 'SIH1362', 'Smart\\nEducation']\n",
      "['69', None, None, 'Government of\\nGujarat', None, 'Self-identifying the mental\\nhealth status and get guidance\\nfor support.', 'Software', 'SIH1363', 'Fitness &\\nSports']\n",
      "['70', None, None, 'Government of\\nGujarat', None, 'Fake Social Media Profile\\ndetection and reporting', 'Software', 'SIH1364', 'Blockchain &\\nCybersecurity']\n",
      "['71', '', '', 'Go', 've', 'Online Blockchain based\\ncertificate generation and\\nvalidation system for\\ngovernment organization.', 'Software', 'SIH1365', 'Blockchain &\\nCybersecurity']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['72', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Centralised Nasha Mukti\\nDatabase', 'Software', 'SIH1366', 'Miscellaneous']\n",
      "['73', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'To develop a technical\\nsolution for enabling\\nInstitution level verification\\nof students of one State\\nstudying in other State/s, who\\nare at present generally\\ndenied benefits under the\\nScholarship scheme as the\\nInstitutions in which they are\\nstudying are not registered on\\nthe portal/s of their home', 'Software', 'SIH1367', 'Smart\\nEducation']\n",
      "['74', None, None, 'Government of\\nJharkhand', None, 'State.\\nOnline integrated platform\\nfor projects taken up by the\\nstudents of various\\nuniversities/colleges', 'Software', 'SIH1369', 'Smart\\nEducation']\n",
      "['75', None, None, 'Government of\\nJharkhand', None, 'Real time monitoring of\\ninfrastructure development', 'Software', 'SIH1370', 'Smart\\nAutomation']\n",
      "['76', None, None, 'Government of\\nJharkhand', None, \"Community Based Reporting\\nand Monitoring Tool for\\nWomen's Safety in\\nColleges/Universities.\", 'Software', 'SIH1371', 'Miscellaneous']\n",
      "['77', None, None, 'Government of\\nJharkhand', None, 'development of systems for\\neffective Environmental,\\nSocial and Governance (ESG)\\nIntervention in Higher\\nEducation', 'Software', 'SIH1372', 'Renewable /\\nSustainable\\nEnergy']\n",
      "['78', None, None, 'Ministry of Power', None, 'Cloudburst prediction system', 'Software', 'SIH1374', 'Disaster\\nManagement']\n",
      "['79', None, None, 'Ministry of Power', None, 'Creation of Live Digital\\nTwins for the power Projects\\nand integration with all\\nexisting monitoring and\\ndatabase system which will\\ngive a holistic real time\\napproach to the project and\\nplant from all aspect of\\nconstruction, operation and', 'Software', 'SIH1377', 'Smart\\nAutomation']\n",
      "['80', None, None, 'Ministry of Power', None, 'maintenance.\\nSegregating and information\\non regulatory / Gofi.\\nPolicieVGuidelines/Office\\nMemorauda etc. related to\\nContract and Procurement\\nissues for proper compliance\\nand reporting of the same.', 'Software', 'SIH1378', 'Miscellaneous']\n",
      "['81', '', '', 'Mi', 'nis', 'Vegetation measurement\\nalong the line corridor using\\nsatellite imagery', 'Software', 'SIH1379', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['82', None, None, 'Ministry of Power', None, 'lntelligent chatbot to answer\\nqueries pertaining to various\\nMaintenance Processes within\\nSubstation', 'Software', 'SIH1380', 'Smart\\nEducation']\n",
      "['83', None, None, 'Ministry of Power', None, 'Analysis and identification of\\nmalicious mobile applications', 'Software', 'SIH1381', 'Blockchain &\\nCybersecurity']\n",
      "['84', None, None, 'Govt of Himachal\\nPradesh', None, 'Real-Time Vehicle Tracking\\nsystem.', 'Software', 'SIH1382', 'Smart Vehicles']\n",
      "['85', None, None, 'Govt of Himachal\\nPradesh', None, 'Optimizing Doctor\\nAvailability and Appointment\\nAllocation in Hospitals\\nthrough Digital Technology\\nand Al Integration.', 'Software', 'SIH1383', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['86', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Developing an interactive\\ngaming software / mobile\\napplication on Inteliectual\\nProperty Awareness for\\nschool students', 'Software', 'SIH1384', 'Smart\\nEducation']\n",
      "['87', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, 'Developing a software that\\ncan translate resource\\nmaterial and other texts from\\nEnglish to other Indian\\nregional languages.', 'Software', 'SIH1385', 'Smart\\nEducation']\n",
      "['88', None, None, 'Ministry of\\nCommerce and\\nIndustries', None, None, 'Developing a software for\\ndubbing of videos from\\nEnglish to other Indian\\nregional languages.', 'Software', 'SIH1386', 'Smart\\nEducation']\n",
      "['89', None, None, 'Ministry of power', None, None, 'Detection of Malwarei Trojan\\nin softwares used in Power\\nSector.', 'Software', 'SIH1388', 'Blockchain &\\nCybersecurity']\n",
      "['90', None, None, 'Ministry of power', None, None, \"To develop centralised\\ninformation security .Log-\\ncollection facility' or 'security\\noperation centre (soc)' in the\\npower sector, considering\\ncEA cybersecurity (Power\\nsector) Guidelines, 2021to\\nkeep lr and or networking\\nSystem isolated and air-\\ngapped.\", 'Software', 'SIH1389', 'Blockchain &\\nCybersecurity']\n",
      "['91', '10', '', 'Mi\\nEn', 'nis\\nvir', 'try of\\nonment', 'Pro Planet Person App', 'Software', 'SIH1390', 'Clean & Green\\nTechnology']\n",
      "['92', None, None, 'Ministry of\\nEnvironment', None, None, 'Behavioural change\\nmonitoring software', 'Software', 'SIH1391', 'Smart\\nAutomation']\n",
      "['93', None, None, 'Ministry of\\nEnvironment', None, None, 'E-Waste Facility Locator', 'Software', 'SIH1392', 'Smart\\nAutomation']\n",
      "['94', None, None, 'Ministry of\\nEnvironment', None, None, 'Water and Electricity\\nTracking App', 'Software', 'SIH1393', 'Smart\\nAutomation']\n",
      "['95', None, None, 'Ministry of\\nEnvironment', None, None, 'Virtual Zoo', 'Software', 'SIH1394', 'Smart\\nEducation']\n",
      "['96', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'IoT based sensors can be used\\nto determine the Machine\\nRuntime', 'Software', 'SIH1395', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['97', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'Developing Virtual Reality\\nbased solutions', 'Software', 'SIH1396', 'Disaster\\nManagement']\n",
      "['98', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'Development of business\\nmodels for collection and\\nutilization of single usc\\nplastics and various other\\nindustrial wastes', 'Software', 'SIH1397', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['99', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'lntegration and Utilization of\\ndata-based being maintained\\nby various\\nMinistries/Departments for\\nbetter utilization of raw\\nmaterials and production\\ncapacity.', 'Software', 'SIH1398', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['100', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, None, 'App-Based Solution to\\nidentify and solve disease in\\nplants/crops', 'Software', 'SIH1401', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['10', '1', '', 'Mi', 'nis', 'Ear Electronic Device for\\nTinnitus Frequency Finding\\nand Adjusting to Provide\\nRelief to Tinnitus Suffering\\nPatient', 'Software', 'SIH1402', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['102', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'APP Based Digital\\nAudiometer', 'Software', 'SIH1403', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['103', None, None, 'Ministry of Social\\nJustice and\\nEmpowerment', None, 'Develop therapy materials in\\nHindi for misarticulation\\nchildren', 'Software', 'SIH1405', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['104', None, None, 'Ministry of Home\\nAffairs', None, 'Chatbot based helpdesk for\\ngovt employees and\\ndepartments', 'Software', 'SIH1407', 'Smart\\nAutomation']\n",
      "['105', None, None, 'Ministry of Home\\nAffairs', None, 'IT System log analyzer', 'Software', 'SIH1408', 'Blockchain &\\nCybersecurity']\n",
      "['106', None, None, 'Ministry of Home\\nAffairs', None, 'AI based IT training system', 'Software', 'SIH1409', 'Smart\\nEducation']\n",
      "['107', None, None, 'Ministry of Home\\nAffairs', None, 'Augmented/ Virtual reality\\nsystem for the live training of\\ntroops', 'Software', 'SIH1410', 'Smart\\nAutomation']\n",
      "['108', None, None, 'Ministry of Home\\nAffairs', None, 'Simulator system for counter\\nHijack and sky Marshalling\\noperations', 'Software', 'SIH1411', 'Blockchain &\\nCybersecurity']\n",
      "['109', None, None, 'Ministry of Home\\nAffairs', None, 'Data Compression for\\nbackbone network', 'Software', 'SIH1412', 'Blockchain &\\nCybersecurity']\n",
      "['110', None, None, 'Ministry of\\nCommunications', None, 'Dak Ghar Niryat Kendra', 'Software', 'SIH1413', 'Transportation\\n& Logistics']\n",
      "['11', '1', '', 'Mi', 'nis', 'Development of motion\\namplification video\\ntechniques for vibration\\nanalysis', 'Software', 'SIH1415', 'Smart\\nAutomation']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['112', None, None, 'Ministry of Defence', None, 'AI based Automatic alarm\\ngeneration and dropping of\\npayload at a particular object\\nthrough a Drone.', 'Software', 'SIH1416', 'Disaster\\nManagement']\n",
      "['113', None, None, 'Ministry of Defence', None, 'AI-ML based intelligent de-\\nsmoking/de-hazing algorithm', 'Software', 'SIH1417', 'Disaster\\nManagement']\n",
      "['114', None, None, 'Ministry of Defence', None, 'Deep learning for terrain\\nrecognition', 'Software', 'SIH1418', 'Miscellaneous']\n",
      "['115', None, None, 'Ministry of Defence', None, 'Robust human target\\ndetection and acquisition', 'Software', 'SIH1419', 'Miscellaneous']\n",
      "['116', None, None, 'Ministry of Defence', None, 'Lean module for reasoning\\nabout computational\\ncomplexity in GPTs.', 'Software', 'SIH1420', 'Miscellaneous']\n",
      "['117', None, None, 'Ministry of Defence', None, 'Novel Technologies for Early\\nDetection and Mitigation of\\nAvalanches', 'Software', 'SIH1421', 'Disaster\\nManagement']\n",
      "['118', None, None, 'Ministry of Defence', None, 'Devise the method for\\nidentification of victims\\nburied under avalanches.', 'Software', 'SIH1422', 'Disaster\\nManagement']\n",
      "['119', None, None, 'Ministry of Jal\\nShakti', None, 'Web /Mobile based tool for\\nmapping of Water supply\\nnetwork', 'Software', 'SIH1423', 'Miscellaneous']\n",
      "['120', None, None, 'Ministry of Rural\\nDevelopment', None, \"AR/VR based application\\nwhich helps visualize the\\ncomplete house virtually at an\\nearly stage, which can help in\\ncost estimation, planning and\\ncompletion of the house in\\ntime'\", 'Software', 'SIH1428', 'Smart\\nAutomation']\n",
      "['12', '1', '', 'Mi', 'nis', 'Develop a solution to identifo\\ndiscrepancies in Quality\\nMonitoring Data on OMMAS\\nand generate reports that\\nhighlight areas where\\ncorrective action is Required.', 'Software', 'SIH1429', 'Smart\\nAutomation']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['122', None, None, 'Ministry of\\nEducation', None, 'Online personalized learning\\nremediation/tutoring tool.\\nSearch for best teacher for\\nspecific topics.', 'Software', 'SIH1431', 'Smart\\nEducation']\n",
      "['123', None, None, 'Ministry of\\nEducation', None, 'Identify slow learners for\\nremedial teaching and\\ncapacity building for\\ninnovative methods.', 'Software', 'SIH1432', 'Smart\\nEducation']\n",
      "['124', None, None, 'Ministry of\\nEducation', None, 'Mental health and well-being\\nsurveillance, assessment and\\ntracking solution among\\nchildren.', 'Software', 'SIH1433', 'Smart\\nEducation']\n",
      "['125', None, None, 'Ministry of\\nEducation', None, 'Making career choices and AI\\nbased counselling accessible\\nto every child at secondary\\nlevel along with aptitude tests\\nand detailed career paths.', 'Software', 'SIH1434', 'Smart\\nEducation']\n",
      "['126', None, None, 'Ministry of Rural\\nDevelopment', None, 'Developing an algotithim /\\nprogramme to measure\\nincrease in income of FPOs\\non account of project\\ninterventions under WDC 2.0.', 'Software', 'SIH1435', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['127', None, None, 'Ministry of Rural\\nDevelopment', None, 'Number of persons benefitted\\nfrom using the Water\\nHarvesting Structures (WHS)\\ncreated / rejuvenated in the\\nproject areas under WDC 2.0\\nfor economic activities like\\nfisheries etc for alternate\\nsource of income generation.', 'Software', 'SIH1436', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['128', None, None, 'Ministry of Rural\\nDevelopment', None, 'Development of suitable\\nSoftware and Hardware\\ncomponents/sensors for\\nspringshed mapping,\\nmonitoring and management.', 'Software', 'SIH1437', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['129', None, None, 'Ministry of Home\\nAffairs', None, 'Virtual Reality-Based\\nTraining for CBRN Disaster\\nResponse', 'Software', 'SIH1438', 'Disaster\\nManagement']\n",
      "['130', None, None, 'Ministry of Home\\nAffairs', None, 'An application under which\\nall rescue agencies are\\nregistered and which can\\ndisplay the location of other\\nrescue relief agencies during\\nnatural/ man made calamities', 'Software', 'SIH1440', 'Disaster\\nManagement']\n",
      "['13', '1', '', 'Ba', 'jaj', 'Similar Document Template\\nMatching Algorithm', 'Software', 'SIH1441', 'Miscellaneous']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['132', None, None, 'Autodesk Education\\nExperience', None, 'Students to use Autodesk\\nFusion 360 to research and\\nredesign a conventional\\nautomotive component\\ncommonly found in vehicles\\nand utilize generative design\\nto reimagine its design. For\\nadditional information and\\ndetailed problem statement,\\nplease visit:\\nhttps://damassets.autodesk.net\\n/content/dam/autodesk/www/p\\ndfs/sih-2023-hardware-\\nedition-additive-\\nmanufacturing.pdf', 'Software', 'SIH1442', 'Smart Vehicles']\n",
      "['133', None, None, 'Autodesk Education\\nExperience', None, 'Students to use Autodesk\\nFusion 360 to research and to\\ngenerate NC code with\\nmachine details and tool\\nlibrary for any industrial\\ncomponent. For additional\\ninformation and detailed\\nproblem statement, please\\nvisit:\\nhttps://damassets.autodesk.net\\n/content/dam/autodesk/www/p\\ndfs/sih-2023-hardware-', 'Software', 'SIH1443', 'Smart\\nAutomation']\n",
      "['134', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'edition-cnc.pdf\\nDe-anonymisation for\\nmonitoring and tracking of\\nillegal activities performed\\nusing cryptocurrency\\ntransaction technology', 'Software', 'SIH1445', 'Blockchain &\\nCybersecurity']\n",
      "['135', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Developing a GUI based\\nhardening script for Ubuntu\\noperating system with\\nflexibility to cater for\\norganisational security\\npolicies', 'Software', 'SIH1446', 'Miscellaneous']\n",
      "['136', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Identification and Extraction\\nof Forward Error Correction\\n(FEC) schemes of unknown\\ndemodulated signals', 'Software', 'SIH1447', 'Miscellaneous']\n",
      "['137', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Design, develop and\\nimplement a software bill of\\nmaterials (SBOM) generation\\ntool that can generate the\\ncomplete SBOM of custom-\\ndeveloped software (including\\nin-house developments by\\norganisations)', 'Software', 'SIH1449', 'Smart\\nAutomation']\n",
      "['138', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Develop and deploy a Large\\nLanguage Model (LLM)\\nbased tool for generating\\nhuman like responses to\\nnatural language inputs for\\nnetwork not connected over\\ninternet', 'Software', 'SIH1450', 'Smart\\nAutomation']\n",
      "['139', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Develop a AI/ML tool to\\ndetect whether a system /\\nfirewall /router / network is\\ncompromised. The technique\\nshould not rely only on IoCs\\n(Indicators of Compromises)\\ndetection.', 'Software', 'SIH1451', 'Blockchain &\\nCybersecurity']\n",
      "['140', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Develop Ransomware\\nReadiness Assessment tool.', 'Software', 'SIH1452', 'Blockchain &\\nCybersecurity']\n",
      "['14', '1', '', 'Na', 'tio', 'Investigation of\\nvulnerabilities in\\nimplementation of crypto\\nlibrary used by OpenVPN for\\nInternet Protocol Security\\n(IPsec), IPV6 deployment.', 'Software', 'SIH1453', 'Blockchain &\\nCybersecurity']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['142', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Create an intelligent system\\nusing AI/ML to detect\\nphishing domains which\\nimitate look and feel of\\ngenuine domains', 'Software', 'SIH1454', 'Blockchain &\\nCybersecurity']\n",
      "['143', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Efficient enumeration of\\nURLs of active hidden servers\\nover anonymous channel\\n(TOR)', 'Software', 'SIH1455', 'Blockchain &\\nCybersecurity']\n",
      "['144', None, None, 'National Technical\\nResearch\\nOrganisation,(NTRO\\n)', None, 'Speech to text transcription\\nfor Indian languages. The\\nproblem entails transcription\\nin the native script and then\\ntranslation to English. The\\nlanguages of interest are\\nHindi, Indian English, Urdu,\\nBengali, Punjabi.', 'Software', 'SIH1456', 'Miscellaneous']\n",
      "['145', None, None, 'MathWorks India\\nPrivate Limited', None, 'Get Fit Faster with a High-\\nTech Tracker: Analyze\\nHuman Activity and GPS\\nData for Improved Results', 'Software', 'SIH1457', 'Smart\\nAutomation']\n",
      "['146', None, None, 'AICTE', None, 'AI Based - Designing of\\nAssistive portal for\\nStakeholders in Approval\\nProcess', 'Software', 'SIH1458', 'Miscellaneous']\n",
      "['147', None, None, 'AICTE', None, 'Integration of Multiple Data-\\nbases of AICTE in order to\\nfetch Coherent Information', 'Software', 'SIH1459', 'Miscellaneous']\n",
      "['148', None, None, 'AICTE', None, 'Integration of AI for Adaptive\\nLearning for MCQ Selection\\nin PARAKH', 'Software', 'SIH1460', 'Smart\\nAutomation']\n",
      "['149', None, None, 'AICTE', None, 'Cybersecurity Portal for\\nEffective Management of\\nServers and Firewalls', 'Software', 'SIH1461', 'Blockchain &\\nCybersecurity']\n",
      "['150', None, None, 'Ministry of Home\\nAffairs', None, 'Awareness and Preparedness\\nTowards Disaster\\nManagement', 'Software', 'SIH1462', 'Disaster\\nManagement']\n",
      "['15', '1', '', 'AI', 'CT', 'Establishing a Server log\\nsystem for E-governance with\\nappropriate notification and\\ncontent based classification of\\nlog AICTE', 'Software', 'SIH1463', 'Miscellaneous']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['152', None, None, 'AICTE', None, 'Design and Developed a\\npersonalized online meeting\\nsystem for AICTE', 'Software', 'SIH1464', 'Blockchain &\\nCybersecurity']\n",
      "['153', None, None, 'AICTE', None, 'A unified portal for\\ndeveloping a model\\nCurriculum for all the AICTE\\nApproved Institutes', 'Software', 'SIH1465', 'Miscellaneous']\n",
      "['154', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1467', 'Smart\\nEducation']\n",
      "['155', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1468', 'Disaster\\nManagement']\n",
      "['156', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1483', 'Miscellaneous']\n",
      "['157', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1484', 'Blockchain &\\nCybersecurity']\n",
      "['158', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1485', 'Renewable /\\nSustainable\\nEnergy']\n",
      "['159', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1486', 'Transportation\\n& Logistics']\n",
      "['160', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1487', 'Clean & Green\\nTechnology']\n",
      "['16', '1', '', 'AI', 'CT', 'Student Innovation', 'Software', 'SIH1488', 'Robotics and\\nDrones']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['162', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1489', 'Transportation\\n& Logistics']\n",
      "['163', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1490', 'Smart Vehicles']\n",
      "['164', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1491', 'Agriculture,\\nFoodTech &\\nRural\\nDevelopment']\n",
      "['165', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1492', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['166', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1493', 'Heritage &\\nCulture']\n",
      "['167', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1494', 'Fitness &\\nSports']\n",
      "['168', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1495', 'Smart\\nAutomation']\n",
      "['169', None, None, 'AICTE, MIC-\\nStudent Innovation', None, 'Student Innovation', 'Software', 'SIH1496', 'Toys & Games']\n",
      "['170', None, None, 'AICTE, MIC', None, 'Develop a Proctored exam\\ntool for shortlisting the\\ncandidates for the national\\nand international level\\nhackathons.', 'Software', 'SIH1498', 'Smart\\nAutomation']\n",
      "['17', '1', '', 'Go', 've', 'Education ecosystem for\\nspecially abled student need\\nprovision and improvement to\\ntake care of compliance,\\ngovernance and conduct.', 'Software', 'SIH1500', 'Smart\\nEducation']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['172', None, None, 'Ministry of AYUSH', None, 'Development of Virtual\\nReality (VR) technology for\\nDhatuposhana Nyaya', 'Software', 'SIH1501', 'MedTech /\\nBioTech /\\nHealthTech']\n",
      "['173', None, None, 'Government of\\nJharkhand', None, 'Blended Learning to\\novercome inadequate\\ninfrastructure', 'Software', 'SIH1502', 'Smart\\nEducation']\n",
      "['174', None, None, 'Government of\\nJharkhand', None, 'Capacity building,\\nperformance assessment and\\nmotivation driven tool for\\nfaculty upgradation', 'Software', 'SIH1504', 'Smart\\nEducation']\n",
      "['175', None, None, 'Ministry of Home\\nAffairs', None, 'Areal Location of Hazardous\\nAtmosphere in Industries', 'Software', 'SIH1505', 'Disaster\\nManagement']\n",
      "['176', None, None, 'Ministry of Ports,\\nShipping and\\nWaterways', None, 'Leveraging the power of deep\\nlearning to overcome the\\nchallenges of marine\\nengineering and improve\\nvessel operations:', 'Software', 'SIH1506', 'Smart\\nAutomation']\n",
      "['177', None, None, 'Ministry of Power', None, \"Creation of dedicated real\\ntime 'Procurement Data\\nPortal'as well as 'Vendor\\nPayment Data portal'to\\ncapture all related data in\\nrespect of NEEPCO,S\\nProcurements and Payments'\\nincluding Procurement from\\nMSE Sector and procurement\\nin GeM Portal\", 'Software', 'SIH1508', 'Miscellaneous']\n",
      "['178', None, None, 'Ministry of Micro,\\nSmall and Medium\\nEnterprises', None, 'App-Based Solution to\\nprovide market access to\\nmicro and small enterprises', 'Software', 'SIH1509', 'Miscellaneous']\n",
      "['179', None, None, 'Ministry of Rural\\nDevelopment', None, 'Land profiling of Asset\\nCreation process', 'Software', 'SIH1510', 'Miscellaneous']\n",
      "['180', None, None, 'Ministry of Housing\\nand Urban Affairs', None, 'Comprehensive lnspection\\nand Analysis of Water Supply\\nDistribution Lines', 'Software', 'SIH1514', 'Clean & Green\\nTechnology']\n",
      "['18', '1', '', 'Mi', 'nis', 'Smart and Effective realtime\\nManagement of street parking', 'Software', 'SIH1515', 'Smart\\nAutomation']\n",
      "['', None, None, None, None, None, None, None, None]\n",
      "['182', None, None, 'Ministry of Housing\\nand Urban Affairs', None, 'Suggest an Al-based solution\\nto enable ease of grievance\\nlodging and tracking for\\ncitizens across multiple\\ndepartments', 'Software', 'SIH1516', 'Smart\\nAutomation']\n",
      "['', '']\n"
     ]
    }
   ],
   "source": [
    "for page in pdf.pages:\n",
    "    table=page.extract_table()\n",
    "    for i in table:\n",
    "        print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3\n"
     ]
    }
   ],
   "source": [
    "def nested_depth(input_list: list):\n",
    "    if isinstance(input_list,list):\n",
    "        return 1+max(nested_depth(item) for item in input_list)\n",
    "    else:\n",
    "        return 0\n",
    "depth=nested_depth(tables)\n",
    "print(depth)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Irregular shape\n"
     ]
    }
   ],
   "source": [
    "def check_shape(lst: list)-> str:\n",
    "    if not lst:\n",
    "        return \"Empty list\"\n",
    "    row_length = len(lst[0])\n",
    "    for row in lst:\n",
    "        if len(row) != row_length:\n",
    "            return \"Irregular shape\"\n",
    "    return f\"Shape is {len(lst)} rows by {row_length} columns\"\n",
    "\n",
    "my_list = [[['', '10', '', '', '', 'Organization', 'Problem Statement Title']]]\n",
    "shape_info = check_shape(tables)\n",
    "print(shape_info) \n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In short tables are deeply nested into 3 further"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In short, data is not at all clean, many a time there are too many unexpected spaces and all that stuff, thatswhy we have inconsitent lenght"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is due to many sort of empty spaces in between"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Name</th>\n",
       "      <th>Maths</th>\n",
       "      <th>Science</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Martha</td>\n",
       "      <td>87</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tim</td>\n",
       "      <td>91</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Rob</td>\n",
       "      <td>97</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>95</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Name  Maths  Science\n",
       "0   Martha     87       83\n",
       "1      Tim     91       99\n",
       "2      Rob     97       84\n",
       "3  Georgia     95       76"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from IPython.display import display,HTML\n",
    "import pandas as pd\n",
    "from numpy.random import randint\n",
    "dict = {'Name':['Martha', 'Tim', 'Rob', 'Georgia'],\n",
    "        'Maths':[87, 91, 97, 95],\n",
    "        'Science':[83, 99, 84, 76]\n",
    "       }\n",
    "df2=pd.DataFrame(dict)\n",
    "display(df2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>Name</th>\n",
       "      <th>Maths</th>\n",
       "      <th>Science</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Martha</td>\n",
       "      <td>87.0</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tim</td>\n",
       "      <td>91.0</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Rob</td>\n",
       "      <td>97.0</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>95.0</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Amysdee</td>\n",
       "      <td>9.0</td>\n",
       "      <td>932</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Name  Maths  Science\n",
       "0   Martha   87.0       83\n",
       "1      Tim   91.0       99\n",
       "2      Rob   97.0       84\n",
       "3  Georgia   95.0       76\n",
       "5  Amysdee    9.0      932"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df2.loc[len(df2.index)+1]=['Amysdee',9e0,932]\n",
    "display(df2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In short for adding elements to a dataframe, \n",
    "df.loc[len(df.index)+1]=['Raghav',98,23]\n",
    "display(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In short, yeh steps hai which one / you should follow for adding element to the dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[['', '10', '', '', '', 'Organization', 'Problem Statement Title', 'Category', 'PS Number', 'Domain Bucket'], ['1', None, None, 'Ministry of\\nChemicals and\\nFertilizers', None, None, 'International Comparative\\nSystem to Launch Integrated\\nReal-Time Data Management\\nSystem (IDMS) for Chemical\\nand Petrochemicals Sector.', 'Software', 'SIH1278', 'Miscellaneous'], ['2', None, None, 'Ministry of Law and\\nJustice', None, None, 'Development of software for\\nstreamlining the listing of\\ncases through Differentiated\\nCase Flow Management', 'Software', 'SIH1279', 'Miscellaneous'], ['3', None, None, 'Ministry of Law and\\nJustice', None, None, 'Development of e-Portal for\\nfacilitating Case Management\\nHearing of various types of\\ncases', 'Software', 'SIH1280', 'Miscellaneous'], ['4', None, None, 'Ministry of Law and\\nJustice', None, None, \"Development of gamified\\nplatform on Children's Rights\\nto increase legal literacy and\\nawareness among children in\\nIndia\", 'Software', 'SIH1281', 'Smart\\nEducation'], ['5', None, None, 'Ministry of Law and\\nJustice', None, None, 'Tech-Driven Solutions for\\nUndertrial Prisoners in India', 'Software', 'SIH1282', 'Miscellaneous'], ['6', None, None, 'Ministry of Law and\\nJustice', None, None, 'Digital Assistant for Legal\\nAwareness and Designing a\\nKYC framework in India', 'Software', 'SIH1283', 'Smart\\nEducation'], ['7', None, None, 'Ministry of Law and\\nJustice', None, None, 'Developing a Blockchain-\\nBased eVault for Legal\\nRecords', 'Software', 'SIH1284', 'Blockchain &\\nCybersecurity'], ['8', None, None, 'Ministry of Law and\\nJustice', None, None, 'AI-powered Legal\\nDocumentation Assistant', 'Software', 'SIH1285', 'Miscellaneous'], ['9', None, None, 'Ministry of Law and\\nJustice', None, None, 'Incentives based Design for\\nonboarding Legal Service\\nProviders such as Advocates,\\nArbitrators, Mediators,\\nNotaries, Document Writers,\\netc on eMarket Place for\\nextending Legal Services to\\nCitizens in India', 'Software', 'SIH1286', 'Miscellaneous'], ['10', None, None, 'Ministry of Jal\\nShakti', None, None, 'Use of Digital Technology to\\ncalculate water footprints for\\ndifferent daily use items.', 'Software', 'SIH1287', 'Clean & Green\\nTechnology'], ['', None, None, '', None, None, '', '', '', ''], ['11', '', '', 'Mi', 'nis', None, 'Use of Digital Technology in\\naddressing Non-Revenue\\nWater (NRW)', 'Software', 'SIH1288', 'Clean & Green\\nTechnology'], ['', None, None, None, None, None, None, None, None, None], ['12', None, None, 'Ministry of Jal\\nShakti', None, None, 'Projection of the extent of\\ninundation corresponding to\\nthe forecasts of flood levels in\\na river.', 'Software', 'SIH1289', 'Disaster\\nManagement']]\n"
     ]
    }
   ],
   "source": [
    "print(tables[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I have had 182 problem statements so final df must have 182 rows as simple as that"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "   0     1     2                                        3     4             5  \\\n",
      "0       10                                                       Organization   \n",
      "1  1  None  None  Ministry of\\nChemicals and\\nFertilizers  None          None   \n",
      "2  2  None  None             Ministry of Law and\\nJustice  None          None   \n",
      "\n",
      "                                                   6         7          8  \\\n",
      "0                            Problem Statement Title  Category  PS Number   \n",
      "1  International Comparative\\nSystem to Launch In...  Software    SIH1278   \n",
      "2  Development of software for\\nstreamlining the ...  Software    SIH1279   \n",
      "\n",
      "               9  \n",
      "0  Domain Bucket  \n",
      "1  Miscellaneous  \n",
      "2  Miscellaneous  \n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "data = [\n",
    "    ['', '10', '', '', '', 'Organization', 'Problem Statement Title', 'Category', 'PS Number', 'Domain Bucket'],\n",
    "    ['1', None, None, 'Ministry of\\nChemicals and\\nFertilizers', None, None, 'International Comparative\\nSystem to Launch Integrated\\nReal-Time Data Management\\nSystem (IDMS) for Chemical\\nand Petrochemicals Sector.', 'Software', 'SIH1278', 'Miscellaneous'],\n",
    "    ['2', None, None, 'Ministry of Law and\\nJustice', None, None, 'Development of software for\\nstreamlining the listing of\\ncases through Differentiated\\nCase Flow Management', 'Software', 'SIH1279', 'Miscellaneous']\n",
    "]\n",
    "df=pd.DataFrame(data)\n",
    "print(df)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td>10</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Organization</td>\n",
       "      <td>Problem Statement Title</td>\n",
       "      <td>Category</td>\n",
       "      <td>PS Number</td>\n",
       "      <td>Domain Bucket</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   0     1     2                                        3     4             5  \\\n",
       "0       10                                                       Organization   \n",
       "1  1  None  None  Ministry of\\nChemicals and\\nFertilizers  None          None   \n",
       "2  2  None  None             Ministry of Law and\\nJustice  None          None   \n",
       "\n",
       "                                                   6         7          8  \\\n",
       "0                            Problem Statement Title  Category  PS Number   \n",
       "1  International Comparative\\nSystem to Launch In...  Software    SIH1278   \n",
       "2  Development of software for\\nstreamlining the ...  Software    SIH1279   \n",
       "\n",
       "               9  \n",
       "0  Domain Bucket  \n",
       "1  Miscellaneous  \n",
       "2  Miscellaneous  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_cleaned=df.dropna(axis=1,how='any')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>0</th>\n",
       "      <th>3</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Problem Statement Title</td>\n",
       "      <td>Category</td>\n",
       "      <td>PS Number</td>\n",
       "      <td>Domain Bucket</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   0                                        3  \\\n",
       "0                                               \n",
       "1  1  Ministry of\\nChemicals and\\nFertilizers   \n",
       "2  2             Ministry of Law and\\nJustice   \n",
       "\n",
       "                                                   6         7          8  \\\n",
       "0                            Problem Statement Title  Category  PS Number   \n",
       "1  International Comparative\\nSystem to Launch In...  Software    SIH1278   \n",
       "2  Development of software for\\nstreamlining the ...  Software    SIH1279   \n",
       "\n",
       "               9  \n",
       "0  Domain Bucket  \n",
       "1  Miscellaneous  \n",
       "2  Miscellaneous  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cleaned"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_header=df_cleaned.iloc[0]\n",
    "df_cleaned=df_cleaned[1:]\n",
    "df_cleaned.columns=new_header\n",
    "df_cleaned.reset_index(drop=True,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "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></th>\n",
       "      <th></th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "0                                              \\\n",
       "0  1  Ministry of\\nChemicals and\\nFertilizers   \n",
       "1  2             Ministry of Law and\\nJustice   \n",
       "\n",
       "0                            Problem Statement Title  Category PS Number  \\\n",
       "0  International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1  Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "\n",
       "0  Domain Bucket  \n",
       "0  Miscellaneous  \n",
       "1  Miscellaneous  "
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cleaned"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_original=pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>None</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of e-Portal for\\nfacilitating Case...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of gamified\\nplatform on Children'...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Tech-Driven Solutions for\\nUndertrial Prisoner...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Digital Assistant for Legal\\nAwareness and Des...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Developing a Blockchain-\\nBased eVault for Leg...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;\\nCybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>AI-powered Legal\\nDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Incentives based Design for\\nonboarding Legal ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>None</td>\n",
       "      <td>Use of Digital Technology to\\ncalculate water ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td></td>\n",
       "      <td>Mi</td>\n",
       "      <td>nis</td>\n",
       "      <td>Use of Digital Technology in\\naddressing Non-R...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>12</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>None</td>\n",
       "      <td>Projection of the extent of\\ninundation corres...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>Disaster\\nManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "0                                                            \\\n",
       "0    1  None  Ministry of\\nChemicals and\\nFertilizers  None   \n",
       "1    2  None             Ministry of Law and\\nJustice  None   \n",
       "2    3  None             Ministry of Law and\\nJustice  None   \n",
       "3    4  None             Ministry of Law and\\nJustice  None   \n",
       "4    5  None             Ministry of Law and\\nJustice  None   \n",
       "5    6  None             Ministry of Law and\\nJustice  None   \n",
       "6    7  None             Ministry of Law and\\nJustice  None   \n",
       "7    8  None             Ministry of Law and\\nJustice  None   \n",
       "8    9  None             Ministry of Law and\\nJustice  None   \n",
       "9   10  None                  Ministry of Jal\\nShakti  None   \n",
       "10      None                                           None   \n",
       "11  11                                             Mi   nis   \n",
       "12      None                                     None  None   \n",
       "13  12  None                  Ministry of Jal\\nShakti  None   \n",
       "\n",
       "0                             Problem Statement Title  Category PS Number  \\\n",
       "0   International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1   Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "2   Development of e-Portal for\\nfacilitating Case...  Software   SIH1280   \n",
       "3   Development of gamified\\nplatform on Children'...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions for\\nUndertrial Prisoner...  Software   SIH1282   \n",
       "5   Digital Assistant for Legal\\nAwareness and Des...  Software   SIH1283   \n",
       "6   Developing a Blockchain-\\nBased eVault for Leg...  Software   SIH1284   \n",
       "7           AI-powered Legal\\nDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design for\\nonboarding Legal ...  Software   SIH1286   \n",
       "9   Use of Digital Technology to\\ncalculate water ...  Software   SIH1287   \n",
       "10                                                                          \n",
       "11  Use of Digital Technology in\\naddressing Non-R...  Software   SIH1288   \n",
       "12                                               None      None      None   \n",
       "13  Projection of the extent of\\ninundation corres...  Software   SIH1289   \n",
       "\n",
       "0                 Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3              Smart\\nEducation  \n",
       "4                 Miscellaneous  \n",
       "5              Smart\\nEducation  \n",
       "6   Blockchain &\\nCybersecurity  \n",
       "7                 Miscellaneous  \n",
       "8                 Miscellaneous  \n",
       "9     Clean & Green\\nTechnology  \n",
       "10                               \n",
       "11    Clean & Green\\nTechnology  \n",
       "12                         None  \n",
       "13         Disaster\\nManagement  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# here some of them nan and some of them explicity None, both ko alag le rha isliye:\n",
    "import numpy as np\n",
    "def create_dataframe_from_list(data:list)->pd.DataFrame:\n",
    "    df=pd.DataFrame(data)\n",
    "    new_header=df.iloc[0]\n",
    "    df_cleaned=df[1:]\n",
    "    df_cleaned.columns=new_header\n",
    "    df_cleaned.reset_index(drop=True,inplace=True)\n",
    "    df=df_cleaned.dropna(axis=1,how='all')\n",
    "    columns_to_delete=['10']\n",
    "    df = df.drop(columns=columns_to_delete)\n",
    "    return df\n",
    "    # df_cleaned=df.dropna(thresh=threshold)\n",
    "    # print(df_cleaned)\n",
    "    # df_cleaned=df.dropna(axis=1,how='any')\n",
    "    # print(df_cleaned)\n",
    "    # new_header=df_cleaned.iloc[0]\n",
    "    # df_cleaned=df_cleaned[1:]\n",
    "    # df_cleaned.columns=new_header\n",
    "    # df_cleaned.reset_index(drop=True,inplace=True)\n",
    "    # return df_cleaned\n",
    "    \n",
    "\n",
    "\n",
    "d2=create_dataframe_from_list(tables[0])\n",
    "display(d2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [],
   "source": [
    "d2=d2.dropna(axis=1,how='all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>None</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of e-Portal for\\nfacilitating Case...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of gamified\\nplatform on Children'...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Tech-Driven Solutions for\\nUndertrial Prisoner...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Digital Assistant for Legal\\nAwareness and Des...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Developing a Blockchain-\\nBased eVault for Leg...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;\\nCybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>AI-powered Legal\\nDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Incentives based Design for\\nonboarding Legal ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>None</td>\n",
       "      <td>Use of Digital Technology to\\ncalculate water ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td></td>\n",
       "      <td>Mi</td>\n",
       "      <td>nis</td>\n",
       "      <td>Use of Digital Technology in\\naddressing Non-R...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>12</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>None</td>\n",
       "      <td>Projection of the extent of\\ninundation corres...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>Disaster\\nManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "0                                                            \\\n",
       "0    1  None  Ministry of\\nChemicals and\\nFertilizers  None   \n",
       "1    2  None             Ministry of Law and\\nJustice  None   \n",
       "2    3  None             Ministry of Law and\\nJustice  None   \n",
       "3    4  None             Ministry of Law and\\nJustice  None   \n",
       "4    5  None             Ministry of Law and\\nJustice  None   \n",
       "5    6  None             Ministry of Law and\\nJustice  None   \n",
       "6    7  None             Ministry of Law and\\nJustice  None   \n",
       "7    8  None             Ministry of Law and\\nJustice  None   \n",
       "8    9  None             Ministry of Law and\\nJustice  None   \n",
       "9   10  None                  Ministry of Jal\\nShakti  None   \n",
       "10      None                                           None   \n",
       "11  11                                             Mi   nis   \n",
       "12      None                                     None  None   \n",
       "13  12  None                  Ministry of Jal\\nShakti  None   \n",
       "\n",
       "0                             Problem Statement Title  Category PS Number  \\\n",
       "0   International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1   Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "2   Development of e-Portal for\\nfacilitating Case...  Software   SIH1280   \n",
       "3   Development of gamified\\nplatform on Children'...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions for\\nUndertrial Prisoner...  Software   SIH1282   \n",
       "5   Digital Assistant for Legal\\nAwareness and Des...  Software   SIH1283   \n",
       "6   Developing a Blockchain-\\nBased eVault for Leg...  Software   SIH1284   \n",
       "7           AI-powered Legal\\nDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design for\\nonboarding Legal ...  Software   SIH1286   \n",
       "9   Use of Digital Technology to\\ncalculate water ...  Software   SIH1287   \n",
       "10                                                                          \n",
       "11  Use of Digital Technology in\\naddressing Non-R...  Software   SIH1288   \n",
       "12                                               None      None      None   \n",
       "13  Projection of the extent of\\ninundation corres...  Software   SIH1289   \n",
       "\n",
       "0                 Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3              Smart\\nEducation  \n",
       "4                 Miscellaneous  \n",
       "5              Smart\\nEducation  \n",
       "6   Blockchain &\\nCybersecurity  \n",
       "7                 Miscellaneous  \n",
       "8                 Miscellaneous  \n",
       "9     Clean & Green\\nTechnology  \n",
       "10                               \n",
       "11    Clean & Green\\nTechnology  \n",
       "12                         None  \n",
       "13         Disaster\\nManagement  "
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>None</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of e-Portal for\\nfacilitating Case...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of gamified\\nplatform on Children'...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Tech-Driven Solutions for\\nUndertrial Prisoner...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Digital Assistant for Legal\\nAwareness and Des...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Developing a Blockchain-\\nBased eVault for Leg...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;\\nCybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>AI-powered Legal\\nDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Incentives based Design for\\nonboarding Legal ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>None</td>\n",
       "      <td>Use of Digital Technology to\\ncalculate water ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td></td>\n",
       "      <td>Mi</td>\n",
       "      <td>nis</td>\n",
       "      <td>Use of Digital Technology in\\naddressing Non-R...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>12</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>None</td>\n",
       "      <td>Projection of the extent of\\ninundation corres...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>Disaster\\nManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "0                                                            \\\n",
       "0    1  None  Ministry of\\nChemicals and\\nFertilizers  None   \n",
       "1    2  None             Ministry of Law and\\nJustice  None   \n",
       "2    3  None             Ministry of Law and\\nJustice  None   \n",
       "3    4  None             Ministry of Law and\\nJustice  None   \n",
       "4    5  None             Ministry of Law and\\nJustice  None   \n",
       "5    6  None             Ministry of Law and\\nJustice  None   \n",
       "6    7  None             Ministry of Law and\\nJustice  None   \n",
       "7    8  None             Ministry of Law and\\nJustice  None   \n",
       "8    9  None             Ministry of Law and\\nJustice  None   \n",
       "9   10  None                  Ministry of Jal\\nShakti  None   \n",
       "10      None                                           None   \n",
       "11  11                                             Mi   nis   \n",
       "12      None                                     None  None   \n",
       "13  12  None                  Ministry of Jal\\nShakti  None   \n",
       "\n",
       "0                             Problem Statement Title  Category PS Number  \\\n",
       "0   International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1   Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "2   Development of e-Portal for\\nfacilitating Case...  Software   SIH1280   \n",
       "3   Development of gamified\\nplatform on Children'...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions for\\nUndertrial Prisoner...  Software   SIH1282   \n",
       "5   Digital Assistant for Legal\\nAwareness and Des...  Software   SIH1283   \n",
       "6   Developing a Blockchain-\\nBased eVault for Leg...  Software   SIH1284   \n",
       "7           AI-powered Legal\\nDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design for\\nonboarding Legal ...  Software   SIH1286   \n",
       "9   Use of Digital Technology to\\ncalculate water ...  Software   SIH1287   \n",
       "10                                                                          \n",
       "11  Use of Digital Technology in\\naddressing Non-R...  Software   SIH1288   \n",
       "12                                               None      None      None   \n",
       "13  Projection of the extent of\\ninundation corres...  Software   SIH1289   \n",
       "\n",
       "0                 Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3              Smart\\nEducation  \n",
       "4                 Miscellaneous  \n",
       "5              Smart\\nEducation  \n",
       "6   Blockchain &\\nCybersecurity  \n",
       "7                 Miscellaneous  \n",
       "8                 Miscellaneous  \n",
       "9     Clean & Green\\nTechnology  \n",
       "10                               \n",
       "11    Clean & Green\\nTechnology  \n",
       "12                         None  \n",
       "13         Disaster\\nManagement  "
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['', '', '', '', 'Problem Statement Title', 'Category', 'PS Number',\n",
       "       'Domain Bucket'],\n",
       "      dtype='object', name=0)"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {},
   "outputs": [],
   "source": [
    "d2.columns = ['Sno', 'Sno2', 'hello', 'Organization', 'Problem Statement Title', 'Category', 'PS Number', 'Domain Bucket']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "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>Sno</th>\n",
       "      <th>Sno2</th>\n",
       "      <th>hello</th>\n",
       "      <th>Organization</th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>None</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of e-Portal for\\nfacilitating Case...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Development of gamified\\nplatform on Children'...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Tech-Driven Solutions for\\nUndertrial Prisoner...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Digital Assistant for Legal\\nAwareness and Des...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Developing a Blockchain-\\nBased eVault for Leg...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;\\nCybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>AI-powered Legal\\nDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>None</td>\n",
       "      <td>Incentives based Design for\\nonboarding Legal ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>None</td>\n",
       "      <td>Use of Digital Technology to\\ncalculate water ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td></td>\n",
       "      <td>Mi</td>\n",
       "      <td>nis</td>\n",
       "      <td>Use of Digital Technology in\\naddressing Non-R...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>12</td>\n",
       "      <td>None</td>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>None</td>\n",
       "      <td>Projection of the extent of\\ninundation corres...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>Disaster\\nManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Sno  Sno2                                    hello Organization  \\\n",
       "0    1  None  Ministry of\\nChemicals and\\nFertilizers         None   \n",
       "1    2  None             Ministry of Law and\\nJustice         None   \n",
       "2    3  None             Ministry of Law and\\nJustice         None   \n",
       "3    4  None             Ministry of Law and\\nJustice         None   \n",
       "4    5  None             Ministry of Law and\\nJustice         None   \n",
       "5    6  None             Ministry of Law and\\nJustice         None   \n",
       "6    7  None             Ministry of Law and\\nJustice         None   \n",
       "7    8  None             Ministry of Law and\\nJustice         None   \n",
       "8    9  None             Ministry of Law and\\nJustice         None   \n",
       "9   10  None                  Ministry of Jal\\nShakti         None   \n",
       "10      None                                                  None   \n",
       "11  11                                             Mi          nis   \n",
       "12      None                                     None         None   \n",
       "13  12  None                  Ministry of Jal\\nShakti         None   \n",
       "\n",
       "                              Problem Statement Title  Category PS Number  \\\n",
       "0   International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1   Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "2   Development of e-Portal for\\nfacilitating Case...  Software   SIH1280   \n",
       "3   Development of gamified\\nplatform on Children'...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions for\\nUndertrial Prisoner...  Software   SIH1282   \n",
       "5   Digital Assistant for Legal\\nAwareness and Des...  Software   SIH1283   \n",
       "6   Developing a Blockchain-\\nBased eVault for Leg...  Software   SIH1284   \n",
       "7           AI-powered Legal\\nDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design for\\nonboarding Legal ...  Software   SIH1286   \n",
       "9   Use of Digital Technology to\\ncalculate water ...  Software   SIH1287   \n",
       "10                                                                          \n",
       "11  Use of Digital Technology in\\naddressing Non-R...  Software   SIH1288   \n",
       "12                                               None      None      None   \n",
       "13  Projection of the extent of\\ninundation corres...  Software   SIH1289   \n",
       "\n",
       "                  Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3              Smart\\nEducation  \n",
       "4                 Miscellaneous  \n",
       "5              Smart\\nEducation  \n",
       "6   Blockchain &\\nCybersecurity  \n",
       "7                 Miscellaneous  \n",
       "8                 Miscellaneous  \n",
       "9     Clean & Green\\nTechnology  \n",
       "10                               \n",
       "11    Clean & Green\\nTechnology  \n",
       "12                         None  \n",
       "13         Disaster\\nManagement  "
      ]
     },
     "execution_count": 122,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [],
   "source": [
    "# d2.drop(columns=['Sno','Sno2',],inplace=True)\n",
    "d2.drop(columns=['Organization'],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "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>hello</th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of e-Portal for\\nfacilitating Case...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of gamified\\nplatform on Children'...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Tech-Driven Solutions for\\nUndertrial Prisoner...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Digital Assistant for Legal\\nAwareness and Des...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Developing a Blockchain-\\nBased eVault for Leg...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;\\nCybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>AI-powered Legal\\nDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Incentives based Design for\\nonboarding Legal ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Use of Digital Technology to\\ncalculate water ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Mi</td>\n",
       "      <td>Use of Digital Technology in\\naddressing Non-R...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Projection of the extent of\\ninundation corres...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>Disaster\\nManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      hello  \\\n",
       "0   Ministry of\\nChemicals and\\nFertilizers   \n",
       "1              Ministry of Law and\\nJustice   \n",
       "2              Ministry of Law and\\nJustice   \n",
       "3              Ministry of Law and\\nJustice   \n",
       "4              Ministry of Law and\\nJustice   \n",
       "5              Ministry of Law and\\nJustice   \n",
       "6              Ministry of Law and\\nJustice   \n",
       "7              Ministry of Law and\\nJustice   \n",
       "8              Ministry of Law and\\nJustice   \n",
       "9                   Ministry of Jal\\nShakti   \n",
       "10                                            \n",
       "11                                       Mi   \n",
       "12                                     None   \n",
       "13                  Ministry of Jal\\nShakti   \n",
       "\n",
       "                              Problem Statement Title  Category PS Number  \\\n",
       "0   International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1   Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "2   Development of e-Portal for\\nfacilitating Case...  Software   SIH1280   \n",
       "3   Development of gamified\\nplatform on Children'...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions for\\nUndertrial Prisoner...  Software   SIH1282   \n",
       "5   Digital Assistant for Legal\\nAwareness and Des...  Software   SIH1283   \n",
       "6   Developing a Blockchain-\\nBased eVault for Leg...  Software   SIH1284   \n",
       "7           AI-powered Legal\\nDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design for\\nonboarding Legal ...  Software   SIH1286   \n",
       "9   Use of Digital Technology to\\ncalculate water ...  Software   SIH1287   \n",
       "10                                                                          \n",
       "11  Use of Digital Technology in\\naddressing Non-R...  Software   SIH1288   \n",
       "12                                               None      None      None   \n",
       "13  Projection of the extent of\\ninundation corres...  Software   SIH1289   \n",
       "\n",
       "                  Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3              Smart\\nEducation  \n",
       "4                 Miscellaneous  \n",
       "5              Smart\\nEducation  \n",
       "6   Blockchain &\\nCybersecurity  \n",
       "7                 Miscellaneous  \n",
       "8                 Miscellaneous  \n",
       "9     Clean & Green\\nTechnology  \n",
       "10                               \n",
       "11    Clean & Green\\nTechnology  \n",
       "12                         None  \n",
       "13         Disaster\\nManagement  "
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [],
   "source": [
    "d2.rename(columns={'hello': 'Organization'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "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>Organization</th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of e-Portal for\\nfacilitating Case...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of gamified\\nplatform on Children'...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Tech-Driven Solutions for\\nUndertrial Prisoner...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Digital Assistant for Legal\\nAwareness and Des...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Developing a Blockchain-\\nBased eVault for Leg...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;\\nCybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>AI-powered Legal\\nDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Incentives based Design for\\nonboarding Legal ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Use of Digital Technology to\\ncalculate water ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Mi</td>\n",
       "      <td>Use of Digital Technology in\\naddressing Non-R...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Projection of the extent of\\ninundation corres...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>Disaster\\nManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Organization  \\\n",
       "0   Ministry of\\nChemicals and\\nFertilizers   \n",
       "1              Ministry of Law and\\nJustice   \n",
       "2              Ministry of Law and\\nJustice   \n",
       "3              Ministry of Law and\\nJustice   \n",
       "4              Ministry of Law and\\nJustice   \n",
       "5              Ministry of Law and\\nJustice   \n",
       "6              Ministry of Law and\\nJustice   \n",
       "7              Ministry of Law and\\nJustice   \n",
       "8              Ministry of Law and\\nJustice   \n",
       "9                   Ministry of Jal\\nShakti   \n",
       "10                                            \n",
       "11                                       Mi   \n",
       "12                                     None   \n",
       "13                  Ministry of Jal\\nShakti   \n",
       "\n",
       "                              Problem Statement Title  Category PS Number  \\\n",
       "0   International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1   Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "2   Development of e-Portal for\\nfacilitating Case...  Software   SIH1280   \n",
       "3   Development of gamified\\nplatform on Children'...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions for\\nUndertrial Prisoner...  Software   SIH1282   \n",
       "5   Digital Assistant for Legal\\nAwareness and Des...  Software   SIH1283   \n",
       "6   Developing a Blockchain-\\nBased eVault for Leg...  Software   SIH1284   \n",
       "7           AI-powered Legal\\nDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design for\\nonboarding Legal ...  Software   SIH1286   \n",
       "9   Use of Digital Technology to\\ncalculate water ...  Software   SIH1287   \n",
       "10                                                                          \n",
       "11  Use of Digital Technology in\\naddressing Non-R...  Software   SIH1288   \n",
       "12                                               None      None      None   \n",
       "13  Projection of the extent of\\ninundation corres...  Software   SIH1289   \n",
       "\n",
       "                  Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3              Smart\\nEducation  \n",
       "4                 Miscellaneous  \n",
       "5              Smart\\nEducation  \n",
       "6   Blockchain &\\nCybersecurity  \n",
       "7                 Miscellaneous  \n",
       "8                 Miscellaneous  \n",
       "9     Clean & Green\\nTechnology  \n",
       "10                               \n",
       "11    Clean & Green\\nTechnology  \n",
       "12                         None  \n",
       "13         Disaster\\nManagement  "
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {},
   "outputs": [],
   "source": [
    "d2 = d2.replace(r'^\\s*$', np.nan, regex=True)\n",
    "# converting non empty characters into a string lol a lot diffiut"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "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>Organization</th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of e-Portal for\\nfacilitating Case...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of gamified\\nplatform on Children'...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Tech-Driven Solutions for\\nUndertrial Prisoner...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Digital Assistant for Legal\\nAwareness and Des...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Developing a Blockchain-\\nBased eVault for Leg...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;\\nCybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>AI-powered Legal\\nDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Incentives based Design for\\nonboarding Legal ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Use of Digital Technology to\\ncalculate water ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Mi</td>\n",
       "      <td>Use of Digital Technology in\\naddressing Non-R...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Projection of the extent of\\ninundation corres...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>Disaster\\nManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Organization  \\\n",
       "0   Ministry of\\nChemicals and\\nFertilizers   \n",
       "1              Ministry of Law and\\nJustice   \n",
       "2              Ministry of Law and\\nJustice   \n",
       "3              Ministry of Law and\\nJustice   \n",
       "4              Ministry of Law and\\nJustice   \n",
       "5              Ministry of Law and\\nJustice   \n",
       "6              Ministry of Law and\\nJustice   \n",
       "7              Ministry of Law and\\nJustice   \n",
       "8              Ministry of Law and\\nJustice   \n",
       "9                   Ministry of Jal\\nShakti   \n",
       "10                                      NaN   \n",
       "11                                       Mi   \n",
       "12                                     None   \n",
       "13                  Ministry of Jal\\nShakti   \n",
       "\n",
       "                              Problem Statement Title  Category PS Number  \\\n",
       "0   International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1   Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "2   Development of e-Portal for\\nfacilitating Case...  Software   SIH1280   \n",
       "3   Development of gamified\\nplatform on Children'...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions for\\nUndertrial Prisoner...  Software   SIH1282   \n",
       "5   Digital Assistant for Legal\\nAwareness and Des...  Software   SIH1283   \n",
       "6   Developing a Blockchain-\\nBased eVault for Leg...  Software   SIH1284   \n",
       "7           AI-powered Legal\\nDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design for\\nonboarding Legal ...  Software   SIH1286   \n",
       "9   Use of Digital Technology to\\ncalculate water ...  Software   SIH1287   \n",
       "10                                                NaN       NaN       NaN   \n",
       "11  Use of Digital Technology in\\naddressing Non-R...  Software   SIH1288   \n",
       "12                                               None      None      None   \n",
       "13  Projection of the extent of\\ninundation corres...  Software   SIH1289   \n",
       "\n",
       "                  Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3              Smart\\nEducation  \n",
       "4                 Miscellaneous  \n",
       "5              Smart\\nEducation  \n",
       "6   Blockchain &\\nCybersecurity  \n",
       "7                 Miscellaneous  \n",
       "8                 Miscellaneous  \n",
       "9     Clean & Green\\nTechnology  \n",
       "10                          NaN  \n",
       "11    Clean & Green\\nTechnology  \n",
       "12                         None  \n",
       "13         Disaster\\nManagement  "
      ]
     },
     "execution_count": 139,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "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>Organization</th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of e-Portal for\\nfacilitating Case...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of gamified\\nplatform on Children'...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Tech-Driven Solutions for\\nUndertrial Prisoner...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Digital Assistant for Legal\\nAwareness and Des...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Developing a Blockchain-\\nBased eVault for Leg...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;\\nCybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>AI-powered Legal\\nDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Incentives based Design for\\nonboarding Legal ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Use of Digital Technology to\\ncalculate water ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Mi</td>\n",
       "      <td>Use of Digital Technology in\\naddressing Non-R...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Projection of the extent of\\ninundation corres...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>Disaster\\nManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Organization  \\\n",
       "0   Ministry of\\nChemicals and\\nFertilizers   \n",
       "1              Ministry of Law and\\nJustice   \n",
       "2              Ministry of Law and\\nJustice   \n",
       "3              Ministry of Law and\\nJustice   \n",
       "4              Ministry of Law and\\nJustice   \n",
       "5              Ministry of Law and\\nJustice   \n",
       "6              Ministry of Law and\\nJustice   \n",
       "7              Ministry of Law and\\nJustice   \n",
       "8              Ministry of Law and\\nJustice   \n",
       "9                   Ministry of Jal\\nShakti   \n",
       "11                                       Mi   \n",
       "13                  Ministry of Jal\\nShakti   \n",
       "\n",
       "                              Problem Statement Title  Category PS Number  \\\n",
       "0   International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1   Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "2   Development of e-Portal for\\nfacilitating Case...  Software   SIH1280   \n",
       "3   Development of gamified\\nplatform on Children'...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions for\\nUndertrial Prisoner...  Software   SIH1282   \n",
       "5   Digital Assistant for Legal\\nAwareness and Des...  Software   SIH1283   \n",
       "6   Developing a Blockchain-\\nBased eVault for Leg...  Software   SIH1284   \n",
       "7           AI-powered Legal\\nDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design for\\nonboarding Legal ...  Software   SIH1286   \n",
       "9   Use of Digital Technology to\\ncalculate water ...  Software   SIH1287   \n",
       "11  Use of Digital Technology in\\naddressing Non-R...  Software   SIH1288   \n",
       "13  Projection of the extent of\\ninundation corres...  Software   SIH1289   \n",
       "\n",
       "                  Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3              Smart\\nEducation  \n",
       "4                 Miscellaneous  \n",
       "5              Smart\\nEducation  \n",
       "6   Blockchain &\\nCybersecurity  \n",
       "7                 Miscellaneous  \n",
       "8                 Miscellaneous  \n",
       "9     Clean & Green\\nTechnology  \n",
       "11    Clean & Green\\nTechnology  \n",
       "13         Disaster\\nManagement  "
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2.dropna(how='all', inplace=True)\n",
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "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>Organization</th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of e-Portal for\\nfacilitating Case...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of gamified\\nplatform on Children'...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Tech-Driven Solutions for\\nUndertrial Prisoner...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Digital Assistant for Legal\\nAwareness and Des...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Developing a Blockchain-\\nBased eVault for Leg...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;\\nCybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>AI-powered Legal\\nDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Incentives based Design for\\nonboarding Legal ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Use of Digital Technology to\\ncalculate water ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Mi</td>\n",
       "      <td>Use of Digital Technology in\\naddressing Non-R...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Projection of the extent of\\ninundation corres...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>Disaster\\nManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Organization  \\\n",
       "0   Ministry of\\nChemicals and\\nFertilizers   \n",
       "1              Ministry of Law and\\nJustice   \n",
       "2              Ministry of Law and\\nJustice   \n",
       "3              Ministry of Law and\\nJustice   \n",
       "4              Ministry of Law and\\nJustice   \n",
       "5              Ministry of Law and\\nJustice   \n",
       "6              Ministry of Law and\\nJustice   \n",
       "7              Ministry of Law and\\nJustice   \n",
       "8              Ministry of Law and\\nJustice   \n",
       "9                   Ministry of Jal\\nShakti   \n",
       "11                                       Mi   \n",
       "13                  Ministry of Jal\\nShakti   \n",
       "\n",
       "                              Problem Statement Title  Category PS Number  \\\n",
       "0   International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1   Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "2   Development of e-Portal for\\nfacilitating Case...  Software   SIH1280   \n",
       "3   Development of gamified\\nplatform on Children'...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions for\\nUndertrial Prisoner...  Software   SIH1282   \n",
       "5   Digital Assistant for Legal\\nAwareness and Des...  Software   SIH1283   \n",
       "6   Developing a Blockchain-\\nBased eVault for Leg...  Software   SIH1284   \n",
       "7           AI-powered Legal\\nDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design for\\nonboarding Legal ...  Software   SIH1286   \n",
       "9   Use of Digital Technology to\\ncalculate water ...  Software   SIH1287   \n",
       "11  Use of Digital Technology in\\naddressing Non-R...  Software   SIH1288   \n",
       "13  Projection of the extent of\\ninundation corres...  Software   SIH1289   \n",
       "\n",
       "                  Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3              Smart\\nEducation  \n",
       "4                 Miscellaneous  \n",
       "5              Smart\\nEducation  \n",
       "6   Blockchain &\\nCybersecurity  \n",
       "7                 Miscellaneous  \n",
       "8                 Miscellaneous  \n",
       "9     Clean & Green\\nTechnology  \n",
       "11    Clean & Green\\nTechnology  \n",
       "13         Disaster\\nManagement  "
      ]
     },
     "execution_count": 141,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {},
   "outputs": [],
   "source": [
    "d2.to_csv('page_1.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "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>Organization</th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of e-Portal for\\nfacilitating Case...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of gamified\\nplatform on Children'...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Tech-Driven Solutions for\\nUndertrial Prisoner...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Digital Assistant for Legal\\nAwareness and Des...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Developing a Blockchain-\\nBased eVault for Leg...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;\\nCybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>AI-powered Legal\\nDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Incentives based Design for\\nonboarding Legal ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Use of Digital Technology to\\ncalculate water ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Mi</td>\n",
       "      <td>Use of Digital Technology in\\naddressing Non-R...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Projection of the extent of\\ninundation corres...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>Disaster\\nManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Organization  \\\n",
       "0   Ministry of\\nChemicals and\\nFertilizers   \n",
       "1              Ministry of Law and\\nJustice   \n",
       "2              Ministry of Law and\\nJustice   \n",
       "3              Ministry of Law and\\nJustice   \n",
       "4              Ministry of Law and\\nJustice   \n",
       "5              Ministry of Law and\\nJustice   \n",
       "6              Ministry of Law and\\nJustice   \n",
       "7              Ministry of Law and\\nJustice   \n",
       "8              Ministry of Law and\\nJustice   \n",
       "9                   Ministry of Jal\\nShakti   \n",
       "11                                       Mi   \n",
       "13                  Ministry of Jal\\nShakti   \n",
       "\n",
       "                              Problem Statement Title  Category PS Number  \\\n",
       "0   International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1   Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "2   Development of e-Portal for\\nfacilitating Case...  Software   SIH1280   \n",
       "3   Development of gamified\\nplatform on Children'...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions for\\nUndertrial Prisoner...  Software   SIH1282   \n",
       "5   Digital Assistant for Legal\\nAwareness and Des...  Software   SIH1283   \n",
       "6   Developing a Blockchain-\\nBased eVault for Leg...  Software   SIH1284   \n",
       "7           AI-powered Legal\\nDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design for\\nonboarding Legal ...  Software   SIH1286   \n",
       "9   Use of Digital Technology to\\ncalculate water ...  Software   SIH1287   \n",
       "11  Use of Digital Technology in\\naddressing Non-R...  Software   SIH1288   \n",
       "13  Projection of the extent of\\ninundation corres...  Software   SIH1289   \n",
       "\n",
       "                  Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3              Smart\\nEducation  \n",
       "4                 Miscellaneous  \n",
       "5              Smart\\nEducation  \n",
       "6   Blockchain &\\nCybersecurity  \n",
       "7                 Miscellaneous  \n",
       "8                 Miscellaneous  \n",
       "9     Clean & Green\\nTechnology  \n",
       "11    Clean & Green\\nTechnology  \n",
       "13         Disaster\\nManagement  "
      ]
     },
     "execution_count": 143,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {},
   "outputs": [],
   "source": [
    "d2.iloc[10] = d2.iloc[10].replace(\"Ministry of Jal Shakti\", \"Ministry of JalShakti\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "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>Organization</th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ministry of\\nChemicals and\\nFertilizers</td>\n",
       "      <td>International Comparative\\nSystem to Launch In...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of software for\\nstreamlining the ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of e-Portal for\\nfacilitating Case...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Development of gamified\\nplatform on Children'...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Tech-Driven Solutions for\\nUndertrial Prisoner...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Digital Assistant for Legal\\nAwareness and Des...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>Smart\\nEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Developing a Blockchain-\\nBased eVault for Leg...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;\\nCybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>AI-powered Legal\\nDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ministry of Law and\\nJustice</td>\n",
       "      <td>Incentives based Design for\\nonboarding Legal ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Use of Digital Technology to\\ncalculate water ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ministry of Jal Shakti</td>\n",
       "      <td>Use of Digital Technology in\\naddressing Non-R...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; Green\\nTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ministry of Jal\\nShakti</td>\n",
       "      <td>Projection of the extent of\\ninundation corres...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>Disaster\\nManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Organization  \\\n",
       "0   Ministry of\\nChemicals and\\nFertilizers   \n",
       "1              Ministry of Law and\\nJustice   \n",
       "2              Ministry of Law and\\nJustice   \n",
       "3              Ministry of Law and\\nJustice   \n",
       "4              Ministry of Law and\\nJustice   \n",
       "5              Ministry of Law and\\nJustice   \n",
       "6              Ministry of Law and\\nJustice   \n",
       "7              Ministry of Law and\\nJustice   \n",
       "8              Ministry of Law and\\nJustice   \n",
       "9                   Ministry of Jal\\nShakti   \n",
       "11                   Ministry of Jal Shakti   \n",
       "13                  Ministry of Jal\\nShakti   \n",
       "\n",
       "                              Problem Statement Title  Category PS Number  \\\n",
       "0   International Comparative\\nSystem to Launch In...  Software   SIH1278   \n",
       "1   Development of software for\\nstreamlining the ...  Software   SIH1279   \n",
       "2   Development of e-Portal for\\nfacilitating Case...  Software   SIH1280   \n",
       "3   Development of gamified\\nplatform on Children'...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions for\\nUndertrial Prisoner...  Software   SIH1282   \n",
       "5   Digital Assistant for Legal\\nAwareness and Des...  Software   SIH1283   \n",
       "6   Developing a Blockchain-\\nBased eVault for Leg...  Software   SIH1284   \n",
       "7           AI-powered Legal\\nDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design for\\nonboarding Legal ...  Software   SIH1286   \n",
       "9   Use of Digital Technology to\\ncalculate water ...  Software   SIH1287   \n",
       "11  Use of Digital Technology in\\naddressing Non-R...  Software   SIH1288   \n",
       "13  Projection of the extent of\\ninundation corres...  Software   SIH1289   \n",
       "\n",
       "                  Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3              Smart\\nEducation  \n",
       "4                 Miscellaneous  \n",
       "5              Smart\\nEducation  \n",
       "6   Blockchain &\\nCybersecurity  \n",
       "7                 Miscellaneous  \n",
       "8                 Miscellaneous  \n",
       "9     Clean & Green\\nTechnology  \n",
       "11    Clean & Green\\nTechnology  \n",
       "13         Disaster\\nManagement  "
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [],
   "source": [
    "d2 = d2.replace(r'\\n', '', regex=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "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>Organization</th>\n",
       "      <th>Problem Statement Title</th>\n",
       "      <th>Category</th>\n",
       "      <th>PS Number</th>\n",
       "      <th>Domain Bucket</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ministry ofChemicals andFertilizers</td>\n",
       "      <td>International ComparativeSystem to Launch Inte...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1278</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ministry of Law andJustice</td>\n",
       "      <td>Development of software forstreamlining the li...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1279</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ministry of Law andJustice</td>\n",
       "      <td>Development of e-Portal forfacilitating Case M...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1280</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ministry of Law andJustice</td>\n",
       "      <td>Development of gamifiedplatform on Children's ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1281</td>\n",
       "      <td>SmartEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ministry of Law andJustice</td>\n",
       "      <td>Tech-Driven Solutions forUndertrial Prisoners ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1282</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ministry of Law andJustice</td>\n",
       "      <td>Digital Assistant for LegalAwareness and Desig...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1283</td>\n",
       "      <td>SmartEducation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ministry of Law andJustice</td>\n",
       "      <td>Developing a Blockchain-Based eVault for Legal...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1284</td>\n",
       "      <td>Blockchain &amp;Cybersecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ministry of Law andJustice</td>\n",
       "      <td>AI-powered LegalDocumentation Assistant</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1285</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ministry of Law andJustice</td>\n",
       "      <td>Incentives based Design foronboarding Legal Se...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1286</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ministry of JalShakti</td>\n",
       "      <td>Use of Digital Technology tocalculate water fo...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1287</td>\n",
       "      <td>Clean &amp; GreenTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ministry of JalShakti</td>\n",
       "      <td>Use of Digital Technology inaddressing Non-Rev...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1288</td>\n",
       "      <td>Clean &amp; GreenTechnology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ministry of JalShakti</td>\n",
       "      <td>Projection of the extent ofinundation correspo...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1289</td>\n",
       "      <td>DisasterManagement</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Organization  \\\n",
       "0   Ministry ofChemicals andFertilizers   \n",
       "1            Ministry of Law andJustice   \n",
       "2            Ministry of Law andJustice   \n",
       "3            Ministry of Law andJustice   \n",
       "4            Ministry of Law andJustice   \n",
       "5            Ministry of Law andJustice   \n",
       "6            Ministry of Law andJustice   \n",
       "7            Ministry of Law andJustice   \n",
       "8            Ministry of Law andJustice   \n",
       "9                 Ministry of JalShakti   \n",
       "11                Ministry of JalShakti   \n",
       "13                Ministry of JalShakti   \n",
       "\n",
       "                              Problem Statement Title  Category PS Number  \\\n",
       "0   International ComparativeSystem to Launch Inte...  Software   SIH1278   \n",
       "1   Development of software forstreamlining the li...  Software   SIH1279   \n",
       "2   Development of e-Portal forfacilitating Case M...  Software   SIH1280   \n",
       "3   Development of gamifiedplatform on Children's ...  Software   SIH1281   \n",
       "4   Tech-Driven Solutions forUndertrial Prisoners ...  Software   SIH1282   \n",
       "5   Digital Assistant for LegalAwareness and Desig...  Software   SIH1283   \n",
       "6   Developing a Blockchain-Based eVault for Legal...  Software   SIH1284   \n",
       "7             AI-powered LegalDocumentation Assistant  Software   SIH1285   \n",
       "8   Incentives based Design foronboarding Legal Se...  Software   SIH1286   \n",
       "9   Use of Digital Technology tocalculate water fo...  Software   SIH1287   \n",
       "11  Use of Digital Technology inaddressing Non-Rev...  Software   SIH1288   \n",
       "13  Projection of the extent ofinundation correspo...  Software   SIH1289   \n",
       "\n",
       "                Domain Bucket  \n",
       "0               Miscellaneous  \n",
       "1               Miscellaneous  \n",
       "2               Miscellaneous  \n",
       "3              SmartEducation  \n",
       "4               Miscellaneous  \n",
       "5              SmartEducation  \n",
       "6   Blockchain &Cybersecurity  \n",
       "7               Miscellaneous  \n",
       "8               Miscellaneous  \n",
       "9     Clean & GreenTechnology  \n",
       "11    Clean & GreenTechnology  \n",
       "13         DisasterManagement  "
      ]
     },
     "execution_count": 153,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {},
   "outputs": [],
   "source": [
    "d2.to_csv('page_1.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}