csv_update.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "from IPython.display import display"
   ]
  },
  {
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>40481</td>\n",
       "      <td>50869</td>\n",
       "      <td>DYNAMIC DUDES@</td>\n",
       "      <td>BHAVYA GROVER</td>\n",
       "      <td>145546</td>\n",
       "      <td>MODERN INSTITUTE OF TECHNOLOGY &amp; RESEARCH CENT...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>27179</td>\n",
       "      <td>50141</td>\n",
       "      <td>Swasthya Sahayak</td>\n",
       "      <td>PRAVEEN KUSHWAHA</td>\n",
       "      <td>158737</td>\n",
       "      <td>AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>28982</td>\n",
       "      <td>48836</td>\n",
       "      <td>FusionX!</td>\n",
       "      <td>SANKALP SRIVASTAVA</td>\n",
       "      <td>103531</td>\n",
       "      <td>GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3934</td>\n",
       "      <td>39712</td>\n",
       "      <td>Binks' Crew</td>\n",
       "      <td>SOHAM SAWANT</td>\n",
       "      <td>102748</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3103</td>\n",
       "      <td>47678</td>\n",
       "      <td>Elk Cloners</td>\n",
       "      <td>HITHENDRA B M</td>\n",
       "      <td>131047</td>\n",
       "      <td>VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1300</th>\n",
       "      <td>1301</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>5774</td>\n",
       "      <td>2340</td>\n",
       "      <td>HackWave Nexus</td>\n",
       "      <td>DIPAN SRIMANY</td>\n",
       "      <td>103603</td>\n",
       "      <td>SISTER NIVEDITA UNIVERSITY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1301</th>\n",
       "      <td>1302</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>34862</td>\n",
       "      <td>26612</td>\n",
       "      <td>Aprendiza</td>\n",
       "      <td>GUGGILAM SHANMUKHA SAMBASIVA RAO</td>\n",
       "      <td>117220</td>\n",
       "      <td>NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1302</th>\n",
       "      <td>1303</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>15731</td>\n",
       "      <td>23205</td>\n",
       "      <td>Team NAVYA</td>\n",
       "      <td>RAHUL KUMAR MISHRA</td>\n",
       "      <td>164119</td>\n",
       "      <td>MEGHNAD SAHA INSTITUTE OF TECHNOLOGY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1303</th>\n",
       "      <td>1304</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>11167</td>\n",
       "      <td>14410</td>\n",
       "      <td>LadleLogix</td>\n",
       "      <td>R DASWANTA KUMAR</td>\n",
       "      <td>102497</td>\n",
       "      <td>CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1304</th>\n",
       "      <td>1305</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>29640</td>\n",
       "      <td>20657</td>\n",
       "      <td>HUSTLERS01</td>\n",
       "      <td>P SAI KUMAR</td>\n",
       "      <td>116500</td>\n",
       "      <td>SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1305 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      S.NO.     ORGANISATION     PSID PS CATEGORY  TEAM ID  IDEA ID  \\\n",
       "0         1            AICTE  SIH1458    Software    40481    50869   \n",
       "1         2            AICTE  SIH1458    Software    27179    50141   \n",
       "2         3            AICTE  SIH1458    Software    28982    48836   \n",
       "3         4            AICTE  SIH1458    Software     3934    39712   \n",
       "4         5            AICTE  SIH1458    Software     3103    47678   \n",
       "...     ...              ...      ...         ...      ...      ...   \n",
       "1300   1301  Open Innovation      NaN    Software     5774     2340   \n",
       "1301   1302  Open Innovation      NaN    Software    34862    26612   \n",
       "1302   1303  Open Innovation      NaN    Software    15731    23205   \n",
       "1303   1304  Open Innovation      NaN    Software    11167    14410   \n",
       "1304   1305  Open Innovation      NaN    Software    29640    20657   \n",
       "\n",
       "             TEAM NAME                  TEAM LEADER NAME  COLLEGE ID  \\\n",
       "0       DYNAMIC DUDES@                     BHAVYA GROVER      145546   \n",
       "1     Swasthya Sahayak                  PRAVEEN KUSHWAHA      158737   \n",
       "2             FusionX!                SANKALP SRIVASTAVA      103531   \n",
       "3          Binks' Crew                      SOHAM SAWANT      102748   \n",
       "4          Elk Cloners                     HITHENDRA B M      131047   \n",
       "...                ...                               ...         ...   \n",
       "1300    HackWave Nexus                     DIPAN SRIMANY      103603   \n",
       "1301         Aprendiza  GUGGILAM SHANMUKHA SAMBASIVA RAO      117220   \n",
       "1302        Team NAVYA                RAHUL KUMAR MISHRA      164119   \n",
       "1303        LadleLogix                  R DASWANTA KUMAR      102497   \n",
       "1304        HUSTLERS01                       P SAI KUMAR      116500   \n",
       "\n",
       "                                                COLLEGE  \\\n",
       "0     MODERN INSTITUTE OF TECHNOLOGY & RESEARCH CENT...   \n",
       "1     AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...   \n",
       "2     GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...   \n",
       "3     INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...   \n",
       "4     VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...   \n",
       "...                                                 ...   \n",
       "1300                         SISTER NIVEDITA UNIVERSITY   \n",
       "1301  NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...   \n",
       "1302               MEGHNAD SAHA INSTITUTE OF TECHNOLOGY   \n",
       "1303  CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT   \n",
       "1304  SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI   \n",
       "\n",
       "                      STATUS  \\\n",
       "0                   SELECTED   \n",
       "1                   SELECTED   \n",
       "2                   SELECTED   \n",
       "3                   SELECTED   \n",
       "4                   SELECTED   \n",
       "...                      ...   \n",
       "1300  SELECTED FROM WAITLIST   \n",
       "1301  SELECTED FROM WAITLIST   \n",
       "1302  SELECTED FROM WAITLIST   \n",
       "1303  SELECTED FROM WAITLIST   \n",
       "1304  SELECTED FROM WAITLIST   \n",
       "\n",
       "                                           NODAL CENTER  \n",
       "0     O P Jindal University, Raigarh,Chhattisgarh,Ra...  \n",
       "1     O P Jindal University, Raigarh,Chhattisgarh,Ra...  \n",
       "2     O P Jindal University, Raigarh,Chhattisgarh,Ra...  \n",
       "3     O P Jindal University, Raigarh,Chhattisgarh,Ra...  \n",
       "4     O P Jindal University, Raigarh,Chhattisgarh,Ra...  \n",
       "...                                                 ...  \n",
       "1300  Veer Surendra Sai University of Technology,Sam...  \n",
       "1301  Veer Surendra Sai University of Technology,Sam...  \n",
       "1302  Veer Surendra Sai University of Technology,Sam...  \n",
       "1303  Veer Surendra Sai University of Technology,Sam...  \n",
       "1304  Veer Surendra Sai University of Technology,Sam...  \n",
       "\n",
       "[1305 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Problem Statement Title']=None"
   ]
  },
  {
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</th>\n",
       "      <th>Problem Statement Title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>40481</td>\n",
       "      <td>50869</td>\n",
       "      <td>DYNAMIC DUDES@</td>\n",
       "      <td>BHAVYA GROVER</td>\n",
       "      <td>145546</td>\n",
       "      <td>MODERN INSTITUTE OF TECHNOLOGY &amp; RESEARCH CENT...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>27179</td>\n",
       "      <td>50141</td>\n",
       "      <td>Swasthya Sahayak</td>\n",
       "      <td>PRAVEEN KUSHWAHA</td>\n",
       "      <td>158737</td>\n",
       "      <td>AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>28982</td>\n",
       "      <td>48836</td>\n",
       "      <td>FusionX!</td>\n",
       "      <td>SANKALP SRIVASTAVA</td>\n",
       "      <td>103531</td>\n",
       "      <td>GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3934</td>\n",
       "      <td>39712</td>\n",
       "      <td>Binks' Crew</td>\n",
       "      <td>SOHAM SAWANT</td>\n",
       "      <td>102748</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3103</td>\n",
       "      <td>47678</td>\n",
       "      <td>Elk Cloners</td>\n",
       "      <td>HITHENDRA B M</td>\n",
       "      <td>131047</td>\n",
       "      <td>VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1300</th>\n",
       "      <td>1301</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>5774</td>\n",
       "      <td>2340</td>\n",
       "      <td>HackWave Nexus</td>\n",
       "      <td>DIPAN SRIMANY</td>\n",
       "      <td>103603</td>\n",
       "      <td>SISTER NIVEDITA UNIVERSITY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1301</th>\n",
       "      <td>1302</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>34862</td>\n",
       "      <td>26612</td>\n",
       "      <td>Aprendiza</td>\n",
       "      <td>GUGGILAM SHANMUKHA SAMBASIVA RAO</td>\n",
       "      <td>117220</td>\n",
       "      <td>NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1302</th>\n",
       "      <td>1303</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>15731</td>\n",
       "      <td>23205</td>\n",
       "      <td>Team NAVYA</td>\n",
       "      <td>RAHUL KUMAR MISHRA</td>\n",
       "      <td>164119</td>\n",
       "      <td>MEGHNAD SAHA INSTITUTE OF TECHNOLOGY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1303</th>\n",
       "      <td>1304</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>11167</td>\n",
       "      <td>14410</td>\n",
       "      <td>LadleLogix</td>\n",
       "      <td>R DASWANTA KUMAR</td>\n",
       "      <td>102497</td>\n",
       "      <td>CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1304</th>\n",
       "      <td>1305</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>29640</td>\n",
       "      <td>20657</td>\n",
       "      <td>HUSTLERS01</td>\n",
       "      <td>P SAI KUMAR</td>\n",
       "      <td>116500</td>\n",
       "      <td>SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1305 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      S.NO.     ORGANISATION     PSID PS CATEGORY  TEAM ID  IDEA ID  \\\n",
       "0         1            AICTE  SIH1458    Software    40481    50869   \n",
       "1         2            AICTE  SIH1458    Software    27179    50141   \n",
       "2         3            AICTE  SIH1458    Software    28982    48836   \n",
       "3         4            AICTE  SIH1458    Software     3934    39712   \n",
       "4         5            AICTE  SIH1458    Software     3103    47678   \n",
       "...     ...              ...      ...         ...      ...      ...   \n",
       "1300   1301  Open Innovation      NaN    Software     5774     2340   \n",
       "1301   1302  Open Innovation      NaN    Software    34862    26612   \n",
       "1302   1303  Open Innovation      NaN    Software    15731    23205   \n",
       "1303   1304  Open Innovation      NaN    Software    11167    14410   \n",
       "1304   1305  Open Innovation      NaN    Software    29640    20657   \n",
       "\n",
       "             TEAM NAME                  TEAM LEADER NAME  COLLEGE ID  \\\n",
       "0       DYNAMIC DUDES@                     BHAVYA GROVER      145546   \n",
       "1     Swasthya Sahayak                  PRAVEEN KUSHWAHA      158737   \n",
       "2             FusionX!                SANKALP SRIVASTAVA      103531   \n",
       "3          Binks' Crew                      SOHAM SAWANT      102748   \n",
       "4          Elk Cloners                     HITHENDRA B M      131047   \n",
       "...                ...                               ...         ...   \n",
       "1300    HackWave Nexus                     DIPAN SRIMANY      103603   \n",
       "1301         Aprendiza  GUGGILAM SHANMUKHA SAMBASIVA RAO      117220   \n",
       "1302        Team NAVYA                RAHUL KUMAR MISHRA      164119   \n",
       "1303        LadleLogix                  R DASWANTA KUMAR      102497   \n",
       "1304        HUSTLERS01                       P SAI KUMAR      116500   \n",
       "\n",
       "                                                COLLEGE  \\\n",
       "0     MODERN INSTITUTE OF TECHNOLOGY & RESEARCH CENT...   \n",
       "1     AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...   \n",
       "2     GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...   \n",
       "3     INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...   \n",
       "4     VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...   \n",
       "...                                                 ...   \n",
       "1300                         SISTER NIVEDITA UNIVERSITY   \n",
       "1301  NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...   \n",
       "1302               MEGHNAD SAHA INSTITUTE OF TECHNOLOGY   \n",
       "1303  CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT   \n",
       "1304  SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI   \n",
       "\n",
       "                      STATUS  \\\n",
       "0                   SELECTED   \n",
       "1                   SELECTED   \n",
       "2                   SELECTED   \n",
       "3                   SELECTED   \n",
       "4                   SELECTED   \n",
       "...                      ...   \n",
       "1300  SELECTED FROM WAITLIST   \n",
       "1301  SELECTED FROM WAITLIST   \n",
       "1302  SELECTED FROM WAITLIST   \n",
       "1303  SELECTED FROM WAITLIST   \n",
       "1304  SELECTED FROM WAITLIST   \n",
       "\n",
       "                                           NODAL CENTER  \\\n",
       "0     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "1     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "2     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "3     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "4     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "...                                                 ...   \n",
       "1300  Veer Surendra Sai University of Technology,Sam...   \n",
       "1301  Veer Surendra Sai University of Technology,Sam...   \n",
       "1302  Veer Surendra Sai University of Technology,Sam...   \n",
       "1303  Veer Surendra Sai University of Technology,Sam...   \n",
       "1304  Veer Surendra Sai University of Technology,Sam...   \n",
       "\n",
       "     Problem Statement Title  \n",
       "0                       None  \n",
       "1                       None  \n",
       "2                       None  \n",
       "3                       None  \n",
       "4                       None  \n",
       "...                      ...  \n",
       "1300                    None  \n",
       "1301                    None  \n",
       "1302                    None  \n",
       "1303                    None  \n",
       "1304                    None  \n",
       "\n",
       "[1305 rows x 13 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "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>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>Ministry of Micro, Small and Medium Enterprises</td>\n",
       "      <td>App-Based Solution to provide market access to...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1509</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>Ministry of Rural Development</td>\n",
       "      <td>Land profiling of Asset Creation process</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1510</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ministry of Housing and Urban Affairs</td>\n",
       "      <td>Comprehensive Inspection and Analysis of Water...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1514</td>\n",
       "      <td>Clean &amp; Green Technology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>Ministry of Housing and Urban Affairs</td>\n",
       "      <td>Smart and Effective realtime Management of str...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1515</td>\n",
       "      <td>Smart Automation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Ministry of Housing and Urban Affairs</td>\n",
       "      <td>Suggest an AI-based solution to enable ease of...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1516</td>\n",
       "      <td>Smart Automation</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>182 rows × 5 columns</p>\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",
       "..                                               ...   \n",
       "177  Ministry of Micro, Small and Medium Enterprises   \n",
       "178                    Ministry of Rural Development   \n",
       "179            Ministry of Housing and Urban Affairs   \n",
       "180            Ministry of Housing and Urban Affairs   \n",
       "181            Ministry of Housing and Urban Affairs   \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",
       "..                                                 ...       ...       ...   \n",
       "177  App-Based Solution to provide market access to...  Software   SIH1509   \n",
       "178           Land profiling of Asset Creation process  Software   SIH1510   \n",
       "179  Comprehensive Inspection and Analysis of Water...  Software   SIH1514   \n",
       "180  Smart and Effective realtime Management of str...  Software   SIH1515   \n",
       "181  Suggest an AI-based solution to enable ease of...  Software   SIH1516   \n",
       "\n",
       "                Domain Bucket  \n",
       "0               Miscellaneous  \n",
       "1               Miscellaneous  \n",
       "2               Miscellaneous  \n",
       "3              SmartEducation  \n",
       "4               Miscellaneous  \n",
       "..                        ...  \n",
       "177             Miscellaneous  \n",
       "178             Miscellaneous  \n",
       "179  Clean & Green Technology  \n",
       "180          Smart Automation  \n",
       "181          Smart Automation  \n",
       "\n",
       "[182 rows x 5 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2=pd.read_csv('page.csv')\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</th>\n",
       "      <th>Problem Statement Title_x</th>\n",
       "      <th>Organization</th>\n",
       "      <th>Problem Statement Title_y</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>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>40481</td>\n",
       "      <td>50869</td>\n",
       "      <td>DYNAMIC DUDES@</td>\n",
       "      <td>BHAVYA GROVER</td>\n",
       "      <td>145546</td>\n",
       "      <td>MODERN INSTITUTE OF TECHNOLOGY &amp; RESEARCH CENT...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>27179</td>\n",
       "      <td>50141</td>\n",
       "      <td>Swasthya Sahayak</td>\n",
       "      <td>PRAVEEN KUSHWAHA</td>\n",
       "      <td>158737</td>\n",
       "      <td>AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>28982</td>\n",
       "      <td>48836</td>\n",
       "      <td>FusionX!</td>\n",
       "      <td>SANKALP SRIVASTAVA</td>\n",
       "      <td>103531</td>\n",
       "      <td>GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3934</td>\n",
       "      <td>39712</td>\n",
       "      <td>Binks' Crew</td>\n",
       "      <td>SOHAM SAWANT</td>\n",
       "      <td>102748</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3103</td>\n",
       "      <td>47678</td>\n",
       "      <td>Elk Cloners</td>\n",
       "      <td>HITHENDRA B M</td>\n",
       "      <td>131047</td>\n",
       "      <td>VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1300</th>\n",
       "      <td>1301</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>5774</td>\n",
       "      <td>2340</td>\n",
       "      <td>HackWave Nexus</td>\n",
       "      <td>DIPAN SRIMANY</td>\n",
       "      <td>103603</td>\n",
       "      <td>SISTER NIVEDITA UNIVERSITY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1301</th>\n",
       "      <td>1302</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>34862</td>\n",
       "      <td>26612</td>\n",
       "      <td>Aprendiza</td>\n",
       "      <td>GUGGILAM SHANMUKHA SAMBASIVA RAO</td>\n",
       "      <td>117220</td>\n",
       "      <td>NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1302</th>\n",
       "      <td>1303</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>15731</td>\n",
       "      <td>23205</td>\n",
       "      <td>Team NAVYA</td>\n",
       "      <td>RAHUL KUMAR MISHRA</td>\n",
       "      <td>164119</td>\n",
       "      <td>MEGHNAD SAHA INSTITUTE OF TECHNOLOGY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1303</th>\n",
       "      <td>1304</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>11167</td>\n",
       "      <td>14410</td>\n",
       "      <td>LadleLogix</td>\n",
       "      <td>R DASWANTA KUMAR</td>\n",
       "      <td>102497</td>\n",
       "      <td>CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1304</th>\n",
       "      <td>1305</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>29640</td>\n",
       "      <td>20657</td>\n",
       "      <td>HUSTLERS01</td>\n",
       "      <td>P SAI KUMAR</td>\n",
       "      <td>116500</td>\n",
       "      <td>SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1305 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      S.NO.     ORGANISATION     PSID PS CATEGORY  TEAM ID  IDEA ID  \\\n",
       "0         1            AICTE  SIH1458    Software    40481    50869   \n",
       "1         2            AICTE  SIH1458    Software    27179    50141   \n",
       "2         3            AICTE  SIH1458    Software    28982    48836   \n",
       "3         4            AICTE  SIH1458    Software     3934    39712   \n",
       "4         5            AICTE  SIH1458    Software     3103    47678   \n",
       "...     ...              ...      ...         ...      ...      ...   \n",
       "1300   1301  Open Innovation      NaN    Software     5774     2340   \n",
       "1301   1302  Open Innovation      NaN    Software    34862    26612   \n",
       "1302   1303  Open Innovation      NaN    Software    15731    23205   \n",
       "1303   1304  Open Innovation      NaN    Software    11167    14410   \n",
       "1304   1305  Open Innovation      NaN    Software    29640    20657   \n",
       "\n",
       "             TEAM NAME                  TEAM LEADER NAME  COLLEGE ID  \\\n",
       "0       DYNAMIC DUDES@                     BHAVYA GROVER      145546   \n",
       "1     Swasthya Sahayak                  PRAVEEN KUSHWAHA      158737   \n",
       "2             FusionX!                SANKALP SRIVASTAVA      103531   \n",
       "3          Binks' Crew                      SOHAM SAWANT      102748   \n",
       "4          Elk Cloners                     HITHENDRA B M      131047   \n",
       "...                ...                               ...         ...   \n",
       "1300    HackWave Nexus                     DIPAN SRIMANY      103603   \n",
       "1301         Aprendiza  GUGGILAM SHANMUKHA SAMBASIVA RAO      117220   \n",
       "1302        Team NAVYA                RAHUL KUMAR MISHRA      164119   \n",
       "1303        LadleLogix                  R DASWANTA KUMAR      102497   \n",
       "1304        HUSTLERS01                       P SAI KUMAR      116500   \n",
       "\n",
       "                                                COLLEGE  \\\n",
       "0     MODERN INSTITUTE OF TECHNOLOGY & RESEARCH CENT...   \n",
       "1     AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...   \n",
       "2     GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...   \n",
       "3     INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...   \n",
       "4     VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...   \n",
       "...                                                 ...   \n",
       "1300                         SISTER NIVEDITA UNIVERSITY   \n",
       "1301  NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...   \n",
       "1302               MEGHNAD SAHA INSTITUTE OF TECHNOLOGY   \n",
       "1303  CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT   \n",
       "1304  SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI   \n",
       "\n",
       "                      STATUS  \\\n",
       "0                   SELECTED   \n",
       "1                   SELECTED   \n",
       "2                   SELECTED   \n",
       "3                   SELECTED   \n",
       "4                   SELECTED   \n",
       "...                      ...   \n",
       "1300  SELECTED FROM WAITLIST   \n",
       "1301  SELECTED FROM WAITLIST   \n",
       "1302  SELECTED FROM WAITLIST   \n",
       "1303  SELECTED FROM WAITLIST   \n",
       "1304  SELECTED FROM WAITLIST   \n",
       "\n",
       "                                           NODAL CENTER  \\\n",
       "0     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "1     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "2     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "3     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "4     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "...                                                 ...   \n",
       "1300  Veer Surendra Sai University of Technology,Sam...   \n",
       "1301  Veer Surendra Sai University of Technology,Sam...   \n",
       "1302  Veer Surendra Sai University of Technology,Sam...   \n",
       "1303  Veer Surendra Sai University of Technology,Sam...   \n",
       "1304  Veer Surendra Sai University of Technology,Sam...   \n",
       "\n",
       "     Problem Statement Title_x Organization  \\\n",
       "0                         None        AICTE   \n",
       "1                         None        AICTE   \n",
       "2                         None        AICTE   \n",
       "3                         None        AICTE   \n",
       "4                         None        AICTE   \n",
       "...                        ...          ...   \n",
       "1300                      None          NaN   \n",
       "1301                      None          NaN   \n",
       "1302                      None          NaN   \n",
       "1303                      None          NaN   \n",
       "1304                      None          NaN   \n",
       "\n",
       "                              Problem Statement Title_y  Category PS Number  \\\n",
       "0     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "1     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "2     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "3     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "4     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "...                                                 ...       ...       ...   \n",
       "1300                                                NaN       NaN       NaN   \n",
       "1301                                                NaN       NaN       NaN   \n",
       "1302                                                NaN       NaN       NaN   \n",
       "1303                                                NaN       NaN       NaN   \n",
       "1304                                                NaN       NaN       NaN   \n",
       "\n",
       "      Domain Bucket  \n",
       "0     Miscellaneous  \n",
       "1     Miscellaneous  \n",
       "2     Miscellaneous  \n",
       "3     Miscellaneous  \n",
       "4     Miscellaneous  \n",
       "...             ...  \n",
       "1300            NaN  \n",
       "1301            NaN  \n",
       "1302            NaN  \n",
       "1303            NaN  \n",
       "1304            NaN  \n",
       "\n",
       "[1305 rows x 18 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df=pd.merge(df,df2,left_on='PSID',right_on='PS Number',how='left')\n",
    "merged_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</th>\n",
       "      <th>Problem Statement Title_x</th>\n",
       "      <th>Organization</th>\n",
       "      <th>Problem Statement Title_y</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>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>40481</td>\n",
       "      <td>50869</td>\n",
       "      <td>DYNAMIC DUDES@</td>\n",
       "      <td>BHAVYA GROVER</td>\n",
       "      <td>145546</td>\n",
       "      <td>MODERN INSTITUTE OF TECHNOLOGY &amp; RESEARCH CENT...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>27179</td>\n",
       "      <td>50141</td>\n",
       "      <td>Swasthya Sahayak</td>\n",
       "      <td>PRAVEEN KUSHWAHA</td>\n",
       "      <td>158737</td>\n",
       "      <td>AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>28982</td>\n",
       "      <td>48836</td>\n",
       "      <td>FusionX!</td>\n",
       "      <td>SANKALP SRIVASTAVA</td>\n",
       "      <td>103531</td>\n",
       "      <td>GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3934</td>\n",
       "      <td>39712</td>\n",
       "      <td>Binks' Crew</td>\n",
       "      <td>SOHAM SAWANT</td>\n",
       "      <td>102748</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3103</td>\n",
       "      <td>47678</td>\n",
       "      <td>Elk Cloners</td>\n",
       "      <td>HITHENDRA B M</td>\n",
       "      <td>131047</td>\n",
       "      <td>VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   S.NO. ORGANISATION     PSID PS CATEGORY  TEAM ID  IDEA ID  \\\n",
       "0      1        AICTE  SIH1458    Software    40481    50869   \n",
       "1      2        AICTE  SIH1458    Software    27179    50141   \n",
       "2      3        AICTE  SIH1458    Software    28982    48836   \n",
       "3      4        AICTE  SIH1458    Software     3934    39712   \n",
       "4      5        AICTE  SIH1458    Software     3103    47678   \n",
       "\n",
       "          TEAM NAME    TEAM LEADER NAME  COLLEGE ID  \\\n",
       "0    DYNAMIC DUDES@       BHAVYA GROVER      145546   \n",
       "1  Swasthya Sahayak    PRAVEEN KUSHWAHA      158737   \n",
       "2          FusionX!  SANKALP SRIVASTAVA      103531   \n",
       "3       Binks' Crew        SOHAM SAWANT      102748   \n",
       "4       Elk Cloners       HITHENDRA B M      131047   \n",
       "\n",
       "                                             COLLEGE    STATUS  \\\n",
       "0  MODERN INSTITUTE OF TECHNOLOGY & RESEARCH CENT...  SELECTED   \n",
       "1  AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...  SELECTED   \n",
       "2  GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...  SELECTED   \n",
       "3  INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...  SELECTED   \n",
       "4  VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...  SELECTED   \n",
       "\n",
       "                                        NODAL CENTER  \\\n",
       "0  O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "1  O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "2  O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "3  O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "4  O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "\n",
       "  Problem Statement Title_x Organization  \\\n",
       "0                      None        AICTE   \n",
       "1                      None        AICTE   \n",
       "2                      None        AICTE   \n",
       "3                      None        AICTE   \n",
       "4                      None        AICTE   \n",
       "\n",
       "                           Problem Statement Title_y  Category PS Number  \\\n",
       "0  AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "1  AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "2  AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "3  AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "4  AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "\n",
       "   Domain Bucket  \n",
       "0  Miscellaneous  \n",
       "1  Miscellaneous  \n",
       "2  Miscellaneous  \n",
       "3  Miscellaneous  \n",
       "4  Miscellaneous  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</th>\n",
       "      <th>Problem Statement Title_x</th>\n",
       "      <th>Organization</th>\n",
       "      <th>Problem Statement Title_y</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>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>40481</td>\n",
       "      <td>50869</td>\n",
       "      <td>DYNAMIC DUDES@</td>\n",
       "      <td>BHAVYA GROVER</td>\n",
       "      <td>145546</td>\n",
       "      <td>MODERN INSTITUTE OF TECHNOLOGY &amp; RESEARCH CENT...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>27179</td>\n",
       "      <td>50141</td>\n",
       "      <td>Swasthya Sahayak</td>\n",
       "      <td>PRAVEEN KUSHWAHA</td>\n",
       "      <td>158737</td>\n",
       "      <td>AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>28982</td>\n",
       "      <td>48836</td>\n",
       "      <td>FusionX!</td>\n",
       "      <td>SANKALP SRIVASTAVA</td>\n",
       "      <td>103531</td>\n",
       "      <td>GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3934</td>\n",
       "      <td>39712</td>\n",
       "      <td>Binks' Crew</td>\n",
       "      <td>SOHAM SAWANT</td>\n",
       "      <td>102748</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3103</td>\n",
       "      <td>47678</td>\n",
       "      <td>Elk Cloners</td>\n",
       "      <td>HITHENDRA B M</td>\n",
       "      <td>131047</td>\n",
       "      <td>VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>None</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1300</th>\n",
       "      <td>1301</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>5774</td>\n",
       "      <td>2340</td>\n",
       "      <td>HackWave Nexus</td>\n",
       "      <td>DIPAN SRIMANY</td>\n",
       "      <td>103603</td>\n",
       "      <td>SISTER NIVEDITA UNIVERSITY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1301</th>\n",
       "      <td>1302</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>34862</td>\n",
       "      <td>26612</td>\n",
       "      <td>Aprendiza</td>\n",
       "      <td>GUGGILAM SHANMUKHA SAMBASIVA RAO</td>\n",
       "      <td>117220</td>\n",
       "      <td>NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1302</th>\n",
       "      <td>1303</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>15731</td>\n",
       "      <td>23205</td>\n",
       "      <td>Team NAVYA</td>\n",
       "      <td>RAHUL KUMAR MISHRA</td>\n",
       "      <td>164119</td>\n",
       "      <td>MEGHNAD SAHA INSTITUTE OF TECHNOLOGY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1303</th>\n",
       "      <td>1304</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>11167</td>\n",
       "      <td>14410</td>\n",
       "      <td>LadleLogix</td>\n",
       "      <td>R DASWANTA KUMAR</td>\n",
       "      <td>102497</td>\n",
       "      <td>CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1304</th>\n",
       "      <td>1305</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>29640</td>\n",
       "      <td>20657</td>\n",
       "      <td>HUSTLERS01</td>\n",
       "      <td>P SAI KUMAR</td>\n",
       "      <td>116500</td>\n",
       "      <td>SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1305 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      S.NO.     ORGANISATION     PSID PS CATEGORY  TEAM ID  IDEA ID  \\\n",
       "0         1            AICTE  SIH1458    Software    40481    50869   \n",
       "1         2            AICTE  SIH1458    Software    27179    50141   \n",
       "2         3            AICTE  SIH1458    Software    28982    48836   \n",
       "3         4            AICTE  SIH1458    Software     3934    39712   \n",
       "4         5            AICTE  SIH1458    Software     3103    47678   \n",
       "...     ...              ...      ...         ...      ...      ...   \n",
       "1300   1301  Open Innovation      NaN    Software     5774     2340   \n",
       "1301   1302  Open Innovation      NaN    Software    34862    26612   \n",
       "1302   1303  Open Innovation      NaN    Software    15731    23205   \n",
       "1303   1304  Open Innovation      NaN    Software    11167    14410   \n",
       "1304   1305  Open Innovation      NaN    Software    29640    20657   \n",
       "\n",
       "             TEAM NAME                  TEAM LEADER NAME  COLLEGE ID  \\\n",
       "0       DYNAMIC DUDES@                     BHAVYA GROVER      145546   \n",
       "1     Swasthya Sahayak                  PRAVEEN KUSHWAHA      158737   \n",
       "2             FusionX!                SANKALP SRIVASTAVA      103531   \n",
       "3          Binks' Crew                      SOHAM SAWANT      102748   \n",
       "4          Elk Cloners                     HITHENDRA B M      131047   \n",
       "...                ...                               ...         ...   \n",
       "1300    HackWave Nexus                     DIPAN SRIMANY      103603   \n",
       "1301         Aprendiza  GUGGILAM SHANMUKHA SAMBASIVA RAO      117220   \n",
       "1302        Team NAVYA                RAHUL KUMAR MISHRA      164119   \n",
       "1303        LadleLogix                  R DASWANTA KUMAR      102497   \n",
       "1304        HUSTLERS01                       P SAI KUMAR      116500   \n",
       "\n",
       "                                                COLLEGE  \\\n",
       "0     MODERN INSTITUTE OF TECHNOLOGY & RESEARCH CENT...   \n",
       "1     AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...   \n",
       "2     GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...   \n",
       "3     INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...   \n",
       "4     VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...   \n",
       "...                                                 ...   \n",
       "1300                         SISTER NIVEDITA UNIVERSITY   \n",
       "1301  NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...   \n",
       "1302               MEGHNAD SAHA INSTITUTE OF TECHNOLOGY   \n",
       "1303  CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT   \n",
       "1304  SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI   \n",
       "\n",
       "                      STATUS  \\\n",
       "0                   SELECTED   \n",
       "1                   SELECTED   \n",
       "2                   SELECTED   \n",
       "3                   SELECTED   \n",
       "4                   SELECTED   \n",
       "...                      ...   \n",
       "1300  SELECTED FROM WAITLIST   \n",
       "1301  SELECTED FROM WAITLIST   \n",
       "1302  SELECTED FROM WAITLIST   \n",
       "1303  SELECTED FROM WAITLIST   \n",
       "1304  SELECTED FROM WAITLIST   \n",
       "\n",
       "                                           NODAL CENTER  \\\n",
       "0     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "1     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "2     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "3     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "4     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "...                                                 ...   \n",
       "1300  Veer Surendra Sai University of Technology,Sam...   \n",
       "1301  Veer Surendra Sai University of Technology,Sam...   \n",
       "1302  Veer Surendra Sai University of Technology,Sam...   \n",
       "1303  Veer Surendra Sai University of Technology,Sam...   \n",
       "1304  Veer Surendra Sai University of Technology,Sam...   \n",
       "\n",
       "     Problem Statement Title_x Organization  \\\n",
       "0                         None        AICTE   \n",
       "1                         None        AICTE   \n",
       "2                         None        AICTE   \n",
       "3                         None        AICTE   \n",
       "4                         None        AICTE   \n",
       "...                        ...          ...   \n",
       "1300                      None          NaN   \n",
       "1301                      None          NaN   \n",
       "1302                      None          NaN   \n",
       "1303                      None          NaN   \n",
       "1304                      None          NaN   \n",
       "\n",
       "                              Problem Statement Title_y  Category PS Number  \\\n",
       "0     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "1     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "2     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "3     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "4     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "...                                                 ...       ...       ...   \n",
       "1300                                                NaN       NaN       NaN   \n",
       "1301                                                NaN       NaN       NaN   \n",
       "1302                                                NaN       NaN       NaN   \n",
       "1303                                                NaN       NaN       NaN   \n",
       "1304                                                NaN       NaN       NaN   \n",
       "\n",
       "      Domain Bucket  \n",
       "0     Miscellaneous  \n",
       "1     Miscellaneous  \n",
       "2     Miscellaneous  \n",
       "3     Miscellaneous  \n",
       "4     Miscellaneous  \n",
       "...             ...  \n",
       "1300            NaN  \n",
       "1301            NaN  \n",
       "1302            NaN  \n",
       "1303            NaN  \n",
       "1304            NaN  \n",
       "\n",
       "[1305 rows x 18 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_df.drop('Problem Statement Title_x', axis=1, inplace=True)\n",
    "\n",
    "# Rename the merged column to 'problem statement title'\n",
    "merged_df.rename(columns={'Problem Statement Title_y': 'problem statement title'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</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>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>40481</td>\n",
       "      <td>50869</td>\n",
       "      <td>DYNAMIC DUDES@</td>\n",
       "      <td>BHAVYA GROVER</td>\n",
       "      <td>145546</td>\n",
       "      <td>MODERN INSTITUTE OF TECHNOLOGY &amp; RESEARCH CENT...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>27179</td>\n",
       "      <td>50141</td>\n",
       "      <td>Swasthya Sahayak</td>\n",
       "      <td>PRAVEEN KUSHWAHA</td>\n",
       "      <td>158737</td>\n",
       "      <td>AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>28982</td>\n",
       "      <td>48836</td>\n",
       "      <td>FusionX!</td>\n",
       "      <td>SANKALP SRIVASTAVA</td>\n",
       "      <td>103531</td>\n",
       "      <td>GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3934</td>\n",
       "      <td>39712</td>\n",
       "      <td>Binks' Crew</td>\n",
       "      <td>SOHAM SAWANT</td>\n",
       "      <td>102748</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3103</td>\n",
       "      <td>47678</td>\n",
       "      <td>Elk Cloners</td>\n",
       "      <td>HITHENDRA B M</td>\n",
       "      <td>131047</td>\n",
       "      <td>VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1300</th>\n",
       "      <td>1301</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>5774</td>\n",
       "      <td>2340</td>\n",
       "      <td>HackWave Nexus</td>\n",
       "      <td>DIPAN SRIMANY</td>\n",
       "      <td>103603</td>\n",
       "      <td>SISTER NIVEDITA UNIVERSITY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1301</th>\n",
       "      <td>1302</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>34862</td>\n",
       "      <td>26612</td>\n",
       "      <td>Aprendiza</td>\n",
       "      <td>GUGGILAM SHANMUKHA SAMBASIVA RAO</td>\n",
       "      <td>117220</td>\n",
       "      <td>NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1302</th>\n",
       "      <td>1303</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>15731</td>\n",
       "      <td>23205</td>\n",
       "      <td>Team NAVYA</td>\n",
       "      <td>RAHUL KUMAR MISHRA</td>\n",
       "      <td>164119</td>\n",
       "      <td>MEGHNAD SAHA INSTITUTE OF TECHNOLOGY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1303</th>\n",
       "      <td>1304</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>11167</td>\n",
       "      <td>14410</td>\n",
       "      <td>LadleLogix</td>\n",
       "      <td>R DASWANTA KUMAR</td>\n",
       "      <td>102497</td>\n",
       "      <td>CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1304</th>\n",
       "      <td>1305</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>29640</td>\n",
       "      <td>20657</td>\n",
       "      <td>HUSTLERS01</td>\n",
       "      <td>P SAI KUMAR</td>\n",
       "      <td>116500</td>\n",
       "      <td>SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1305 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      S.NO.     ORGANISATION     PSID PS CATEGORY  TEAM ID  IDEA ID  \\\n",
       "0         1            AICTE  SIH1458    Software    40481    50869   \n",
       "1         2            AICTE  SIH1458    Software    27179    50141   \n",
       "2         3            AICTE  SIH1458    Software    28982    48836   \n",
       "3         4            AICTE  SIH1458    Software     3934    39712   \n",
       "4         5            AICTE  SIH1458    Software     3103    47678   \n",
       "...     ...              ...      ...         ...      ...      ...   \n",
       "1300   1301  Open Innovation      NaN    Software     5774     2340   \n",
       "1301   1302  Open Innovation      NaN    Software    34862    26612   \n",
       "1302   1303  Open Innovation      NaN    Software    15731    23205   \n",
       "1303   1304  Open Innovation      NaN    Software    11167    14410   \n",
       "1304   1305  Open Innovation      NaN    Software    29640    20657   \n",
       "\n",
       "             TEAM NAME                  TEAM LEADER NAME  COLLEGE ID  \\\n",
       "0       DYNAMIC DUDES@                     BHAVYA GROVER      145546   \n",
       "1     Swasthya Sahayak                  PRAVEEN KUSHWAHA      158737   \n",
       "2             FusionX!                SANKALP SRIVASTAVA      103531   \n",
       "3          Binks' Crew                      SOHAM SAWANT      102748   \n",
       "4          Elk Cloners                     HITHENDRA B M      131047   \n",
       "...                ...                               ...         ...   \n",
       "1300    HackWave Nexus                     DIPAN SRIMANY      103603   \n",
       "1301         Aprendiza  GUGGILAM SHANMUKHA SAMBASIVA RAO      117220   \n",
       "1302        Team NAVYA                RAHUL KUMAR MISHRA      164119   \n",
       "1303        LadleLogix                  R DASWANTA KUMAR      102497   \n",
       "1304        HUSTLERS01                       P SAI KUMAR      116500   \n",
       "\n",
       "                                                COLLEGE  \\\n",
       "0     MODERN INSTITUTE OF TECHNOLOGY & RESEARCH CENT...   \n",
       "1     AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...   \n",
       "2     GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...   \n",
       "3     INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...   \n",
       "4     VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...   \n",
       "...                                                 ...   \n",
       "1300                         SISTER NIVEDITA UNIVERSITY   \n",
       "1301  NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...   \n",
       "1302               MEGHNAD SAHA INSTITUTE OF TECHNOLOGY   \n",
       "1303  CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT   \n",
       "1304  SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI   \n",
       "\n",
       "                      STATUS  \\\n",
       "0                   SELECTED   \n",
       "1                   SELECTED   \n",
       "2                   SELECTED   \n",
       "3                   SELECTED   \n",
       "4                   SELECTED   \n",
       "...                      ...   \n",
       "1300  SELECTED FROM WAITLIST   \n",
       "1301  SELECTED FROM WAITLIST   \n",
       "1302  SELECTED FROM WAITLIST   \n",
       "1303  SELECTED FROM WAITLIST   \n",
       "1304  SELECTED FROM WAITLIST   \n",
       "\n",
       "                                           NODAL CENTER Organization  \\\n",
       "0     O P Jindal University, Raigarh,Chhattisgarh,Ra...        AICTE   \n",
       "1     O P Jindal University, Raigarh,Chhattisgarh,Ra...        AICTE   \n",
       "2     O P Jindal University, Raigarh,Chhattisgarh,Ra...        AICTE   \n",
       "3     O P Jindal University, Raigarh,Chhattisgarh,Ra...        AICTE   \n",
       "4     O P Jindal University, Raigarh,Chhattisgarh,Ra...        AICTE   \n",
       "...                                                 ...          ...   \n",
       "1300  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1301  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1302  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1303  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1304  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "\n",
       "                                problem statement title  Category PS Number  \\\n",
       "0     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "1     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "2     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "3     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "4     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "...                                                 ...       ...       ...   \n",
       "1300                                                NaN       NaN       NaN   \n",
       "1301                                                NaN       NaN       NaN   \n",
       "1302                                                NaN       NaN       NaN   \n",
       "1303                                                NaN       NaN       NaN   \n",
       "1304                                                NaN       NaN       NaN   \n",
       "\n",
       "      Domain Bucket  \n",
       "0     Miscellaneous  \n",
       "1     Miscellaneous  \n",
       "2     Miscellaneous  \n",
       "3     Miscellaneous  \n",
       "4     Miscellaneous  \n",
       "...             ...  \n",
       "1300            NaN  \n",
       "1301            NaN  \n",
       "1302            NaN  \n",
       "1303            NaN  \n",
       "1304            NaN  \n",
       "\n",
       "[1305 rows x 17 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</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>42</th>\n",
       "      <td>43</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>42831</td>\n",
       "      <td>41589</td>\n",
       "      <td>Keysight Technology</td>\n",
       "      <td>P.DHANYASRI</td>\n",
       "      <td>118578</td>\n",
       "      <td>LENDI INSTITUTE OF ENGINEERING &amp; TECHNOLOGY, J...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>10877</td>\n",
       "      <td>50490</td>\n",
       "      <td>INNOVATIVE IDEA</td>\n",
       "      <td>MOSES CHARLIE</td>\n",
       "      <td>135674</td>\n",
       "      <td>ST. ALOYSIUS INSTITUTE OF TECHNOLOGY, MANDLA R...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>12317</td>\n",
       "      <td>38426</td>\n",
       "      <td>TEAM AQUA THERAPY</td>\n",
       "      <td>PINNIBOYINA TRIVENI</td>\n",
       "      <td>117071</td>\n",
       "      <td>R.V.R. &amp; J.C. COLLEGE OF ENGINEERING,ANDHRA PR...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>37495</td>\n",
       "      <td>27301</td>\n",
       "      <td>Change Makers_1</td>\n",
       "      <td>LAASYA.S</td>\n",
       "      <td>131038</td>\n",
       "      <td>G S S S INSTITUTE OF ENGINEERING &amp; TECHNOLOGY ...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>35726</td>\n",
       "      <td>23809</td>\n",
       "      <td>Smart-tech-innovator2.0</td>\n",
       "      <td>HULGUTTE NIKITA VIKRAM</td>\n",
       "      <td>142046</td>\n",
       "      <td>N.B. NAVALE SINHAGAD COLLEGE OF ENGINEERING KE...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1300</th>\n",
       "      <td>1301</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>5774</td>\n",
       "      <td>2340</td>\n",
       "      <td>HackWave Nexus</td>\n",
       "      <td>DIPAN SRIMANY</td>\n",
       "      <td>103603</td>\n",
       "      <td>SISTER NIVEDITA UNIVERSITY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1301</th>\n",
       "      <td>1302</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>34862</td>\n",
       "      <td>26612</td>\n",
       "      <td>Aprendiza</td>\n",
       "      <td>GUGGILAM SHANMUKHA SAMBASIVA RAO</td>\n",
       "      <td>117220</td>\n",
       "      <td>NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1302</th>\n",
       "      <td>1303</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>15731</td>\n",
       "      <td>23205</td>\n",
       "      <td>Team NAVYA</td>\n",
       "      <td>RAHUL KUMAR MISHRA</td>\n",
       "      <td>164119</td>\n",
       "      <td>MEGHNAD SAHA INSTITUTE OF TECHNOLOGY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1303</th>\n",
       "      <td>1304</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>11167</td>\n",
       "      <td>14410</td>\n",
       "      <td>LadleLogix</td>\n",
       "      <td>R DASWANTA KUMAR</td>\n",
       "      <td>102497</td>\n",
       "      <td>CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1304</th>\n",
       "      <td>1305</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>29640</td>\n",
       "      <td>20657</td>\n",
       "      <td>HUSTLERS01</td>\n",
       "      <td>P SAI KUMAR</td>\n",
       "      <td>116500</td>\n",
       "      <td>SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>368 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      S.NO.                   ORGANISATION     PSID PS CATEGORY  TEAM ID  \\\n",
       "42       43  AICTE, MIC-Student Innovation  SIH1466    Hardware    42831   \n",
       "43       44  AICTE, MIC-Student Innovation  SIH1466    Hardware    10877   \n",
       "44       45  AICTE, MIC-Student Innovation  SIH1466    Hardware    12317   \n",
       "45       46  AICTE, MIC-Student Innovation  SIH1466    Hardware    37495   \n",
       "46       47  AICTE, MIC-Student Innovation  SIH1466    Hardware    35726   \n",
       "...     ...                            ...      ...         ...      ...   \n",
       "1300   1301                Open Innovation      NaN    Software     5774   \n",
       "1301   1302                Open Innovation      NaN    Software    34862   \n",
       "1302   1303                Open Innovation      NaN    Software    15731   \n",
       "1303   1304                Open Innovation      NaN    Software    11167   \n",
       "1304   1305                Open Innovation      NaN    Software    29640   \n",
       "\n",
       "      IDEA ID                TEAM NAME                  TEAM LEADER NAME  \\\n",
       "42      41589      Keysight Technology                       P.DHANYASRI   \n",
       "43      50490          INNOVATIVE IDEA                     MOSES CHARLIE   \n",
       "44      38426        TEAM AQUA THERAPY               PINNIBOYINA TRIVENI   \n",
       "45      27301          Change Makers_1                          LAASYA.S   \n",
       "46      23809  Smart-tech-innovator2.0            HULGUTTE NIKITA VIKRAM   \n",
       "...       ...                      ...                               ...   \n",
       "1300     2340           HackWave Nexus                     DIPAN SRIMANY   \n",
       "1301    26612                Aprendiza  GUGGILAM SHANMUKHA SAMBASIVA RAO   \n",
       "1302    23205               Team NAVYA                RAHUL KUMAR MISHRA   \n",
       "1303    14410               LadleLogix                  R DASWANTA KUMAR   \n",
       "1304    20657               HUSTLERS01                       P SAI KUMAR   \n",
       "\n",
       "      COLLEGE ID                                            COLLEGE  \\\n",
       "42        118578  LENDI INSTITUTE OF ENGINEERING & TECHNOLOGY, J...   \n",
       "43        135674  ST. ALOYSIUS INSTITUTE OF TECHNOLOGY, MANDLA R...   \n",
       "44        117071  R.V.R. & J.C. COLLEGE OF ENGINEERING,ANDHRA PR...   \n",
       "45        131038  G S S S INSTITUTE OF ENGINEERING & TECHNOLOGY ...   \n",
       "46        142046  N.B. NAVALE SINHAGAD COLLEGE OF ENGINEERING KE...   \n",
       "...          ...                                                ...   \n",
       "1300      103603                         SISTER NIVEDITA UNIVERSITY   \n",
       "1301      117220  NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...   \n",
       "1302      164119               MEGHNAD SAHA INSTITUTE OF TECHNOLOGY   \n",
       "1303      102497  CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT   \n",
       "1304      116500  SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI   \n",
       "\n",
       "                      STATUS  \\\n",
       "42                  SELECTED   \n",
       "43                  SELECTED   \n",
       "44                  SELECTED   \n",
       "45                  SELECTED   \n",
       "46                  SELECTED   \n",
       "...                      ...   \n",
       "1300  SELECTED FROM WAITLIST   \n",
       "1301  SELECTED FROM WAITLIST   \n",
       "1302  SELECTED FROM WAITLIST   \n",
       "1303  SELECTED FROM WAITLIST   \n",
       "1304  SELECTED FROM WAITLIST   \n",
       "\n",
       "                                           NODAL CENTER Organization  \\\n",
       "42    Bhilai Institute of Technology, Durg,Chhattisg...          NaN   \n",
       "43    Bhilai Institute of Technology, Durg,Chhattisg...          NaN   \n",
       "44    Bhilai Institute of Technology, Durg,Chhattisg...          NaN   \n",
       "45    Bhilai Institute of Technology, Durg,Chhattisg...          NaN   \n",
       "46    Bhilai Institute of Technology, Durg,Chhattisg...          NaN   \n",
       "...                                                 ...          ...   \n",
       "1300  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1301  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1302  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1303  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1304  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "\n",
       "     problem statement title Category PS Number Domain Bucket  \n",
       "42                       NaN      NaN       NaN           NaN  \n",
       "43                       NaN      NaN       NaN           NaN  \n",
       "44                       NaN      NaN       NaN           NaN  \n",
       "45                       NaN      NaN       NaN           NaN  \n",
       "46                       NaN      NaN       NaN           NaN  \n",
       "...                      ...      ...       ...           ...  \n",
       "1300                     NaN      NaN       NaN           NaN  \n",
       "1301                     NaN      NaN       NaN           NaN  \n",
       "1302                     NaN      NaN       NaN           NaN  \n",
       "1303                     NaN      NaN       NaN           NaN  \n",
       "1304                     NaN      NaN       NaN           NaN  \n",
       "\n",
       "[368 rows x 17 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rows_with_none = merged_df[merged_df.isna().any(axis=1)]\n",
    "rows_with_none"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "# drop rows where psid is none"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "rows_with_none_in_A = merged_df[merged_df['PSID'].isna()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</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>1282</th>\n",
       "      <td>1283</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>10523</td>\n",
       "      <td>42288</td>\n",
       "      <td>console_log</td>\n",
       "      <td>RAHUL GORAI</td>\n",
       "      <td>103643</td>\n",
       "      <td>INDIAN INSTITUTE OF TECHNOLOGY, KHARAGPUR</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1283</th>\n",
       "      <td>1284</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>405</td>\n",
       "      <td>1172</td>\n",
       "      <td>Falcon</td>\n",
       "      <td>SHAIK ZOHAIB</td>\n",
       "      <td>117304</td>\n",
       "      <td>SESHADRI RAO GUDLAVALLERU ENGINEERING COLLEGE</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1284</th>\n",
       "      <td>1285</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>10609</td>\n",
       "      <td>48406</td>\n",
       "      <td>SIX ELEMENTS</td>\n",
       "      <td>ANKIT KUMAR SONI</td>\n",
       "      <td>103643</td>\n",
       "      <td>INDIAN INSTITUTE OF TECHNOLOGY, KHARAGPUR</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1285</th>\n",
       "      <td>1286</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>8595</td>\n",
       "      <td>18884</td>\n",
       "      <td>CODE CRAFTERSSS</td>\n",
       "      <td>AVILASH BHOWMICK</td>\n",
       "      <td>164119</td>\n",
       "      <td>MEGHNAD SAHA INSTITUTE OF TECHNOLOGY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1286</th>\n",
       "      <td>1287</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>22359</td>\n",
       "      <td>49774</td>\n",
       "      <td>Synchronous Geeks</td>\n",
       "      <td>TIRTHAJYOTI NAG</td>\n",
       "      <td>103602</td>\n",
       "      <td>JIS UNIVERSITY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1287</th>\n",
       "      <td>1288</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>10145</td>\n",
       "      <td>22497</td>\n",
       "      <td>Aurora._</td>\n",
       "      <td>SAUMYA RANJAN JENA</td>\n",
       "      <td>103201</td>\n",
       "      <td>KALINGA INSTITUTE OF INDUSTRIAL TECHNOLOGY, BH...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1288</th>\n",
       "      <td>1289</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>298</td>\n",
       "      <td>4826</td>\n",
       "      <td>CodeElixir_T187</td>\n",
       "      <td>AGNISHA BHATTA</td>\n",
       "      <td>164138</td>\n",
       "      <td>TECHNO INTERNATIONAL NEW TOWN</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1289</th>\n",
       "      <td>1290</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>33025</td>\n",
       "      <td>44289</td>\n",
       "      <td>SENTIMAP</td>\n",
       "      <td>BANDI JAYA SAI SRIKAR</td>\n",
       "      <td>118583</td>\n",
       "      <td>UNIVERSITY COLLEGE OF ENGINEERING, VIZIANAGARAM</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1290</th>\n",
       "      <td>1291</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>10055</td>\n",
       "      <td>14742</td>\n",
       "      <td>Misfits</td>\n",
       "      <td>APURVA JYOTI PAUL</td>\n",
       "      <td>103654</td>\n",
       "      <td>NATIONAL INSTITUTE OF TECHNOLOGY, DURGAPUR</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1291</th>\n",
       "      <td>1292</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>13685</td>\n",
       "      <td>4777</td>\n",
       "      <td>ARCUS_GIFT</td>\n",
       "      <td>ANKIT KUMAR</td>\n",
       "      <td>143669</td>\n",
       "      <td>GANDHI INSTITUTE FOR TECHNOLOGY GIFT, KHURDA, ...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1292</th>\n",
       "      <td>1293</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>24701</td>\n",
       "      <td>19224</td>\n",
       "      <td>Clrt+Alt+Del</td>\n",
       "      <td>SHREYA TIWARI</td>\n",
       "      <td>102613</td>\n",
       "      <td>INTERNATIONAL INSTITUTE OF INFORMATION TECHNOLOGY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293</th>\n",
       "      <td>1294</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>29720</td>\n",
       "      <td>19781</td>\n",
       "      <td>VR Prophets</td>\n",
       "      <td>SATVIKA BHEESETTI</td>\n",
       "      <td>117314</td>\n",
       "      <td>VELAGAPUDI RAMAKRISHNA SIDDHARTHA ENGINEERING ...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1294</th>\n",
       "      <td>1295</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>12898</td>\n",
       "      <td>46958</td>\n",
       "      <td>Ctrl_Alt_Defeat</td>\n",
       "      <td>SHIVAM MALPANI</td>\n",
       "      <td>102611</td>\n",
       "      <td>INDIAN INSTITUTE OF TECHNOLOGY BHILAI</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1295</th>\n",
       "      <td>1296</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>42590</td>\n",
       "      <td>38554</td>\n",
       "      <td>Team saha</td>\n",
       "      <td>D.VINEETHA REDDY</td>\n",
       "      <td>118424</td>\n",
       "      <td>GAYATRI VIDYA PARISHAD COLLEGE OF ENGINEERING ...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1296</th>\n",
       "      <td>1297</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>3890</td>\n",
       "      <td>50735</td>\n",
       "      <td>TEAM WTS</td>\n",
       "      <td>ARNUB SAHOO</td>\n",
       "      <td>103198</td>\n",
       "      <td>C.V. RAMAN GLOBAL UNIVERSITY, ODISHA</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1297</th>\n",
       "      <td>1298</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>11585</td>\n",
       "      <td>15908</td>\n",
       "      <td>Team Glastrier</td>\n",
       "      <td>SRIOM DASH</td>\n",
       "      <td>143391</td>\n",
       "      <td>NATIONAL INSTITUTE OF SCIENCE AND TECHNOLOGY N...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1298</th>\n",
       "      <td>1299</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>4829</td>\n",
       "      <td>8302</td>\n",
       "      <td>LEGAL _BUDDY</td>\n",
       "      <td>ATRAYEE BANERJEE</td>\n",
       "      <td>103628</td>\n",
       "      <td>ADAMAS UNIVERSITY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1299</th>\n",
       "      <td>1300</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>1553</td>\n",
       "      <td>8171</td>\n",
       "      <td>Six of Spades</td>\n",
       "      <td>ABHRAJEET BASAK</td>\n",
       "      <td>164330</td>\n",
       "      <td>ST. THOMAS COLLEGE OF ENGINEERING &amp; TECHNOLOGY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1300</th>\n",
       "      <td>1301</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>5774</td>\n",
       "      <td>2340</td>\n",
       "      <td>HackWave Nexus</td>\n",
       "      <td>DIPAN SRIMANY</td>\n",
       "      <td>103603</td>\n",
       "      <td>SISTER NIVEDITA UNIVERSITY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1301</th>\n",
       "      <td>1302</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>34862</td>\n",
       "      <td>26612</td>\n",
       "      <td>Aprendiza</td>\n",
       "      <td>GUGGILAM SHANMUKHA SAMBASIVA RAO</td>\n",
       "      <td>117220</td>\n",
       "      <td>NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1302</th>\n",
       "      <td>1303</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>15731</td>\n",
       "      <td>23205</td>\n",
       "      <td>Team NAVYA</td>\n",
       "      <td>RAHUL KUMAR MISHRA</td>\n",
       "      <td>164119</td>\n",
       "      <td>MEGHNAD SAHA INSTITUTE OF TECHNOLOGY</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1303</th>\n",
       "      <td>1304</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>11167</td>\n",
       "      <td>14410</td>\n",
       "      <td>LadleLogix</td>\n",
       "      <td>R DASWANTA KUMAR</td>\n",
       "      <td>102497</td>\n",
       "      <td>CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1304</th>\n",
       "      <td>1305</td>\n",
       "      <td>Open Innovation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Software</td>\n",
       "      <td>29640</td>\n",
       "      <td>20657</td>\n",
       "      <td>HUSTLERS01</td>\n",
       "      <td>P SAI KUMAR</td>\n",
       "      <td>116500</td>\n",
       "      <td>SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Veer Surendra Sai University of Technology,Sam...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      S.NO.     ORGANISATION PSID PS CATEGORY  TEAM ID  IDEA ID  \\\n",
       "1282   1283  Open Innovation  NaN    Software    10523    42288   \n",
       "1283   1284  Open Innovation  NaN    Software      405     1172   \n",
       "1284   1285  Open Innovation  NaN    Software    10609    48406   \n",
       "1285   1286  Open Innovation  NaN    Software     8595    18884   \n",
       "1286   1287  Open Innovation  NaN    Software    22359    49774   \n",
       "1287   1288  Open Innovation  NaN    Software    10145    22497   \n",
       "1288   1289  Open Innovation  NaN    Software      298     4826   \n",
       "1289   1290  Open Innovation  NaN    Software    33025    44289   \n",
       "1290   1291  Open Innovation  NaN    Software    10055    14742   \n",
       "1291   1292  Open Innovation  NaN    Software    13685     4777   \n",
       "1292   1293  Open Innovation  NaN    Software    24701    19224   \n",
       "1293   1294  Open Innovation  NaN    Software    29720    19781   \n",
       "1294   1295  Open Innovation  NaN    Software    12898    46958   \n",
       "1295   1296  Open Innovation  NaN    Software    42590    38554   \n",
       "1296   1297  Open Innovation  NaN    Software     3890    50735   \n",
       "1297   1298  Open Innovation  NaN    Software    11585    15908   \n",
       "1298   1299  Open Innovation  NaN    Software     4829     8302   \n",
       "1299   1300  Open Innovation  NaN    Software     1553     8171   \n",
       "1300   1301  Open Innovation  NaN    Software     5774     2340   \n",
       "1301   1302  Open Innovation  NaN    Software    34862    26612   \n",
       "1302   1303  Open Innovation  NaN    Software    15731    23205   \n",
       "1303   1304  Open Innovation  NaN    Software    11167    14410   \n",
       "1304   1305  Open Innovation  NaN    Software    29640    20657   \n",
       "\n",
       "              TEAM NAME                  TEAM LEADER NAME  COLLEGE ID  \\\n",
       "1282        console_log                       RAHUL GORAI      103643   \n",
       "1283             Falcon                      SHAIK ZOHAIB      117304   \n",
       "1284       SIX ELEMENTS                  ANKIT KUMAR SONI      103643   \n",
       "1285    CODE CRAFTERSSS                  AVILASH BHOWMICK      164119   \n",
       "1286  Synchronous Geeks                   TIRTHAJYOTI NAG      103602   \n",
       "1287           Aurora._                SAUMYA RANJAN JENA      103201   \n",
       "1288    CodeElixir_T187                    AGNISHA BHATTA      164138   \n",
       "1289           SENTIMAP             BANDI JAYA SAI SRIKAR      118583   \n",
       "1290            Misfits                 APURVA JYOTI PAUL      103654   \n",
       "1291         ARCUS_GIFT                       ANKIT KUMAR      143669   \n",
       "1292       Clrt+Alt+Del                     SHREYA TIWARI      102613   \n",
       "1293        VR Prophets                 SATVIKA BHEESETTI      117314   \n",
       "1294    Ctrl_Alt_Defeat                    SHIVAM MALPANI      102611   \n",
       "1295          Team saha                  D.VINEETHA REDDY      118424   \n",
       "1296           TEAM WTS                       ARNUB SAHOO      103198   \n",
       "1297     Team Glastrier                        SRIOM DASH      143391   \n",
       "1298       LEGAL _BUDDY                  ATRAYEE BANERJEE      103628   \n",
       "1299      Six of Spades                   ABHRAJEET BASAK      164330   \n",
       "1300     HackWave Nexus                     DIPAN SRIMANY      103603   \n",
       "1301          Aprendiza  GUGGILAM SHANMUKHA SAMBASIVA RAO      117220   \n",
       "1302         Team NAVYA                RAHUL KUMAR MISHRA      164119   \n",
       "1303         LadleLogix                  R DASWANTA KUMAR      102497   \n",
       "1304         HUSTLERS01                       P SAI KUMAR      116500   \n",
       "\n",
       "                                                COLLEGE  \\\n",
       "1282          INDIAN INSTITUTE OF TECHNOLOGY, KHARAGPUR   \n",
       "1283      SESHADRI RAO GUDLAVALLERU ENGINEERING COLLEGE   \n",
       "1284          INDIAN INSTITUTE OF TECHNOLOGY, KHARAGPUR   \n",
       "1285               MEGHNAD SAHA INSTITUTE OF TECHNOLOGY   \n",
       "1286                                     JIS UNIVERSITY   \n",
       "1287  KALINGA INSTITUTE OF INDUSTRIAL TECHNOLOGY, BH...   \n",
       "1288                      TECHNO INTERNATIONAL NEW TOWN   \n",
       "1289    UNIVERSITY COLLEGE OF ENGINEERING, VIZIANAGARAM   \n",
       "1290         NATIONAL INSTITUTE OF TECHNOLOGY, DURGAPUR   \n",
       "1291  GANDHI INSTITUTE FOR TECHNOLOGY GIFT, KHURDA, ...   \n",
       "1292  INTERNATIONAL INSTITUTE OF INFORMATION TECHNOLOGY   \n",
       "1293  VELAGAPUDI RAMAKRISHNA SIDDHARTHA ENGINEERING ...   \n",
       "1294              INDIAN INSTITUTE OF TECHNOLOGY BHILAI   \n",
       "1295  GAYATRI VIDYA PARISHAD COLLEGE OF ENGINEERING ...   \n",
       "1296               C.V. RAMAN GLOBAL UNIVERSITY, ODISHA   \n",
       "1297  NATIONAL INSTITUTE OF SCIENCE AND TECHNOLOGY N...   \n",
       "1298                                  ADAMAS UNIVERSITY   \n",
       "1299     ST. THOMAS COLLEGE OF ENGINEERING & TECHNOLOGY   \n",
       "1300                         SISTER NIVEDITA UNIVERSITY   \n",
       "1301  NARASARAOPETA ENGINEERING COLLEGE, KOTAPPA KON...   \n",
       "1302               MEGHNAD SAHA INSTITUTE OF TECHNOLOGY   \n",
       "1303  CENTURION UNIVERSITY OF TECHNOLOGY AND MANAGEMENT   \n",
       "1304  SREE VIDYANIKETHAN ENGINEERING COLLEGE, TIRUPATHI   \n",
       "\n",
       "                      STATUS  \\\n",
       "1282  SELECTED FROM WAITLIST   \n",
       "1283  SELECTED FROM WAITLIST   \n",
       "1284  SELECTED FROM WAITLIST   \n",
       "1285  SELECTED FROM WAITLIST   \n",
       "1286  SELECTED FROM WAITLIST   \n",
       "1287  SELECTED FROM WAITLIST   \n",
       "1288  SELECTED FROM WAITLIST   \n",
       "1289  SELECTED FROM WAITLIST   \n",
       "1290  SELECTED FROM WAITLIST   \n",
       "1291  SELECTED FROM WAITLIST   \n",
       "1292  SELECTED FROM WAITLIST   \n",
       "1293  SELECTED FROM WAITLIST   \n",
       "1294  SELECTED FROM WAITLIST   \n",
       "1295  SELECTED FROM WAITLIST   \n",
       "1296  SELECTED FROM WAITLIST   \n",
       "1297  SELECTED FROM WAITLIST   \n",
       "1298  SELECTED FROM WAITLIST   \n",
       "1299  SELECTED FROM WAITLIST   \n",
       "1300  SELECTED FROM WAITLIST   \n",
       "1301  SELECTED FROM WAITLIST   \n",
       "1302  SELECTED FROM WAITLIST   \n",
       "1303  SELECTED FROM WAITLIST   \n",
       "1304  SELECTED FROM WAITLIST   \n",
       "\n",
       "                                           NODAL CENTER Organization  \\\n",
       "1282  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1283  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1284  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1285  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1286  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1287  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1288  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1289  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1290  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1291  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1292  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1293  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1294  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1295  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1296  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1297  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1298  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1299  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1300  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1301  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1302  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1303  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "1304  Veer Surendra Sai University of Technology,Sam...          NaN   \n",
       "\n",
       "     problem statement title Category PS Number Domain Bucket  \n",
       "1282                     NaN      NaN       NaN           NaN  \n",
       "1283                     NaN      NaN       NaN           NaN  \n",
       "1284                     NaN      NaN       NaN           NaN  \n",
       "1285                     NaN      NaN       NaN           NaN  \n",
       "1286                     NaN      NaN       NaN           NaN  \n",
       "1287                     NaN      NaN       NaN           NaN  \n",
       "1288                     NaN      NaN       NaN           NaN  \n",
       "1289                     NaN      NaN       NaN           NaN  \n",
       "1290                     NaN      NaN       NaN           NaN  \n",
       "1291                     NaN      NaN       NaN           NaN  \n",
       "1292                     NaN      NaN       NaN           NaN  \n",
       "1293                     NaN      NaN       NaN           NaN  \n",
       "1294                     NaN      NaN       NaN           NaN  \n",
       "1295                     NaN      NaN       NaN           NaN  \n",
       "1296                     NaN      NaN       NaN           NaN  \n",
       "1297                     NaN      NaN       NaN           NaN  \n",
       "1298                     NaN      NaN       NaN           NaN  \n",
       "1299                     NaN      NaN       NaN           NaN  \n",
       "1300                     NaN      NaN       NaN           NaN  \n",
       "1301                     NaN      NaN       NaN           NaN  \n",
       "1302                     NaN      NaN       NaN           NaN  \n",
       "1303                     NaN      NaN       NaN           NaN  \n",
       "1304                     NaN      NaN       NaN           NaN  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rows_with_none_in_A"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_df.dropna(subset=['PSID'],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</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>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>40481</td>\n",
       "      <td>50869</td>\n",
       "      <td>DYNAMIC DUDES@</td>\n",
       "      <td>BHAVYA GROVER</td>\n",
       "      <td>145546</td>\n",
       "      <td>MODERN INSTITUTE OF TECHNOLOGY &amp; RESEARCH CENT...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>27179</td>\n",
       "      <td>50141</td>\n",
       "      <td>Swasthya Sahayak</td>\n",
       "      <td>PRAVEEN KUSHWAHA</td>\n",
       "      <td>158737</td>\n",
       "      <td>AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>28982</td>\n",
       "      <td>48836</td>\n",
       "      <td>FusionX!</td>\n",
       "      <td>SANKALP SRIVASTAVA</td>\n",
       "      <td>103531</td>\n",
       "      <td>GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3934</td>\n",
       "      <td>39712</td>\n",
       "      <td>Binks' Crew</td>\n",
       "      <td>SOHAM SAWANT</td>\n",
       "      <td>102748</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3103</td>\n",
       "      <td>47678</td>\n",
       "      <td>Elk Cloners</td>\n",
       "      <td>HITHENDRA B M</td>\n",
       "      <td>131047</td>\n",
       "      <td>VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1277</th>\n",
       "      <td>1278</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>5312</td>\n",
       "      <td>33571</td>\n",
       "      <td>The Alchemists</td>\n",
       "      <td>UJJWAL JAIN</td>\n",
       "      <td>102979</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, KO...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1278</th>\n",
       "      <td>1279</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>26583</td>\n",
       "      <td>35038</td>\n",
       "      <td>#Cyphers</td>\n",
       "      <td>ADITYA PANDEY</td>\n",
       "      <td>103484</td>\n",
       "      <td>UNIVERSITY OF PETROLEUM AND ENERGY STUDIES, DE...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1279</th>\n",
       "      <td>1280</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>7042</td>\n",
       "      <td>35877</td>\n",
       "      <td>Squadron</td>\n",
       "      <td>SIDDHESH DESAI</td>\n",
       "      <td>140984</td>\n",
       "      <td>BANSILAL RAMNATH AGARWAL CHARITABLE TRUSTS VIS...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1280</th>\n",
       "      <td>1281</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>22834</td>\n",
       "      <td>45446</td>\n",
       "      <td>RYUKS</td>\n",
       "      <td>YASH RAJ DWIVEDI</td>\n",
       "      <td>160890</td>\n",
       "      <td>INSTITUTE OF ENGINEERING &amp; TECHNOLOGY,LUCKNOW,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1281</th>\n",
       "      <td>1282</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>7707</td>\n",
       "      <td>7669</td>\n",
       "      <td>Tech Thinkers1</td>\n",
       "      <td>JAYANTH KOTTE</td>\n",
       "      <td>117204</td>\n",
       "      <td>CHALAPATHI INSTITUTE OF TECHNOLOGY, A.R.NAGAR,...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1282 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      S.NO.                                       ORGANISATION     PSID  \\\n",
       "0         1                                              AICTE  SIH1458   \n",
       "1         2                                              AICTE  SIH1458   \n",
       "2         3                                              AICTE  SIH1458   \n",
       "3         4                                              AICTE  SIH1458   \n",
       "4         5                                              AICTE  SIH1458   \n",
       "...     ...                                                ...      ...   \n",
       "1277   1278  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1278   1279  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1279   1280  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1280   1281  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1281   1282  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "\n",
       "     PS CATEGORY  TEAM ID  IDEA ID         TEAM NAME    TEAM LEADER NAME  \\\n",
       "0       Software    40481    50869    DYNAMIC DUDES@       BHAVYA GROVER   \n",
       "1       Software    27179    50141  Swasthya Sahayak    PRAVEEN KUSHWAHA   \n",
       "2       Software    28982    48836          FusionX!  SANKALP SRIVASTAVA   \n",
       "3       Software     3934    39712       Binks' Crew        SOHAM SAWANT   \n",
       "4       Software     3103    47678       Elk Cloners       HITHENDRA B M   \n",
       "...          ...      ...      ...               ...                 ...   \n",
       "1277    Software     5312    33571    The Alchemists         UJJWAL JAIN   \n",
       "1278    Software    26583    35038          #Cyphers       ADITYA PANDEY   \n",
       "1279    Software     7042    35877          Squadron      SIDDHESH DESAI   \n",
       "1280    Software    22834    45446             RYUKS    YASH RAJ DWIVEDI   \n",
       "1281    Software     7707     7669    Tech Thinkers1       JAYANTH KOTTE   \n",
       "\n",
       "      COLLEGE ID                                            COLLEGE  \\\n",
       "0         145546  MODERN INSTITUTE OF TECHNOLOGY & RESEARCH CENT...   \n",
       "1         158737  AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...   \n",
       "2         103531  GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...   \n",
       "3         102748  INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...   \n",
       "4         131047  VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...   \n",
       "...          ...                                                ...   \n",
       "1277      102979  INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, KO...   \n",
       "1278      103484  UNIVERSITY OF PETROLEUM AND ENERGY STUDIES, DE...   \n",
       "1279      140984  BANSILAL RAMNATH AGARWAL CHARITABLE TRUSTS VIS...   \n",
       "1280      160890  INSTITUTE OF ENGINEERING & TECHNOLOGY,LUCKNOW,...   \n",
       "1281      117204  CHALAPATHI INSTITUTE OF TECHNOLOGY, A.R.NAGAR,...   \n",
       "\n",
       "                      STATUS  \\\n",
       "0                   SELECTED   \n",
       "1                   SELECTED   \n",
       "2                   SELECTED   \n",
       "3                   SELECTED   \n",
       "4                   SELECTED   \n",
       "...                      ...   \n",
       "1277                SELECTED   \n",
       "1278                SELECTED   \n",
       "1279                SELECTED   \n",
       "1280                SELECTED   \n",
       "1281  SELECTED FROM WAITLIST   \n",
       "\n",
       "                                           NODAL CENTER  \\\n",
       "0     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "1     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "2     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "3     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "4     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "...                                                 ...   \n",
       "1277  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1278  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1279  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1280  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1281  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "\n",
       "                                           Organization  \\\n",
       "0                                                 AICTE   \n",
       "1                                                 AICTE   \n",
       "2                                                 AICTE   \n",
       "3                                                 AICTE   \n",
       "4                                                 AICTE   \n",
       "...                                                 ...   \n",
       "1277  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1278  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1279  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1280  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1281  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "\n",
       "                                problem statement title  Category PS Number  \\\n",
       "0     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "1     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "2     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "3     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "4     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "...                                                 ...       ...       ...   \n",
       "1277  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1278  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1279  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1280  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1281  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "\n",
       "                  Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3                 Miscellaneous  \n",
       "4                 Miscellaneous  \n",
       "...                         ...  \n",
       "1277  Transportation& Logistics  \n",
       "1278  Transportation& Logistics  \n",
       "1279  Transportation& Logistics  \n",
       "1280  Transportation& Logistics  \n",
       "1281  Transportation& Logistics  \n",
       "\n",
       "[1282 rows x 17 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</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>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>40481</td>\n",
       "      <td>50869</td>\n",
       "      <td>DYNAMIC DUDES@</td>\n",
       "      <td>BHAVYA GROVER</td>\n",
       "      <td>145546</td>\n",
       "      <td>MODERN INSTITUTE OF TECHNOLOGY &amp; RESEARCH CENT...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>27179</td>\n",
       "      <td>50141</td>\n",
       "      <td>Swasthya Sahayak</td>\n",
       "      <td>PRAVEEN KUSHWAHA</td>\n",
       "      <td>158737</td>\n",
       "      <td>AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>28982</td>\n",
       "      <td>48836</td>\n",
       "      <td>FusionX!</td>\n",
       "      <td>SANKALP SRIVASTAVA</td>\n",
       "      <td>103531</td>\n",
       "      <td>GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3934</td>\n",
       "      <td>39712</td>\n",
       "      <td>Binks' Crew</td>\n",
       "      <td>SOHAM SAWANT</td>\n",
       "      <td>102748</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3103</td>\n",
       "      <td>47678</td>\n",
       "      <td>Elk Cloners</td>\n",
       "      <td>HITHENDRA B M</td>\n",
       "      <td>131047</td>\n",
       "      <td>VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1277</th>\n",
       "      <td>1278</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>5312</td>\n",
       "      <td>33571</td>\n",
       "      <td>The Alchemists</td>\n",
       "      <td>UJJWAL JAIN</td>\n",
       "      <td>102979</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, KO...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1278</th>\n",
       "      <td>1279</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>26583</td>\n",
       "      <td>35038</td>\n",
       "      <td>#Cyphers</td>\n",
       "      <td>ADITYA PANDEY</td>\n",
       "      <td>103484</td>\n",
       "      <td>UNIVERSITY OF PETROLEUM AND ENERGY STUDIES, DE...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1279</th>\n",
       "      <td>1280</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>7042</td>\n",
       "      <td>35877</td>\n",
       "      <td>Squadron</td>\n",
       "      <td>SIDDHESH DESAI</td>\n",
       "      <td>140984</td>\n",
       "      <td>BANSILAL RAMNATH AGARWAL CHARITABLE TRUSTS VIS...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1280</th>\n",
       "      <td>1281</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>22834</td>\n",
       "      <td>45446</td>\n",
       "      <td>RYUKS</td>\n",
       "      <td>YASH RAJ DWIVEDI</td>\n",
       "      <td>160890</td>\n",
       "      <td>INSTITUTE OF ENGINEERING &amp; TECHNOLOGY,LUCKNOW,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1281</th>\n",
       "      <td>1282</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>7707</td>\n",
       "      <td>7669</td>\n",
       "      <td>Tech Thinkers1</td>\n",
       "      <td>JAYANTH KOTTE</td>\n",
       "      <td>117204</td>\n",
       "      <td>CHALAPATHI INSTITUTE OF TECHNOLOGY, A.R.NAGAR,...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1282 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      S.NO.                                       ORGANISATION     PSID  \\\n",
       "0         1                                              AICTE  SIH1458   \n",
       "1         2                                              AICTE  SIH1458   \n",
       "2         3                                              AICTE  SIH1458   \n",
       "3         4                                              AICTE  SIH1458   \n",
       "4         5                                              AICTE  SIH1458   \n",
       "...     ...                                                ...      ...   \n",
       "1277   1278  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1278   1279  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1279   1280  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1280   1281  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1281   1282  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "\n",
       "     PS CATEGORY  TEAM ID  IDEA ID         TEAM NAME    TEAM LEADER NAME  \\\n",
       "0       Software    40481    50869    DYNAMIC DUDES@       BHAVYA GROVER   \n",
       "1       Software    27179    50141  Swasthya Sahayak    PRAVEEN KUSHWAHA   \n",
       "2       Software    28982    48836          FusionX!  SANKALP SRIVASTAVA   \n",
       "3       Software     3934    39712       Binks' Crew        SOHAM SAWANT   \n",
       "4       Software     3103    47678       Elk Cloners       HITHENDRA B M   \n",
       "...          ...      ...      ...               ...                 ...   \n",
       "1277    Software     5312    33571    The Alchemists         UJJWAL JAIN   \n",
       "1278    Software    26583    35038          #Cyphers       ADITYA PANDEY   \n",
       "1279    Software     7042    35877          Squadron      SIDDHESH DESAI   \n",
       "1280    Software    22834    45446             RYUKS    YASH RAJ DWIVEDI   \n",
       "1281    Software     7707     7669    Tech Thinkers1       JAYANTH KOTTE   \n",
       "\n",
       "      COLLEGE ID                                            COLLEGE  \\\n",
       "0         145546  MODERN INSTITUTE OF TECHNOLOGY & RESEARCH CENT...   \n",
       "1         158737  AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...   \n",
       "2         103531  GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...   \n",
       "3         102748  INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...   \n",
       "4         131047  VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...   \n",
       "...          ...                                                ...   \n",
       "1277      102979  INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, KO...   \n",
       "1278      103484  UNIVERSITY OF PETROLEUM AND ENERGY STUDIES, DE...   \n",
       "1279      140984  BANSILAL RAMNATH AGARWAL CHARITABLE TRUSTS VIS...   \n",
       "1280      160890  INSTITUTE OF ENGINEERING & TECHNOLOGY,LUCKNOW,...   \n",
       "1281      117204  CHALAPATHI INSTITUTE OF TECHNOLOGY, A.R.NAGAR,...   \n",
       "\n",
       "                      STATUS  \\\n",
       "0                   SELECTED   \n",
       "1                   SELECTED   \n",
       "2                   SELECTED   \n",
       "3                   SELECTED   \n",
       "4                   SELECTED   \n",
       "...                      ...   \n",
       "1277                SELECTED   \n",
       "1278                SELECTED   \n",
       "1279                SELECTED   \n",
       "1280                SELECTED   \n",
       "1281  SELECTED FROM WAITLIST   \n",
       "\n",
       "                                           NODAL CENTER  \\\n",
       "0     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "1     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "2     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "3     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "4     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "...                                                 ...   \n",
       "1277  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1278  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1279  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1280  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1281  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "\n",
       "                                           Organization  \\\n",
       "0                                                 AICTE   \n",
       "1                                                 AICTE   \n",
       "2                                                 AICTE   \n",
       "3                                                 AICTE   \n",
       "4                                                 AICTE   \n",
       "...                                                 ...   \n",
       "1277  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1278  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1279  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1280  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1281  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "\n",
       "                                problem statement title  Category PS Number  \\\n",
       "0     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "1     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "2     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "3     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "4     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "...                                                 ...       ...       ...   \n",
       "1277  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1278  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1279  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1280  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1281  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "\n",
       "                  Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3                 Miscellaneous  \n",
       "4                 Miscellaneous  \n",
       "...                         ...  \n",
       "1277  Transportation& Logistics  \n",
       "1278  Transportation& Logistics  \n",
       "1279  Transportation& Logistics  \n",
       "1280  Transportation& Logistics  \n",
       "1281  Transportation& Logistics  \n",
       "\n",
       "[1282 rows x 17 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "c=merged_df[merged_df.isna().any(axis=1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [],
   "source": [
    "values=c['PSID'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "nv=values.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "SIH1466\n",
      "SIH1469\n",
      "SIH1470\n",
      "SIH1471\n",
      "SIH1472\n",
      "SIH1473\n",
      "SIH1474\n",
      "SIH1475\n",
      "SIH1476\n",
      "SIH1477\n",
      "SIH1478\n",
      "SIH1479\n",
      "SIH1480\n",
      "SIH1481\n",
      "SIH1482\n",
      "SIH1497\n",
      "SIH1444\n",
      "SIH1361\n",
      "SIH1323\n",
      "SIH1327\n",
      "SIH1517\n",
      "SIH1518\n",
      "SIH1519\n",
      "SIH1520\n",
      "SIH1521\n",
      "SIH1522\n",
      "SIH1523\n",
      "SIH1524\n",
      "SIH1525\n",
      "SIH1503\n",
      "SIH1313\n",
      "SIH1315\n",
      "SIH1414\n",
      "SIH1430\n",
      "SIH1373\n",
      "SIH1499\n",
      "SIH1439\n",
      "SIH1512\n",
      "SIH1513\n",
      "SIH1293\n",
      "SIH1294\n",
      "SIH1328\n",
      "SIH1424\n",
      "SIH1425\n",
      "SIH1426\n",
      "SIH1427\n",
      "SIH1335\n",
      "SIH1336\n",
      "SIH1337\n",
      "SIH1507\n",
      "SIH1511\n",
      "SIH1310\n",
      "SIH1298\n",
      "SIH1299\n",
      "SIH1300\n",
      "SIH1375\n",
      "SIH1376\n",
      "SIH1387\n",
      "SIH1306\n",
      "SIH1368\n",
      "SIH1404\n",
      "SIH1406\n",
      "SIH1448\n"
     ]
    }
   ],
   "source": [
    "for i in nv:\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "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>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>Ministry of Micro, Small and Medium Enterprises</td>\n",
       "      <td>App-Based Solution to provide market access to...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1509</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>Ministry of Rural Development</td>\n",
       "      <td>Land profiling of Asset Creation process</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1510</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ministry of Housing and Urban Affairs</td>\n",
       "      <td>Comprehensive Inspection and Analysis of Water...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1514</td>\n",
       "      <td>Clean &amp; Green Technology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>Ministry of Housing and Urban Affairs</td>\n",
       "      <td>Smart and Effective realtime Management of str...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1515</td>\n",
       "      <td>Smart Automation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Ministry of Housing and Urban Affairs</td>\n",
       "      <td>Suggest an AI-based solution to enable ease of...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1516</td>\n",
       "      <td>Smart Automation</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>182 rows × 5 columns</p>\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",
       "..                                               ...   \n",
       "177  Ministry of Micro, Small and Medium Enterprises   \n",
       "178                    Ministry of Rural Development   \n",
       "179            Ministry of Housing and Urban Affairs   \n",
       "180            Ministry of Housing and Urban Affairs   \n",
       "181            Ministry of Housing and Urban Affairs   \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",
       "..                                                 ...       ...       ...   \n",
       "177  App-Based Solution to provide market access to...  Software   SIH1509   \n",
       "178           Land profiling of Asset Creation process  Software   SIH1510   \n",
       "179  Comprehensive Inspection and Analysis of Water...  Software   SIH1514   \n",
       "180  Smart and Effective realtime Management of str...  Software   SIH1515   \n",
       "181  Suggest an AI-based solution to enable ease of...  Software   SIH1516   \n",
       "\n",
       "                Domain Bucket  \n",
       "0               Miscellaneous  \n",
       "1               Miscellaneous  \n",
       "2               Miscellaneous  \n",
       "3              SmartEducation  \n",
       "4               Miscellaneous  \n",
       "..                        ...  \n",
       "177             Miscellaneous  \n",
       "178             Miscellaneous  \n",
       "179  Clean & Green Technology  \n",
       "180          Smart Automation  \n",
       "181          Smart Automation  \n",
       "\n",
       "[182 rows x 5 columns]"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [],
   "source": [
    "l2=df2['PS Number'].unique().tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Not found {'SIH1466'}\n",
      "Not found {'SIH1469'}\n",
      "Not found {'SIH1470'}\n",
      "Not found {'SIH1471'}\n",
      "Not found {'SIH1472'}\n",
      "Not found {'SIH1473'}\n",
      "Not found {'SIH1474'}\n",
      "Not found {'SIH1475'}\n",
      "Not found {'SIH1476'}\n",
      "Not found {'SIH1477'}\n",
      "Not found {'SIH1478'}\n",
      "Not found {'SIH1479'}\n",
      "Not found {'SIH1480'}\n",
      "Not found {'SIH1481'}\n",
      "Not found {'SIH1482'}\n",
      "Not found {'SIH1497'}\n",
      "Not found {'SIH1444'}\n",
      "Not found {'SIH1361'}\n",
      "Not found {'SIH1323'}\n",
      "Not found {'SIH1327'}\n",
      "Not found {'SIH1517'}\n",
      "Not found {'SIH1518'}\n",
      "Not found {'SIH1519'}\n",
      "Not found {'SIH1520'}\n",
      "Not found {'SIH1521'}\n",
      "Not found {'SIH1522'}\n",
      "Not found {'SIH1523'}\n",
      "Not found {'SIH1524'}\n",
      "Not found {'SIH1525'}\n",
      "Not found {'SIH1503'}\n",
      "Not found {'SIH1313'}\n",
      "Not found {'SIH1315'}\n",
      "Not found {'SIH1414'}\n",
      "Not found {'SIH1430'}\n",
      "Not found {'SIH1373'}\n",
      "Not found {'SIH1499'}\n",
      "Not found {'SIH1439'}\n",
      "Not found {'SIH1512'}\n",
      "Not found {'SIH1513'}\n",
      "Not found {'SIH1293'}\n",
      "Not found {'SIH1294'}\n",
      "Not found {'SIH1328'}\n",
      "Not found {'SIH1424'}\n",
      "Not found {'SIH1425'}\n",
      "Not found {'SIH1426'}\n",
      "Not found {'SIH1427'}\n",
      "Not found {'SIH1335'}\n",
      "Not found {'SIH1336'}\n",
      "Not found {'SIH1337'}\n",
      "Not found {'SIH1507'}\n",
      "Not found {'SIH1511'}\n",
      "Not found {'SIH1310'}\n",
      "Not found {'SIH1298'}\n",
      "Not found {'SIH1299'}\n",
      "Not found {'SIH1300'}\n",
      "Not found {'SIH1375'}\n",
      "Not found {'SIH1376'}\n",
      "Not found {'SIH1387'}\n",
      "Not found {'SIH1306'}\n",
      "Not found {'SIH1368'}\n",
      "Not found {'SIH1404'}\n",
      "Not found {'SIH1406'}\n",
      "Not found {'SIH1448'}\n"
     ]
    }
   ],
   "source": [
    "for i in nv:\n",
    "    if i in l2:\n",
    "        print(i)\n",
    "    else:\n",
    "        print(\"Not found\",{i})"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "So these all pss have been removed, so lets remove them"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</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>42</th>\n",
       "      <td>43</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>42831</td>\n",
       "      <td>41589</td>\n",
       "      <td>Keysight Technology</td>\n",
       "      <td>P.DHANYASRI</td>\n",
       "      <td>118578</td>\n",
       "      <td>LENDI INSTITUTE OF ENGINEERING &amp; TECHNOLOGY, J...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>10877</td>\n",
       "      <td>50490</td>\n",
       "      <td>INNOVATIVE IDEA</td>\n",
       "      <td>MOSES CHARLIE</td>\n",
       "      <td>135674</td>\n",
       "      <td>ST. ALOYSIUS INSTITUTE OF TECHNOLOGY, MANDLA R...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>12317</td>\n",
       "      <td>38426</td>\n",
       "      <td>TEAM AQUA THERAPY</td>\n",
       "      <td>PINNIBOYINA TRIVENI</td>\n",
       "      <td>117071</td>\n",
       "      <td>R.V.R. &amp; J.C. COLLEGE OF ENGINEERING,ANDHRA PR...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>37495</td>\n",
       "      <td>27301</td>\n",
       "      <td>Change Makers_1</td>\n",
       "      <td>LAASYA.S</td>\n",
       "      <td>131038</td>\n",
       "      <td>G S S S INSTITUTE OF ENGINEERING &amp; TECHNOLOGY ...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>35726</td>\n",
       "      <td>23809</td>\n",
       "      <td>Smart-tech-innovator2.0</td>\n",
       "      <td>HULGUTTE NIKITA VIKRAM</td>\n",
       "      <td>142046</td>\n",
       "      <td>N.B. NAVALE SINHAGAD COLLEGE OF ENGINEERING KE...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1228</th>\n",
       "      <td>1229</td>\n",
       "      <td>National Technical Research Organisation,(NTRO)</td>\n",
       "      <td>SIH1448</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>8955</td>\n",
       "      <td>3289</td>\n",
       "      <td>Evolution</td>\n",
       "      <td>RANJEET SINGH</td>\n",
       "      <td>103256</td>\n",
       "      <td>INDIAN INSTITUTE OF TECHNOLOGY, ROPAR,PUNJAB,R...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Galgotias University ,Uttar Pradesh,Greater Noida</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1229</th>\n",
       "      <td>1230</td>\n",
       "      <td>National Technical Research Organisation,(NTRO)</td>\n",
       "      <td>SIH1448</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>17299</td>\n",
       "      <td>9156</td>\n",
       "      <td>TeleConverter</td>\n",
       "      <td>ANIKET ALANKAR THAVAI</td>\n",
       "      <td>141538</td>\n",
       "      <td>MAHATMA EDUCATION SOCIETYS PILLAI HOC COLLEGE ...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Galgotias University ,Uttar Pradesh,Greater Noida</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1230</th>\n",
       "      <td>1231</td>\n",
       "      <td>National Technical Research Organisation,(NTRO)</td>\n",
       "      <td>SIH1448</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>30671</td>\n",
       "      <td>26654</td>\n",
       "      <td>Signal Seekers</td>\n",
       "      <td>SINGARAM S</td>\n",
       "      <td>150177</td>\n",
       "      <td>KUMARAGURU COLLEGE OF TECHNOLOGY,TAMIL NADU,CO...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Galgotias University ,Uttar Pradesh,Greater Noida</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1231</th>\n",
       "      <td>1232</td>\n",
       "      <td>National Technical Research Organisation,(NTRO)</td>\n",
       "      <td>SIH1448</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>36990</td>\n",
       "      <td>39971</td>\n",
       "      <td>Tech Mavens</td>\n",
       "      <td>ARYAN MITTAL</td>\n",
       "      <td>102818</td>\n",
       "      <td>NATIONAL INSTITUTE OF TECHNOLOGY, HAMIRPUR,HIM...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Galgotias University ,Uttar Pradesh,Greater Noida</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1232</th>\n",
       "      <td>1233</td>\n",
       "      <td>National Technical Research Organisation,(NTRO)</td>\n",
       "      <td>SIH1448</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>25860</td>\n",
       "      <td>40718</td>\n",
       "      <td>RFixers</td>\n",
       "      <td>SUSHREE R RUTUDHWAJA SAHOO</td>\n",
       "      <td>143392</td>\n",
       "      <td>PARALA MAHARAJA ENGINEERING COLLEGE, BERHAMPUR...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Galgotias University ,Uttar Pradesh,Greater Noida</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>345 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      S.NO.                                     ORGANISATION     PSID  \\\n",
       "42       43                    AICTE, MIC-Student Innovation  SIH1466   \n",
       "43       44                    AICTE, MIC-Student Innovation  SIH1466   \n",
       "44       45                    AICTE, MIC-Student Innovation  SIH1466   \n",
       "45       46                    AICTE, MIC-Student Innovation  SIH1466   \n",
       "46       47                    AICTE, MIC-Student Innovation  SIH1466   \n",
       "...     ...                                              ...      ...   \n",
       "1228   1229  National Technical Research Organisation,(NTRO)  SIH1448   \n",
       "1229   1230  National Technical Research Organisation,(NTRO)  SIH1448   \n",
       "1230   1231  National Technical Research Organisation,(NTRO)  SIH1448   \n",
       "1231   1232  National Technical Research Organisation,(NTRO)  SIH1448   \n",
       "1232   1233  National Technical Research Organisation,(NTRO)  SIH1448   \n",
       "\n",
       "     PS CATEGORY  TEAM ID  IDEA ID                TEAM NAME  \\\n",
       "42      Hardware    42831    41589      Keysight Technology   \n",
       "43      Hardware    10877    50490          INNOVATIVE IDEA   \n",
       "44      Hardware    12317    38426        TEAM AQUA THERAPY   \n",
       "45      Hardware    37495    27301          Change Makers_1   \n",
       "46      Hardware    35726    23809  Smart-tech-innovator2.0   \n",
       "...          ...      ...      ...                      ...   \n",
       "1228    Hardware     8955     3289                Evolution   \n",
       "1229    Hardware    17299     9156            TeleConverter   \n",
       "1230    Hardware    30671    26654           Signal Seekers   \n",
       "1231    Hardware    36990    39971              Tech Mavens   \n",
       "1232    Hardware    25860    40718                  RFixers   \n",
       "\n",
       "                TEAM LEADER NAME  COLLEGE ID  \\\n",
       "42                   P.DHANYASRI      118578   \n",
       "43                 MOSES CHARLIE      135674   \n",
       "44           PINNIBOYINA TRIVENI      117071   \n",
       "45                      LAASYA.S      131038   \n",
       "46        HULGUTTE NIKITA VIKRAM      142046   \n",
       "...                          ...         ...   \n",
       "1228               RANJEET SINGH      103256   \n",
       "1229       ANIKET ALANKAR THAVAI      141538   \n",
       "1230                  SINGARAM S      150177   \n",
       "1231                ARYAN MITTAL      102818   \n",
       "1232  SUSHREE R RUTUDHWAJA SAHOO      143392   \n",
       "\n",
       "                                                COLLEGE    STATUS  \\\n",
       "42    LENDI INSTITUTE OF ENGINEERING & TECHNOLOGY, J...  SELECTED   \n",
       "43    ST. ALOYSIUS INSTITUTE OF TECHNOLOGY, MANDLA R...  SELECTED   \n",
       "44    R.V.R. & J.C. COLLEGE OF ENGINEERING,ANDHRA PR...  SELECTED   \n",
       "45    G S S S INSTITUTE OF ENGINEERING & TECHNOLOGY ...  SELECTED   \n",
       "46    N.B. NAVALE SINHAGAD COLLEGE OF ENGINEERING KE...  SELECTED   \n",
       "...                                                 ...       ...   \n",
       "1228  INDIAN INSTITUTE OF TECHNOLOGY, ROPAR,PUNJAB,R...  SELECTED   \n",
       "1229  MAHATMA EDUCATION SOCIETYS PILLAI HOC COLLEGE ...  SELECTED   \n",
       "1230  KUMARAGURU COLLEGE OF TECHNOLOGY,TAMIL NADU,CO...  SELECTED   \n",
       "1231  NATIONAL INSTITUTE OF TECHNOLOGY, HAMIRPUR,HIM...  SELECTED   \n",
       "1232  PARALA MAHARAJA ENGINEERING COLLEGE, BERHAMPUR...  SELECTED   \n",
       "\n",
       "                                           NODAL CENTER Organization  \\\n",
       "42    Bhilai Institute of Technology, Durg,Chhattisg...          NaN   \n",
       "43    Bhilai Institute of Technology, Durg,Chhattisg...          NaN   \n",
       "44    Bhilai Institute of Technology, Durg,Chhattisg...          NaN   \n",
       "45    Bhilai Institute of Technology, Durg,Chhattisg...          NaN   \n",
       "46    Bhilai Institute of Technology, Durg,Chhattisg...          NaN   \n",
       "...                                                 ...          ...   \n",
       "1228  Galgotias University ,Uttar Pradesh,Greater Noida          NaN   \n",
       "1229  Galgotias University ,Uttar Pradesh,Greater Noida          NaN   \n",
       "1230  Galgotias University ,Uttar Pradesh,Greater Noida          NaN   \n",
       "1231  Galgotias University ,Uttar Pradesh,Greater Noida          NaN   \n",
       "1232  Galgotias University ,Uttar Pradesh,Greater Noida          NaN   \n",
       "\n",
       "     problem statement title Category PS Number Domain Bucket  \n",
       "42                       NaN      NaN       NaN           NaN  \n",
       "43                       NaN      NaN       NaN           NaN  \n",
       "44                       NaN      NaN       NaN           NaN  \n",
       "45                       NaN      NaN       NaN           NaN  \n",
       "46                       NaN      NaN       NaN           NaN  \n",
       "...                      ...      ...       ...           ...  \n",
       "1228                     NaN      NaN       NaN           NaN  \n",
       "1229                     NaN      NaN       NaN           NaN  \n",
       "1230                     NaN      NaN       NaN           NaN  \n",
       "1231                     NaN      NaN       NaN           NaN  \n",
       "1232                     NaN      NaN       NaN           NaN  \n",
       "\n",
       "[345 rows x 17 columns]"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df[merged_df.isna().any(axis=1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_df_dropped = merged_df.dropna(axis=0, how='any')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</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>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>40481</td>\n",
       "      <td>50869</td>\n",
       "      <td>DYNAMIC DUDES@</td>\n",
       "      <td>BHAVYA GROVER</td>\n",
       "      <td>145546</td>\n",
       "      <td>MODERN INSTITUTE OF TECHNOLOGY &amp; RESEARCH CENT...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>27179</td>\n",
       "      <td>50141</td>\n",
       "      <td>Swasthya Sahayak</td>\n",
       "      <td>PRAVEEN KUSHWAHA</td>\n",
       "      <td>158737</td>\n",
       "      <td>AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>28982</td>\n",
       "      <td>48836</td>\n",
       "      <td>FusionX!</td>\n",
       "      <td>SANKALP SRIVASTAVA</td>\n",
       "      <td>103531</td>\n",
       "      <td>GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3934</td>\n",
       "      <td>39712</td>\n",
       "      <td>Binks' Crew</td>\n",
       "      <td>SOHAM SAWANT</td>\n",
       "      <td>102748</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Software</td>\n",
       "      <td>3103</td>\n",
       "      <td>47678</td>\n",
       "      <td>Elk Cloners</td>\n",
       "      <td>HITHENDRA B M</td>\n",
       "      <td>131047</td>\n",
       "      <td>VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>O P Jindal University, Raigarh,Chhattisgarh,Ra...</td>\n",
       "      <td>AICTE</td>\n",
       "      <td>AI Based - Designing of Assistive portal for S...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1458</td>\n",
       "      <td>Miscellaneous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1277</th>\n",
       "      <td>1278</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>5312</td>\n",
       "      <td>33571</td>\n",
       "      <td>The Alchemists</td>\n",
       "      <td>UJJWAL JAIN</td>\n",
       "      <td>102979</td>\n",
       "      <td>INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, KO...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1278</th>\n",
       "      <td>1279</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>26583</td>\n",
       "      <td>35038</td>\n",
       "      <td>#Cyphers</td>\n",
       "      <td>ADITYA PANDEY</td>\n",
       "      <td>103484</td>\n",
       "      <td>UNIVERSITY OF PETROLEUM AND ENERGY STUDIES, DE...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1279</th>\n",
       "      <td>1280</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>7042</td>\n",
       "      <td>35877</td>\n",
       "      <td>Squadron</td>\n",
       "      <td>SIDDHESH DESAI</td>\n",
       "      <td>140984</td>\n",
       "      <td>BANSILAL RAMNATH AGARWAL CHARITABLE TRUSTS VIS...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1280</th>\n",
       "      <td>1281</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>22834</td>\n",
       "      <td>45446</td>\n",
       "      <td>RYUKS</td>\n",
       "      <td>YASH RAJ DWIVEDI</td>\n",
       "      <td>160890</td>\n",
       "      <td>INSTITUTE OF ENGINEERING &amp; TECHNOLOGY,LUCKNOW,...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1281</th>\n",
       "      <td>1282</td>\n",
       "      <td>Rashtriya Ispat Nigam Limited, Visakhapatnam S...</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Software</td>\n",
       "      <td>7707</td>\n",
       "      <td>7669</td>\n",
       "      <td>Tech Thinkers1</td>\n",
       "      <td>JAYANTH KOTTE</td>\n",
       "      <td>117204</td>\n",
       "      <td>CHALAPATHI INSTITUTE OF TECHNOLOGY, A.R.NAGAR,...</td>\n",
       "      <td>SELECTED FROM WAITLIST</td>\n",
       "      <td>Aditya Engineering College,Andhra Pradesh,Sura...</td>\n",
       "      <td>Rashtriya IspatNigam Limited,VisakhapatnamStee...</td>\n",
       "      <td>Hot metal, Steel Ladle, andScrap pot Tracking ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1332</td>\n",
       "      <td>Transportation&amp; Logistics</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>937 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      S.NO.                                       ORGANISATION     PSID  \\\n",
       "0         1                                              AICTE  SIH1458   \n",
       "1         2                                              AICTE  SIH1458   \n",
       "2         3                                              AICTE  SIH1458   \n",
       "3         4                                              AICTE  SIH1458   \n",
       "4         5                                              AICTE  SIH1458   \n",
       "...     ...                                                ...      ...   \n",
       "1277   1278  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1278   1279  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1279   1280  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1280   1281  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "1281   1282  Rashtriya Ispat Nigam Limited, Visakhapatnam S...  SIH1332   \n",
       "\n",
       "     PS CATEGORY  TEAM ID  IDEA ID         TEAM NAME    TEAM LEADER NAME  \\\n",
       "0       Software    40481    50869    DYNAMIC DUDES@       BHAVYA GROVER   \n",
       "1       Software    27179    50141  Swasthya Sahayak    PRAVEEN KUSHWAHA   \n",
       "2       Software    28982    48836          FusionX!  SANKALP SRIVASTAVA   \n",
       "3       Software     3934    39712       Binks' Crew        SOHAM SAWANT   \n",
       "4       Software     3103    47678       Elk Cloners       HITHENDRA B M   \n",
       "...          ...      ...      ...               ...                 ...   \n",
       "1277    Software     5312    33571    The Alchemists         UJJWAL JAIN   \n",
       "1278    Software    26583    35038          #Cyphers       ADITYA PANDEY   \n",
       "1279    Software     7042    35877          Squadron      SIDDHESH DESAI   \n",
       "1280    Software    22834    45446             RYUKS    YASH RAJ DWIVEDI   \n",
       "1281    Software     7707     7669    Tech Thinkers1       JAYANTH KOTTE   \n",
       "\n",
       "      COLLEGE ID                                            COLLEGE  \\\n",
       "0         145546  MODERN INSTITUTE OF TECHNOLOGY & RESEARCH CENT...   \n",
       "1         158737  AJAY KUMAR GARG ENGINEERING COLLEGE, GHAZIABAD...   \n",
       "2         103531  GALGOTIAS UNIVERSITY,UTTAR PRADESH,GAUTAM BUDD...   \n",
       "3         102748  INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, VA...   \n",
       "4         131047  VIDYA VARDHAKA COLLEGE OF ENGINEERING, MYSORE,...   \n",
       "...          ...                                                ...   \n",
       "1277      102979  INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, KO...   \n",
       "1278      103484  UNIVERSITY OF PETROLEUM AND ENERGY STUDIES, DE...   \n",
       "1279      140984  BANSILAL RAMNATH AGARWAL CHARITABLE TRUSTS VIS...   \n",
       "1280      160890  INSTITUTE OF ENGINEERING & TECHNOLOGY,LUCKNOW,...   \n",
       "1281      117204  CHALAPATHI INSTITUTE OF TECHNOLOGY, A.R.NAGAR,...   \n",
       "\n",
       "                      STATUS  \\\n",
       "0                   SELECTED   \n",
       "1                   SELECTED   \n",
       "2                   SELECTED   \n",
       "3                   SELECTED   \n",
       "4                   SELECTED   \n",
       "...                      ...   \n",
       "1277                SELECTED   \n",
       "1278                SELECTED   \n",
       "1279                SELECTED   \n",
       "1280                SELECTED   \n",
       "1281  SELECTED FROM WAITLIST   \n",
       "\n",
       "                                           NODAL CENTER  \\\n",
       "0     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "1     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "2     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "3     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "4     O P Jindal University, Raigarh,Chhattisgarh,Ra...   \n",
       "...                                                 ...   \n",
       "1277  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1278  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1279  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1280  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "1281  Aditya Engineering College,Andhra Pradesh,Sura...   \n",
       "\n",
       "                                           Organization  \\\n",
       "0                                                 AICTE   \n",
       "1                                                 AICTE   \n",
       "2                                                 AICTE   \n",
       "3                                                 AICTE   \n",
       "4                                                 AICTE   \n",
       "...                                                 ...   \n",
       "1277  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1278  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1279  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1280  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "1281  Rashtriya IspatNigam Limited,VisakhapatnamStee...   \n",
       "\n",
       "                                problem statement title  Category PS Number  \\\n",
       "0     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "1     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "2     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "3     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "4     AI Based - Designing of Assistive portal for S...  Software   SIH1458   \n",
       "...                                                 ...       ...       ...   \n",
       "1277  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1278  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1279  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1280  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "1281  Hot metal, Steel Ladle, andScrap pot Tracking ...  Software   SIH1332   \n",
       "\n",
       "                  Domain Bucket  \n",
       "0                 Miscellaneous  \n",
       "1                 Miscellaneous  \n",
       "2                 Miscellaneous  \n",
       "3                 Miscellaneous  \n",
       "4                 Miscellaneous  \n",
       "...                         ...  \n",
       "1277  Transportation& Logistics  \n",
       "1278  Transportation& Logistics  \n",
       "1279  Transportation& Logistics  \n",
       "1280  Transportation& Logistics  \n",
       "1281  Transportation& Logistics  \n",
       "\n",
       "[937 rows x 17 columns]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df_dropped"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "937\n"
     ]
    }
   ],
   "source": [
    "print(1282-345)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "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>S.NO.</th>\n",
       "      <th>ORGANISATION</th>\n",
       "      <th>PSID</th>\n",
       "      <th>PS CATEGORY</th>\n",
       "      <th>TEAM ID</th>\n",
       "      <th>IDEA ID</th>\n",
       "      <th>TEAM NAME</th>\n",
       "      <th>TEAM LEADER NAME</th>\n",
       "      <th>COLLEGE ID</th>\n",
       "      <th>COLLEGE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>NODAL CENTER</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>40</th>\n",
       "      <td>41</td>\n",
       "      <td>AICTE, MIC</td>\n",
       "      <td>SIH1498</td>\n",
       "      <td>Software</td>\n",
       "      <td>18717</td>\n",
       "      <td>33526</td>\n",
       "      <td>Alias</td>\n",
       "      <td>AIMAN FATIMA</td>\n",
       "      <td>102648</td>\n",
       "      <td>JAMIA MILLIA ISLAMIA UNIVERSITY,DELHI,SOUTH EAST</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Rungta College of Engineering and Technology, ...</td>\n",
       "      <td>AICTE, MIC</td>\n",
       "      <td>Develop a Proctored exam tool for shortlisting...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1498</td>\n",
       "      <td>Smart Automation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>42</td>\n",
       "      <td>AICTE, MIC</td>\n",
       "      <td>SIH1498</td>\n",
       "      <td>Software</td>\n",
       "      <td>4146</td>\n",
       "      <td>1232</td>\n",
       "      <td>THE HAXTERS</td>\n",
       "      <td>VANSH RATHI</td>\n",
       "      <td>134320</td>\n",
       "      <td>LAKSHMI NARAIN COLLEGE OF TECHNOLOGY, KALCHURI...</td>\n",
       "      <td>WILDCARD ENTRY</td>\n",
       "      <td>Rungta College of Engineering and Technology, ...</td>\n",
       "      <td>AICTE, MIC</td>\n",
       "      <td>Develop a Proctored exam tool for shortlisting...</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1498</td>\n",
       "      <td>Smart Automation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>43</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>42831</td>\n",
       "      <td>41589</td>\n",
       "      <td>Keysight Technology</td>\n",
       "      <td>P.DHANYASRI</td>\n",
       "      <td>118578</td>\n",
       "      <td>LENDI INSTITUTE OF ENGINEERING &amp; TECHNOLOGY, J...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>10877</td>\n",
       "      <td>50490</td>\n",
       "      <td>INNOVATIVE IDEA</td>\n",
       "      <td>MOSES CHARLIE</td>\n",
       "      <td>135674</td>\n",
       "      <td>ST. ALOYSIUS INSTITUTE OF TECHNOLOGY, MANDLA R...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>12317</td>\n",
       "      <td>38426</td>\n",
       "      <td>TEAM AQUA THERAPY</td>\n",
       "      <td>PINNIBOYINA TRIVENI</td>\n",
       "      <td>117071</td>\n",
       "      <td>R.V.R. &amp; J.C. COLLEGE OF ENGINEERING,ANDHRA PR...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>37495</td>\n",
       "      <td>27301</td>\n",
       "      <td>Change Makers_1</td>\n",
       "      <td>LAASYA.S</td>\n",
       "      <td>131038</td>\n",
       "      <td>G S S S INSTITUTE OF ENGINEERING &amp; TECHNOLOGY ...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1466</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>35726</td>\n",
       "      <td>23809</td>\n",
       "      <td>Smart-tech-innovator2.0</td>\n",
       "      <td>HULGUTTE NIKITA VIKRAM</td>\n",
       "      <td>142046</td>\n",
       "      <td>N.B. NAVALE SINHAGAD COLLEGE OF ENGINEERING KE...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Bhilai Institute of Technology, Durg,Chhattisg...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>48</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1467</td>\n",
       "      <td>Software</td>\n",
       "      <td>17991</td>\n",
       "      <td>9632</td>\n",
       "      <td>Innovative Integrals</td>\n",
       "      <td>GAURAV PUNANI</td>\n",
       "      <td>144452</td>\n",
       "      <td>BABA FARID COLLEGE, DEON,PUNJAB,BATHINDA</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Prasad V Potluri Siddhartha Institute of Techn...</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>Student Innovation</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1467</td>\n",
       "      <td>Smart Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>49</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1467</td>\n",
       "      <td>Software</td>\n",
       "      <td>14925</td>\n",
       "      <td>7928</td>\n",
       "      <td>Nexus-1</td>\n",
       "      <td>TEJAS BHUSARI</td>\n",
       "      <td>139942</td>\n",
       "      <td>GH RAISONI INSTITUTE OF ENGINEERING AND TECHNO...</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Prasad V Potluri Siddhartha Institute of Techn...</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>Student Innovation</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1467</td>\n",
       "      <td>Smart Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>50</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>SIH1467</td>\n",
       "      <td>Software</td>\n",
       "      <td>15519</td>\n",
       "      <td>9688</td>\n",
       "      <td>CodeCognoscenti</td>\n",
       "      <td>SIDDHARTHA REDDY D</td>\n",
       "      <td>153391</td>\n",
       "      <td>VASAVI COLLEGE OF ENGINEERING,TELANGANA,HYDERABAD</td>\n",
       "      <td>SELECTED</td>\n",
       "      <td>Prasad V Potluri Siddhartha Institute of Techn...</td>\n",
       "      <td>AICTE, MIC-Student Innovation</td>\n",
       "      <td>Student Innovation</td>\n",
       "      <td>Software</td>\n",
       "      <td>SIH1467</td>\n",
       "      <td>Smart Education</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    S.NO.                   ORGANISATION     PSID PS CATEGORY  TEAM ID  \\\n",
       "40     41                     AICTE, MIC  SIH1498    Software    18717   \n",
       "41     42                     AICTE, MIC  SIH1498    Software     4146   \n",
       "42     43  AICTE, MIC-Student Innovation  SIH1466    Hardware    42831   \n",
       "43     44  AICTE, MIC-Student Innovation  SIH1466    Hardware    10877   \n",
       "44     45  AICTE, MIC-Student Innovation  SIH1466    Hardware    12317   \n",
       "45     46  AICTE, MIC-Student Innovation  SIH1466    Hardware    37495   \n",
       "46     47  AICTE, MIC-Student Innovation  SIH1466    Hardware    35726   \n",
       "47     48  AICTE, MIC-Student Innovation  SIH1467    Software    17991   \n",
       "48     49  AICTE, MIC-Student Innovation  SIH1467    Software    14925   \n",
       "49     50  AICTE, MIC-Student Innovation  SIH1467    Software    15519   \n",
       "\n",
       "    IDEA ID                TEAM NAME        TEAM LEADER NAME  COLLEGE ID  \\\n",
       "40    33526                    Alias            AIMAN FATIMA      102648   \n",
       "41     1232              THE HAXTERS             VANSH RATHI      134320   \n",
       "42    41589      Keysight Technology             P.DHANYASRI      118578   \n",
       "43    50490          INNOVATIVE IDEA           MOSES CHARLIE      135674   \n",
       "44    38426        TEAM AQUA THERAPY     PINNIBOYINA TRIVENI      117071   \n",
       "45    27301          Change Makers_1                LAASYA.S      131038   \n",
       "46    23809  Smart-tech-innovator2.0  HULGUTTE NIKITA VIKRAM      142046   \n",
       "47     9632     Innovative Integrals           GAURAV PUNANI      144452   \n",
       "48     7928                  Nexus-1           TEJAS BHUSARI      139942   \n",
       "49     9688          CodeCognoscenti      SIDDHARTHA REDDY D      153391   \n",
       "\n",
       "                                              COLLEGE          STATUS  \\\n",
       "40   JAMIA MILLIA ISLAMIA UNIVERSITY,DELHI,SOUTH EAST        SELECTED   \n",
       "41  LAKSHMI NARAIN COLLEGE OF TECHNOLOGY, KALCHURI...  WILDCARD ENTRY   \n",
       "42  LENDI INSTITUTE OF ENGINEERING & TECHNOLOGY, J...        SELECTED   \n",
       "43  ST. ALOYSIUS INSTITUTE OF TECHNOLOGY, MANDLA R...        SELECTED   \n",
       "44  R.V.R. & J.C. COLLEGE OF ENGINEERING,ANDHRA PR...        SELECTED   \n",
       "45  G S S S INSTITUTE OF ENGINEERING & TECHNOLOGY ...        SELECTED   \n",
       "46  N.B. NAVALE SINHAGAD COLLEGE OF ENGINEERING KE...        SELECTED   \n",
       "47           BABA FARID COLLEGE, DEON,PUNJAB,BATHINDA        SELECTED   \n",
       "48  GH RAISONI INSTITUTE OF ENGINEERING AND TECHNO...        SELECTED   \n",
       "49  VASAVI COLLEGE OF ENGINEERING,TELANGANA,HYDERABAD        SELECTED   \n",
       "\n",
       "                                         NODAL CENTER  \\\n",
       "40  Rungta College of Engineering and Technology, ...   \n",
       "41  Rungta College of Engineering and Technology, ...   \n",
       "42  Bhilai Institute of Technology, Durg,Chhattisg...   \n",
       "43  Bhilai Institute of Technology, Durg,Chhattisg...   \n",
       "44  Bhilai Institute of Technology, Durg,Chhattisg...   \n",
       "45  Bhilai Institute of Technology, Durg,Chhattisg...   \n",
       "46  Bhilai Institute of Technology, Durg,Chhattisg...   \n",
       "47  Prasad V Potluri Siddhartha Institute of Techn...   \n",
       "48  Prasad V Potluri Siddhartha Institute of Techn...   \n",
       "49  Prasad V Potluri Siddhartha Institute of Techn...   \n",
       "\n",
       "                     Organization  \\\n",
       "40                     AICTE, MIC   \n",
       "41                     AICTE, MIC   \n",
       "42                            NaN   \n",
       "43                            NaN   \n",
       "44                            NaN   \n",
       "45                            NaN   \n",
       "46                            NaN   \n",
       "47  AICTE, MIC-Student Innovation   \n",
       "48  AICTE, MIC-Student Innovation   \n",
       "49  AICTE, MIC-Student Innovation   \n",
       "\n",
       "                              problem statement title  Category PS Number  \\\n",
       "40  Develop a Proctored exam tool for shortlisting...  Software   SIH1498   \n",
       "41  Develop a Proctored exam tool for shortlisting...  Software   SIH1498   \n",
       "42                                                NaN       NaN       NaN   \n",
       "43                                                NaN       NaN       NaN   \n",
       "44                                                NaN       NaN       NaN   \n",
       "45                                                NaN       NaN       NaN   \n",
       "46                                                NaN       NaN       NaN   \n",
       "47                                 Student Innovation  Software   SIH1467   \n",
       "48                                 Student Innovation  Software   SIH1467   \n",
       "49                                 Student Innovation  Software   SIH1467   \n",
       "\n",
       "       Domain Bucket  \n",
       "40  Smart Automation  \n",
       "41  Smart Automation  \n",
       "42               NaN  \n",
       "43               NaN  \n",
       "44               NaN  \n",
       "45               NaN  \n",
       "46               NaN  \n",
       "47   Smart Education  \n",
       "48   Smart Education  \n",
       "49   Smart Education  "
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df[40:50]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "so merged df dropped final df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_df_dropped.to_csv('newsih.csv',index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}