July2023_C4_S2_PraticeSolution.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "6d6ae637",
   "metadata": {},
   "source": [
    "# Preparation of Olympiad"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "61a12074",
   "metadata": {},
   "source": [
    "#  Task 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2b1d385a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from numpy import genfromtxt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "dc14b7e2",
   "metadata": {},
   "outputs": [],
   "source": [
    "std_id=pd.Series(range(1001,1041))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "7535e5f2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     1001\n",
       "1     1002\n",
       "2     1003\n",
       "3     1004\n",
       "4     1005\n",
       "5     1006\n",
       "6     1007\n",
       "7     1008\n",
       "8     1009\n",
       "9     1010\n",
       "10    1011\n",
       "11    1012\n",
       "12    1013\n",
       "13    1014\n",
       "14    1015\n",
       "15    1016\n",
       "16    1017\n",
       "17    1018\n",
       "18    1019\n",
       "19    1020\n",
       "20    1021\n",
       "21    1022\n",
       "22    1023\n",
       "23    1024\n",
       "24    1025\n",
       "25    1026\n",
       "26    1027\n",
       "27    1028\n",
       "28    1029\n",
       "29    1030\n",
       "30    1031\n",
       "31    1032\n",
       "32    1033\n",
       "33    1034\n",
       "34    1035\n",
       "35    1036\n",
       "36    1037\n",
       "37    1038\n",
       "38    1039\n",
       "39    1040\n",
       "dtype: int64"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "std_id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "8742a22e",
   "metadata": {},
   "outputs": [],
   "source": [
    "std_ids=pd.DataFrame(std_id,columns=['student_ids'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "5302665a",
   "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_ids</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>1038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1040</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    student_ids\n",
       "0          1001\n",
       "1          1002\n",
       "2          1003\n",
       "3          1004\n",
       "4          1005\n",
       "5          1006\n",
       "6          1007\n",
       "7          1008\n",
       "8          1009\n",
       "9          1010\n",
       "10         1011\n",
       "11         1012\n",
       "12         1013\n",
       "13         1014\n",
       "14         1015\n",
       "15         1016\n",
       "16         1017\n",
       "17         1018\n",
       "18         1019\n",
       "19         1020\n",
       "20         1021\n",
       "21         1022\n",
       "22         1023\n",
       "23         1024\n",
       "24         1025\n",
       "25         1026\n",
       "26         1027\n",
       "27         1028\n",
       "28         1029\n",
       "29         1030\n",
       "30         1031\n",
       "31         1032\n",
       "32         1033\n",
       "33         1034\n",
       "34         1035\n",
       "35         1036\n",
       "36         1037\n",
       "37         1038\n",
       "38         1039\n",
       "39         1040"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "std_ids"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "25852291",
   "metadata": {},
   "source": [
    "Conclusion - Assigned unique students id for 40 students"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a842a68d",
   "metadata": {},
   "source": [
    "# Task 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "0e4ee1ed",
   "metadata": {},
   "outputs": [],
   "source": [
    "maths_marks=[35, 86, 63, 90, 50, 63, 15, 72, 15, 54, 72, 83, 58, 70, 92, 40, 59, 63, 53, 59, 55, 85, 18, 83, 67, 85, 46, 59, 77, 71, 77, 56, 79, 61, 82, 76, 60, 52, 88, 78]\n",
    "physics_marks=[85, 94, 63, 59, 76, 64, 87, 55, 51, 71, 54, 94, 33, 72, 75, 67, 85, 15, 50, 50, 19, 55, 59, 65, 76, 13, 57, 70, 51, 94, 55, 50, 71, 91, 75, 51, 90, 70, 87, 56]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ed4ae24f",
   "metadata": {},
   "outputs": [],
   "source": [
    "maths=np.array(maths_marks)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "33e2b525",
   "metadata": {},
   "outputs": [],
   "source": [
    "physics=np.array(physics_marks)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "d7a644c7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([35, 86, 63, 90, 50, 63, 15, 72, 15, 54, 72, 83, 58, 70, 92, 40, 59,\n",
       "       63, 53, 59, 55, 85, 18, 83, 67, 85, 46, 59, 77, 71, 77, 56, 79, 61,\n",
       "       82, 76, 60, 52, 88, 78])"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maths"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2f85b9cc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([85, 94, 63, 59, 76, 64, 87, 55, 51, 71, 54, 94, 33, 72, 75, 67, 85,\n",
       "       15, 50, 50, 19, 55, 59, 65, 76, 13, 57, 70, 51, 94, 55, 50, 71, 91,\n",
       "       75, 51, 90, 70, 87, 56])"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "physics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "c091828c",
   "metadata": {},
   "outputs": [],
   "source": [
    "physics_score=pd.Series(physics,index=std_id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "e9120404",
   "metadata": {},
   "outputs": [],
   "source": [
    "maths_score=pd.Series(maths,index=std_id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "5a061c35",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1001    85\n",
       "1002    94\n",
       "1003    63\n",
       "1004    59\n",
       "1005    76\n",
       "1006    64\n",
       "1007    87\n",
       "1008    55\n",
       "1009    51\n",
       "1010    71\n",
       "1011    54\n",
       "1012    94\n",
       "1013    33\n",
       "1014    72\n",
       "1015    75\n",
       "1016    67\n",
       "1017    85\n",
       "1018    15\n",
       "1019    50\n",
       "1020    50\n",
       "1021    19\n",
       "1022    55\n",
       "1023    59\n",
       "1024    65\n",
       "1025    76\n",
       "1026    13\n",
       "1027    57\n",
       "1028    70\n",
       "1029    51\n",
       "1030    94\n",
       "1031    55\n",
       "1032    50\n",
       "1033    71\n",
       "1034    91\n",
       "1035    75\n",
       "1036    51\n",
       "1037    90\n",
       "1038    70\n",
       "1039    87\n",
       "1040    56\n",
       "dtype: int32"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "physics_score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "2ca41abe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1001    35\n",
       "1002    86\n",
       "1003    63\n",
       "1004    90\n",
       "1005    50\n",
       "1006    63\n",
       "1007    15\n",
       "1008    72\n",
       "1009    15\n",
       "1010    54\n",
       "1011    72\n",
       "1012    83\n",
       "1013    58\n",
       "1014    70\n",
       "1015    92\n",
       "1016    40\n",
       "1017    59\n",
       "1018    63\n",
       "1019    53\n",
       "1020    59\n",
       "1021    55\n",
       "1022    85\n",
       "1023    18\n",
       "1024    83\n",
       "1025    67\n",
       "1026    85\n",
       "1027    46\n",
       "1028    59\n",
       "1029    77\n",
       "1030    71\n",
       "1031    77\n",
       "1032    56\n",
       "1033    79\n",
       "1034    61\n",
       "1035    82\n",
       "1036    76\n",
       "1037    60\n",
       "1038    52\n",
       "1039    88\n",
       "1040    78\n",
       "dtype: int32"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maths_score"
   ]
  },
  {
   "cell_type": "raw",
   "id": "c0eaa7a9",
   "metadata": {},
   "source": [
    "Conclusion - The student id and maths marks is displayed in series and student id and maths marks displayed in series"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3d164128",
   "metadata": {},
   "source": [
    "# Task 3 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "3ced12f0",
   "metadata": {},
   "outputs": [],
   "source": [
    "total_marks = physics+maths"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "93b248b1",
   "metadata": {},
   "outputs": [],
   "source": [
    "total=pd.Series(total_marks,index=std_id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "bef4a453",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1001    120\n",
       "1002    180\n",
       "1003    126\n",
       "1004    149\n",
       "1005    126\n",
       "1006    127\n",
       "1007    102\n",
       "1008    127\n",
       "1009     66\n",
       "1010    125\n",
       "1011    126\n",
       "1012    177\n",
       "1013     91\n",
       "1014    142\n",
       "1015    167\n",
       "1016    107\n",
       "1017    144\n",
       "1018     78\n",
       "1019    103\n",
       "1020    109\n",
       "1021     74\n",
       "1022    140\n",
       "1023     77\n",
       "1024    148\n",
       "1025    143\n",
       "1026     98\n",
       "1027    103\n",
       "1028    129\n",
       "1029    128\n",
       "1030    165\n",
       "1031    132\n",
       "1032    106\n",
       "1033    150\n",
       "1034    152\n",
       "1035    157\n",
       "1036    127\n",
       "1037    150\n",
       "1038    122\n",
       "1039    175\n",
       "1040    134\n",
       "dtype: int32"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1c27d08c",
   "metadata": {},
   "source": [
    "Conclusion - The student id and the total marks is displayed as total is combination of maths and physics "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "980320d9",
   "metadata": {},
   "source": [
    "# Task 4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "dfbb69c9",
   "metadata": {},
   "outputs": [],
   "source": [
    "filtered=total[(total_marks>120)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "c746cc34",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1002    180\n",
       "1003    126\n",
       "1004    149\n",
       "1005    126\n",
       "1006    127\n",
       "1008    127\n",
       "1010    125\n",
       "1011    126\n",
       "1012    177\n",
       "1014    142\n",
       "1015    167\n",
       "1017    144\n",
       "1022    140\n",
       "1024    148\n",
       "1025    143\n",
       "1028    129\n",
       "1029    128\n",
       "1030    165\n",
       "1031    132\n",
       "1033    150\n",
       "1034    152\n",
       "1035    157\n",
       "1036    127\n",
       "1037    150\n",
       "1038    122\n",
       "1039    175\n",
       "1040    134\n",
       "dtype: int32"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "af5ad595",
   "metadata": {},
   "source": [
    "Conclusion - The student id and total marks is shown where the total marks > 120."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0f3a5e56",
   "metadata": {},
   "source": [
    "# Task 5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "f2dcd78e",
   "metadata": {},
   "outputs": [],
   "source": [
    "round1qualifies= pd.DataFrame(filtered,columns=['round1qualifiers'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "c03580a5",
   "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>round1qualifiers</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1002</th>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003</th>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1004</th>\n",
       "      <td>149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1005</th>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1006</th>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1008</th>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1010</th>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1011</th>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1012</th>\n",
       "      <td>177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014</th>\n",
       "      <td>142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1015</th>\n",
       "      <td>167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1017</th>\n",
       "      <td>144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1022</th>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1024</th>\n",
       "      <td>148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1025</th>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1028</th>\n",
       "      <td>129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029</th>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1030</th>\n",
       "      <td>165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1031</th>\n",
       "      <td>132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1033</th>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1034</th>\n",
       "      <td>152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1035</th>\n",
       "      <td>157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1036</th>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1037</th>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1038</th>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1039</th>\n",
       "      <td>175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1040</th>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      round1qualifiers\n",
       "1002               180\n",
       "1003               126\n",
       "1004               149\n",
       "1005               126\n",
       "1006               127\n",
       "1008               127\n",
       "1010               125\n",
       "1011               126\n",
       "1012               177\n",
       "1014               142\n",
       "1015               167\n",
       "1017               144\n",
       "1022               140\n",
       "1024               148\n",
       "1025               143\n",
       "1028               129\n",
       "1029               128\n",
       "1030               165\n",
       "1031               132\n",
       "1033               150\n",
       "1034               152\n",
       "1035               157\n",
       "1036               127\n",
       "1037               150\n",
       "1038               122\n",
       "1039               175\n",
       "1040               134"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "round1qualifies"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "90ac1a93",
   "metadata": {},
   "source": [
    "Conclusion - The student id and total marks is shown where the total marks > 120 which is shown is diplayed as round 1 qualifiers in DataFrame."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "74ee7bd6",
   "metadata": {},
   "source": [
    "# Task 6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "cbeb72c5",
   "metadata": {},
   "outputs": [],
   "source": [
    "total_marks=np.array(total)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "44bb3e68",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([120, 180, 126, 149, 126, 127, 102, 127,  66, 125, 126, 177,  91,\n",
       "       142, 167, 107, 144,  78, 103, 109,  74, 140,  77, 148, 143,  98,\n",
       "       103, 129, 128, 165, 132, 106, 150, 152, 157, 127, 150, 122, 175,\n",
       "       134])"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total_marks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "d4f01ef1",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "c86f8ad0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"student_id\"]=std_id\n",
    "df[\"maths_marks\"]= maths\n",
    "df[\"physics_marks\"]=physics\n",
    "df[\"total_marks\"]=total_marks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "4853362c",
   "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_id</th>\n",
       "      <th>maths_marks</th>\n",
       "      <th>physics_marks</th>\n",
       "      <th>total_marks</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1001</td>\n",
       "      <td>35</td>\n",
       "      <td>85</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1002</td>\n",
       "      <td>86</td>\n",
       "      <td>94</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1003</td>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1004</td>\n",
       "      <td>90</td>\n",
       "      <td>59</td>\n",
       "      <td>149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1005</td>\n",
       "      <td>50</td>\n",
       "      <td>76</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1006</td>\n",
       "      <td>63</td>\n",
       "      <td>64</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1007</td>\n",
       "      <td>15</td>\n",
       "      <td>87</td>\n",
       "      <td>102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1008</td>\n",
       "      <td>72</td>\n",
       "      <td>55</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1009</td>\n",
       "      <td>15</td>\n",
       "      <td>51</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1010</td>\n",
       "      <td>54</td>\n",
       "      <td>71</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1011</td>\n",
       "      <td>72</td>\n",
       "      <td>54</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1012</td>\n",
       "      <td>83</td>\n",
       "      <td>94</td>\n",
       "      <td>177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1013</td>\n",
       "      <td>58</td>\n",
       "      <td>33</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1014</td>\n",
       "      <td>70</td>\n",
       "      <td>72</td>\n",
       "      <td>142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1015</td>\n",
       "      <td>92</td>\n",
       "      <td>75</td>\n",
       "      <td>167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1016</td>\n",
       "      <td>40</td>\n",
       "      <td>67</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1017</td>\n",
       "      <td>59</td>\n",
       "      <td>85</td>\n",
       "      <td>144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1018</td>\n",
       "      <td>63</td>\n",
       "      <td>15</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1019</td>\n",
       "      <td>53</td>\n",
       "      <td>50</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1020</td>\n",
       "      <td>59</td>\n",
       "      <td>50</td>\n",
       "      <td>109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1021</td>\n",
       "      <td>55</td>\n",
       "      <td>19</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1022</td>\n",
       "      <td>85</td>\n",
       "      <td>55</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1023</td>\n",
       "      <td>18</td>\n",
       "      <td>59</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1024</td>\n",
       "      <td>83</td>\n",
       "      <td>65</td>\n",
       "      <td>148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1025</td>\n",
       "      <td>67</td>\n",
       "      <td>76</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1026</td>\n",
       "      <td>85</td>\n",
       "      <td>13</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1027</td>\n",
       "      <td>46</td>\n",
       "      <td>57</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1028</td>\n",
       "      <td>59</td>\n",
       "      <td>70</td>\n",
       "      <td>129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1029</td>\n",
       "      <td>77</td>\n",
       "      <td>51</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1030</td>\n",
       "      <td>71</td>\n",
       "      <td>94</td>\n",
       "      <td>165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1031</td>\n",
       "      <td>77</td>\n",
       "      <td>55</td>\n",
       "      <td>132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1032</td>\n",
       "      <td>56</td>\n",
       "      <td>50</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1033</td>\n",
       "      <td>79</td>\n",
       "      <td>71</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1034</td>\n",
       "      <td>61</td>\n",
       "      <td>91</td>\n",
       "      <td>152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1035</td>\n",
       "      <td>82</td>\n",
       "      <td>75</td>\n",
       "      <td>157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1036</td>\n",
       "      <td>76</td>\n",
       "      <td>51</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1037</td>\n",
       "      <td>60</td>\n",
       "      <td>90</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>1038</td>\n",
       "      <td>52</td>\n",
       "      <td>70</td>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1039</td>\n",
       "      <td>88</td>\n",
       "      <td>87</td>\n",
       "      <td>175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1040</td>\n",
       "      <td>78</td>\n",
       "      <td>56</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    student_id  maths_marks  physics_marks  total_marks\n",
       "0         1001           35             85          120\n",
       "1         1002           86             94          180\n",
       "2         1003           63             63          126\n",
       "3         1004           90             59          149\n",
       "4         1005           50             76          126\n",
       "5         1006           63             64          127\n",
       "6         1007           15             87          102\n",
       "7         1008           72             55          127\n",
       "8         1009           15             51           66\n",
       "9         1010           54             71          125\n",
       "10        1011           72             54          126\n",
       "11        1012           83             94          177\n",
       "12        1013           58             33           91\n",
       "13        1014           70             72          142\n",
       "14        1015           92             75          167\n",
       "15        1016           40             67          107\n",
       "16        1017           59             85          144\n",
       "17        1018           63             15           78\n",
       "18        1019           53             50          103\n",
       "19        1020           59             50          109\n",
       "20        1021           55             19           74\n",
       "21        1022           85             55          140\n",
       "22        1023           18             59           77\n",
       "23        1024           83             65          148\n",
       "24        1025           67             76          143\n",
       "25        1026           85             13           98\n",
       "26        1027           46             57          103\n",
       "27        1028           59             70          129\n",
       "28        1029           77             51          128\n",
       "29        1030           71             94          165\n",
       "30        1031           77             55          132\n",
       "31        1032           56             50          106\n",
       "32        1033           79             71          150\n",
       "33        1034           61             91          152\n",
       "34        1035           82             75          157\n",
       "35        1036           76             51          127\n",
       "36        1037           60             90          150\n",
       "37        1038           52             70          122\n",
       "38        1039           88             87          175\n",
       "39        1040           78             56          134"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "26ebd650",
   "metadata": {},
   "outputs": [],
   "source": [
    "filtered_data =df[(df['maths_marks']>=50) & (df['physics_marks']>=50) & (df['total_marks']>=120)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "8d4194e8",
   "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_id</th>\n",
       "      <th>maths_marks</th>\n",
       "      <th>physics_marks</th>\n",
       "      <th>total_marks</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1002</td>\n",
       "      <td>86</td>\n",
       "      <td>94</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1003</td>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1004</td>\n",
       "      <td>90</td>\n",
       "      <td>59</td>\n",
       "      <td>149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1005</td>\n",
       "      <td>50</td>\n",
       "      <td>76</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1006</td>\n",
       "      <td>63</td>\n",
       "      <td>64</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1008</td>\n",
       "      <td>72</td>\n",
       "      <td>55</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1010</td>\n",
       "      <td>54</td>\n",
       "      <td>71</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1011</td>\n",
       "      <td>72</td>\n",
       "      <td>54</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1012</td>\n",
       "      <td>83</td>\n",
       "      <td>94</td>\n",
       "      <td>177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1014</td>\n",
       "      <td>70</td>\n",
       "      <td>72</td>\n",
       "      <td>142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1015</td>\n",
       "      <td>92</td>\n",
       "      <td>75</td>\n",
       "      <td>167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1017</td>\n",
       "      <td>59</td>\n",
       "      <td>85</td>\n",
       "      <td>144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1022</td>\n",
       "      <td>85</td>\n",
       "      <td>55</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1024</td>\n",
       "      <td>83</td>\n",
       "      <td>65</td>\n",
       "      <td>148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1025</td>\n",
       "      <td>67</td>\n",
       "      <td>76</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1028</td>\n",
       "      <td>59</td>\n",
       "      <td>70</td>\n",
       "      <td>129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1029</td>\n",
       "      <td>77</td>\n",
       "      <td>51</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1030</td>\n",
       "      <td>71</td>\n",
       "      <td>94</td>\n",
       "      <td>165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1031</td>\n",
       "      <td>77</td>\n",
       "      <td>55</td>\n",
       "      <td>132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1033</td>\n",
       "      <td>79</td>\n",
       "      <td>71</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1034</td>\n",
       "      <td>61</td>\n",
       "      <td>91</td>\n",
       "      <td>152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1035</td>\n",
       "      <td>82</td>\n",
       "      <td>75</td>\n",
       "      <td>157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1036</td>\n",
       "      <td>76</td>\n",
       "      <td>51</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1037</td>\n",
       "      <td>60</td>\n",
       "      <td>90</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>1038</td>\n",
       "      <td>52</td>\n",
       "      <td>70</td>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1039</td>\n",
       "      <td>88</td>\n",
       "      <td>87</td>\n",
       "      <td>175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1040</td>\n",
       "      <td>78</td>\n",
       "      <td>56</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    student_id  maths_marks  physics_marks  total_marks\n",
       "1         1002           86             94          180\n",
       "2         1003           63             63          126\n",
       "3         1004           90             59          149\n",
       "4         1005           50             76          126\n",
       "5         1006           63             64          127\n",
       "7         1008           72             55          127\n",
       "9         1010           54             71          125\n",
       "10        1011           72             54          126\n",
       "11        1012           83             94          177\n",
       "13        1014           70             72          142\n",
       "14        1015           92             75          167\n",
       "16        1017           59             85          144\n",
       "21        1022           85             55          140\n",
       "23        1024           83             65          148\n",
       "24        1025           67             76          143\n",
       "27        1028           59             70          129\n",
       "28        1029           77             51          128\n",
       "29        1030           71             94          165\n",
       "30        1031           77             55          132\n",
       "32        1033           79             71          150\n",
       "33        1034           61             91          152\n",
       "34        1035           82             75          157\n",
       "35        1036           76             51          127\n",
       "36        1037           60             90          150\n",
       "37        1038           52             70          122\n",
       "38        1039           88             87          175\n",
       "39        1040           78             56          134"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "67291a24",
   "metadata": {},
   "outputs": [],
   "source": [
    "round2qualifiers=pd.DataFrame(filtered_data.student_id)\n",
    "round2qualifiers.rename(columns = {'student_ids':'round2qualifiers'},inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "afa5be12",
   "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_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>1038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1040</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    student_id\n",
       "1         1002\n",
       "2         1003\n",
       "3         1004\n",
       "4         1005\n",
       "5         1006\n",
       "7         1008\n",
       "9         1010\n",
       "10        1011\n",
       "11        1012\n",
       "13        1014\n",
       "14        1015\n",
       "16        1017\n",
       "21        1022\n",
       "23        1024\n",
       "24        1025\n",
       "27        1028\n",
       "28        1029\n",
       "29        1030\n",
       "30        1031\n",
       "32        1033\n",
       "33        1034\n",
       "34        1035\n",
       "35        1036\n",
       "36        1037\n",
       "37        1038\n",
       "38        1039\n",
       "39        1040"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "round2qualifiers"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b214bfda",
   "metadata": {},
   "source": [
    "Conclusion - Filtered the data according to the condition and made them as round2qualifers"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "61c6b33c",
   "metadata": {},
   "source": [
    "# Task 7 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "422e622b",
   "metadata": {},
   "outputs": [],
   "source": [
    "count=len(round2qualifiers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "d014fd89",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "27"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "count"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d959dd77",
   "metadata": {},
   "source": [
    "Conclusion - The number of students of round2qualifiers is found to be 27"
   ]
  }
 ],
 "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}