pandas exercise (1).ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# Pandas Lab"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1. Create a data series with marks of students : 75, 80, 79, 60"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2. Create a data frame with name of students, id and marks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"data for panda exercise.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3. Now read the file 'data.csv' in panda"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.columns= [c.replace(\" \", \"_\") for c in df.columns ]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 4. What are the columns in the dataframe?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 5. Sort the data based on Marks obtained. Fill all the 'na' cells with 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>0.0</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>0.0</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     0.0     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           0.0           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": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.fillna(value=0, inplace=True)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 6. Display the top 10 rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "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>0.0</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>0.0</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>0.0</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",
       "0   022-14-19987  BS(CS)       Abdul Basit   28     8.0     3.0   \n",
       "1  022-14-110233  BS(CS)       Adeel Ahmed   17     0.0     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",
       "5  022-14-110232  BS(CS)       Ameer Hamza   25     9.0     6.0   \n",
       "6  022-14-110588  BS(CS)     Anas Ali Khan   28     5.0     6.0   \n",
       "7  022-14-110388  BS(CS)  Aneebullah Niazi   26     9.0     6.0   \n",
       "8  022-14-110601  BS(CS)    Areesha Sohail   19     9.0     4.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",
       "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           0.0           2.0                    2   \n",
       "4                7           7.0           9.0                    9   \n",
       "5                9           8.0          10.0                   10   \n",
       "6                6           8.0          10.0                   10   \n",
       "7                9           8.0          10.0                   10   \n",
       "8                9           7.0           9.0                    9   \n",
       "9                8           8.0           0.0                    8   \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  "
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 7. Display the last 10 rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>0.0</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>0.0</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           0.0                    9   \n",
       "45                9           9.0           0.0                    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": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 8. Display only the odd rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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>0.0</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>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>0.0</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>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>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>0.0</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>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>0.0</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>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>15</th>\n",
       "      <td>022-14-19916</td>\n",
       "      <td>BS(CS)</td>\n",
       "      <td>Haseeb Sajid</td>\n",
       "      <td>18</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18</td>\n",
       "      <td>F</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>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>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>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>0.0</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>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>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>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>0.0</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>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>0.0</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>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>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>0.0</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>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>0.0</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>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>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>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>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>0.0</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>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",
       "1   022-14-110233  BS(CS)                     Adeel Ahmed   17     0.0   \n",
       "3    022-14-19718  BS(CS)                  Ahmed Ali Raza   14     7.0   \n",
       "5   022-14-110232  BS(CS)                     Ameer Hamza   25     9.0   \n",
       "7   022-14-110388  BS(CS)                Aneebullah Niazi   26     9.0   \n",
       "9   022-14-110599  BS(CS)                         Arsalan   28     8.0   \n",
       "11  022-14-110591  BS(CS)                     Habib Ullah   28     8.0   \n",
       "13  022-14-110600  BS(CS)              Hamza Abdul Jabbar   24     8.0   \n",
       "15   022-14-19916  BS(CS)                    Haseeb Sajid   18     0.0   \n",
       "17  022-14-110396  BS(CS)                    Khalid Anwer   20     8.0   \n",
       "19  022-14-110222  BS(CS)                 Mohammad Hunain   27     9.0   \n",
       "21  022-14-110593  BS(CS)  Muhammad Abdul Rehman Siddiqui   20     9.0   \n",
       "23   022-14-19983  BS(CS)              Muhammad Ali Iqbal   26     5.0   \n",
       "25  022-14-110105  BS(CS)                  Muhammad Faraz   26     9.0   \n",
       "27  022-14-110452  BS(CS)             Muhammad Osama Khan   27     8.0   \n",
       "29  022-14-110217  BS(CS)       Muhammad Shahroz Khurshid   17     7.0   \n",
       "31  022-14-110231  BS(CS)           Muhammad Taha Hasnain   27     7.0   \n",
       "33   022-14-19919  BS(CS)            Muhammad Younus Baig   20     4.0   \n",
       "35   022-14-19923  BS(CS)                      Rabi Ahmed   20     8.0   \n",
       "37  022-14-110230  BS(CS)                   Sadaf Nosheen   27     9.0   \n",
       "39  022-14-110107  BS(CS)                     Sania Iqbal   28     4.0   \n",
       "41  022-14-110225  BS(CS)                   Shariqa Ahmad   20     7.0   \n",
       "43  022-14-110451  BS(CS)               Syed Faizan Uddin   28     9.0   \n",
       "45  022-14-110400  BS(CS)               Syeda Sabika Raza   27     9.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",
       "1      5.0                5           8.0          10.0                   10   \n",
       "3      2.0                7           0.0           2.0                    2   \n",
       "5      6.0                9           8.0          10.0                   10   \n",
       "7      6.0                9           8.0          10.0                   10   \n",
       "9      6.0                8           8.0           0.0                    8   \n",
       "11     5.0                8           5.0           0.0                    5   \n",
       "13     4.0                8           8.0          10.0                   10   \n",
       "15     0.0                0           0.0           0.0                    0   \n",
       "17     5.0                8           9.0          11.0                   11   \n",
       "19     6.0                9           8.0          10.0                   10   \n",
       "21     6.0                9           9.0          11.0                   11   \n",
       "23     0.0                5           8.0          10.0                   10   \n",
       "25     6.0                9           8.0          10.0                   10   \n",
       "27     6.0                8           8.0          10.0                   10   \n",
       "29     1.0                7           6.0           0.0                    6   \n",
       "31     5.0                7          10.0           0.0                   10   \n",
       "33     2.0                4           8.0          10.0                   10   \n",
       "35     5.0                8           0.0          10.0                   10   \n",
       "37     5.0                9           9.0           0.0                    9   \n",
       "39     4.0                4           9.0          11.0                   11   \n",
       "41     6.0                7           8.0          10.0                   10   \n",
       "43     4.0                9           6.0           8.0                    8   \n",
       "45     6.0                9           9.0           0.0                    9   \n",
       "47     5.0                9           5.0           7.0                    7   \n",
       "\n",
       "    Total_Sessional_(50)  Final_(50)  Total_(100) Grade  \n",
       "1                     32        18.0           50     F  \n",
       "3                     23        23.0           46     F  \n",
       "5                     44        27.0           71     B  \n",
       "7                     45        40.0           85     A  \n",
       "9                     44        40.0           84     A  \n",
       "11                    41        35.0           76     B  \n",
       "13                    42        25.0           67     C  \n",
       "15                    18         0.0           18     F  \n",
       "17                    39        31.0           70     B  \n",
       "19                    46        45.0           91     A  \n",
       "21                    40        20.0           60     C  \n",
       "23                    41        21.0           62     C  \n",
       "25                    45        41.0           86     A  \n",
       "27                    45        26.0           71     B  \n",
       "29                    30         9.0           39     F  \n",
       "31                    44        29.0           73     B  \n",
       "33                    34        17.0           51     F  \n",
       "35                    38        28.0           66     C  \n",
       "37                    45        30.0           75     B  \n",
       "39                    43        25.0           68     C  \n",
       "41                    37        20.0           57     F  \n",
       "43                    45        34.0           79     B  \n",
       "45                    45        35.0           80     A  \n",
       "47                    27        19.0           46     F  "
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[1::2]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 9. Display only those students who got failed in examination"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Adeel Ahmed</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ahmed Ali Raza</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Haseeb Sajid</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Muhammad Abdullah</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Muhammad Saqib Intizar</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Muhammad Shahroz Khurshid</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Muhammad Wajahat Khan</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Muhammad Younus Baig</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Sadaquat Rafique</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Shariqa Ahmad</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Waqar Ahmed</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Student_Name Grade\n",
       "1                 Adeel Ahmed     F\n",
       "3              Ahmed Ali Raza     F\n",
       "15               Haseeb Sajid     F\n",
       "22          Muhammad Abdullah     F\n",
       "28     Muhammad Saqib Intizar     F\n",
       "29  Muhammad Shahroz Khurshid     F\n",
       "32      Muhammad Wajahat Khan     F\n",
       "33       Muhammad Younus Baig     F\n",
       "38           Sadaquat Rafique     F\n",
       "41              Shariqa Ahmad     F\n",
       "47                Waqar Ahmed     F"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[[\"Student_Name\",\"Grade\"]][df.Grade == \"F\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 10. Find out the basic statistical info about data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "--------------------------Mean----------------------\n",
      "Mid                     22.937500\n",
      "Quiz_1                   6.833333\n",
      "Quiz_2                   4.562500\n",
      "Best_of_Quizzes          7.020833\n",
      "Assignment_1             7.270833\n",
      "Assignment_2             7.083333\n",
      "Best_of_Assignments      8.937500\n",
      "Total_Sessional_(50)    38.895833\n",
      "Final_(50)              27.270833\n",
      "Total_(100)             66.166667\n",
      "dtype: float64\n",
      "--------------------------Median----------------------\n",
      "Mid                     25.0\n",
      "Quiz_1                   7.0\n",
      "Quiz_2                   5.0\n",
      "Best_of_Quizzes          7.0\n",
      "Assignment_1             8.0\n",
      "Assignment_2            10.0\n",
      "Best_of_Assignments     10.0\n",
      "Total_Sessional_(50)    41.0\n",
      "Final_(50)              27.5\n",
      "Total_(100)             69.0\n",
      "dtype: float64\n",
      "--------------------------Standard Deviation----------------------\n",
      "Mid                      5.236558\n",
      "Quiz_1                   2.336877\n",
      "Quiz_2                   1.843981\n",
      "Best_of_Quizzes          1.973113\n",
      "Assignment_1             2.209646\n",
      "Assignment_2             4.365402\n",
      "Best_of_Assignments      2.127892\n",
      "Total_Sessional_(50)     7.179283\n",
      "Final_(50)               9.259244\n",
      "Total_(100)             15.227821\n",
      "dtype: float64\n",
      "--------------------------Variance----------------------\n",
      "Mid                      27.421543\n",
      "Quiz_1                    5.460993\n",
      "Quiz_2                    3.400266\n",
      "Best_of_Quizzes           3.893174\n",
      "Assignment_1              4.882535\n",
      "Assignment_2             19.056738\n",
      "Best_of_Assignments       4.527926\n",
      "Total_Sessional_(50)     51.542110\n",
      "Final_(50)               85.733599\n",
      "Total_(100)             231.886525\n",
      "dtype: float64\n"
     ]
    }
   ],
   "source": [
    "print(\"--------------------------Mean----------------------\")\n",
    "print(df.mean())\n",
    "print(\"--------------------------Median----------------------\")\n",
    "print(df.median())\n",
    "print(\"--------------------------Standard Deviation----------------------\")\n",
    "print(df.std())\n",
    "print(\"--------------------------Variance----------------------\")\n",
    "print(df.var())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 11. How many students got A, B, C, F?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Student_Name    8\n",
       "Grade           8\n",
       "dtype: int64"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[[\"Student_Name\",\"Grade\"]][df.Grade == \"A\"].count()\n",
    "# df[[\"Student_Name\",\"Grade\"]][df.Grade == \"F\"].count()\n",
    "# df[[\"Student_Name\",\"Grade\"]][df.Grade == \"B\"].count()\n",
    "# df[[\"Student_Name\",\"Grade\"]][df.Grade == \"C\"].count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>Grade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Aneebullah Niazi</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Arsalan</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Fatima Haider Warsi</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Mohammad Hunain</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Muhammad Faraz</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Nazeer Bin Zafar</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Sharif Taqi</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Syeda Sabika Raza</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Student_Name Grade\n",
       "7      Aneebullah Niazi     A\n",
       "9               Arsalan     A\n",
       "10  Fatima Haider Warsi     A\n",
       "19      Mohammad Hunain     A\n",
       "25       Muhammad Faraz     A\n",
       "34     Nazeer Bin Zafar     A\n",
       "40          Sharif Taqi     A\n",
       "45    Syeda Sabika Raza     A"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[[\"Student_Name\",\"Grade\"]][df.Grade == \"A\"]\n",
    "# df[[\"Student_Name\",\"Grade\"]][df.Grade == \"F\"]\n",
    "# df[[\"Student_Name\",\"Grade\"]][df.Grade == \"B\"]\n",
    "# df[[\"Student_Name\",\"Grade\"]][df.Grade == \"C\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 12. What are the mean scores for students who got A, B, C, F?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Mid                     27.000\n",
       "Quiz_1                   8.750\n",
       "Quiz_2                   6.125\n",
       "Best_of_Quizzes          8.750\n",
       "Assignment_1             8.125\n",
       "Assignment_2             6.250\n",
       "Best_of_Assignments      9.375\n",
       "Total_Sessional_(50)    45.125\n",
       "Final_(50)              40.375\n",
       "Total_(100)             85.500\n",
       "dtype: float64"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.Grade == \"A\"].mean()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Mid                     25.6875\n",
       "Quiz_1                   7.4375\n",
       "Quiz_2                   5.1250\n",
       "Best_of_Quizzes          7.5000\n",
       "Assignment_1             7.8750\n",
       "Assignment_2             6.6250\n",
       "Best_of_Assignments      9.2500\n",
       "Total_Sessional_(50)    42.4375\n",
       "Final_(50)              30.7500\n",
       "Total_(100)             73.1875\n",
       "dtype: float64"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.Grade == \"B\"].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Mid                     22.846154\n",
       "Quiz_1                   6.615385\n",
       "Quiz_2                   3.615385\n",
       "Best_of_Quizzes          6.692308\n",
       "Assignment_1             7.230769\n",
       "Assignment_2             9.000000\n",
       "Best_of_Assignments      9.692308\n",
       "Total_Sessional_(50)    39.230769\n",
       "Final_(50)              24.769231\n",
       "Total_(100)             64.000000\n",
       "dtype: float64"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.Grade == \"C\"].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Mid                     16.090909\n",
       "Quiz_1                   4.818182\n",
       "Quiz_2                   3.727273\n",
       "Best_of_Quizzes          5.454545\n",
       "Assignment_1             5.818182\n",
       "Assignment_2             6.090909\n",
       "Best_of_Assignments      7.272727\n",
       "Total_Sessional_(50)    28.818182\n",
       "Final_(50)              15.636364\n",
       "Total_(100)             44.454545\n",
       "dtype: float64"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.Grade == \"F\"].mean()"
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}