C02 DATASET.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "58ac73ff",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "94b9266c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"CO2_DATASET.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "fa64b540",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 512 entries, 0 to 511\n",
      "Data columns (total 13 columns):\n",
      " #   Column           Non-Null Count  Dtype  \n",
      "---  ------           --------------  -----  \n",
      " 0   DataMessageGUID  512 non-null    object \n",
      " 1   SensorID         512 non-null    int64  \n",
      " 2   Sensor Name      512 non-null    object \n",
      " 3   Date             512 non-null    object \n",
      " 4   Value            512 non-null    int64  \n",
      " 5   Formatted Value  512 non-null    object \n",
      " 6   Battery          512 non-null    int64  \n",
      " 7   Raw Data         512 non-null    object \n",
      " 8   Sensor State     512 non-null    int64  \n",
      " 9   GatewayID        512 non-null    int64  \n",
      " 10  Alert Sent       512 non-null    bool   \n",
      " 11  Signal Strength  512 non-null    int64  \n",
      " 12  Voltage          512 non-null    float64\n",
      "dtypes: bool(1), float64(1), int64(6), object(5)\n",
      "memory usage: 48.6+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0c009518",
   "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>DataMessageGUID</th>\n",
       "      <th>SensorID</th>\n",
       "      <th>Sensor Name</th>\n",
       "      <th>Date</th>\n",
       "      <th>Value</th>\n",
       "      <th>Formatted Value</th>\n",
       "      <th>Battery</th>\n",
       "      <th>Raw Data</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>GatewayID</th>\n",
       "      <th>Alert Sent</th>\n",
       "      <th>Signal Strength</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>049320ec-7f1b-4ef1-b756-3997e204887b</td>\n",
       "      <td>687589</td>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:54 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20496c37-a2ac-495b-8ec2-6e6e665d244e</td>\n",
       "      <td>687589</td>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:39 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b3bc0fe4-1edb-430e-8997-5232f5efa946</td>\n",
       "      <td>687589</td>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:24 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>720bd7a6-3d6b-48df-9d99-eaae5f6c9213</td>\n",
       "      <td>687589</td>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:09 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>de3a8c71-a8bb-4411-bcd3-0a0e2ead827a</td>\n",
       "      <td>687589</td>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 6:54 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        DataMessageGUID  SensorID    Sensor Name  \\\n",
       "0  049320ec-7f1b-4ef1-b756-3997e204887b    687589  CO2 Meter - 1   \n",
       "1  20496c37-a2ac-495b-8ec2-6e6e665d244e    687589  CO2 Meter - 1   \n",
       "2  b3bc0fe4-1edb-430e-8997-5232f5efa946    687589  CO2 Meter - 1   \n",
       "3  720bd7a6-3d6b-48df-9d99-eaae5f6c9213    687589  CO2 Meter - 1   \n",
       "4  de3a8c71-a8bb-4411-bcd3-0a0e2ead827a    687589  CO2 Meter - 1   \n",
       "\n",
       "                 Date  Value                           Formatted Value  \\\n",
       "0  11/19/2022 7:54 AM      0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm   \n",
       "1  11/19/2022 7:39 AM      0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm   \n",
       "2  11/19/2022 7:24 AM      0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm   \n",
       "3  11/19/2022 7:09 AM      0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm   \n",
       "4  11/19/2022 6:54 AM      0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm   \n",
       "\n",
       "   Battery     Raw Data  Sensor State  GatewayID  Alert Sent  Signal Strength  \\\n",
       "0      100  0|0|0|48424             0     964010       False              100   \n",
       "1      100  0|0|0|48424             0     964010       False              100   \n",
       "2      100  0|0|0|48424             0     964010       False              100   \n",
       "3      100  0|0|0|48424             0     964010       False              100   \n",
       "4      100  0|0|0|48424             0     964010       False              100   \n",
       "\n",
       "   Voltage  \n",
       "0     3.11  \n",
       "1     3.11  \n",
       "2     3.11  \n",
       "3     3.11  \n",
       "4     3.11  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "65b16aac",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(\"DataMessageGUID\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "4c7aff58",
   "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>SensorID</th>\n",
       "      <th>Sensor Name</th>\n",
       "      <th>Date</th>\n",
       "      <th>Value</th>\n",
       "      <th>Formatted Value</th>\n",
       "      <th>Battery</th>\n",
       "      <th>Raw Data</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>GatewayID</th>\n",
       "      <th>Alert Sent</th>\n",
       "      <th>Signal Strength</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>687589</td>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:54 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>687589</td>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:39 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>687589</td>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:24 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>687589</td>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:09 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>687589</td>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 6:54 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   SensorID    Sensor Name                Date  Value  \\\n",
       "0    687589  CO2 Meter - 1  11/19/2022 7:54 AM      0   \n",
       "1    687589  CO2 Meter - 1  11/19/2022 7:39 AM      0   \n",
       "2    687589  CO2 Meter - 1  11/19/2022 7:24 AM      0   \n",
       "3    687589  CO2 Meter - 1  11/19/2022 7:09 AM      0   \n",
       "4    687589  CO2 Meter - 1  11/19/2022 6:54 AM      0   \n",
       "\n",
       "                            Formatted Value  Battery     Raw Data  \\\n",
       "0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm      100  0|0|0|48424   \n",
       "1  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm      100  0|0|0|48424   \n",
       "2  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm      100  0|0|0|48424   \n",
       "3  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm      100  0|0|0|48424   \n",
       "4  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm      100  0|0|0|48424   \n",
       "\n",
       "   Sensor State  GatewayID  Alert Sent  Signal Strength  Voltage  \n",
       "0             0     964010       False              100     3.11  \n",
       "1             0     964010       False              100     3.11  \n",
       "2             0     964010       False              100     3.11  \n",
       "3             0     964010       False              100     3.11  \n",
       "4             0     964010       False              100     3.11  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "3235014f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(\"SensorID\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5ab29496",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "31a89c9b",
   "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>Sensor Name</th>\n",
       "      <th>Date</th>\n",
       "      <th>Value</th>\n",
       "      <th>Formatted Value</th>\n",
       "      <th>Battery</th>\n",
       "      <th>Raw Data</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>GatewayID</th>\n",
       "      <th>Alert Sent</th>\n",
       "      <th>Signal Strength</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:54 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:39 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:24 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 7:09 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CO2 Meter - 1</td>\n",
       "      <td>11/19/2022 6:54 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Sensor Name                Date  Value  \\\n",
       "0  CO2 Meter - 1  11/19/2022 7:54 AM      0   \n",
       "1  CO2 Meter - 1  11/19/2022 7:39 AM      0   \n",
       "2  CO2 Meter - 1  11/19/2022 7:24 AM      0   \n",
       "3  CO2 Meter - 1  11/19/2022 7:09 AM      0   \n",
       "4  CO2 Meter - 1  11/19/2022 6:54 AM      0   \n",
       "\n",
       "                            Formatted Value  Battery     Raw Data  \\\n",
       "0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm      100  0|0|0|48424   \n",
       "1  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm      100  0|0|0|48424   \n",
       "2  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm      100  0|0|0|48424   \n",
       "3  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm      100  0|0|0|48424   \n",
       "4  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm      100  0|0|0|48424   \n",
       "\n",
       "   Sensor State  GatewayID  Alert Sent  Signal Strength  Voltage  \n",
       "0             0     964010       False              100     3.11  \n",
       "1             0     964010       False              100     3.11  \n",
       "2             0     964010       False              100     3.11  \n",
       "3             0     964010       False              100     3.11  \n",
       "4             0     964010       False              100     3.11  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c6bfb85a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(\"Sensor Name\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "a35b1765",
   "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>Date</th>\n",
       "      <th>Value</th>\n",
       "      <th>Formatted Value</th>\n",
       "      <th>Battery</th>\n",
       "      <th>Raw Data</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>GatewayID</th>\n",
       "      <th>Alert Sent</th>\n",
       "      <th>Signal Strength</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11/19/2022 7:54 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11/19/2022 7:39 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11/19/2022 7:24 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11/19/2022 7:09 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11/19/2022 6:54 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Date  Value                           Formatted Value  \\\n",
       "0  11/19/2022 7:54 AM      0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm   \n",
       "1  11/19/2022 7:39 AM      0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm   \n",
       "2  11/19/2022 7:24 AM      0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm   \n",
       "3  11/19/2022 7:09 AM      0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm   \n",
       "4  11/19/2022 6:54 AM      0  CO2 Instantaneous: 0 ppm; CO2 TWA: 0 ppm   \n",
       "\n",
       "   Battery     Raw Data  Sensor State  GatewayID  Alert Sent  Signal Strength  \\\n",
       "0      100  0|0|0|48424             0     964010       False              100   \n",
       "1      100  0|0|0|48424             0     964010       False              100   \n",
       "2      100  0|0|0|48424             0     964010       False              100   \n",
       "3      100  0|0|0|48424             0     964010       False              100   \n",
       "4      100  0|0|0|48424             0     964010       False              100   \n",
       "\n",
       "   Voltage  \n",
       "0     3.11  \n",
       "1     3.11  \n",
       "2     3.11  \n",
       "3     3.11  \n",
       "4     3.11  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "deb04cd0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(\"Formatted Value\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "51dd9182",
   "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>Date</th>\n",
       "      <th>Value</th>\n",
       "      <th>Battery</th>\n",
       "      <th>Raw Data</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>GatewayID</th>\n",
       "      <th>Alert Sent</th>\n",
       "      <th>Signal Strength</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11/19/2022 7:54 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11/19/2022 7:39 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11/19/2022 7:24 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11/19/2022 7:09 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11/19/2022 6:54 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Date  Value  Battery     Raw Data  Sensor State  GatewayID  \\\n",
       "0  11/19/2022 7:54 AM      0      100  0|0|0|48424             0     964010   \n",
       "1  11/19/2022 7:39 AM      0      100  0|0|0|48424             0     964010   \n",
       "2  11/19/2022 7:24 AM      0      100  0|0|0|48424             0     964010   \n",
       "3  11/19/2022 7:09 AM      0      100  0|0|0|48424             0     964010   \n",
       "4  11/19/2022 6:54 AM      0      100  0|0|0|48424             0     964010   \n",
       "\n",
       "   Alert Sent  Signal Strength  Voltage  \n",
       "0       False              100     3.11  \n",
       "1       False              100     3.11  \n",
       "2       False              100     3.11  \n",
       "3       False              100     3.11  \n",
       "4       False              100     3.11  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "ecf3df4e",
   "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>Value</th>\n",
       "      <th>Battery</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>GatewayID</th>\n",
       "      <th>Signal Strength</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>512.00000</td>\n",
       "      <td>512.0</td>\n",
       "      <td>512.000000</td>\n",
       "      <td>512.0</td>\n",
       "      <td>512.000000</td>\n",
       "      <td>512.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>91.50000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.003906</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>99.996094</td>\n",
       "      <td>3.119102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>159.67728</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.088388</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.088388</td>\n",
       "      <td>0.006223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.00000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>3.110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.00000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>3.120000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.00000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>3.120000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>132.25000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>3.120000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>972.00000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>3.130000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Value  Battery  Sensor State  GatewayID  Signal Strength  \\\n",
       "count  512.00000    512.0    512.000000      512.0       512.000000   \n",
       "mean    91.50000    100.0      0.003906   964010.0        99.996094   \n",
       "std    159.67728      0.0      0.088388        0.0         0.088388   \n",
       "min      0.00000    100.0      0.000000   964010.0        98.000000   \n",
       "25%      0.00000    100.0      0.000000   964010.0       100.000000   \n",
       "50%      0.00000    100.0      0.000000   964010.0       100.000000   \n",
       "75%    132.25000    100.0      0.000000   964010.0       100.000000   \n",
       "max    972.00000    100.0      2.000000   964010.0       100.000000   \n",
       "\n",
       "          Voltage  \n",
       "count  512.000000  \n",
       "mean     3.119102  \n",
       "std      0.006223  \n",
       "min      3.110000  \n",
       "25%      3.120000  \n",
       "50%      3.120000  \n",
       "75%      3.120000  \n",
       "max      3.130000  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "dc1a0c23",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      329\n",
       "15       5\n",
       "216      3\n",
       "405      3\n",
       "423      3\n",
       "      ... \n",
       "239      1\n",
       "141      1\n",
       "59       1\n",
       "78       1\n",
       "42       1\n",
       "Name: Value, Length: 142, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Value'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "1c894dca",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                    Date  Value  Battery     Raw Data  Sensor State  \\\n",
      "0     11/19/2022 7:54 AM      0      100  0|0|0|48424             0   \n",
      "1     11/19/2022 7:39 AM      0      100  0|0|0|48424             0   \n",
      "2     11/19/2022 7:24 AM      0      100  0|0|0|48424             0   \n",
      "3     11/19/2022 7:09 AM      0      100  0|0|0|48424             0   \n",
      "4     11/19/2022 6:54 AM      0      100  0|0|0|48424             0   \n",
      "..                   ...    ...      ...          ...           ...   \n",
      "507   11/14/2022 2:19 AM      0      100  0|0|0|48424             0   \n",
      "508   11/14/2022 1:49 AM      0      100  0|0|0|48424             0   \n",
      "509   11/14/2022 1:19 AM      0      100  0|0|0|48424             0   \n",
      "510  11/14/2022 12:49 AM      0      100  0|0|0|48424             0   \n",
      "511  11/14/2022 12:19 AM      0      100  0|0|0|48424             0   \n",
      "\n",
      "     GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "0       964010       False              100     3.11  \n",
      "1       964010       False              100     3.11  \n",
      "2       964010       False              100     3.11  \n",
      "3       964010       False              100     3.11  \n",
      "4       964010       False              100     3.11  \n",
      "..         ...         ...              ...      ...  \n",
      "507     964010       False              100     3.13  \n",
      "508     964010       False              100     3.13  \n",
      "509     964010       False              100     3.13  \n",
      "510     964010       False              100     3.13  \n",
      "511     964010       False              100     3.13  \n",
      "\n",
      "[512 rows x 9 columns]\n"
     ]
    }
   ],
   "source": [
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "572663b6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                    Date  Value  Battery       Raw Data  Sensor State  \\\n",
      "36   11/18/2022 11:39 PM      0      100  0|132|0|48424             0   \n",
      "37   11/18/2022 11:24 PM      0      100  0|151|0|48424             0   \n",
      "38   11/18/2022 11:09 PM      0      100  0|159|0|48424             0   \n",
      "39   11/18/2022 10:54 PM      0      100  0|175|0|48424             0   \n",
      "40   11/18/2022 10:39 PM      0      100  0|184|0|48424             0   \n",
      "..                   ...    ...      ...            ...           ...   \n",
      "507   11/14/2022 2:19 AM      0      100    0|0|0|48424             0   \n",
      "508   11/14/2022 1:49 AM      0      100    0|0|0|48424             0   \n",
      "509   11/14/2022 1:19 AM      0      100    0|0|0|48424             0   \n",
      "510  11/14/2022 12:49 AM      0      100    0|0|0|48424             0   \n",
      "511  11/14/2022 12:19 AM      0      100    0|0|0|48424             0   \n",
      "\n",
      "     GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "36      964010       False              100     3.11  \n",
      "37      964010       False              100     3.11  \n",
      "38      964010       False              100     3.11  \n",
      "39      964010       False              100     3.11  \n",
      "40      964010       False              100     3.11  \n",
      "..         ...         ...              ...      ...  \n",
      "507     964010       False              100     3.13  \n",
      "508     964010       False              100     3.13  \n",
      "509     964010       False              100     3.13  \n",
      "510     964010       False              100     3.13  \n",
      "511     964010       False              100     3.13  \n",
      "\n",
      "[476 rows x 9 columns]\n"
     ]
    }
   ],
   "source": [
    "n = 36\n",
    "df.drop(index=df.index[:n],inplace=True)\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "d1e7b82b",
   "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>Date</th>\n",
       "      <th>Value</th>\n",
       "      <th>Battery</th>\n",
       "      <th>Raw Data</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>GatewayID</th>\n",
       "      <th>Alert Sent</th>\n",
       "      <th>Signal Strength</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>11/18/2022 11:39 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|132|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>11/18/2022 11:24 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|151|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>11/18/2022 11:09 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|159|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>11/18/2022 10:54 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|175|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>11/18/2022 10:39 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|184|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Date  Value  Battery       Raw Data  Sensor State  \\\n",
       "36  11/18/2022 11:39 PM      0      100  0|132|0|48424             0   \n",
       "37  11/18/2022 11:24 PM      0      100  0|151|0|48424             0   \n",
       "38  11/18/2022 11:09 PM      0      100  0|159|0|48424             0   \n",
       "39  11/18/2022 10:54 PM      0      100  0|175|0|48424             0   \n",
       "40  11/18/2022 10:39 PM      0      100  0|184|0|48424             0   \n",
       "\n",
       "    GatewayID  Alert Sent  Signal Strength  Voltage  \n",
       "36     964010       False              100     3.11  \n",
       "37     964010       False              100     3.11  \n",
       "38     964010       False              100     3.11  \n",
       "39     964010       False              100     3.11  \n",
       "40     964010       False              100     3.11  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "6e0f9b83",
   "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>Date</th>\n",
       "      <th>Value</th>\n",
       "      <th>Battery</th>\n",
       "      <th>Raw Data</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>GatewayID</th>\n",
       "      <th>Alert Sent</th>\n",
       "      <th>Signal Strength</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>511</th>\n",
       "      <td>11/14/2022 12:19 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>11/14/2022 12:49 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>11/14/2022 1:19 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>11/14/2022 1:49 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>11/14/2022 2:19 AM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|0|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>11/18/2022 10:39 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|184|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>11/18/2022 10:54 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|175|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>11/18/2022 11:09 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|159|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>11/18/2022 11:24 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|151|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>11/18/2022 11:39 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>0|132|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>476 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Date  Value  Battery       Raw Data  Sensor State  \\\n",
       "511  11/14/2022 12:19 AM      0      100    0|0|0|48424             0   \n",
       "510  11/14/2022 12:49 AM      0      100    0|0|0|48424             0   \n",
       "509   11/14/2022 1:19 AM      0      100    0|0|0|48424             0   \n",
       "508   11/14/2022 1:49 AM      0      100    0|0|0|48424             0   \n",
       "507   11/14/2022 2:19 AM      0      100    0|0|0|48424             0   \n",
       "..                   ...    ...      ...            ...           ...   \n",
       "40   11/18/2022 10:39 PM      0      100  0|184|0|48424             0   \n",
       "39   11/18/2022 10:54 PM      0      100  0|175|0|48424             0   \n",
       "38   11/18/2022 11:09 PM      0      100  0|159|0|48424             0   \n",
       "37   11/18/2022 11:24 PM      0      100  0|151|0|48424             0   \n",
       "36   11/18/2022 11:39 PM      0      100  0|132|0|48424             0   \n",
       "\n",
       "     GatewayID  Alert Sent  Signal Strength  Voltage  \n",
       "511     964010       False              100     3.13  \n",
       "510     964010       False              100     3.13  \n",
       "509     964010       False              100     3.13  \n",
       "508     964010       False              100     3.13  \n",
       "507     964010       False              100     3.13  \n",
       "..         ...         ...              ...      ...  \n",
       "40      964010       False              100     3.11  \n",
       "39      964010       False              100     3.11  \n",
       "38      964010       False              100     3.11  \n",
       "37      964010       False              100     3.11  \n",
       "36      964010       False              100     3.11  \n",
       "\n",
       "[476 rows x 9 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[::-1]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "80ecdad9",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "1e11d83c",
   "metadata": {},
   "outputs": [],
   "source": [
    "n = 369\n",
    "df.drop(df.tail(n).index,\n",
    "        inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "4c8de34f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                    Date  Value  Battery       Raw Data  Sensor State  \\\n",
      "36   11/18/2022 11:39 PM      0      100  0|132|0|48424             0   \n",
      "37   11/18/2022 11:24 PM      0      100  0|151|0|48424             0   \n",
      "38   11/18/2022 11:09 PM      0      100  0|159|0|48424             0   \n",
      "39   11/18/2022 10:54 PM      0      100  0|175|0|48424             0   \n",
      "40   11/18/2022 10:39 PM      0      100  0|184|0|48424             0   \n",
      "..                   ...    ...      ...            ...           ...   \n",
      "138  11/18/2022 12:24 AM      0      100   0|55|0|48424             0   \n",
      "139  11/18/2022 12:24 AM      0      100   0|55|0|48424             0   \n",
      "140  11/18/2022 12:09 AM      0      100   0|63|0|48424             0   \n",
      "141  11/18/2022 12:09 AM      0      100   0|63|0|48424             0   \n",
      "142  11/17/2022 11:54 PM      0      100   0|79|0|48424             0   \n",
      "\n",
      "     GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "36      964010       False              100     3.11  \n",
      "37      964010       False              100     3.11  \n",
      "38      964010       False              100     3.11  \n",
      "39      964010       False              100     3.11  \n",
      "40      964010       False              100     3.11  \n",
      "..         ...         ...              ...      ...  \n",
      "138     964010       False              100     3.11  \n",
      "139     964010       False              100     3.11  \n",
      "140     964010       False              100     3.12  \n",
      "141     964010       False              100     3.12  \n",
      "142     964010       False              100     3.11  \n",
      "\n",
      "[107 rows x 9 columns]\n"
     ]
    }
   ],
   "source": [
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "1c26df14",
   "metadata": {},
   "outputs": [],
   "source": [
    "n = 43\n",
    "df.drop(df.tail(n).index,\n",
    "        inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "cf8b2e05",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                   Date  Value  Battery       Raw Data  Sensor State  \\\n",
      "36  11/18/2022 11:39 PM      0      100  0|132|0|48424             0   \n",
      "37  11/18/2022 11:24 PM      0      100  0|151|0|48424             0   \n",
      "38  11/18/2022 11:09 PM      0      100  0|159|0|48424             0   \n",
      "39  11/18/2022 10:54 PM      0      100  0|175|0|48424             0   \n",
      "40  11/18/2022 10:39 PM      0      100  0|184|0|48424             0   \n",
      "..                  ...    ...      ...            ...           ...   \n",
      "95   11/18/2022 8:54 AM      0      100    0|0|0|48424             0   \n",
      "96   11/18/2022 8:39 AM      0      100    0|0|0|48424             0   \n",
      "97   11/18/2022 8:24 AM      0      100    0|0|0|48424             0   \n",
      "98   11/18/2022 8:09 AM      0      100    0|0|0|48424             0   \n",
      "99   11/18/2022 7:54 AM      0      100    0|0|0|48424             0   \n",
      "\n",
      "    GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "36     964010       False              100     3.11  \n",
      "37     964010       False              100     3.11  \n",
      "38     964010       False              100     3.11  \n",
      "39     964010       False              100     3.11  \n",
      "40     964010       False              100     3.11  \n",
      "..        ...         ...              ...      ...  \n",
      "95     964010       False              100     3.11  \n",
      "96     964010       False              100     3.12  \n",
      "97     964010       False              100     3.11  \n",
      "98     964010       False              100     3.11  \n",
      "99     964010       False              100     3.11  \n",
      "\n",
      "[64 rows x 9 columns]\n"
     ]
    }
   ],
   "source": [
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "c9dfe62f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                   Date  Value  Battery         Raw Data  Sensor State  \\\n",
      "46   11/18/2022 9:09 PM     20      100   20|231|0|48424             0   \n",
      "47   11/18/2022 8:54 PM     25      100   25|242|0|48424             0   \n",
      "48   11/18/2022 8:39 PM      1      100    1|248|0|48424             0   \n",
      "49   11/18/2022 8:24 PM     57      100   57|263|0|48424             0   \n",
      "50   11/18/2022 8:09 PM     33      100   33|270|0|48424             0   \n",
      "51   11/18/2022 7:54 PM     31      100   31|284|0|48424             0   \n",
      "52   11/18/2022 7:39 PM     35      100   35|291|0|48424             0   \n",
      "53   11/18/2022 7:24 PM     47      100   47|304|0|48424             0   \n",
      "54   11/18/2022 7:09 PM     73      100   73|308|0|48424             0   \n",
      "55   11/18/2022 6:54 PM    223      100  223|308|0|48424             0   \n",
      "56   11/18/2022 6:39 PM    308      100  308|304|0|48424             0   \n",
      "57   11/18/2022 6:24 PM    136      100  136|298|0|48424             0   \n",
      "58   11/18/2022 6:09 PM    172      100  172|297|0|48424             0   \n",
      "59   11/18/2022 5:54 PM    329      100  329|286|0|48424             0   \n",
      "60   11/18/2022 5:39 PM    341      100  341|285|0|48424             0   \n",
      "61   11/18/2022 5:24 PM    318      100  318|283|0|48424             0   \n",
      "62   11/18/2022 5:09 PM    240      100  240|282|0|48424             0   \n",
      "63   11/18/2022 4:54 PM    268      100  268|283|0|48424             0   \n",
      "64   11/18/2022 4:39 PM    323      100  323|283|0|48424             0   \n",
      "65   11/18/2022 4:24 PM    347      100  347|282|0|48424             0   \n",
      "66   11/18/2022 4:09 PM    384      100  384|280|0|48424             0   \n",
      "67   11/18/2022 3:54 PM    396      100  396|275|0|48424             0   \n",
      "68   11/18/2022 3:39 PM    398      100  398|272|0|48424             0   \n",
      "69   11/18/2022 3:24 PM    474      100  474|263|0|48424             0   \n",
      "70   11/18/2022 3:09 PM    397      100  397|257|0|48424             0   \n",
      "71   11/18/2022 2:54 PM    358      100  358|247|0|48424             0   \n",
      "72   11/18/2022 2:39 PM    421      100  421|244|0|48424             0   \n",
      "73   11/18/2022 2:24 PM    445      100  445|230|0|48424             0   \n",
      "74   11/18/2022 2:09 PM    356      100  356|222|0|48424             0   \n",
      "75   11/18/2022 1:54 PM    131      100  131|218|0|48424             0   \n",
      "76   11/18/2022 1:39 PM    123      100  123|222|0|48424             0   \n",
      "77   11/18/2022 1:24 PM    206      100  206|228|0|48424             0   \n",
      "78   11/18/2022 1:09 PM    300      100  300|230|0|48424             0   \n",
      "79  11/18/2022 12:54 PM    227      100  227|220|0|48424             0   \n",
      "80  11/18/2022 12:39 PM    317      100  317|220|0|48424             0   \n",
      "81  11/18/2022 12:24 PM    395      100  395|205|0|48424             0   \n",
      "82  11/18/2022 12:09 PM    443      100  443|193|0|48424             0   \n",
      "83  11/18/2022 11:54 AM    338      100  338|162|0|48424             0   \n",
      "84  11/18/2022 11:39 AM    347      100  347|148|0|48424             0   \n",
      "85  11/18/2022 11:24 AM    402      100  402|109|0|48424             0   \n",
      "86  11/18/2022 11:09 AM    251      100   251|80|0|48424             0   \n",
      "87  11/18/2022 10:54 AM     56      100    56|55|0|48424             0   \n",
      "88  11/18/2022 10:39 AM     55      100    55|55|0|48424             0   \n",
      "89  11/18/2022 10:24 AM     55      100    55|60|0|48424             0   \n",
      "90  11/18/2022 10:09 AM     89      100    89|61|0|48424             0   \n",
      "91   11/18/2022 9:54 AM     22      100    22|27|0|48424             0   \n",
      "92   11/18/2022 9:39 AM     32      100    32|32|0|48424             0   \n",
      "93   11/18/2022 9:24 AM     10      100    10|10|0|48424             0   \n",
      "94   11/18/2022 9:09 AM      0      100      0|0|0|48424             0   \n",
      "95   11/18/2022 8:54 AM      0      100      0|0|0|48424             0   \n",
      "96   11/18/2022 8:39 AM      0      100      0|0|0|48424             0   \n",
      "97   11/18/2022 8:24 AM      0      100      0|0|0|48424             0   \n",
      "98   11/18/2022 8:09 AM      0      100      0|0|0|48424             0   \n",
      "99   11/18/2022 7:54 AM      0      100      0|0|0|48424             0   \n",
      "\n",
      "    GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "46     964010       False              100     3.11  \n",
      "47     964010       False              100     3.11  \n",
      "48     964010       False              100     3.11  \n",
      "49     964010       False              100     3.11  \n",
      "50     964010       False              100     3.11  \n",
      "51     964010       False              100     3.11  \n",
      "52     964010       False              100     3.11  \n",
      "53     964010       False              100     3.11  \n",
      "54     964010       False              100     3.11  \n",
      "55     964010       False              100     3.11  \n",
      "56     964010       False              100     3.11  \n",
      "57     964010       False              100     3.11  \n",
      "58     964010       False              100     3.12  \n",
      "59     964010       False              100     3.11  \n",
      "60     964010       False              100     3.11  \n",
      "61     964010       False              100     3.11  \n",
      "62     964010       False              100     3.11  \n",
      "63     964010       False              100     3.11  \n",
      "64     964010       False              100     3.11  \n",
      "65     964010       False              100     3.11  \n",
      "66     964010       False              100     3.11  \n",
      "67     964010       False              100     3.12  \n",
      "68     964010       False              100     3.11  \n",
      "69     964010       False              100     3.11  \n",
      "70     964010       False              100     3.12  \n",
      "71     964010       False              100     3.11  \n",
      "72     964010       False              100     3.11  \n",
      "73     964010       False              100     3.11  \n",
      "74     964010       False              100     3.11  \n",
      "75     964010       False              100     3.11  \n",
      "76     964010       False              100     3.12  \n",
      "77     964010       False              100     3.11  \n",
      "78     964010       False              100     3.11  \n",
      "79     964010       False              100     3.11  \n",
      "80     964010       False              100     3.11  \n",
      "81     964010       False              100     3.11  \n",
      "82     964010       False              100     3.12  \n",
      "83     964010       False              100     3.11  \n",
      "84     964010       False              100     3.11  \n",
      "85     964010       False              100     3.11  \n",
      "86     964010       False              100     3.11  \n",
      "87     964010       False              100     3.11  \n",
      "88     964010       False              100     3.11  \n",
      "89     964010       False              100     3.11  \n",
      "90     964010       False              100     3.11  \n",
      "91     964010       False              100     3.11  \n",
      "92     964010       False              100     3.11  \n",
      "93     964010       False              100     3.11  \n",
      "94     964010       False              100     3.12  \n",
      "95     964010       False              100     3.11  \n",
      "96     964010       False              100     3.12  \n",
      "97     964010       False              100     3.11  \n",
      "98     964010       False              100     3.11  \n",
      "99     964010       False              100     3.11  \n"
     ]
    }
   ],
   "source": [
    "n = 10\n",
    "df.drop(index=df.index[:n],inplace=True)\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "86324dfa",
   "metadata": {},
   "outputs": [],
   "source": [
    "n = 5\n",
    "df.drop(df.tail(n).index,\n",
    "        inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "2efa0586",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                   Date  Value  Battery         Raw Data  Sensor State  \\\n",
      "46   11/18/2022 9:09 PM     20      100   20|231|0|48424             0   \n",
      "47   11/18/2022 8:54 PM     25      100   25|242|0|48424             0   \n",
      "48   11/18/2022 8:39 PM      1      100    1|248|0|48424             0   \n",
      "49   11/18/2022 8:24 PM     57      100   57|263|0|48424             0   \n",
      "50   11/18/2022 8:09 PM     33      100   33|270|0|48424             0   \n",
      "51   11/18/2022 7:54 PM     31      100   31|284|0|48424             0   \n",
      "52   11/18/2022 7:39 PM     35      100   35|291|0|48424             0   \n",
      "53   11/18/2022 7:24 PM     47      100   47|304|0|48424             0   \n",
      "54   11/18/2022 7:09 PM     73      100   73|308|0|48424             0   \n",
      "55   11/18/2022 6:54 PM    223      100  223|308|0|48424             0   \n",
      "56   11/18/2022 6:39 PM    308      100  308|304|0|48424             0   \n",
      "57   11/18/2022 6:24 PM    136      100  136|298|0|48424             0   \n",
      "58   11/18/2022 6:09 PM    172      100  172|297|0|48424             0   \n",
      "59   11/18/2022 5:54 PM    329      100  329|286|0|48424             0   \n",
      "60   11/18/2022 5:39 PM    341      100  341|285|0|48424             0   \n",
      "61   11/18/2022 5:24 PM    318      100  318|283|0|48424             0   \n",
      "62   11/18/2022 5:09 PM    240      100  240|282|0|48424             0   \n",
      "63   11/18/2022 4:54 PM    268      100  268|283|0|48424             0   \n",
      "64   11/18/2022 4:39 PM    323      100  323|283|0|48424             0   \n",
      "65   11/18/2022 4:24 PM    347      100  347|282|0|48424             0   \n",
      "66   11/18/2022 4:09 PM    384      100  384|280|0|48424             0   \n",
      "67   11/18/2022 3:54 PM    396      100  396|275|0|48424             0   \n",
      "68   11/18/2022 3:39 PM    398      100  398|272|0|48424             0   \n",
      "69   11/18/2022 3:24 PM    474      100  474|263|0|48424             0   \n",
      "70   11/18/2022 3:09 PM    397      100  397|257|0|48424             0   \n",
      "71   11/18/2022 2:54 PM    358      100  358|247|0|48424             0   \n",
      "72   11/18/2022 2:39 PM    421      100  421|244|0|48424             0   \n",
      "73   11/18/2022 2:24 PM    445      100  445|230|0|48424             0   \n",
      "74   11/18/2022 2:09 PM    356      100  356|222|0|48424             0   \n",
      "75   11/18/2022 1:54 PM    131      100  131|218|0|48424             0   \n",
      "76   11/18/2022 1:39 PM    123      100  123|222|0|48424             0   \n",
      "77   11/18/2022 1:24 PM    206      100  206|228|0|48424             0   \n",
      "78   11/18/2022 1:09 PM    300      100  300|230|0|48424             0   \n",
      "79  11/18/2022 12:54 PM    227      100  227|220|0|48424             0   \n",
      "80  11/18/2022 12:39 PM    317      100  317|220|0|48424             0   \n",
      "81  11/18/2022 12:24 PM    395      100  395|205|0|48424             0   \n",
      "82  11/18/2022 12:09 PM    443      100  443|193|0|48424             0   \n",
      "83  11/18/2022 11:54 AM    338      100  338|162|0|48424             0   \n",
      "84  11/18/2022 11:39 AM    347      100  347|148|0|48424             0   \n",
      "85  11/18/2022 11:24 AM    402      100  402|109|0|48424             0   \n",
      "86  11/18/2022 11:09 AM    251      100   251|80|0|48424             0   \n",
      "87  11/18/2022 10:54 AM     56      100    56|55|0|48424             0   \n",
      "88  11/18/2022 10:39 AM     55      100    55|55|0|48424             0   \n",
      "89  11/18/2022 10:24 AM     55      100    55|60|0|48424             0   \n",
      "90  11/18/2022 10:09 AM     89      100    89|61|0|48424             0   \n",
      "91   11/18/2022 9:54 AM     22      100    22|27|0|48424             0   \n",
      "92   11/18/2022 9:39 AM     32      100    32|32|0|48424             0   \n",
      "93   11/18/2022 9:24 AM     10      100    10|10|0|48424             0   \n",
      "94   11/18/2022 9:09 AM      0      100      0|0|0|48424             0   \n",
      "\n",
      "    GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "46     964010       False              100     3.11  \n",
      "47     964010       False              100     3.11  \n",
      "48     964010       False              100     3.11  \n",
      "49     964010       False              100     3.11  \n",
      "50     964010       False              100     3.11  \n",
      "51     964010       False              100     3.11  \n",
      "52     964010       False              100     3.11  \n",
      "53     964010       False              100     3.11  \n",
      "54     964010       False              100     3.11  \n",
      "55     964010       False              100     3.11  \n",
      "56     964010       False              100     3.11  \n",
      "57     964010       False              100     3.11  \n",
      "58     964010       False              100     3.12  \n",
      "59     964010       False              100     3.11  \n",
      "60     964010       False              100     3.11  \n",
      "61     964010       False              100     3.11  \n",
      "62     964010       False              100     3.11  \n",
      "63     964010       False              100     3.11  \n",
      "64     964010       False              100     3.11  \n",
      "65     964010       False              100     3.11  \n",
      "66     964010       False              100     3.11  \n",
      "67     964010       False              100     3.12  \n",
      "68     964010       False              100     3.11  \n",
      "69     964010       False              100     3.11  \n",
      "70     964010       False              100     3.12  \n",
      "71     964010       False              100     3.11  \n",
      "72     964010       False              100     3.11  \n",
      "73     964010       False              100     3.11  \n",
      "74     964010       False              100     3.11  \n",
      "75     964010       False              100     3.11  \n",
      "76     964010       False              100     3.12  \n",
      "77     964010       False              100     3.11  \n",
      "78     964010       False              100     3.11  \n",
      "79     964010       False              100     3.11  \n",
      "80     964010       False              100     3.11  \n",
      "81     964010       False              100     3.11  \n",
      "82     964010       False              100     3.12  \n",
      "83     964010       False              100     3.11  \n",
      "84     964010       False              100     3.11  \n",
      "85     964010       False              100     3.11  \n",
      "86     964010       False              100     3.11  \n",
      "87     964010       False              100     3.11  \n",
      "88     964010       False              100     3.11  \n",
      "89     964010       False              100     3.11  \n",
      "90     964010       False              100     3.11  \n",
      "91     964010       False              100     3.11  \n",
      "92     964010       False              100     3.11  \n",
      "93     964010       False              100     3.11  \n",
      "94     964010       False              100     3.12  \n"
     ]
    }
   ],
   "source": [
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "52f3df1e",
   "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>Value</th>\n",
       "      <th>Battery</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>GatewayID</th>\n",
       "      <th>Signal Strength</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>49.000000</td>\n",
       "      <td>49.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>49.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>219.489796</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>3.111224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>154.722483</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>3.110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>55.000000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>3.110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>240.000000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>3.110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>347.000000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>3.110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>474.000000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>964010.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>3.120000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Value  Battery  Sensor State  GatewayID  Signal Strength  \\\n",
       "count   49.000000     49.0          49.0       49.0             49.0   \n",
       "mean   219.489796    100.0           0.0   964010.0            100.0   \n",
       "std    154.722483      0.0           0.0        0.0              0.0   \n",
       "min      0.000000    100.0           0.0   964010.0            100.0   \n",
       "25%     55.000000    100.0           0.0   964010.0            100.0   \n",
       "50%    240.000000    100.0           0.0   964010.0            100.0   \n",
       "75%    347.000000    100.0           0.0   964010.0            100.0   \n",
       "max    474.000000    100.0           0.0   964010.0            100.0   \n",
       "\n",
       "         Voltage  \n",
       "count  49.000000  \n",
       "mean    3.111224  \n",
       "std     0.003312  \n",
       "min     3.110000  \n",
       "25%     3.110000  \n",
       "50%     3.110000  \n",
       "75%     3.110000  \n",
       "max     3.120000  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()\n",
    "#IMPORTANT "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "3843f04f",
   "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>Date</th>\n",
       "      <th>Value</th>\n",
       "      <th>Battery</th>\n",
       "      <th>Raw Data</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>GatewayID</th>\n",
       "      <th>Alert Sent</th>\n",
       "      <th>Signal Strength</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>11/18/2022 9:09 PM</td>\n",
       "      <td>20</td>\n",
       "      <td>100</td>\n",
       "      <td>20|231|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>11/18/2022 8:54 PM</td>\n",
       "      <td>25</td>\n",
       "      <td>100</td>\n",
       "      <td>25|242|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>11/18/2022 8:39 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>100</td>\n",
       "      <td>1|248|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>11/18/2022 8:24 PM</td>\n",
       "      <td>57</td>\n",
       "      <td>100</td>\n",
       "      <td>57|263|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>11/18/2022 8:09 PM</td>\n",
       "      <td>33</td>\n",
       "      <td>100</td>\n",
       "      <td>33|270|0|48424</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Date  Value  Battery        Raw Data  Sensor State  \\\n",
       "46  11/18/2022 9:09 PM     20      100  20|231|0|48424             0   \n",
       "47  11/18/2022 8:54 PM     25      100  25|242|0|48424             0   \n",
       "48  11/18/2022 8:39 PM      1      100   1|248|0|48424             0   \n",
       "49  11/18/2022 8:24 PM     57      100  57|263|0|48424             0   \n",
       "50  11/18/2022 8:09 PM     33      100  33|270|0|48424             0   \n",
       "\n",
       "    GatewayID  Alert Sent  Signal Strength  Voltage  \n",
       "46     964010       False              100     3.11  \n",
       "47     964010       False              100     3.11  \n",
       "48     964010       False              100     3.11  \n",
       "49     964010       False              100     3.11  \n",
       "50     964010       False              100     3.11  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "de9d3a76",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                  Date  Value  Battery         Raw Data  Sensor State  \\\n",
      "69  11/18/2022 3:24 PM    474      100  474|263|0|48424             0   \n",
      "\n",
      "    GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "69     964010       False              100     3.11  \n"
     ]
    }
   ],
   "source": [
    "print(df[df.Value == df.Value.max()])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "765cfc9c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                  Date  Value  Battery     Raw Data  Sensor State  GatewayID  \\\n",
      "94  11/18/2022 9:09 AM      0      100  0|0|0|48424             0     964010   \n",
      "\n",
      "    Alert Sent  Signal Strength  Voltage  \n",
      "94       False              100     3.12  \n"
     ]
    }
   ],
   "source": [
    "print(df[df.Value == df.Value.min()])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "a2d84183",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                  Date  Value  Battery         Raw Data  Sensor State  \\\n",
      "62  11/18/2022 5:09 PM    240      100  240|282|0|48424             0   \n",
      "\n",
      "    GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "62     964010       False              100     3.11  \n"
     ]
    }
   ],
   "source": [
    "print(df[df.Value == df.Value.median()])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "0be1c7c0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAmQAAAKvCAYAAADEPtPLAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAABEb0lEQVR4nO3de5hlZ1nn/e/dSQgUZ0g4mKS7EcMIjBKwBxBGQRA5yAiOgkipEdFGRVAZHdH2VRmnZ9CZ1/E0yNSLIkoBMgMvRwE5e0AMHQhgOEiUdCdyCgqXYAma9D1/rFX07p2q7r2ra+17P3t/P9e1rqq99l2/5yn2burO2utZKzITSZIk1dlTPQFJkqRlZ0MmSZJUzIZMkiSpmA2ZJElSMRsySZKkYjZkkiRJxc6unsCZOO+883L//v3V05AkSTqtyy+//NOZef5WzzXdkO3fv58jR45UT0OSJOm0IuLods/5kaUkSVIxGzJJkqRiNmSSJEnFbMgkSZKK2ZBJkiQVsyGTJEkqZkMmSZJUzIZMkiSpmA2ZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZIkFbMhkyRJKmZDJkmSVMyGTJIkqZgNmSRJUjEbMkmSpGI2ZJIkScVsyCRJkorZkEnSTqyvw/79sGdP93V9vXpGkhp2dvUEJKk56+tw8CBsbHSPjx7tHgOsrtbNS1KzPEImSdM6dOhEM7ZpY6PbL0k7YEMmSdM6dmy6/ZJ0GjZkkjStvXun2y9Jp2FDJknTOnwYVlZO3rey0u2XpB2wIZOkaa2uwtoa7NsHEd3XtTVP6Je0Y66ylKSdWF21AZO0azxCJkmSVMyGTJIkqZgNmSRJUjEbMkmSpGI2ZJIkScVsyCRJkorZkEmSJBWzIZMkSSpmQyZJklTMhkySJKmYDZkkSVIxGzJJkqRiNmSSJEnFbMgkSZKK2ZBJkiQVsyGTJEkqZkMmSZJUzIZMkiSpmA2ZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZov6+uwfz/s2dN9XV+vnpEkDe7s6glI0pesr8PBg7Cx0T0+erR7DLC6WjcvSRqYR8ikrXiUpsahQyeasU0bG91+SVpgHiGTxnmUps6xY9Ptl6QF4REyaZxHaers3TvdfklaEDZk0jiP0tQ5fBhWVk7et7LS7ZekBWZDJo3zKE2d1VVYW4N9+yCi+7q25kfFkhaeDZk0zqM0tVZX4eqr4fjx7qvNmKQlYEMmjfMojSRpxlxlKW1lddUGTJI0Mx4hkyRJKmZDJkmSVMyGTJIkqZgNmSRJUjEbMkmSpGI2ZJIkScVsyCRJkorZkEmSJBWzIZMkSSpmQyZJklTMhkySJKmYDZkkSVIxGzJJkqRiNmSSJEnFbMgkSZKK2ZBJatP6OuzfD3v2dF/X16tnJEk7dnb1BCRpauvrcPAgbGx0j48e7R4DrK7WzUuSdsgjZJLac+jQiWZs08ZGt1+SGmRDJqk9x45Nt1+S5pwNmaT27N073X5JmnM2ZJLac/gwrKycvG9lpdsvSQ2yIZPUntVVWFuDffsgovu6tuYJ/ZKa5SpLSW1aXbUBk7QwPEImSZJUzIZMkiSpmA2ZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZIkFbMhkyRJKmZDJkmSVMyGTJIkqZgNmSRJUjEbMkmSpGI2ZJpP6+uwfz/s2dN9XV+vnpEkSYMZvCGLiLMi4j0R8Zr+8e0i4o0R8ZH+621Han86Iq6KiA9HxMOHnpvm1Po6HDwIR49CZvf14EGbMknSwprFEbIfBT448viZwJsz82Lgzf1jIuIewBOAewKPAJ4TEWfNYH6aN4cOwcbGyfs2Nrr9kiQtoEEbsoi4EPhm4Hkjux8DvKD//gXAY0f2vyQzv5iZHwWuAu475Pw0p44dm26/JEmNG/oI2a8C/xE4PrLvjpn5cYD+6x36/RcA14zUXdvv07LZu3e6/dI883xISRMYrCGLiEcDn8rMyyf9kS325Ra5ByPiSEQcue66685ojppThw/DysrJ+1ZWuv3SkHa7efJ8SEkTGvII2QOBb4mIq4GXAA+JiBcCn4yIOwP0Xz/V118LXDTy8xcCHxsPzcy1zDyQmQfOP//8AaevMqursLYG+/ZBRPd1ba3bLw1liOZp2vMhPZomLa3IvNFBqN0fJOLBwE9k5qMj4r8Bf5eZz46IZwK3y8z/GBH3BF5Ed97Yl9Gd8H9xZt6wXe6BAwfyyJEjg89f2tb6evfH9dix7iPVw4dtHFu1f3/XhI3btw+uvnpnmXv2dM3duAg4fvzkfZsN4WgDt7Lif4xICyQiLs/MA1s9V3EdsmcDD4uIjwAP6x+TmVcCLwU+ALweeOqpmjGpnB9HLZYhFpNMcz6kq4ulpTaTI2RD8QiZSg1xREV1hng9pznqNc3RNElNmrcjZNJi8PIci2WIxSTTnA/p6mJpqdmQSTvlH9DFMtRiktXV7gjb8ePd1+3yXF0sLTUbMmmn/AO6eCZtnoYa29XF0tI6u3oCUrM2/1C6ylK7ZXXV94+0pGzIpDPhH1BJ0i7wI0tJkqRiNmSSJEnFbMgkSZKK2ZBJUou876W0UDypX5JaM34HgM3bdoGLTKRGeYRMklrjfS+lhWNDJkmt8bZd0sKxIZOk1njbLmnh2JBJUmu8bZe0cGzIJKk13vdSWjiuspSkFnnbLmmheIRMkiSpmA2ZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZIkFbMhkyRJKmZDJkmSVMyGTJIkqZgNmSRJUjEbMkmSpGI2ZJIkScVsyCRJkorZkEmSJBWzIZMkSSpmQyZJklTMhkySJKmYDZkkSVIxGzJJkqRiNmSSJEnFbMgkLb71ddi/H/bs6b6ur1fPSJJOcnb1BCRpUOvrcPAgbGx0j48e7R4DrK7WzUuSRniETNLwKo9QHTp0ohnbtLHR7ZekOeERMknDqj5CdezYdPslqYBHyCQNq/oI1d690+2XpAI2ZJKGVX2E6vBhWFk5ed/KSrdfkuaEDZmkYVUfoVpdhbU12LcPIrqva2ue0C9prtiQSRrWPByhWl2Fq6+G48e7rzZjkuaMDZmkYXmESpJOy1WWkoa3umoDJkmn4BEySZKkYjZkapu3xJFOzX8jUhP8yFLtqr7gqDTv/DciNSMys3oOO3bgwIE8cuRI9TRUZf/+7g/MuH37upV00rLz34g0VyLi8sw8sNVzfmSpdlVfcFSad/4bkZphQ6Z2VV9wVJp3/huRmmFDpnbNwwVHpXnmvxGpGTZkapcXHJVObVH/jbhyVAvIk/olSe0YXzkK3VG/RWg0tfA8qV+StBgOHTq5GYPu8aFDNfORdokNmZaHH3NI7XPlqBaUDZmWw+bHHEePQuaJC2TalEltceWoFpQNmZaDH3NIi8GVo1pQNmRaDn7MIS2GRV05qqXnvSy1HPbu3foWMn7MIbVnddUGTAvHI2RaDn7MIUmaYzZkWg5+zCFJmmN+ZKnl4ccckqQ55REySZKkYjZkkiRJxWzIJEmLyzt0qBGeQyZJWkzjNyLfvEMHeD6p5o5HyCRJi8k7dKghNmSSpMXkHTrUEBsySdJi8kbkaogNmSRpMXmHDjXEhkyS1Fm0FYneoUMNcZWlJGlxVyR6hw41wiNkkiRXJErFbMgkSa5IlIrZkEmSXJEoFbMhkyTVr0hctAUF0pRsyKRZ8Q+O5lnlisTNBQVHj0LmiQUF/hvREonMrJ7Djh04cCCPHDlSPQ3p9MZXsEF39MEl+FL3HyhHj954/759cPXVs56NNJiIuDwzD2z1nEfIpFlwBZu0PRcUSDZk0kz4B0fangsKJBsyaSb8gyNtr3pBgTQHbMikWfAPjrQ9b3EkeeskaSY2/7AcOtR9TLl3b9eM+QdH6niLIy05GzJpVvyDI0nahh9ZSpIkFbMhkyRJKmZDJknSELw7h6bgOWSSJO228btzbN4OCjyXVFvyCJkkSbvNu3NoSjZkkiTtNu/OoSnZkEmStNu8O4emZEMmSdJu8+4cmpINmSRJu83bQWlKgzVkEXHTiLgsIt4bEVdGxLP6/beLiDdGxEf6r7cd+ZmfjoirIuLDEfHwoeYmSdLgVlfh6qvh+PHuq82YTmHII2RfBB6SmfcCLgEeERH3B54JvDkzLwbe3D8mIu4BPAG4J/AI4DkRcdaA85Pa53WOJGkhDNaQZefz/cNz+i2BxwAv6Pe/AHhs//1jgJdk5hcz86PAVcB9h5qf1LzN6xwdPQqZJ65zZFMmSc0Z9ByyiDgrIq4APgW8MTP/ArhjZn4coP96h778AuCakR+/tt8naSte50iSFsagDVlm3pCZlwAXAveNiH99ivLYKuJGRREHI+JIRBy57rrrdmmmUoO8zpEkLYyZrLLMzM8Cb6M7N+yTEXFngP7rp/qya4GLRn7sQuBjW2StZeaBzDxw/vnnDzltab55nSNJWhhDrrI8PyJu039/M+AbgQ8BrwIu7csuBV7Zf/8q4AkRcW5E3AW4GLhsqPlJzfM6R5K0MIa8ufidgRf0KyX3AC/NzNdExJ8DL42IJwPHgMcBZOaVEfFS4APA9cBTM/OGAecntW1zCf2hQ93HlHv3ds2YS+slqTmReaPTtJpx4MCBPHLkSPU0JEmSTisiLs/MA1s955X6JUmSitmQSZIkFbMhkyRJKmZDJkmSVMyGTJIkqZgNmSRJUjEbMkmSpGI2ZJIkScVsyCRJkorZkEmSJBWzIZMkSSpmQyZJklTMhkySJKmYDZkkSVIxGzJJkqRiNmSSJEnFbMgkSZKK2ZBJkiQVsyGTJEkqZkMmSZJUzIZMkiSpmA2ZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZKms74O+/fDnj3d1/X16hlJzTu7egKSpIasr8PBg7Cx0T0+erR7DLC6WjcvqXEeIZMkTe7QoRPN2KaNjW6/pB2zIZMkTe7Ysen2S5qIDZkkaXJ79063X9JEbMgkSZM7fBhWVk7et7LS7Ze0YzZkkqTJra7C2hrs2wcR3de1NU/ol86QqywlSdNZXbUBk3aZR8gkSZKK2ZBJkiQVsyGTJEkqZkMmSZJUzIZMkiSpmA2ZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZIkFbMh0+ysr8P+/bBnT/d1fb16RpIkzQXvZanZWF+HgwdhY6N7fPRo9xi8J54kael5hEyzcejQiWZs08ZGt1+SpCVnQ6bZOHZsuv2SJC0RGzLNxt690+2XJGmJ2JBpNg4fhpWVk/etrHT7JUlachM3ZBFx8yEnogW3ugpra7BvH0R0X9fWPKFfkiQmaMgi4gER8QHgg/3je0XEcwafmRbP6ipcfTUcP959tRmTJAmY7AjZ/wAeDvwdQGa+F/j6ISclSZK0TCb6yDIzrxnbdcMAc5EkSVpKk1wY9pqIeACQEXET4On0H19KkiTpzE1yhOwHgacCFwDXApf0jyVJkrQLTtuQZeanM3M1M++YmXfIzO/KzL+bxeQkSY3zHrbSRE77kWVEPB/I8f2Z+X2DzEiStBi8h600sUk+snwN8Np+ezNwK+DzQ05KkrQAvIetNLHTHiHLzJeNPo6IFwNvGmxGkqTF4D1spYnt5NZJFwPegFCSdGrew1aa2CRX6v9cRPzD5lfg1cBPDT81SVLTvIetNLFJPrK85SwmIklaMJsn7h861H1MuXdv14x5Qr90I9s2ZBFxn1P9YGa+e/enI0laKKurNmDSBE51hOz/PcVzCTxkl+ciSZK0lLZtyDLzG2Y5EUmSpGU1yb0siYh/DdwDuOnmvsz8vaEmJUmStEwmuVL/zwMPpmvI/hB4JPCngA2ZJEnSLpjkOmTfDjwU+ERmPgm4F3DuoLOSJElaIpM0ZF/IzOPA9RFxK+BTwJcPOy1piXkzZklaOqe67MVvAi8GLouI2wD/H3A53X0sL5vJ7KRl482YJWkpneocso8A/x34Mrom7MXAw4BbZeb7ZjA3afmc6mbMNmSStLC2/cgyM38tM78W+Hrg74HnA68DHhsRF89oftJy8WbMkrSUTnsOWWYezcxfysx7A08EvhX40OAzk5aRN2OWlpPnji69SW4ufk5E/LuIWKc7QvZXwLcNPjNpGXkzZmn5bJ47evQoZJ44d9SmbKls25BFxMMi4neAa4GDdNcgu2tmfkdmvmJG85OWy+oqrK3Bvn0Q0X1dW/P8MWmRnercUS2NyMytn4h4K/Ai4GWZ+fczndWEDhw4kEeOHKmehiRJO7dnT3dkbFwEHD8++/loMBFxeWYe2Oo572UpSVKlvXu7jym32q+lMcmFYSVJ0lA8d1TYkEmSVMtzR8UENxeXJEkDW121AVtyHiGTJEkqZkMmSZJUzIZMkiSpmA2ZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZIkFbMhkyRJKmZDJkmSVMyGTFoG6+uwfz/s2dN9XV+vnpEkaYT3spQW3fo6HDwIGxvd46NHu8fgvfMkaU54hExadIcOnWjGNm1sdPslSXPBhkxadMeOTbdfkjRzNmTSotu7d7r9kqSZsyGTFt3hw7CycvK+lZVuvyRpLgzWkEXERRHx1oj4YERcGRE/2u+/XUS8MSI+0n+97cjP/HREXBURH46Ihw81N2mprK7C2hrs2wcR3de1NU/ol6Q5Epk5THDEnYE7Z+a7I+KWwOXAY4HvBf4+M58dEc8EbpuZPxUR9wBeDNwX+DLgTcDdMvOG7cY4cOBAHjlyZJD5S5Ik7aaIuDwzD2z13GBHyDLz45n57v77zwEfBC4AHgO8oC97AV2TRr//JZn5xcz8KHAVXXMmSZK00GZyDllE7AfuDfwFcMfM/Dh0TRtwh77sAuCakR+7tt83nnUwIo5ExJHrrrtu0HlLkiTNwuANWUTcAngZ8GOZ+Q+nKt1i340+T83Mtcw8kJkHzj///N2apiRJUplBG7KIOIeuGVvPzJf3uz/Zn1+2eZ7Zp/r91wIXjfz4hcDHhpyfJEnSPBhylWUAvw18MDN/ZeSpVwGX9t9fCrxyZP8TIuLciLgLcDFw2VDzkyRJmhdD3svygcB3A++PiCv6fT8DPBt4aUQ8GTgGPA4gM6+MiJcCHwCuB556qhWWkiRJi2Kwhiwz/5StzwsDeOg2P3MY8GqVkiRpqXilfkmSpGI2ZJIkScVsyCRJkorZkEmSJBWzIZMkSSpmQyZJklTMhkySJKmYDZkkSVIxGzJJkqRiNmSSJEnFbMgkSZKK2ZBJkiQVsyGTJEkqZkMmSZJUzIZMkiSpmA2ZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZIkFbMhkyRJKmZDJknS+jrs3w979nRf19erZ6Qlc3b1BCRJKrW+DgcPwsZG9/jo0e4xwOpq3by0VDxCJklabocOnWjGNm1sdPulGbEhkyQtt2PHptsvDcCGTJK03PbunW6/NAAbMknScjt8GFZWTt63stLtl2bEhkyStNxWV2FtDfbtg4ju69qaJ/RrplxlKUnS6qoNmEp5hEySJKmYDZkkSVIxGzJJkqRiNmSSJEnFbMgkSZKK2ZBJkiQVsyGTJEkqZkMmSZJUzIZMkiSpmA2ZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZIkFbMhkyRJKmZDJkmSVMyGTJIkqZgNmSRJUjEbMkmSpGI2ZJIkScVsyCRJkorZkEmSJBWzIZMkSSpmQyZJklTMhkySJKmYDZkkSVIxGzJJkqRiNmSSJEnFbMgkSZKK2ZBJkjSN9XXYvx/27Om+rq9Xz0gL4OzqCUiS1Iz1dTh4EDY2usdHj3aPAVZX6+al5nmETJKkSR06dKIZ27Sx0e2XzoANmSRJkzp2bLr90oRsyCRJmtTevdPtlyZkQyZpZzyxWcvo8GFYWTl538pKt186AzZkkqa3eWLz0aOQeeLEZpsyLbrVVVhbg337IKL7urbmCf06Y5GZ1XPYsQMHDuSRI0eqpyEtn/37uyZs3L59cPXVs56NJDUhIi7PzANbPecRMknT88RmSdpVNmSSpueJzZK0q2zIJE3PE5slaVfZkEmanic2S9Ku8tZJknZmddUGTJJ2iUfIJEmSitmQSTqZF3yVpJnzI0tJJ2xe8HXz5smbF3wFP56UpAF5hEzSCYcOnWjGNm1sdPslSYOxIZN0ghd8laQSNmSSTvCCr5JUwoZM0gle8FWSStiQSTrBC75KUglXWUo6mRd8laSZ8wiZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZIkFbMhkyRJKmZDJkmSVMyGTJIkqZgNmSRJUjEbMkmSpGI2ZJIkScVsyCRJkorZkEmSJBWzIZMkSSpmQyZJklRssIYsIn4nIj4VEX85su92EfHGiPhI//W2I8/9dERcFREfjoiHDzUvSZKkeTPkEbLfBR4xtu+ZwJsz82Lgzf1jIuIewBOAe/Y/85yIOGvAuUmSJM2NwRqyzPxj4O/Hdj8GeEH//QuAx47sf0lmfjEzPwpcBdx3qLlJkiTNk1mfQ3bHzPw4QP/1Dv3+C4BrRuqu7fdJkiQtvHk5qT+22JdbFkYcjIgjEXHkuuuuG3hakiRJw5t1Q/bJiLgzQP/1U/3+a4GLRuouBD62VUBmrmXmgcw8cP755w86WUmSpFmYdUP2KuDS/vtLgVeO7H9CRJwbEXcBLgYum/HcJEmSSpw9VHBEvBh4MHBeRFwL/DzwbOClEfFk4BjwOIDMvDIiXgp8ALgeeGpm3jDU3CRJkubJYA1ZZn7nNk89dJv6w8DhoeYjSZI0r+blpH5JkqSlZUMmSZJUzIZMkiSpmA3ZIlhfh/37Yc+e7uv6evWMJEnSFAY7qV8zsr4OBw/Cxkb3+OjR7jHA6mrdvCRJ0sQ8Qta6Q4dONGObNja6/ZIkqQk2ZK07dmy6/ZIkae7YkLVu797p9kuSpLljQ9a6w4dhZeXkfSsr3X5JktQEG7LWra7C2hrs2wcR3de1NU/olySpIa6yXASrqzZgkiQ1zCNkkiRJxWzIJEmSitmQSZIkFbMhkyRJKmZDJkmSVMyGTJIkqZgNmSRJUjEbMkmSpGI2ZJIkScVsyCRJasX6OuzfD3v2dF/X16tnpF3irZMkSWrB+jocPAgbG93jo0e7x+Dt8xaAR8gkSWrBoUMnmrFNGxvdfjXPhkySpBYcOzbdfjXFhkySpBbs3TvdfjXFhkySpBYcPgwrKyfvW1np9qt5NmSSJLVgdRXW1mDfPojovq6teUL/gnCVpSRJrVhdtQFbUB4hkyRJKmZDJkmSVMyGTJIkqZgNmSRJUjEbMkmSpGI2ZJIkScVsyCRJkorZkEmSJBWzIZMkSXXW12H/ftizp/u6vl49oxI2ZDpz/mOSJO3E+jocPAhHj0Jm9/XgwaX8O2JDtmwmbZ6mqfMfkyRpJw4dgo2Nk/dtbHT7l0xkZvUcduzAgQN55MiR6mm0Y7N5Gn3zr6zc+Oa0k9ZB16wdPXrjsfbtg6uv3s3ZS5IWzZ493X/Mj4uA48dnP5+BRcTlmXlgy+dsyJbIpM3TNE3Wkv1jkiTtoiX7j/pTNWR+ZLlMjh2bbP+kdQB7925du91+SZI2HT7cfQIzamWl279kbMiWyaTN0zRNlv+YJEk7tbranQ6zb1/3ycq+fVufHrMEbMiWyaTN0zRNlv+YJElnYnW1+3jy+PHu65L+/bAhWyaTNk/TNln+Y5Ik6Yx4Ur8kSdIMeFK/JEnSHLMhkyRpEXkXlaacXT0BSZK0y8Yv8L15FxXwPN855REySZIWjbckao4NmSRJi2aaC3xrLtiQSZK0aLyLSnNsyCRJWjTeRaU5NmSSJC0a76LSHFdZSpK0iFZXbcAa4hEySZKkYjZkkiRJxWzIJEmSitmQSZIkFbMhkyRp2Xnfy3KuspQkaZl538u54BEySZKW2VD3vfSo21RsyGbNN6gkaZ4Mcd/LzaNuR49C5omjbv7N25YN2Sz5BpUkzZsh7ns51FG3BWZDNku+QSVJ82aa+15O+inPEEfdFpwN2Sz5BpUkzZtJ73s5zac8Qxx1W3A2ZLPkG1SSNI9WV+Hqq+H48e7rVqsrp/mUZ5qjbgJsyGbLN6gkqVXTfMoz6VE3fYkN2Sz5BpUktWraT3kmOeqmL7EhmzXfoJKkFvkpz6BsyCRJ0um19ClPg9f89NZJkiRpMqur89mAjWr0VlAeIZMkSYuj0Wt+2pDNqwYPt0qSVK7Ra37akM0jb7EkSdLONHrNTxuyedTo4VZJkspNuxp0Tj6RsiGbR40ebpUkqdw0q0Hn6BOpyMyZD7pbDhw4kEeOHKmexu7bv797U4zbt6+7dpkkSTpzM/57GxGXZ+aBrZ7zCNk88uJ7kiQNb44+kbIhm0ctXXxPkqRWzdECABuyeeUtliRJGtYcfSJlQyZJkpbTHH0i5a2TJEnS8pqT20F5hEySJKmYDZkkSVIxG7LdMCdX+ZUkSW3yHLIztXmV381bHW1e5Rfm4jNpSZI0/zxCdqa876QkSTpDNmRnao6u8itJktpkQ3am5ugqv5IkqU02ZGdqjq7yK0mS2mRDdqbm6Cq/kiSpTa6y3A1zcpVfSZLUJo+QSZIkFbMhkyRJKjZ3DVlEPCIiPhwRV0XEM6vnI0mS5sQC3xlnrhqyiDgL+J/AI4F7AN8ZEfcom9ACv/CSJDVl8844R49C5ok74yzI3+a5asiA+wJXZebfZOY/Ay8BHlMykwV/4SVJasqC3xln3hqyC4BrRh5f2++bvQV/4SVJasqC3xln3hqy2GJfnlQQcTAijkTEkeuuu264mSz4Cy9JUlMW/M4489aQXQtcNPL4QuBjowWZuZaZBzLzwPnnnz/cTBb8hZckqSkLfmeceWvI3gVcHBF3iYibAE8AXlUykwV/4SVJasqC3xlnrq7Un5nXR8SPAG8AzgJ+JzOvLJnM5gt86FD3MeXevV0ztiAvvCRJzVngO+NEZp6+ak4dOHAgjxw5Uj0NSZKk04qIyzPzwFbPzdtHlpIkSUvHhkySJKmYDZkkSVIxGzJJkqRiNmSSJEnFbMgkSZKK2ZBJkiQVsyGTJEkqZkMmSZJUzIZMkiSpmA2ZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZIkFbMhkyRJKmZDJkmSVMyGTJIkqZgNmSRJUjEbMkmSpGKRmdVz2LGIuA44OoOhzgM+vYt11ZnV47eSWT3+MmdWj99KZvX4rWRWj99KZvX4rWSeiX2Zef6Wz2Sm22k24Mhu1lVnVo/fSmb1+MucWT1+K5nV47eSWT1+K5nV47eSOdTmR5aSJEnFbMgkSZKK2ZBNZm2X66ozq8dvJbN6/GXOrB6/lczq8VvJrB6/lczq8VvJHETTJ/VLkiQtAo+QSZIkFbMhkyRJKnZ29QQ0vYj496d6PjNfPm3tMmf2tc84Te2vTFM3YObtTlP799PUVWdWj99KZvX4rWRWj99KZvX4rWTOmueQjYiIzwGj/4NE/ziAzMxbTVM3YOZx4Ip+26zdlJn5fdPWLnPmWO3rgC+O1ZKZz5qmbuDMa4Hrt/mdvnyauurM6vFbyawev5XM6vFbyawev5XMmcvCi6DN2wa8Angn8B+BvWdaN2DmtwIvAY4A/w/wFWdau8yZfe0lwLPpGqPfBr6R/j9YdlI3YOavAe8FngN83ZnWVWdWj99KZvX4rWRWj99KZvX4rWTOeiufwLxtwK2BJwFvAN4O/DBwu53WDZXZ198ceCLwSuBPgQedae0yZ47UPwD4DeCDwLecad1uZ9L919w30C3RvgL4ZeAuO62rzqwev5XM6vFbyawev5XM6vFbyZzlVjbwvG90Cx6+k+6+Vs8407ohMoGzgG8Gfh94D/DwM61d5sy+9nzgqcDbgDcC9z+TuqEy+/rbAD8IXAf8wJnWVWdWj99KZvX4rWRWj99KZvX4rWTOYvOk/jER8QC6Zujr6I6mfGtm/slO64bIjIhv6OvuC7wJ+LXMPLLN2BPVLnNmX/sk4DuAmwL/B3h8Zn5qp3UDZt4ceExffz7wcuA+mXnNTuqqM6vHbyWzevxWMqvHbyWzevxWMmfNk/pHRMTVwGfpzjt6CydO+AMgM989Td2AmceB99E1bcnJiwHIzKdPW7vMmSO17weObT49Vvst09QNmPmPwEeAFwNXbVH78mnqqjOrx28ls3r8VjKrx28ls3r8VjJnzYZsRES8jRMvTMKNVl48ZJq6ATMvPdXvkZkvmLZ2mTP72gedpvbt09QNmPm7jP2fx8mlX1qNOlFddWb1+K1kVo/fSmb1+K1kVo/fSuas2ZBNKCLOycx/2a26ITIj4qbAv8vM/71btcuUGRH3Bu4KXJmZHzzFz09UN1SmJGnx7KmewDyLzkMi4nl01yw5o7ohMiPirIh4ZET8HnCU7jPxM6pdxsyI+DngD4BvA14bET+wTc5EdQNm3i8i3hsRn4+IP4+Iu59JXXVm9fitZFaP30pm9fitZFaP30rmzGXhioJ53YD70V2n5BjweeBS4LY7rRsiE/h64LnANcDLgE8AK9uMPVHtkmdeubkfuD3wrm3yJqobMPMI8DDgXOBxwBvOpK46s3r8VjKrx28ls3r8VjKrx28lc9Zb+QTmaQMO053o92bg++n+OH50p3UDZl4LvAP4buCW/b4zql3mzH7/5ad6PG3dgJnvPtXjaeuqM6vHbyWzevxWMqvHbyWzevxWMme9edmLkx0EPgz8FvCazPxCROQZ1A2V+TLgsXQfu90QEa9k+xMUJ61d5kyAu0bEq/rvY+wxeWKl46R1Q2XeJk6+R+dJj/PE6qBJ66ozq8dvJbN6/FYyq8dvJbN6/FYyZ8qT+kdExFnAN9Fdu+ohwFvpbmNzUWZeP23dUJl9/eZVhr8TeBRwK+DJwB9m5ud3UrvkmQ8a/994VM7PKsvnn7r0SyuOJqqrzqwev5XM6vFbyawev5XM6vFbyZw1G7JtRLcS79F0f8j/LfDmzHziTuuGyuzrzwEe0dd/U2aed6a1y5wpSdKs2ZBNICJuRXfV/BfsRt1QmX39zTLzn3azdpkzJUmaBRsySZKkYl6HTJIkqZirLCUgIvYA30t3cdYL6e4l+hHguZn5ttP87F9l5t1mkdk/dwu6c+EuGsn8o8w8fprM/5KZPzPvmafKXebMM8ld5sxT5S5z5pnkLnPmkPzIcsw8vfCn+Me54z/0/c/f6I/9Mmf2+59PdwX/NwHfDvwD8CfATwGvzMzf6Os+x4lLZ2zeb3QF2KBbnXOrgTMfD/wk8F661aPvoDvS/VXAama+v6/79fFfke56bL9HF/r0ecicJneZM6fJXebMaXKXOXOa3GXOnLmcg4uhzcsGPB54F/A84K+B3wfWgfcBXzVS9+tj228An918PIPM5wO/QLcC81eB/0R31eE3AU8bq/0cXSPwD/33nwNu2Nxv5pdq3zf2+J3913OBD47s/w26f+B3HNn30W3eT4NkcuKq/ufRX2Ea+GrgHSN11wIvBL6H7m4PlwLXbX4/L5nT5C5zZvXr1Epm9evUSmb169RK5qy3kkHndWvpzTT2eMs/9P2+if7YL3Nmv/9y4K799/cB/njkuQ+M1X4N8Bbg6XT/VfU3M8x8PyeObN8MeM/Ic3858v0t6RrWFwEX9PvmLnOa3GXOrH6dWsmsfp1ayax+nVrJnPXmOWQnC2DzUgj/CNwBIDPf119+YtPdgV+k+xjyJzPzbyPi53PrS1MMkfkvEXHXzPzriLgP8M995hdj7Or+mfm0iPga4MUR8QrgN9n6avXLnAnd4eu3RsQXgHOAJwBExPnAa8ZyL4+IbwR+BHg7cNMZZv4h8PqIeDvwSOB/95m348THnWTm54Af63//F0bEa9l+EU9Z5pS5y5w5ce4yZ06Zu8yZE+cuc+bMVXWC87gBvwS8AfgZunN9fqbffzvgyi3qv4buivo/AVw9w8yH0N18/K+AjwL36/efD/zyNj+zh+7oy58AHzNzy7oAzpvyPXNn4FEzznxU//542NjveO4p5vBU4IXznDlJ7jJnzsvr1ErmIr32vp/qM2exeVL/mIh4FHAP4L2Z+cZ+3x7gnMz84hb1Afww8LWZ+V0zzAzg9pn56Sl/vzsD987MPzTzRs/fmu4I5QV0R9I+RvcR82fH6m4FnJ+Zfz22/6sz831j++4EkJmf6I+MfR3w4cy88hTzvAtwb7qPNT90irrbddH5me1q5oHz3H2tzNV57q5W5gntzHWu5lnVCc77RncE67bV8zjF/G5Nd9PsZwA/3n9/m21qb0V/LtPY/q8ee3wn4E799+cD/x645wRzuUtf+5UNz/N76BZd/Bbws/323H7f94zUPZ6uUbsCuBL4NyPPvXss8yl0R/GuBn4I+Avgd+huIv/kkbpXjHz/mP5nnt/Xfe9Y5l7gJcCn6FaXXtV//xJg/0jdRf2+P6E7OnvOVuP1j78SeB3wWuCuwO/SLSi5DLj7SN33jXx/IfBm4DN0K5TutpN5TjPXSec5zVxbmecivvZDzHMRX/sh5rmIr/0Q85z1VjLovG4NvZkmah762okaCCZsHsZ/R07RQLQyz/75D7NFowjcFvirkcdXAHfuv78v8CHg3/eP3zP2s++nu3zF7YHPc6KJvC1wxUjde0a+fwdwl/778+iOqo5m/jldU3vWyL6z6M5Pe+fIvjcCPwhcQre44R10RxW3mucfA/+O7h6fR/us6Pe9eZvX4aX9a7EH+NbRumnmOc1cJ53nNHNtZZ6L+NoPMc9FfO2HmOcivvZDzHPWW8mg87o19GaaqHno913BBA0EEzYPW/zctg1EK/Ps9/0VcOst5npr4COj4489f2e61ZRP58ZHyEZf0/Hx3rNN3WXb1fWPPzI+x62e2+J/i++ia3TvusU8R+dy1Sl+h3efIn9H85xmrpPOc5q5tjLPRXzth5jnIr72Q8xzEV/7IeY5681Vlic7LzP/YHRHZt4AvCQifnFk9/mZ+dz++6dFxHcBfxwR38KNV/HdMjNfDRARv5iZL+n3vzoinrXNPO6WmY/vv///I+Lnxp6PLcYBOM6NV4iclZkf73+XyyLiG4DXRMSFYxn/kpkbwEZE/HVmfqL/mc+Mr14c+7mzM/Ojfe2nI2L0YretzBPgMPDuiPgj4Jp+3166a5yNvvafi36VZ5/18Yh4MPAK4J7jv2dEnJOZ/wJ88+bOiLgpJ6/+uVdE/EP/v8m5EXGn7M45uwndfxCMujwingO8YGSeF9FdHuU9I3XnRMRNM/ML/TxfGBGfoFtgcvOxzNExfmXsuZuMfH9hdBdfDOD8kd8NulWkO5nnNHOddJ7TzLWVeU4z11Ze+yHmOc1cW3nth5jnNHNt5bUf6v+fZqeqE5zHje5jyOcA9wO+rN/u1+976UjdlcBNx372G+k+4vz42P73jXz/w2PPjV5D5VOcuCDs33Lyx6Dj15q5lBMfBf5Mv21+FPi9Y7XvYOy8LLrrtbwZ+OLIviObYwIXjuy/KTc+unMDJy62+s+cOEp1k7Hft4l5jtTflu4I5n+gW33zBMbOIwTuBXzFFj97Dt0Vnkf37aVrBMdrLwC+cYL3423oFnaM7rsJ3Ue1r6c7WviXdB+J/zAjq4Poztd70BaZ9wbeOLbvKcAttqj9CuBXx17P0e22/f47Af9lJ/OcZq6TznOaubYyz0V87YeY5yK+9kPMcxFf+yHmOevNVZYj+iMST6Y73+gCuk77GuDVwG9nvyIyIn6c7vDo28d+/t50l1542Mi+pwDrmfn5sdqvAH4kM3+sf3zp2HReld1RnzsBT8+xWyhFxG2Bh4/M81q6FYGfGau7F/CPmXnV2P5zgMdn5nr/eC/dJSGuH6u7gO5ctzdt8z/baO1t+to/b22ekiSVquoE3dzmdQPWTvV42roBMx99qsfT1lVnVo/fSmb1+K1kVo/fSmb1+K1kzmLb7iq2Sy8iHn2qx9PWDZi5dqrHO6ld5sze/zrN42nrhsr8N6d5PG1ddWb1+K1kVo/fSmb1+K1kVo/fSubwqjrBed+AZ53q8bR1A2Z+zake76R2mTPd3Nzc3NwqtvIJuLnNw0a3kucpdCsqHzj23M9OWzdU5ml+h4ftZt2ZZjLhhX6nqR0oc+ILDU9aO0TmNj/7X3azbohMTnFB5p3U7VYt3aKbm/bfB/AkukVVP8TYYpxJawfK/BbGFpGd4nfd9dppMvv6rwf+Vf/9v6VbIPXNO60bMPMWwLfTLTB4Gt1dWvZM+nsOsXlS/5iIuAXdC3MRcD3dBWL/KDOP76RuiMyIOJtu8cG30q0ETbqLqr6SbvHBv0xbO0TmqUTEWmYePF3dNLVnkhkRz6O7vtllwHcDb8/MZ/TPvTsz7zNN3VCZp/mdjmXm3t2qO5PMiHg88Kt0q4fPoVtV+67+ufH/nSaqHSjzKcAz6f4g/hLwvXSrqB9It0Dnt0cyJ6odIrOv/fXx/9np3i+/B5CZT5+mbsDMV2TmY/vvH0P3OrwNeADwXzPzd6epG6o2Iv4SuG9mbkTEL9FdA+sVdPfLJTO/byRzotqBMv8J+Ee6VYAvplsUdQNbGKJ2ysxfpbuO5Nl0l7B4aP9zD6K7FthPTlM3YObjgZ8E3gt8A90q/z3AVwHflWO3wJuZym5w3ja6q8W/C3ge3aUZfh9YB97HyH9VT1o3YOaL6S4lcX+6q/pf2H//W8Af7KR2oMzbbbPdHrh2LHOi2iEy+9rRy3WcDawBLwfO5eQLE05UN2Dmq7bZXk23SnWqugEzr2DyOxpMVDtQ5jQXGp70zgu7ntnvuxZ4Id0dMC7tt+s2v5+2bsDM0f99T3Xh6Inqhqqlu1fs5veXM3J0ZIvMiWoHynxP/374AbrLAH2S7vJBDxrNG6p2yswr6Zr1Fbo7zaz0+8/h5Ms8TVQ3YOb7Rp4/j67JBPhq4B3jv9estpJB53Wb9EWa5sUcKPPDp/gdxq+AP1HtQJk3AH9Dd8uizW3z8T+P/dxEtUNk9rUf2uJ3+Tngzzj5CtMT1Q2Y+Rm6i8w+aGx7MPDJaesGzJzmjgYT1Q6UOdHdFKapHSKzf3xLuqM9LwIu6Pf9zRbvnYnqBsyc6M4Tk9YNVUt3FOUh/fcvA/b1399+i9diotqBMsff23fq38d/Dlyz3e++W7VTZv5l//WmdP9/cbP+8Vmc3IBOVDdg5vvhS58Q3mzsfXFS8zbLrWTQed0mfZGmeTEHynwn8DhO/i+qPXS3ffqLndQOlPkRYO82/1uP/0OeqHaIzP7xC4FHbFH3/XR3B5iqbsDM1wHfsM3v9MfT1g2YOdGFfqepHShzmgsNT1Q7RObYz3wN8Fa682Ou3qpmmrrdzmTyC0dPfOHmIWrpTg15K93t7V5N90f8LXRHhB46ljlR7UCZ7znF67Fv7PGu106Z+Ut093h+F/Df+t/rEPBHwHOnrRs48w10Fyv/E+Bn+v23A6481b+VIbeSQed1m/RFmubFHChzP/AHdB8Z/FW/farfd5ed1A6U+VTgXtv8b/20sccT1Q6R6TbIv6V7MfkdDSaqHShz4rspTFo7ROYWz0f//n7haV6HieqGyhz7udswdueJM6nbrVrg7nQXA/82ujuzbHti96S1u5kJPHiK/413vXaazL7+a4H799/fla55f/wWv9dEdQNmPqp//mEj+/bglfrnR0Q8CrgH3X+dvrHft4fuv2K/OG3dUJkjP3N7uiNrn57gd5uodojMlkXEwzZfj92oGypTktQuG7IFU90ULFpmXzs3qxclSYvJhmzBVDcFrWZGxKu2K6U78fbm09QNlSlJWkxnV09A0zvNH/Db76R2mTN7Xwd8F92lB8Zr77uDuqEyJUmLqOrkNbedb9Rf0mChMvvaVlYv3gr4r3TXqXvi2HPPmbauOrN6/FYyq8dvJbN6/FYyq8dvJXPW2x70JRFxq4j4rxHx+xHxxLHnnjNt3VCZdJed2MjMt49tbwM+vMPaZc4kMx+ZmW9lC5n59dPWDZUJPJ/uyNnLgCdExMsi4tz+ufvvoK46s3r8VjKrx28ls3r8VjKrx28lc7aqOsF53PoX59nAY+muQP4y+iWwnHyxwYnqhsp0W96NG1+9/RDdBWRvP/Z+mqiuOrN6/FYyq8dvJbN6/FYyq8dvJXPWW8mg87q18mZyW94N+CA3vvbOpXS3DTk6bV11ZvX4rWRWj99KZvX4rWRWj99K5qy3kkHndWvlzeS2vBvwy2xxwVC6m9J/ZNq66szq8VvJrB6/lczq8VvJrB6/lcxZb172YkRE/DLwR5n5prH9jwB+IzMvnqZuqExJkrRgqjpBN7d52mhkdVC/7yuBhwK3GNv/iJ3UVWdWj99KZvX4rWRWj99KZvX4rWTOcisZdJ63Ft5MNLJkuJXM/nETCzqAp9OtEH0FcDXwmJHn3j1tXXVm9fitZFaP30pm9fitZFaP30rmrLeSQed1a+jNVN0ULFRm//iKscdzuaADeD99w053k/cjwI/2j98zbV11ZvX4rWRWj99KZvX4rWRWj99K5qw3r9R/sh8AviYzPx8R+4H/ExH7M/PX6K5ZMm3dUJl3zcxv679/RUQcAt4SEd+yxe80ae0yZwKcGxF7MvM4QGYejohrgT8GbrGDuqEyz8rMz/d1V0fEg+neK/s4+X0yaV11ZvX4rWRWj99KZvX4rWRWj99K5mxVdYLzuAEfGHt8C+D1wK8wchRj0roBM5tYMtxKZr+/ldVBbwEuGdt3NvB7wA3T1lVnVo/fSmb1+K1kVo/fSmb1+K1kznorGXRet4beTNVNwUJltrQBFwJ32ua5B05bV51ZPX4rmdXjt5JZPX4rmdXjt5I5683LXoyIiAuB6zPzE1s898DM/LNp6obK1DAi4iuBC4C/yP5wdr//EZn5+mnrhsrs99+xr0/gY5n5yW1+p4nqqjOrx28ls3r8VjKrx28ls3r8VjJnxYZsCy28maqbggXMfDrwVLqPOS+hO8Hzlf1z787M+0xTN2DmJcBzgVsDf9vvvhD4LPBDmfmeaeqqM6vHbyWzevxWMqvHbyWzevxWMmdu2kNqi7zR/TF8J90fxjf124f6ffeetm7AzOpVnguV2T9uZXXQFcD9tnjv3h9477R11ZnV47eSWT1+K5nV47eSWT1+K5mz3koGndetoTdTdVOwUJn941YWdGx77htw1bR11ZnV47eSWT1+K5nV47eSWT1+K5mz3rzsxclunpl/Mb4zM98ZETffQd1Qma0sGW4lE+ATEXFJZl7R138+Ih4N/A7wVTuoGyrzdRHxWrrFHtf0+y4CvoeuiZu2rjqzevxWMqvHbyWzevxWMqvHbyVzpjyHbERE/DpwV7Z+kT6amT8yTd2AmW8BnrH5B7zfdzbdH/DVzDxr2tplzuz3N7OgIyIeCTyG7ty4AK4FXpWZf7iTuurM6vFbyawev5XM6vFbyawev5XMWbIhG9PCm6m6KVi0zLH9c7+gQ5K0gLb6HNOtjQ24I3Af4N7AHXejdlkzaWdBx1nAU4BfBB4w9tzPTltXnVk9fiuZ1eO3klk9fiuZ1eO3kjnrrWTQed0aejNdQm1TsFCZfe0VtLGg43nAi4AfAy4HfmXkuXdPW1edWT1+K5nV47eSWT1+K5nV47eSOeutZNB53Rp6M11BA0uGW8ns97WyOuh9I9+fDawBLwfO5eTVqBPVVWdWj99KZvX4rWRWj99KZvX4rWTOetuDRt03M5+Ymb8K3A+4RUS8PCLO5eRVeZPWDZW57YpMYOJVnmO1y5wJ/aqbiPiOiHhAv31HvxLnRit5JqgbKvMmI7/H9Zl5kK7xfAsn34h80rrqzOrxW8msHr+VzOrxW8msHr+VzNmq6gTncQM+tMW+nwP+jJPvpzhR3YCZvw68FvgO4AH99h39vt/cSe0yZ47UP5Lu6s2vBl7Tf/+ondYNkQm8EHjEFvu/H/iXaeuqM6vHbyWzevxWMqvHbyWzevxWMme9ucpyRES8EHhh3vj2O98P/FZmnjNN3VCZ/f4mlgy3ktmKiLhzZn58t+qqM6vHbyWzevxWMqvHbyWzevxWMmfNhmxEK28m7b6IOIvuv44uBF6Xme8Yee5nM/M/T1M3YObrgNsCb6P7OPNPM/P6LX6fieqqM6vHbyWzevxWMqvHbyWzevxWMmfNhmxEQ2+m6qZgoTL7x88DVoDLgO8G3p6Zz+ifG70R+ER1Q2X2+24KPJjuY84HAsfo3jOvz8xj09ZVZ1aP30pm9fitZFaP30pm9fitZM6SDdmYFt5M1U3BomX2j9+XmV/df3828BzgPOA7gXdm5r2nqRsqcysRcRe698wjgDtl5n3PpK46s3r8VjKrx28ls3r8VjKrx28lc1BZdPJaKxtwF+CHgVcBl51p3W5k0siS4VYy++ebWNCxzfvkvJHvb3KmddWZ1eO3klk9fiuZ1eO3klk9fiuZQ24zH7C1bR7fTNSv8lyozH5/K6uDHgl8FPhTujsPXAn8Nd1ihYdOW1edWT1+K5nV47eSWT1+K5nV47eSOeutZNB53Rp6M1U3BQuV2e+784TvkYnqBsy8Arg78LXA3wH37/ffnZMvNDxRXXVm9fitZFaP30pm9fitZFaP30rmrLeSQed1a+jNVN0ULFRmX/s6ulsqPZvuPL6zz6RuwMzR98w14++1aeuqM6vHbyWzevxWMqvHbyWzevxWMme9nY1GHc/MDwJExEZ2V3QnMz8YEXt2UDdU5u9ExKRLdietXeZMMvORI4sqvhX47xFxo0UVk9YNlQl8NiKeAtwK+ExE/DjwUuAbgc/voK46s3r8VjKrx28ls3r8VjKrx28lc6a8ddLJPhsRT4mIn6R/kSLigoi4lC1e+AnqBsnMzEfS/fF+G90f8HdGd5ulgxGxdye1y5w5Uv+FzHx9Zv5oZh4A/gPdYoDfjIjLpq0bKPNS4D7AlwPf1O97A/B44Ad2UFedWT1+K5nV47eSWT1+K5nV47eSOVNe9mJERFwE/CxwHHgW3WUHngwcBX5i5AjWRHVDZW4z9yaWDLeS2deel5mf7r+/SWb+85nUDZUpSVoAVZ+Vuu3uRiNLhuc1k0YWdJzmd/u53ayrzqwev5XM6vFbyawev5XM6vFbyRxiKxm0xW2e3kzVTcGiZfa1V9DAgo7TvE+O7WZddWb1+K1kVo/fSmb1+K1kVo/fSuYQmx9ZTigijmXmjc472mndmWRGxBV0H2neBngN8M2Z+c6IuDuwnidfgX6i2mXO7GtH7wZwTWZeNJqTmZdMUzdg5j+wtQBulplnT1NXnVk9fiuZ1eO3klk9fiuZ1eO3kjlrJYPOq9O9SNPWDZVJ/SrPRcuEhlYHAf8mMz85tp+IuGYHddWZ1eO3klk9fiuZ1eO3klk9fiuZM+Uqy5N9Frg4M281tt0S+PgO6gbLjMJVnguYCe2sDvo9YB9be9EO6qozq8dvJbN6/FYyq8dvJbN6/FYyZyuLPiudxw34z8B9t3nul6atGzDzIuB/Ab8F3An4ceAvgdcCd99J7TJntrRxiovG7qSuOrN6/FYyq8dvJbN6/FYyq8dvJXPWm+eQjYiIs3P7i4xOXTdUpmYrIn4uM//TbtWdSWZEHKFblLB50dirt/m5ieqqM6vHbyWzevxWMqvHbyWzevxWMmfNhmxEK2+m0/wOgzcFy5TZ187Ngo5+3z5OXEvtArpVpK8D3p6ZX5y2rjqzevxWMqvHbyWzevxWMqvHbyVzlmzIxrTyZjrF/GfSFCxaZjSyOmiL3+Mc4Ovo3jMPBq7LzG/eaV11ZvX4rWRWj99KZvX4rWRWj99K5tBsyE5hXt9M1U3BomX2tcc4xaqb7C9FMWndUJmnExEXZObf7lZddWb1+K1kVo/fSmb1+K1kVo/fSuauyzk4ka2VDbhgN+t2mgkcA+64Td34nesnql3mzP5xEws6TvMeed1u1lVnVo/fSmb1+K1kVo/fSmb1+K1kDrF5HbIJRcTrsrtZ9a7UnWHm5pLdGx1RYfvlvaerXeZMgF/IbRZVZOZP7aBukMyIuM9WdXRH/S6Ztq46s3r8VjKrx28ls3r8VjKrx28lc9b8yHLEaV6k12TmnaepGzCzdJXnomX2tU0s6IiIG4C3070vxt0/M282TV11ZvX4rWRWj99KZvX4rWRWj99K5sxVHZqbxw24AXgL8NYttn+atm7AzCPAK4AfBPaf5neaqHaZM0fq9/W1rwDeBfwPugu1nruTuiEy6a6jdvE2879m2rrqzOrxW8msHr+VzOrxW8msHr+VzFlvJYPO69bKm6nfV9YULGLmFj93DvAQ4JeBy4DXnkndbmUC3w78q21+7rHT1lVnVo/fSmb1+K1kVo/fSmb1+K1kznrzI8sREfHtwPsz88NbPPfYzHzFNHVDZW7xfBNLhlvJ3OZnm1gdJElqVFUn6DbcxsCrPJcws5XVQU/azbrqzOrxW8msHr+VzOrxW8msHr+VzCE2j5BNKCKelJnP3626ATNnscpz4TJbWdBxKtHoRXnndfxWMqvHbyWzevxWMqvHbyVzCF72YnLPAiZpiiat23FmK0uGW8nsvYvtV93cZgd1g2RGxPu2qKH/2TtOW1edWT1+K5nV47eSWT1+K5nV47eSOWs2ZCNaeTNR3BQsYCbAB4GnZOZHxgsj4pod1A2VeUfg4cBnxkuBd+ygrjqzevxWMqvHbyWzevxWMqvHbyVzpmzITtbKm6m6KVi0TIBfAPaM1/WetoO6oTJfA9wiM68YL4yIt+2grjqzevxWMqvHbyWzevxWMqvHbyVztqpOXpvHDfht4N9u89yLpq0bMLOJJcOtZLq5ubm5uVVvntQvnUY0sqBDktSu7T4mUaMi4km7XbvMmb1n7XLdUJmSpEZ5hGzBtLJkeN4yT7Oo4m6Zee40dUNlSpIWkyf1N6h6leeiZfZaWdAhSVpANmRtqm4KFi0T2lkdJElaQDZkbapuChYtk8x88njNyHNPnLZuqExJ0mLyHDJJkqRirrKUJEkqZkMmSZJUzIZMkiSpmA2ZpKUQETdExBURcWVEvDcinhERp/z/wIjYHxEurJA0OBsyScvinzLzksy8J/Aw4FHAz5/mZ/YDNmSSBucqS0lLISI+n5m3GHn85cC7gPOAfcDvAzfvn/6RzHxHRLwTuDvwUeAFwK8DzwYeDJwL/M/M/F8z+yUkLSwbMklLYbwh6/d9BvhK4HPA8cz8QkRcDLw4Mw9ExIOBn8jMR/f1B4E7ZOZ/johzgT8DHpeZH53l7yJp8XhhWEnLLPqv5wC/GRGXADcAd9um/puAr46Ib+8f3xq4mO4ImiTtmA2ZpKXUf2R5A/ApunPJPgnci+7c2i9s92PA0zLzDTOZpKSl4Un9kpZORJwPPBf4zezO27g18PHMPA58N3BWX/o54JYjP/oG4Ici4pw+524RcXMk6Qx5hEzSsrhZRFxB9/Hk9XQn8f9K/9xzgJdFxOOAtwL/2O9/H3B9RLwX+F3g1+hWXr47IgK4DnjsbKYvaZF5Ur8kSVIxP7KUJEkqZkMmSZJUzIZMkiSpmA2ZJElSMRsySZKkYjZkkiRJxWzIJEmSitmQSZIkFfu/e4sOCYXLwNcAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 720x720 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.figure(figsize=(10,10))\n",
    "plt.scatter(df['Date'], df['Value'], marker='o', color='red')\n",
    "plt.xlabel('Date')\n",
    "plt.ylabel('Value')\n",
    "plt.gca().invert_xaxis()\n",
    "ax = plt.gca()\n",
    "ax.tick_params(axis='x', labelrotation = 90)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}