school data pandas work.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from pandas import DataFrame, Series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>022-14-19987</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Abdul Basit</td>\n",
       "      <td>28</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>25.0</td>\n",
       "      <td>70</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>022-14-110233</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Adeel Ahmed</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>32</td>\n",
       "      <td>18.0</td>\n",
       "      <td>50</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>022-14-110585</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Afrah Zareen</td>\n",
       "      <td>18</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>33</td>\n",
       "      <td>30.0</td>\n",
       "      <td>63</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>022-14-19718</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahmed Ali Raza</td>\n",
       "      <td>14</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>23.0</td>\n",
       "      <td>46</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>022-14-110648</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahsan Ali Vohra</td>\n",
       "      <td>27</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>43</td>\n",
       "      <td>34.0</td>\n",
       "      <td>77</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>022-14-110232</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ameer Hamza</td>\n",
       "      <td>25</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>27.0</td>\n",
       "      <td>71</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>022-14-110588</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Anas Ali Khan</td>\n",
       "      <td>28</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>30.0</td>\n",
       "      <td>74</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>022-14-110388</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Aneebullah Niazi</td>\n",
       "      <td>26</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>40.0</td>\n",
       "      <td>85</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>022-14-110601</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Areesha Sohail</td>\n",
       "      <td>19</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>37</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>022-14-110599</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Arsalan</td>\n",
       "      <td>28</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>44</td>\n",
       "      <td>40.0</td>\n",
       "      <td>84</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>022-14-110214</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Fatima Haider Warsi</td>\n",
       "      <td>30</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>46</td>\n",
       "      <td>45.0</td>\n",
       "      <td>91</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>022-14-110591</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Habib Ullah</td>\n",
       "      <td>28</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>41</td>\n",
       "      <td>35.0</td>\n",
       "      <td>76</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>022-15-110994</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Hafiza Tooba Akbani</td>\n",
       "      <td>23</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>40</td>\n",
       "      <td>33.0</td>\n",
       "      <td>73</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>022-14-110600</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Hamza Abdul Jabbar</td>\n",
       "      <td>24</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>42</td>\n",
       "      <td>25.0</td>\n",
       "      <td>67</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>022-14-110389</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Hareem Afshan</td>\n",
       "      <td>21</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8</td>\n",
       "      <td>36</td>\n",
       "      <td>29.0</td>\n",
       "      <td>65</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>022-14-19916</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Haseeb Sajid</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>022-14-110596</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Hassam Ahmed</td>\n",
       "      <td>23</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>37</td>\n",
       "      <td>35.0</td>\n",
       "      <td>72</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>022-14-110396</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Khalid Anwer</td>\n",
       "      <td>20</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>39</td>\n",
       "      <td>31.0</td>\n",
       "      <td>70</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>022-14-110223</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Madiha Jabeen</td>\n",
       "      <td>16</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>31</td>\n",
       "      <td>29.0</td>\n",
       "      <td>60</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>022-14-110222</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Mohammad Hunain</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>46</td>\n",
       "      <td>45.0</td>\n",
       "      <td>91</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>022-14-110412</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Aamir</td>\n",
       "      <td>24</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>40</td>\n",
       "      <td>31.0</td>\n",
       "      <td>71</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>022-14-110593</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Abdul Rehman Siddiqui</td>\n",
       "      <td>20</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>20.0</td>\n",
       "      <td>60</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>022-14-110398</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Abdullah</td>\n",
       "      <td>20</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>34</td>\n",
       "      <td>23.0</td>\n",
       "      <td>57</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>022-14-19983</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Ali Iqbal</td>\n",
       "      <td>26</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>41</td>\n",
       "      <td>21.0</td>\n",
       "      <td>62</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>022-14-110215</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Bilal</td>\n",
       "      <td>28</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>44</td>\n",
       "      <td>33.0</td>\n",
       "      <td>77</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>022-14-110105</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Faraz</td>\n",
       "      <td>26</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>41.0</td>\n",
       "      <td>86</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>022-14-110370</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Ghazali Faridi</td>\n",
       "      <td>27</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8</td>\n",
       "      <td>41</td>\n",
       "      <td>24.0</td>\n",
       "      <td>65</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>022-14-110452</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Osama Khan</td>\n",
       "      <td>27</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>26.0</td>\n",
       "      <td>71</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>022-14-110387</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Saqib Intizar</td>\n",
       "      <td>22</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>39</td>\n",
       "      <td>18.0</td>\n",
       "      <td>57</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>022-14-110217</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Shahroz Khurshid</td>\n",
       "      <td>17</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>9.0</td>\n",
       "      <td>39</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>022-14-110401</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Shozab</td>\n",
       "      <td>23</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>40</td>\n",
       "      <td>32.0</td>\n",
       "      <td>72</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>022-14-110231</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Taha Hasnain</td>\n",
       "      <td>27</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>29.0</td>\n",
       "      <td>73</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>022-14-110035</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Wajahat Khan</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>21</td>\n",
       "      <td>8.0</td>\n",
       "      <td>29</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>022-14-19919</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Younus Baig</td>\n",
       "      <td>20</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>34</td>\n",
       "      <td>17.0</td>\n",
       "      <td>51</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>022-14-110413</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Nazeer Bin Zafar</td>\n",
       "      <td>25</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>42.0</td>\n",
       "      <td>86</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>022-14-19923</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Rabi Ahmed</td>\n",
       "      <td>20</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>38</td>\n",
       "      <td>28.0</td>\n",
       "      <td>66</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>022-14-110582</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Rida Nasim</td>\n",
       "      <td>25</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>43</td>\n",
       "      <td>27.0</td>\n",
       "      <td>70</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>022-14-110230</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sadaf Nosheen</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>30.0</td>\n",
       "      <td>75</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>022-14-110229</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sadaquat Rafique</td>\n",
       "      <td>9</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7</td>\n",
       "      <td>22</td>\n",
       "      <td>17.0</td>\n",
       "      <td>39</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>022-14-110107</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sania Iqbal</td>\n",
       "      <td>28</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>43</td>\n",
       "      <td>25.0</td>\n",
       "      <td>68</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>022-14-110584</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sharif Taqi</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>46</td>\n",
       "      <td>35.0</td>\n",
       "      <td>81</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>022-14-110225</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Shariqa Ahmad</td>\n",
       "      <td>20</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>37</td>\n",
       "      <td>20.0</td>\n",
       "      <td>57</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>022-14-110587</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sumbul Rehman</td>\n",
       "      <td>28</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>23.0</td>\n",
       "      <td>67</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>022-14-110451</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syed Faizan Uddin</td>\n",
       "      <td>28</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8</td>\n",
       "      <td>45</td>\n",
       "      <td>34.0</td>\n",
       "      <td>79</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>022-14-110589</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syed Sohaib</td>\n",
       "      <td>25</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>41</td>\n",
       "      <td>22.0</td>\n",
       "      <td>63</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>022-14-110400</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syeda Sabika Raza</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>35.0</td>\n",
       "      <td>80</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>022-14-19911</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Usman Khan</td>\n",
       "      <td>25</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>43</td>\n",
       "      <td>22.0</td>\n",
       "      <td>65</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>022-14-110219</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Waqar Ahmed</td>\n",
       "      <td>11</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>19.0</td>\n",
       "      <td>46</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Student_Code  Degree                    Student_Name  Mid  Quiz_1  \\\n",
       "0    022-14-19987  BS(CS)                     Abdul Basit   28     8.0   \n",
       "1   022-14-110233  BS(CS)                     Adeel Ahmed   17     NaN   \n",
       "2   022-14-110585  BS(CS)                    Afrah Zareen   18     5.0   \n",
       "3    022-14-19718  BS(CS)                  Ahmed Ali Raza   14     7.0   \n",
       "4   022-14-110648  BS(CS)                 Ahsan Ali Vohra   27     7.0   \n",
       "5   022-14-110232  BS(CS)                     Ameer Hamza   25     9.0   \n",
       "6   022-14-110588  BS(CS)                   Anas Ali Khan   28     5.0   \n",
       "7   022-14-110388  BS(CS)                Aneebullah Niazi   26     9.0   \n",
       "8   022-14-110601  BS(CS)                  Areesha Sohail   19     9.0   \n",
       "9   022-14-110599  BS(CS)                         Arsalan   28     8.0   \n",
       "10  022-14-110214  BS(CS)             Fatima Haider Warsi   30     8.0   \n",
       "11  022-14-110591  BS(CS)                     Habib Ullah   28     8.0   \n",
       "12  022-15-110994  BS(CS)             Hafiza Tooba Akbani   23     7.0   \n",
       "13  022-14-110600  BS(CS)              Hamza Abdul Jabbar   24     8.0   \n",
       "14  022-14-110389  BS(CS)                   Hareem Afshan   21     7.0   \n",
       "15   022-14-19916  BS(CS)                    Haseeb Sajid   18     NaN   \n",
       "16  022-14-110596  BS(CS)                    Hassam Ahmed   23     5.0   \n",
       "17  022-14-110396  BS(CS)                    Khalid Anwer   20     8.0   \n",
       "18  022-14-110223  BS(CS)                   Madiha Jabeen   16     5.0   \n",
       "19  022-14-110222  BS(CS)                 Mohammad Hunain   27     9.0   \n",
       "20  022-14-110412  BS(CS)                  Muhammad Aamir   24     7.0   \n",
       "21  022-14-110593  BS(CS)  Muhammad Abdul Rehman Siddiqui   20     9.0   \n",
       "22  022-14-110398  BS(CS)               Muhammad Abdullah   20     7.0   \n",
       "23   022-14-19983  BS(CS)              Muhammad Ali Iqbal   26     5.0   \n",
       "24  022-14-110215  BS(CS)                  Muhammad Bilal   28     5.0   \n",
       "25  022-14-110105  BS(CS)                  Muhammad Faraz   26     9.0   \n",
       "26  022-14-110370  BS(CS)         Muhammad Ghazali Faridi   27     6.0   \n",
       "27  022-14-110452  BS(CS)             Muhammad Osama Khan   27     8.0   \n",
       "28  022-14-110387  BS(CS)          Muhammad Saqib Intizar   22     6.0   \n",
       "29  022-14-110217  BS(CS)       Muhammad Shahroz Khurshid   17     7.0   \n",
       "30  022-14-110401  BS(CS)                 Muhammad Shozab   23     8.0   \n",
       "31  022-14-110231  BS(CS)           Muhammad Taha Hasnain   27     7.0   \n",
       "32  022-14-110035  BS(CS)           Muhammad Wajahat Khan    9     NaN   \n",
       "33   022-14-19919  BS(CS)            Muhammad Younus Baig   20     4.0   \n",
       "34  022-14-110413  BS(CS)                Nazeer Bin Zafar   25     9.0   \n",
       "35   022-14-19923  BS(CS)                      Rabi Ahmed   20     8.0   \n",
       "36  022-14-110582  BS(CS)                      Rida Nasim   25     9.0   \n",
       "37  022-14-110230  BS(CS)                   Sadaf Nosheen   27     9.0   \n",
       "38  022-14-110229  BS(CS)                Sadaquat Rafique    9     6.0   \n",
       "39  022-14-110107  BS(CS)                     Sania Iqbal   28     4.0   \n",
       "40  022-14-110584  BS(CS)                     Sharif Taqi   27     9.0   \n",
       "41  022-14-110225  BS(CS)                   Shariqa Ahmad   20     7.0   \n",
       "42  022-14-110587  BS(CS)                   Sumbul Rehman   28     5.0   \n",
       "43  022-14-110451  BS(CS)               Syed Faizan Uddin   28     9.0   \n",
       "44  022-14-110589  BS(CS)                     Syed Sohaib   25     7.0   \n",
       "45  022-14-110400  BS(CS)               Syeda Sabika Raza   27     9.0   \n",
       "46   022-14-19911  BS(CS)                      Usman Khan   25     8.0   \n",
       "47  022-14-110219  BS(CS)                     Waqar Ahmed   11     9.0   \n",
       "\n",
       "    Quiz_2  Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "0      3.0                8           7.0           9.0                    9   \n",
       "1      5.0                5           8.0          10.0                   10   \n",
       "2      2.0                5           8.0          10.0                   10   \n",
       "3      2.0                7           NaN           2.0                    2   \n",
       "4      6.0                7           7.0           9.0                    9   \n",
       "5      6.0                9           8.0          10.0                   10   \n",
       "6      6.0                6           8.0          10.0                   10   \n",
       "7      6.0                9           8.0          10.0                   10   \n",
       "8      4.0                9           7.0           9.0                    9   \n",
       "9      6.0                8           8.0           NaN                    8   \n",
       "10     7.0                8           8.0           NaN                    8   \n",
       "11     5.0                8           5.0           NaN                    5   \n",
       "12     5.0                7           8.0          10.0                   10   \n",
       "13     4.0                8           8.0          10.0                   10   \n",
       "14     4.0                7           6.0           8.0                    8   \n",
       "15     NaN                0           NaN           NaN                    0   \n",
       "16     5.0                5           7.0           9.0                    9   \n",
       "17     5.0                8           9.0          11.0                   11   \n",
       "18     2.0                5           8.0          10.0                   10   \n",
       "19     6.0                9           8.0          10.0                   10   \n",
       "20     6.0                7           7.0           9.0                    9   \n",
       "21     6.0                9           9.0          11.0                   11   \n",
       "22     6.0                7           7.0           NaN                    7   \n",
       "23     NaN                5           8.0          10.0                   10   \n",
       "24     4.0                5           9.0          11.0                   11   \n",
       "25     6.0                9           8.0          10.0                   10   \n",
       "26     NaN                6           6.0           8.0                    8   \n",
       "27     6.0                8           8.0          10.0                   10   \n",
       "28     6.0                6           9.0          11.0                   11   \n",
       "29     1.0                7           6.0           NaN                    6   \n",
       "30     6.0                8           9.0           NaN                    9   \n",
       "31     5.0                7          10.0           NaN                   10   \n",
       "32     2.0                2           8.0          10.0                   10   \n",
       "33     2.0                4           8.0          10.0                   10   \n",
       "34     6.0                9           8.0          10.0                   10   \n",
       "35     5.0                8           NaN          10.0                   10   \n",
       "36     5.0                9           9.0           NaN                    9   \n",
       "37     5.0                9           9.0           NaN                    9   \n",
       "38     6.0                6           5.0           7.0                    7   \n",
       "39     4.0                4           9.0          11.0                   11   \n",
       "40     6.0                9           8.0          10.0                   10   \n",
       "41     6.0                7           8.0          10.0                   10   \n",
       "42     6.0                6           8.0          10.0                   10   \n",
       "43     4.0                9           6.0           8.0                    8   \n",
       "44     5.0                7           9.0           NaN                    9   \n",
       "45     6.0                9           9.0           NaN                    9   \n",
       "46     5.0                8           8.0          10.0                   10   \n",
       "47     5.0                9           5.0           7.0                    7   \n",
       "\n",
       "    Total_Sessional_(50)  Final (50)  Total (100) Grade  \n",
       "0                     45        25.0           70     B  \n",
       "1                     32        18.0           50     F  \n",
       "2                     33        30.0           63     C  \n",
       "3                     23        23.0           46     F  \n",
       "4                     43        34.0           77     B  \n",
       "5                     44        27.0           71     B  \n",
       "6                     44        30.0           74     B  \n",
       "7                     45        40.0           85     A  \n",
       "8                     37        24.0           61     C  \n",
       "9                     44        40.0           84     A  \n",
       "10                    46        45.0           91     A  \n",
       "11                    41        35.0           76     B  \n",
       "12                    40        33.0           73     B  \n",
       "13                    42        25.0           67     C  \n",
       "14                    36        29.0           65     C  \n",
       "15                    18         NaN           18     F  \n",
       "16                    37        35.0           72     B  \n",
       "17                    39        31.0           70     B  \n",
       "18                    31        29.0           60     C  \n",
       "19                    46        45.0           91     A  \n",
       "20                    40        31.0           71     B  \n",
       "21                    40        20.0           60     C  \n",
       "22                    34        23.0           57     F  \n",
       "23                    41        21.0           62     C  \n",
       "24                    44        33.0           77     B  \n",
       "25                    45        41.0           86     A  \n",
       "26                    41        24.0           65     C  \n",
       "27                    45        26.0           71     B  \n",
       "28                    39        18.0           57     F  \n",
       "29                    30         9.0           39     F  \n",
       "30                    40        32.0           72     B  \n",
       "31                    44        29.0           73     B  \n",
       "32                    21         8.0           29     F  \n",
       "33                    34        17.0           51     F  \n",
       "34                    44        42.0           86     A  \n",
       "35                    38        28.0           66     C  \n",
       "36                    43        27.0           70     B  \n",
       "37                    45        30.0           75     B  \n",
       "38                    22        17.0           39     F  \n",
       "39                    43        25.0           68     C  \n",
       "40                    46        35.0           81     A  \n",
       "41                    37        20.0           57     F  \n",
       "42                    44        23.0           67     C  \n",
       "43                    45        34.0           79     B  \n",
       "44                    41        22.0           63     C  \n",
       "45                    45        35.0           80     A  \n",
       "46                    43        22.0           65     C  \n",
       "47                    27        19.0           46     F  "
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv('data for panda exercise.csv')\n",
    "data\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Shahzad Ahsan\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:1: DeprecationWarning: \n",
      ".ix is deprecated. Please use\n",
      ".loc for label based indexing or\n",
      ".iloc for positional indexing\n",
      "\n",
      "See the documentation here:\n",
      "http://pandas.pydata.org/pandas-docs/stable/indexing.html#ix-indexer-is-deprecated\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Index(['Student_Code', 'Degree', 'Student_Name', 'Mid', 'Quiz_1', 'Quiz_2',\n",
       "       'Best_of_Quizzes', 'Assignment_1', 'Assignment_2',\n",
       "       'Best_of_Assignments', 'Total_Sessional_(50)', 'Final (50)',\n",
       "       'Total (100)', 'Grade'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.ix[1].index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Student_Code', 'Degree', 'Student_Name', 'Mid', 'Quiz_1', 'Quiz_2',\n",
       "       'Best_of_Quizzes', 'Assignment_1', 'Assignment_2',\n",
       "       'Best_of_Assignments', 'Total_Sessional_(50)', 'Final (50)',\n",
       "       'Total (100)', 'Grade'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>022-14-110229</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sadaquat Rafique</td>\n",
       "      <td>9</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7</td>\n",
       "      <td>22</td>\n",
       "      <td>17.0</td>\n",
       "      <td>39</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>022-14-110107</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sania Iqbal</td>\n",
       "      <td>28</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>43</td>\n",
       "      <td>25.0</td>\n",
       "      <td>68</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>022-14-110584</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sharif Taqi</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>46</td>\n",
       "      <td>35.0</td>\n",
       "      <td>81</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>022-14-110225</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Shariqa Ahmad</td>\n",
       "      <td>20</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>37</td>\n",
       "      <td>20.0</td>\n",
       "      <td>57</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>022-14-110587</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sumbul Rehman</td>\n",
       "      <td>28</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>23.0</td>\n",
       "      <td>67</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>022-14-110451</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syed Faizan Uddin</td>\n",
       "      <td>28</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8</td>\n",
       "      <td>45</td>\n",
       "      <td>34.0</td>\n",
       "      <td>79</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>022-14-110589</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syed Sohaib</td>\n",
       "      <td>25</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>41</td>\n",
       "      <td>22.0</td>\n",
       "      <td>63</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>022-14-110400</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syeda Sabika Raza</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>35.0</td>\n",
       "      <td>80</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>022-14-19911</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Usman Khan</td>\n",
       "      <td>25</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>43</td>\n",
       "      <td>22.0</td>\n",
       "      <td>65</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>022-14-110219</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Waqar Ahmed</td>\n",
       "      <td>11</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>19.0</td>\n",
       "      <td>46</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Student_Code  Degree       Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "38  022-14-110229  BS(CS)   Sadaquat Rafique    9     6.0     6.0   \n",
       "39  022-14-110107  BS(CS)        Sania Iqbal   28     4.0     4.0   \n",
       "40  022-14-110584  BS(CS)        Sharif Taqi   27     9.0     6.0   \n",
       "41  022-14-110225  BS(CS)      Shariqa Ahmad   20     7.0     6.0   \n",
       "42  022-14-110587  BS(CS)      Sumbul Rehman   28     5.0     6.0   \n",
       "43  022-14-110451  BS(CS)  Syed Faizan Uddin   28     9.0     4.0   \n",
       "44  022-14-110589  BS(CS)        Syed Sohaib   25     7.0     5.0   \n",
       "45  022-14-110400  BS(CS)  Syeda Sabika Raza   27     9.0     6.0   \n",
       "46   022-14-19911  BS(CS)         Usman Khan   25     8.0     5.0   \n",
       "47  022-14-110219  BS(CS)        Waqar Ahmed   11     9.0     5.0   \n",
       "\n",
       "    Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "38                6           5.0           7.0                    7   \n",
       "39                4           9.0          11.0                   11   \n",
       "40                9           8.0          10.0                   10   \n",
       "41                7           8.0          10.0                   10   \n",
       "42                6           8.0          10.0                   10   \n",
       "43                9           6.0           8.0                    8   \n",
       "44                7           9.0           NaN                    9   \n",
       "45                9           9.0           NaN                    9   \n",
       "46                8           8.0          10.0                   10   \n",
       "47                9           5.0           7.0                    7   \n",
       "\n",
       "    Total_Sessional_(50)  Final (50)  Total (100) Grade  \n",
       "38                    22        17.0           39     F  \n",
       "39                    43        25.0           68     C  \n",
       "40                    46        35.0           81     A  \n",
       "41                    37        20.0           57     F  \n",
       "42                    44        23.0           67     C  \n",
       "43                    45        34.0           79     B  \n",
       "44                    41        22.0           63     C  \n",
       "45                    45        35.0           80     A  \n",
       "46                    43        22.0           65     C  \n",
       "47                    27        19.0           46     F  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>022-14-110451</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syed Faizan Uddin</td>\n",
       "      <td>28</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8</td>\n",
       "      <td>45</td>\n",
       "      <td>34.0</td>\n",
       "      <td>79</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>022-14-110589</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syed Sohaib</td>\n",
       "      <td>25</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>41</td>\n",
       "      <td>22.0</td>\n",
       "      <td>63</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>022-14-110400</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syeda Sabika Raza</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>35.0</td>\n",
       "      <td>80</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>022-14-19911</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Usman Khan</td>\n",
       "      <td>25</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>43</td>\n",
       "      <td>22.0</td>\n",
       "      <td>65</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>022-14-110219</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Waqar Ahmed</td>\n",
       "      <td>11</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>19.0</td>\n",
       "      <td>46</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Student_Code  Degree       Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "43  022-14-110451  BS(CS)  Syed Faizan Uddin   28     9.0     4.0   \n",
       "44  022-14-110589  BS(CS)        Syed Sohaib   25     7.0     5.0   \n",
       "45  022-14-110400  BS(CS)  Syeda Sabika Raza   27     9.0     6.0   \n",
       "46   022-14-19911  BS(CS)         Usman Khan   25     8.0     5.0   \n",
       "47  022-14-110219  BS(CS)        Waqar Ahmed   11     9.0     5.0   \n",
       "\n",
       "    Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "43                9           6.0           8.0                    8   \n",
       "44                7           9.0           NaN                    9   \n",
       "45                9           9.0           NaN                    9   \n",
       "46                8           8.0          10.0                   10   \n",
       "47                9           5.0           7.0                    7   \n",
       "\n",
       "    Total_Sessional_(50)  Final (50)  Total (100) Grade  \n",
       "43                    45        34.0           79     B  \n",
       "44                    41        22.0           63     C  \n",
       "45                    45        35.0           80     A  \n",
       "46                    43        22.0           65     C  \n",
       "47                    27        19.0           46     F  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail()"
   ]
  },
  {
   "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>Student_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>022-14-19987</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Abdul Basit</td>\n",
       "      <td>28</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>25.0</td>\n",
       "      <td>70</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>022-14-110233</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Adeel Ahmed</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>32</td>\n",
       "      <td>18.0</td>\n",
       "      <td>50</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>022-14-110585</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Afrah Zareen</td>\n",
       "      <td>18</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>33</td>\n",
       "      <td>30.0</td>\n",
       "      <td>63</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>022-14-19718</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahmed Ali Raza</td>\n",
       "      <td>14</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>23.0</td>\n",
       "      <td>46</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>022-14-110648</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahsan Ali Vohra</td>\n",
       "      <td>27</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>43</td>\n",
       "      <td>34.0</td>\n",
       "      <td>77</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Student_Code  Degree     Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "0   022-14-19987  BS(CS)      Abdul Basit   28     8.0     3.0   \n",
       "1  022-14-110233  BS(CS)      Adeel Ahmed   17     NaN     5.0   \n",
       "2  022-14-110585  BS(CS)     Afrah Zareen   18     5.0     2.0   \n",
       "3   022-14-19718  BS(CS)   Ahmed Ali Raza   14     7.0     2.0   \n",
       "4  022-14-110648  BS(CS)  Ahsan Ali Vohra   27     7.0     6.0   \n",
       "\n",
       "   Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "0                8           7.0           9.0                    9   \n",
       "1                5           8.0          10.0                   10   \n",
       "2                5           8.0          10.0                   10   \n",
       "3                7           NaN           2.0                    2   \n",
       "4                7           7.0           9.0                    9   \n",
       "\n",
       "   Total_Sessional_(50)  Final (50)  Total (100) Grade  \n",
       "0                    45        25.0           70     B  \n",
       "1                    32        18.0           50     F  \n",
       "2                    33        30.0           63     C  \n",
       "3                    23        23.0           46     F  \n",
       "4                    43        34.0           77     B  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>19</td>\n",
       "      <td>20</td>\n",
       "      <td>21</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Student_Code  Degree  Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "Best_of_Assignments                                                            \n",
       "0                               1       1             1    1       0       0   \n",
       "2                               1       1             1    1       1       1   \n",
       "5                               1       1             1    1       1       1   \n",
       "6                               1       1             1    1       1       1   \n",
       "7                               3       3             3    3       3       3   \n",
       "8                               5       5             5    5       5       4   \n",
       "9                              10      10            10   10      10      10   \n",
       "10                             21      21            21   21      19      20   \n",
       "11                              5       5             5    5       5       5   \n",
       "\n",
       "                     Best_of_Quizzes  Assignment_1  Assignment_2  \\\n",
       "Best_of_Assignments                                                \n",
       "0                                  1             0             0   \n",
       "2                                  1             0             1   \n",
       "5                                  1             1             0   \n",
       "6                                  1             1             0   \n",
       "7                                  3             3             2   \n",
       "8                                  5             5             3   \n",
       "9                                 10            10             5   \n",
       "10                                21            20            20   \n",
       "11                                 5             5             5   \n",
       "\n",
       "                     Total_Sessional_(50)  Final (50)  Total (100)  Grade  \n",
       "Best_of_Assignments                                                        \n",
       "0                                       1           0            1      1  \n",
       "2                                       1           1            1      1  \n",
       "5                                       1           1            1      1  \n",
       "6                                       1           1            1      1  \n",
       "7                                       3           3            3      3  \n",
       "8                                       5           5            5      5  \n",
       "9                                      10          10           10     10  \n",
       "10                                     21          21           21     21  \n",
       "11                                      5           5            5      5  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby(['Best_of_Assignments']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Student_Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Abdul Basit</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adeel Ahmed</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Afrah Zareen</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahmed Ali Raza</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahsan Ali Vohra</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ameer Hamza</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anas Ali Khan</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aneebullah Niazi</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Areesha Sohail</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Arsalan</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fatima Haider Warsi</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Habib Ullah</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hafiza Tooba Akbani</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hamza Abdul Jabbar</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hareem Afshan</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Haseeb Sajid</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hassam Ahmed</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Khalid Anwer</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Madiha Jabeen</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mohammad Hunain</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Aamir</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Abdul Rehman Siddiqui</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Abdullah</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Ali Iqbal</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Bilal</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Faraz</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Ghazali Faridi</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Osama Khan</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Saqib Intizar</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Shahroz Khurshid</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Shozab</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Taha Hasnain</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Wajahat Khan</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muhammad Younus Baig</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nazeer Bin Zafar</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rabi Ahmed</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rida Nasim</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sadaf Nosheen</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sadaquat Rafique</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sania Iqbal</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sharif Taqi</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shariqa Ahmad</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sumbul Rehman</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Syed Faizan Uddin</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Syed Sohaib</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Syeda Sabika Raza</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Usman Khan</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waqar Ahmed</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                Student_Code  Degree  Mid  Quiz_1  Quiz_2  \\\n",
       "Student_Name                                                                \n",
       "Abdul Basit                                1       1    1       1       1   \n",
       "Adeel Ahmed                                1       1    1       0       1   \n",
       "Afrah Zareen                               1       1    1       1       1   \n",
       "Ahmed Ali Raza                             1       1    1       1       1   \n",
       "Ahsan Ali Vohra                            1       1    1       1       1   \n",
       "Ameer Hamza                                1       1    1       1       1   \n",
       "Anas Ali Khan                              1       1    1       1       1   \n",
       "Aneebullah Niazi                           1       1    1       1       1   \n",
       "Areesha Sohail                             1       1    1       1       1   \n",
       "Arsalan                                    1       1    1       1       1   \n",
       "Fatima Haider Warsi                        1       1    1       1       1   \n",
       "Habib Ullah                                1       1    1       1       1   \n",
       "Hafiza Tooba Akbani                        1       1    1       1       1   \n",
       "Hamza Abdul Jabbar                         1       1    1       1       1   \n",
       "Hareem Afshan                              1       1    1       1       1   \n",
       "Haseeb Sajid                               1       1    1       0       0   \n",
       "Hassam Ahmed                               1       1    1       1       1   \n",
       "Khalid Anwer                               1       1    1       1       1   \n",
       "Madiha Jabeen                              1       1    1       1       1   \n",
       "Mohammad Hunain                            1       1    1       1       1   \n",
       "Muhammad Aamir                             1       1    1       1       1   \n",
       "Muhammad Abdul Rehman Siddiqui             1       1    1       1       1   \n",
       "Muhammad Abdullah                          1       1    1       1       1   \n",
       "Muhammad Ali Iqbal                         1       1    1       1       0   \n",
       "Muhammad Bilal                             1       1    1       1       1   \n",
       "Muhammad Faraz                             1       1    1       1       1   \n",
       "Muhammad Ghazali Faridi                    1       1    1       1       0   \n",
       "Muhammad Osama Khan                        1       1    1       1       1   \n",
       "Muhammad Saqib Intizar                     1       1    1       1       1   \n",
       "Muhammad Shahroz Khurshid                  1       1    1       1       1   \n",
       "Muhammad Shozab                            1       1    1       1       1   \n",
       "Muhammad Taha Hasnain                      1       1    1       1       1   \n",
       "Muhammad Wajahat Khan                      1       1    1       0       1   \n",
       "Muhammad Younus Baig                       1       1    1       1       1   \n",
       "Nazeer Bin Zafar                           1       1    1       1       1   \n",
       "Rabi Ahmed                                 1       1    1       1       1   \n",
       "Rida Nasim                                 1       1    1       1       1   \n",
       "Sadaf Nosheen                              1       1    1       1       1   \n",
       "Sadaquat Rafique                           1       1    1       1       1   \n",
       "Sania Iqbal                                1       1    1       1       1   \n",
       "Sharif Taqi                                1       1    1       1       1   \n",
       "Shariqa Ahmad                              1       1    1       1       1   \n",
       "Sumbul Rehman                              1       1    1       1       1   \n",
       "Syed Faizan Uddin                          1       1    1       1       1   \n",
       "Syed Sohaib                                1       1    1       1       1   \n",
       "Syeda Sabika Raza                          1       1    1       1       1   \n",
       "Usman Khan                                 1       1    1       1       1   \n",
       "Waqar Ahmed                                1       1    1       1       1   \n",
       "\n",
       "                                Best_of_Quizzes  Assignment_1  Assignment_2  \\\n",
       "Student_Name                                                                  \n",
       "Abdul Basit                                   1             1             1   \n",
       "Adeel Ahmed                                   1             1             1   \n",
       "Afrah Zareen                                  1             1             1   \n",
       "Ahmed Ali Raza                                1             0             1   \n",
       "Ahsan Ali Vohra                               1             1             1   \n",
       "Ameer Hamza                                   1             1             1   \n",
       "Anas Ali Khan                                 1             1             1   \n",
       "Aneebullah Niazi                              1             1             1   \n",
       "Areesha Sohail                                1             1             1   \n",
       "Arsalan                                       1             1             0   \n",
       "Fatima Haider Warsi                           1             1             0   \n",
       "Habib Ullah                                   1             1             0   \n",
       "Hafiza Tooba Akbani                           1             1             1   \n",
       "Hamza Abdul Jabbar                            1             1             1   \n",
       "Hareem Afshan                                 1             1             1   \n",
       "Haseeb Sajid                                  1             0             0   \n",
       "Hassam Ahmed                                  1             1             1   \n",
       "Khalid Anwer                                  1             1             1   \n",
       "Madiha Jabeen                                 1             1             1   \n",
       "Mohammad Hunain                               1             1             1   \n",
       "Muhammad Aamir                                1             1             1   \n",
       "Muhammad Abdul Rehman Siddiqui                1             1             1   \n",
       "Muhammad Abdullah                             1             1             0   \n",
       "Muhammad Ali Iqbal                            1             1             1   \n",
       "Muhammad Bilal                                1             1             1   \n",
       "Muhammad Faraz                                1             1             1   \n",
       "Muhammad Ghazali Faridi                       1             1             1   \n",
       "Muhammad Osama Khan                           1             1             1   \n",
       "Muhammad Saqib Intizar                        1             1             1   \n",
       "Muhammad Shahroz Khurshid                     1             1             0   \n",
       "Muhammad Shozab                               1             1             0   \n",
       "Muhammad Taha Hasnain                         1             1             0   \n",
       "Muhammad Wajahat Khan                         1             1             1   \n",
       "Muhammad Younus Baig                          1             1             1   \n",
       "Nazeer Bin Zafar                              1             1             1   \n",
       "Rabi Ahmed                                    1             0             1   \n",
       "Rida Nasim                                    1             1             0   \n",
       "Sadaf Nosheen                                 1             1             0   \n",
       "Sadaquat Rafique                              1             1             1   \n",
       "Sania Iqbal                                   1             1             1   \n",
       "Sharif Taqi                                   1             1             1   \n",
       "Shariqa Ahmad                                 1             1             1   \n",
       "Sumbul Rehman                                 1             1             1   \n",
       "Syed Faizan Uddin                             1             1             1   \n",
       "Syed Sohaib                                   1             1             0   \n",
       "Syeda Sabika Raza                             1             1             0   \n",
       "Usman Khan                                    1             1             1   \n",
       "Waqar Ahmed                                   1             1             1   \n",
       "\n",
       "                                Best_of_Assignments  Total_Sessional_(50)  \\\n",
       "Student_Name                                                                \n",
       "Abdul Basit                                       1                     1   \n",
       "Adeel Ahmed                                       1                     1   \n",
       "Afrah Zareen                                      1                     1   \n",
       "Ahmed Ali Raza                                    1                     1   \n",
       "Ahsan Ali Vohra                                   1                     1   \n",
       "Ameer Hamza                                       1                     1   \n",
       "Anas Ali Khan                                     1                     1   \n",
       "Aneebullah Niazi                                  1                     1   \n",
       "Areesha Sohail                                    1                     1   \n",
       "Arsalan                                           1                     1   \n",
       "Fatima Haider Warsi                               1                     1   \n",
       "Habib Ullah                                       1                     1   \n",
       "Hafiza Tooba Akbani                               1                     1   \n",
       "Hamza Abdul Jabbar                                1                     1   \n",
       "Hareem Afshan                                     1                     1   \n",
       "Haseeb Sajid                                      1                     1   \n",
       "Hassam Ahmed                                      1                     1   \n",
       "Khalid Anwer                                      1                     1   \n",
       "Madiha Jabeen                                     1                     1   \n",
       "Mohammad Hunain                                   1                     1   \n",
       "Muhammad Aamir                                    1                     1   \n",
       "Muhammad Abdul Rehman Siddiqui                    1                     1   \n",
       "Muhammad Abdullah                                 1                     1   \n",
       "Muhammad Ali Iqbal                                1                     1   \n",
       "Muhammad Bilal                                    1                     1   \n",
       "Muhammad Faraz                                    1                     1   \n",
       "Muhammad Ghazali Faridi                           1                     1   \n",
       "Muhammad Osama Khan                               1                     1   \n",
       "Muhammad Saqib Intizar                            1                     1   \n",
       "Muhammad Shahroz Khurshid                         1                     1   \n",
       "Muhammad Shozab                                   1                     1   \n",
       "Muhammad Taha Hasnain                             1                     1   \n",
       "Muhammad Wajahat Khan                             1                     1   \n",
       "Muhammad Younus Baig                              1                     1   \n",
       "Nazeer Bin Zafar                                  1                     1   \n",
       "Rabi Ahmed                                        1                     1   \n",
       "Rida Nasim                                        1                     1   \n",
       "Sadaf Nosheen                                     1                     1   \n",
       "Sadaquat Rafique                                  1                     1   \n",
       "Sania Iqbal                                       1                     1   \n",
       "Sharif Taqi                                       1                     1   \n",
       "Shariqa Ahmad                                     1                     1   \n",
       "Sumbul Rehman                                     1                     1   \n",
       "Syed Faizan Uddin                                 1                     1   \n",
       "Syed Sohaib                                       1                     1   \n",
       "Syeda Sabika Raza                                 1                     1   \n",
       "Usman Khan                                        1                     1   \n",
       "Waqar Ahmed                                       1                     1   \n",
       "\n",
       "                                Final (50)  Total (100)  Grade  \n",
       "Student_Name                                                    \n",
       "Abdul Basit                              1            1      1  \n",
       "Adeel Ahmed                              1            1      1  \n",
       "Afrah Zareen                             1            1      1  \n",
       "Ahmed Ali Raza                           1            1      1  \n",
       "Ahsan Ali Vohra                          1            1      1  \n",
       "Ameer Hamza                              1            1      1  \n",
       "Anas Ali Khan                            1            1      1  \n",
       "Aneebullah Niazi                         1            1      1  \n",
       "Areesha Sohail                           1            1      1  \n",
       "Arsalan                                  1            1      1  \n",
       "Fatima Haider Warsi                      1            1      1  \n",
       "Habib Ullah                              1            1      1  \n",
       "Hafiza Tooba Akbani                      1            1      1  \n",
       "Hamza Abdul Jabbar                       1            1      1  \n",
       "Hareem Afshan                            1            1      1  \n",
       "Haseeb Sajid                             0            1      1  \n",
       "Hassam Ahmed                             1            1      1  \n",
       "Khalid Anwer                             1            1      1  \n",
       "Madiha Jabeen                            1            1      1  \n",
       "Mohammad Hunain                          1            1      1  \n",
       "Muhammad Aamir                           1            1      1  \n",
       "Muhammad Abdul Rehman Siddiqui           1            1      1  \n",
       "Muhammad Abdullah                        1            1      1  \n",
       "Muhammad Ali Iqbal                       1            1      1  \n",
       "Muhammad Bilal                           1            1      1  \n",
       "Muhammad Faraz                           1            1      1  \n",
       "Muhammad Ghazali Faridi                  1            1      1  \n",
       "Muhammad Osama Khan                      1            1      1  \n",
       "Muhammad Saqib Intizar                   1            1      1  \n",
       "Muhammad Shahroz Khurshid                1            1      1  \n",
       "Muhammad Shozab                          1            1      1  \n",
       "Muhammad Taha Hasnain                    1            1      1  \n",
       "Muhammad Wajahat Khan                    1            1      1  \n",
       "Muhammad Younus Baig                     1            1      1  \n",
       "Nazeer Bin Zafar                         1            1      1  \n",
       "Rabi Ahmed                               1            1      1  \n",
       "Rida Nasim                               1            1      1  \n",
       "Sadaf Nosheen                            1            1      1  \n",
       "Sadaquat Rafique                         1            1      1  \n",
       "Sania Iqbal                              1            1      1  \n",
       "Sharif Taqi                              1            1      1  \n",
       "Shariqa Ahmad                            1            1      1  \n",
       "Sumbul Rehman                            1            1      1  \n",
       "Syed Faizan Uddin                        1            1      1  \n",
       "Syed Sohaib                              1            1      1  \n",
       "Syeda Sabika Raza                        1            1      1  \n",
       "Usman Khan                               1            1      1  \n",
       "Waqar Ahmed                              1            1      1  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby(['Student_Name']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "8"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(data.Grade=='A')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>022-14-110388</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Aneebullah Niazi</td>\n",
       "      <td>26</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>40.0</td>\n",
       "      <td>85</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>022-14-110599</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Arsalan</td>\n",
       "      <td>28</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>44</td>\n",
       "      <td>40.0</td>\n",
       "      <td>84</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>022-14-110214</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Fatima Haider Warsi</td>\n",
       "      <td>30</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>46</td>\n",
       "      <td>45.0</td>\n",
       "      <td>91</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>022-14-110222</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Mohammad Hunain</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>46</td>\n",
       "      <td>45.0</td>\n",
       "      <td>91</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>022-14-110105</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Faraz</td>\n",
       "      <td>26</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>41.0</td>\n",
       "      <td>86</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>022-14-110413</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Nazeer Bin Zafar</td>\n",
       "      <td>25</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>42.0</td>\n",
       "      <td>86</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>022-14-110584</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sharif Taqi</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>46</td>\n",
       "      <td>35.0</td>\n",
       "      <td>81</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>022-14-110400</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syeda Sabika Raza</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>35.0</td>\n",
       "      <td>80</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Student_Code  Degree         Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "7   022-14-110388  BS(CS)     Aneebullah Niazi   26     9.0     6.0   \n",
       "9   022-14-110599  BS(CS)              Arsalan   28     8.0     6.0   \n",
       "10  022-14-110214  BS(CS)  Fatima Haider Warsi   30     8.0     7.0   \n",
       "19  022-14-110222  BS(CS)      Mohammad Hunain   27     9.0     6.0   \n",
       "25  022-14-110105  BS(CS)       Muhammad Faraz   26     9.0     6.0   \n",
       "34  022-14-110413  BS(CS)     Nazeer Bin Zafar   25     9.0     6.0   \n",
       "40  022-14-110584  BS(CS)          Sharif Taqi   27     9.0     6.0   \n",
       "45  022-14-110400  BS(CS)    Syeda Sabika Raza   27     9.0     6.0   \n",
       "\n",
       "    Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "7                 9           8.0          10.0                   10   \n",
       "9                 8           8.0           NaN                    8   \n",
       "10                8           8.0           NaN                    8   \n",
       "19                9           8.0          10.0                   10   \n",
       "25                9           8.0          10.0                   10   \n",
       "34                9           8.0          10.0                   10   \n",
       "40                9           8.0          10.0                   10   \n",
       "45                9           9.0           NaN                    9   \n",
       "\n",
       "    Total_Sessional_(50)  Final (50)  Total (100) Grade  \n",
       "7                     45        40.0           85     A  \n",
       "9                     44        40.0           84     A  \n",
       "10                    46        45.0           91     A  \n",
       "19                    46        45.0           91     A  \n",
       "25                    45        41.0           86     A  \n",
       "34                    44        42.0           86     A  \n",
       "40                    46        35.0           81     A  \n",
       "45                    45        35.0           80     A  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Grade=='A']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>022-14-19987</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Abdul Basit</td>\n",
       "      <td>28</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>25.0</td>\n",
       "      <td>70</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>022-14-110233</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Adeel Ahmed</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>32</td>\n",
       "      <td>18.0</td>\n",
       "      <td>50</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>022-14-110585</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Afrah Zareen</td>\n",
       "      <td>18</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>33</td>\n",
       "      <td>30.0</td>\n",
       "      <td>63</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>022-14-110648</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahsan Ali Vohra</td>\n",
       "      <td>27</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>43</td>\n",
       "      <td>34.0</td>\n",
       "      <td>77</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>022-14-110232</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ameer Hamza</td>\n",
       "      <td>25</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>27.0</td>\n",
       "      <td>71</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>022-14-110588</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Anas Ali Khan</td>\n",
       "      <td>28</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>30.0</td>\n",
       "      <td>74</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>022-14-110388</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Aneebullah Niazi</td>\n",
       "      <td>26</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>40.0</td>\n",
       "      <td>85</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>022-14-110601</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Areesha Sohail</td>\n",
       "      <td>19</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>37</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>022-14-110599</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Arsalan</td>\n",
       "      <td>28</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>44</td>\n",
       "      <td>40.0</td>\n",
       "      <td>84</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>022-14-110214</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Fatima Haider Warsi</td>\n",
       "      <td>30</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>46</td>\n",
       "      <td>45.0</td>\n",
       "      <td>91</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>022-15-110994</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Hafiza Tooba Akbani</td>\n",
       "      <td>23</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>40</td>\n",
       "      <td>33.0</td>\n",
       "      <td>73</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>022-14-110600</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Hamza Abdul Jabbar</td>\n",
       "      <td>24</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>42</td>\n",
       "      <td>25.0</td>\n",
       "      <td>67</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>022-14-110389</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Hareem Afshan</td>\n",
       "      <td>21</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8</td>\n",
       "      <td>36</td>\n",
       "      <td>29.0</td>\n",
       "      <td>65</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>022-14-110596</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Hassam Ahmed</td>\n",
       "      <td>23</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>37</td>\n",
       "      <td>35.0</td>\n",
       "      <td>72</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>022-14-110396</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Khalid Anwer</td>\n",
       "      <td>20</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>39</td>\n",
       "      <td>31.0</td>\n",
       "      <td>70</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>022-14-110223</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Madiha Jabeen</td>\n",
       "      <td>16</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>31</td>\n",
       "      <td>29.0</td>\n",
       "      <td>60</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>022-14-110222</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Mohammad Hunain</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>46</td>\n",
       "      <td>45.0</td>\n",
       "      <td>91</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>022-14-110412</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Aamir</td>\n",
       "      <td>24</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>40</td>\n",
       "      <td>31.0</td>\n",
       "      <td>71</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>022-14-110593</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Abdul Rehman Siddiqui</td>\n",
       "      <td>20</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>20.0</td>\n",
       "      <td>60</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>022-14-110398</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Abdullah</td>\n",
       "      <td>20</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>34</td>\n",
       "      <td>23.0</td>\n",
       "      <td>57</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>022-14-19983</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Ali Iqbal</td>\n",
       "      <td>26</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>41</td>\n",
       "      <td>21.0</td>\n",
       "      <td>62</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>022-14-110215</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Bilal</td>\n",
       "      <td>28</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>44</td>\n",
       "      <td>33.0</td>\n",
       "      <td>77</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>022-14-110105</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Faraz</td>\n",
       "      <td>26</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>41.0</td>\n",
       "      <td>86</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>022-14-110370</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Ghazali Faridi</td>\n",
       "      <td>27</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8</td>\n",
       "      <td>41</td>\n",
       "      <td>24.0</td>\n",
       "      <td>65</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>022-14-110452</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Osama Khan</td>\n",
       "      <td>27</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>26.0</td>\n",
       "      <td>71</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>022-14-110387</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Saqib Intizar</td>\n",
       "      <td>22</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>39</td>\n",
       "      <td>18.0</td>\n",
       "      <td>57</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>022-14-110217</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Shahroz Khurshid</td>\n",
       "      <td>17</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>9.0</td>\n",
       "      <td>39</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>022-14-110401</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Shozab</td>\n",
       "      <td>23</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>40</td>\n",
       "      <td>32.0</td>\n",
       "      <td>72</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>022-14-110231</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Taha Hasnain</td>\n",
       "      <td>27</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>29.0</td>\n",
       "      <td>73</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>022-14-110035</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Wajahat Khan</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>21</td>\n",
       "      <td>8.0</td>\n",
       "      <td>29</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>022-14-19919</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Younus Baig</td>\n",
       "      <td>20</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>34</td>\n",
       "      <td>17.0</td>\n",
       "      <td>51</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>022-14-110413</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Nazeer Bin Zafar</td>\n",
       "      <td>25</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>42.0</td>\n",
       "      <td>86</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>022-14-19923</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Rabi Ahmed</td>\n",
       "      <td>20</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>38</td>\n",
       "      <td>28.0</td>\n",
       "      <td>66</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>022-14-110582</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Rida Nasim</td>\n",
       "      <td>25</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>43</td>\n",
       "      <td>27.0</td>\n",
       "      <td>70</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>022-14-110230</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sadaf Nosheen</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>30.0</td>\n",
       "      <td>75</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>022-14-110229</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sadaquat Rafique</td>\n",
       "      <td>9</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7</td>\n",
       "      <td>22</td>\n",
       "      <td>17.0</td>\n",
       "      <td>39</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>022-14-110107</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sania Iqbal</td>\n",
       "      <td>28</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>43</td>\n",
       "      <td>25.0</td>\n",
       "      <td>68</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>022-14-110584</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sharif Taqi</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>46</td>\n",
       "      <td>35.0</td>\n",
       "      <td>81</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>022-14-110225</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Shariqa Ahmad</td>\n",
       "      <td>20</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>37</td>\n",
       "      <td>20.0</td>\n",
       "      <td>57</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>022-14-110587</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sumbul Rehman</td>\n",
       "      <td>28</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>23.0</td>\n",
       "      <td>67</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>022-14-110451</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syed Faizan Uddin</td>\n",
       "      <td>28</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8</td>\n",
       "      <td>45</td>\n",
       "      <td>34.0</td>\n",
       "      <td>79</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>022-14-110589</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syed Sohaib</td>\n",
       "      <td>25</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>41</td>\n",
       "      <td>22.0</td>\n",
       "      <td>63</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>022-14-110400</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syeda Sabika Raza</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>35.0</td>\n",
       "      <td>80</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>022-14-19911</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Usman Khan</td>\n",
       "      <td>25</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>43</td>\n",
       "      <td>22.0</td>\n",
       "      <td>65</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>022-14-110219</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Waqar Ahmed</td>\n",
       "      <td>11</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>19.0</td>\n",
       "      <td>46</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Student_Code  Degree                    Student_Name  Mid  Quiz_1  \\\n",
       "0    022-14-19987  BS(CS)                     Abdul Basit   28     8.0   \n",
       "1   022-14-110233  BS(CS)                     Adeel Ahmed   17     NaN   \n",
       "2   022-14-110585  BS(CS)                    Afrah Zareen   18     5.0   \n",
       "4   022-14-110648  BS(CS)                 Ahsan Ali Vohra   27     7.0   \n",
       "5   022-14-110232  BS(CS)                     Ameer Hamza   25     9.0   \n",
       "6   022-14-110588  BS(CS)                   Anas Ali Khan   28     5.0   \n",
       "7   022-14-110388  BS(CS)                Aneebullah Niazi   26     9.0   \n",
       "8   022-14-110601  BS(CS)                  Areesha Sohail   19     9.0   \n",
       "9   022-14-110599  BS(CS)                         Arsalan   28     8.0   \n",
       "10  022-14-110214  BS(CS)             Fatima Haider Warsi   30     8.0   \n",
       "12  022-15-110994  BS(CS)             Hafiza Tooba Akbani   23     7.0   \n",
       "13  022-14-110600  BS(CS)              Hamza Abdul Jabbar   24     8.0   \n",
       "14  022-14-110389  BS(CS)                   Hareem Afshan   21     7.0   \n",
       "16  022-14-110596  BS(CS)                    Hassam Ahmed   23     5.0   \n",
       "17  022-14-110396  BS(CS)                    Khalid Anwer   20     8.0   \n",
       "18  022-14-110223  BS(CS)                   Madiha Jabeen   16     5.0   \n",
       "19  022-14-110222  BS(CS)                 Mohammad Hunain   27     9.0   \n",
       "20  022-14-110412  BS(CS)                  Muhammad Aamir   24     7.0   \n",
       "21  022-14-110593  BS(CS)  Muhammad Abdul Rehman Siddiqui   20     9.0   \n",
       "22  022-14-110398  BS(CS)               Muhammad Abdullah   20     7.0   \n",
       "23   022-14-19983  BS(CS)              Muhammad Ali Iqbal   26     5.0   \n",
       "24  022-14-110215  BS(CS)                  Muhammad Bilal   28     5.0   \n",
       "25  022-14-110105  BS(CS)                  Muhammad Faraz   26     9.0   \n",
       "26  022-14-110370  BS(CS)         Muhammad Ghazali Faridi   27     6.0   \n",
       "27  022-14-110452  BS(CS)             Muhammad Osama Khan   27     8.0   \n",
       "28  022-14-110387  BS(CS)          Muhammad Saqib Intizar   22     6.0   \n",
       "29  022-14-110217  BS(CS)       Muhammad Shahroz Khurshid   17     7.0   \n",
       "30  022-14-110401  BS(CS)                 Muhammad Shozab   23     8.0   \n",
       "31  022-14-110231  BS(CS)           Muhammad Taha Hasnain   27     7.0   \n",
       "32  022-14-110035  BS(CS)           Muhammad Wajahat Khan    9     NaN   \n",
       "33   022-14-19919  BS(CS)            Muhammad Younus Baig   20     4.0   \n",
       "34  022-14-110413  BS(CS)                Nazeer Bin Zafar   25     9.0   \n",
       "35   022-14-19923  BS(CS)                      Rabi Ahmed   20     8.0   \n",
       "36  022-14-110582  BS(CS)                      Rida Nasim   25     9.0   \n",
       "37  022-14-110230  BS(CS)                   Sadaf Nosheen   27     9.0   \n",
       "38  022-14-110229  BS(CS)                Sadaquat Rafique    9     6.0   \n",
       "39  022-14-110107  BS(CS)                     Sania Iqbal   28     4.0   \n",
       "40  022-14-110584  BS(CS)                     Sharif Taqi   27     9.0   \n",
       "41  022-14-110225  BS(CS)                   Shariqa Ahmad   20     7.0   \n",
       "42  022-14-110587  BS(CS)                   Sumbul Rehman   28     5.0   \n",
       "43  022-14-110451  BS(CS)               Syed Faizan Uddin   28     9.0   \n",
       "44  022-14-110589  BS(CS)                     Syed Sohaib   25     7.0   \n",
       "45  022-14-110400  BS(CS)               Syeda Sabika Raza   27     9.0   \n",
       "46   022-14-19911  BS(CS)                      Usman Khan   25     8.0   \n",
       "47  022-14-110219  BS(CS)                     Waqar Ahmed   11     9.0   \n",
       "\n",
       "    Quiz_2  Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "0      3.0                8           7.0           9.0                    9   \n",
       "1      5.0                5           8.0          10.0                   10   \n",
       "2      2.0                5           8.0          10.0                   10   \n",
       "4      6.0                7           7.0           9.0                    9   \n",
       "5      6.0                9           8.0          10.0                   10   \n",
       "6      6.0                6           8.0          10.0                   10   \n",
       "7      6.0                9           8.0          10.0                   10   \n",
       "8      4.0                9           7.0           9.0                    9   \n",
       "9      6.0                8           8.0           NaN                    8   \n",
       "10     7.0                8           8.0           NaN                    8   \n",
       "12     5.0                7           8.0          10.0                   10   \n",
       "13     4.0                8           8.0          10.0                   10   \n",
       "14     4.0                7           6.0           8.0                    8   \n",
       "16     5.0                5           7.0           9.0                    9   \n",
       "17     5.0                8           9.0          11.0                   11   \n",
       "18     2.0                5           8.0          10.0                   10   \n",
       "19     6.0                9           8.0          10.0                   10   \n",
       "20     6.0                7           7.0           9.0                    9   \n",
       "21     6.0                9           9.0          11.0                   11   \n",
       "22     6.0                7           7.0           NaN                    7   \n",
       "23     NaN                5           8.0          10.0                   10   \n",
       "24     4.0                5           9.0          11.0                   11   \n",
       "25     6.0                9           8.0          10.0                   10   \n",
       "26     NaN                6           6.0           8.0                    8   \n",
       "27     6.0                8           8.0          10.0                   10   \n",
       "28     6.0                6           9.0          11.0                   11   \n",
       "29     1.0                7           6.0           NaN                    6   \n",
       "30     6.0                8           9.0           NaN                    9   \n",
       "31     5.0                7          10.0           NaN                   10   \n",
       "32     2.0                2           8.0          10.0                   10   \n",
       "33     2.0                4           8.0          10.0                   10   \n",
       "34     6.0                9           8.0          10.0                   10   \n",
       "35     5.0                8           NaN          10.0                   10   \n",
       "36     5.0                9           9.0           NaN                    9   \n",
       "37     5.0                9           9.0           NaN                    9   \n",
       "38     6.0                6           5.0           7.0                    7   \n",
       "39     4.0                4           9.0          11.0                   11   \n",
       "40     6.0                9           8.0          10.0                   10   \n",
       "41     6.0                7           8.0          10.0                   10   \n",
       "42     6.0                6           8.0          10.0                   10   \n",
       "43     4.0                9           6.0           8.0                    8   \n",
       "44     5.0                7           9.0           NaN                    9   \n",
       "45     6.0                9           9.0           NaN                    9   \n",
       "46     5.0                8           8.0          10.0                   10   \n",
       "47     5.0                9           5.0           7.0                    7   \n",
       "\n",
       "    Total_Sessional_(50)  Final (50)  Total (100) Grade  \n",
       "0                     45        25.0           70     B  \n",
       "1                     32        18.0           50     F  \n",
       "2                     33        30.0           63     C  \n",
       "4                     43        34.0           77     B  \n",
       "5                     44        27.0           71     B  \n",
       "6                     44        30.0           74     B  \n",
       "7                     45        40.0           85     A  \n",
       "8                     37        24.0           61     C  \n",
       "9                     44        40.0           84     A  \n",
       "10                    46        45.0           91     A  \n",
       "12                    40        33.0           73     B  \n",
       "13                    42        25.0           67     C  \n",
       "14                    36        29.0           65     C  \n",
       "16                    37        35.0           72     B  \n",
       "17                    39        31.0           70     B  \n",
       "18                    31        29.0           60     C  \n",
       "19                    46        45.0           91     A  \n",
       "20                    40        31.0           71     B  \n",
       "21                    40        20.0           60     C  \n",
       "22                    34        23.0           57     F  \n",
       "23                    41        21.0           62     C  \n",
       "24                    44        33.0           77     B  \n",
       "25                    45        41.0           86     A  \n",
       "26                    41        24.0           65     C  \n",
       "27                    45        26.0           71     B  \n",
       "28                    39        18.0           57     F  \n",
       "29                    30         9.0           39     F  \n",
       "30                    40        32.0           72     B  \n",
       "31                    44        29.0           73     B  \n",
       "32                    21         8.0           29     F  \n",
       "33                    34        17.0           51     F  \n",
       "34                    44        42.0           86     A  \n",
       "35                    38        28.0           66     C  \n",
       "36                    43        27.0           70     B  \n",
       "37                    45        30.0           75     B  \n",
       "38                    22        17.0           39     F  \n",
       "39                    43        25.0           68     C  \n",
       "40                    46        35.0           81     A  \n",
       "41                    37        20.0           57     F  \n",
       "42                    44        23.0           67     C  \n",
       "43                    45        34.0           79     B  \n",
       "44                    41        22.0           63     C  \n",
       "45                    45        35.0           80     A  \n",
       "46                    43        22.0           65     C  \n",
       "47                    27        19.0           46     F  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Best_of_Assignments>5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>022-14-110233</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Adeel Ahmed</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>32</td>\n",
       "      <td>18.0</td>\n",
       "      <td>50</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>022-14-110585</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Afrah Zareen</td>\n",
       "      <td>18</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>33</td>\n",
       "      <td>30.0</td>\n",
       "      <td>63</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>022-14-19718</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahmed Ali Raza</td>\n",
       "      <td>14</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>23.0</td>\n",
       "      <td>46</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>022-14-110601</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Areesha Sohail</td>\n",
       "      <td>19</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>37</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>022-14-19916</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Haseeb Sajid</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>022-14-110223</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Madiha Jabeen</td>\n",
       "      <td>16</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>31</td>\n",
       "      <td>29.0</td>\n",
       "      <td>60</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>022-14-110217</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Shahroz Khurshid</td>\n",
       "      <td>17</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>9.0</td>\n",
       "      <td>39</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>022-14-110035</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Wajahat Khan</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>21</td>\n",
       "      <td>8.0</td>\n",
       "      <td>29</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>022-14-110229</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sadaquat Rafique</td>\n",
       "      <td>9</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7</td>\n",
       "      <td>22</td>\n",
       "      <td>17.0</td>\n",
       "      <td>39</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>022-14-110219</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Waqar Ahmed</td>\n",
       "      <td>11</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>19.0</td>\n",
       "      <td>46</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Student_Code  Degree               Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "1   022-14-110233  BS(CS)                Adeel Ahmed   17     NaN     5.0   \n",
       "2   022-14-110585  BS(CS)               Afrah Zareen   18     5.0     2.0   \n",
       "3    022-14-19718  BS(CS)             Ahmed Ali Raza   14     7.0     2.0   \n",
       "8   022-14-110601  BS(CS)             Areesha Sohail   19     9.0     4.0   \n",
       "15   022-14-19916  BS(CS)               Haseeb Sajid   18     NaN     NaN   \n",
       "18  022-14-110223  BS(CS)              Madiha Jabeen   16     5.0     2.0   \n",
       "29  022-14-110217  BS(CS)  Muhammad Shahroz Khurshid   17     7.0     1.0   \n",
       "32  022-14-110035  BS(CS)      Muhammad Wajahat Khan    9     NaN     2.0   \n",
       "38  022-14-110229  BS(CS)           Sadaquat Rafique    9     6.0     6.0   \n",
       "47  022-14-110219  BS(CS)                Waqar Ahmed   11     9.0     5.0   \n",
       "\n",
       "    Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "1                 5           8.0          10.0                   10   \n",
       "2                 5           8.0          10.0                   10   \n",
       "3                 7           NaN           2.0                    2   \n",
       "8                 9           7.0           9.0                    9   \n",
       "15                0           NaN           NaN                    0   \n",
       "18                5           8.0          10.0                   10   \n",
       "29                7           6.0           NaN                    6   \n",
       "32                2           8.0          10.0                   10   \n",
       "38                6           5.0           7.0                    7   \n",
       "47                9           5.0           7.0                    7   \n",
       "\n",
       "    Total_Sessional_(50)  Final (50)  Total (100) Grade  \n",
       "1                     32        18.0           50     F  \n",
       "2                     33        30.0           63     C  \n",
       "3                     23        23.0           46     F  \n",
       "8                     37        24.0           61     C  \n",
       "15                    18         NaN           18     F  \n",
       "18                    31        29.0           60     C  \n",
       "29                    30         9.0           39     F  \n",
       "32                    21         8.0           29     F  \n",
       "38                    22        17.0           39     F  \n",
       "47                    27        19.0           46     F  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Mid<20]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Student_Code            9\n",
       "Degree                  9\n",
       "Student_Name            9\n",
       "Mid                     9\n",
       "Quiz_1                  9\n",
       "Quiz_2                  9\n",
       "Best_of_Quizzes         9\n",
       "Assignment_1            9\n",
       "Assignment_2            6\n",
       "Best_of_Assignments     9\n",
       "Total_Sessional_(50)    9\n",
       "Final (50)              9\n",
       "Total (100)             9\n",
       "Grade                   9\n",
       "dtype: int64"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Mid>27].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Student_Code            022-14-110232\n",
       "Degree                         BS(CS)\n",
       "Student_Name              Ameer Hamza\n",
       "Mid                                25\n",
       "Quiz_1                              9\n",
       "Quiz_2                              6\n",
       "Best_of_Quizzes                     9\n",
       "Assignment_1                        8\n",
       "Assignment_2                       10\n",
       "Best_of_Assignments                10\n",
       "Total_Sessional_(50)               44\n",
       "Final (50)                         27\n",
       "Total (100)                        71\n",
       "Grade                               B\n",
       "Name: 5, dtype: object"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.iloc[5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Student_Code            022-14-110588\n",
       "Degree                         BS(CS)\n",
       "Student_Name            Anas Ali Khan\n",
       "Mid                                28\n",
       "Quiz_1                              5\n",
       "Quiz_2                              6\n",
       "Best_of_Quizzes                     6\n",
       "Assignment_1                        8\n",
       "Assignment_2                       10\n",
       "Best_of_Assignments                10\n",
       "Total_Sessional_(50)               44\n",
       "Final (50)                         30\n",
       "Total (100)                        74\n",
       "Grade                               B\n",
       "Name: 6, dtype: object"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.loc[6]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>022-14-110223</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Madiha Jabeen</td>\n",
       "      <td>16</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>31</td>\n",
       "      <td>29.0</td>\n",
       "      <td>60</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Student_Code  Degree   Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "18  022-14-110223  BS(CS)  Madiha Jabeen   16     5.0     2.0   \n",
       "\n",
       "    Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "18                5           8.0          10.0                   10   \n",
       "\n",
       "    Total_Sessional_(50)  Final (50)  Total (100) Grade  \n",
       "18                    31        29.0           60     C  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Student_Name == 'Madiha Jabeen']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3     2.0\n",
       "4     9.0\n",
       "5    10.0\n",
       "6    10.0\n",
       "7    10.0\n",
       "Name: Assignment_2, dtype: float64"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.Assignment_2[3:8]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1     5\n",
       "3     7\n",
       "5     9\n",
       "7     9\n",
       "8     9\n",
       "10    8\n",
       "14    7\n",
       "Name: Best_of_Quizzes, dtype: int64"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.iloc[[1, 3, 5 , 7 , 8 , 10 , 14]].Best_of_Quizzes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2    10.0\n",
       "4     9.0\n",
       "5    10.0\n",
       "6    10.0\n",
       "7    10.0\n",
       "8     9.0\n",
       "9     NaN\n",
       "0     9.0\n",
       "3     2.0\n",
       "1    10.0\n",
       "Name: Assignment_2, dtype: float64"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.iloc[[2,4,5,6,7,8,9,0,3,1]].Assignment_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>022-14-19987</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Abdul Basit</td>\n",
       "      <td>28</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>25.0</td>\n",
       "      <td>70</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>022-14-110233</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Adeel Ahmed</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>32</td>\n",
       "      <td>18.0</td>\n",
       "      <td>50</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>022-14-110585</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Afrah Zareen</td>\n",
       "      <td>18</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>33</td>\n",
       "      <td>30.0</td>\n",
       "      <td>63</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>022-14-19718</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahmed Ali Raza</td>\n",
       "      <td>14</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>23.0</td>\n",
       "      <td>46</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>022-14-110648</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahsan Ali Vohra</td>\n",
       "      <td>27</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>43</td>\n",
       "      <td>34.0</td>\n",
       "      <td>77</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Student_Code  Degree     Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "0   022-14-19987  BS(CS)      Abdul Basit   28     8.0     3.0   \n",
       "1  022-14-110233  BS(CS)      Adeel Ahmed   17     NaN     5.0   \n",
       "2  022-14-110585  BS(CS)     Afrah Zareen   18     5.0     2.0   \n",
       "3   022-14-19718  BS(CS)   Ahmed Ali Raza   14     7.0     2.0   \n",
       "4  022-14-110648  BS(CS)  Ahsan Ali Vohra   27     7.0     6.0   \n",
       "\n",
       "   Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "0                8           7.0           9.0                    9   \n",
       "1                5           8.0          10.0                   10   \n",
       "2                5           8.0          10.0                   10   \n",
       "3                7           NaN           2.0                    2   \n",
       "4                7           7.0           9.0                    9   \n",
       "\n",
       "   Total_Sessional_(50)  Final (50)  Total (100) Grade  \n",
       "0                    45        25.0           70     B  \n",
       "1                    32        18.0           50     F  \n",
       "2                    33        30.0           63     C  \n",
       "3                    23        23.0           46     F  \n",
       "4                    43        34.0           77     B  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data1 = data.loc[:, \"Student_Code\":\"Grade\"]\n",
    "data1.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(48, 14)\n"
     ]
    }
   ],
   "source": [
    "print(data.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>022-14-19987</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Abdul Basit</td>\n",
       "      <td>28</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>25.0</td>\n",
       "      <td>70</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>022-14-110233</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Adeel Ahmed</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>32</td>\n",
       "      <td>18.0</td>\n",
       "      <td>50</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>022-14-110585</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Afrah Zareen</td>\n",
       "      <td>18</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>33</td>\n",
       "      <td>30.0</td>\n",
       "      <td>63</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>022-14-19718</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahmed Ali Raza</td>\n",
       "      <td>14</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>23.0</td>\n",
       "      <td>46</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>022-14-110648</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahsan Ali Vohra</td>\n",
       "      <td>27</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9</td>\n",
       "      <td>43</td>\n",
       "      <td>34.0</td>\n",
       "      <td>77</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Student_Code  Degree     Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "0   022-14-19987  BS(CS)      Abdul Basit   28     8.0     3.0   \n",
       "1  022-14-110233  BS(CS)      Adeel Ahmed   17     NaN     5.0   \n",
       "2  022-14-110585  BS(CS)     Afrah Zareen   18     5.0     2.0   \n",
       "3   022-14-19718  BS(CS)   Ahmed Ali Raza   14     7.0     2.0   \n",
       "4  022-14-110648  BS(CS)  Ahsan Ali Vohra   27     7.0     6.0   \n",
       "\n",
       "   Best_of_Quizzes  Assignment_2  Best_of_Assignments  Total_Sessional_(50)  \\\n",
       "0                8           9.0                    9                    45   \n",
       "1                5          10.0                   10                    32   \n",
       "2                5          10.0                   10                    33   \n",
       "3                7           2.0                    2                    23   \n",
       "4                7           9.0                    9                    43   \n",
       "\n",
       "   Final (50)  Total (100) Grade  \n",
       "0        25.0           70     B  \n",
       "1        18.0           50     F  \n",
       "2        30.0           63     C  \n",
       "3        23.0           46     F  \n",
       "4        34.0           77     B  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "del data['Assignment_1']\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>022-14-19718</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahmed Ali Raza</td>\n",
       "      <td>14.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>022-14-110648</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahsan Ali Vohra</td>\n",
       "      <td>27.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Student_Code  Degree     Student_Name   Mid  Quiz_1  Quiz_2  \\\n",
       "0            NaN     NaN              NaN   NaN     NaN     NaN   \n",
       "1            NaN     NaN              NaN   NaN     NaN     NaN   \n",
       "2            NaN     NaN              NaN   NaN     NaN     NaN   \n",
       "3   022-14-19718  BS(CS)   Ahmed Ali Raza  14.0     7.0     2.0   \n",
       "4  022-14-110648  BS(CS)  Ahsan Ali Vohra  27.0     7.0     6.0   \n",
       "\n",
       "   Best_of_Quizzes  Assignment_2  Best_of_Assignments  Total_Sessional_(50)  \\\n",
       "0              NaN           NaN                  NaN                   NaN   \n",
       "1              NaN           NaN                  NaN                   NaN   \n",
       "2              NaN           NaN                  NaN                   NaN   \n",
       "3              7.0           2.0                  2.0                  23.0   \n",
       "4              7.0           9.0                  9.0                  43.0   \n",
       "\n",
       "   Final (50)  Total (100) Grade  \n",
       "0         NaN          NaN   NaN  \n",
       "1         NaN          NaN   NaN  \n",
       "2         NaN          NaN   NaN  \n",
       "3        23.0         46.0     F  \n",
       "4        34.0         77.0     B  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.iloc[0:3 ,:] = np.nan\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Student_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>022-14-19718</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahmed Ali Raza</td>\n",
       "      <td>14.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>022-14-110648</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahsan Ali Vohra</td>\n",
       "      <td>27.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>022-14-110232</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ameer Hamza</td>\n",
       "      <td>25.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>022-14-110588</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Anas Ali Khan</td>\n",
       "      <td>28.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>022-14-110388</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Aneebullah Niazi</td>\n",
       "      <td>26.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Student_Code  Degree      Student_Name   Mid  Quiz_1  Quiz_2  \\\n",
       "3   022-14-19718  BS(CS)    Ahmed Ali Raza  14.0     7.0     2.0   \n",
       "4  022-14-110648  BS(CS)   Ahsan Ali Vohra  27.0     7.0     6.0   \n",
       "5  022-14-110232  BS(CS)       Ameer Hamza  25.0     9.0     6.0   \n",
       "6  022-14-110588  BS(CS)     Anas Ali Khan  28.0     5.0     6.0   \n",
       "7  022-14-110388  BS(CS)  Aneebullah Niazi  26.0     9.0     6.0   \n",
       "\n",
       "   Best_of_Quizzes  Assignment_2  Best_of_Assignments  Total_Sessional_(50)  \\\n",
       "3              7.0           2.0                  2.0                  23.0   \n",
       "4              7.0           9.0                  9.0                  43.0   \n",
       "5              9.0          10.0                 10.0                  44.0   \n",
       "6              6.0          10.0                 10.0                  44.0   \n",
       "7              9.0          10.0                 10.0                  45.0   \n",
       "\n",
       "   Final (50)  Total (100) Grade  \n",
       "3        23.0         46.0     F  \n",
       "4        34.0         77.0     B  \n",
       "5        27.0         71.0     B  \n",
       "6        30.0         74.0     B  \n",
       "7        40.0         85.0     A  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = data.dropna(how='any')\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(30, 13)"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>022-14-110388</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Aneebullah Niazi</td>\n",
       "      <td>26</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>40.0</td>\n",
       "      <td>85</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>022-14-110599</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Arsalan</td>\n",
       "      <td>28</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>44</td>\n",
       "      <td>40.0</td>\n",
       "      <td>84</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Student_Code  Degree      Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "7  022-14-110388  BS(CS)  Aneebullah Niazi   26     9.0     6.0   \n",
       "9  022-14-110599  BS(CS)           Arsalan   28     8.0     6.0   \n",
       "\n",
       "   Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "7                9           8.0          10.0                   10   \n",
       "9                8           8.0           NaN                    8   \n",
       "\n",
       "   Total_Sessional_(50)  Final (50)  Total (100) Grade  \n",
       "7                    45        40.0           85     A  \n",
       "9                    44        40.0           84     A  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data.Student_Name.str.startswith('A')) & (data['Grade'] == 'A')] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Student_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Grade</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>11</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>F</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Student_Code  Degree  Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "Grade                                                            \n",
       "A                 8       8             8    8       8       8   \n",
       "B                16      16            16   16      16      16   \n",
       "C                13      13            13   13      13      11   \n",
       "F                11      11            11   11       8      10   \n",
       "\n",
       "       Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "Grade                                                                     \n",
       "A                    8             8             5                    8   \n",
       "B                   16            16            11                   16   \n",
       "C                   13            12            12                   13   \n",
       "F                   11             9             8                   11   \n",
       "\n",
       "       Total_Sessional_(50)  Final (50)  Total (100)  \n",
       "Grade                                                 \n",
       "A                         8           8            8  \n",
       "B                        16          16           16  \n",
       "C                        13          13           13  \n",
       "F                        11          10           11  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby('Grade').count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Aneebullah Niazi</td>\n",
       "      <td>26.0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Mohammad Hunain</td>\n",
       "      <td>27.0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Muhammad Faraz</td>\n",
       "      <td>26.0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Nazeer Bin Zafar</td>\n",
       "      <td>25.0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Sharif Taqi</td>\n",
       "      <td>27.0</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Student_Name   Mid Grade\n",
       "7   Aneebullah Niazi  26.0     A\n",
       "19   Mohammad Hunain  27.0     A\n",
       "25    Muhammad Faraz  26.0     A\n",
       "34  Nazeer Bin Zafar  25.0     A\n",
       "40       Sharif Taqi  27.0     A"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[['Student_Name','Mid', 'Grade']][(data.Grade == 'A')]"
   ]
  },
  {
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_1</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>022-14-110388</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Aneebullah Niazi</td>\n",
       "      <td>26</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>40.0</td>\n",
       "      <td>85</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>022-14-110222</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Mohammad Hunain</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>46</td>\n",
       "      <td>45.0</td>\n",
       "      <td>91</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>022-14-110105</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Muhammad Faraz</td>\n",
       "      <td>26</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>41.0</td>\n",
       "      <td>86</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>022-14-110413</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Nazeer Bin Zafar</td>\n",
       "      <td>25</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>42.0</td>\n",
       "      <td>86</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>022-14-110584</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Sharif Taqi</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>46</td>\n",
       "      <td>35.0</td>\n",
       "      <td>81</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>022-14-110400</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Syeda Sabika Raza</td>\n",
       "      <td>27</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>45</td>\n",
       "      <td>35.0</td>\n",
       "      <td>80</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Student_Code  Degree       Student_Name  Mid  Quiz_1  Quiz_2  \\\n",
       "7   022-14-110388  BS(CS)   Aneebullah Niazi   26     9.0     6.0   \n",
       "19  022-14-110222  BS(CS)    Mohammad Hunain   27     9.0     6.0   \n",
       "25  022-14-110105  BS(CS)     Muhammad Faraz   26     9.0     6.0   \n",
       "34  022-14-110413  BS(CS)   Nazeer Bin Zafar   25     9.0     6.0   \n",
       "40  022-14-110584  BS(CS)        Sharif Taqi   27     9.0     6.0   \n",
       "45  022-14-110400  BS(CS)  Syeda Sabika Raza   27     9.0     6.0   \n",
       "\n",
       "    Best_of_Quizzes  Assignment_1  Assignment_2  Best_of_Assignments  \\\n",
       "7                 9           8.0          10.0                   10   \n",
       "19                9           8.0          10.0                   10   \n",
       "25                9           8.0          10.0                   10   \n",
       "34                9           8.0          10.0                   10   \n",
       "40                9           8.0          10.0                   10   \n",
       "45                9           9.0           NaN                    9   \n",
       "\n",
       "    Total_Sessional_(50)  Final (50)  Total (100) Grade  \n",
       "7                     45        40.0           85     A  \n",
       "19                    46        45.0           91     A  \n",
       "25                    45        41.0           86     A  \n",
       "34                    44        42.0           86     A  \n",
       "40                    46        35.0           81     A  \n",
       "45                    45        35.0           80     A  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data.Best_of_Quizzes == 9) & (data.Grade == 'A')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>022-14-19718</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahmed Ali Raza</td>\n",
       "      <td>14.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>022-14-110648</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ahsan Ali Vohra</td>\n",
       "      <td>27.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>022-14-110588</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Anas Ali Khan</td>\n",
       "      <td>28.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Student_Code  Degree     Student_Name   Mid  Quiz_1  Quiz_2  \\\n",
       "3   022-14-19718  BS(CS)   Ahmed Ali Raza  14.0     7.0     2.0   \n",
       "4  022-14-110648  BS(CS)  Ahsan Ali Vohra  27.0     7.0     6.0   \n",
       "6  022-14-110588  BS(CS)    Anas Ali Khan  28.0     5.0     6.0   \n",
       "\n",
       "   Best_of_Quizzes  Assignment_2  Best_of_Assignments  Total_Sessional_(50)  \\\n",
       "3              7.0           2.0                  2.0                  23.0   \n",
       "4              7.0           9.0                  9.0                  43.0   \n",
       "6              6.0          10.0                 10.0                  44.0   \n",
       "\n",
       "   Final (50)  Total (100) Grade  \n",
       "3        23.0         46.0     F  \n",
       "4        34.0         77.0     B  \n",
       "6        30.0         74.0     B  "
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Student_Name.str.contains(' Ali ')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "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_Code</th>\n",
       "      <th>Degree</th>\n",
       "      <th>Student_Name</th>\n",
       "      <th>Mid</th>\n",
       "      <th>Quiz_1</th>\n",
       "      <th>Quiz_2</th>\n",
       "      <th>Best_of_Quizzes</th>\n",
       "      <th>Assignment_2</th>\n",
       "      <th>Best_of_Assignments</th>\n",
       "      <th>Total_Sessional_(50)</th>\n",
       "      <th>Final (50)</th>\n",
       "      <th>Total (100)</th>\n",
       "      <th>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>022-14-110232</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Ameer Hamza</td>\n",
       "      <td>25.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Student_Code  Degree Student_Name   Mid  Quiz_1  Quiz_2  Best_of_Quizzes  \\\n",
       "5  022-14-110232  BS(CS)  Ameer Hamza  25.0     9.0     6.0              9.0   \n",
       "\n",
       "   Assignment_2  Best_of_Assignments  Total_Sessional_(50)  Final (50)  \\\n",
       "5          10.0                 10.0                  44.0        27.0   \n",
       "\n",
       "   Total (100) Grade  \n",
       "5         71.0     B  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Student_Name.str.endswith('Hamza')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "persons = pd.DataFrame({\n",
    "    'name': ['Shahzad' , 'Taha' , 'Fatima' , 'Khani' , 'Samia'],\n",
    "    'age': np.random.randint(1,40, size = [5]),\n",
    "    'percent': np.random.randint(40,90, size = [5])\n",
    "    \n",
    "})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>age</th>\n",
       "      <th>percent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Shahzad</td>\n",
       "      <td>29</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Taha</td>\n",
       "      <td>10</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fatima</td>\n",
       "      <td>12</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Khani</td>\n",
       "      <td>36</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Samia</td>\n",
       "      <td>31</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      name  age  percent\n",
       "0  Shahzad   29       46\n",
       "1     Taha   10       87\n",
       "2   Fatima   12       67\n",
       "3    Khani   36       56\n",
       "4    Samia   31       46"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "persons"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "def a(age):\n",
    "    if age < 18:\n",
    "        return 'Non-Adult'\n",
    "    else:\n",
    "        return 'Adult'\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "persons['Status'] = persons['age'].map(a) #We can use 'apply' also"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>age</th>\n",
       "      <th>percent</th>\n",
       "      <th>Status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Shahzad</td>\n",
       "      <td>29</td>\n",
       "      <td>46</td>\n",
       "      <td>Adult</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Taha</td>\n",
       "      <td>10</td>\n",
       "      <td>87</td>\n",
       "      <td>Non-Adult</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fatima</td>\n",
       "      <td>12</td>\n",
       "      <td>67</td>\n",
       "      <td>Non-Adult</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Khani</td>\n",
       "      <td>36</td>\n",
       "      <td>56</td>\n",
       "      <td>Adult</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Samia</td>\n",
       "      <td>31</td>\n",
       "      <td>46</td>\n",
       "      <td>Adult</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      name  age  percent     Status\n",
       "0  Shahzad   29       46      Adult\n",
       "1     Taha   10       87  Non-Adult\n",
       "2   Fatima   12       67  Non-Adult\n",
       "3    Khani   36       56      Adult\n",
       "4    Samia   31       46      Adult"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "persons"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}