TBP_python.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Importing the required libraries\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "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>S.no</th>\n",
       "      <th>current_electrode_distace(l/2)</th>\n",
       "      <th>potential_electrode_distance(b/2)</th>\n",
       "      <th>direct_voltmeter_reading(v1)</th>\n",
       "      <th>reverse_voltmeter_reading(v2)</th>\n",
       "      <th>direct_currentmeter_reading(i1)</th>\n",
       "      <th>reverse_currentmeter_reading(i2)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>211</td>\n",
       "      <td>213</td>\n",
       "      <td>43.5</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>38</td>\n",
       "      <td>40</td>\n",
       "      <td>17.6</td>\n",
       "      <td>18.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>25</td>\n",
       "      <td>26</td>\n",
       "      <td>21.2</td>\n",
       "      <td>21.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>12.6</td>\n",
       "      <td>12.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30</td>\n",
       "      <td>28</td>\n",
       "      <td>30.1</td>\n",
       "      <td>29.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16</td>\n",
       "      <td>15</td>\n",
       "      <td>30.3</td>\n",
       "      <td>30.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>15.3</td>\n",
       "      <td>23.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>30.8</td>\n",
       "      <td>37.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>20</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>26.9</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>30</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>38.3</td>\n",
       "      <td>36.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>4.0</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>79.7</td>\n",
       "      <td>72.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>50</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>26.6</td>\n",
       "      <td>33.9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    S.no  current_electrode_distace(l/2)  potential_electrode_distance(b/2)  \\\n",
       "0      1                               2                                0.5   \n",
       "1      2                               3                                0.5   \n",
       "2      3                               4                                0.5   \n",
       "3      4                               5                                0.5   \n",
       "4      5                               6                                1.0   \n",
       "5      6                               8                                1.0   \n",
       "6      7                              10                                1.0   \n",
       "7      8                              15                                2.0   \n",
       "8      9                              20                                2.0   \n",
       "9     10                              30                                4.0   \n",
       "10    11                              40                                4.0   \n",
       "11    12                              50                                4.0   \n",
       "\n",
       "    direct_voltmeter_reading(v1)  reverse_voltmeter_reading(v2)  \\\n",
       "0                            211                            213   \n",
       "1                             38                             40   \n",
       "2                             25                             26   \n",
       "3                              9                              9   \n",
       "4                             30                             28   \n",
       "5                             16                             15   \n",
       "6                              7                              7   \n",
       "7                             11                             13   \n",
       "8                              5                              4   \n",
       "9                              8                              8   \n",
       "10                            10                              8   \n",
       "11                             3                              3   \n",
       "\n",
       "    direct_currentmeter_reading(i1)  reverse_currentmeter_reading(i2)  \n",
       "0                              43.5                              44.0  \n",
       "1                              17.6                              18.1  \n",
       "2                              21.2                              21.6  \n",
       "3                              12.6                              12.9  \n",
       "4                              30.1                              29.9  \n",
       "5                              30.3                              30.4  \n",
       "6                              15.3                              23.6  \n",
       "7                              30.8                              37.5  \n",
       "8                              26.9                              22.0  \n",
       "9                              38.3                              36.5  \n",
       "10                             79.7                              72.6  \n",
       "11                             26.6                              33.9  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#importing the data into the environment\n",
    "ExptData = pd.read_excel(\"VES1.xlsx\")\n",
    "ExptData"
   ]
  },
  {
   "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>S.no</th>\n",
       "      <th>current_electrode_distace(l/2)</th>\n",
       "      <th>potential_electrode_distance(b/2)</th>\n",
       "      <th>direct_voltmeter_reading(v1)</th>\n",
       "      <th>reverse_voltmeter_reading(v2)</th>\n",
       "      <th>direct_currentmeter_reading(i1)</th>\n",
       "      <th>reverse_currentmeter_reading(i2)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     S.no  current_electrode_distace(l/2)  potential_electrode_distance(b/2)  \\\n",
       "0   False                           False                              False   \n",
       "1   False                           False                              False   \n",
       "2   False                           False                              False   \n",
       "3   False                           False                              False   \n",
       "4   False                           False                              False   \n",
       "5   False                           False                              False   \n",
       "6   False                           False                              False   \n",
       "7   False                           False                              False   \n",
       "8   False                           False                              False   \n",
       "9   False                           False                              False   \n",
       "10  False                           False                              False   \n",
       "11  False                           False                              False   \n",
       "\n",
       "    direct_voltmeter_reading(v1)  reverse_voltmeter_reading(v2)  \\\n",
       "0                          False                          False   \n",
       "1                          False                          False   \n",
       "2                          False                          False   \n",
       "3                          False                          False   \n",
       "4                          False                          False   \n",
       "5                          False                          False   \n",
       "6                          False                          False   \n",
       "7                          False                          False   \n",
       "8                          False                          False   \n",
       "9                          False                          False   \n",
       "10                         False                          False   \n",
       "11                         False                          False   \n",
       "\n",
       "    direct_currentmeter_reading(i1)  reverse_currentmeter_reading(i2)  \n",
       "0                             False                             False  \n",
       "1                             False                             False  \n",
       "2                             False                             False  \n",
       "3                             False                             False  \n",
       "4                             False                             False  \n",
       "5                             False                             False  \n",
       "6                             False                             False  \n",
       "7                             False                             False  \n",
       "8                             False                             False  \n",
       "9                             False                             False  \n",
       "10                            False                             False  \n",
       "11                            False                             False  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Checking for missing values or null values from the data imported\n",
    "pd.isnull(ExptData)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n"
     ]
    }
   ],
   "source": [
    "#Checking the type and dimensionalities \n",
    "print(type(ExptData))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "7\n",
      "(12, 7)\n"
     ]
    }
   ],
   "source": [
    "print(len(ExptData.columns))\n",
    "print(ExptData.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>S.no</th>\n",
       "      <th>current_electrode_distace(l/2)</th>\n",
       "      <th>potential_electrode_distance(b/2)</th>\n",
       "      <th>direct_voltmeter_reading(v1)</th>\n",
       "      <th>reverse_voltmeter_reading(v2)</th>\n",
       "      <th>direct_currentmeter_reading(i1)</th>\n",
       "      <th>reverse_currentmeter_reading(i2)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>12.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>12.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>6.500000</td>\n",
       "      <td>16.083333</td>\n",
       "      <td>1.750000</td>\n",
       "      <td>31.083333</td>\n",
       "      <td>31.166667</td>\n",
       "      <td>31.075000</td>\n",
       "      <td>31.916667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>3.605551</td>\n",
       "      <td>15.882857</td>\n",
       "      <td>1.453835</td>\n",
       "      <td>57.683239</td>\n",
       "      <td>58.348223</td>\n",
       "      <td>17.784882</td>\n",
       "      <td>15.638230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>12.600000</td>\n",
       "      <td>12.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>3.750000</td>\n",
       "      <td>4.750000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>7.750000</td>\n",
       "      <td>7.750000</td>\n",
       "      <td>20.300000</td>\n",
       "      <td>21.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>6.500000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>10.500000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>28.500000</td>\n",
       "      <td>30.150000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>9.250000</td>\n",
       "      <td>22.500000</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>26.250000</td>\n",
       "      <td>26.500000</td>\n",
       "      <td>32.675000</td>\n",
       "      <td>36.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>12.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>211.000000</td>\n",
       "      <td>213.000000</td>\n",
       "      <td>79.700000</td>\n",
       "      <td>72.600000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            S.no  current_electrode_distace(l/2)  \\\n",
       "count  12.000000                       12.000000   \n",
       "mean    6.500000                       16.083333   \n",
       "std     3.605551                       15.882857   \n",
       "min     1.000000                        2.000000   \n",
       "25%     3.750000                        4.750000   \n",
       "50%     6.500000                        9.000000   \n",
       "75%     9.250000                       22.500000   \n",
       "max    12.000000                       50.000000   \n",
       "\n",
       "       potential_electrode_distance(b/2)  direct_voltmeter_reading(v1)  \\\n",
       "count                          12.000000                     12.000000   \n",
       "mean                            1.750000                     31.083333   \n",
       "std                             1.453835                     57.683239   \n",
       "min                             0.500000                      3.000000   \n",
       "25%                             0.500000                      7.750000   \n",
       "50%                             1.000000                     10.500000   \n",
       "75%                             2.500000                     26.250000   \n",
       "max                             4.000000                    211.000000   \n",
       "\n",
       "       reverse_voltmeter_reading(v2)  direct_currentmeter_reading(i1)  \\\n",
       "count                      12.000000                        12.000000   \n",
       "mean                       31.166667                        31.075000   \n",
       "std                        58.348223                        17.784882   \n",
       "min                         3.000000                        12.600000   \n",
       "25%                         7.750000                        20.300000   \n",
       "50%                        11.000000                        28.500000   \n",
       "75%                        26.500000                        32.675000   \n",
       "max                       213.000000                        79.700000   \n",
       "\n",
       "       reverse_currentmeter_reading(i2)  \n",
       "count                         12.000000  \n",
       "mean                          31.916667  \n",
       "std                           15.638230  \n",
       "min                           12.900000  \n",
       "25%                           21.900000  \n",
       "50%                           30.150000  \n",
       "75%                           36.750000  \n",
       "max                           72.600000  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ExptData.describe() #Understanding the summary of the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Renaming or assigning row names for the sake of mitigating ambiguity\n",
    "ExptData = ExptData.rename(columns = {\"current_electrode_distace(l/2)\" : \"current_ed\", \"potential_electrode_distance(b/2)\" : \"potential_ed\", \n",
    "                                \"direct_voltmeter_reading(v1)\" : \"vr_direct\", \"reverse_voltmeter_reading(v2)\" : \"vr_reverse\", \n",
    "                                \"direct_currentmeter_reading(i1)\" : \"cr_direct\", \"reverse_currentmeter_reading(i2)\" : \"cr_reverse\"})"
   ]
  },
  {
   "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>S.no</th>\n",
       "      <th>current_ed</th>\n",
       "      <th>potential_ed</th>\n",
       "      <th>vr_direct</th>\n",
       "      <th>vr_reverse</th>\n",
       "      <th>cr_direct</th>\n",
       "      <th>cr_reverse</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>211</td>\n",
       "      <td>213</td>\n",
       "      <td>43.5</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>38</td>\n",
       "      <td>40</td>\n",
       "      <td>17.6</td>\n",
       "      <td>18.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>25</td>\n",
       "      <td>26</td>\n",
       "      <td>21.2</td>\n",
       "      <td>21.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>12.6</td>\n",
       "      <td>12.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30</td>\n",
       "      <td>28</td>\n",
       "      <td>30.1</td>\n",
       "      <td>29.9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   S.no  current_ed  potential_ed  vr_direct  vr_reverse  cr_direct  \\\n",
       "0     1           2           0.5        211         213       43.5   \n",
       "1     2           3           0.5         38          40       17.6   \n",
       "2     3           4           0.5         25          26       21.2   \n",
       "3     4           5           0.5          9           9       12.6   \n",
       "4     5           6           1.0         30          28       30.1   \n",
       "\n",
       "   cr_reverse  \n",
       "0        44.0  \n",
       "1        18.1  \n",
       "2        21.6  \n",
       "3        12.9  \n",
       "4        29.9  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Checking the first and last 5 rows of the DataFrame\n",
    "ExptData.head() #first 5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>S.no</th>\n",
       "      <th>current_ed</th>\n",
       "      <th>potential_ed</th>\n",
       "      <th>vr_direct</th>\n",
       "      <th>vr_reverse</th>\n",
       "      <th>cr_direct</th>\n",
       "      <th>cr_reverse</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>30.8</td>\n",
       "      <td>37.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>20</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>26.9</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>30</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>38.3</td>\n",
       "      <td>36.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>4.0</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>79.7</td>\n",
       "      <td>72.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>50</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>26.6</td>\n",
       "      <td>33.9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    S.no  current_ed  potential_ed  vr_direct  vr_reverse  cr_direct  \\\n",
       "7      8          15           2.0         11          13       30.8   \n",
       "8      9          20           2.0          5           4       26.9   \n",
       "9     10          30           4.0          8           8       38.3   \n",
       "10    11          40           4.0         10           8       79.7   \n",
       "11    12          50           4.0          3           3       26.6   \n",
       "\n",
       "    cr_reverse  \n",
       "7         37.5  \n",
       "8         22.0  \n",
       "9         36.5  \n",
       "10        72.6  \n",
       "11        33.9  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ExptData.tail() #bottom 5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Performing calculations required on the columns\n",
    "#Mutating and adding additional columns to the existing dataframe\n",
    "\n",
    "ExptData[\"Avg_pd\"] = (ExptData[\"vr_direct\"] + ExptData[\"vr_reverse\"])/2\n",
    "ExptData[\"Avg_curr\"] = (ExptData[\"cr_direct\"] + ExptData[\"cr_reverse\"])/2\n",
    "ExptData[\"R\"] = ExptData[\"Avg_pd\"]/ ExptData[\"Avg_curr\"] \n",
    "ExptData[\"K\"] = ((np.pi * ((ExptData[\"current_ed\"] ** 2)) - (ExptData[\"potential_ed\"] ** 2))/ (ExptData[\"potential_ed\"] * 2))\n",
    "ExptData[\"Apparent_res\"] = ExptData[\"K\"] * ExptData[\"R\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Rounding the values upto 3 decimal places\n",
    "ExptData = round(ExptData, 3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>S.no</th>\n",
       "      <th>current_ed</th>\n",
       "      <th>potential_ed</th>\n",
       "      <th>vr_direct</th>\n",
       "      <th>vr_reverse</th>\n",
       "      <th>cr_direct</th>\n",
       "      <th>cr_reverse</th>\n",
       "      <th>Avg_pd</th>\n",
       "      <th>Avg_curr</th>\n",
       "      <th>R</th>\n",
       "      <th>K</th>\n",
       "      <th>Apparent_res</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>211</td>\n",
       "      <td>213</td>\n",
       "      <td>43.5</td>\n",
       "      <td>44.0</td>\n",
       "      <td>212.0</td>\n",
       "      <td>43.75</td>\n",
       "      <td>4.846</td>\n",
       "      <td>12.316</td>\n",
       "      <td>59.682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>38</td>\n",
       "      <td>40</td>\n",
       "      <td>17.6</td>\n",
       "      <td>18.1</td>\n",
       "      <td>39.0</td>\n",
       "      <td>17.85</td>\n",
       "      <td>2.185</td>\n",
       "      <td>28.024</td>\n",
       "      <td>61.230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>25</td>\n",
       "      <td>26</td>\n",
       "      <td>21.2</td>\n",
       "      <td>21.6</td>\n",
       "      <td>25.5</td>\n",
       "      <td>21.40</td>\n",
       "      <td>1.192</td>\n",
       "      <td>50.015</td>\n",
       "      <td>59.598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>12.6</td>\n",
       "      <td>12.9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>12.75</td>\n",
       "      <td>0.706</td>\n",
       "      <td>78.290</td>\n",
       "      <td>55.263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>30</td>\n",
       "      <td>28</td>\n",
       "      <td>30.1</td>\n",
       "      <td>29.9</td>\n",
       "      <td>29.0</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.967</td>\n",
       "      <td>56.049</td>\n",
       "      <td>54.180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16</td>\n",
       "      <td>15</td>\n",
       "      <td>30.3</td>\n",
       "      <td>30.4</td>\n",
       "      <td>15.5</td>\n",
       "      <td>30.35</td>\n",
       "      <td>0.511</td>\n",
       "      <td>100.031</td>\n",
       "      <td>51.087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>15.3</td>\n",
       "      <td>23.6</td>\n",
       "      <td>7.0</td>\n",
       "      <td>19.45</td>\n",
       "      <td>0.360</td>\n",
       "      <td>156.580</td>\n",
       "      <td>56.353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>30.8</td>\n",
       "      <td>37.5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>34.15</td>\n",
       "      <td>0.351</td>\n",
       "      <td>175.715</td>\n",
       "      <td>61.745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>20</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>26.9</td>\n",
       "      <td>22.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>24.45</td>\n",
       "      <td>0.184</td>\n",
       "      <td>313.159</td>\n",
       "      <td>57.637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>30</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>38.3</td>\n",
       "      <td>36.5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>37.40</td>\n",
       "      <td>0.214</td>\n",
       "      <td>351.429</td>\n",
       "      <td>75.172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>4.0</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>79.7</td>\n",
       "      <td>72.6</td>\n",
       "      <td>9.0</td>\n",
       "      <td>76.15</td>\n",
       "      <td>0.118</td>\n",
       "      <td>626.319</td>\n",
       "      <td>74.023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>50</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>26.6</td>\n",
       "      <td>33.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>30.25</td>\n",
       "      <td>0.099</td>\n",
       "      <td>979.748</td>\n",
       "      <td>97.165</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    S.no  current_ed  potential_ed  vr_direct  vr_reverse  cr_direct  \\\n",
       "0      1           2           0.5        211         213       43.5   \n",
       "1      2           3           0.5         38          40       17.6   \n",
       "2      3           4           0.5         25          26       21.2   \n",
       "3      4           5           0.5          9           9       12.6   \n",
       "4      5           6           1.0         30          28       30.1   \n",
       "5      6           8           1.0         16          15       30.3   \n",
       "6      7          10           1.0          7           7       15.3   \n",
       "7      8          15           2.0         11          13       30.8   \n",
       "8      9          20           2.0          5           4       26.9   \n",
       "9     10          30           4.0          8           8       38.3   \n",
       "10    11          40           4.0         10           8       79.7   \n",
       "11    12          50           4.0          3           3       26.6   \n",
       "\n",
       "    cr_reverse  Avg_pd  Avg_curr      R        K  Apparent_res  \n",
       "0         44.0   212.0     43.75  4.846   12.316        59.682  \n",
       "1         18.1    39.0     17.85  2.185   28.024        61.230  \n",
       "2         21.6    25.5     21.40  1.192   50.015        59.598  \n",
       "3         12.9     9.0     12.75  0.706   78.290        55.263  \n",
       "4         29.9    29.0     30.00  0.967   56.049        54.180  \n",
       "5         30.4    15.5     30.35  0.511  100.031        51.087  \n",
       "6         23.6     7.0     19.45  0.360  156.580        56.353  \n",
       "7         37.5    12.0     34.15  0.351  175.715        61.745  \n",
       "8         22.0     4.5     24.45  0.184  313.159        57.637  \n",
       "9         36.5     8.0     37.40  0.214  351.429        75.172  \n",
       "10        72.6     9.0     76.15  0.118  626.319        74.023  \n",
       "11        33.9     3.0     30.25  0.099  979.748        97.165  "
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ExptData #Viewing the table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "97.165\n",
      "51.087\n"
     ]
    }
   ],
   "source": [
    "#Maximum and minimum values of Apparent Resistivity\n",
    "print(ExptData[\"Apparent_res\"].max()) #max value\n",
    "print(ExptData[\"Apparent_res\"].min()) #min value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Depth of the water table is 8 mts.\n"
     ]
    }
   ],
   "source": [
    "#Depth of the water table\n",
    "min_value = ExptData[\"Apparent_res\"].min()\n",
    "depth = ExptData.loc[ExptData[\"Apparent_res\"] == min_value, \"current_ed\"].iloc[0]\n",
    "print(\"Depth of the water table is {} mts.\".format(depth))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAY4AAAEaCAYAAAAG87ApAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAhWklEQVR4nO3de5wddX3/8dc7u5tsNpfNFYGQEGK4hbsGVKolKpVLDVJBBCmCokDr3YdtsdWibbVefvVRuXiJgEHkjoLQhoK1DchFkxDC3VgkCSQIJIFc2Fz29vn9MbPJybJ7dia7Z+ec5P18PM5jz5k5M/M5mex573y/M99RRGBmZpbVkKILMDOz2uLgMDOzXBwcZmaWi4PDzMxycXCYmVkuDg4zM8vFwWG2m5N0l6Rzd2K5d0haWsltWHVycNjrSFou6fgy8/9e0tclvVXSLyW9Imm1pFsk7TWYtZbU9BVJIemYIrY/EDL8u8+S1CnpNUkbJS2V9JH+bjciToqIazLUF5Kmlyz364g4MO82JJ0n6f6dr9iK5uCwnXEyMA8YC8wBpgL7AhuBHw92MZIEnAO8AhT2V62kukHYzAsRMRIYDXwO+JGkTF/eZgPFwWG5SBoLHAA8FBF3RcQtEbEhIjYBlwN/0styZ0pa1G3a5yTdkT4/WdJT6V/SqyR9IUdZ7wD2Bj4DnClpaMk2zpP0gKTLJK2X9DtJ7y6ZP1/Sv0pakM7/haRxJfNvkfRiOu8+SYeUzJsr6fuS5klqAd4paW9JP0uPwJZJ+nTJ+78i6WZJP0k/55OSZqbzrgWmAHemRxR/W+4DR2IeSVgenq5jiKSLJf1B0tp0W+PSeY2SfppOXydpoaQ3lPwbfCx9Pl3SvennXSPppnT6femmH03r+2B6BLQynX+xpFtLa5T0XUmXlm5D0sHAD4C3petZJ+loSS9Jqi9Z9jRJS8r9G1hxHByW1wnAryKio4d5fwo82ctydwAHStq/ZNqHgOvT51cBF0bEKOBQ4H9y1HQucCdwU/r6vd3mvwV4FpgAXAL8vDQcgA8DHyUJn3bg0pJ5dwH7A3sAi4Hruq37Q8DXgFHAg2kdjwKTgHcDn5V0Qsn7TwFuBMaQ/JtcDhAR5wDPAbMjYmREfKvcB05D4pT0Mz2TTv40cCpwXPpZXgWuSOedCzQDk4HxwEXA5h5W/c/APSRHk/sAl6X1/Wk6/4i0vpu6LXcDcLKk0Wl9dcAZbN+/pOt5Ot32Q+l6xkTEQmAt8Gclb/1L4Npy/wZWHAeH5fXnJM1UO5B0OPCPwN/0tFB6RPIL4Kz0/fsDB5F8eQK0ATMkjY6IVyNicZZiJDUBHwCuj4g24FZe31z1MvDvEdGWfuEtTT9Hl2sj4omIaAG+DJzR1ewUEVdHxMaI2Ap8BThCUnPJsr+IiAciohM4DJgYEf8UEa0R8SzwI+DMkvffHxHz0uC9Fjgiy+cssbekdSRf+rcBn4+IR9J5FwL/EBErS+o9Pf1Lvo0kMKZHREdEPBwRG3pYfxtJs+PeEbElIjL1RUTECpJgPTWd9C5gU0T8JuPnuoYkLEhD/QS6hY5VDweHZSZpCMlfhf/Vbfp0kr/MPxMRvy6ziutJg4PkL/Xb00ABOI2k72RF2lTytoxl/QXJUUJXmF0HnCRpYsl7VsWOo3muIPmLvMvz3eY1ABMk1Un6Rtr0swFYnr5nQi/L7kv6xd71AP4eeEPJe14seb4JaCxtosnghYgYQ9LHcSnJF3Tp9m8r2fbTQEe6/WuBu4EbJb0g6VuSGnpY/98CAhakTWkfzVFb9/2b54v/p8BsSSNJjlR+HRF/zLG8DSIHh+VxNLA8IlZ3TZC0L/DfwD9HRF9NC/eQfCEfSfIFs+2LJSIWRsT7SJqEbgduzljTucBI4DlJLwK3kHzxn1XynkmSVPJ6CvBCyevJ3ea1AWtIvvzeBxxP0swzNX1P6bpKA+l5YFna/NL1GBURJ2f8LJmHqk6PKP4OOEzSqSXbP6nb9hsjYlV6tPXViJgBHEvSnPfhHtb7YkR8PCL2JjmC+Z5KzqTqwy3ALEn7kAR6b8Hxus8ZEauAh9LlzsHNVFXNwWG9aUg7VLse9XRrppI0iaQv4oqI+EFfK4yIdpKmpG8D44BfpusZKulsSc1pc9MGkr+Uy0q3/26SL8Ej08cRwDfZsblqD+DTkhokfQA4mB2b2/5S0oy02eufgFvTpqRRwFaS9vcm4Ot9lLQA2CDp7yQNT49YDpV0dF+fJfUSMC3je4mIVuDfSJoIIel0/loa5kiaKOl96fN3SjosbYLbQBKOr/s3lvSB9Isfkj6SKHlf2frSPyjmk5xZtyztz+jtc+6jkpMYUj8hOeI5jKQZzqqUg8N6M4+kHb3r8RW2n4bb5WMkXySXpGfIvCbptT7Wez3JX/C3pEHS5RxgedokdBHb27unpOud0sO6zgGWRMQ96V/KL0bEiyRNOIdLOjR9329JOrjXkHRknx4Ra0vWcy0wl6QZqZGkkxmSL7IVwCrgKaBse30aNrNJAmxZur0rSY5WsvhX4EtpU1PWs8quBqZImg18l6TP6B5JG9N635K+b0+S0N5A0oR1L0nzUHdHA79N9+MdJM2Py9J5XwGuSes7o5d6uvZvuWaq/yE5ieJFSWtKpt9G2tyW9jdZlZJv5GRZpKduLiHpNK2Z/zSSzgM+FhFv72X+fOCnEXHlYNZlPZP0B5Kz6/676Fqsdz7isKyaSc7gqZnQsNoi6TSSprE8p2JbAfKczVFR6YVBnyE5Y+VXEfH9gkuyEhHxe+D3Rddhu6b0yG8GcE56arNVsYo2VUm6mqTj8uWIOLRk+okk7bF1wJUR8Y2SeUOAH0XE+RUrzMzMdlqlm6rmAieWTkjP6rgCOInkL4yzJM1I550C3A/8qsJ1mZnZTqpocETEfSRj6ZQ6BngmIp5NTye8keRceSLijog4Fji7knWZmdnOK6KPYxI7Xm27EniLpFnA+4Fh9DCkRRdJFwAXAIwYMeLNBx10UMUKtXyWrk1uzXDgeA/WalbNHn744TURMbHvd/asiOBQD9MiIuaTXDxUVkTMIRnKm5kzZ8aiRYv6WMIGy6y5swCYf978Qusws/IkrejP8kWcjruSHYd42Icdh38wM7MqVkRwLAT2l7RfOuTAmWwfITUTSbMlzVm/fn1FCjQzs95VNDgk3UAycNmBklZKOj8dZuKTJCN1Pg3cHBG93cOhRxFxZ0Rc0NycdSQHMzMbKBXt44iIs3qZPo8yHeBmZla9POSImZnlUpPB4T4OM7Pi1GRwuI/DzKw4NRkcZmZWHAeHmZnlUpPB4T4OM7Pi1GRwuI/DzKw4NRkcZmZWHAeHmZnl4uAwM7NcajI43DluZlacmgwOd46bmRWnJoPDzMyK4+AwM7NcHBxmZpZLTQaHO8fNzIpTk8HhznEzs+LUZHCYmVlxHBxmZpaLg8PMzHJxcJiZWS4ODjMzy6Umg8On45qZFacmg8On45qZFacmg8PMzIrj4DAzs1wcHGZmlouDw8zMcnFwmJlZLg4OMzPLxcFhZma51GRw+AJAM7Pi1GRw+AJAM7Pi1GRwmJlZcRwcZmaWi4PDzMxycXCYmVkuDg4zM8vFwWFmZrk4OMzMLBcHh5mZ5eLgMDOzXBwcZmaWi4PDzMxyqcng8CCHZmbFqcng8CCHZmbFqcngMDOz4jg4zMwsFweHmZnl4uAwM7NcHBxmZpaLg8PMzHJxcJiZWS4ODjMzy6XP4JD0/yQdMhjFmJlZ9ctyxPE7YI6k30q6SJIv1zYz2431GRwRcWVE/AnwYWAq8Jik6yW9s9LFmZlZ9cnUxyGpDjgofawBHgU+L+nGCtZmZmZVqL6vN0j6DjAb+B/g6xGxIJ31TUlLK1mcmZlVnz6DA3gC+FJEbOph3jEDXI+ZmVW5LE1VZ3cPDUm/AogI3xDDzGw30+sRh6RGoAmYIGksoHTWaGDvQajNzMyqULmmqguBz5KExOKS6RuAKypYk5mZVbFegyMivgt8V9KnIuKywShG0qnAnwN7AFdExD2DsV0zM8uu1z4OSe9Kn66S9P7uj6wbkHS1pJclPdFt+omSlkp6RtLFABFxe0R8HDgP+GD+j2NmZpVWrqnqOJJTcGf3MC+An2fcxlzgcuAnXRPS60KuAP4MWAkslHRHRDyVvuVLuDnM7HXaOzqpr/MQc1asck1Vl6RPPxYRHTu7gYi4T9LUbpOPAZ6JiGcB0gsJ3yfpaeAbwF0RsZgeSLoAuABgypQpO1uWWc35/Usb+evrFvNPpxzCsdMnFF2O7cay/OmyTNIcSe+WpL7fnskk4PmS1yvTaZ8CjgdOl3RRTwtGxJyImBkRMydOnDhA5ZhVt3mP/5FTr3iAdZvaaKj3EYcVK8sFgAeSNFd9ArhK0n8AN0bE/f3Ybk8BFBFxKXBpP9Zrtktp7+jk2/cs5Yf3PstRU8bw/bPfzJ7NjUWXZbu5PoMjIjYDNwM3p9dzfBe4F6jrx3ZXApNLXu8DvJB1YUmzgdnTp0/vRwlm1e2VllY+fcMj3P/MGs5+yxT+cfYMhtX359fObGBkHeTwOEnfI7meoxE4o5/bXQjsL2k/SUOBM4E7si4cEXdGxAXNzR7h3XZNT6xaz+zL7mfB8lf41mmH87W/OMyhYVUjyyCHy4AlJEcdfxMRLXk2IOkGYBbJFegrgUsi4ipJnwTuJjlyuToinsxZu9ku6WcPr+Tvb3uc8SOGcsuFb+OIyWOKLslsB1n6OI6IiA07u4GIOKuX6fOAeTu7XrNdTWt7J1/7z6e45qEVvHXaOC7/0JuYMHJY0WWZvU65sar+NiK+BXxNUnSfHxGfrmhlZbiPw3Y1L2/cwieuW8zC5a/y8Xfsx9+deJCv17CqVe6I4+n056LBKCSPiLgTuHPmzJkfL7oWM4Alz6/j+t+u4OWNW2msr6OxYQiNDXU0NtQxrGFIOq10ejJtWMMQNrd28tU7n2TjlnYuPesoTjnCY4hadSt3AeCd6dNNEXFL6TxJH6hoVWY1YGt7B/Me/yNzH1zBo8+vY+SweqZNHMGWtg62tHWmPzvY0t5Ja3tn2XVNGdfENR89hoP3Gj1I1ZvtvCx9HF8EbskwzWy38OL6LVz32xXcsOA51rzWyrSJI/jqKYfw/jdNYlRjQ4/LdHYGW9vTMGlPgmVr+rO1vZND9h7NiGFZfh3Nileuj+Mk4GRgkqTSi/JGA+2VLqwc93HYYIsIFq14lbkPLufuJ16kI4J3HbgH5x47lbdPn8CQIeUHVRgyRAwfWsfwoT6l1mpfuT9xXiDp3zgFeLhk+kbgc5Usqi/u47DBsqWtgzuWvMDcB5fz1B83MLqxnvOOncqH3zaVKeObii7PrBDl+jgeBR6VdH1EtAGkV45PjohXB6tAsyKsfHUTP/3Nc9y08Dle3dTGgW8Yxdf/4jBOPWpvmoa6Scl2b1l+A34p6ZT0vUuA1ZLujYjPV7SyXVhEsKWtk81tHcmjtZ3NrZ1sam2nozMY1djAqMZ6Rg9Pfjb4tMzXae/oZNW6zSxb08KyNS2s39zG1PEjeOPEkUybOGKn+gsigoeeXcs1Dy7nl0+9BMB7ZuzJucdO5a3TxjFwY3ya1bYsv13NEbFB0seAH0fEJZIeq3RhtWD9pjauX/Dc9i//tg42tSZn0mxq7WBza1cwdJvelm+U+uENdYweXs/oHQKlgdEl4bLHqEaOnNzMtAkj+2xvrxWdncGLG7awfE0Ly9a2sGx1C8vXtvDsmhaef2UTbR2vu7xom72aG5k2MQmSrse0iSPYq7nxdQGwqbWd2x5ZxU8eXMHSlzYytqmBC497I3/51n2ZNGZ4pT+mWc3JEhz1kvYiGZ/qHypcTybV0jm+cWsb3/yv3wHJl/vwoXXbfjYNTc7bHzdiKMPHbJ/XtO099QxvGELT0Hoah9bRlC43ROK1re1s2NzGxi1tbNjS9bydDVva2LCljVdaWlm+pmXbvPbO7V+goxvrOXLKWI6aPIY37TuWI/cZQ3NTz2f6VIOIYG1L67Yjh2VrWpKgWJOExJa27aexDqsfwn4TRnDAHqM44ZA92W/8CPabOIKp40cweng9z63dxB9Wv8YfVrfwh5df4w9rWrht8So2bt1+LkfT0LptgTJtwkjWb27jloefZ+OWdg7ZezTfOv1wTjlibxob3Ilt1htF9P5XG2y7ZuPLwP0R8deSpgHfjojTBqPAcmbOnBmLFhV3fWJnZ7ClvYPG+rrC/srvavZa+eomHnl+HY889yqPPLeOpS9tpGvXvnHiCN40ZSxHTRnLUVPGMH2PkRVp/po1dxYA88+b3+t7Vm/cyr2/X82Dz6zhmdWvsWx1yw5f7PVDxJTxTUkoTBjB1AkjmJb+3HN0Y+5/54hg9catPLP6NZ5d3bJDsKxat5n6IeLEQ/fkvGOn8uZ9x7o5ynYLkh6OiJk7vXxfwVHNig6OarZxSxuPr1zP4jRIHnl+Ha+0tG6bP2pYPc1NDYxpamDM8KHJ8+HbX7+huZEp45qYMq6JsU0Nmb5QewqOjs5gyfOvMn/pauYvXc3jq9YDMGHkUA7eazT7TdgxICaNGT5oQ21sbu2gtaOT5uHVe0RmVgn9DY4+x6qSdBnJPcZ3UORYVda3UY0NHDt9wrZbjEYEz72yicXPvcpzazezbnMr6ze1sW5zG+s2tfLC+s3bXnd07ri7Rw6rZ/K4JqaMG74tTCanPyeNHf664b67jirmL32ZX//fGtZvbmOI4E1TxvKF9xzArAP3YMZeowvvixk+tI7h/bqtjNnuqdcjDkmzI+JOSef2ND8irqloZRnMHDUqFr35zUWXsUsJkqOE1vbtVzZ3/9n9/8zQ+iEMq69jQ8f/0dEZ1HfsB0BD3RCamxoY2zSU5uEN1O8infZmtU733luZI46usapKA0LSEGBkf4ZZt+omkn6G+rSDv7sA2jo62drWyZb2jh1+tncGQyQmj2tizPAGmobV93iPYDOrbVlu5HQ9cBHQQXIFebOk70TEtytdXJmatp9VNX9+UWXslgQMTR+jus3L0jluZlWgnyeBZOmFnJEeYZxKcuOlKcA5/dpqP/nWsWZmxckSHA2SGkiC4xfp8CO1eyqWmZn1S5bg+CGwHBgB3CdpX8B9HGZmu6k++zgi4lKgdFj1FZLeWbmSzMysmvV5xCHpDZKuknRX+noG0OMpumZmtuvL0lQ1F7gb6LoR8u+Bz1aoHjMzq3JZgmNCRNwMdAJERDvJqbmFkTRb0pz169cXWYaZ2W4pS3C0SBpPeiaVpLcChX5j+3RcM7PiZBlW/fPAHcAbJT0ATAROr2hVZmZWtbKcVbVY0nHAgSQXDi8Fjql0YWZmVp3KjY5bR3LzpknAXRHxpKT3AnOA4cBRg1OimZlVk3JHHFcBk4EFwGWSVgBvBb4YEbcPQm1mZlaFygXHTODwiOiU1AisAaZHxIuDU5qZmVWjcmdVtUZE1ym4W4DfOzTMzKzcEcdBkh5Ln4vkrKrH0ucREYdXvDozM6s65YLj4EGrIqcd7sdhZmaDqtwdAFcMZiF5pHcnvHPmzJkfL7oWM7PdTZYrx83MzLZxcJiZWS5ZhlX/TJZpZma2e8hyxNHTvTfOG+A6zMysRpQbcuQs4EPAfpLuKJk1Clhb6cLMzKw6lTsd90Hgj8AE4N9Kpm8EHutxCTMz2+X1dTruCuBtg1eOmZlVuyyd4++X9H+S1kvaIGmjpA2DUZyZmVWfLDdy+hYwOyKernQxZmZW/bKcVfWSQ8PMzLpkOeJYJOkm4HZga9fEiPh5pYoyM7PqlSU4RgObgPeUTAugsODwIIdmZsXJcs/xjwxGIXl4kEMzs+JkOavqAEm/kvRE+vpwSV+qfGlmZlaNsnSO/wj4ItAGEBGPAWdWsigzM6teWYKjKSIWdJvWXolizMys+mUJjjWS3kjSIY6k00mGIjEzs91QlrOqPgHMIbkH+SpgGXB2RasyM7OqVTY4JNUBfxURx0saAQyJiI2DU5qZmVWjssERER2S3pw+bxmckszMrJplaap6JL0fxy3AtvDwleNmZrunLMExjuTGTe8qmVboleNmZlacmrxy3MzMitNncEhqBM4HDgEau6ZHxEcrWJeZmVWpLNdxXAvsCZwA3AvsQ3L7WDMz2w1lCY7pEfFloCUirgH+HDissmWZmVm1yhIcbenPdZIOBZqBqRWryMzMqlqWs6rmSBoLfBm4AxiZPjczs91QlrOqrkyf3gtMq2w5ZmZW7bLcj2O8pMskLZb0sKR/lzR+oAuRNE3SVZJuHeh1m5nZwMnSx3Ej8DJwGnA6sAa4KcvKJV0t6eWum0CVTD9R0lJJz0i6GCAino2I8/OVb2Zmgy1LcIyLiH+OiGXp41+AMRnXPxc4sXRCOnDiFcBJwAzgLEkzspdsZmZFyhIc/yvpTElD0scZwH9mWXlE3Ae80m3yMcAz6RFGK8kRzftyVW1mZoXJEhwXAtcDrenjRuDzkjZK2rAT25wEPF/yeiUwKe1L+QFwlKQv9rawpAskLZK0aPXq1TuxeTMz648sZ1WNGuBtqufNxFrgogz1zCG5sRQzZ86MAa7NzMz6kOU6DiS9H3g7yai4v46I2/uxzZXA5JLX+wAv9GN9ZmY2iLKcjvs9kiOBx4EngIskXdGPbS4E9pe0n6ShwJkkFxZmJmm2pDnr16/vRxlmZrYzsvRxHAecEBE/jogfAycDs7KsXNINwEPAgZJWSjo/ItqBTwJ3A08DN0fEk3mKjog7I+KC5ubmPIuZmdkAyNJUtRSYAqxIX08GHsuy8og4q5fp84B5WdZhZmbVJUtwjAeelrQgfX008Jv0drJExCmVKs7MzKpPluD4x4pXkZOk2cDs6dOnF12Kmdlup88+joi4t/QBtANnlLwedO7jMDMrTtbTcY8EPgScASwDflbBmszMrIr1GhySDiA5VfYsYC3JwIaKiHcOUm1mZlaFyjVV/Q54NzA7It4eEZcBHYNTVnm+jsPMrDjlguM04EWSQQ5/JOnd9DxcyKBzH4eZWXF6DY6IuC0iPggcBMwHPge8QdL3Jb1nkOozM7Mqk+WsqpaIuC4i3ksyrtQS4OJKF2ZmZtUpy5Aj20TEKxHxw4h4V6UKMjOz6pYrOKqFO8fNzIpTk8HhznEzs+LUZHCYmVlxHBxmZpaLg8PMzHKpyeBw57iZWXFqMjjcOW5mVpyaDA4zMyuOg8PMzHJxcJiZWS4ODjMzy8XBYWZmudRkcPh0XDOz4tRkcPh0XDOz4tRkcJiZWXEcHGZmlouDw8zMcnFwmJlZLg4OMzPLxcFhZma5ODjMzCyXmgwOXwBoZlacmgwOXwBoZlacmgwOMzMrjoPDzMxycXCYmVkuDg4zM8vFwWFmZrk4OMzMLBcHh5mZ5eLgMDOzXBwcZmaWi4PDzMxycXCYmVkuNRkcHuTQzKw4NRkcHuTQzKw4NRkcZmZWHAeHmZnl4uAwM7NcHBxmZpaLg8PMzHJxcJiZWS4ODjMzy8XBYWZmuTg4zMwsFweHmZnl4uAwM7NcHBxmZpaLg8PMzHJxcJiZWS4ODjMzy8XBYWZmuTg4zMwsl/qiC+giaQTwPaAVmB8R1xVckpmZ9aCiRxySrpb0sqQnuk0/UdJSSc9Iujid/H7g1oj4OHBKJesyM7OdV+mmqrnAiaUTJNUBVwAnATOAsyTNAPYBnk/f1lHhuszMbCdVtKkqIu6TNLXb5GOAZyLiWQBJNwLvA1aShMcSygSapAuAC9KXW7sfzRSkGVhf8LryLJflveXeU3aePqKe5vW0zARgTR91VNpA7rv+rG8g99/Ozs8zvRr2Hex+v3vl5ueZfmAfNZQXERV9AFOBJ0penw5cWfL6HOByYATwY+D7wNkZ172o0vVnrGNO0evKs1yW95Z7z87M62l6Ney/gdx31bL/dnZ+re27gd5/1bDvamX/FdE5rh6mRUS0AB8Z7GIGyJ1VsK48y2V5b7n37My8gfw3GkgDXVc17L+dnV9r+w52v9+9cvMHbf8pTZ+KSZuq/iMiDk1fvw34SkSckL7+IkBE/OtOrHtRRMwcwHJtEHn/1S7vu9rW3/1XxHUcC4H9Je0naShwJnDHTq5rzsCVZQXw/qtd3ne1rV/7r6JHHJJuAGaRdKS9BFwSEVdJOhn4d6AOuDoivlaxIszMbEBVvKnKzMx2LR5yxMzMcnFwmJlZLrtUcEgaIekaST+SdHbR9Vh2kqZJukrSrUXXYvlJOjX9vfuFpPcUXY9lJ+lgST+QdKukv8qyTNUHh8e7ql159l1EPBsR5xdTqfUk5/67Pf29Ow/4YAHlWomc++7piLgIOAPIdIpu1QcHHu+qls0l+76z6jOX/PvvS+l8K9Zccuw7SacA9wO/yrLyqg+OiLgPeKXb5G3jXUVEK9B9vCuogc+2q8u576zK5Nl/SnwTuCsiFg92rbajvL97EXFHRBwLZGrir9Uv10lsP7KAJDAmAT8HTpP0fap7mITdWY/7TtJ4ST8AjuoaTcCqUm+/e58CjgdOl3RREYVZn3r73Zsl6VJJPwTmZVlR1dzIKaddcbyr3UVv+24t4C+c6tfb/rsUuHSwi7Fcett384H5eVZUq0ccK4HJJa/3AV4oqBbLx/uutnn/1a4B23e1GhwDOd6VDS7vu9rm/Ve7BmzfVX1wpONdPQQcKGmlpPMjoh34JHA38DRwc0Q8WWSd9nred7XN+692VXrfeawqMzPLpeqPOMzMrLo4OMzMLBcHh5mZ5eLgMDOzXBwcZmaWi4PDzMxycXDYbk9Sh6Qlkp6U9Kikz0saks6bKanXoTQkTZX0ocGr1qx4vo7DdnuSXouIkenzPYDrgQci4pIMy84CvhAR761okWZVxEccZiUi4mXgAuCT6VDhsyT9B4Ck49IjkyWSHpE0CvgG8I502ufSI5BfS1qcPo5Nl50laX56l7XfSbpOktJ5R0t6MD3aWSBplKQ6Sd+WtFDSY5IuLOrfxKy7Wh0d16xiIuLZtKlqj26zvgB8IiIekDQS2AJcTMkRh6Qm4M8iYouk/YEb2H5XtaOAQ0gGlnsA+BNJC4CbgA9GxEJJo4HNwPnA+og4WtIw4AFJ90TEskp+drMsHBxmPetpCOoHgO9Iug74eUSsTA8aSjUAl0s6kuQulAeUzFsQESsBJC0BpgLrgT9GxEKAiNiQzn8PcLik09Nlm4H9AQeHFc7BYdaNpGkkX/ovAwd3TY+Ib0j6T+Bk4DeSju9h8c8BLwFHkDQFbymZt7XkeQfJ75+AnjoaBXwqIu7ux0cxqwj3cZiVkDQR+AFweXQ7c0TSGyPi8Yj4JrAIOAjYCIwqeVszyRFEJ3AOUNfHJn8H7C3p6HQboyTVk4xg+leSGtLpB0ga0f9PaNZ/PuIwg+Fp01ED0A5cC3ynh/d9VtI7SY4WngLuAjqBdkmPAnOB7wE/k/QB4H+BlnIbjohWSR8ELpM0nKR/43jgSpKmrMVpJ/pq4NR+fUqzAeLTcc3MLBc3VZmZWS4ODjMzy8XBYWZmuTg4zMwsFweHmZnl4uAwM7NcHBxmZpaLg8PMzHL5/1Cg7T3z3355AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Plotting the graph between \"Distance\" and \"Apparent resistivity\"\n",
    "plt.plot(ExptData[\"current_ed\"], ExptData[\"Apparent_res\"])\n",
    "\n",
    "#Adding labels and plot title\n",
    "plt.xlabel(\"Distance\")\n",
    "plt.ylabel(\"Apparent Resistivity\")\n",
    "plt.title(\"L/2 vs. Apparent Resistivity\")\n",
    "\n",
    "#Setting log-log scale\n",
    "plt.xscale(\"log\")\n",
    "plt.yscale(\"log\")\n",
    "\n",
    "#Setting the limits for the plot\n",
    "plt.xlim(1,1000)\n",
    "plt.ylim(1,1000)\n",
    "\n",
    "#Pointing the end point or minimum point on the graph\n",
    "plt.axvline(x = depth, color = 'g')\n",
    "plt.axhline(y = min(ExptData[\"Apparent_res\"]), color = 'r')\n",
    "\n",
    "#Displaying output graph\n",
    "plt.show()"
   ]
  }
 ],
 "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}