Generator (1).ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Sneha\\anaconda3\\Lib\\site-packages\\pandas\\core\\arrays\\masked.py:60: UserWarning: Pandas requires version '1.3.6' or newer of 'bottleneck' (version '1.3.5' currently installed).\n",
      "  from pandas.core import (\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import xlsxwriter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "Sem_data = 'Datesheet Generator.xlsx'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = pd.read_excel(Sem_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Program</th>\n",
       "      <th>Semester</th>\n",
       "      <th>Course Code</th>\n",
       "      <th>Course Name</th>\n",
       "      <th>Course Type</th>\n",
       "      <th>No. of Students</th>\n",
       "      <th>L-T-P</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>B.Sc Chemistry</td>\n",
       "      <td>IV</td>\n",
       "      <td>CHH205B-T</td>\n",
       "      <td>PHYSICAL CHEMISTRY III</td>\n",
       "      <td>Core</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3-1-0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>B.Sc Chemistry</td>\n",
       "      <td>IV</td>\n",
       "      <td>CHH206B-T</td>\n",
       "      <td>INORGANIC CHEMISTRY III</td>\n",
       "      <td>Core</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3-1-0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>B.Sc Chemistry</td>\n",
       "      <td>IV</td>\n",
       "      <td>CHH207B-T</td>\n",
       "      <td>ORGANIC CHEMISTRY III</td>\n",
       "      <td>Core</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0-0-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>B.Sc Chemistry</td>\n",
       "      <td>IV</td>\n",
       "      <td>CHH209B</td>\n",
       "      <td>INDUSTRIAL CHEMISTRY</td>\n",
       "      <td>Elective</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3-1-0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>B.Sc Chemistry</td>\n",
       "      <td>VI</td>\n",
       "      <td>CHH310B</td>\n",
       "      <td>Chemicals &amp; Environment</td>\n",
       "      <td>Elective</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3-1-0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>479</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH313B-T</td>\n",
       "      <td>DATA WAREHOUSE &amp; DATA MINING</td>\n",
       "      <td>Elective</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3-0-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>480</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH314B</td>\n",
       "      <td>MACHINE LEARNING</td>\n",
       "      <td>Elective</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3-0-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>481</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH306B-T</td>\n",
       "      <td>SYSTEM NETWORK &amp; ADMINISTRATION</td>\n",
       "      <td>Elective</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3-0-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>482</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>LWS323/LWS325</td>\n",
       "      <td>CYBER LAW/\\nLAW RELATING TO INTELLECTUAL PROPE...</td>\n",
       "      <td>Elective</td>\n",
       "      <td>30.0</td>\n",
       "      <td>2-0-0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>483</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CDO332</td>\n",
       "      <td>PROFESSIONAL COMPETANCY ENHANCEMENT-IV</td>\n",
       "      <td>CDC</td>\n",
       "      <td>30.0</td>\n",
       "      <td>6-0-0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>483 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     S.No            Program Semester    Course Code  \\\n",
       "0       1     B.Sc Chemistry       IV      CHH205B-T   \n",
       "1       2     B.Sc Chemistry       IV      CHH206B-T   \n",
       "2       3     B.Sc Chemistry       IV      CHH207B-T   \n",
       "3       4     B.Sc Chemistry       IV        CHH209B   \n",
       "4       5     B.Sc Chemistry       VI        CHH310B   \n",
       "..    ...                ...      ...            ...   \n",
       "478   479  B.Tech CSE - CSTI       VI      CSH313B-T   \n",
       "479   480  B.Tech CSE - CSTI       VI        CSH314B   \n",
       "480   481  B.Tech CSE - CSTI       VI      CSH306B-T   \n",
       "481   482  B.Tech CSE - CSTI       VI  LWS323/LWS325   \n",
       "482   483  B.Tech CSE - CSTI       VI         CDO332   \n",
       "\n",
       "                                           Course Name Course Type  \\\n",
       "0                               PHYSICAL CHEMISTRY III        Core   \n",
       "1                              INORGANIC CHEMISTRY III        Core   \n",
       "2                                ORGANIC CHEMISTRY III        Core   \n",
       "3                                 INDUSTRIAL CHEMISTRY    Elective   \n",
       "4                              Chemicals & Environment    Elective   \n",
       "..                                                 ...         ...   \n",
       "478                       DATA WAREHOUSE & DATA MINING    Elective   \n",
       "479                                   MACHINE LEARNING    Elective   \n",
       "480                    SYSTEM NETWORK & ADMINISTRATION    Elective   \n",
       "481  CYBER LAW/\\nLAW RELATING TO INTELLECTUAL PROPE...    Elective   \n",
       "482             PROFESSIONAL COMPETANCY ENHANCEMENT-IV         CDC   \n",
       "\n",
       "     No. of Students  L-T-P  \n",
       "0                9.0  3-1-0  \n",
       "1                9.0  3-1-0  \n",
       "2                9.0  0-0-3  \n",
       "3                9.0  3-1-0  \n",
       "4                5.0  3-1-0  \n",
       "..               ...    ...  \n",
       "478             30.0  3-0-2  \n",
       "479             30.0  3-0-2  \n",
       "480             30.0  3-0-2  \n",
       "481             30.0  2-0-0  \n",
       "482             30.0  6-0-0  \n",
       "\n",
       "[483 rows x 8 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['PHYSICAL CHEMISTRY III', 'INORGANIC CHEMISTRY III',\n",
       "       'ORGANIC CHEMISTRY III', 'INDUSTRIAL CHEMISTRY',\n",
       "       'Chemicals & Environment', 'Physical Chemistry-II',\n",
       "       'Inorganic Chemistry-II', 'Organic Chemistry-II',\n",
       "       'Professional Competency PG-I', 'Electronic Devices',\n",
       "       'Computational Condensed Matter Physics ', 'Career Skills III',\n",
       "       'NUMERICAL ANALYSIS', 'Thermodynamics', 'Solid State Physics',\n",
       "       'Professional Competancy- III', 'Quantum Mechanics-II',\n",
       "       'Statistical Mechanics', 'Atomic and Molecular Physics',\n",
       "       'Professional Competancy PG-I', 'Nanotechnology ',\n",
       "       'ADVANCED ANALYSIS', 'ADVANCED ALGEBRA', 'MECHANICS-I',\n",
       "       'INTEGRAL TRANSFORMS & APPLICATION',\n",
       "       'SURVEY SAMPLING & INDIAN OFFICIAL STATS',\n",
       "       'PROFESSIONAL COMPETENCY-III', 'LINEAR PROGRAMMING & GAME THEORY',\n",
       "       'DISCRETE MATHEMATICS', 'ECONOMETRICS', 'CAREER SKILLS - III',\n",
       "       'MATHEMATICAL MODELLING', 'COMPLEX ANALYSIS',\n",
       "       'FUNCTIONAL ANALYSIS', 'DIFFERENTIAL GEOMETRY',\n",
       "       'OPERATIONS RESEARCH', 'PROFESSIONAL COMPETANCY PG-I',\n",
       "       'ADVANCED OPERATIONS RESEARCH', 'CODING THEORY',\n",
       "       'History:  Indian history-1206 A.D. to 1757 A.D.',\n",
       "       'English: Renaissance and Restoration',\n",
       "       'Political Science:  Indian Constitution',\n",
       "       'Creating an Inclusive Classroom', 'Learner and Learning Process ',\n",
       "       'Professional Communication-II', 'Drama and Art Education',\n",
       "       'History:  National movement (1857 – 1947 A.D)  ',\n",
       "       'English: Indian Writings in English',\n",
       "       'English: Twentieth Century British Literature ',\n",
       "       'Political Science:  Growth &international relations ',\n",
       "       'Assessment For Learning', 'School Organization & Management',\n",
       "       'Basics of Economics',\n",
       "       'History:  Nationalism & Colonialism in Asia (1800 – 1950 A.D.)',\n",
       "       'History: Modern Western Civilization 1789 – 1945 A.D.  ',\n",
       "       'English: Popular Literature  ', 'Economics: Money and Banking  ',\n",
       "       'Political Science: International politics  ',\n",
       "       'Pedagogy of English',\n",
       "       'History: Indian and world history 1750 – 2000 A.D.  ',\n",
       "       'English:  Gender and Literature', 'Economics:  Statistics',\n",
       "       'Political Science:  Social Constructionists and Their Thoughts  ',\n",
       "       'School leadership and Management', 'Peace and Value Education',\n",
       "       'Guidance and  Counselling', 'Human Rights in Education',\n",
       "       'Environment and Education',\n",
       "       'Thermodynamics, Equilibrium and Solutions',\n",
       "       'Bryophytes and Pteridophytes', 'Animal Diversity-II',\n",
       "       'Creating An Inclusive Classroom', 'Organic Chemistry II',\n",
       "       'Plant Systematics and  Angiosperm Phylogeny',\n",
       "       'Cell Biology and Genetics', 'Animal Physiology and Endocrinology',\n",
       "       'Introduction to Finance', 'Basics of Entrepreneurship', 'Optics',\n",
       "       'Probability & Statistics', 'Electrochemistry and Photochemistry',\n",
       "       'Relativity and Quantum Mechanics',\n",
       "       'Plant Physiology and Metabolism', 'GROUPS AND RINGS',\n",
       "       'COMPLEX ANALYSIS & NUMERICAL ANALYSIS',\n",
       "       'Developmental Biology and Applied Zoology',\n",
       "       'Pedagogy of Physical Sciences', 'Reading And Reflection On Texts',\n",
       "       'Spectroscopy, Natural Products and  Heterocyclics',\n",
       "       'Nuclear and Solid State Physics',\n",
       "       'Biochemistry , Plant Tissue culture and Biotechnology',\n",
       "       ' Genetics and Palentology', 'Linear Algebra ',\n",
       "       'Molecular Biology and  Immunology ', 'Guidance and  Counseling',\n",
       "       'Learning and Teaching', 'Assessment for Learning',\n",
       "       'Pedagogy of Commerce', 'Pedagogy of Physical Science',\n",
       "       'Pedagogy of Hindi', 'Language and Curriculum',\n",
       "       ' Professional Communication II', 'Guidance and Counseling',\n",
       "       'Applied Behaviour Analysis', 'Early Childhood Care & Education',\n",
       "       'Management of Learning Disability',\n",
       "       'Vocational Training, Transition & Job Placement',\n",
       "       'Other Disability Special School', 'Inclusive School',\n",
       "       'PHYSICS FOR ENGINEERS',\n",
       "       'MATHEMATICS – II (DIFFERENTIAL EQUATIONS)',\n",
       "       'ELECRONIC DEVICES & CIRCUITS', 'INTRODUCTION TO DATA STRUCTURE',\n",
       "       'APPLIED PHILOSOPHY', 'APPLIED PSYCHOLOGY', 'APPLIED SOCIOLOGY',\n",
       "       'PROFESSIONAL ENGLISH ', 'ENVIRONMENTAL SCIENCES',\n",
       "       'PROFESSIONAL COMMUNICATION-II', 'ELECTROMAGNETIC FIELD AND WAVES',\n",
       "       'ANALOG AND DIGITAL COMMUNICATION',\n",
       "       'MICROPROCESSORS & INTERFACING', 'VLSI DESIGN',\n",
       "       'PROFESSIONAL COMPETANCY ENHANCEMENT-II',\n",
       "       'PROGRAMMING FOR PROBLEM SOLVING USING PYTHON',\n",
       "       'RESEARCH & INNOVATION-I', 'SPANISH-II', 'GERMAN-II', 'FRENCH-II',\n",
       "       'DIGITAL SIGNAL AND IMAGE PROCESSING', 'CONTROL SYSTEMS',\n",
       "       'WIRELESS & MOBILE COMMUNICATION',\n",
       "       'PLC PROGRAMMING AND APPLICATIONS', 'CYBER LAW',\n",
       "       'LAW RELATING TO INTELLECTUALPROPERTY RIGHTS',\n",
       "       'PROFESSIONAL COMPETANCY ENHANCEMENT-IV',\n",
       "       'HARDWARE VERIFICATION USING SYSTEM VERILOG',\n",
       "       'Network Security and Cryptography',\n",
       "       'VLSI Design Verification and Testing',\n",
       "       'Analog and Digital CMOS VLSI Design', 'Pedagogy Studies',\n",
       "       'Memory technologies', 'Legal Methods', 'Law of Contract - II',\n",
       "       'Political Science - II', 'Sociology - II', 'Economics - II',\n",
       "       'Legal English - II', 'Professional Communication Law -II',\n",
       "       'Constitutional Law-II', 'Family Law – II', 'Law of Crimes – II',\n",
       "       'Political Science-IV', 'Legal and Constitutional History',\n",
       "       'Environmental Science', 'Professional Competency Law -IV',\n",
       "       'Civil Procedure Code and Limitation Act', 'Labour Laws',\n",
       "       'Property Law', 'Alternate Dispute Resolution',\n",
       "       'Legal Philosophy ', 'Political Science VI',\n",
       "       'Professional Competency Law -VI', 'Principles of Taxation',\n",
       "       'Intellectual Property Rights Law- II',\n",
       "       'Interpretation of Statutes', 'Insolvency and Bankruptcy Law',\n",
       "       'Forensic Science and Criminal Law',\n",
       "       'Law on Infrastructure Development', 'Socio-economic Offenes',\n",
       "       'Foreign Language II I(Spanish-II)/ (German-II)/ (French-II)',\n",
       "       'Professional Competency Law -VIII',\n",
       "       'Professional Ethics and Professional Accounting System',\n",
       "       'Private International Law', 'Cyber Crimes and Law',\n",
       "       'International Investment Law',\n",
       "       'Securities Law and Market Regulations',\n",
       "       'International Criminal Law', 'Professional Competency Law -X',\n",
       "       'Law of Contract-II', 'Human Resource Management',\n",
       "       'Digital Marketing  ', 'Business and Growth Economics',\n",
       "       'Legal English-II', 'Professional Competency Law-II',\n",
       "       'Constitutional Law – II', 'Organisational Behaviour',\n",
       "       'MIS (Management Information System)', 'Audit Practices',\n",
       "       'Professional Communication Law -VI', 'Family Law-II',\n",
       "       'Jurisprudence', 'Law of Crimes-II',\n",
       "       'Information Technology and Telecommunication Laws',\n",
       "       'Law of Evidence',\n",
       "       'MATHEMATICS-II (ORDINARY & PARTIAL DIFFERENTIAL EQUATION, NUMERICAL METHODS)\\n',\n",
       "       'OPTICS & WAVE OSCILLATIONS',\n",
       "       'PROGRAMING FOR PROBLEM SOLVING USING C',\n",
       "       'PROFESSIONAL COMMUNICATIONS-II', 'PROFESSIONAL ENGLISH',\n",
       "       'STRENGTH OF MATERIALS-I', 'MATERIALS SCIENCE', 'MECHATRONICS',\n",
       "       'CYBER LAW/ LAW RELATING TO INTELLECTUAL PROPERTY RIGHTS',\n",
       "       '*FOREIGN LANGUAGE(SPANISH-II/GERMAN-II/FRENCH-II)',\n",
       "       'PROFESSIONAL COMPETENCY ENHANCEMENT-II',\n",
       "       'INTERNAL COMBUSTION ENGINE & GAS TURBINES', 'OPERATION RESEARCH',\n",
       "       'TOOL ENGINEERING DESIGN/PRODUCT DESIGN DEVELOPMENT//FUNDAMENTALS OF NANOSCIENCE & NANOTECHNOLOGY',\n",
       "       'MECHANICAL VIBRATIONS/AUTOMOBILE ENGINEERING/COMPOSITE MATERIALS',\n",
       "       'INTRODUCTION TO WIRELESS SENSOR NETWORK/INFORMATION RETREIVAL',\n",
       "       'PROFESSIONAL COMPETENCY ENHANCEMENT-IV',\n",
       "       'INDUSTRIAL ENGINEERING & OPERATIONS RESEARCH',\n",
       "       'CIM/INDUSTRIAL AUTOMATION',\n",
       "       'RAPID PROTOTYPING/ADVANCED FOUNDRY TECHNOLOGY ',\n",
       "       'HUMAN RESOURCE MANAGEMENT', 'FINANCIAL MANAGEMENT',\n",
       "       'ADVANCED EXCEL', 'MACRO ECONOMICS',\n",
       "       'INTRODUCTION TO  FAMILY BUSINESS MANAGEMENT (EFB)',\n",
       "       'CREATIVITY & INNOVATION IN ENTREPRENEURSHIP',\n",
       "       'BUSINESS COMMUNICATION SKILLS- II  ', 'COST  ACCOUNTING ',\n",
       "       'FINANCIAL SERVICES',\n",
       "       'FINANCING & BUSINESS DEVELOPMENT OF HOSPITALS ',\n",
       "       'HEALTHCARE COMMUNICATION ',\n",
       "       'Hospital Hazards and waste management ', 'HEALTHCARE ECONOMICS  ',\n",
       "       'FUNDAMENTALS OF LOGISTICS ', 'MANAGERIAL ECONOMICS ',\n",
       "       'Structured Query Language (SQL)', 'DATA CLEANING',\n",
       "       'SERVICES MARKETING', 'CSR And Sustainable Development',\n",
       "       'SUPPLY CHAIN MANAGEMENT ',\n",
       "       'MANAGING ENTREPRENEURIAL GROWTH AND STRATEGY ',\n",
       "       'MANAGEMENT OF BANKING AND FINANCIAL INSTITUTIONS ',\n",
       "       'CORPORATE ACCOUNTING ', 'DIGITAL FINANCE ',\n",
       "       'PERFORMANCE AND COMPENSATION MANAGEMENT SYSTEMS ',\n",
       "       'MATERIAL & INVENTORY MANAGEMENT ',\n",
       "       'HEALTHCARE INFORMATION SYSTEM ', 'MANAGEMENT OF MEDICATION ',\n",
       "       'HEALTHCARE & HRM ', 'PROJECT MANAGEMENT ',\n",
       "       'FREIGHT TRANSPORT MANAGEMENT ', 'Operation Research ',\n",
       "       'DIGITAL MARKETING', 'BUSINESS ANALYTICS', 'E-COMMERCE ',\n",
       "       'STRATEGIES AND PRACTICES OF FAMILY OWNED ENTERPRISES ',\n",
       "       'COPYRIGHT, PATENTS, LAWS OF IPR ', 'ENTREPRENEURIAL FINANCE ',\n",
       "       'BEHAVIOURAL FINANCE ', 'RISK MANAGEMENT IN BANKING SECTOR ',\n",
       "       'FINANCIAL MODELING ', 'PUBLIC HEALTH ',\n",
       "       'GLOBAL HEALTHCARE SCENARIO', 'INTRODUCTION TO SHIPPING ',\n",
       "       'MULTIMODAL TRANSPORTATION',\n",
       "       'TRANSPORTATION AND DISTRIBUTION MANAGEMENT ',\n",
       "       'Machine Learning & AI ', 'Marketing Analytics',\n",
       "       'Supply Chain Analytics ', 'Operations Research',\n",
       "       'Data Visualization Tableau', 'Data Cleaning using R',\n",
       "       'Multivariate Data Analysis',\n",
       "       'Creativity Innovation & Design Thinking', 'Skill Enhancement-II',\n",
       "       'Operations and Suppy Chain Management',\n",
       "       'Entrepreneurship Development', 'CRM', 'Project Management',\n",
       "       'Natural Language Processing',\n",
       "       'Warehousing & Inventory Opitimization', 'CHEMISTRY-1',\n",
       "       'PROBABILITY AND STATISTICS ',\n",
       "       'BASICS OF ELECTRONICS & ELECTRICAL ENGINEERING',\n",
       "       'DATA STRUCTURES & ALGORITHMS', 'PROBABILITY & STATISTICS ',\n",
       "       'ARTIFICIAL INTELLIGENCE', 'OPERATING SYSTEM', 'FOREIGN LANGUAGE',\n",
       "       'ESSENCE OF INDIAN TRADITIONAL KNOWLEDGE',\n",
       "       'COMPUTER GRAPHICS & MULTIMEDIA',\n",
       "       'THEORY OF AUTOMATA & COMPILER DESIGN',\n",
       "       'ADVANCED ANDROID DEVELOPMENT', 'DATA WAREHOUSE & DATA MINING',\n",
       "       'MACHINE LEARNING', 'N/W SECURITY & CRYPTOGRAPHY',\n",
       "       'OBJECT ORIENTED SOFTWARE ENGINEERING',\n",
       "       'PROGRESSIVE WEB APPLICATIONS', 'BIG DATA', 'IMAGE PROCESSING',\n",
       "       'CLOUD COMPUTING', 'SOFTWARE TESTING',\n",
       "       'INTRODUCTION TO BLOCKCHAIN TECHNOLOGY', 'BIOLOGY', 'CHEMISTRY',\n",
       "       'CALCULUS & LINEAR ALGEBRA', 'QUANTUM MECHANICS FOR ENGINEER',\n",
       "       'USER INTERFACE-II ', 'INDIAN CONSTITUTION', 'PYTHON PROGRAMMING',\n",
       "       'UX Expert-React Native + Angular',\n",
       "       'INTRODUCTION TO STANDARDS, FRAMEWORKS AND KEY TECHNOLOGY CONCEPTS',\n",
       "       'MATERIALS FOR ROBOTICS', 'DIGITAL LOGIC AND HARDWARE DESIGN',\n",
       "       'COMMUNICATION SYSTEMS', 'KINEMATICS & DYNAMICS OF ROBOTS',\n",
       "       'DIGITAL ELECTRONICS', 'UnSUPERVISED LEARNING & NEURAL NETWORK',\n",
       "       'SOFTWARE CRAFTMANSHIP', 'DIGITAL FORENSICS',\n",
       "       'SOFTWARE ENGINEERING', 'COMPUTER NETWORKS',\n",
       "       'NATURAL LANGUAGE PROCESSING', 'ADVANCED JAVA',\n",
       "       'MOBILE COMPUTING WITH ANDROID', 'SYSTEM NETWORK & ADMINISTRATION',\n",
       "       'CYBER LAW/\\nLAW RELATING TO INTELLECTUAL PROPERTY RIGHTS ',\n",
       "       'MODERN ARCHITECTURE PATTERNS',\n",
       "       'VULNERABILITY ASSESSMENT AND PENETRATION TESTING'], dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "course = df1[\"Course Name\"].unique()\n",
    "course"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "psc_data = \"PSC_List_10-3-2024 (1).xlsx\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "psc_df = pd.read_excel(psc_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Unnamed: 0</th>\n",
       "      <th>Student</th>\n",
       "      <th>Rollno</th>\n",
       "      <th>DOB</th>\n",
       "      <th>Type</th>\n",
       "      <th>Sub. Name</th>\n",
       "      <th>Sub. Code</th>\n",
       "      <th>Credit</th>\n",
       "      <th>Class</th>\n",
       "      <th>Semester</th>\n",
       "      <th>...</th>\n",
       "      <th>Exam Due In Head</th>\n",
       "      <th>Exam Due In Head.1</th>\n",
       "      <th>Exam Collection In Head</th>\n",
       "      <th>Exam Collection In Head.1</th>\n",
       "      <th>Outstanding Amount</th>\n",
       "      <th>Outstanding Amount.1</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>Unnamed: 18</th>\n",
       "      <th>Unnamed: 19</th>\n",
       "      <th>Unnamed: 20</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Lakshay Bhardwaj</td>\n",
       "      <td>2K22CSUN06017</td>\n",
       "      <td>21/07/2003</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>CSH103B-T</td>\n",
       "      <td>4.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>26000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>26000.0</td>\n",
       "      <td>NOT PAID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Lalit Sharma</td>\n",
       "      <td>2K22CSUN06018</td>\n",
       "      <td>2004-04-09 00:00:00</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>CSH103B-T</td>\n",
       "      <td>4.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>54000.0</td>\n",
       "      <td>77000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45800.0</td>\n",
       "      <td>68800.0</td>\n",
       "      <td>NOT PAID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Vulli Ajay Kumar</td>\n",
       "      <td>2K22CSUN06031</td>\n",
       "      <td>29/10/2004</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>CSH103B-T</td>\n",
       "      <td>4.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>14000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>14000.0</td>\n",
       "      <td>NOT PAID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Puthi Rishik Sai Kumar</td>\n",
       "      <td>2K22CSUN01115</td>\n",
       "      <td>17/09/2004</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>CSH103B-T</td>\n",
       "      <td>4.0</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13000.0</td>\n",
       "      <td>-2000.0</td>\n",
       "      <td>-2000.0</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Shivam Rajbhar</td>\n",
       "      <td>2K22CSUN06028</td>\n",
       "      <td>2004-09-09 00:00:00</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>CSH103B-T</td>\n",
       "      <td>4.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>NOT PAID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Aryan Goyal</td>\n",
       "      <td>2K22CSUN06007</td>\n",
       "      <td>23/12/2004</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>MATERIALS FOR ROBOTICS LAB (2023)</td>\n",
       "      <td>MEH109B-P</td>\n",
       "      <td>1.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>PAYMENT CLEARED</td>\n",
       "      <td>DONE</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Anish Kuntal</td>\n",
       "      <td>2K22CSUN06006</td>\n",
       "      <td>2004-04-06 00:00:00</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>MATERIALS FOR ROBOTICS LAB (2023)</td>\n",
       "      <td>MEH109B-P</td>\n",
       "      <td>1.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40000.0</td>\n",
       "      <td>NOT PAID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Lalit Sharma</td>\n",
       "      <td>2K22CSUN06018</td>\n",
       "      <td>2004-04-09 00:00:00</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>MATERIALS FOR ROBOTICS LAB (2023)</td>\n",
       "      <td>MEH109B-P</td>\n",
       "      <td>1.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>54000.0</td>\n",
       "      <td>77000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45800.0</td>\n",
       "      <td>68800.0</td>\n",
       "      <td>NOT PAID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Animesh Kumar Bhardwaj</td>\n",
       "      <td>2K22CSUN06005</td>\n",
       "      <td>16/05/2004</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>MATERIALS FOR ROBOTICS LAB (2023)</td>\n",
       "      <td>MEH109B-P</td>\n",
       "      <td>1.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>16000.0</td>\n",
       "      <td>16000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-3300.0</td>\n",
       "      <td>-3300.0</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>DUES CLEARED</td>\n",
       "      <td>DONE</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Vulli Ajay Kumar</td>\n",
       "      <td>2K22CSUN06031</td>\n",
       "      <td>29/10/2004</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>MATERIALS FOR ROBOTICS LAB (2023)</td>\n",
       "      <td>MEH109B-P</td>\n",
       "      <td>1.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>14000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>14000.0</td>\n",
       "      <td>NOT PAID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Saddanapu Sathwik</td>\n",
       "      <td>2K22CSUN06024</td>\n",
       "      <td>2005-11-05 00:00:00</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>MATERIALS FOR ROBOTICS LAB (2023)</td>\n",
       "      <td>MEH109B-P</td>\n",
       "      <td>1.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>NR CASE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>Aleshwaram Vamshi Teja</td>\n",
       "      <td>2K22CSUN06004</td>\n",
       "      <td>19/12/2004</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>MATERIALS FOR ROBOTICS LAB (2023)</td>\n",
       "      <td>MEH109B-P</td>\n",
       "      <td>1.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32000.0</td>\n",
       "      <td>NR CASE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Shivam Rajbhar</td>\n",
       "      <td>2K22CSUN06028</td>\n",
       "      <td>2004-09-09 00:00:00</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>MATERIALS FOR ROBOTICS LAB (2023)</td>\n",
       "      <td>MEH109B-P</td>\n",
       "      <td>1.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>NOT PAID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Lakshay Bhardwaj</td>\n",
       "      <td>2K22CSUN06017</td>\n",
       "      <td>21/07/2003</td>\n",
       "      <td>Regular</td>\n",
       "      <td>MATERIALS FOR ROBOTICS LAB (2023)</td>\n",
       "      <td>MEH109B-P</td>\n",
       "      <td>1.0</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>26000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>26000.0</td>\n",
       "      <td>NOT PAID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Deeksha Pandey</td>\n",
       "      <td>2K22CSUN01192</td>\n",
       "      <td>22/02/2004</td>\n",
       "      <td>Backlog</td>\n",
       "      <td>QUANTUM MECHANICS FOR ENGINEER LAB (2023)</td>\n",
       "      <td>PHH101B -P</td>\n",
       "      <td>1.0</td>\n",
       "      <td>B.Tech CSE CDFD (Xebia)</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>...</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>NOT PAID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0                 Student         Rollno                  DOB  \\\n",
       "0            1        Lakshay Bhardwaj  2K22CSUN06017           21/07/2003   \n",
       "1            2            Lalit Sharma  2K22CSUN06018  2004-04-09 00:00:00   \n",
       "2            3        Vulli Ajay Kumar  2K22CSUN06031           29/10/2004   \n",
       "3            4  Puthi Rishik Sai Kumar  2K22CSUN01115           17/09/2004   \n",
       "4            5          Shivam Rajbhar  2K22CSUN06028  2004-09-09 00:00:00   \n",
       "5            6             Aryan Goyal  2K22CSUN06007           23/12/2004   \n",
       "6            7            Anish Kuntal  2K22CSUN06006  2004-04-06 00:00:00   \n",
       "7            8            Lalit Sharma  2K22CSUN06018  2004-04-09 00:00:00   \n",
       "8            9  Animesh Kumar Bhardwaj  2K22CSUN06005           16/05/2004   \n",
       "9           10        Vulli Ajay Kumar  2K22CSUN06031           29/10/2004   \n",
       "10          11       Saddanapu Sathwik  2K22CSUN06024  2005-11-05 00:00:00   \n",
       "11          12  Aleshwaram Vamshi Teja  2K22CSUN06004           19/12/2004   \n",
       "12          13          Shivam Rajbhar  2K22CSUN06028  2004-09-09 00:00:00   \n",
       "13          14        Lakshay Bhardwaj  2K22CSUN06017           21/07/2003   \n",
       "14          15          Deeksha Pandey  2K22CSUN01192           22/02/2004   \n",
       "\n",
       "       Type                                  Sub. Name   Sub. Code  Credit  \\\n",
       "0   Backlog               DATA STRUCTURES & ALGORITHMS   CSH103B-T     4.0   \n",
       "1   Backlog               DATA STRUCTURES & ALGORITHMS   CSH103B-T     4.0   \n",
       "2   Backlog               DATA STRUCTURES & ALGORITHMS   CSH103B-T     4.0   \n",
       "3   Backlog               DATA STRUCTURES & ALGORITHMS   CSH103B-T     4.0   \n",
       "4   Backlog               DATA STRUCTURES & ALGORITHMS   CSH103B-T     4.0   \n",
       "5   Backlog          MATERIALS FOR ROBOTICS LAB (2023)   MEH109B-P     1.0   \n",
       "6   Backlog          MATERIALS FOR ROBOTICS LAB (2023)   MEH109B-P     1.0   \n",
       "7   Backlog          MATERIALS FOR ROBOTICS LAB (2023)   MEH109B-P     1.0   \n",
       "8   Backlog          MATERIALS FOR ROBOTICS LAB (2023)   MEH109B-P     1.0   \n",
       "9   Backlog          MATERIALS FOR ROBOTICS LAB (2023)   MEH109B-P     1.0   \n",
       "10  Backlog          MATERIALS FOR ROBOTICS LAB (2023)   MEH109B-P     1.0   \n",
       "11  Backlog          MATERIALS FOR ROBOTICS LAB (2023)   MEH109B-P     1.0   \n",
       "12  Backlog          MATERIALS FOR ROBOTICS LAB (2023)   MEH109B-P     1.0   \n",
       "13  Regular          MATERIALS FOR ROBOTICS LAB (2023)   MEH109B-P     1.0   \n",
       "14  Backlog  QUANTUM MECHANICS FOR ENGINEER LAB (2023)  PHH101B -P     1.0   \n",
       "\n",
       "                      Class Semester  ... Exam Due In Head  \\\n",
       "0               B.Tech R&AI    Sem 2  ...           8000.0   \n",
       "1               B.Tech R&AI    Sem 2  ...          54000.0   \n",
       "2               B.Tech R&AI    Sem 2  ...          10000.0   \n",
       "3                 BTech CSE    Sem 2  ...              NaN   \n",
       "4               B.Tech R&AI    Sem 2  ...              NaN   \n",
       "5               B.Tech R&AI    Sem 2  ...           2000.0   \n",
       "6               B.Tech R&AI    Sem 2  ...              NaN   \n",
       "7               B.Tech R&AI    Sem 2  ...          54000.0   \n",
       "8               B.Tech R&AI    Sem 2  ...          16000.0   \n",
       "9               B.Tech R&AI    Sem 2  ...          10000.0   \n",
       "10              B.Tech R&AI    Sem 2  ...              NaN   \n",
       "11              B.Tech R&AI    Sem 2  ...              NaN   \n",
       "12              B.Tech R&AI    Sem 2  ...              NaN   \n",
       "13              B.Tech R&AI    Sem 2  ...           8000.0   \n",
       "14  B.Tech CSE CDFD (Xebia)    Sem 2  ...           6000.0   \n",
       "\n",
       "    Exam Due In Head.1  Exam Collection In Head  Exam Collection In Head.1  \\\n",
       "0              26000.0                      NaN                        NaN   \n",
       "1              77000.0                      NaN                        NaN   \n",
       "2              14000.0                      NaN                        NaN   \n",
       "3              13000.0                      NaN                    13000.0   \n",
       "4              13000.0                      NaN                     9000.0   \n",
       "5               2000.0                      NaN                        NaN   \n",
       "6              40000.0                      NaN                        NaN   \n",
       "7              77000.0                      NaN                        NaN   \n",
       "8              16000.0                      NaN                        NaN   \n",
       "9              14000.0                      NaN                        NaN   \n",
       "10             36000.0                      NaN                        NaN   \n",
       "11             32000.0                      NaN                        NaN   \n",
       "12             13000.0                      NaN                     9000.0   \n",
       "13             26000.0                      NaN                        NaN   \n",
       "14             10000.0                   6000.0                     6000.0   \n",
       "\n",
       "    Outstanding Amount  Outstanding Amount.1      STATUS      Unnamed: 18  \\\n",
       "0               8000.0               26000.0    NOT PAID              NaN   \n",
       "1              45800.0               68800.0    NOT PAID              NaN   \n",
       "2              10000.0               14000.0    NOT PAID              NaN   \n",
       "3              -2000.0               -2000.0  REGISTERED              NaN   \n",
       "4                  0.0                4000.0    NOT PAID              NaN   \n",
       "5                  0.0                   0.0  REGISTERED  PAYMENT CLEARED   \n",
       "6                  0.0               40000.0    NOT PAID              NaN   \n",
       "7              45800.0               68800.0    NOT PAID              NaN   \n",
       "8              -3300.0               -3300.0  REGISTERED     DUES CLEARED   \n",
       "9              10000.0               14000.0    NOT PAID              NaN   \n",
       "10                 0.0               36000.0     NR CASE              NaN   \n",
       "11                 0.0               32000.0     NR CASE              NaN   \n",
       "12                 0.0                4000.0    NOT PAID              NaN   \n",
       "13              8000.0               26000.0    NOT PAID              NaN   \n",
       "14                 0.0                4000.0    NOT PAID              NaN   \n",
       "\n",
       "   Unnamed: 19 Unnamed: 20  \n",
       "0          NaN         NaN  \n",
       "1          NaN         NaN  \n",
       "2          NaN         NaN  \n",
       "3          NaN         NaN  \n",
       "4          NaN         NaN  \n",
       "5         DONE         NaN  \n",
       "6          NaN         NaN  \n",
       "7          NaN         NaN  \n",
       "8         DONE         NaN  \n",
       "9          NaN         NaN  \n",
       "10         NaN         NaN  \n",
       "11         NaN         NaN  \n",
       "12         NaN         NaN  \n",
       "13         NaN         NaN  \n",
       "14         NaN         NaN  \n",
       "\n",
       "[15 rows x 21 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "psc_df.head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "holiday_data = \"holiday.xlsx\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "holiday_df = pd.read_excel(holiday_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>Holiday</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Republic Day</td>\n",
       "      <td>2024-01-26</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Maha Shivratri</td>\n",
       "      <td>2024-03-08</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Holi</td>\n",
       "      <td>2024-03-25</td>\n",
       "      <td>Monday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Id-Ul Zuha*</td>\n",
       "      <td>2024-06-17</td>\n",
       "      <td>Monday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Holiday      Date      Day\n",
       "0    Republic Day 2024-01-26  Friday\n",
       "1  Maha Shivratri 2024-03-08  Friday\n",
       "2            Holi 2024-03-25  Monday\n",
       "3     Id-Ul Zuha* 2024-06-17  Monday"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "holiday_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "sheet_df = pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "sheet_df[\"S.No\"] = df1[\"S.No\"]\n",
    "sheet_df[\"Program\"] = df1[\"Program\"]\n",
    "sheet_df[\"Semester\"] = df1[\"Semester\"]\n",
    "sheet_df[\"Course Code\"] = df1[\"Course Code\"]\n",
    "sheet_df[\"Course Name\"] = df1[\"Course Name\"]\n",
    "sheet_df[\"No. of Students\"] = df1[\"No. of Students\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>Program</th>\n",
       "      <th>Semester</th>\n",
       "      <th>Course Code</th>\n",
       "      <th>Course Name</th>\n",
       "      <th>No. of Students</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>B.Sc Chemistry</td>\n",
       "      <td>IV</td>\n",
       "      <td>CHH205B-T</td>\n",
       "      <td>PHYSICAL CHEMISTRY III</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>B.Sc Chemistry</td>\n",
       "      <td>IV</td>\n",
       "      <td>CHH206B-T</td>\n",
       "      <td>INORGANIC CHEMISTRY III</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>B.Sc Chemistry</td>\n",
       "      <td>IV</td>\n",
       "      <td>CHH207B-T</td>\n",
       "      <td>ORGANIC CHEMISTRY III</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>B.Sc Chemistry</td>\n",
       "      <td>IV</td>\n",
       "      <td>CHH209B</td>\n",
       "      <td>INDUSTRIAL CHEMISTRY</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>B.Sc Chemistry</td>\n",
       "      <td>VI</td>\n",
       "      <td>CHH310B</td>\n",
       "      <td>Chemicals &amp; Environment</td>\n",
       "      <td>5.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>479</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH313B-T</td>\n",
       "      <td>DATA WAREHOUSE &amp; DATA MINING</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>480</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH314B</td>\n",
       "      <td>MACHINE LEARNING</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>481</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH306B-T</td>\n",
       "      <td>SYSTEM NETWORK &amp; ADMINISTRATION</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>482</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>LWS323/LWS325</td>\n",
       "      <td>CYBER LAW/\\nLAW RELATING TO INTELLECTUAL PROPE...</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>483</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CDO332</td>\n",
       "      <td>PROFESSIONAL COMPETANCY ENHANCEMENT-IV</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>483 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     S.No            Program Semester    Course Code  \\\n",
       "0       1     B.Sc Chemistry       IV      CHH205B-T   \n",
       "1       2     B.Sc Chemistry       IV      CHH206B-T   \n",
       "2       3     B.Sc Chemistry       IV      CHH207B-T   \n",
       "3       4     B.Sc Chemistry       IV        CHH209B   \n",
       "4       5     B.Sc Chemistry       VI        CHH310B   \n",
       "..    ...                ...      ...            ...   \n",
       "478   479  B.Tech CSE - CSTI       VI      CSH313B-T   \n",
       "479   480  B.Tech CSE - CSTI       VI        CSH314B   \n",
       "480   481  B.Tech CSE - CSTI       VI      CSH306B-T   \n",
       "481   482  B.Tech CSE - CSTI       VI  LWS323/LWS325   \n",
       "482   483  B.Tech CSE - CSTI       VI         CDO332   \n",
       "\n",
       "                                           Course Name  No. of Students  \n",
       "0                               PHYSICAL CHEMISTRY III              9.0  \n",
       "1                              INORGANIC CHEMISTRY III              9.0  \n",
       "2                                ORGANIC CHEMISTRY III              9.0  \n",
       "3                                 INDUSTRIAL CHEMISTRY              9.0  \n",
       "4                              Chemicals & Environment              5.0  \n",
       "..                                                 ...              ...  \n",
       "478                       DATA WAREHOUSE & DATA MINING             30.0  \n",
       "479                                   MACHINE LEARNING             30.0  \n",
       "480                    SYSTEM NETWORK & ADMINISTRATION             30.0  \n",
       "481  CYBER LAW/\\nLAW RELATING TO INTELLECTUAL PROPE...             30.0  \n",
       "482             PROFESSIONAL COMPETANCY ENHANCEMENT-IV             30.0  \n",
       "\n",
       "[483 rows x 6 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sheet_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Sneha\\AppData\\Local\\Temp\\ipykernel_18304\\2215737844.py:63: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  sheet_df.at[i, 'Date'] = current_date\n",
      "C:\\Users\\Sneha\\AppData\\Local\\Temp\\ipykernel_18304\\2215737844.py:66: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  sheet_df.at[i, 'Time Slot'] = time_slots[time_slot_index]\n"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "# Splitting 'L-T-P' column and converting to numeric\n",
    "sheet_df[['L', 'T', 'P']] = df1['L-T-P'].str.split('-', expand=True)\n",
    "sheet_df[['L', 'T', 'P']] = sheet_df[['L', 'T', 'P']].apply(pd.to_numeric)\n",
    "\n",
    "# Filtering non-zero lectures and tutorials\n",
    "sheet_df = sheet_df[(sheet_df['L'] != 0) | (sheet_df['T'] != 0)]\n",
    "\n",
    "# Define start and end dates\n",
    "start_date = '2024-03-11'\n",
    "end_date = '2024-04-28'\n",
    "\n",
    "# Create date range and select weekdays\n",
    "date_range = pd.date_range(start=start_date, end=end_date)\n",
    "weekdays_range = date_range[date_range.dayofweek < 5]\n",
    "\n",
    "# Define time slots based on term\n",
    "term = \"end-term\"  # or \"end-term\"\n",
    "if term == \"mid-term\":\n",
    "    time_slots = [\n",
    "        '9:00 - 10:30', \n",
    "        '11:30 - 13:00', \n",
    "        '14:00 - 15:30'\n",
    "    ]\n",
    "elif term == \"end-term\":\n",
    "    time_slots = [\n",
    "        '9:00 - 12:30', \n",
    "        '13:00 - 15:30'\n",
    "    ]\n",
    "\n",
    "date_index = 0\n",
    "time_slot_index = 0 \n",
    "last_date = {} \n",
    "prev_program_semester = None  \n",
    "\n",
    "for i, row in sheet_df.iterrows():\n",
    "    program_semester = (row[\"Program\"], row[\"Semester\"]) \n",
    "    \n",
    "    if pd.isna(row[\"Course Name\"]):  \n",
    "        sheet_df.at[i, 'Date'] = np.nan  \n",
    "        date_index = 0  \n",
    "    else:\n",
    "        if program_semester != prev_program_semester:\n",
    "            date_index = 0  \n",
    "            prev_program_semester = program_semester\n",
    "            time_slot_index = 0 \n",
    "        \n",
    "        if program_semester in last_date:\n",
    "            last_assigned_date = last_date[program_semester] + pd.Timedelta(days=2) \n",
    "        else:\n",
    "            last_assigned_date = pd.Timestamp(weekdays_range[0])  \n",
    "        \n",
    "        while True:\n",
    "            if date_index >= len(weekdays_range):\n",
    "                # Reset date index if all dates are used\n",
    "                date_index = 0\n",
    "                \n",
    "            if weekdays_range[date_index].dayofweek < 5:\n",
    "                current_date = pd.Timestamp(weekdays_range[date_index].date())  \n",
    "                if current_date >= last_assigned_date:\n",
    "                    sheet_df.at[i, 'Date'] = current_date  \n",
    "                    last_date[program_semester] = current_date \n",
    "                    \n",
    "                    sheet_df.at[i, 'Time Slot'] = time_slots[time_slot_index]\n",
    "                    \n",
    "                    time_slot_index = (time_slot_index + 1) % len(time_slots)\n",
    "                    \n",
    "                    date_index += 1  \n",
    "                    break\n",
    "                else:\n",
    "                    date_index += 1  \n",
    "            else:\n",
    "                date_index += 1  \n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Sneha\\AppData\\Local\\Temp\\ipykernel_18304\\1509579609.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  sheet_df['Year'] = ''\n"
     ]
    }
   ],
   "source": [
    "sheet_df['Year'] = ''\n",
    "\n",
    "# Define conditions and assign values to the \"Year\" column based on the \"Semester\" values\n",
    "sheet_df.loc[sheet_df['Semester'].isin(['I', 'II']), 'Year'] = 1\n",
    "sheet_df.loc[sheet_df['Semester'].isin(['III', 'IV']), 'Year'] = 2\n",
    "sheet_df.loc[sheet_df['Semester'].isin(['V', 'VI']), 'Year'] = 3\n",
    "sheet_df.loc[sheet_df['Semester'].isin(['VII', 'VIII']), 'Year'] = 4\n",
    "sheet_df.loc[sheet_df['Semester'].isin(['IX', 'X']), 'Year'] = 5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "scrolled": false
   },
   "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>Program</th>\n",
       "      <th>Semester</th>\n",
       "      <th>Course Code</th>\n",
       "      <th>Course Name</th>\n",
       "      <th>No. of Students</th>\n",
       "      <th>L</th>\n",
       "      <th>T</th>\n",
       "      <th>P</th>\n",
       "      <th>Date</th>\n",
       "      <th>Time Slot</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>464</td>\n",
       "      <td>B.Tech CSE - CDA</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH322B</td>\n",
       "      <td>MODERN ARCHITECTURE PATTERNS</td>\n",
       "      <td>13.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-11</td>\n",
       "      <td>9:00 - 12:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>465</td>\n",
       "      <td>B.Tech CSE - CDA</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH207B</td>\n",
       "      <td>SOFTWARE ENGINEERING</td>\n",
       "      <td>13.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-13</td>\n",
       "      <td>13:00 - 15:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>466</td>\n",
       "      <td>B.Tech CSE - CDA</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH421B</td>\n",
       "      <td>CLOUD COMPUTING</td>\n",
       "      <td>13.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-15</td>\n",
       "      <td>9:00 - 12:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>467</td>\n",
       "      <td>B.Tech CSE - CDA</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH308B-T</td>\n",
       "      <td>ADVANCED JAVA</td>\n",
       "      <td>13.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-18</td>\n",
       "      <td>13:00 - 15:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>468</td>\n",
       "      <td>B.Tech CSE - CDA</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH303B</td>\n",
       "      <td>MOBILE COMPUTING WITH ANDROID</td>\n",
       "      <td>13.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-20</td>\n",
       "      <td>9:00 - 12:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>469</td>\n",
       "      <td>B.Tech CSE - CDA</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH313B-T</td>\n",
       "      <td>DATA WAREHOUSE &amp; DATA MINING</td>\n",
       "      <td>13.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-22</td>\n",
       "      <td>13:00 - 15:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>470</td>\n",
       "      <td>B.Tech CSE - CDA</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH314B</td>\n",
       "      <td>MACHINE LEARNING</td>\n",
       "      <td>13.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-25</td>\n",
       "      <td>9:00 - 12:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>471</td>\n",
       "      <td>B.Tech CSE - CDA</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH306B-T</td>\n",
       "      <td>SYSTEM NETWORK &amp; ADMINISTRATION</td>\n",
       "      <td>13.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-27</td>\n",
       "      <td>13:00 - 15:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>472</td>\n",
       "      <td>B.Tech CSE - CDA</td>\n",
       "      <td>VI</td>\n",
       "      <td>LWS323/LWS325</td>\n",
       "      <td>CYBER LAW/\\nLAW RELATING TO INTELLECTUAL PROPE...</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2024-03-29</td>\n",
       "      <td>9:00 - 12:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>473</td>\n",
       "      <td>B.Tech CSE - CDA</td>\n",
       "      <td>VI</td>\n",
       "      <td>CDO332</td>\n",
       "      <td>PROFESSIONAL COMPETANCY ENHANCEMENT-IV</td>\n",
       "      <td>13.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2024-04-01</td>\n",
       "      <td>13:00 - 15:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>474</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH330B-T</td>\n",
       "      <td>VULNERABILITY ASSESSMENT AND PENETRATION TESTING</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2024-03-11</td>\n",
       "      <td>9:00 - 12:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>475</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH207B</td>\n",
       "      <td>SOFTWARE ENGINEERING</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-13</td>\n",
       "      <td>13:00 - 15:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>476</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH421B</td>\n",
       "      <td>CLOUD COMPUTING</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-15</td>\n",
       "      <td>9:00 - 12:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>477</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH308B-T</td>\n",
       "      <td>ADVANCED JAVA</td>\n",
       "      <td>30.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2024-03-18</td>\n",
       "      <td>13:00 - 15:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>478</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH303B</td>\n",
       "      <td>MOBILE COMPUTING WITH ANDROID</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-20</td>\n",
       "      <td>9:00 - 12:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>479</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH313B-T</td>\n",
       "      <td>DATA WAREHOUSE &amp; DATA MINING</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-22</td>\n",
       "      <td>13:00 - 15:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>480</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH314B</td>\n",
       "      <td>MACHINE LEARNING</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-25</td>\n",
       "      <td>9:00 - 12:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>481</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CSH306B-T</td>\n",
       "      <td>SYSTEM NETWORK &amp; ADMINISTRATION</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2024-03-27</td>\n",
       "      <td>13:00 - 15:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>482</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>LWS323/LWS325</td>\n",
       "      <td>CYBER LAW/\\nLAW RELATING TO INTELLECTUAL PROPE...</td>\n",
       "      <td>30.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2024-03-29</td>\n",
       "      <td>9:00 - 12:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>483</td>\n",
       "      <td>B.Tech CSE - CSTI</td>\n",
       "      <td>VI</td>\n",
       "      <td>CDO332</td>\n",
       "      <td>PROFESSIONAL COMPETANCY ENHANCEMENT-IV</td>\n",
       "      <td>30.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2024-04-01</td>\n",
       "      <td>13:00 - 15:30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     S.No            Program Semester    Course Code  \\\n",
       "463   464   B.Tech CSE - CDA       VI        CSH322B   \n",
       "464   465   B.Tech CSE - CDA       VI        CSH207B   \n",
       "465   466   B.Tech CSE - CDA       VI        CSH421B   \n",
       "466   467   B.Tech CSE - CDA       VI      CSH308B-T   \n",
       "467   468   B.Tech CSE - CDA       VI        CSH303B   \n",
       "468   469   B.Tech CSE - CDA       VI      CSH313B-T   \n",
       "469   470   B.Tech CSE - CDA       VI        CSH314B   \n",
       "470   471   B.Tech CSE - CDA       VI      CSH306B-T   \n",
       "471   472   B.Tech CSE - CDA       VI  LWS323/LWS325   \n",
       "472   473   B.Tech CSE - CDA       VI         CDO332   \n",
       "473   474  B.Tech CSE - CSTI       VI      CSH330B-T   \n",
       "474   475  B.Tech CSE - CSTI       VI        CSH207B   \n",
       "475   476  B.Tech CSE - CSTI       VI        CSH421B   \n",
       "476   477  B.Tech CSE - CSTI       VI      CSH308B-T   \n",
       "477   478  B.Tech CSE - CSTI       VI        CSH303B   \n",
       "478   479  B.Tech CSE - CSTI       VI      CSH313B-T   \n",
       "479   480  B.Tech CSE - CSTI       VI        CSH314B   \n",
       "480   481  B.Tech CSE - CSTI       VI      CSH306B-T   \n",
       "481   482  B.Tech CSE - CSTI       VI  LWS323/LWS325   \n",
       "482   483  B.Tech CSE - CSTI       VI         CDO332   \n",
       "\n",
       "                                           Course Name  No. of Students    L  \\\n",
       "463                       MODERN ARCHITECTURE PATTERNS             13.0  3.0   \n",
       "464                               SOFTWARE ENGINEERING             13.0  3.0   \n",
       "465                                    CLOUD COMPUTING             13.0  3.0   \n",
       "466                                      ADVANCED JAVA             13.0  3.0   \n",
       "467                      MOBILE COMPUTING WITH ANDROID             13.0  3.0   \n",
       "468                       DATA WAREHOUSE & DATA MINING             13.0  3.0   \n",
       "469                                   MACHINE LEARNING             13.0  3.0   \n",
       "470                    SYSTEM NETWORK & ADMINISTRATION             13.0  3.0   \n",
       "471  CYBER LAW/\\nLAW RELATING TO INTELLECTUAL PROPE...             13.0  2.0   \n",
       "472             PROFESSIONAL COMPETANCY ENHANCEMENT-IV             13.0  6.0   \n",
       "473   VULNERABILITY ASSESSMENT AND PENETRATION TESTING             30.0  1.0   \n",
       "474                               SOFTWARE ENGINEERING             30.0  3.0   \n",
       "475                                    CLOUD COMPUTING             30.0  3.0   \n",
       "476                                      ADVANCED JAVA             30.0  2.0   \n",
       "477                      MOBILE COMPUTING WITH ANDROID             30.0  3.0   \n",
       "478                       DATA WAREHOUSE & DATA MINING             30.0  3.0   \n",
       "479                                   MACHINE LEARNING             30.0  3.0   \n",
       "480                    SYSTEM NETWORK & ADMINISTRATION             30.0  3.0   \n",
       "481  CYBER LAW/\\nLAW RELATING TO INTELLECTUAL PROPE...             30.0  2.0   \n",
       "482             PROFESSIONAL COMPETANCY ENHANCEMENT-IV             30.0  6.0   \n",
       "\n",
       "       T    P       Date      Time Slot Year  \n",
       "463  1.0  2.0 2024-03-11   9:00 - 12:30    3  \n",
       "464  1.0  2.0 2024-03-13  13:00 - 15:30    3  \n",
       "465  1.0  2.0 2024-03-15   9:00 - 12:30    3  \n",
       "466  1.0  2.0 2024-03-18  13:00 - 15:30    3  \n",
       "467  0.0  2.0 2024-03-20   9:00 - 12:30    3  \n",
       "468  0.0  2.0 2024-03-22  13:00 - 15:30    3  \n",
       "469  0.0  2.0 2024-03-25   9:00 - 12:30    3  \n",
       "470  0.0  2.0 2024-03-27  13:00 - 15:30    3  \n",
       "471  0.0  0.0 2024-03-29   9:00 - 12:30    3  \n",
       "472  0.0  0.0 2024-04-01  13:00 - 15:30    3  \n",
       "473  0.0  0.0 2024-03-11   9:00 - 12:30    3  \n",
       "474  1.0  2.0 2024-03-13  13:00 - 15:30    3  \n",
       "475  1.0  2.0 2024-03-15   9:00 - 12:30    3  \n",
       "476  0.0  0.0 2024-03-18  13:00 - 15:30    3  \n",
       "477  0.0  2.0 2024-03-20   9:00 - 12:30    3  \n",
       "478  0.0  2.0 2024-03-22  13:00 - 15:30    3  \n",
       "479  0.0  2.0 2024-03-25   9:00 - 12:30    3  \n",
       "480  0.0  2.0 2024-03-27  13:00 - 15:30    3  \n",
       "481  0.0  0.0 2024-03-29   9:00 - 12:30    3  \n",
       "482  0.0  0.0 2024-04-01  13:00 - 15:30    3  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sheet_df.tail(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "psc_stu = pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "filtered_psc_df = psc_df[psc_df['Sub. Name'].isin(course)].copy()\n",
    "\n",
    "psc_stu = pd.DataFrame()\n",
    "psc_stu[\"Student\"] = filtered_psc_df[\"Student\"]\n",
    "psc_stu[\"Rollno\"] = filtered_psc_df[\"Rollno\"]\n",
    "psc_stu[\"Sub. Name\"] = filtered_psc_df[\"Sub. Name\"]\n",
    "psc_stu[\"Semester\"] = filtered_psc_df[\"Semester\"]\n",
    "psc_stu[\"Class\"] = filtered_psc_df[\"Class\"]\n",
    "psc_stu[\"STATUS\"] = filtered_psc_df[\"STATUS\"]\n",
    "\n",
    "psc_stu = psc_stu[psc_stu['STATUS'] == 'REGISTERED']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "scrolled": true
   },
   "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>Student</th>\n",
       "      <th>Rollno</th>\n",
       "      <th>Sub. Name</th>\n",
       "      <th>Semester</th>\n",
       "      <th>Class</th>\n",
       "      <th>STATUS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Puthi Rishik Sai Kumar</td>\n",
       "      <td>2K22CSUN01115</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Mahesh Tanwar</td>\n",
       "      <td>2K20CSUN01065</td>\n",
       "      <td>APPLIED PSYCHOLOGY</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Lakshay Bajaj</td>\n",
       "      <td>2K20CSUN01061</td>\n",
       "      <td>APPLIED PSYCHOLOGY</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Nishchay Raj</td>\n",
       "      <td>2K22ECUN03008</td>\n",
       "      <td>APPLIED PSYCHOLOGY</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech ECE VLSI D&amp;V</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Sagar</td>\n",
       "      <td>2K20CSUN01091</td>\n",
       "      <td>APPLIED PSYCHOLOGY</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Gandi Sai Swaroop</td>\n",
       "      <td>2K20CSUN01128</td>\n",
       "      <td>CLOUD COMPUTING</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Lotti Uday Kiran Sai</td>\n",
       "      <td>2K20CSUN01063</td>\n",
       "      <td>CLOUD COMPUTING</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Harsh Choudhary</td>\n",
       "      <td>2K20CSUN01042</td>\n",
       "      <td>CLOUD COMPUTING</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Vibhor Sharma</td>\n",
       "      <td>2K22CSUN01126</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Krishna Yadav</td>\n",
       "      <td>2K22CSUN06024</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>Puthi Rishik Sai Kumar</td>\n",
       "      <td>2K22CSUN01115</td>\n",
       "      <td>CHEMISTRY</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>Anshul Semwal</td>\n",
       "      <td>2K22CSUN01005</td>\n",
       "      <td>CHEMISTRY</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>Lakshay Bajaj</td>\n",
       "      <td>2K20CSUN01061</td>\n",
       "      <td>COMPUTER GRAPHICS &amp; MULTIMEDIA</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Sagar</td>\n",
       "      <td>2K20CSUN01091</td>\n",
       "      <td>COMPUTER GRAPHICS &amp; MULTIMEDIA</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>Kotakommula Sai Pavan Kalyan</td>\n",
       "      <td>2K20CSUN04031</td>\n",
       "      <td>OPERATING SYSTEM</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>Aseem</td>\n",
       "      <td>2K21CSUN04007</td>\n",
       "      <td>OPERATING SYSTEM</td>\n",
       "      <td>Sem 3</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>Maddimsetti Navadeep</td>\n",
       "      <td>2K20CSUN04035</td>\n",
       "      <td>OPERATING SYSTEM</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>Anuj Chaher</td>\n",
       "      <td>2K22MEUN03002</td>\n",
       "      <td>PROFESSIONAL ENGLISH</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>SMA</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>Ayush Sharma</td>\n",
       "      <td>2K22CSUN01164</td>\n",
       "      <td>PROFESSIONAL ENGLISH</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Enumula Saketh Kumar</td>\n",
       "      <td>2K21CSUN04047</td>\n",
       "      <td>PYTHON PROGRAMMING</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>Kotakommula Sai Pavan Kalyan</td>\n",
       "      <td>2K20CSUN04031</td>\n",
       "      <td>BIOLOGY</td>\n",
       "      <td>Sem 7</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>Potlapally Sai Teja</td>\n",
       "      <td>2K20CSUN04040</td>\n",
       "      <td>DIGITAL MARKETING</td>\n",
       "      <td>Sem 5</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>Arjun Vats</td>\n",
       "      <td>2K21CSUN04006</td>\n",
       "      <td>FRENCH-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>Gadi Teja Siva Sankar Guru Sai</td>\n",
       "      <td>2K20CSUN04020</td>\n",
       "      <td>THEORY OF AUTOMATA &amp; COMPILER DESIGN</td>\n",
       "      <td>Sem 7</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>Vudari Dhamaruka Sivasai</td>\n",
       "      <td>2K20CSUN04055</td>\n",
       "      <td>THEORY OF AUTOMATA &amp; COMPILER DESIGN</td>\n",
       "      <td>Sem 7</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>Ireddi Sai Krishna</td>\n",
       "      <td>2K20CSUN04025</td>\n",
       "      <td>THEORY OF AUTOMATA &amp; COMPILER DESIGN</td>\n",
       "      <td>Sem 7</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>Aditya Sharma</td>\n",
       "      <td>2K21CSUN01005</td>\n",
       "      <td>PROFESSIONAL COMPETANCY ENHANCEMENT-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>Tushar Joshi</td>\n",
       "      <td>2K22CSUN01155</td>\n",
       "      <td>CHEMISTRY-1</td>\n",
       "      <td>Sem 1</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>Mareti Ganesh Ram</td>\n",
       "      <td>2K22CSUN01239</td>\n",
       "      <td>CHEMISTRY-1</td>\n",
       "      <td>Sem 1</td>\n",
       "      <td>B.Tech CSE CSTI</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>Ashna Jain</td>\n",
       "      <td>2K22CSUN01131</td>\n",
       "      <td>QUANTUM MECHANICS FOR ENGINEER</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>Ashish Chauhan</td>\n",
       "      <td>2K20CSUN04006</td>\n",
       "      <td>RESEARCH &amp; INNOVATION-I</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>Enumula Saketh Kumar</td>\n",
       "      <td>2K21CSUN04047</td>\n",
       "      <td>PROFESSIONAL COMMUNICATION-II</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>Rahil Singh Dalal</td>\n",
       "      <td>2K21CSUN01138</td>\n",
       "      <td>PROFESSIONAL COMPETENCY ENHANCEMENT-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>Gopal Sharma</td>\n",
       "      <td>2K21CSUN01115</td>\n",
       "      <td>PROFESSIONAL COMPETENCY ENHANCEMENT-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>Karan Khanduja</td>\n",
       "      <td>2K20MEUN03004</td>\n",
       "      <td>PROFESSIONAL COMPETANCY ENHANCEMENT-IV</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>SMA</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>Karan Khanduja</td>\n",
       "      <td>2K20MEUN03004</td>\n",
       "      <td>GERMAN-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>SMA</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>Anuj</td>\n",
       "      <td>2K22CSUN01088</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>Prateek Tyagi</td>\n",
       "      <td>2K21CSUN04057</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 3</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>Krishna Yadav</td>\n",
       "      <td>2K22CSUN06013</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>Anup Attri</td>\n",
       "      <td>2K22CSUN01054</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Student         Rollno  \\\n",
       "3            Puthi Rishik Sai Kumar  2K22CSUN01115   \n",
       "48                    Mahesh Tanwar  2K20CSUN01065   \n",
       "49                    Lakshay Bajaj  2K20CSUN01061   \n",
       "50                     Nishchay Raj  2K22ECUN03008   \n",
       "51                            Sagar  2K20CSUN01091   \n",
       "52                Gandi Sai Swaroop  2K20CSUN01128   \n",
       "53             Lotti Uday Kiran Sai  2K20CSUN01063   \n",
       "55                  Harsh Choudhary  2K20CSUN01042   \n",
       "89                    Vibhor Sharma  2K22CSUN01126   \n",
       "92                    Krishna Yadav  2K22CSUN06024   \n",
       "118          Puthi Rishik Sai Kumar  2K22CSUN01115   \n",
       "119                   Anshul Semwal  2K22CSUN01005   \n",
       "136                   Lakshay Bajaj  2K20CSUN01061   \n",
       "137                           Sagar  2K20CSUN01091   \n",
       "149    Kotakommula Sai Pavan Kalyan  2K20CSUN04031   \n",
       "150                           Aseem  2K21CSUN04007   \n",
       "153            Maddimsetti Navadeep  2K20CSUN04035   \n",
       "163                     Anuj Chaher  2K22MEUN03002   \n",
       "164                    Ayush Sharma  2K22CSUN01164   \n",
       "179            Enumula Saketh Kumar  2K21CSUN04047   \n",
       "202    Kotakommula Sai Pavan Kalyan  2K20CSUN04031   \n",
       "208             Potlapally Sai Teja  2K20CSUN04040   \n",
       "209                      Arjun Vats  2K21CSUN04006   \n",
       "214  Gadi Teja Siva Sankar Guru Sai  2K20CSUN04020   \n",
       "215        Vudari Dhamaruka Sivasai  2K20CSUN04055   \n",
       "216              Ireddi Sai Krishna  2K20CSUN04025   \n",
       "225                   Aditya Sharma  2K21CSUN01005   \n",
       "254                    Tushar Joshi  2K22CSUN01155   \n",
       "255               Mareti Ganesh Ram  2K22CSUN01239   \n",
       "257                      Ashna Jain  2K22CSUN01131   \n",
       "272                  Ashish Chauhan  2K20CSUN04006   \n",
       "273            Enumula Saketh Kumar  2K21CSUN04047   \n",
       "278               Rahil Singh Dalal  2K21CSUN01138   \n",
       "280                    Gopal Sharma  2K21CSUN01115   \n",
       "298                  Karan Khanduja  2K20MEUN03004   \n",
       "301                  Karan Khanduja  2K20MEUN03004   \n",
       "309                            Anuj  2K22CSUN01088   \n",
       "310                   Prateek Tyagi  2K21CSUN04057   \n",
       "311                   Krishna Yadav  2K22CSUN06013   \n",
       "314                      Anup Attri  2K22CSUN01054   \n",
       "\n",
       "                                  Sub. Name Semester                Class  \\\n",
       "3              DATA STRUCTURES & ALGORITHMS    Sem 2            BTech CSE   \n",
       "48                       APPLIED PSYCHOLOGY    Sem 6            BTech CSE   \n",
       "49                       APPLIED PSYCHOLOGY    Sem 6            BTech CSE   \n",
       "50                       APPLIED PSYCHOLOGY    Sem 2  B.Tech ECE VLSI D&V   \n",
       "51                       APPLIED PSYCHOLOGY    Sem 6            BTech CSE   \n",
       "52                          CLOUD COMPUTING    Sem 6            BTech CSE   \n",
       "53                          CLOUD COMPUTING    Sem 6            BTech CSE   \n",
       "55                          CLOUD COMPUTING    Sem 6            BTech CSE   \n",
       "89             DATA STRUCTURES & ALGORITHMS    Sem 2            BTech CSE   \n",
       "92             DATA STRUCTURES & ALGORITHMS    Sem 2          B.Tech R&AI   \n",
       "118                               CHEMISTRY    Sem 2            BTech CSE   \n",
       "119                               CHEMISTRY    Sem 2            BTech CSE   \n",
       "136          COMPUTER GRAPHICS & MULTIMEDIA    Sem 6            BTech CSE   \n",
       "137          COMPUTER GRAPHICS & MULTIMEDIA    Sem 6            BTech CSE   \n",
       "149                        OPERATING SYSTEM    Sem 4      B.Tech CSE AIML   \n",
       "150                        OPERATING SYSTEM    Sem 3      B.Tech CSE AIML   \n",
       "153                        OPERATING SYSTEM    Sem 4      B.Tech CSE AIML   \n",
       "163                    PROFESSIONAL ENGLISH    Sem 2                  SMA   \n",
       "164                    PROFESSIONAL ENGLISH    Sem 2      B.Tech CSE AIML   \n",
       "179                      PYTHON PROGRAMMING    Sem 2      B.Tech CSE AIML   \n",
       "202                                 BIOLOGY    Sem 7      B.Tech CSE AIML   \n",
       "208                       DIGITAL MARKETING    Sem 5      B.Tech CSE AIML   \n",
       "209                               FRENCH-II    Sem 4      B.Tech CSE AIML   \n",
       "214    THEORY OF AUTOMATA & COMPILER DESIGN    Sem 7      B.Tech CSE AIML   \n",
       "215    THEORY OF AUTOMATA & COMPILER DESIGN    Sem 7      B.Tech CSE AIML   \n",
       "216    THEORY OF AUTOMATA & COMPILER DESIGN    Sem 7      B.Tech CSE AIML   \n",
       "225  PROFESSIONAL COMPETANCY ENHANCEMENT-II    Sem 4            BTech CSE   \n",
       "254                             CHEMISTRY-1    Sem 1      B.Tech CSE AIML   \n",
       "255                             CHEMISTRY-1    Sem 1      B.Tech CSE CSTI   \n",
       "257          QUANTUM MECHANICS FOR ENGINEER    Sem 2      B.Tech CSE AIML   \n",
       "272                 RESEARCH & INNOVATION-I    Sem 4      B.Tech CSE AIML   \n",
       "273           PROFESSIONAL COMMUNICATION-II    Sem 2      B.Tech CSE AIML   \n",
       "278  PROFESSIONAL COMPETENCY ENHANCEMENT-II    Sem 4            BTech CSE   \n",
       "280  PROFESSIONAL COMPETENCY ENHANCEMENT-II    Sem 4            BTech CSE   \n",
       "298  PROFESSIONAL COMPETANCY ENHANCEMENT-IV    Sem 6                  SMA   \n",
       "301                               GERMAN-II    Sem 4                  SMA   \n",
       "309            DATA STRUCTURES & ALGORITHMS    Sem 2            BTech CSE   \n",
       "310            DATA STRUCTURES & ALGORITHMS    Sem 3      B.Tech CSE AIML   \n",
       "311            DATA STRUCTURES & ALGORITHMS    Sem 2          B.Tech R&AI   \n",
       "314            DATA STRUCTURES & ALGORITHMS    Sem 2            BTech CSE   \n",
       "\n",
       "         STATUS  \n",
       "3    REGISTERED  \n",
       "48   REGISTERED  \n",
       "49   REGISTERED  \n",
       "50   REGISTERED  \n",
       "51   REGISTERED  \n",
       "52   REGISTERED  \n",
       "53   REGISTERED  \n",
       "55   REGISTERED  \n",
       "89   REGISTERED  \n",
       "92   REGISTERED  \n",
       "118  REGISTERED  \n",
       "119  REGISTERED  \n",
       "136  REGISTERED  \n",
       "137  REGISTERED  \n",
       "149  REGISTERED  \n",
       "150  REGISTERED  \n",
       "153  REGISTERED  \n",
       "163  REGISTERED  \n",
       "164  REGISTERED  \n",
       "179  REGISTERED  \n",
       "202  REGISTERED  \n",
       "208  REGISTERED  \n",
       "209  REGISTERED  \n",
       "214  REGISTERED  \n",
       "215  REGISTERED  \n",
       "216  REGISTERED  \n",
       "225  REGISTERED  \n",
       "254  REGISTERED  \n",
       "255  REGISTERED  \n",
       "257  REGISTERED  \n",
       "272  REGISTERED  \n",
       "273  REGISTERED  \n",
       "278  REGISTERED  \n",
       "280  REGISTERED  \n",
       "298  REGISTERED  \n",
       "301  REGISTERED  \n",
       "309  REGISTERED  \n",
       "310  REGISTERED  \n",
       "311  REGISTERED  \n",
       "314  REGISTERED  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "psc_stu.head(40)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime\n",
    "c_year = int(str(datetime.datetime.now().year)[2:])\n",
    "psc_stu['Current_year'] = c_year - psc_stu['Rollno'].str[2:4].fillna(0).astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>Student</th>\n",
       "      <th>Rollno</th>\n",
       "      <th>Sub. Name</th>\n",
       "      <th>Semester</th>\n",
       "      <th>Class</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>Current_year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Puthi Rishik Sai Kumar</td>\n",
       "      <td>2K22CSUN01115</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Mahesh Tanwar</td>\n",
       "      <td>2K20CSUN01065</td>\n",
       "      <td>APPLIED PSYCHOLOGY</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Lakshay Bajaj</td>\n",
       "      <td>2K20CSUN01061</td>\n",
       "      <td>APPLIED PSYCHOLOGY</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Nishchay Raj</td>\n",
       "      <td>2K22ECUN03008</td>\n",
       "      <td>APPLIED PSYCHOLOGY</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech ECE VLSI D&amp;V</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Sagar</td>\n",
       "      <td>2K20CSUN01091</td>\n",
       "      <td>APPLIED PSYCHOLOGY</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Gandi Sai Swaroop</td>\n",
       "      <td>2K20CSUN01128</td>\n",
       "      <td>CLOUD COMPUTING</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Lotti Uday Kiran Sai</td>\n",
       "      <td>2K20CSUN01063</td>\n",
       "      <td>CLOUD COMPUTING</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Harsh Choudhary</td>\n",
       "      <td>2K20CSUN01042</td>\n",
       "      <td>CLOUD COMPUTING</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Vibhor Sharma</td>\n",
       "      <td>2K22CSUN01126</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Krishna Yadav</td>\n",
       "      <td>2K22CSUN06024</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>Puthi Rishik Sai Kumar</td>\n",
       "      <td>2K22CSUN01115</td>\n",
       "      <td>CHEMISTRY</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>Anshul Semwal</td>\n",
       "      <td>2K22CSUN01005</td>\n",
       "      <td>CHEMISTRY</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>Lakshay Bajaj</td>\n",
       "      <td>2K20CSUN01061</td>\n",
       "      <td>COMPUTER GRAPHICS &amp; MULTIMEDIA</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Sagar</td>\n",
       "      <td>2K20CSUN01091</td>\n",
       "      <td>COMPUTER GRAPHICS &amp; MULTIMEDIA</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>Kotakommula Sai Pavan Kalyan</td>\n",
       "      <td>2K20CSUN04031</td>\n",
       "      <td>OPERATING SYSTEM</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>Aseem</td>\n",
       "      <td>2K21CSUN04007</td>\n",
       "      <td>OPERATING SYSTEM</td>\n",
       "      <td>Sem 3</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>Maddimsetti Navadeep</td>\n",
       "      <td>2K20CSUN04035</td>\n",
       "      <td>OPERATING SYSTEM</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>Anuj Chaher</td>\n",
       "      <td>2K22MEUN03002</td>\n",
       "      <td>PROFESSIONAL ENGLISH</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>SMA</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>Ayush Sharma</td>\n",
       "      <td>2K22CSUN01164</td>\n",
       "      <td>PROFESSIONAL ENGLISH</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Enumula Saketh Kumar</td>\n",
       "      <td>2K21CSUN04047</td>\n",
       "      <td>PYTHON PROGRAMMING</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>Kotakommula Sai Pavan Kalyan</td>\n",
       "      <td>2K20CSUN04031</td>\n",
       "      <td>BIOLOGY</td>\n",
       "      <td>Sem 7</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>Potlapally Sai Teja</td>\n",
       "      <td>2K20CSUN04040</td>\n",
       "      <td>DIGITAL MARKETING</td>\n",
       "      <td>Sem 5</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>Arjun Vats</td>\n",
       "      <td>2K21CSUN04006</td>\n",
       "      <td>FRENCH-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>Gadi Teja Siva Sankar Guru Sai</td>\n",
       "      <td>2K20CSUN04020</td>\n",
       "      <td>THEORY OF AUTOMATA &amp; COMPILER DESIGN</td>\n",
       "      <td>Sem 7</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>Vudari Dhamaruka Sivasai</td>\n",
       "      <td>2K20CSUN04055</td>\n",
       "      <td>THEORY OF AUTOMATA &amp; COMPILER DESIGN</td>\n",
       "      <td>Sem 7</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>Ireddi Sai Krishna</td>\n",
       "      <td>2K20CSUN04025</td>\n",
       "      <td>THEORY OF AUTOMATA &amp; COMPILER DESIGN</td>\n",
       "      <td>Sem 7</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>Aditya Sharma</td>\n",
       "      <td>2K21CSUN01005</td>\n",
       "      <td>PROFESSIONAL COMPETANCY ENHANCEMENT-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>Tushar Joshi</td>\n",
       "      <td>2K22CSUN01155</td>\n",
       "      <td>CHEMISTRY-1</td>\n",
       "      <td>Sem 1</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>Mareti Ganesh Ram</td>\n",
       "      <td>2K22CSUN01239</td>\n",
       "      <td>CHEMISTRY-1</td>\n",
       "      <td>Sem 1</td>\n",
       "      <td>B.Tech CSE CSTI</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>Ashna Jain</td>\n",
       "      <td>2K22CSUN01131</td>\n",
       "      <td>QUANTUM MECHANICS FOR ENGINEER</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>Ashish Chauhan</td>\n",
       "      <td>2K20CSUN04006</td>\n",
       "      <td>RESEARCH &amp; INNOVATION-I</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>Enumula Saketh Kumar</td>\n",
       "      <td>2K21CSUN04047</td>\n",
       "      <td>PROFESSIONAL COMMUNICATION-II</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>Rahil Singh Dalal</td>\n",
       "      <td>2K21CSUN01138</td>\n",
       "      <td>PROFESSIONAL COMPETENCY ENHANCEMENT-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>Gopal Sharma</td>\n",
       "      <td>2K21CSUN01115</td>\n",
       "      <td>PROFESSIONAL COMPETENCY ENHANCEMENT-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>Karan Khanduja</td>\n",
       "      <td>2K20MEUN03004</td>\n",
       "      <td>PROFESSIONAL COMPETANCY ENHANCEMENT-IV</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>SMA</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>Karan Khanduja</td>\n",
       "      <td>2K20MEUN03004</td>\n",
       "      <td>GERMAN-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>SMA</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>Anuj</td>\n",
       "      <td>2K22CSUN01088</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>Prateek Tyagi</td>\n",
       "      <td>2K21CSUN04057</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 3</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>Krishna Yadav</td>\n",
       "      <td>2K22CSUN06013</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech R&amp;AI</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>Anup Attri</td>\n",
       "      <td>2K22CSUN01054</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>Nakul</td>\n",
       "      <td>2K22CSUN01073</td>\n",
       "      <td>DATA STRUCTURES &amp; ALGORITHMS</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335</th>\n",
       "      <td>Pushpender</td>\n",
       "      <td>2K19CSUN01047</td>\n",
       "      <td>COMPUTER NETWORKS</td>\n",
       "      <td>Sem 5</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>Ayush Sharma</td>\n",
       "      <td>2K22CSUN01164</td>\n",
       "      <td>PROFESSIONAL ENGLISH</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347</th>\n",
       "      <td>Mohd Shahid Raza</td>\n",
       "      <td>2K21CSUL04002</td>\n",
       "      <td>INDIAN CONSTITUTION</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>Sanidhya Tiwari</td>\n",
       "      <td>2K21CSUN01091</td>\n",
       "      <td>DISCRETE MATHEMATICS</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>Lotti Uday Kiran Sai</td>\n",
       "      <td>2K20CSUN01063</td>\n",
       "      <td>FRENCH-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>Harsh Kumar Dhir</td>\n",
       "      <td>2K21CSUN01118</td>\n",
       "      <td>RESEARCH &amp; INNOVATION-I</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>Navneet</td>\n",
       "      <td>2K21CSUN03009</td>\n",
       "      <td>CALCULUS &amp; LINEAR ALGEBRA</td>\n",
       "      <td>Sem 2</td>\n",
       "      <td>B.Tech CSE CDA</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>Parag Mishra</td>\n",
       "      <td>2K20CSUN01074</td>\n",
       "      <td>COMPUTER GRAPHICS &amp; MULTIMEDIA</td>\n",
       "      <td>Sem 6</td>\n",
       "      <td>BTech CSE</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>Maddimsetti Navadeep</td>\n",
       "      <td>2K20CSUN04035</td>\n",
       "      <td>PROFESSIONAL COMPETENCY ENHANCEMENT-II</td>\n",
       "      <td>Sem 4</td>\n",
       "      <td>B.Tech CSE AIML</td>\n",
       "      <td>REGISTERED</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Student         Rollno  \\\n",
       "3            Puthi Rishik Sai Kumar  2K22CSUN01115   \n",
       "48                    Mahesh Tanwar  2K20CSUN01065   \n",
       "49                    Lakshay Bajaj  2K20CSUN01061   \n",
       "50                     Nishchay Raj  2K22ECUN03008   \n",
       "51                            Sagar  2K20CSUN01091   \n",
       "52                Gandi Sai Swaroop  2K20CSUN01128   \n",
       "53             Lotti Uday Kiran Sai  2K20CSUN01063   \n",
       "55                  Harsh Choudhary  2K20CSUN01042   \n",
       "89                    Vibhor Sharma  2K22CSUN01126   \n",
       "92                    Krishna Yadav  2K22CSUN06024   \n",
       "118          Puthi Rishik Sai Kumar  2K22CSUN01115   \n",
       "119                   Anshul Semwal  2K22CSUN01005   \n",
       "136                   Lakshay Bajaj  2K20CSUN01061   \n",
       "137                           Sagar  2K20CSUN01091   \n",
       "149    Kotakommula Sai Pavan Kalyan  2K20CSUN04031   \n",
       "150                           Aseem  2K21CSUN04007   \n",
       "153            Maddimsetti Navadeep  2K20CSUN04035   \n",
       "163                     Anuj Chaher  2K22MEUN03002   \n",
       "164                    Ayush Sharma  2K22CSUN01164   \n",
       "179            Enumula Saketh Kumar  2K21CSUN04047   \n",
       "202    Kotakommula Sai Pavan Kalyan  2K20CSUN04031   \n",
       "208             Potlapally Sai Teja  2K20CSUN04040   \n",
       "209                      Arjun Vats  2K21CSUN04006   \n",
       "214  Gadi Teja Siva Sankar Guru Sai  2K20CSUN04020   \n",
       "215        Vudari Dhamaruka Sivasai  2K20CSUN04055   \n",
       "216              Ireddi Sai Krishna  2K20CSUN04025   \n",
       "225                   Aditya Sharma  2K21CSUN01005   \n",
       "254                    Tushar Joshi  2K22CSUN01155   \n",
       "255               Mareti Ganesh Ram  2K22CSUN01239   \n",
       "257                      Ashna Jain  2K22CSUN01131   \n",
       "272                  Ashish Chauhan  2K20CSUN04006   \n",
       "273            Enumula Saketh Kumar  2K21CSUN04047   \n",
       "278               Rahil Singh Dalal  2K21CSUN01138   \n",
       "280                    Gopal Sharma  2K21CSUN01115   \n",
       "298                  Karan Khanduja  2K20MEUN03004   \n",
       "301                  Karan Khanduja  2K20MEUN03004   \n",
       "309                            Anuj  2K22CSUN01088   \n",
       "310                   Prateek Tyagi  2K21CSUN04057   \n",
       "311                   Krishna Yadav  2K22CSUN06013   \n",
       "314                      Anup Attri  2K22CSUN01054   \n",
       "315                           Nakul  2K22CSUN01073   \n",
       "335                      Pushpender  2K19CSUN01047   \n",
       "340                    Ayush Sharma  2K22CSUN01164   \n",
       "347                Mohd Shahid Raza  2K21CSUL04002   \n",
       "377                 Sanidhya Tiwari  2K21CSUN01091   \n",
       "381            Lotti Uday Kiran Sai  2K20CSUN01063   \n",
       "407                Harsh Kumar Dhir  2K21CSUN01118   \n",
       "421                         Navneet  2K21CSUN03009   \n",
       "432                    Parag Mishra  2K20CSUN01074   \n",
       "433            Maddimsetti Navadeep  2K20CSUN04035   \n",
       "\n",
       "                                  Sub. Name Semester                Class  \\\n",
       "3              DATA STRUCTURES & ALGORITHMS    Sem 2            BTech CSE   \n",
       "48                       APPLIED PSYCHOLOGY    Sem 6            BTech CSE   \n",
       "49                       APPLIED PSYCHOLOGY    Sem 6            BTech CSE   \n",
       "50                       APPLIED PSYCHOLOGY    Sem 2  B.Tech ECE VLSI D&V   \n",
       "51                       APPLIED PSYCHOLOGY    Sem 6            BTech CSE   \n",
       "52                          CLOUD COMPUTING    Sem 6            BTech CSE   \n",
       "53                          CLOUD COMPUTING    Sem 6            BTech CSE   \n",
       "55                          CLOUD COMPUTING    Sem 6            BTech CSE   \n",
       "89             DATA STRUCTURES & ALGORITHMS    Sem 2            BTech CSE   \n",
       "92             DATA STRUCTURES & ALGORITHMS    Sem 2          B.Tech R&AI   \n",
       "118                               CHEMISTRY    Sem 2            BTech CSE   \n",
       "119                               CHEMISTRY    Sem 2            BTech CSE   \n",
       "136          COMPUTER GRAPHICS & MULTIMEDIA    Sem 6            BTech CSE   \n",
       "137          COMPUTER GRAPHICS & MULTIMEDIA    Sem 6            BTech CSE   \n",
       "149                        OPERATING SYSTEM    Sem 4      B.Tech CSE AIML   \n",
       "150                        OPERATING SYSTEM    Sem 3      B.Tech CSE AIML   \n",
       "153                        OPERATING SYSTEM    Sem 4      B.Tech CSE AIML   \n",
       "163                    PROFESSIONAL ENGLISH    Sem 2                  SMA   \n",
       "164                    PROFESSIONAL ENGLISH    Sem 2      B.Tech CSE AIML   \n",
       "179                      PYTHON PROGRAMMING    Sem 2      B.Tech CSE AIML   \n",
       "202                                 BIOLOGY    Sem 7      B.Tech CSE AIML   \n",
       "208                       DIGITAL MARKETING    Sem 5      B.Tech CSE AIML   \n",
       "209                               FRENCH-II    Sem 4      B.Tech CSE AIML   \n",
       "214    THEORY OF AUTOMATA & COMPILER DESIGN    Sem 7      B.Tech CSE AIML   \n",
       "215    THEORY OF AUTOMATA & COMPILER DESIGN    Sem 7      B.Tech CSE AIML   \n",
       "216    THEORY OF AUTOMATA & COMPILER DESIGN    Sem 7      B.Tech CSE AIML   \n",
       "225  PROFESSIONAL COMPETANCY ENHANCEMENT-II    Sem 4            BTech CSE   \n",
       "254                             CHEMISTRY-1    Sem 1      B.Tech CSE AIML   \n",
       "255                             CHEMISTRY-1    Sem 1      B.Tech CSE CSTI   \n",
       "257          QUANTUM MECHANICS FOR ENGINEER    Sem 2      B.Tech CSE AIML   \n",
       "272                 RESEARCH & INNOVATION-I    Sem 4      B.Tech CSE AIML   \n",
       "273           PROFESSIONAL COMMUNICATION-II    Sem 2      B.Tech CSE AIML   \n",
       "278  PROFESSIONAL COMPETENCY ENHANCEMENT-II    Sem 4            BTech CSE   \n",
       "280  PROFESSIONAL COMPETENCY ENHANCEMENT-II    Sem 4            BTech CSE   \n",
       "298  PROFESSIONAL COMPETANCY ENHANCEMENT-IV    Sem 6                  SMA   \n",
       "301                               GERMAN-II    Sem 4                  SMA   \n",
       "309            DATA STRUCTURES & ALGORITHMS    Sem 2            BTech CSE   \n",
       "310            DATA STRUCTURES & ALGORITHMS    Sem 3      B.Tech CSE AIML   \n",
       "311            DATA STRUCTURES & ALGORITHMS    Sem 2          B.Tech R&AI   \n",
       "314            DATA STRUCTURES & ALGORITHMS    Sem 2            BTech CSE   \n",
       "315            DATA STRUCTURES & ALGORITHMS    Sem 2            BTech CSE   \n",
       "335                       COMPUTER NETWORKS    Sem 5            BTech CSE   \n",
       "340                    PROFESSIONAL ENGLISH    Sem 2      B.Tech CSE AIML   \n",
       "347                     INDIAN CONSTITUTION    Sem 4      B.Tech CSE AIML   \n",
       "377                    DISCRETE MATHEMATICS    Sem 4            BTech CSE   \n",
       "381                               FRENCH-II    Sem 4            BTech CSE   \n",
       "407                 RESEARCH & INNOVATION-I    Sem 4            BTech CSE   \n",
       "421               CALCULUS & LINEAR ALGEBRA    Sem 2       B.Tech CSE CDA   \n",
       "432          COMPUTER GRAPHICS & MULTIMEDIA    Sem 6            BTech CSE   \n",
       "433  PROFESSIONAL COMPETENCY ENHANCEMENT-II    Sem 4      B.Tech CSE AIML   \n",
       "\n",
       "         STATUS  Current_year  \n",
       "3    REGISTERED             2  \n",
       "48   REGISTERED             4  \n",
       "49   REGISTERED             4  \n",
       "50   REGISTERED             2  \n",
       "51   REGISTERED             4  \n",
       "52   REGISTERED             4  \n",
       "53   REGISTERED             4  \n",
       "55   REGISTERED             4  \n",
       "89   REGISTERED             2  \n",
       "92   REGISTERED             2  \n",
       "118  REGISTERED             2  \n",
       "119  REGISTERED             2  \n",
       "136  REGISTERED             4  \n",
       "137  REGISTERED             4  \n",
       "149  REGISTERED             4  \n",
       "150  REGISTERED             3  \n",
       "153  REGISTERED             4  \n",
       "163  REGISTERED             2  \n",
       "164  REGISTERED             2  \n",
       "179  REGISTERED             3  \n",
       "202  REGISTERED             4  \n",
       "208  REGISTERED             4  \n",
       "209  REGISTERED             3  \n",
       "214  REGISTERED             4  \n",
       "215  REGISTERED             4  \n",
       "216  REGISTERED             4  \n",
       "225  REGISTERED             3  \n",
       "254  REGISTERED             2  \n",
       "255  REGISTERED             2  \n",
       "257  REGISTERED             2  \n",
       "272  REGISTERED             4  \n",
       "273  REGISTERED             3  \n",
       "278  REGISTERED             3  \n",
       "280  REGISTERED             3  \n",
       "298  REGISTERED             4  \n",
       "301  REGISTERED             4  \n",
       "309  REGISTERED             2  \n",
       "310  REGISTERED             3  \n",
       "311  REGISTERED             2  \n",
       "314  REGISTERED             2  \n",
       "315  REGISTERED             2  \n",
       "335  REGISTERED             5  \n",
       "340  REGISTERED             2  \n",
       "347  REGISTERED             3  \n",
       "377  REGISTERED             3  \n",
       "381  REGISTERED             4  \n",
       "407  REGISTERED             3  \n",
       "421  REGISTERED             3  \n",
       "432  REGISTERED             4  \n",
       "433  REGISTERED             4  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "psc_stu"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Sub. Name\n",
       "DATA STRUCTURES & ALGORITHMS              8\n",
       "APPLIED PSYCHOLOGY                        4\n",
       "CLOUD COMPUTING                           3\n",
       "COMPUTER GRAPHICS & MULTIMEDIA            3\n",
       "OPERATING SYSTEM                          3\n",
       "PROFESSIONAL ENGLISH                      3\n",
       "PROFESSIONAL COMPETENCY ENHANCEMENT-II    3\n",
       "THEORY OF AUTOMATA & COMPILER DESIGN      3\n",
       "CHEMISTRY-1                               2\n",
       "CHEMISTRY                                 2\n",
       "RESEARCH & INNOVATION-I                   2\n",
       "FRENCH-II                                 2\n",
       "GERMAN-II                                 1\n",
       "INDIAN CONSTITUTION                       1\n",
       "COMPUTER NETWORKS                         1\n",
       "DISCRETE MATHEMATICS                      1\n",
       "PROFESSIONAL COMPETANCY ENHANCEMENT-IV    1\n",
       "PROFESSIONAL COMPETANCY ENHANCEMENT-II    1\n",
       "PROFESSIONAL COMMUNICATION-II             1\n",
       "QUANTUM MECHANICS FOR ENGINEER            1\n",
       "DIGITAL MARKETING                         1\n",
       "BIOLOGY                                   1\n",
       "PYTHON PROGRAMMING                        1\n",
       "CALCULUS & LINEAR ALGEBRA                 1\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "psc_stu[\"Sub. Name\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}