Merging and  Removing rows and columns on a DataFrame.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Learning how to Describe, Clean and Manupulate Data Using  My perfomance Score Cards"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# loading in the required Libraries\n",
    "\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Reading  in My Score Cards Date Set\n",
    "Score_Card = pd.read_csv(r'C:\\Users\\DMONGARE\\Desktop\\J projects\\Pefomance Data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>KPIs</th>\n",
       "      <th>Apr-19</th>\n",
       "      <th>May-19</th>\n",
       "      <th>Jun-19</th>\n",
       "      <th>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "      <th>Nov-19</th>\n",
       "      <th>Dec-19</th>\n",
       "      <th>...</th>\n",
       "      <th>Jun-20</th>\n",
       "      <th>Jul-20</th>\n",
       "      <th>Aug-20</th>\n",
       "      <th>Sep-20</th>\n",
       "      <th>Oct-20</th>\n",
       "      <th>Nov-20</th>\n",
       "      <th>Dec-20</th>\n",
       "      <th>Jan-21</th>\n",
       "      <th>Feb-21</th>\n",
       "      <th>Mar-21</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Call Quality</td>\n",
       "      <td>98.14%</td>\n",
       "      <td>98.50%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.22%</td>\n",
       "      <td>99%</td>\n",
       "      <td>91.30%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.78%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.98%</td>\n",
       "      <td>97.74%</td>\n",
       "      <td>99%</td>\n",
       "      <td>97.32%</td>\n",
       "      <td>95.14%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.50%</td>\n",
       "      <td>91.91%</td>\n",
       "      <td>98.11%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SMS Quality</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Service Request</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>eMail Quality</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Quality of Escalation</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "      <td>97.06%</td>\n",
       "      <td>88%</td>\n",
       "      <td>85%</td>\n",
       "      <td>100%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.15%</td>\n",
       "      <td>92%</td>\n",
       "      <td>97.37%</td>\n",
       "      <td>95%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>95.74%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Customer Feedback(Satisfaction)</td>\n",
       "      <td>70.09%</td>\n",
       "      <td>74.88%</td>\n",
       "      <td>71.28%</td>\n",
       "      <td>71.35%</td>\n",
       "      <td>72.97%</td>\n",
       "      <td>70.94%</td>\n",
       "      <td>74.32%</td>\n",
       "      <td>68.82%</td>\n",
       "      <td>71.69%</td>\n",
       "      <td>...</td>\n",
       "      <td>78.08%</td>\n",
       "      <td>72.47%</td>\n",
       "      <td>82.37%</td>\n",
       "      <td>62.50%</td>\n",
       "      <td>80.77%</td>\n",
       "      <td>77.16%</td>\n",
       "      <td>79.40%</td>\n",
       "      <td>82.11%</td>\n",
       "      <td>78.60%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Customer Feedback(Resolution)</td>\n",
       "      <td>80.80%</td>\n",
       "      <td>71.30%</td>\n",
       "      <td>82.27%</td>\n",
       "      <td>66.67%</td>\n",
       "      <td>79.38%</td>\n",
       "      <td>82.91%</td>\n",
       "      <td>84.35%</td>\n",
       "      <td>74.12%</td>\n",
       "      <td>76.19%</td>\n",
       "      <td>...</td>\n",
       "      <td>83.22%</td>\n",
       "      <td>76.21%</td>\n",
       "      <td>86.33%</td>\n",
       "      <td>83.33%</td>\n",
       "      <td>80.49%</td>\n",
       "      <td>82.76%</td>\n",
       "      <td>79.55%</td>\n",
       "      <td>82.93%</td>\n",
       "      <td>84.93%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Customer Feedback(NPS)</td>\n",
       "      <td>33.04%</td>\n",
       "      <td>25.93%</td>\n",
       "      <td>22.70%</td>\n",
       "      <td>16.67%</td>\n",
       "      <td>38.13%</td>\n",
       "      <td>32.48%</td>\n",
       "      <td>46.26%</td>\n",
       "      <td>28.24%</td>\n",
       "      <td>37.04%</td>\n",
       "      <td>...</td>\n",
       "      <td>51.03%</td>\n",
       "      <td>38.33%</td>\n",
       "      <td>56.83%</td>\n",
       "      <td>25.00%</td>\n",
       "      <td>54.40%</td>\n",
       "      <td>46.55%</td>\n",
       "      <td>53.98%</td>\n",
       "      <td>44.72%</td>\n",
       "      <td>32.88%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Chat(Availability)</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>...</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>9</th>\n",
       "      <td>Chat(Efficiency)</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>...</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>10</th>\n",
       "      <td>Reversals Closed</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>...</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>11</th>\n",
       "      <td>Reports</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>98erence</td>\n",
       "      <td>97.75%</td>\n",
       "      <td>97.61%</td>\n",
       "      <td>98.22%</td>\n",
       "      <td>99.70%</td>\n",
       "      <td>99.35%</td>\n",
       "      <td>95.49%</td>\n",
       "      <td>98.18%</td>\n",
       "      <td>98.53%</td>\n",
       "      <td>98.19%</td>\n",
       "      <td>...</td>\n",
       "      <td>93.27%</td>\n",
       "      <td>95.20%</td>\n",
       "      <td>97.84%</td>\n",
       "      <td>97.91%</td>\n",
       "      <td>98.12%</td>\n",
       "      <td>95.15%</td>\n",
       "      <td>98.33%</td>\n",
       "      <td>95.94%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.97%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>SLA</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>...</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>14</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>...</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>15</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>...</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>16</th>\n",
       "      <td>Hold Time / Talk Time</td>\n",
       "      <td>13| 181</td>\n",
       "      <td>20| 179</td>\n",
       "      <td>25| 186</td>\n",
       "      <td>27| 198</td>\n",
       "      <td>19| 208</td>\n",
       "      <td>20| 217</td>\n",
       "      <td>19 | 208</td>\n",
       "      <td>24 | 207</td>\n",
       "      <td>25 | 194</td>\n",
       "      <td>...</td>\n",
       "      <td>32| 203</td>\n",
       "      <td>35| 213</td>\n",
       "      <td>27| 223</td>\n",
       "      <td>18| 215</td>\n",
       "      <td>25 | 205</td>\n",
       "      <td>23 | 219</td>\n",
       "      <td>23 | 207</td>\n",
       "      <td>20 | 198</td>\n",
       "      <td>22 | 205</td>\n",
       "      <td>20 | 208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Fraud SMS Tool / Proactive Retention</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Follow Up &amp; Feedback / Reactive Retention</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Calls Answered / SRs Closed per Day(Monthly)</td>\n",
       "      <td>3142</td>\n",
       "      <td>2965</td>\n",
       "      <td>2380</td>\n",
       "      <td>1169</td>\n",
       "      <td>2908</td>\n",
       "      <td>2362</td>\n",
       "      <td>2518</td>\n",
       "      <td>2159</td>\n",
       "      <td>2776</td>\n",
       "      <td>...</td>\n",
       "      <td>2491</td>\n",
       "      <td>2182</td>\n",
       "      <td>2390</td>\n",
       "      <td>1048</td>\n",
       "      <td>2502</td>\n",
       "      <td>1111</td>\n",
       "      <td>2776</td>\n",
       "      <td>2393</td>\n",
       "      <td>2185</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Calls Answered / SRs Closed per Day(Daily)</td>\n",
       "      <td>18 |</td>\n",
       "      <td>18 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>17 |</td>\n",
       "      <td>...</td>\n",
       "      <td>13 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>12 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Short Calls / Login(Average)</td>\n",
       "      <td>|</td>\n",
       "      <td>6 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>9 |</td>\n",
       "      <td>...</td>\n",
       "      <td>11 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>|</td>\n",
       "      <td>8 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>182 |</td>\n",
       "      <td>9 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>SMS Quantity Closed</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>...</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>23</th>\n",
       "      <td>First Call Resolution (FCR)</td>\n",
       "      <td>89.14%</td>\n",
       "      <td>86.70%</td>\n",
       "      <td>87.81%</td>\n",
       "      <td>88.09%</td>\n",
       "      <td>86.64%</td>\n",
       "      <td>86.88%</td>\n",
       "      <td>90%</td>\n",
       "      <td>87%</td>\n",
       "      <td>88%</td>\n",
       "      <td>...</td>\n",
       "      <td>89%</td>\n",
       "      <td>89%</td>\n",
       "      <td>90%</td>\n",
       "      <td>90%</td>\n",
       "      <td>90%</td>\n",
       "      <td>91%</td>\n",
       "      <td>91%</td>\n",
       "      <td>91%</td>\n",
       "      <td>Not Apply%</td>\n",
       "      <td>89%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Attendance (MIA Days)(Days Missed)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Net Promoter Score (NPS)</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>...</td>\n",
       "      <td>39</td>\n",
       "      <td>44</td>\n",
       "      <td>45</td>\n",
       "      <td>46</td>\n",
       "      <td>52</td>\n",
       "      <td>53</td>\n",
       "      <td>49</td>\n",
       "      <td>50</td>\n",
       "      <td>47</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>26 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            KPIs     Apr-19     May-19  \\\n",
       "0                                   Call Quality     98.14%     98.50%   \n",
       "1                                    SMS Quality  Not Apply  Not Apply   \n",
       "2                                Service Request  Not Apply  Not Apply   \n",
       "3                                  eMail Quality  Not Apply  Not Apply   \n",
       "4                          Quality of Escalation       100%       100%   \n",
       "5                Customer Feedback(Satisfaction)     70.09%     74.88%   \n",
       "6                  Customer Feedback(Resolution)     80.80%     71.30%   \n",
       "7                         Customer Feedback(NPS)     33.04%     25.93%   \n",
       "8                             Chat(Availability)        NaN        NaN   \n",
       "9                               Chat(Efficiency)        NaN        NaN   \n",
       "10                              Reversals Closed        NaN        NaN   \n",
       "11                                       Reports          |          |   \n",
       "12                                      98erence     97.75%     97.61%   \n",
       "13                                           SLA        NaN        NaN   \n",
       "14                                           NaN        NaN        NaN   \n",
       "15                                           NaN        NaN        NaN   \n",
       "16                         Hold Time / Talk Time    13| 181    20| 179   \n",
       "17          Fraud SMS Tool / Proactive Retention          |          |   \n",
       "18     Follow Up & Feedback / Reactive Retention          |          |   \n",
       "19  Calls Answered / SRs Closed per Day(Monthly)       3142       2965   \n",
       "20    Calls Answered / SRs Closed per Day(Daily)       18 |       18 |   \n",
       "21                  Short Calls / Login(Average)          |        6 |   \n",
       "22                           SMS Quantity Closed        NaN        NaN   \n",
       "23                   First Call Resolution (FCR)     89.14%     86.70%   \n",
       "24            Attendance (MIA Days)(Days Missed)        NaN        NaN   \n",
       "25                      Net Promoter Score (NPS)        NaN        NaN   \n",
       "\n",
       "       Jun-19     Jul-19     Aug-19     Sep-19     Oct-19     Nov-19  \\\n",
       "0      99.50%     97.80%     95.22%        99%     91.30%     99.50%   \n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4        100%       100%     96.43%     97.06%        88%        85%   \n",
       "5      71.28%     71.35%     72.97%     70.94%     74.32%     68.82%   \n",
       "6      82.27%     66.67%     79.38%     82.91%     84.35%     74.12%   \n",
       "7      22.70%     16.67%     38.13%     32.48%     46.26%     28.24%   \n",
       "8         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "11          |          |          |          |          |          |   \n",
       "12     98.22%     99.70%     99.35%     95.49%     98.18%     98.53%   \n",
       "13        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "14        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "15        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "16    25| 186    27| 198    19| 208    20| 217   19 | 208   24 | 207   \n",
       "17          |          |          |          |          |          |   \n",
       "18          |          |          |          |          |          |   \n",
       "19       2380       1169       2908       2362       2518       2159   \n",
       "20       16 |       16 |       16 |       15 |       15 |       15 |   \n",
       "21        7 |        6 |        6 |        6 |        6 |        8 |   \n",
       "22        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "23     87.81%     88.09%     86.64%     86.88%        90%        87%   \n",
       "24        NaN        NaN        NaN          1          1          2   \n",
       "25        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "\n",
       "       Dec-19  ...     Jun-20     Jul-20     Aug-20     Sep-20     Oct-20  \\\n",
       "0      97.78%  ...     96.98%     97.74%        99%     97.32%     95.14%   \n",
       "1   Not Apply  ...  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2   Not Apply  ...  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3   Not Apply  ...  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4        100%  ...     96.15%        92%     97.37%        95%       100%   \n",
       "5      71.69%  ...     78.08%     72.47%     82.37%     62.50%     80.77%   \n",
       "6      76.19%  ...     83.22%     76.21%     86.33%     83.33%     80.49%   \n",
       "7      37.04%  ...     51.03%     38.33%     56.83%     25.00%     54.40%   \n",
       "8         NaN  ...        NaN        NaN        NaN        NaN        NaN   \n",
       "9         NaN  ...        NaN        NaN        NaN        NaN        NaN   \n",
       "10        NaN  ...        NaN        NaN        NaN        NaN        NaN   \n",
       "11          |  ...          |          |          |          |          |   \n",
       "12     98.19%  ...     93.27%     95.20%     97.84%     97.91%     98.12%   \n",
       "13        NaN  ...        NaN        NaN        NaN        NaN        NaN   \n",
       "14        NaN  ...        NaN        NaN        NaN        NaN        NaN   \n",
       "15        NaN  ...        NaN        NaN        NaN        NaN        NaN   \n",
       "16   25 | 194  ...    32| 203    35| 213    27| 223    18| 215   25 | 205   \n",
       "17          |  ...          |          |          |          |          |   \n",
       "18          |  ...          |          |          |          |          |   \n",
       "19       2776  ...       2491       2182       2390       1048       2502   \n",
       "20       17 |  ...       13 |       14 |       14 |       15 |       14 |   \n",
       "21        9 |  ...       11 |        8 |        7 |        7 |          |   \n",
       "22        NaN  ...        NaN        NaN        NaN        NaN        NaN   \n",
       "23        88%  ...        89%        89%        90%        90%        90%   \n",
       "24        NaN  ...        NaN          2        NaN        NaN          1   \n",
       "25        NaN  ...         39         44         45         46         52   \n",
       "\n",
       "       Nov-20     Dec-20     Jan-21      Feb-21    Mar-21  \n",
       "0        100%     98.50%     91.91%      98.11%       NaN  \n",
       "1   Not Apply  Not Apply  Not Apply   Not Apply       NaN  \n",
       "2   Not Apply  Not Apply  Not Apply   Not Apply       NaN  \n",
       "3   Not Apply  Not Apply  Not Apply   Not Apply       NaN  \n",
       "4        100%       100%       100%      95.74%       NaN  \n",
       "5      77.16%     79.40%     82.11%      78.60%       NaN  \n",
       "6      82.76%     79.55%     82.93%      84.93%       NaN  \n",
       "7      46.55%     53.98%     44.72%      32.88%       NaN  \n",
       "8         NaN        NaN        NaN         NaN       NaN  \n",
       "9         NaN        NaN        NaN         NaN       NaN  \n",
       "10        NaN        NaN        NaN         NaN       NaN  \n",
       "11          |          |          |           |         |  \n",
       "12     95.15%     98.33%     95.94%      97.80%    95.97%  \n",
       "13        NaN        NaN        NaN         NaN       NaN  \n",
       "14        NaN        NaN        NaN         NaN       NaN  \n",
       "15        NaN        NaN        NaN         NaN       NaN  \n",
       "16   23 | 219   23 | 207   20 | 198    22 | 205  20 | 208  \n",
       "17          |          |          |           |         |  \n",
       "18          |          |          |           |         |  \n",
       "19       1111       2776       2393        2185      1992  \n",
       "20       14 |       16 |       15 |        15 |      12 |  \n",
       "21        8 |        7 |        7 |       182 |       9 |  \n",
       "22        NaN        NaN        NaN         NaN       NaN  \n",
       "23        91%        91%        91%  Not Apply%       89%  \n",
       "24        NaN        NaN          1         NaN       NaN  \n",
       "25         53         49         50          47       NaN  \n",
       "\n",
       "[26 rows x 26 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Taking a look  at  my Data Set\n",
    "\n",
    "Score_Card.head(27)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(26, 26)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Score_Card.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['KPIs', 'Apr-19', 'May-19', 'Jun-19', 'Jul-19', 'Aug-19', 'Sep-19',\n",
       "       'Oct-19', 'Nov-19', 'Dec-19', 'Jan-20', 'Feb-20', 'Mar-20', 'Apr-20',\n",
       "       'Apr-20.1', 'May-20', 'Jun-20', 'Jul-20', 'Aug-20', 'Sep-20', 'Oct-20',\n",
       "       'Nov-20', 'Dec-20', 'Jan-21', 'Feb-21', 'Mar-21'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# checking columns\n",
    "\n",
    "Score_Card.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Deleting Rows and Columns\n",
    "\n",
    "# a) Rows :  I am going to drop row  'Unnamed: 1'\n",
    "\n",
    "Score_Card.drop('KPIs',axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>May-19</th>\n",
       "      <th>Jun-19</th>\n",
       "      <th>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "      <th>Nov-19</th>\n",
       "      <th>Dec-19</th>\n",
       "      <th>Jan-20</th>\n",
       "      <th>Feb-20</th>\n",
       "      <th>...</th>\n",
       "      <th>Jun-20</th>\n",
       "      <th>Jul-20</th>\n",
       "      <th>Aug-20</th>\n",
       "      <th>Sep-20</th>\n",
       "      <th>Oct-20</th>\n",
       "      <th>Nov-20</th>\n",
       "      <th>Dec-20</th>\n",
       "      <th>Jan-21</th>\n",
       "      <th>Feb-21</th>\n",
       "      <th>Mar-21</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>98.50%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.22%</td>\n",
       "      <td>99%</td>\n",
       "      <td>91.30%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.78%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.38%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.98%</td>\n",
       "      <td>97.74%</td>\n",
       "      <td>99%</td>\n",
       "      <td>97.32%</td>\n",
       "      <td>95.14%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.50%</td>\n",
       "      <td>91.91%</td>\n",
       "      <td>98.11%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "      <td>97.06%</td>\n",
       "      <td>88%</td>\n",
       "      <td>85%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.15%</td>\n",
       "      <td>92%</td>\n",
       "      <td>97.37%</td>\n",
       "      <td>95%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>95.74%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      May-19     Jun-19     Jul-19     Aug-19     Sep-19     Oct-19  \\\n",
       "0     98.50%     99.50%     97.80%     95.22%        99%     91.30%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4       100%       100%       100%     96.43%     97.06%        88%   \n",
       "\n",
       "      Nov-19     Dec-19     Jan-20     Feb-20  ...     Jun-20     Jul-20  \\\n",
       "0     99.50%     97.78%       100%     98.38%  ...     96.98%     97.74%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "4        85%       100%       100%       100%  ...     96.15%        92%   \n",
       "\n",
       "      Aug-20     Sep-20     Oct-20     Nov-20     Dec-20     Jan-21  \\\n",
       "0        99%     97.32%     95.14%       100%     98.50%     91.91%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4     97.37%        95%       100%       100%       100%       100%   \n",
       "\n",
       "      Feb-21 Mar-21  \n",
       "0     98.11%    NaN  \n",
       "1  Not Apply    NaN  \n",
       "2  Not Apply    NaN  \n",
       "3  Not Apply    NaN  \n",
       "4     95.74%    NaN  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Score_Card.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['May-19', 'Jun-19', 'Jul-19', 'Aug-19', 'Sep-19', 'Oct-19', 'Nov-19',\n",
       "       'Dec-19', 'Jan-20', 'Feb-20', 'Mar-20', 'Apr-20', 'Apr-20.1', 'May-20',\n",
       "       'Jun-20', 'Jul-20', 'Aug-20', 'Sep-20', 'Oct-20', 'Nov-20', 'Dec-20',\n",
       "       'Jan-21', 'Feb-21', 'Mar-21'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Deleting more than one  columns\n",
    "# Create a new data frame\n",
    "\n",
    "Score_Card.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Jun-19', 'Apr-20', 'Dec-20'], dtype='object')"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Score_Card.columns[[1,11,20]]"
   ]
  },
  {
   "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>May-19</th>\n",
       "      <th>Jun-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "      <th>Nov-19</th>\n",
       "      <th>Dec-19</th>\n",
       "      <th>Jan-20</th>\n",
       "      <th>Feb-20</th>\n",
       "      <th>Mar-20</th>\n",
       "      <th>...</th>\n",
       "      <th>May-20</th>\n",
       "      <th>Jun-20</th>\n",
       "      <th>Jul-20</th>\n",
       "      <th>Aug-20</th>\n",
       "      <th>Sep-20</th>\n",
       "      <th>Oct-20</th>\n",
       "      <th>Nov-20</th>\n",
       "      <th>Jan-21</th>\n",
       "      <th>Feb-21</th>\n",
       "      <th>Mar-21</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>98.50%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>95.22%</td>\n",
       "      <td>99%</td>\n",
       "      <td>91.30%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.78%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.38%</td>\n",
       "      <td>99%</td>\n",
       "      <td>...</td>\n",
       "      <td>92.32%</td>\n",
       "      <td>96.98%</td>\n",
       "      <td>97.74%</td>\n",
       "      <td>99%</td>\n",
       "      <td>97.32%</td>\n",
       "      <td>95.14%</td>\n",
       "      <td>100%</td>\n",
       "      <td>91.91%</td>\n",
       "      <td>98.11%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "      <td>97.06%</td>\n",
       "      <td>88%</td>\n",
       "      <td>85%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>95.83%</td>\n",
       "      <td>...</td>\n",
       "      <td>96%</td>\n",
       "      <td>96.15%</td>\n",
       "      <td>92%</td>\n",
       "      <td>97.37%</td>\n",
       "      <td>95%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>95.74%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      May-19     Jun-19     Aug-19     Sep-19     Oct-19     Nov-19  \\\n",
       "0     98.50%     99.50%     95.22%        99%     91.30%     99.50%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4       100%       100%     96.43%     97.06%        88%        85%   \n",
       "\n",
       "      Dec-19     Jan-20     Feb-20     Mar-20  ...     May-20     Jun-20  \\\n",
       "0     97.78%       100%     98.38%        99%  ...     92.32%     96.98%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "4       100%       100%       100%     95.83%  ...        96%     96.15%   \n",
       "\n",
       "      Jul-20     Aug-20     Sep-20     Oct-20     Nov-20     Jan-21  \\\n",
       "0     97.74%        99%     97.32%     95.14%       100%     91.91%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4        92%     97.37%        95%       100%       100%       100%   \n",
       "\n",
       "      Feb-21 Mar-21  \n",
       "0     98.11%    NaN  \n",
       "1  Not Apply    NaN  \n",
       "2  Not Apply    NaN  \n",
       "3  Not Apply    NaN  \n",
       "4     95.74%    NaN  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Score_Card1 = Score_Card.drop(Score_Card.columns[[2,11,20]],axis=1)\n",
    "Score_Card1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>May-19</th>\n",
       "      <th>Jun-19</th>\n",
       "      <th>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "      <th>Nov-19</th>\n",
       "      <th>Dec-19</th>\n",
       "      <th>Jan-20</th>\n",
       "      <th>Feb-20</th>\n",
       "      <th>...</th>\n",
       "      <th>Jun-20</th>\n",
       "      <th>Jul-20</th>\n",
       "      <th>Aug-20</th>\n",
       "      <th>Sep-20</th>\n",
       "      <th>Oct-20</th>\n",
       "      <th>Nov-20</th>\n",
       "      <th>Dec-20</th>\n",
       "      <th>Jan-21</th>\n",
       "      <th>Feb-21</th>\n",
       "      <th>Mar-21</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "      <td>97.06%</td>\n",
       "      <td>88%</td>\n",
       "      <td>85%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.15%</td>\n",
       "      <td>92%</td>\n",
       "      <td>97.37%</td>\n",
       "      <td>95%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>95.74%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>74.88%</td>\n",
       "      <td>71.28%</td>\n",
       "      <td>71.35%</td>\n",
       "      <td>72.97%</td>\n",
       "      <td>70.94%</td>\n",
       "      <td>74.32%</td>\n",
       "      <td>68.82%</td>\n",
       "      <td>71.69%</td>\n",
       "      <td>64.86%</td>\n",
       "      <td>79.46%</td>\n",
       "      <td>...</td>\n",
       "      <td>78.08%</td>\n",
       "      <td>72.47%</td>\n",
       "      <td>82.37%</td>\n",
       "      <td>62.50%</td>\n",
       "      <td>80.77%</td>\n",
       "      <td>77.16%</td>\n",
       "      <td>79.40%</td>\n",
       "      <td>82.11%</td>\n",
       "      <td>78.60%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>71.30%</td>\n",
       "      <td>82.27%</td>\n",
       "      <td>66.67%</td>\n",
       "      <td>79.38%</td>\n",
       "      <td>82.91%</td>\n",
       "      <td>84.35%</td>\n",
       "      <td>74.12%</td>\n",
       "      <td>76.19%</td>\n",
       "      <td>75.36%</td>\n",
       "      <td>75.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>83.22%</td>\n",
       "      <td>76.21%</td>\n",
       "      <td>86.33%</td>\n",
       "      <td>83.33%</td>\n",
       "      <td>80.49%</td>\n",
       "      <td>82.76%</td>\n",
       "      <td>79.55%</td>\n",
       "      <td>82.93%</td>\n",
       "      <td>84.93%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>25.93%</td>\n",
       "      <td>22.70%</td>\n",
       "      <td>16.67%</td>\n",
       "      <td>38.13%</td>\n",
       "      <td>32.48%</td>\n",
       "      <td>46.26%</td>\n",
       "      <td>28.24%</td>\n",
       "      <td>37.04%</td>\n",
       "      <td>27.54%</td>\n",
       "      <td>35.71%</td>\n",
       "      <td>...</td>\n",
       "      <td>51.03%</td>\n",
       "      <td>38.33%</td>\n",
       "      <td>56.83%</td>\n",
       "      <td>25.00%</td>\n",
       "      <td>54.40%</td>\n",
       "      <td>46.55%</td>\n",
       "      <td>53.98%</td>\n",
       "      <td>44.72%</td>\n",
       "      <td>32.88%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</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>...</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>9</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>...</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>10</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>...</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>11</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>97.61%</td>\n",
       "      <td>98.22%</td>\n",
       "      <td>99.70%</td>\n",
       "      <td>99.35%</td>\n",
       "      <td>95.49%</td>\n",
       "      <td>98.18%</td>\n",
       "      <td>98.53%</td>\n",
       "      <td>98.19%</td>\n",
       "      <td>98.76%</td>\n",
       "      <td>98.06%</td>\n",
       "      <td>...</td>\n",
       "      <td>93.27%</td>\n",
       "      <td>95.20%</td>\n",
       "      <td>97.84%</td>\n",
       "      <td>97.91%</td>\n",
       "      <td>98.12%</td>\n",
       "      <td>95.15%</td>\n",
       "      <td>98.33%</td>\n",
       "      <td>95.94%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.97%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</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>...</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>14</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>...</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>15</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>...</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>16</th>\n",
       "      <td>20| 179</td>\n",
       "      <td>25| 186</td>\n",
       "      <td>27| 198</td>\n",
       "      <td>19| 208</td>\n",
       "      <td>20| 217</td>\n",
       "      <td>19 | 208</td>\n",
       "      <td>24 | 207</td>\n",
       "      <td>25 | 194</td>\n",
       "      <td>25 | 188</td>\n",
       "      <td>20 | 191</td>\n",
       "      <td>...</td>\n",
       "      <td>32| 203</td>\n",
       "      <td>35| 213</td>\n",
       "      <td>27| 223</td>\n",
       "      <td>18| 215</td>\n",
       "      <td>25 | 205</td>\n",
       "      <td>23 | 219</td>\n",
       "      <td>23 | 207</td>\n",
       "      <td>20 | 198</td>\n",
       "      <td>22 | 205</td>\n",
       "      <td>20 | 208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2965</td>\n",
       "      <td>2380</td>\n",
       "      <td>1169</td>\n",
       "      <td>2908</td>\n",
       "      <td>2362</td>\n",
       "      <td>2518</td>\n",
       "      <td>2159</td>\n",
       "      <td>2776</td>\n",
       "      <td>2498</td>\n",
       "      <td>1434</td>\n",
       "      <td>...</td>\n",
       "      <td>2491</td>\n",
       "      <td>2182</td>\n",
       "      <td>2390</td>\n",
       "      <td>1048</td>\n",
       "      <td>2502</td>\n",
       "      <td>1111</td>\n",
       "      <td>2776</td>\n",
       "      <td>2393</td>\n",
       "      <td>2185</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>18 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>17 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>...</td>\n",
       "      <td>13 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>12 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>9 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>...</td>\n",
       "      <td>11 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>|</td>\n",
       "      <td>8 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>182 |</td>\n",
       "      <td>9 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</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>...</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>23</th>\n",
       "      <td>86.70%</td>\n",
       "      <td>87.81%</td>\n",
       "      <td>88.09%</td>\n",
       "      <td>86.64%</td>\n",
       "      <td>86.88%</td>\n",
       "      <td>90%</td>\n",
       "      <td>87%</td>\n",
       "      <td>88%</td>\n",
       "      <td>87%</td>\n",
       "      <td>90%</td>\n",
       "      <td>...</td>\n",
       "      <td>89%</td>\n",
       "      <td>89%</td>\n",
       "      <td>90%</td>\n",
       "      <td>90%</td>\n",
       "      <td>90%</td>\n",
       "      <td>91%</td>\n",
       "      <td>91%</td>\n",
       "      <td>91%</td>\n",
       "      <td>Not Apply%</td>\n",
       "      <td>89%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</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>...</td>\n",
       "      <td>39</td>\n",
       "      <td>44</td>\n",
       "      <td>45</td>\n",
       "      <td>46</td>\n",
       "      <td>52</td>\n",
       "      <td>53</td>\n",
       "      <td>49</td>\n",
       "      <td>50</td>\n",
       "      <td>47</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       May-19     Jun-19     Jul-19     Aug-19     Sep-19     Oct-19  \\\n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4        100%       100%       100%     96.43%     97.06%        88%   \n",
       "5      74.88%     71.28%     71.35%     72.97%     70.94%     74.32%   \n",
       "6      71.30%     82.27%     66.67%     79.38%     82.91%     84.35%   \n",
       "7      25.93%     22.70%     16.67%     38.13%     32.48%     46.26%   \n",
       "8         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "11          |          |          |          |          |          |   \n",
       "12     97.61%     98.22%     99.70%     99.35%     95.49%     98.18%   \n",
       "13        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "14        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "15        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "16    20| 179    25| 186    27| 198    19| 208    20| 217   19 | 208   \n",
       "17          |          |          |          |          |          |   \n",
       "18          |          |          |          |          |          |   \n",
       "19       2965       2380       1169       2908       2362       2518   \n",
       "20       18 |       16 |       16 |       16 |       15 |       15 |   \n",
       "21        6 |        7 |        6 |        6 |        6 |        6 |   \n",
       "22        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "23     86.70%     87.81%     88.09%     86.64%     86.88%        90%   \n",
       "24        NaN        NaN        NaN        NaN          1          1   \n",
       "25        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "\n",
       "       Nov-19     Dec-19     Jan-20     Feb-20  ...     Jun-20     Jul-20  \\\n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "4         85%       100%       100%       100%  ...     96.15%        92%   \n",
       "5      68.82%     71.69%     64.86%     79.46%  ...     78.08%     72.47%   \n",
       "6      74.12%     76.19%     75.36%     75.00%  ...     83.22%     76.21%   \n",
       "7      28.24%     37.04%     27.54%     35.71%  ...     51.03%     38.33%   \n",
       "8         NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "11          |          |          |          |  ...          |          |   \n",
       "12     98.53%     98.19%     98.76%     98.06%  ...     93.27%     95.20%   \n",
       "13        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "14        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "15        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "16   24 | 207   25 | 194   25 | 188   20 | 191  ...    32| 203    35| 213   \n",
       "17          |          |          |          |  ...          |          |   \n",
       "18          |          |          |          |  ...          |          |   \n",
       "19       2159       2776       2498       1434  ...       2491       2182   \n",
       "20       15 |       17 |       16 |       15 |  ...       13 |       14 |   \n",
       "21        8 |        9 |        8 |        8 |  ...       11 |        8 |   \n",
       "22        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "23        87%        88%        87%        90%  ...        89%        89%   \n",
       "24          2        NaN          3        NaN  ...        NaN          2   \n",
       "25        NaN        NaN        NaN        NaN  ...         39         44   \n",
       "\n",
       "       Aug-20     Sep-20     Oct-20     Nov-20     Dec-20     Jan-21  \\\n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4      97.37%        95%       100%       100%       100%       100%   \n",
       "5      82.37%     62.50%     80.77%     77.16%     79.40%     82.11%   \n",
       "6      86.33%     83.33%     80.49%     82.76%     79.55%     82.93%   \n",
       "7      56.83%     25.00%     54.40%     46.55%     53.98%     44.72%   \n",
       "8         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "11          |          |          |          |          |          |   \n",
       "12     97.84%     97.91%     98.12%     95.15%     98.33%     95.94%   \n",
       "13        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "14        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "15        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "16    27| 223    18| 215   25 | 205   23 | 219   23 | 207   20 | 198   \n",
       "17          |          |          |          |          |          |   \n",
       "18          |          |          |          |          |          |   \n",
       "19       2390       1048       2502       1111       2776       2393   \n",
       "20       14 |       15 |       14 |       14 |       16 |       15 |   \n",
       "21        7 |        7 |          |        8 |        7 |        7 |   \n",
       "22        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "23        90%        90%        90%        91%        91%        91%   \n",
       "24        NaN        NaN          1        NaN        NaN          1   \n",
       "25         45         46         52         53         49         50   \n",
       "\n",
       "        Feb-21    Mar-21  \n",
       "1    Not Apply       NaN  \n",
       "2    Not Apply       NaN  \n",
       "3    Not Apply       NaN  \n",
       "4       95.74%       NaN  \n",
       "5       78.60%       NaN  \n",
       "6       84.93%       NaN  \n",
       "7       32.88%       NaN  \n",
       "8          NaN       NaN  \n",
       "9          NaN       NaN  \n",
       "10         NaN       NaN  \n",
       "11           |         |  \n",
       "12      97.80%    95.97%  \n",
       "13         NaN       NaN  \n",
       "14         NaN       NaN  \n",
       "15         NaN       NaN  \n",
       "16    22 | 205  20 | 208  \n",
       "17           |         |  \n",
       "18           |         |  \n",
       "19        2185      1992  \n",
       "20        15 |      12 |  \n",
       "21       182 |       9 |  \n",
       "22         NaN       NaN  \n",
       "23  Not Apply%       89%  \n",
       "24         NaN       NaN  \n",
       "25          47       NaN  \n",
       "\n",
       "[25 rows x 24 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# b) Deteing Rows\n",
    "\n",
    "Score_Card.drop(0)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>May-19</th>\n",
       "      <th>Jun-19</th>\n",
       "      <th>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "      <th>Nov-19</th>\n",
       "      <th>Dec-19</th>\n",
       "      <th>Jan-20</th>\n",
       "      <th>Feb-20</th>\n",
       "      <th>...</th>\n",
       "      <th>Jun-20</th>\n",
       "      <th>Jul-20</th>\n",
       "      <th>Aug-20</th>\n",
       "      <th>Sep-20</th>\n",
       "      <th>Oct-20</th>\n",
       "      <th>Nov-20</th>\n",
       "      <th>Dec-20</th>\n",
       "      <th>Jan-21</th>\n",
       "      <th>Feb-21</th>\n",
       "      <th>Mar-21</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>98.50%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.22%</td>\n",
       "      <td>99%</td>\n",
       "      <td>91.30%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.78%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.38%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.98%</td>\n",
       "      <td>97.74%</td>\n",
       "      <td>99%</td>\n",
       "      <td>97.32%</td>\n",
       "      <td>95.14%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.50%</td>\n",
       "      <td>91.91%</td>\n",
       "      <td>98.11%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "      <td>97.06%</td>\n",
       "      <td>88%</td>\n",
       "      <td>85%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.15%</td>\n",
       "      <td>92%</td>\n",
       "      <td>97.37%</td>\n",
       "      <td>95%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>95.74%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>74.88%</td>\n",
       "      <td>71.28%</td>\n",
       "      <td>71.35%</td>\n",
       "      <td>72.97%</td>\n",
       "      <td>70.94%</td>\n",
       "      <td>74.32%</td>\n",
       "      <td>68.82%</td>\n",
       "      <td>71.69%</td>\n",
       "      <td>64.86%</td>\n",
       "      <td>79.46%</td>\n",
       "      <td>...</td>\n",
       "      <td>78.08%</td>\n",
       "      <td>72.47%</td>\n",
       "      <td>82.37%</td>\n",
       "      <td>62.50%</td>\n",
       "      <td>80.77%</td>\n",
       "      <td>77.16%</td>\n",
       "      <td>79.40%</td>\n",
       "      <td>82.11%</td>\n",
       "      <td>78.60%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>25.93%</td>\n",
       "      <td>22.70%</td>\n",
       "      <td>16.67%</td>\n",
       "      <td>38.13%</td>\n",
       "      <td>32.48%</td>\n",
       "      <td>46.26%</td>\n",
       "      <td>28.24%</td>\n",
       "      <td>37.04%</td>\n",
       "      <td>27.54%</td>\n",
       "      <td>35.71%</td>\n",
       "      <td>...</td>\n",
       "      <td>51.03%</td>\n",
       "      <td>38.33%</td>\n",
       "      <td>56.83%</td>\n",
       "      <td>25.00%</td>\n",
       "      <td>54.40%</td>\n",
       "      <td>46.55%</td>\n",
       "      <td>53.98%</td>\n",
       "      <td>44.72%</td>\n",
       "      <td>32.88%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</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>...</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>9</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>...</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>10</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>...</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>11</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>97.61%</td>\n",
       "      <td>98.22%</td>\n",
       "      <td>99.70%</td>\n",
       "      <td>99.35%</td>\n",
       "      <td>95.49%</td>\n",
       "      <td>98.18%</td>\n",
       "      <td>98.53%</td>\n",
       "      <td>98.19%</td>\n",
       "      <td>98.76%</td>\n",
       "      <td>98.06%</td>\n",
       "      <td>...</td>\n",
       "      <td>93.27%</td>\n",
       "      <td>95.20%</td>\n",
       "      <td>97.84%</td>\n",
       "      <td>97.91%</td>\n",
       "      <td>98.12%</td>\n",
       "      <td>95.15%</td>\n",
       "      <td>98.33%</td>\n",
       "      <td>95.94%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.97%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</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>...</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>14</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>...</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>15</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>...</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>16</th>\n",
       "      <td>20| 179</td>\n",
       "      <td>25| 186</td>\n",
       "      <td>27| 198</td>\n",
       "      <td>19| 208</td>\n",
       "      <td>20| 217</td>\n",
       "      <td>19 | 208</td>\n",
       "      <td>24 | 207</td>\n",
       "      <td>25 | 194</td>\n",
       "      <td>25 | 188</td>\n",
       "      <td>20 | 191</td>\n",
       "      <td>...</td>\n",
       "      <td>32| 203</td>\n",
       "      <td>35| 213</td>\n",
       "      <td>27| 223</td>\n",
       "      <td>18| 215</td>\n",
       "      <td>25 | 205</td>\n",
       "      <td>23 | 219</td>\n",
       "      <td>23 | 207</td>\n",
       "      <td>20 | 198</td>\n",
       "      <td>22 | 205</td>\n",
       "      <td>20 | 208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2965</td>\n",
       "      <td>2380</td>\n",
       "      <td>1169</td>\n",
       "      <td>2908</td>\n",
       "      <td>2362</td>\n",
       "      <td>2518</td>\n",
       "      <td>2159</td>\n",
       "      <td>2776</td>\n",
       "      <td>2498</td>\n",
       "      <td>1434</td>\n",
       "      <td>...</td>\n",
       "      <td>2491</td>\n",
       "      <td>2182</td>\n",
       "      <td>2390</td>\n",
       "      <td>1048</td>\n",
       "      <td>2502</td>\n",
       "      <td>1111</td>\n",
       "      <td>2776</td>\n",
       "      <td>2393</td>\n",
       "      <td>2185</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>18 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>17 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>...</td>\n",
       "      <td>13 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>12 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>9 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>...</td>\n",
       "      <td>11 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>|</td>\n",
       "      <td>8 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>182 |</td>\n",
       "      <td>9 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</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>...</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>23</th>\n",
       "      <td>86.70%</td>\n",
       "      <td>87.81%</td>\n",
       "      <td>88.09%</td>\n",
       "      <td>86.64%</td>\n",
       "      <td>86.88%</td>\n",
       "      <td>90%</td>\n",
       "      <td>87%</td>\n",
       "      <td>88%</td>\n",
       "      <td>87%</td>\n",
       "      <td>90%</td>\n",
       "      <td>...</td>\n",
       "      <td>89%</td>\n",
       "      <td>89%</td>\n",
       "      <td>90%</td>\n",
       "      <td>90%</td>\n",
       "      <td>90%</td>\n",
       "      <td>91%</td>\n",
       "      <td>91%</td>\n",
       "      <td>91%</td>\n",
       "      <td>Not Apply%</td>\n",
       "      <td>89%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</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>...</td>\n",
       "      <td>39</td>\n",
       "      <td>44</td>\n",
       "      <td>45</td>\n",
       "      <td>46</td>\n",
       "      <td>52</td>\n",
       "      <td>53</td>\n",
       "      <td>49</td>\n",
       "      <td>50</td>\n",
       "      <td>47</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       May-19     Jun-19     Jul-19     Aug-19     Sep-19     Oct-19  \\\n",
       "0      98.50%     99.50%     97.80%     95.22%        99%     91.30%   \n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4        100%       100%       100%     96.43%     97.06%        88%   \n",
       "5      74.88%     71.28%     71.35%     72.97%     70.94%     74.32%   \n",
       "7      25.93%     22.70%     16.67%     38.13%     32.48%     46.26%   \n",
       "8         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "11          |          |          |          |          |          |   \n",
       "12     97.61%     98.22%     99.70%     99.35%     95.49%     98.18%   \n",
       "13        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "14        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "15        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "16    20| 179    25| 186    27| 198    19| 208    20| 217   19 | 208   \n",
       "17          |          |          |          |          |          |   \n",
       "18          |          |          |          |          |          |   \n",
       "19       2965       2380       1169       2908       2362       2518   \n",
       "20       18 |       16 |       16 |       16 |       15 |       15 |   \n",
       "21        6 |        7 |        6 |        6 |        6 |        6 |   \n",
       "22        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "23     86.70%     87.81%     88.09%     86.64%     86.88%        90%   \n",
       "24        NaN        NaN        NaN        NaN          1          1   \n",
       "25        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "\n",
       "       Nov-19     Dec-19     Jan-20     Feb-20  ...     Jun-20     Jul-20  \\\n",
       "0      99.50%     97.78%       100%     98.38%  ...     96.98%     97.74%   \n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "4         85%       100%       100%       100%  ...     96.15%        92%   \n",
       "5      68.82%     71.69%     64.86%     79.46%  ...     78.08%     72.47%   \n",
       "7      28.24%     37.04%     27.54%     35.71%  ...     51.03%     38.33%   \n",
       "8         NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "11          |          |          |          |  ...          |          |   \n",
       "12     98.53%     98.19%     98.76%     98.06%  ...     93.27%     95.20%   \n",
       "13        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "14        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "15        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "16   24 | 207   25 | 194   25 | 188   20 | 191  ...    32| 203    35| 213   \n",
       "17          |          |          |          |  ...          |          |   \n",
       "18          |          |          |          |  ...          |          |   \n",
       "19       2159       2776       2498       1434  ...       2491       2182   \n",
       "20       15 |       17 |       16 |       15 |  ...       13 |       14 |   \n",
       "21        8 |        9 |        8 |        8 |  ...       11 |        8 |   \n",
       "22        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "23        87%        88%        87%        90%  ...        89%        89%   \n",
       "24          2        NaN          3        NaN  ...        NaN          2   \n",
       "25        NaN        NaN        NaN        NaN  ...         39         44   \n",
       "\n",
       "       Aug-20     Sep-20     Oct-20     Nov-20     Dec-20     Jan-21  \\\n",
       "0         99%     97.32%     95.14%       100%     98.50%     91.91%   \n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4      97.37%        95%       100%       100%       100%       100%   \n",
       "5      82.37%     62.50%     80.77%     77.16%     79.40%     82.11%   \n",
       "7      56.83%     25.00%     54.40%     46.55%     53.98%     44.72%   \n",
       "8         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "11          |          |          |          |          |          |   \n",
       "12     97.84%     97.91%     98.12%     95.15%     98.33%     95.94%   \n",
       "13        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "14        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "15        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "16    27| 223    18| 215   25 | 205   23 | 219   23 | 207   20 | 198   \n",
       "17          |          |          |          |          |          |   \n",
       "18          |          |          |          |          |          |   \n",
       "19       2390       1048       2502       1111       2776       2393   \n",
       "20       14 |       15 |       14 |       14 |       16 |       15 |   \n",
       "21        7 |        7 |          |        8 |        7 |        7 |   \n",
       "22        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "23        90%        90%        90%        91%        91%        91%   \n",
       "24        NaN        NaN          1        NaN        NaN          1   \n",
       "25         45         46         52         53         49         50   \n",
       "\n",
       "        Feb-21    Mar-21  \n",
       "0       98.11%       NaN  \n",
       "1    Not Apply       NaN  \n",
       "2    Not Apply       NaN  \n",
       "3    Not Apply       NaN  \n",
       "4       95.74%       NaN  \n",
       "5       78.60%       NaN  \n",
       "7       32.88%       NaN  \n",
       "8          NaN       NaN  \n",
       "9          NaN       NaN  \n",
       "10         NaN       NaN  \n",
       "11           |         |  \n",
       "12      97.80%    95.97%  \n",
       "13         NaN       NaN  \n",
       "14         NaN       NaN  \n",
       "15         NaN       NaN  \n",
       "16    22 | 205  20 | 208  \n",
       "17           |         |  \n",
       "18           |         |  \n",
       "19        2185      1992  \n",
       "20        15 |      12 |  \n",
       "21       182 |       9 |  \n",
       "22         NaN       NaN  \n",
       "23  Not Apply%       89%  \n",
       "24         NaN       NaN  \n",
       "25          47       NaN  \n",
       "\n",
       "[25 rows x 24 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Score_Card.drop(6)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Deleting Multiple Rows using diffrent functions\n",
    "\n",
    "# i) Loc Method\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "May-19      98.50%\n",
       "Jun-19      99.50%\n",
       "Jul-19      97.80%\n",
       "Aug-19      95.22%\n",
       "Sep-19         99%\n",
       "Oct-19      91.30%\n",
       "Nov-19      99.50%\n",
       "Dec-19      97.78%\n",
       "Jan-20        100%\n",
       "Feb-20      98.38%\n",
       "Mar-20         99%\n",
       "Apr-20       97.66\n",
       "Apr-20.1    97.45%\n",
       "May-20      92.32%\n",
       "Jun-20      96.98%\n",
       "Jul-20      97.74%\n",
       "Aug-20         99%\n",
       "Sep-20      97.32%\n",
       "Oct-20      95.14%\n",
       "Nov-20        100%\n",
       "Dec-20      98.50%\n",
       "Jan-21      91.91%\n",
       "Feb-21      98.11%\n",
       "Mar-21         NaN\n",
       "Name: 0, dtype: object"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#  used for selecting things by label\n",
    "\n",
    "# The below loc[] code shows how to select the   first row of the data set/Frame:\n",
    "\n",
    "Score_Card.loc[0, :]"
   ]
  },
  {
   "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>May-19</th>\n",
       "      <th>Jun-19</th>\n",
       "      <th>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "      <th>Nov-19</th>\n",
       "      <th>Dec-19</th>\n",
       "      <th>Jan-20</th>\n",
       "      <th>Feb-20</th>\n",
       "      <th>...</th>\n",
       "      <th>Jun-20</th>\n",
       "      <th>Jul-20</th>\n",
       "      <th>Aug-20</th>\n",
       "      <th>Sep-20</th>\n",
       "      <th>Oct-20</th>\n",
       "      <th>Nov-20</th>\n",
       "      <th>Dec-20</th>\n",
       "      <th>Jan-21</th>\n",
       "      <th>Feb-21</th>\n",
       "      <th>Mar-21</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>74.88%</td>\n",
       "      <td>71.28%</td>\n",
       "      <td>71.35%</td>\n",
       "      <td>72.97%</td>\n",
       "      <td>70.94%</td>\n",
       "      <td>74.32%</td>\n",
       "      <td>68.82%</td>\n",
       "      <td>71.69%</td>\n",
       "      <td>64.86%</td>\n",
       "      <td>79.46%</td>\n",
       "      <td>...</td>\n",
       "      <td>78.08%</td>\n",
       "      <td>72.47%</td>\n",
       "      <td>82.37%</td>\n",
       "      <td>62.50%</td>\n",
       "      <td>80.77%</td>\n",
       "      <td>77.16%</td>\n",
       "      <td>79.40%</td>\n",
       "      <td>82.11%</td>\n",
       "      <td>78.60%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>71.30%</td>\n",
       "      <td>82.27%</td>\n",
       "      <td>66.67%</td>\n",
       "      <td>79.38%</td>\n",
       "      <td>82.91%</td>\n",
       "      <td>84.35%</td>\n",
       "      <td>74.12%</td>\n",
       "      <td>76.19%</td>\n",
       "      <td>75.36%</td>\n",
       "      <td>75.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>83.22%</td>\n",
       "      <td>76.21%</td>\n",
       "      <td>86.33%</td>\n",
       "      <td>83.33%</td>\n",
       "      <td>80.49%</td>\n",
       "      <td>82.76%</td>\n",
       "      <td>79.55%</td>\n",
       "      <td>82.93%</td>\n",
       "      <td>84.93%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>25.93%</td>\n",
       "      <td>22.70%</td>\n",
       "      <td>16.67%</td>\n",
       "      <td>38.13%</td>\n",
       "      <td>32.48%</td>\n",
       "      <td>46.26%</td>\n",
       "      <td>28.24%</td>\n",
       "      <td>37.04%</td>\n",
       "      <td>27.54%</td>\n",
       "      <td>35.71%</td>\n",
       "      <td>...</td>\n",
       "      <td>51.03%</td>\n",
       "      <td>38.33%</td>\n",
       "      <td>56.83%</td>\n",
       "      <td>25.00%</td>\n",
       "      <td>54.40%</td>\n",
       "      <td>46.55%</td>\n",
       "      <td>53.98%</td>\n",
       "      <td>44.72%</td>\n",
       "      <td>32.88%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</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>...</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>17</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>18 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>17 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>...</td>\n",
       "      <td>13 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>12 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>9 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>...</td>\n",
       "      <td>11 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>|</td>\n",
       "      <td>8 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>182 |</td>\n",
       "      <td>9 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</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>...</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       May-19     Jun-19     Jul-19     Aug-19     Sep-19     Oct-19  \\\n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "5      74.88%     71.28%     71.35%     72.97%     70.94%     74.32%   \n",
       "6      71.30%     82.27%     66.67%     79.38%     82.91%     84.35%   \n",
       "7      25.93%     22.70%     16.67%     38.13%     32.48%     46.26%   \n",
       "8         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "17          |          |          |          |          |          |   \n",
       "20       18 |       16 |       16 |       16 |       15 |       15 |   \n",
       "21        6 |        7 |        6 |        6 |        6 |        6 |   \n",
       "22        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "\n",
       "       Nov-19     Dec-19     Jan-20     Feb-20  ...     Jun-20     Jul-20  \\\n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "5      68.82%     71.69%     64.86%     79.46%  ...     78.08%     72.47%   \n",
       "6      74.12%     76.19%     75.36%     75.00%  ...     83.22%     76.21%   \n",
       "7      28.24%     37.04%     27.54%     35.71%  ...     51.03%     38.33%   \n",
       "8         NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "17          |          |          |          |  ...          |          |   \n",
       "20       15 |       17 |       16 |       15 |  ...       13 |       14 |   \n",
       "21        8 |        9 |        8 |        8 |  ...       11 |        8 |   \n",
       "22        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "\n",
       "       Aug-20     Sep-20     Oct-20     Nov-20     Dec-20     Jan-21  \\\n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "5      82.37%     62.50%     80.77%     77.16%     79.40%     82.11%   \n",
       "6      86.33%     83.33%     80.49%     82.76%     79.55%     82.93%   \n",
       "7      56.83%     25.00%     54.40%     46.55%     53.98%     44.72%   \n",
       "8         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "17          |          |          |          |          |          |   \n",
       "20       14 |       15 |       14 |       14 |       16 |       15 |   \n",
       "21        7 |        7 |          |        8 |        7 |        7 |   \n",
       "22        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "\n",
       "       Feb-21 Mar-21  \n",
       "1   Not Apply    NaN  \n",
       "3   Not Apply    NaN  \n",
       "5      78.60%    NaN  \n",
       "6      84.93%    NaN  \n",
       "7      32.88%    NaN  \n",
       "8         NaN    NaN  \n",
       "17          |      |  \n",
       "20       15 |   12 |  \n",
       "21      182 |    9 |  \n",
       "22        NaN    NaN  \n",
       "\n",
       "[10 rows x 24 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Selecting different  multiple Rows\n",
    "\n",
    "Score_Card.loc[[1,3,5,6,7,8,17,20,21,22], :]"
   ]
  },
  {
   "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>May-19</th>\n",
       "      <th>Jun-19</th>\n",
       "      <th>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "      <th>Nov-19</th>\n",
       "      <th>Dec-19</th>\n",
       "      <th>Jan-20</th>\n",
       "      <th>Feb-20</th>\n",
       "      <th>...</th>\n",
       "      <th>Jun-20</th>\n",
       "      <th>Jul-20</th>\n",
       "      <th>Aug-20</th>\n",
       "      <th>Sep-20</th>\n",
       "      <th>Oct-20</th>\n",
       "      <th>Nov-20</th>\n",
       "      <th>Dec-20</th>\n",
       "      <th>Jan-21</th>\n",
       "      <th>Feb-21</th>\n",
       "      <th>Mar-21</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>98.50%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.22%</td>\n",
       "      <td>99%</td>\n",
       "      <td>91.30%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.78%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.38%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.98%</td>\n",
       "      <td>97.74%</td>\n",
       "      <td>99%</td>\n",
       "      <td>97.32%</td>\n",
       "      <td>95.14%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.50%</td>\n",
       "      <td>91.91%</td>\n",
       "      <td>98.11%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "      <td>97.06%</td>\n",
       "      <td>88%</td>\n",
       "      <td>85%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.15%</td>\n",
       "      <td>92%</td>\n",
       "      <td>97.37%</td>\n",
       "      <td>95%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>95.74%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>74.88%</td>\n",
       "      <td>71.28%</td>\n",
       "      <td>71.35%</td>\n",
       "      <td>72.97%</td>\n",
       "      <td>70.94%</td>\n",
       "      <td>74.32%</td>\n",
       "      <td>68.82%</td>\n",
       "      <td>71.69%</td>\n",
       "      <td>64.86%</td>\n",
       "      <td>79.46%</td>\n",
       "      <td>...</td>\n",
       "      <td>78.08%</td>\n",
       "      <td>72.47%</td>\n",
       "      <td>82.37%</td>\n",
       "      <td>62.50%</td>\n",
       "      <td>80.77%</td>\n",
       "      <td>77.16%</td>\n",
       "      <td>79.40%</td>\n",
       "      <td>82.11%</td>\n",
       "      <td>78.60%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>71.30%</td>\n",
       "      <td>82.27%</td>\n",
       "      <td>66.67%</td>\n",
       "      <td>79.38%</td>\n",
       "      <td>82.91%</td>\n",
       "      <td>84.35%</td>\n",
       "      <td>74.12%</td>\n",
       "      <td>76.19%</td>\n",
       "      <td>75.36%</td>\n",
       "      <td>75.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>83.22%</td>\n",
       "      <td>76.21%</td>\n",
       "      <td>86.33%</td>\n",
       "      <td>83.33%</td>\n",
       "      <td>80.49%</td>\n",
       "      <td>82.76%</td>\n",
       "      <td>79.55%</td>\n",
       "      <td>82.93%</td>\n",
       "      <td>84.93%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>25.93%</td>\n",
       "      <td>22.70%</td>\n",
       "      <td>16.67%</td>\n",
       "      <td>38.13%</td>\n",
       "      <td>32.48%</td>\n",
       "      <td>46.26%</td>\n",
       "      <td>28.24%</td>\n",
       "      <td>37.04%</td>\n",
       "      <td>27.54%</td>\n",
       "      <td>35.71%</td>\n",
       "      <td>...</td>\n",
       "      <td>51.03%</td>\n",
       "      <td>38.33%</td>\n",
       "      <td>56.83%</td>\n",
       "      <td>25.00%</td>\n",
       "      <td>54.40%</td>\n",
       "      <td>46.55%</td>\n",
       "      <td>53.98%</td>\n",
       "      <td>44.72%</td>\n",
       "      <td>32.88%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</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>...</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>9</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>...</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>10</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>...</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>11</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>97.61%</td>\n",
       "      <td>98.22%</td>\n",
       "      <td>99.70%</td>\n",
       "      <td>99.35%</td>\n",
       "      <td>95.49%</td>\n",
       "      <td>98.18%</td>\n",
       "      <td>98.53%</td>\n",
       "      <td>98.19%</td>\n",
       "      <td>98.76%</td>\n",
       "      <td>98.06%</td>\n",
       "      <td>...</td>\n",
       "      <td>93.27%</td>\n",
       "      <td>95.20%</td>\n",
       "      <td>97.84%</td>\n",
       "      <td>97.91%</td>\n",
       "      <td>98.12%</td>\n",
       "      <td>95.15%</td>\n",
       "      <td>98.33%</td>\n",
       "      <td>95.94%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.97%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       May-19     Jun-19     Jul-19     Aug-19     Sep-19     Oct-19  \\\n",
       "0      98.50%     99.50%     97.80%     95.22%        99%     91.30%   \n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4        100%       100%       100%     96.43%     97.06%        88%   \n",
       "5      74.88%     71.28%     71.35%     72.97%     70.94%     74.32%   \n",
       "6      71.30%     82.27%     66.67%     79.38%     82.91%     84.35%   \n",
       "7      25.93%     22.70%     16.67%     38.13%     32.48%     46.26%   \n",
       "8         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "11          |          |          |          |          |          |   \n",
       "12     97.61%     98.22%     99.70%     99.35%     95.49%     98.18%   \n",
       "\n",
       "       Nov-19     Dec-19     Jan-20     Feb-20  ...     Jun-20     Jul-20  \\\n",
       "0      99.50%     97.78%       100%     98.38%  ...     96.98%     97.74%   \n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "4         85%       100%       100%       100%  ...     96.15%        92%   \n",
       "5      68.82%     71.69%     64.86%     79.46%  ...     78.08%     72.47%   \n",
       "6      74.12%     76.19%     75.36%     75.00%  ...     83.22%     76.21%   \n",
       "7      28.24%     37.04%     27.54%     35.71%  ...     51.03%     38.33%   \n",
       "8         NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "11          |          |          |          |  ...          |          |   \n",
       "12     98.53%     98.19%     98.76%     98.06%  ...     93.27%     95.20%   \n",
       "\n",
       "       Aug-20     Sep-20     Oct-20     Nov-20     Dec-20     Jan-21  \\\n",
       "0         99%     97.32%     95.14%       100%     98.50%     91.91%   \n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4      97.37%        95%       100%       100%       100%       100%   \n",
       "5      82.37%     62.50%     80.77%     77.16%     79.40%     82.11%   \n",
       "6      86.33%     83.33%     80.49%     82.76%     79.55%     82.93%   \n",
       "7      56.83%     25.00%     54.40%     46.55%     53.98%     44.72%   \n",
       "8         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "11          |          |          |          |          |          |   \n",
       "12     97.84%     97.91%     98.12%     95.15%     98.33%     95.94%   \n",
       "\n",
       "       Feb-21  Mar-21  \n",
       "0      98.11%     NaN  \n",
       "1   Not Apply     NaN  \n",
       "2   Not Apply     NaN  \n",
       "3   Not Apply     NaN  \n",
       "4      95.74%     NaN  \n",
       "5      78.60%     NaN  \n",
       "6      84.93%     NaN  \n",
       "7      32.88%     NaN  \n",
       "8         NaN     NaN  \n",
       "9         NaN     NaN  \n",
       "10        NaN     NaN  \n",
       "11          |       |  \n",
       "12     97.80%  95.97%  \n",
       "\n",
       "[13 rows x 24 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Another method of selecting  multiple rows \n",
    "# Nothe:  its also includes row 12\n",
    "\n",
    "Score_Card.loc[0:12, :]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        97.80%\n",
       "1     Not Apply\n",
       "2     Not Apply\n",
       "3     Not Apply\n",
       "4          100%\n",
       "5        71.35%\n",
       "6        66.67%\n",
       "7        16.67%\n",
       "8           NaN\n",
       "9           NaN\n",
       "10          NaN\n",
       "11            |\n",
       "12       99.70%\n",
       "13          NaN\n",
       "14          NaN\n",
       "15          NaN\n",
       "16      27| 198\n",
       "17            |\n",
       "18            |\n",
       "19         1169\n",
       "20         16 |\n",
       "21          6 |\n",
       "22          NaN\n",
       "23       88.09%\n",
       "24          NaN\n",
       "25          NaN\n",
       "Name: Jul-19, dtype: object"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Selecting columns using the Loc[] method\n",
    "\n",
    "Score_Card.loc[:, 'Jul-19']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.22%</td>\n",
       "      <td>99%</td>\n",
       "      <td>91.30%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "      <td>97.06%</td>\n",
       "      <td>88%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>71.35%</td>\n",
       "      <td>72.97%</td>\n",
       "      <td>70.94%</td>\n",
       "      <td>74.32%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>66.67%</td>\n",
       "      <td>79.38%</td>\n",
       "      <td>82.91%</td>\n",
       "      <td>84.35%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>16.67%</td>\n",
       "      <td>38.13%</td>\n",
       "      <td>32.48%</td>\n",
       "      <td>46.26%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>99.70%</td>\n",
       "      <td>99.35%</td>\n",
       "      <td>95.49%</td>\n",
       "      <td>98.18%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>27| 198</td>\n",
       "      <td>19| 208</td>\n",
       "      <td>20| 217</td>\n",
       "      <td>19 | 208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1169</td>\n",
       "      <td>2908</td>\n",
       "      <td>2362</td>\n",
       "      <td>2518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>88.09%</td>\n",
       "      <td>86.64%</td>\n",
       "      <td>86.88%</td>\n",
       "      <td>90%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Jul-19     Aug-19     Sep-19     Oct-19\n",
       "0      97.80%     95.22%        99%     91.30%\n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply\n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply\n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply\n",
       "4        100%     96.43%     97.06%        88%\n",
       "5      71.35%     72.97%     70.94%     74.32%\n",
       "6      66.67%     79.38%     82.91%     84.35%\n",
       "7      16.67%     38.13%     32.48%     46.26%\n",
       "8         NaN        NaN        NaN        NaN\n",
       "9         NaN        NaN        NaN        NaN\n",
       "10        NaN        NaN        NaN        NaN\n",
       "11          |          |          |          |\n",
       "12     99.70%     99.35%     95.49%     98.18%\n",
       "13        NaN        NaN        NaN        NaN\n",
       "14        NaN        NaN        NaN        NaN\n",
       "15        NaN        NaN        NaN        NaN\n",
       "16    27| 198    19| 208    20| 217   19 | 208\n",
       "17          |          |          |          |\n",
       "18          |          |          |          |\n",
       "19       1169       2908       2362       2518\n",
       "20       16 |       16 |       15 |       15 |\n",
       "21        6 |        6 |        6 |        6 |\n",
       "22        NaN        NaN        NaN        NaN\n",
       "23     88.09%     86.64%     86.88%        90%\n",
       "24        NaN        NaN          1          1\n",
       "25        NaN        NaN        NaN        NaN"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Selecting multiple columns using the Loc[] method\n",
    "\n",
    "Score_Card.loc[:, 'Jul-19':'Oct-19']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.22%</td>\n",
       "      <td>99%</td>\n",
       "      <td>91.30%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "      <td>97.06%</td>\n",
       "      <td>88%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>71.35%</td>\n",
       "      <td>72.97%</td>\n",
       "      <td>70.94%</td>\n",
       "      <td>74.32%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>66.67%</td>\n",
       "      <td>79.38%</td>\n",
       "      <td>82.91%</td>\n",
       "      <td>84.35%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Jul-19     Aug-19     Sep-19     Oct-19\n",
       "0     97.80%     95.22%        99%     91.30%\n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply\n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply\n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply\n",
       "4       100%     96.43%     97.06%        88%\n",
       "5     71.35%     72.97%     70.94%     74.32%\n",
       "6     66.67%     79.38%     82.91%     84.35%"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# You can combine Both rows and column with one function code\n",
    "\n",
    "Score_Card.loc[0:6, 'Jul-19':'Oct-19']"
   ]
  },
  {
   "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>Jun-19</th>\n",
       "      <th>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "      <th>Nov-19</th>\n",
       "      <th>Dec-19</th>\n",
       "      <th>Jan-20</th>\n",
       "      <th>Feb-20</th>\n",
       "      <th>Mar-20</th>\n",
       "      <th>...</th>\n",
       "      <th>Jun-20</th>\n",
       "      <th>Jul-20</th>\n",
       "      <th>Aug-20</th>\n",
       "      <th>Sep-20</th>\n",
       "      <th>Oct-20</th>\n",
       "      <th>Nov-20</th>\n",
       "      <th>Dec-20</th>\n",
       "      <th>Jan-21</th>\n",
       "      <th>Feb-21</th>\n",
       "      <th>Mar-21</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.22%</td>\n",
       "      <td>99%</td>\n",
       "      <td>91.30%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.78%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.38%</td>\n",
       "      <td>99%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.98%</td>\n",
       "      <td>97.74%</td>\n",
       "      <td>99%</td>\n",
       "      <td>97.32%</td>\n",
       "      <td>95.14%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.50%</td>\n",
       "      <td>91.91%</td>\n",
       "      <td>98.11%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "      <td>97.06%</td>\n",
       "      <td>88%</td>\n",
       "      <td>85%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>95.83%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.15%</td>\n",
       "      <td>92%</td>\n",
       "      <td>97.37%</td>\n",
       "      <td>95%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>95.74%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>71.28%</td>\n",
       "      <td>71.35%</td>\n",
       "      <td>72.97%</td>\n",
       "      <td>70.94%</td>\n",
       "      <td>74.32%</td>\n",
       "      <td>68.82%</td>\n",
       "      <td>71.69%</td>\n",
       "      <td>64.86%</td>\n",
       "      <td>79.46%</td>\n",
       "      <td>67.47%</td>\n",
       "      <td>...</td>\n",
       "      <td>78.08%</td>\n",
       "      <td>72.47%</td>\n",
       "      <td>82.37%</td>\n",
       "      <td>62.50%</td>\n",
       "      <td>80.77%</td>\n",
       "      <td>77.16%</td>\n",
       "      <td>79.40%</td>\n",
       "      <td>82.11%</td>\n",
       "      <td>78.60%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Jun-19     Jul-19     Aug-19     Sep-19     Oct-19     Nov-19  \\\n",
       "0     99.50%     97.80%     95.22%        99%     91.30%     99.50%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4       100%       100%     96.43%     97.06%        88%        85%   \n",
       "5     71.28%     71.35%     72.97%     70.94%     74.32%     68.82%   \n",
       "\n",
       "      Dec-19     Jan-20     Feb-20     Mar-20  ...     Jun-20     Jul-20  \\\n",
       "0     97.78%       100%     98.38%        99%  ...     96.98%     97.74%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "4       100%       100%       100%     95.83%  ...     96.15%        92%   \n",
       "5     71.69%     64.86%     79.46%     67.47%  ...     78.08%     72.47%   \n",
       "\n",
       "      Aug-20     Sep-20     Oct-20     Nov-20     Dec-20     Jan-21  \\\n",
       "0        99%     97.32%     95.14%       100%     98.50%     91.91%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4     97.37%        95%       100%       100%       100%       100%   \n",
       "5     82.37%     62.50%     80.77%     77.16%     79.40%     82.11%   \n",
       "\n",
       "      Feb-21 Mar-21  \n",
       "0     98.11%    NaN  \n",
       "1  Not Apply    NaN  \n",
       "2  Not Apply    NaN  \n",
       "3  Not Apply    NaN  \n",
       "4     95.74%    NaN  \n",
       "5     78.60%    NaN  \n",
       "\n",
       "[6 rows x 23 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# selecting multiple rows and columns without the lock menthod\n",
    "\n",
    "Score_Card.head(6).drop('May-19',axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>May-19</th>\n",
       "      <th>Aug-19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>98.50%</td>\n",
       "      <td>95.22%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>74.88%</td>\n",
       "      <td>72.97%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>71.30%</td>\n",
       "      <td>79.38%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>25.93%</td>\n",
       "      <td>38.13%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>97.61%</td>\n",
       "      <td>99.35%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>20| 179</td>\n",
       "      <td>19| 208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2965</td>\n",
       "      <td>2908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>18 |</td>\n",
       "      <td>16 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>86.70%</td>\n",
       "      <td>86.64%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       May-19     Aug-19\n",
       "0      98.50%     95.22%\n",
       "1   Not Apply  Not Apply\n",
       "2   Not Apply  Not Apply\n",
       "3   Not Apply  Not Apply\n",
       "4        100%     96.43%\n",
       "5      74.88%     72.97%\n",
       "6      71.30%     79.38%\n",
       "7      25.93%     38.13%\n",
       "8         NaN        NaN\n",
       "9         NaN        NaN\n",
       "10        NaN        NaN\n",
       "11          |          |\n",
       "12     97.61%     99.35%\n",
       "13        NaN        NaN\n",
       "14        NaN        NaN\n",
       "15        NaN        NaN\n",
       "16    20| 179    19| 208\n",
       "17          |          |\n",
       "18          |          |\n",
       "19       2965       2908\n",
       "20       18 |       16 |\n",
       "21        6 |        6 |\n",
       "22        NaN        NaN\n",
       "23     86.70%     86.64%\n",
       "24        NaN        NaN\n",
       "25        NaN        NaN"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Iloc [] Mthod\n",
    "\n",
    "# is for filtering rows and selecting columns bY Interger positon. Thats what the i stands for I.E Integer\n",
    "\n",
    "# In below I am selecting 2 specific rows using the iloc menthod\n",
    "\n",
    "\n",
    "Score_Card.iloc[:, [0,3]]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Iloc [] Mthod"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['May-19', 'Jun-19', 'Jul-19', 'Aug-19', 'Sep-19', 'Oct-19', 'Nov-19',\n",
       "       'Dec-19', 'Jan-20', 'Feb-20', 'Mar-20', 'Apr-20', 'Apr-20.1', 'May-20',\n",
       "       'Jun-20', 'Jul-20', 'Aug-20', 'Sep-20', 'Oct-20', 'Nov-20', 'Dec-20',\n",
       "       'Jan-21', 'Feb-21', 'Mar-21'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# If I want to select a Range of Columns\n",
    "\n",
    "Score_Card.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>May-19</th>\n",
       "      <th>Jun-19</th>\n",
       "      <th>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>98.50%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.22%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>74.88%</td>\n",
       "      <td>71.28%</td>\n",
       "      <td>71.35%</td>\n",
       "      <td>72.97%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>71.30%</td>\n",
       "      <td>82.27%</td>\n",
       "      <td>66.67%</td>\n",
       "      <td>79.38%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>25.93%</td>\n",
       "      <td>22.70%</td>\n",
       "      <td>16.67%</td>\n",
       "      <td>38.13%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>97.61%</td>\n",
       "      <td>98.22%</td>\n",
       "      <td>99.70%</td>\n",
       "      <td>99.35%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>20| 179</td>\n",
       "      <td>25| 186</td>\n",
       "      <td>27| 198</td>\n",
       "      <td>19| 208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2965</td>\n",
       "      <td>2380</td>\n",
       "      <td>1169</td>\n",
       "      <td>2908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>18 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>86.70%</td>\n",
       "      <td>87.81%</td>\n",
       "      <td>88.09%</td>\n",
       "      <td>86.64%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       May-19     Jun-19     Jul-19     Aug-19\n",
       "0      98.50%     99.50%     97.80%     95.22%\n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply\n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply\n",
       "3   Not Apply  Not Apply  Not Apply  Not Apply\n",
       "4        100%       100%       100%     96.43%\n",
       "5      74.88%     71.28%     71.35%     72.97%\n",
       "6      71.30%     82.27%     66.67%     79.38%\n",
       "7      25.93%     22.70%     16.67%     38.13%\n",
       "8         NaN        NaN        NaN        NaN\n",
       "9         NaN        NaN        NaN        NaN\n",
       "10        NaN        NaN        NaN        NaN\n",
       "11          |          |          |          |\n",
       "12     97.61%     98.22%     99.70%     99.35%\n",
       "13        NaN        NaN        NaN        NaN\n",
       "14        NaN        NaN        NaN        NaN\n",
       "15        NaN        NaN        NaN        NaN\n",
       "16    20| 179    25| 186    27| 198    19| 208\n",
       "17          |          |          |          |\n",
       "18          |          |          |          |\n",
       "19       2965       2380       1169       2908\n",
       "20       18 |       16 |       16 |       16 |\n",
       "21        6 |        7 |        6 |        6 |\n",
       "22        NaN        NaN        NaN        NaN\n",
       "23     86.70%     87.81%     88.09%     86.64%\n",
       "24        NaN        NaN        NaN        NaN\n",
       "25        NaN        NaN        NaN        NaN"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Score_Card.iloc[:, 0:4]"
   ]
  },
  {
   "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>May-19</th>\n",
       "      <th>Jun-19</th>\n",
       "      <th>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "      <th>Nov-19</th>\n",
       "      <th>Dec-19</th>\n",
       "      <th>Jan-20</th>\n",
       "      <th>Feb-20</th>\n",
       "      <th>...</th>\n",
       "      <th>Jun-20</th>\n",
       "      <th>Jul-20</th>\n",
       "      <th>Aug-20</th>\n",
       "      <th>Sep-20</th>\n",
       "      <th>Oct-20</th>\n",
       "      <th>Nov-20</th>\n",
       "      <th>Dec-20</th>\n",
       "      <th>Jan-21</th>\n",
       "      <th>Feb-21</th>\n",
       "      <th>Mar-21</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>98.50%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.22%</td>\n",
       "      <td>99%</td>\n",
       "      <td>91.30%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.78%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.38%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.98%</td>\n",
       "      <td>97.74%</td>\n",
       "      <td>99%</td>\n",
       "      <td>97.32%</td>\n",
       "      <td>95.14%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.50%</td>\n",
       "      <td>91.91%</td>\n",
       "      <td>98.11%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "      <td>97.06%</td>\n",
       "      <td>88%</td>\n",
       "      <td>85%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.15%</td>\n",
       "      <td>92%</td>\n",
       "      <td>97.37%</td>\n",
       "      <td>95%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>95.74%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      May-19     Jun-19     Jul-19     Aug-19     Sep-19     Oct-19  \\\n",
       "0     98.50%     99.50%     97.80%     95.22%        99%     91.30%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4       100%       100%       100%     96.43%     97.06%        88%   \n",
       "\n",
       "      Nov-19     Dec-19     Jan-20     Feb-20  ...     Jun-20     Jul-20  \\\n",
       "0     99.50%     97.78%       100%     98.38%  ...     96.98%     97.74%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "4        85%       100%       100%       100%  ...     96.15%        92%   \n",
       "\n",
       "      Aug-20     Sep-20     Oct-20     Nov-20     Dec-20     Jan-21  \\\n",
       "0        99%     97.32%     95.14%       100%     98.50%     91.91%   \n",
       "1  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "3  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4     97.37%        95%       100%       100%       100%       100%   \n",
       "\n",
       "      Feb-21 Mar-21  \n",
       "0     98.11%    NaN  \n",
       "1  Not Apply    NaN  \n",
       "2  Not Apply    NaN  \n",
       "3  Not Apply    NaN  \n",
       "4     95.74%    NaN  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Selecting multiple rows using the Ilock menthod\n",
    "\n",
    "# Note that it does not select Row 5\n",
    "\n",
    " \n",
    "Score_Card.iloc[0:5, :]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# This show the diffence in selcting rows and columns while using both the lock[]  and ilock[] method\n",
    "\n",
    "# lock[] method is used for labels, Ilock[] for integer position\n",
    "\n",
    "# Lock[] when you do ranges because it inludes both sides, While Ilock  is inclussive on the start and exclussive of the stop"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Combing Columns in a DataFrame or Data set"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Note that we no longer have row 0 in our new data set New_Score . \n",
    "\n",
    "New_Score = Score_Card.drop(3)"
   ]
  },
  {
   "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>May-19</th>\n",
       "      <th>Jun-19</th>\n",
       "      <th>Jul-19</th>\n",
       "      <th>Aug-19</th>\n",
       "      <th>Sep-19</th>\n",
       "      <th>Oct-19</th>\n",
       "      <th>Nov-19</th>\n",
       "      <th>Dec-19</th>\n",
       "      <th>Jan-20</th>\n",
       "      <th>Feb-20</th>\n",
       "      <th>...</th>\n",
       "      <th>Jun-20</th>\n",
       "      <th>Jul-20</th>\n",
       "      <th>Aug-20</th>\n",
       "      <th>Sep-20</th>\n",
       "      <th>Oct-20</th>\n",
       "      <th>Nov-20</th>\n",
       "      <th>Dec-20</th>\n",
       "      <th>Jan-21</th>\n",
       "      <th>Feb-21</th>\n",
       "      <th>Mar-21</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>98.50%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.22%</td>\n",
       "      <td>99%</td>\n",
       "      <td>91.30%</td>\n",
       "      <td>99.50%</td>\n",
       "      <td>97.78%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.38%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.98%</td>\n",
       "      <td>97.74%</td>\n",
       "      <td>99%</td>\n",
       "      <td>97.32%</td>\n",
       "      <td>95.14%</td>\n",
       "      <td>100%</td>\n",
       "      <td>98.50%</td>\n",
       "      <td>91.91%</td>\n",
       "      <td>98.11%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>Not Apply</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>96.43%</td>\n",
       "      <td>97.06%</td>\n",
       "      <td>88%</td>\n",
       "      <td>85%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>...</td>\n",
       "      <td>96.15%</td>\n",
       "      <td>92%</td>\n",
       "      <td>97.37%</td>\n",
       "      <td>95%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>100%</td>\n",
       "      <td>95.74%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>74.88%</td>\n",
       "      <td>71.28%</td>\n",
       "      <td>71.35%</td>\n",
       "      <td>72.97%</td>\n",
       "      <td>70.94%</td>\n",
       "      <td>74.32%</td>\n",
       "      <td>68.82%</td>\n",
       "      <td>71.69%</td>\n",
       "      <td>64.86%</td>\n",
       "      <td>79.46%</td>\n",
       "      <td>...</td>\n",
       "      <td>78.08%</td>\n",
       "      <td>72.47%</td>\n",
       "      <td>82.37%</td>\n",
       "      <td>62.50%</td>\n",
       "      <td>80.77%</td>\n",
       "      <td>77.16%</td>\n",
       "      <td>79.40%</td>\n",
       "      <td>82.11%</td>\n",
       "      <td>78.60%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>71.30%</td>\n",
       "      <td>82.27%</td>\n",
       "      <td>66.67%</td>\n",
       "      <td>79.38%</td>\n",
       "      <td>82.91%</td>\n",
       "      <td>84.35%</td>\n",
       "      <td>74.12%</td>\n",
       "      <td>76.19%</td>\n",
       "      <td>75.36%</td>\n",
       "      <td>75.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>83.22%</td>\n",
       "      <td>76.21%</td>\n",
       "      <td>86.33%</td>\n",
       "      <td>83.33%</td>\n",
       "      <td>80.49%</td>\n",
       "      <td>82.76%</td>\n",
       "      <td>79.55%</td>\n",
       "      <td>82.93%</td>\n",
       "      <td>84.93%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>25.93%</td>\n",
       "      <td>22.70%</td>\n",
       "      <td>16.67%</td>\n",
       "      <td>38.13%</td>\n",
       "      <td>32.48%</td>\n",
       "      <td>46.26%</td>\n",
       "      <td>28.24%</td>\n",
       "      <td>37.04%</td>\n",
       "      <td>27.54%</td>\n",
       "      <td>35.71%</td>\n",
       "      <td>...</td>\n",
       "      <td>51.03%</td>\n",
       "      <td>38.33%</td>\n",
       "      <td>56.83%</td>\n",
       "      <td>25.00%</td>\n",
       "      <td>54.40%</td>\n",
       "      <td>46.55%</td>\n",
       "      <td>53.98%</td>\n",
       "      <td>44.72%</td>\n",
       "      <td>32.88%</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</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>...</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>9</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>...</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>10</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>...</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>11</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>97.61%</td>\n",
       "      <td>98.22%</td>\n",
       "      <td>99.70%</td>\n",
       "      <td>99.35%</td>\n",
       "      <td>95.49%</td>\n",
       "      <td>98.18%</td>\n",
       "      <td>98.53%</td>\n",
       "      <td>98.19%</td>\n",
       "      <td>98.76%</td>\n",
       "      <td>98.06%</td>\n",
       "      <td>...</td>\n",
       "      <td>93.27%</td>\n",
       "      <td>95.20%</td>\n",
       "      <td>97.84%</td>\n",
       "      <td>97.91%</td>\n",
       "      <td>98.12%</td>\n",
       "      <td>95.15%</td>\n",
       "      <td>98.33%</td>\n",
       "      <td>95.94%</td>\n",
       "      <td>97.80%</td>\n",
       "      <td>95.97%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</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>...</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>14</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>...</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>15</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>...</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>16</th>\n",
       "      <td>20| 179</td>\n",
       "      <td>25| 186</td>\n",
       "      <td>27| 198</td>\n",
       "      <td>19| 208</td>\n",
       "      <td>20| 217</td>\n",
       "      <td>19 | 208</td>\n",
       "      <td>24 | 207</td>\n",
       "      <td>25 | 194</td>\n",
       "      <td>25 | 188</td>\n",
       "      <td>20 | 191</td>\n",
       "      <td>...</td>\n",
       "      <td>32| 203</td>\n",
       "      <td>35| 213</td>\n",
       "      <td>27| 223</td>\n",
       "      <td>18| 215</td>\n",
       "      <td>25 | 205</td>\n",
       "      <td>23 | 219</td>\n",
       "      <td>23 | 207</td>\n",
       "      <td>20 | 198</td>\n",
       "      <td>22 | 205</td>\n",
       "      <td>20 | 208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>...</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "      <td>|</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2965</td>\n",
       "      <td>2380</td>\n",
       "      <td>1169</td>\n",
       "      <td>2908</td>\n",
       "      <td>2362</td>\n",
       "      <td>2518</td>\n",
       "      <td>2159</td>\n",
       "      <td>2776</td>\n",
       "      <td>2498</td>\n",
       "      <td>1434</td>\n",
       "      <td>...</td>\n",
       "      <td>2491</td>\n",
       "      <td>2182</td>\n",
       "      <td>2390</td>\n",
       "      <td>1048</td>\n",
       "      <td>2502</td>\n",
       "      <td>1111</td>\n",
       "      <td>2776</td>\n",
       "      <td>2393</td>\n",
       "      <td>2185</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>18 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>17 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>...</td>\n",
       "      <td>13 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>14 |</td>\n",
       "      <td>16 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>15 |</td>\n",
       "      <td>12 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>6 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>9 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>...</td>\n",
       "      <td>11 |</td>\n",
       "      <td>8 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>|</td>\n",
       "      <td>8 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>7 |</td>\n",
       "      <td>182 |</td>\n",
       "      <td>9 |</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</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>...</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>23</th>\n",
       "      <td>86.70%</td>\n",
       "      <td>87.81%</td>\n",
       "      <td>88.09%</td>\n",
       "      <td>86.64%</td>\n",
       "      <td>86.88%</td>\n",
       "      <td>90%</td>\n",
       "      <td>87%</td>\n",
       "      <td>88%</td>\n",
       "      <td>87%</td>\n",
       "      <td>90%</td>\n",
       "      <td>...</td>\n",
       "      <td>89%</td>\n",
       "      <td>89%</td>\n",
       "      <td>90%</td>\n",
       "      <td>90%</td>\n",
       "      <td>90%</td>\n",
       "      <td>91%</td>\n",
       "      <td>91%</td>\n",
       "      <td>91%</td>\n",
       "      <td>Not Apply%</td>\n",
       "      <td>89%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</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>...</td>\n",
       "      <td>39</td>\n",
       "      <td>44</td>\n",
       "      <td>45</td>\n",
       "      <td>46</td>\n",
       "      <td>52</td>\n",
       "      <td>53</td>\n",
       "      <td>49</td>\n",
       "      <td>50</td>\n",
       "      <td>47</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       May-19     Jun-19     Jul-19     Aug-19     Sep-19     Oct-19  \\\n",
       "0      98.50%     99.50%     97.80%     95.22%        99%     91.30%   \n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4        100%       100%       100%     96.43%     97.06%        88%   \n",
       "5      74.88%     71.28%     71.35%     72.97%     70.94%     74.32%   \n",
       "6      71.30%     82.27%     66.67%     79.38%     82.91%     84.35%   \n",
       "7      25.93%     22.70%     16.67%     38.13%     32.48%     46.26%   \n",
       "8         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "11          |          |          |          |          |          |   \n",
       "12     97.61%     98.22%     99.70%     99.35%     95.49%     98.18%   \n",
       "13        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "14        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "15        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "16    20| 179    25| 186    27| 198    19| 208    20| 217   19 | 208   \n",
       "17          |          |          |          |          |          |   \n",
       "18          |          |          |          |          |          |   \n",
       "19       2965       2380       1169       2908       2362       2518   \n",
       "20       18 |       16 |       16 |       16 |       15 |       15 |   \n",
       "21        6 |        7 |        6 |        6 |        6 |        6 |   \n",
       "22        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "23     86.70%     87.81%     88.09%     86.64%     86.88%        90%   \n",
       "24        NaN        NaN        NaN        NaN          1          1   \n",
       "25        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "\n",
       "       Nov-19     Dec-19     Jan-20     Feb-20  ...     Jun-20     Jul-20  \\\n",
       "0      99.50%     97.78%       100%     98.38%  ...     96.98%     97.74%   \n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  ...  Not Apply  Not Apply   \n",
       "4         85%       100%       100%       100%  ...     96.15%        92%   \n",
       "5      68.82%     71.69%     64.86%     79.46%  ...     78.08%     72.47%   \n",
       "6      74.12%     76.19%     75.36%     75.00%  ...     83.22%     76.21%   \n",
       "7      28.24%     37.04%     27.54%     35.71%  ...     51.03%     38.33%   \n",
       "8         NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "11          |          |          |          |  ...          |          |   \n",
       "12     98.53%     98.19%     98.76%     98.06%  ...     93.27%     95.20%   \n",
       "13        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "14        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "15        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "16   24 | 207   25 | 194   25 | 188   20 | 191  ...    32| 203    35| 213   \n",
       "17          |          |          |          |  ...          |          |   \n",
       "18          |          |          |          |  ...          |          |   \n",
       "19       2159       2776       2498       1434  ...       2491       2182   \n",
       "20       15 |       17 |       16 |       15 |  ...       13 |       14 |   \n",
       "21        8 |        9 |        8 |        8 |  ...       11 |        8 |   \n",
       "22        NaN        NaN        NaN        NaN  ...        NaN        NaN   \n",
       "23        87%        88%        87%        90%  ...        89%        89%   \n",
       "24          2        NaN          3        NaN  ...        NaN          2   \n",
       "25        NaN        NaN        NaN        NaN  ...         39         44   \n",
       "\n",
       "       Aug-20     Sep-20     Oct-20     Nov-20     Dec-20     Jan-21  \\\n",
       "0         99%     97.32%     95.14%       100%     98.50%     91.91%   \n",
       "1   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "2   Not Apply  Not Apply  Not Apply  Not Apply  Not Apply  Not Apply   \n",
       "4      97.37%        95%       100%       100%       100%       100%   \n",
       "5      82.37%     62.50%     80.77%     77.16%     79.40%     82.11%   \n",
       "6      86.33%     83.33%     80.49%     82.76%     79.55%     82.93%   \n",
       "7      56.83%     25.00%     54.40%     46.55%     53.98%     44.72%   \n",
       "8         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "9         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "10        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "11          |          |          |          |          |          |   \n",
       "12     97.84%     97.91%     98.12%     95.15%     98.33%     95.94%   \n",
       "13        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "14        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "15        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "16    27| 223    18| 215   25 | 205   23 | 219   23 | 207   20 | 198   \n",
       "17          |          |          |          |          |          |   \n",
       "18          |          |          |          |          |          |   \n",
       "19       2390       1048       2502       1111       2776       2393   \n",
       "20       14 |       15 |       14 |       14 |       16 |       15 |   \n",
       "21        7 |        7 |          |        8 |        7 |        7 |   \n",
       "22        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "23        90%        90%        90%        91%        91%        91%   \n",
       "24        NaN        NaN          1        NaN        NaN          1   \n",
       "25         45         46         52         53         49         50   \n",
       "\n",
       "        Feb-21    Mar-21  \n",
       "0       98.11%       NaN  \n",
       "1    Not Apply       NaN  \n",
       "2    Not Apply       NaN  \n",
       "4       95.74%       NaN  \n",
       "5       78.60%       NaN  \n",
       "6       84.93%       NaN  \n",
       "7       32.88%       NaN  \n",
       "8          NaN       NaN  \n",
       "9          NaN       NaN  \n",
       "10         NaN       NaN  \n",
       "11           |         |  \n",
       "12      97.80%    95.97%  \n",
       "13         NaN       NaN  \n",
       "14         NaN       NaN  \n",
       "15         NaN       NaN  \n",
       "16    22 | 205  20 | 208  \n",
       "17           |         |  \n",
       "18           |         |  \n",
       "19        2185      1992  \n",
       "20        15 |      12 |  \n",
       "21       182 |       9 |  \n",
       "22         NaN       NaN  \n",
       "23  Not Apply%       89%  \n",
       "24         NaN       NaN  \n",
       "25          47       NaN  \n",
       "\n",
       "[25 rows x 24 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "New_Score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "# I am trying  to merge two columns  of a single data set to see if the code works for me before we begin the merge operation\n",
    "\n",
    "# Below are some of the different ways to merge columns without the merge function()\n",
    "\n",
    "New_Score[\"KPI\"] = New_Score[\"Jun-19\"].astype(str) + New_Score[\"Sep-19\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0              99.50%99%\n",
       "1     Not ApplyNot Apply\n",
       "2     Not ApplyNot Apply\n",
       "4             100%97.06%\n",
       "5           71.28%70.94%\n",
       "6           82.27%82.91%\n",
       "7           22.70%32.48%\n",
       "8                    NaN\n",
       "9                    NaN\n",
       "10                   NaN\n",
       "11                    ||\n",
       "12          98.22%95.49%\n",
       "13                   NaN\n",
       "14                   NaN\n",
       "15                   NaN\n",
       "16        25| 18620| 217\n",
       "17                    ||\n",
       "18                    ||\n",
       "19              23802362\n",
       "20              16 |15 |\n",
       "21                7 |6 |\n",
       "22                   NaN\n",
       "23          87.81%86.88%\n",
       "24                  nan1\n",
       "25                   NaN\n",
       "Name: KPI, dtype: object"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "New_Score[\"KPI\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Other Format and This one will work for me\n",
    "\n",
    "New_Score['All_Kpi'] =  New_Score['Jun-19'] + '-' + New_Score['Sep-19'].astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0              99.50%-99%\n",
       "1     Not Apply-Not Apply\n",
       "2     Not Apply-Not Apply\n",
       "4             100%-97.06%\n",
       "5           71.28%-70.94%\n",
       "6           82.27%-82.91%\n",
       "7           22.70%-32.48%\n",
       "8                     NaN\n",
       "9                     NaN\n",
       "10                    NaN\n",
       "11                    |-|\n",
       "12          98.22%-95.49%\n",
       "13                    NaN\n",
       "14                    NaN\n",
       "15                    NaN\n",
       "16        25| 186-20| 217\n",
       "17                    |-|\n",
       "18                    |-|\n",
       "19              2380-2362\n",
       "20              16 |-15 |\n",
       "21                7 |-6 |\n",
       "22                    NaN\n",
       "23          87.81%-86.88%\n",
       "24                    NaN\n",
       "25                    NaN\n",
       "Name: All_Kpi, dtype: object"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "New_Score['All_Kpi']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "New_Score['All_Kpi'] =  New_Score['Jun-19'] + '-' + New_Score['Sep-19']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0              99.50%-99%\n",
       "1     Not Apply-Not Apply\n",
       "2     Not Apply-Not Apply\n",
       "4             100%-97.06%\n",
       "5           71.28%-70.94%\n",
       "6           82.27%-82.91%\n",
       "7           22.70%-32.48%\n",
       "8                     NaN\n",
       "9                     NaN\n",
       "10                    NaN\n",
       "11                    |-|\n",
       "12          98.22%-95.49%\n",
       "13                    NaN\n",
       "14                    NaN\n",
       "15                    NaN\n",
       "16        25| 186-20| 217\n",
       "17                    |-|\n",
       "18                    |-|\n",
       "19              2380-2362\n",
       "20              16 |-15 |\n",
       "21                7 |-6 |\n",
       "22                    NaN\n",
       "23          87.81%-86.88%\n",
       "24                    NaN\n",
       "25                    NaN\n",
       "Name: All_Kpi, dtype: object"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "New_Score['All_Kpi']"
   ]
  }
 ],
 "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}