LIGHTS_DATASET.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "ecc9c684",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "cee97af9",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"LIGHT_DATASET.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "878fb75f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 500 entries, 0 to 499\n",
      "Data columns (total 13 columns):\n",
      " #   Column           Non-Null Count  Dtype  \n",
      "---  ------           --------------  -----  \n",
      " 0   DataMessageGUID  500 non-null    object \n",
      " 1   SensorID         500 non-null    int64  \n",
      " 2   Sensor Name      500 non-null    object \n",
      " 3   Date             500 non-null    object \n",
      " 4   Value            500 non-null    float64\n",
      " 5   Formatted Value  500 non-null    object \n",
      " 6   Battery          500 non-null    int64  \n",
      " 7   Raw Data         500 non-null    object \n",
      " 8   Sensor State     500 non-null    int64  \n",
      " 9   GatewayID        500 non-null    int64  \n",
      " 10  Alert Sent       500 non-null    bool   \n",
      " 11  Signal Strength  500 non-null    int64  \n",
      " 12  Voltage          500 non-null    float64\n",
      "dtypes: bool(1), float64(2), int64(5), object(5)\n",
      "memory usage: 47.5+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "2fc7b656",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                          DataMessageGUID  SensorID    Sensor Name  \\\n",
      "43   7475eb2b-d4a3-47b6-a549-f7af4d095419    682607  LightSensor 1   \n",
      "44   1b9cede6-b3f8-4050-a2d6-cab4857c6592    682607  LightSensor 1   \n",
      "45   7d31136e-7a22-4cfa-8a6e-abf4c5019d34    682607  LightSensor 1   \n",
      "46   a27efc11-9717-4343-a0f4-79448f1bc8c8    682607  LightSensor 1   \n",
      "47   4888ed7f-0cb6-40ac-b6ad-8ca9c776437b    682607  LightSensor 1   \n",
      "..                                    ...       ...            ...   \n",
      "495  b033046c-4928-4fa5-a0d2-bf47518b5802    682607  LightSensor 1   \n",
      "496  fb9febbf-10eb-4385-b79a-b85e37e9b1a4    682607  LightSensor 1   \n",
      "497  661f5e03-dbb4-4e06-9f61-345fb1c489da    682607  LightSensor 1   \n",
      "498  7e859614-7001-474b-8764-802099444089    682607  LightSensor 1   \n",
      "499  4ca22860-b404-4e95-9490-b4ab115fbafe    682607  LightSensor 1   \n",
      "\n",
      "                    Date   Value Formatted Value  Battery       Raw Data  \\\n",
      "43   11/18/2022 10:04 PM    9.47        9.47 lux      100    9.47|True|0   \n",
      "44    11/18/2022 9:49 PM    9.69        9.69 lux      100    9.69|True|0   \n",
      "45    11/18/2022 9:34 PM    9.60         9.6 lux      100     9.6|True|0   \n",
      "46    11/18/2022 9:19 PM    9.95        9.95 lux      100    9.95|True|0   \n",
      "47    11/18/2022 9:04 PM    9.61        9.61 lux      100    9.61|True|0   \n",
      "..                   ...     ...             ...      ...            ...   \n",
      "495   11/14/2022 9:49 AM   14.01       14.01 lux      100   14.01|True|0   \n",
      "496   11/14/2022 7:49 AM  137.04      137.04 lux      100  137.04|True|0   \n",
      "497   11/14/2022 5:49 AM    0.21        0.21 lux      100    0.21|True|0   \n",
      "498   11/14/2022 3:49 AM    0.17        0.17 lux      100    0.17|True|0   \n",
      "499   11/14/2022 1:49 AM    0.47        0.47 lux      100    0.47|True|0   \n",
      "\n",
      "     Sensor State  GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "43              0     964010       False              100     3.05  \n",
      "44              0     964010       False              100     3.06  \n",
      "45              0     964010       False              100     3.06  \n",
      "46              0     964010       False              100     3.06  \n",
      "47              0     964010       False              100     3.06  \n",
      "..            ...        ...         ...              ...      ...  \n",
      "495             0     964010       False              100     3.06  \n",
      "496             0     964010       False              100     3.06  \n",
      "497             0     964010       False              100     3.06  \n",
      "498             0     964010       False              100     3.06  \n",
      "499             0     964010       False              100     3.06  \n",
      "\n",
      "[457 rows x 13 columns]\n"
     ]
    }
   ],
   "source": [
    "n = 43\n",
    "df.drop(index=df.index[:n],inplace=True)\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b3b66606",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                         DataMessageGUID  SensorID    Sensor Name  \\\n",
      "43  7475eb2b-d4a3-47b6-a549-f7af4d095419    682607  LightSensor 1   \n",
      "44  1b9cede6-b3f8-4050-a2d6-cab4857c6592    682607  LightSensor 1   \n",
      "45  7d31136e-7a22-4cfa-8a6e-abf4c5019d34    682607  LightSensor 1   \n",
      "46  a27efc11-9717-4343-a0f4-79448f1bc8c8    682607  LightSensor 1   \n",
      "47  4888ed7f-0cb6-40ac-b6ad-8ca9c776437b    682607  LightSensor 1   \n",
      "48  82c8e5a3-f3f6-45e9-83fb-61b8dd318cfb    682607  LightSensor 1   \n",
      "49  a6ed24e9-2aaf-463d-9e09-d60165cea70c    682607  LightSensor 1   \n",
      "50  befadd7e-c6cd-4a1e-bcd0-9cb13455cc54    682607  LightSensor 1   \n",
      "51  d4a20e7d-e8aa-415a-86a0-b9279154d36a    682607  LightSensor 1   \n",
      "52  2d207cb4-bab7-425e-9b8e-1d4edaca0a4f    682607  LightSensor 1   \n",
      "53  eecd2b95-e64a-4edd-83b8-e32911404ba7    682607  LightSensor 1   \n",
      "54  8264fa72-5d38-4c47-8801-a66c4defc5d2    682607  LightSensor 1   \n",
      "55  0b4aa428-b79c-40d2-a4ec-4fdb731cb934    682607  LightSensor 1   \n",
      "56  5229c92f-e17e-4a41-8228-11e6eb49d36c    682607  LightSensor 1   \n",
      "57  141fcd7c-bd03-4eda-a712-13ceb43dc18c    682607  LightSensor 1   \n",
      "58  3196afb3-d5d0-4291-a9a0-0541b7df8138    682607  LightSensor 1   \n",
      "59  0f5c5e09-fcd6-4a5c-be4d-3ac0afc65dbf    682607  LightSensor 1   \n",
      "60  79980880-88d9-40c8-b77e-07ed105487b7    682607  LightSensor 1   \n",
      "61  0367c688-7d6e-43c7-9695-46daa5d59a9e    682607  LightSensor 1   \n",
      "62  92ce557e-b066-4871-b949-a8fd12a795e7    682607  LightSensor 1   \n",
      "63  3b1f0bff-8b9a-4295-b7f2-b69b64b43832    682607  LightSensor 1   \n",
      "64  df987b4d-7c22-4151-b8b9-85de9fa0fa86    682607  LightSensor 1   \n",
      "65  7292215b-700a-47d7-bf8b-1ac7bc248a43    682607  LightSensor 1   \n",
      "66  6cec6dd3-e8d9-4990-8f09-57f7248f0ead    682607  LightSensor 1   \n",
      "67  e4a4fbf3-26d0-4815-81f7-44c21061d178    682607  LightSensor 1   \n",
      "68  3d2531bf-0534-4e2a-98cb-832a591064ff    682607  LightSensor 1   \n",
      "69  013948a4-0d6d-49d0-a60c-c08c6efec6ee    682607  LightSensor 1   \n",
      "70  03f97723-775e-472c-a275-a786e4f6ea2a    682607  LightSensor 1   \n",
      "71  dc64ddc6-d4be-4c49-9761-86c6fd56fed5    682607  LightSensor 1   \n",
      "72  c2184806-285d-45c4-be9c-9193a8b4baae    682607  LightSensor 1   \n",
      "73  efc5a7c9-a282-4476-81c4-7182ac45157e    682607  LightSensor 1   \n",
      "74  e96d3703-393c-400b-8555-f18045bad65b    682607  LightSensor 1   \n",
      "75  ed2eb182-1701-4471-9eb4-f2c8fd4ac582    682607  LightSensor 1   \n",
      "76  a40b8182-0622-4b59-83e0-bd6c5c8f3081    682607  LightSensor 1   \n",
      "77  b54c9577-947e-4db1-972a-17a710bd5d2b    682607  LightSensor 1   \n",
      "78  1d539be3-f4d7-44c5-bf0e-4e68fa17e7cc    682607  LightSensor 1   \n",
      "79  c92fac57-2aeb-4474-b788-9cc5c49146e1    682607  LightSensor 1   \n",
      "80  8c3b1269-2f17-457f-b1a6-351cd9c8d2ad    682607  LightSensor 1   \n",
      "81  495e8a25-345e-4158-831b-2c7999f03891    682607  LightSensor 1   \n",
      "82  e83f2380-8a67-4472-8469-c3e705f29bf9    682607  LightSensor 1   \n",
      "83  726ad3bf-5388-4405-8209-b96eb2db6cc6    682607  LightSensor 1   \n",
      "84  609466df-83c2-48ff-8408-586bf49df262    682607  LightSensor 1   \n",
      "85  be0246ba-c1a9-4f1a-9993-5d154f86ab77    682607  LightSensor 1   \n",
      "86  77006bd7-5c49-43cb-a83d-5e594b427c14    682607  LightSensor 1   \n",
      "87  e4f538ed-ff30-4f34-8db1-e56e96936649    682607  LightSensor 1   \n",
      "88  6535a383-38f6-4c83-9950-bf9aac92b596    682607  LightSensor 1   \n",
      "89  04422325-789b-4087-a07e-8d6f0dd25417    682607  LightSensor 1   \n",
      "90  9266be98-b7b6-4301-8cfb-cb59de398288    682607  LightSensor 1   \n",
      "91  34ef71a7-1e2b-4967-9e61-c6eb98c511a6    682607  LightSensor 1   \n",
      "92  ce5cc4b4-9b5d-42c1-96bb-da04df6911aa    682607  LightSensor 1   \n",
      "93  b2f3288b-ff93-4296-bd13-e15d6ad2d485    682607  LightSensor 1   \n",
      "94  27952e24-f014-455e-b5f9-195ad123a205    682607  LightSensor 1   \n",
      "95  9aa69f12-0c9f-4680-bf4a-48cc51a5344f    682607  LightSensor 1   \n",
      "96  c32db3e5-ac31-4c7b-b2f2-caeea11c9cb6    682607  LightSensor 1   \n",
      "\n",
      "                   Date    Value Formatted Value  Battery        Raw Data  \\\n",
      "43  11/18/2022 10:04 PM     9.47        9.47 lux      100     9.47|True|0   \n",
      "44   11/18/2022 9:49 PM     9.69        9.69 lux      100     9.69|True|0   \n",
      "45   11/18/2022 9:34 PM     9.60         9.6 lux      100      9.6|True|0   \n",
      "46   11/18/2022 9:19 PM     9.95        9.95 lux      100     9.95|True|0   \n",
      "47   11/18/2022 9:04 PM     9.61        9.61 lux      100     9.61|True|0   \n",
      "48   11/18/2022 8:49 PM     9.53        9.53 lux      100     9.53|True|0   \n",
      "49   11/18/2022 8:34 PM     9.64        9.64 lux      100     9.64|True|0   \n",
      "50   11/18/2022 8:19 PM     8.77        8.77 lux      100     8.77|True|0   \n",
      "51   11/18/2022 8:04 PM     7.99        7.99 lux      100     7.99|True|0   \n",
      "52   11/18/2022 7:49 PM     8.18        8.18 lux      100     8.18|True|0   \n",
      "53   11/18/2022 7:34 PM     9.68        9.68 lux      100     9.68|True|0   \n",
      "54   11/18/2022 7:19 PM     9.72        9.72 lux      100     9.72|True|0   \n",
      "55   11/18/2022 7:04 PM     9.80         9.8 lux      100      9.8|True|0   \n",
      "56   11/18/2022 6:49 PM     9.77        9.77 lux      100     9.77|True|0   \n",
      "57   11/18/2022 6:34 PM     9.59        9.59 lux      100     9.59|True|0   \n",
      "58   11/18/2022 6:19 PM     9.48        9.48 lux      100     9.48|True|0   \n",
      "59   11/18/2022 6:04 PM    10.34       10.34 lux      100    10.34|True|0   \n",
      "60   11/18/2022 5:49 PM    10.52       10.52 lux      100    10.52|True|0   \n",
      "61   11/18/2022 5:34 PM    10.54       10.54 lux      100    10.54|True|0   \n",
      "62   11/18/2022 5:19 PM    10.53       10.53 lux      100    10.53|True|0   \n",
      "63   11/18/2022 5:04 PM    10.22       10.22 lux      100    10.22|True|0   \n",
      "64   11/18/2022 4:49 PM    10.41       10.41 lux      100    10.41|True|0   \n",
      "65   11/18/2022 4:34 PM    10.65       10.65 lux      100    10.65|True|0   \n",
      "66   11/18/2022 4:19 PM    14.34       14.34 lux      100    14.34|True|0   \n",
      "67   11/18/2022 4:04 PM    30.02       30.02 lux      100    30.02|True|0   \n",
      "68   11/18/2022 3:49 PM    65.28       65.28 lux      100    65.28|True|0   \n",
      "69   11/18/2022 3:34 PM   126.68      126.68 lux      100   126.68|True|0   \n",
      "70   11/18/2022 3:19 PM   196.32      196.32 lux      100   196.32|True|0   \n",
      "71   11/18/2022 3:04 PM   328.00         328 lux      100      328|True|0   \n",
      "72   11/18/2022 2:49 PM   347.84      347.84 lux      100   347.84|True|0   \n",
      "73   11/18/2022 2:49 PM   347.84      347.84 lux      100   347.84|True|0   \n",
      "74   11/18/2022 2:34 PM   345.12      345.12 lux      100   345.12|True|0   \n",
      "75   11/18/2022 2:19 PM   464.16      464.16 lux      100   464.16|True|0   \n",
      "76   11/18/2022 2:04 PM   523.20       523.2 lux      100    523.2|True|0   \n",
      "77   11/18/2022 1:49 PM   681.92      681.92 lux      100   681.92|True|0   \n",
      "78   11/18/2022 1:34 PM   983.68      983.68 lux      100   983.68|True|0   \n",
      "79   11/18/2022 1:19 PM  1531.52     1531.52 lux      100  1531.52|True|0   \n",
      "80   11/18/2022 1:04 PM  1458.56     1458.56 lux      100  1458.56|True|0   \n",
      "81  11/18/2022 12:49 PM  1067.20      1067.2 lux      100   1067.2|True|0   \n",
      "82  11/18/2022 12:34 PM  1312.64     1312.64 lux      100  1312.64|True|0   \n",
      "83  11/18/2022 12:19 PM  1514.88     1514.88 lux      100  1514.88|True|0   \n",
      "84  11/18/2022 12:04 PM  1062.72     1062.72 lux      100  1062.72|True|0   \n",
      "85  11/18/2022 11:49 AM  1315.20      1315.2 lux      100   1315.2|True|0   \n",
      "86  11/18/2022 11:34 AM  1058.24     1058.24 lux      100  1058.24|True|0   \n",
      "87  11/18/2022 11:19 AM   888.32      888.32 lux      100   888.32|True|0   \n",
      "88  11/18/2022 11:04 AM  1147.84     1147.84 lux      100  1147.84|True|0   \n",
      "89  11/18/2022 10:49 AM  1140.48     1140.48 lux      100  1140.48|True|0   \n",
      "90  11/18/2022 10:34 AM  1261.12     1261.12 lux      100  1261.12|True|0   \n",
      "91  11/18/2022 10:19 AM   811.52      811.52 lux      100   811.52|True|0   \n",
      "92  11/18/2022 10:04 AM   920.32      920.32 lux      100   920.32|True|0   \n",
      "93   11/18/2022 9:49 AM  2091.52     2091.52 lux      100  2091.52|True|0   \n",
      "94   11/18/2022 9:34 AM  2180.48     2180.48 lux      100  2180.48|True|0   \n",
      "95   11/18/2022 9:19 AM  2252.16     2252.16 lux      100  2252.16|True|0   \n",
      "96   11/18/2022 9:04 AM  1300.48     1300.48 lux      100  1300.48|True|0   \n",
      "\n",
      "    Sensor State  GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "43             0     964010       False              100     3.05  \n",
      "44             0     964010       False              100     3.06  \n",
      "45             0     964010       False              100     3.06  \n",
      "46             0     964010       False              100     3.06  \n",
      "47             0     964010       False              100     3.06  \n",
      "48             0     964010       False              100     3.06  \n",
      "49             0     964010       False              100     3.06  \n",
      "50             0     964010       False              100     3.06  \n",
      "51             0     964010       False              100     3.06  \n",
      "52             0     964010       False              100     3.06  \n",
      "53             0     964010       False              100     3.06  \n",
      "54             0     964010       False              100     3.06  \n",
      "55             0     964010       False              100     3.06  \n",
      "56             0     964010       False              100     3.06  \n",
      "57             0     964010       False              100     3.06  \n",
      "58             0     964010       False              100     3.06  \n",
      "59             0     964010       False              100     3.06  \n",
      "60             0     964010       False              100     3.06  \n",
      "61             0     964010       False              100     3.06  \n",
      "62             0     964010       False              100     3.06  \n",
      "63             0     964010       False              100     3.06  \n",
      "64             0     964010       False              100     3.06  \n",
      "65             0     964010       False              100     3.06  \n",
      "66             0     964010       False              100     3.06  \n",
      "67             0     964010       False              100     3.06  \n",
      "68             0     964010       False              100     3.06  \n",
      "69             0     964010       False              100     3.06  \n",
      "70             0     964010       False              100     3.06  \n",
      "71             0     964010       False              100     3.06  \n",
      "72             0     964010       False              100     3.06  \n",
      "73             0     964010       False              100     3.06  \n",
      "74             0     964010       False              100     3.06  \n",
      "75             0     964010       False              100     3.06  \n",
      "76             0     964010       False              100     3.06  \n",
      "77             0     964010       False              100     3.06  \n",
      "78             0     964010       False              100     3.06  \n",
      "79             0     964010       False              100     3.06  \n",
      "80             0     964010       False              100     3.06  \n",
      "81             0     964010       False              100     3.06  \n",
      "82             0     964010       False              100     3.06  \n",
      "83             0     964010       False              100     3.06  \n",
      "84             0     964010       False              100     3.06  \n",
      "85             0     964010       False              100     3.06  \n",
      "86             0     964010       False              100     3.06  \n",
      "87             0     964010       False              100     3.06  \n",
      "88             0     964010       False              100     3.06  \n",
      "89             0     964010       False              100     3.06  \n",
      "90             0     964010       False              100     3.06  \n",
      "91             0     964010       False              100     3.06  \n",
      "92             0     964010       False              100     3.04  \n",
      "93             0     964010       False              100     3.06  \n",
      "94             0     964010       False              100     3.06  \n",
      "95             0     964010       False              100     3.06  \n",
      "96             0     964010       False              100     3.06  \n"
     ]
    }
   ],
   "source": [
    "n = 403\n",
    "df.drop(df.tail(n).index,\n",
    "        inplace = True)\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "525e59d0",
   "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>43</th>\n",
       "      <td>7475eb2b-d4a3-47b6-a549-f7af4d095419</td>\n",
       "      <td>682607</td>\n",
       "      <td>LightSensor 1</td>\n",
       "      <td>11/18/2022 10:04 PM</td>\n",
       "      <td>9.47</td>\n",
       "      <td>9.47 lux</td>\n",
       "      <td>100</td>\n",
       "      <td>9.47|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>1b9cede6-b3f8-4050-a2d6-cab4857c6592</td>\n",
       "      <td>682607</td>\n",
       "      <td>LightSensor 1</td>\n",
       "      <td>11/18/2022 9:49 PM</td>\n",
       "      <td>9.69</td>\n",
       "      <td>9.69 lux</td>\n",
       "      <td>100</td>\n",
       "      <td>9.69|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>7d31136e-7a22-4cfa-8a6e-abf4c5019d34</td>\n",
       "      <td>682607</td>\n",
       "      <td>LightSensor 1</td>\n",
       "      <td>11/18/2022 9:34 PM</td>\n",
       "      <td>9.60</td>\n",
       "      <td>9.6 lux</td>\n",
       "      <td>100</td>\n",
       "      <td>9.6|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>a27efc11-9717-4343-a0f4-79448f1bc8c8</td>\n",
       "      <td>682607</td>\n",
       "      <td>LightSensor 1</td>\n",
       "      <td>11/18/2022 9:19 PM</td>\n",
       "      <td>9.95</td>\n",
       "      <td>9.95 lux</td>\n",
       "      <td>100</td>\n",
       "      <td>9.95|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>4888ed7f-0cb6-40ac-b6ad-8ca9c776437b</td>\n",
       "      <td>682607</td>\n",
       "      <td>LightSensor 1</td>\n",
       "      <td>11/18/2022 9:04 PM</td>\n",
       "      <td>9.61</td>\n",
       "      <td>9.61 lux</td>\n",
       "      <td>100</td>\n",
       "      <td>9.61|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         DataMessageGUID  SensorID    Sensor Name  \\\n",
       "43  7475eb2b-d4a3-47b6-a549-f7af4d095419    682607  LightSensor 1   \n",
       "44  1b9cede6-b3f8-4050-a2d6-cab4857c6592    682607  LightSensor 1   \n",
       "45  7d31136e-7a22-4cfa-8a6e-abf4c5019d34    682607  LightSensor 1   \n",
       "46  a27efc11-9717-4343-a0f4-79448f1bc8c8    682607  LightSensor 1   \n",
       "47  4888ed7f-0cb6-40ac-b6ad-8ca9c776437b    682607  LightSensor 1   \n",
       "\n",
       "                   Date  Value Formatted Value  Battery     Raw Data  \\\n",
       "43  11/18/2022 10:04 PM   9.47        9.47 lux      100  9.47|True|0   \n",
       "44   11/18/2022 9:49 PM   9.69        9.69 lux      100  9.69|True|0   \n",
       "45   11/18/2022 9:34 PM   9.60         9.6 lux      100   9.6|True|0   \n",
       "46   11/18/2022 9:19 PM   9.95        9.95 lux      100  9.95|True|0   \n",
       "47   11/18/2022 9:04 PM   9.61        9.61 lux      100  9.61|True|0   \n",
       "\n",
       "    Sensor State  GatewayID  Alert Sent  Signal Strength  Voltage  \n",
       "43             0     964010       False              100     3.05  \n",
       "44             0     964010       False              100     3.06  \n",
       "45             0     964010       False              100     3.06  \n",
       "46             0     964010       False              100     3.06  \n",
       "47             0     964010       False              100     3.06  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "ff13cf1f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(\"DataMessageGUID\", axis = 1, inplace = True)\n",
    "df.drop(\"SensorID\", axis = 1, inplace = True)\n",
    "df.drop(\"Sensor Name\", axis = 1, inplace = True)\n",
    "df.drop(\"Battery\", axis = 1, inplace = True)\n",
    "df.drop(\"GatewayID\", axis = 1, inplace = True)\n",
    "df.drop(\"Signal Strength\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "4152a51c",
   "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>Raw Data</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>Alert Sent</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>11/18/2022 10:04 PM</td>\n",
       "      <td>9.47</td>\n",
       "      <td>9.47 lux</td>\n",
       "      <td>9.47|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>3.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>11/18/2022 9:49 PM</td>\n",
       "      <td>9.69</td>\n",
       "      <td>9.69 lux</td>\n",
       "      <td>9.69|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>11/18/2022 9:34 PM</td>\n",
       "      <td>9.60</td>\n",
       "      <td>9.6 lux</td>\n",
       "      <td>9.6|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>11/18/2022 9:19 PM</td>\n",
       "      <td>9.95</td>\n",
       "      <td>9.95 lux</td>\n",
       "      <td>9.95|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>11/18/2022 9:04 PM</td>\n",
       "      <td>9.61</td>\n",
       "      <td>9.61 lux</td>\n",
       "      <td>9.61|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Date  Value Formatted Value     Raw Data  Sensor State  \\\n",
       "43  11/18/2022 10:04 PM   9.47        9.47 lux  9.47|True|0             0   \n",
       "44   11/18/2022 9:49 PM   9.69        9.69 lux  9.69|True|0             0   \n",
       "45   11/18/2022 9:34 PM   9.60         9.6 lux   9.6|True|0             0   \n",
       "46   11/18/2022 9:19 PM   9.95        9.95 lux  9.95|True|0             0   \n",
       "47   11/18/2022 9:04 PM   9.61        9.61 lux  9.61|True|0             0   \n",
       "\n",
       "    Alert Sent  Voltage  \n",
       "43       False     3.05  \n",
       "44       False     3.06  \n",
       "45       False     3.06  \n",
       "46       False     3.06  \n",
       "47       False     3.06  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2f9d842d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                   Date    Value Formatted Value        Raw Data  \\\n",
      "43  11/18/2022 10:04 PM     9.47        9.47 lux     9.47|True|0   \n",
      "44   11/18/2022 9:49 PM     9.69        9.69 lux     9.69|True|0   \n",
      "45   11/18/2022 9:34 PM     9.60         9.6 lux      9.6|True|0   \n",
      "46   11/18/2022 9:19 PM     9.95        9.95 lux     9.95|True|0   \n",
      "47   11/18/2022 9:04 PM     9.61        9.61 lux     9.61|True|0   \n",
      "48   11/18/2022 8:49 PM     9.53        9.53 lux     9.53|True|0   \n",
      "49   11/18/2022 8:34 PM     9.64        9.64 lux     9.64|True|0   \n",
      "50   11/18/2022 8:19 PM     8.77        8.77 lux     8.77|True|0   \n",
      "51   11/18/2022 8:04 PM     7.99        7.99 lux     7.99|True|0   \n",
      "52   11/18/2022 7:49 PM     8.18        8.18 lux     8.18|True|0   \n",
      "53   11/18/2022 7:34 PM     9.68        9.68 lux     9.68|True|0   \n",
      "54   11/18/2022 7:19 PM     9.72        9.72 lux     9.72|True|0   \n",
      "55   11/18/2022 7:04 PM     9.80         9.8 lux      9.8|True|0   \n",
      "56   11/18/2022 6:49 PM     9.77        9.77 lux     9.77|True|0   \n",
      "57   11/18/2022 6:34 PM     9.59        9.59 lux     9.59|True|0   \n",
      "58   11/18/2022 6:19 PM     9.48        9.48 lux     9.48|True|0   \n",
      "59   11/18/2022 6:04 PM    10.34       10.34 lux    10.34|True|0   \n",
      "60   11/18/2022 5:49 PM    10.52       10.52 lux    10.52|True|0   \n",
      "61   11/18/2022 5:34 PM    10.54       10.54 lux    10.54|True|0   \n",
      "62   11/18/2022 5:19 PM    10.53       10.53 lux    10.53|True|0   \n",
      "63   11/18/2022 5:04 PM    10.22       10.22 lux    10.22|True|0   \n",
      "64   11/18/2022 4:49 PM    10.41       10.41 lux    10.41|True|0   \n",
      "65   11/18/2022 4:34 PM    10.65       10.65 lux    10.65|True|0   \n",
      "66   11/18/2022 4:19 PM    14.34       14.34 lux    14.34|True|0   \n",
      "67   11/18/2022 4:04 PM    30.02       30.02 lux    30.02|True|0   \n",
      "68   11/18/2022 3:49 PM    65.28       65.28 lux    65.28|True|0   \n",
      "69   11/18/2022 3:34 PM   126.68      126.68 lux   126.68|True|0   \n",
      "70   11/18/2022 3:19 PM   196.32      196.32 lux   196.32|True|0   \n",
      "71   11/18/2022 3:04 PM   328.00         328 lux      328|True|0   \n",
      "72   11/18/2022 2:49 PM   347.84      347.84 lux   347.84|True|0   \n",
      "73   11/18/2022 2:49 PM   347.84      347.84 lux   347.84|True|0   \n",
      "74   11/18/2022 2:34 PM   345.12      345.12 lux   345.12|True|0   \n",
      "75   11/18/2022 2:19 PM   464.16      464.16 lux   464.16|True|0   \n",
      "76   11/18/2022 2:04 PM   523.20       523.2 lux    523.2|True|0   \n",
      "77   11/18/2022 1:49 PM   681.92      681.92 lux   681.92|True|0   \n",
      "78   11/18/2022 1:34 PM   983.68      983.68 lux   983.68|True|0   \n",
      "79   11/18/2022 1:19 PM  1531.52     1531.52 lux  1531.52|True|0   \n",
      "80   11/18/2022 1:04 PM  1458.56     1458.56 lux  1458.56|True|0   \n",
      "81  11/18/2022 12:49 PM  1067.20      1067.2 lux   1067.2|True|0   \n",
      "82  11/18/2022 12:34 PM  1312.64     1312.64 lux  1312.64|True|0   \n",
      "83  11/18/2022 12:19 PM  1514.88     1514.88 lux  1514.88|True|0   \n",
      "84  11/18/2022 12:04 PM  1062.72     1062.72 lux  1062.72|True|0   \n",
      "85  11/18/2022 11:49 AM  1315.20      1315.2 lux   1315.2|True|0   \n",
      "86  11/18/2022 11:34 AM  1058.24     1058.24 lux  1058.24|True|0   \n",
      "87  11/18/2022 11:19 AM   888.32      888.32 lux   888.32|True|0   \n",
      "88  11/18/2022 11:04 AM  1147.84     1147.84 lux  1147.84|True|0   \n",
      "89  11/18/2022 10:49 AM  1140.48     1140.48 lux  1140.48|True|0   \n",
      "90  11/18/2022 10:34 AM  1261.12     1261.12 lux  1261.12|True|0   \n",
      "91  11/18/2022 10:19 AM   811.52      811.52 lux   811.52|True|0   \n",
      "92  11/18/2022 10:04 AM   920.32      920.32 lux   920.32|True|0   \n",
      "93   11/18/2022 9:49 AM  2091.52     2091.52 lux  2091.52|True|0   \n",
      "94   11/18/2022 9:34 AM  2180.48     2180.48 lux  2180.48|True|0   \n",
      "95   11/18/2022 9:19 AM  2252.16     2252.16 lux  2252.16|True|0   \n",
      "96   11/18/2022 9:04 AM  1300.48     1300.48 lux  1300.48|True|0   \n",
      "\n",
      "    Sensor State  Alert Sent  Voltage  \n",
      "43             0       False     3.05  \n",
      "44             0       False     3.06  \n",
      "45             0       False     3.06  \n",
      "46             0       False     3.06  \n",
      "47             0       False     3.06  \n",
      "48             0       False     3.06  \n",
      "49             0       False     3.06  \n",
      "50             0       False     3.06  \n",
      "51             0       False     3.06  \n",
      "52             0       False     3.06  \n",
      "53             0       False     3.06  \n",
      "54             0       False     3.06  \n",
      "55             0       False     3.06  \n",
      "56             0       False     3.06  \n",
      "57             0       False     3.06  \n",
      "58             0       False     3.06  \n",
      "59             0       False     3.06  \n",
      "60             0       False     3.06  \n",
      "61             0       False     3.06  \n",
      "62             0       False     3.06  \n",
      "63             0       False     3.06  \n",
      "64             0       False     3.06  \n",
      "65             0       False     3.06  \n",
      "66             0       False     3.06  \n",
      "67             0       False     3.06  \n",
      "68             0       False     3.06  \n",
      "69             0       False     3.06  \n",
      "70             0       False     3.06  \n",
      "71             0       False     3.06  \n",
      "72             0       False     3.06  \n",
      "73             0       False     3.06  \n",
      "74             0       False     3.06  \n",
      "75             0       False     3.06  \n",
      "76             0       False     3.06  \n",
      "77             0       False     3.06  \n",
      "78             0       False     3.06  \n",
      "79             0       False     3.06  \n",
      "80             0       False     3.06  \n",
      "81             0       False     3.06  \n",
      "82             0       False     3.06  \n",
      "83             0       False     3.06  \n",
      "84             0       False     3.06  \n",
      "85             0       False     3.06  \n",
      "86             0       False     3.06  \n",
      "87             0       False     3.06  \n",
      "88             0       False     3.06  \n",
      "89             0       False     3.06  \n",
      "90             0       False     3.06  \n",
      "91             0       False     3.06  \n",
      "92             0       False     3.04  \n",
      "93             0       False     3.06  \n",
      "94             0       False     3.06  \n",
      "95             0       False     3.06  \n",
      "96             0       False     3.06  \n"
     ]
    }
   ],
   "source": [
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "0ea316a0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                   Date    Value Formatted Value        Raw Data  \\\n",
      "47   11/18/2022 9:04 PM     9.61        9.61 lux     9.61|True|0   \n",
      "48   11/18/2022 8:49 PM     9.53        9.53 lux     9.53|True|0   \n",
      "49   11/18/2022 8:34 PM     9.64        9.64 lux     9.64|True|0   \n",
      "50   11/18/2022 8:19 PM     8.77        8.77 lux     8.77|True|0   \n",
      "51   11/18/2022 8:04 PM     7.99        7.99 lux     7.99|True|0   \n",
      "52   11/18/2022 7:49 PM     8.18        8.18 lux     8.18|True|0   \n",
      "53   11/18/2022 7:34 PM     9.68        9.68 lux     9.68|True|0   \n",
      "54   11/18/2022 7:19 PM     9.72        9.72 lux     9.72|True|0   \n",
      "55   11/18/2022 7:04 PM     9.80         9.8 lux      9.8|True|0   \n",
      "56   11/18/2022 6:49 PM     9.77        9.77 lux     9.77|True|0   \n",
      "57   11/18/2022 6:34 PM     9.59        9.59 lux     9.59|True|0   \n",
      "58   11/18/2022 6:19 PM     9.48        9.48 lux     9.48|True|0   \n",
      "59   11/18/2022 6:04 PM    10.34       10.34 lux    10.34|True|0   \n",
      "60   11/18/2022 5:49 PM    10.52       10.52 lux    10.52|True|0   \n",
      "61   11/18/2022 5:34 PM    10.54       10.54 lux    10.54|True|0   \n",
      "62   11/18/2022 5:19 PM    10.53       10.53 lux    10.53|True|0   \n",
      "63   11/18/2022 5:04 PM    10.22       10.22 lux    10.22|True|0   \n",
      "64   11/18/2022 4:49 PM    10.41       10.41 lux    10.41|True|0   \n",
      "65   11/18/2022 4:34 PM    10.65       10.65 lux    10.65|True|0   \n",
      "66   11/18/2022 4:19 PM    14.34       14.34 lux    14.34|True|0   \n",
      "67   11/18/2022 4:04 PM    30.02       30.02 lux    30.02|True|0   \n",
      "68   11/18/2022 3:49 PM    65.28       65.28 lux    65.28|True|0   \n",
      "69   11/18/2022 3:34 PM   126.68      126.68 lux   126.68|True|0   \n",
      "70   11/18/2022 3:19 PM   196.32      196.32 lux   196.32|True|0   \n",
      "71   11/18/2022 3:04 PM   328.00         328 lux      328|True|0   \n",
      "72   11/18/2022 2:49 PM   347.84      347.84 lux   347.84|True|0   \n",
      "73   11/18/2022 2:49 PM   347.84      347.84 lux   347.84|True|0   \n",
      "74   11/18/2022 2:34 PM   345.12      345.12 lux   345.12|True|0   \n",
      "75   11/18/2022 2:19 PM   464.16      464.16 lux   464.16|True|0   \n",
      "76   11/18/2022 2:04 PM   523.20       523.2 lux    523.2|True|0   \n",
      "77   11/18/2022 1:49 PM   681.92      681.92 lux   681.92|True|0   \n",
      "78   11/18/2022 1:34 PM   983.68      983.68 lux   983.68|True|0   \n",
      "79   11/18/2022 1:19 PM  1531.52     1531.52 lux  1531.52|True|0   \n",
      "80   11/18/2022 1:04 PM  1458.56     1458.56 lux  1458.56|True|0   \n",
      "81  11/18/2022 12:49 PM  1067.20      1067.2 lux   1067.2|True|0   \n",
      "82  11/18/2022 12:34 PM  1312.64     1312.64 lux  1312.64|True|0   \n",
      "83  11/18/2022 12:19 PM  1514.88     1514.88 lux  1514.88|True|0   \n",
      "84  11/18/2022 12:04 PM  1062.72     1062.72 lux  1062.72|True|0   \n",
      "85  11/18/2022 11:49 AM  1315.20      1315.2 lux   1315.2|True|0   \n",
      "86  11/18/2022 11:34 AM  1058.24     1058.24 lux  1058.24|True|0   \n",
      "87  11/18/2022 11:19 AM   888.32      888.32 lux   888.32|True|0   \n",
      "88  11/18/2022 11:04 AM  1147.84     1147.84 lux  1147.84|True|0   \n",
      "89  11/18/2022 10:49 AM  1140.48     1140.48 lux  1140.48|True|0   \n",
      "90  11/18/2022 10:34 AM  1261.12     1261.12 lux  1261.12|True|0   \n",
      "91  11/18/2022 10:19 AM   811.52      811.52 lux   811.52|True|0   \n",
      "92  11/18/2022 10:04 AM   920.32      920.32 lux   920.32|True|0   \n",
      "93   11/18/2022 9:49 AM  2091.52     2091.52 lux  2091.52|True|0   \n",
      "94   11/18/2022 9:34 AM  2180.48     2180.48 lux  2180.48|True|0   \n",
      "95   11/18/2022 9:19 AM  2252.16     2252.16 lux  2252.16|True|0   \n",
      "96   11/18/2022 9:04 AM  1300.48     1300.48 lux  1300.48|True|0   \n",
      "\n",
      "    Sensor State  Alert Sent  Voltage  \n",
      "47             0       False     3.06  \n",
      "48             0       False     3.06  \n",
      "49             0       False     3.06  \n",
      "50             0       False     3.06  \n",
      "51             0       False     3.06  \n",
      "52             0       False     3.06  \n",
      "53             0       False     3.06  \n",
      "54             0       False     3.06  \n",
      "55             0       False     3.06  \n",
      "56             0       False     3.06  \n",
      "57             0       False     3.06  \n",
      "58             0       False     3.06  \n",
      "59             0       False     3.06  \n",
      "60             0       False     3.06  \n",
      "61             0       False     3.06  \n",
      "62             0       False     3.06  \n",
      "63             0       False     3.06  \n",
      "64             0       False     3.06  \n",
      "65             0       False     3.06  \n",
      "66             0       False     3.06  \n",
      "67             0       False     3.06  \n",
      "68             0       False     3.06  \n",
      "69             0       False     3.06  \n",
      "70             0       False     3.06  \n",
      "71             0       False     3.06  \n",
      "72             0       False     3.06  \n",
      "73             0       False     3.06  \n",
      "74             0       False     3.06  \n",
      "75             0       False     3.06  \n",
      "76             0       False     3.06  \n",
      "77             0       False     3.06  \n",
      "78             0       False     3.06  \n",
      "79             0       False     3.06  \n",
      "80             0       False     3.06  \n",
      "81             0       False     3.06  \n",
      "82             0       False     3.06  \n",
      "83             0       False     3.06  \n",
      "84             0       False     3.06  \n",
      "85             0       False     3.06  \n",
      "86             0       False     3.06  \n",
      "87             0       False     3.06  \n",
      "88             0       False     3.06  \n",
      "89             0       False     3.06  \n",
      "90             0       False     3.06  \n",
      "91             0       False     3.06  \n",
      "92             0       False     3.04  \n",
      "93             0       False     3.06  \n",
      "94             0       False     3.06  \n",
      "95             0       False     3.06  \n",
      "96             0       False     3.06  \n"
     ]
    }
   ],
   "source": [
    "n = 4\n",
    "df.drop(index=df.index[:n],inplace=True)\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "06a65362",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                   Date    Value Formatted Value        Raw Data  \\\n",
      "47   11/18/2022 9:04 PM     9.61        9.61 lux     9.61|True|0   \n",
      "48   11/18/2022 8:49 PM     9.53        9.53 lux     9.53|True|0   \n",
      "49   11/18/2022 8:34 PM     9.64        9.64 lux     9.64|True|0   \n",
      "50   11/18/2022 8:19 PM     8.77        8.77 lux     8.77|True|0   \n",
      "51   11/18/2022 8:04 PM     7.99        7.99 lux     7.99|True|0   \n",
      "52   11/18/2022 7:49 PM     8.18        8.18 lux     8.18|True|0   \n",
      "53   11/18/2022 7:34 PM     9.68        9.68 lux     9.68|True|0   \n",
      "54   11/18/2022 7:19 PM     9.72        9.72 lux     9.72|True|0   \n",
      "55   11/18/2022 7:04 PM     9.80         9.8 lux      9.8|True|0   \n",
      "56   11/18/2022 6:49 PM     9.77        9.77 lux     9.77|True|0   \n",
      "57   11/18/2022 6:34 PM     9.59        9.59 lux     9.59|True|0   \n",
      "58   11/18/2022 6:19 PM     9.48        9.48 lux     9.48|True|0   \n",
      "59   11/18/2022 6:04 PM    10.34       10.34 lux    10.34|True|0   \n",
      "60   11/18/2022 5:49 PM    10.52       10.52 lux    10.52|True|0   \n",
      "61   11/18/2022 5:34 PM    10.54       10.54 lux    10.54|True|0   \n",
      "62   11/18/2022 5:19 PM    10.53       10.53 lux    10.53|True|0   \n",
      "63   11/18/2022 5:04 PM    10.22       10.22 lux    10.22|True|0   \n",
      "64   11/18/2022 4:49 PM    10.41       10.41 lux    10.41|True|0   \n",
      "65   11/18/2022 4:34 PM    10.65       10.65 lux    10.65|True|0   \n",
      "66   11/18/2022 4:19 PM    14.34       14.34 lux    14.34|True|0   \n",
      "67   11/18/2022 4:04 PM    30.02       30.02 lux    30.02|True|0   \n",
      "68   11/18/2022 3:49 PM    65.28       65.28 lux    65.28|True|0   \n",
      "69   11/18/2022 3:34 PM   126.68      126.68 lux   126.68|True|0   \n",
      "70   11/18/2022 3:19 PM   196.32      196.32 lux   196.32|True|0   \n",
      "71   11/18/2022 3:04 PM   328.00         328 lux      328|True|0   \n",
      "72   11/18/2022 2:49 PM   347.84      347.84 lux   347.84|True|0   \n",
      "73   11/18/2022 2:49 PM   347.84      347.84 lux   347.84|True|0   \n",
      "74   11/18/2022 2:34 PM   345.12      345.12 lux   345.12|True|0   \n",
      "75   11/18/2022 2:19 PM   464.16      464.16 lux   464.16|True|0   \n",
      "76   11/18/2022 2:04 PM   523.20       523.2 lux    523.2|True|0   \n",
      "77   11/18/2022 1:49 PM   681.92      681.92 lux   681.92|True|0   \n",
      "78   11/18/2022 1:34 PM   983.68      983.68 lux   983.68|True|0   \n",
      "79   11/18/2022 1:19 PM  1531.52     1531.52 lux  1531.52|True|0   \n",
      "80   11/18/2022 1:04 PM  1458.56     1458.56 lux  1458.56|True|0   \n",
      "81  11/18/2022 12:49 PM  1067.20      1067.2 lux   1067.2|True|0   \n",
      "82  11/18/2022 12:34 PM  1312.64     1312.64 lux  1312.64|True|0   \n",
      "83  11/18/2022 12:19 PM  1514.88     1514.88 lux  1514.88|True|0   \n",
      "84  11/18/2022 12:04 PM  1062.72     1062.72 lux  1062.72|True|0   \n",
      "85  11/18/2022 11:49 AM  1315.20      1315.2 lux   1315.2|True|0   \n",
      "86  11/18/2022 11:34 AM  1058.24     1058.24 lux  1058.24|True|0   \n",
      "87  11/18/2022 11:19 AM   888.32      888.32 lux   888.32|True|0   \n",
      "88  11/18/2022 11:04 AM  1147.84     1147.84 lux  1147.84|True|0   \n",
      "89  11/18/2022 10:49 AM  1140.48     1140.48 lux  1140.48|True|0   \n",
      "90  11/18/2022 10:34 AM  1261.12     1261.12 lux  1261.12|True|0   \n",
      "91  11/18/2022 10:19 AM   811.52      811.52 lux   811.52|True|0   \n",
      "92  11/18/2022 10:04 AM   920.32      920.32 lux   920.32|True|0   \n",
      "93   11/18/2022 9:49 AM  2091.52     2091.52 lux  2091.52|True|0   \n",
      "94   11/18/2022 9:34 AM  2180.48     2180.48 lux  2180.48|True|0   \n",
      "95   11/18/2022 9:19 AM  2252.16     2252.16 lux  2252.16|True|0   \n",
      "96   11/18/2022 9:04 AM  1300.48     1300.48 lux  1300.48|True|0   \n",
      "\n",
      "    Sensor State  Alert Sent  Voltage  \n",
      "47             0       False     3.06  \n",
      "48             0       False     3.06  \n",
      "49             0       False     3.06  \n",
      "50             0       False     3.06  \n",
      "51             0       False     3.06  \n",
      "52             0       False     3.06  \n",
      "53             0       False     3.06  \n",
      "54             0       False     3.06  \n",
      "55             0       False     3.06  \n",
      "56             0       False     3.06  \n",
      "57             0       False     3.06  \n",
      "58             0       False     3.06  \n",
      "59             0       False     3.06  \n",
      "60             0       False     3.06  \n",
      "61             0       False     3.06  \n",
      "62             0       False     3.06  \n",
      "63             0       False     3.06  \n",
      "64             0       False     3.06  \n",
      "65             0       False     3.06  \n",
      "66             0       False     3.06  \n",
      "67             0       False     3.06  \n",
      "68             0       False     3.06  \n",
      "69             0       False     3.06  \n",
      "70             0       False     3.06  \n",
      "71             0       False     3.06  \n",
      "72             0       False     3.06  \n",
      "73             0       False     3.06  \n",
      "74             0       False     3.06  \n",
      "75             0       False     3.06  \n",
      "76             0       False     3.06  \n",
      "77             0       False     3.06  \n",
      "78             0       False     3.06  \n",
      "79             0       False     3.06  \n",
      "80             0       False     3.06  \n",
      "81             0       False     3.06  \n",
      "82             0       False     3.06  \n",
      "83             0       False     3.06  \n",
      "84             0       False     3.06  \n",
      "85             0       False     3.06  \n",
      "86             0       False     3.06  \n",
      "87             0       False     3.06  \n",
      "88             0       False     3.06  \n",
      "89             0       False     3.06  \n",
      "90             0       False     3.06  \n",
      "91             0       False     3.06  \n",
      "92             0       False     3.04  \n",
      "93             0       False     3.06  \n",
      "94             0       False     3.06  \n",
      "95             0       False     3.06  \n",
      "96             0       False     3.06  \n"
     ]
    }
   ],
   "source": [
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "04468829",
   "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>Raw Data</th>\n",
       "      <th>Sensor State</th>\n",
       "      <th>Alert Sent</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>11/18/2022 9:04 PM</td>\n",
       "      <td>9.61</td>\n",
       "      <td>9.61 lux</td>\n",
       "      <td>9.61|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>11/18/2022 8:49 PM</td>\n",
       "      <td>9.53</td>\n",
       "      <td>9.53 lux</td>\n",
       "      <td>9.53|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>11/18/2022 8:34 PM</td>\n",
       "      <td>9.64</td>\n",
       "      <td>9.64 lux</td>\n",
       "      <td>9.64|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>11/18/2022 8:19 PM</td>\n",
       "      <td>8.77</td>\n",
       "      <td>8.77 lux</td>\n",
       "      <td>8.77|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>11/18/2022 8:04 PM</td>\n",
       "      <td>7.99</td>\n",
       "      <td>7.99 lux</td>\n",
       "      <td>7.99|True|0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>3.06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Date  Value Formatted Value     Raw Data  Sensor State  \\\n",
       "47  11/18/2022 9:04 PM   9.61        9.61 lux  9.61|True|0             0   \n",
       "48  11/18/2022 8:49 PM   9.53        9.53 lux  9.53|True|0             0   \n",
       "49  11/18/2022 8:34 PM   9.64        9.64 lux  9.64|True|0             0   \n",
       "50  11/18/2022 8:19 PM   8.77        8.77 lux  8.77|True|0             0   \n",
       "51  11/18/2022 8:04 PM   7.99        7.99 lux  7.99|True|0             0   \n",
       "\n",
       "    Alert Sent  Voltage  \n",
       "47       False     3.06  \n",
       "48       False     3.06  \n",
       "49       False     3.06  \n",
       "50       False     3.06  \n",
       "51       False     3.06  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "31ca28ca",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                  Date    Value Formatted Value        Raw Data  Sensor State  \\\n",
      "95  11/18/2022 9:19 AM  2252.16     2252.16 lux  2252.16|True|0             0   \n",
      "\n",
      "    Alert Sent  Voltage  \n",
      "95       False     3.06  \n"
     ]
    }
   ],
   "source": [
    "print(df[df.Value == df.Value.max()])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "66f874ca",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                  Date  Value Formatted Value     Raw Data  Sensor State  \\\n",
      "51  11/18/2022 8:04 PM   7.99        7.99 lux  7.99|True|0             0   \n",
      "\n",
      "    Alert Sent  Voltage  \n",
      "51       False     3.06  \n"
     ]
    }
   ],
   "source": [
    "print(df[df.Value == df.Value.min()])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "3255edef",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Value           579.0914\n",
      "Sensor State      0.0000\n",
      "Alert Sent        0.0000\n",
      "Voltage           3.0596\n",
      "dtype: float64\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\User\\AppData\\Local\\Temp\\ipykernel_19596\\2807316344.py:1: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError.  Select only valid columns before calling the reduction.\n",
      "  print(df.mean())\n"
     ]
    }
   ],
   "source": [
    "print(df.mean())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "14f73fcd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAmoAAAKvCAYAAADa9+N4AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAABGCUlEQVR4nO3de7xkZ1Xg/d/qNAQOEG4Jl0nobsQ4AqME6AkRRuUiEtARVEDkCJFBm+Gio8z4emnHy8z0iMyMF+ANzBnucgSZgQEEAnJHBYQOhISAQJR0J4IQFV6CR9Ek6/1j72NXV59zeu/Ttet59qnf9/PZn6r91Kq1nuqqpFfvqmfvyEwkSZJUn12lJyBJkqSN2ahJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmiRJUqV2l57AUM4888zct29f6WlIkiSd1KWXXvpXmXnW9PiObdT27dvH4cOHS09DkiTppCLiyEbjfvUpSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2akNbXYV9+2DXruZ2dbX0jCRJ0kjsLj2BHW11FQ4cgLW1Zv/IkWYfYHm53LwkSdIoeERtSAcPHmvS1q2tNeOSJEknYaM2pKNH+41LkiRNsFEb0p49/cYlSZIm2KgN6dAhWFo6fmxpqRmXJEk6CRu1IS0vw8oK7N0LEc3tyooLCSRJUieu+hza8rKNmSRJ2haPqEmSJFXKRk2SJKlSNmqSJEmVslGTJEmqlI2aJElSpWzUJEmSKmWjJkmSVCkbtVqsrsK+fbBrV3O7ulp6RpIkqTBPeFuD1VU4cADW1pr9I0eaffBkuZIkLTCPqNXg4MFjTdq6tbVmXJIkLSwbtRocPdpvXJIkLQQbtRrs2dNvXJIkLQQbtRocOgRLS8ePLS0145IkaWHZqNVgeRlWVmDvXohobldWXEggSdKCc9VnLZaXbcwkSdJxPKImSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2amO0ugr79sGuXc3t6mrpGUmSpAHsLj0B9bS6CgcOwNpas3/kSLMPsLxcbl6SJGnmPKI2NgcPHmvS1q2tNeOSJGlHsVEbm6NH+41LkqTRslEbmz17+o1LkqTRslEbm0OHYGnp+LGlpWZckiTtKDZqY7O8DCsrsHcvRDS3KysuJJAkaQdy1ecYLS/bmEmStAA8oiZJklQpGzVJkqRK2ahJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmiRJUqVs1CRJkiployZJklQpGzVJkqRK2ahJkiRVarBGLSLuFhHviYhPRcSVEfHv2vE7RMQ7IuKz7e3tJ57z8xFxVUR8OiIeMTF+/4i4on3seRERQ81bkiSpFkMeUbsB+PeZeU/gAuCZEXEv4OeAd2XmucC72n3ax54A3Bu4ELg4Ik5rc70QOACc224XDjhvSZKkKgzWqGXmFzLzo+3964FPAWcDjwZe0Ya9AnhMe//RwGsy8+uZ+TngKuD8iLgrcEZmfjAzE3jlxHMkSZJ2rLn8Ri0i9gH3Bf4EuHNmfgGaZg64Uxt2NnDNxNOubcfObu9Pj0uSJO1ogzdqEXFr4HXAT2XmV7cK3WAstxjfqNaBiDgcEYevu+66/pOVJEmqyKCNWkTcjKZJW83M17fDX2y/zqS9/VI7fi1wt4mnnwN8vh0/Z4PxE2TmSmbuz8z9Z5111uxeiCRJUgFDrvoM4CXApzLzNyYeehNwUXv/IuCNE+NPiIjTI+LuNIsGPtx+PXp9RFzQ5nzyxHMkSZJ2rN0D5n4Q8CTgioi4rB37BeA5wGsj4qnAUeBxAJl5ZUS8FvgkzYrRZ2bmje3zng68HLglcEm7SZIk7WjRLKTcefbv35+HDx8uPQ1JkqSTiohLM3P/9LhXJpAkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2atKiW12Ffftg167mdnW19IwkSa3dpScgqaDVVThwANbWmv0jR5p9gOXlcvOSJAEeUZMW28GDx5q0dWtrzbgkqTgbNWmRHT3ab1ySNFc2atIQxvK7rz17+o1LkubKRk2atfXffR05ApnHfvdVY7N26BAsLR0/trTUjEuSirNRk2ZtTL/7Wl6GlRXYuxcimtuVFRcSSFIlBmvUIuKlEfGliPjExNivRMRfRMRl7faoicd+PiKuiohPR8QjJsbvHxFXtI89LyJiqDlLMzG2330tL8PVV8NNNzW3NmmSVI0hj6i9HLhwg/HfzMzz2u2tABFxL+AJwL3b51wcEae18S8EDgDntttGOaV6+LsvSdKMDNaoZeb7gb/pGP5o4DWZ+fXM/BxwFXB+RNwVOCMzP5iZCbwSeMwgE5Zmxd99SZJmpMRv1J4VEZe3X43evh07G7hmIubaduzs9v70+IYi4kBEHI6Iw9ddd92s5y114+++JEkzMu9G7YXAPYDzgC8A/6Md3+h3Z7nF+IYycyUz92fm/rPOOusUpyqdAn/3JUmagbk2apn5xcy8MTNvAv4XcH770LXA3SZCzwE+346fs8G4JEnSjjfXRq39zdm67wfWV4S+CXhCRJweEXenWTTw4cz8AnB9RFzQrvZ8MvDGec5ZkiSplMEuyh4RrwYeDJwZEdcCvww8OCLOo/n68mrgaQCZeWVEvBb4JHAD8MzMvLFN9XSaFaS3BC5pN0mSpB0vmsWUO8/+/fvz8OHDpachSZJ0UhFxaWbunx73ygTSTjSWa41KkrY02FefkgpZv9bo+mWs1q81Cq4+laSR8YiatNOM6VqjkqQt2ahJO83YrjUqSdqUjZq003itUUnaMWzUpJ3Ga41K0o5hoybtNF5rVJJ2DFd9SjvR8rKNmSTtAB5RkyRJqpSNmiRJUqVs1CRJkiployZJklQpGzVJkqRK2ahJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmiRJUqVs1CRJkiployZJklQpGzVJkqRK2ahJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmiRJUqVs1CRJkiployZJklQpGzVJkqRK2ahJkiRVykZNkiSpUjZqkiRJlbJRk1ZXYd8+2LWruV1dLT0jSZIAGzUtutVVOHAAjhyBzOb2wIH5Nms2ipKkTdioabEdPAhra8ePra014/NQQ6MoSaqWjdp2eARk5zh6tN/4rJVuFCVJVbNR68sjIDvLnj39xmetdKMoSaqajVpfHgHZWQ4dgqWl48eWlprxeSjdKEqSqmaj1pdHQHaW5WVYWYG9eyGiuV1ZacbnoXSjKEmqmo1aXx4B2XmWl+Hqq+Gmm5rbeTVp67VLNoqSpKrZqPXlERDNWslGUZJUNRu1vjwCIkmS5mR36QmM0vKyjZkkSRqcR9QkSZIqZaOmfjzZryRJc+NXn+pu/WS/6+eRWz/ZL/hVsCRJA/CImrrzZL+SJM2VjZq682S/kiTNlY2auvNkv5IkzZWNmrrzZL+SJM2VjZq682S/kiTNlas+1Y8n+5UkaW48oiZJklQpGzVJkqRK2ahJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmiRJUqVs1CRJkiployZJklQpGzVJkqRK2ahJkiRVykZNkiSpUp0btYi41ZATkSRJ0vFO2qhFxAMj4pPAp9r9+0TExYPPTJIkacF1OaL2m8AjgL8GyMyPA98x5KQkSZLU8avPzLxmaujGAeYiSZKkCbs7xFwTEQ8EMiJuDvwk7degkiRJGk6XI2r/FngmcDZwLXBeuy/Nzuoq7NsHu3Y1t6urpWckSVJxJ23UMvOvMnM5M++cmXfKzB/JzL+ex+Q0cl2br9VVOHAAjhyBzOb2wAGbNUnSwovM3Dog4mXACUGZ+W+GmtQs7N+/Pw8fPlx6GotrvflaWzs2trQEKyuwvHx87L59TXM2be9euPrqIWcpSVIVIuLSzNw/Pd7lq883A29pt3cBZwBfm+30tOMcPHh8kwbN/sGDJ8YePbpxjs3GJUlaECddTJCZr5vcj4hXA+8cbEbaGfo0X3v2bHxEbc+e2c5JkqSR2c4lpM4F/BtUW9usydpo/NCh5mvRSUtLzbgkSQusy5UJro+Ir67fAr8P/OzwU9Oo9Wm+lpeb367t3QsRze1Gv2WTJGnBdPnq8zbzmIh2mPUm6+DB5uvOPXuaJm2z5mt52cZMkqQpmzZqEXG/rZ6YmR+d/XS0o9h8SZJ0SrY6ovY/tngsgYfOeC6SJEmasGmjlpkPmedEJEmSdLwu1/okIv4FcC/gFutjmfnKoSYlSZKkDo1aRPwy8GCaRu2twCOBPwJs1CRJkgbU5TxqjwUeBvxlZj4FuA9w+qCzkiRJUqdG7e8z8ybghog4A/gS8A3DTkuSJElbnZ7jBcCrgQ9HxO2A/wVcSnOdzw/PZXaSJEkLbKvfqH0W+O/AP6Npzl4NPBw4IzMvn8PcJEmSFtqmX31m5m9n5rcB3wH8DfAy4BLgMRFx7pzmJ0mStLBO+hu1zDySmb+emfcFngh8P/Cng89M0olWV2HfPti1q7ldXS09I0nSgLpclP1mEfGvI2KV5ojaZ4AfHHxmUo1KNkqrq3DgABw5ApnN7YEDNmuStINt2qhFxMMj4qXAtcABmnOo3SMzfygz3zCn+UnbN+umqnSjdPAgrK0dP7a21oxLknakyMyNH4h4D/C7wOsy82/mOqsZ2L9/fx4+fLj0NFTKelM12dgsLcHKyvYvFL9vX9OcTdu7F66+ens5+9i1q2kQp0XATTcNX1+SNJiIuDQz958wvlmjNnY2agtuiKaqdKNUulGUJA1ms0atywlvpfE5erTfeBd79vQbn7VDh5qjgpOWlppxSdKOZKOmnWmIpqp0o7S83Hx1u3dvcxRv795T+ypXklQ9GzXtTEM0VTU0SsvLzdecN93U3NqkSdKOttWVCaTxWm9gDh5svu7cs6dp0k61sVletjmSJM2NjZp2LpsqSdLI+dWnJElSpWzUJEmSKmWjJkmSVCkbNUmSpEoN1qhFxEsj4ksR8YmJsTtExDsi4rPt7e0nHvv5iLgqIj4dEY+YGL9/RFzRPva8iIih5ixJklSTIY+ovRy4cGrs54B3Zea5wLvafSLiXsATgHu3z7k4Ik5rn/NCmovCn9tu0zklSZJ2pMEatcx8PzB9MfdHA69o778CeMzE+Gsy8+uZ+TngKuD8iLgrcEZmfjCbi5K+cuI5kiRJO9q8f6N258z8AkB7e6d2/Gzgmom4a9uxs9v70+MbiogDEXE4Ig5fd911M524JEnSvNWymGCj353lFuMbysyVzNyfmfvPOuusmU1OErC6Cvv2wa5dze3qaukZSdKON+8rE3wxIu6amV9ov9b8Ujt+LXC3ibhzgM+34+dsMC5pnlZX4cABWFtr9o8cafbBqz9I0oDmfUTtTcBF7f2LgDdOjD8hIk6PiLvTLBr4cPv16PURcUG72vPJE8+RNC8HDx5r0tatrTXjkqTBDHZELSJeDTwYODMirgV+GXgO8NqIeCpwFHgcQGZeGRGvBT4J3AA8MzNvbFM9nWYF6S2BS9pN0jwdPdpvXJI0E9Esptx59u/fn4cPHy49DWln2Lev+bpz2t69cPXV856NJO04EXFpZu6fHq9lMYGkmh06BEtLx48tLTXjkqTB2KhJOrnlZVhZaY6gRTS3KysuJJCkgc171aeksVpetjGTpDnziJokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2ajvZ6mpzRvldu5rb1dXSM5IkST14HrWdanUVDhw4diHtI0eaffBcWJIkjYRH1HaqgwePNWnr1taacUmSNAo2ajvV0aP9xiVJUnVs1HaqPXv6jUuSpOrYqO1Uhw7B0tLxY0tLzbgkSRoFG7WdankZVlZg716IaG5XVlxIIEnSiNio7WTLy3D11XDTTc3tTmjSPOWIJGmBeHoOjYenHJEkLRiPqGk8POWIJGnB2KhpPDzliCRpwdioaTw85YgkacHYqGk8POWIJGnB2KhpPDzliCRpwbjqU+OyvGxjJklaGB5RkyRJqpSNmiRJUqVs1CRJkiployZJklQpGzVJkqRK2ahJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmhqrq7BvH+za1dyurpaekSRJC89LSKlpyg4cgLW1Zv/IkWYfvFyTJEkFeURNcPDgsSZt3dpaMy5JkoqxURMcPdpvXJIkzYWNmmDPnn7jkiRpLmzUBIcOwdLS8WNLS824JEkqxkZNzYKBlRXYuxcimtuVFRcSSJJUmKs+1VhetjGTJKkyHlGTJEmqlI2aJElSpWzUJEmSKmWjJkmSVCkbNUmSpErZqEmSJFXKRk2SJKlSNmqSJEmVslGTJEmqlI2aJElSpWzUJEmSKmWjJkmSVCkbNUmSpErZqEmSJFXKRk2SJKlSNmqSJEmVslGTJEmqlI2aJElSpWzUJEmSKmWjJkmSVCkbNUmzt7oK+/bBrl3N7epq6RlJ0ijtLj0BSTvM6iocOABra83+kSPNPsDycrl5SdIIeURN0mwdPHisSVu3ttaMS5J6sVGTNFtHj/YblyRtykZN0mzt2dNvXJK0KRs1SbN16BAsLR0/trTUjEuSerFRkzRby8uwsgJ790JEc7uy4kICSdoGV31Kmr3lZRszSZoBj6hJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmiRJUqVs1CRJkiployZJklQpGzVJkqRK2ahJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmiRJUqVs1CRJkiployZJklQpGzVJkqRK2ahJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmiRJUqVs1CRJkiployZJklQpGzVJkqRK2ahJkiRVykZNkiSpUjZqkiRJlbJRk1TO6irs2we7djW3q6ulZyRJVdldegKSFtTqKhw4AGtrzf6RI80+wPJyuXlJUkU8oiapjIMHjzVp69bWmnFJEmCjJqmUo0f7jUvSArJRk1TGnj39xiVpARVp1CLi6oi4IiIui4jD7dgdIuIdEfHZ9vb2E/E/HxFXRcSnI+IRJeYsacYOHYKlpePHlpaacUkSUPaI2kMy87zM3N/u/xzwrsw8F3hXu09E3At4AnBv4ELg4og4rcSEJc3Q8jKsrMDevRDR3K6suJBAkibUtOrz0cCD2/uvAN4L/Gw7/prM/DrwuYi4Cjgf+GCBOUqapeVlGzNJ2kKpI2oJ/EFEXBoR7Xp87pyZXwBob+/Ujp8NXDPx3GvbsRNExIGIOBwRh6+77rqBpi5JkjQfpY6oPSgzPx8RdwLeERF/ukVsbDCWGwVm5gqwArB///4NYyRJksaiyBG1zPx8e/sl4P/SfJX5xYi4K0B7+6U2/FrgbhNPPwf4/PxmK0mSVMbcG7WIuFVE3Gb9PvDdwCeANwEXtWEXAW9s778JeEJEnB4RdwfOBT4831lLkiTNX4mvPu8M/N+IWK//u5n5toj4CPDaiHgqcBR4HEBmXhkRrwU+CdwAPDMzbywwb0mSpLma+xG1zPzzzLxPu907Mw+143+dmQ/LzHPb27+ZeM6hzLxHZv7zzLxk3nOWVAEv4C5pAdV0eg5J2pgXcJe0oLyElKT6eQF3SQvKRk1S/byAu6QFZaMmqX5ewF3SgrJRk1Q/L+AuaUHZqEmqnxdwl7SgXPUpaRy8gLukBeQRNUmSpErZqEmSJFXKRk2SJKlSNmqSJEmVslGTJEmqlI2aJElSpWzUJEmSKmWjJkmSVCkbNUmSpErZqEmSJFXKRk2SJKlSNmqSJEmVslGTJEmqlI2aJElSpWzUJEmSKmWjJkmSVCkbNUmSpErZqEmSJFXKRk3S4nrGM2D3bohobp/xjNIzkqTj2KhJ2nlWV2HfPti1q7ldXT0x5hnPgBe+EG68sdm/8cZm32ZNUkUiM0vPYRD79+/Pw4cPl56GpHlbXYUDB2Bt7djY0hKsrMDy8rGx3buPNWmTTjsNbrhh+HlK0oSIuDQz90+Pe0RN0s5y8ODxTRo0+wcPHj+2UZO21bgkFWCjJmlnOXq02/hpp20ct9l4l69TJWnGbNQk7Sx79nQbP3Bg47iNxte/Tj1yBDKb2wMHbNYkDc5GTdLOcuhQ85u0SUtLzfikiy+Gpz/92BG0005r9i+++MScXb9OlaQZczGBpJ1ndbVpoo4ebY6kHTp0/EKCvnbtao6kTYuAm27afl5Jam22mGB3iclI0qCWl0+tMZu2Z0/zdedG45I0IL/6lKST6fp1qiTNmI2aJJ3M8nJzHra9e5uvO/fuPfG8bJI0AL/6lKQuZv11qiR14BE1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSZIkVcpGTZIkqVI2apIkSZWyUZMkSaqUjZokzdLqKuzbB7t2Nberq6VnJGnEdpeegCTtGKurcOAArK01+0eONPsAy8vl5iVptDyiJkmzcvDgsSZt3dpaMy5J22CjJkmzcvRov3FJOgkbNUmalT17+o1L0knYqEnSrBw6BEtLx48tLTXjkrQNNmqSNCvLy7CyAnv3QkRzu7LiQgJJ2+aqT0mapeVlGzNJM+MRNUmSpErZqEmSJFXKRk2SJKlSNmqSJEmVslGTJEmqlI2aJElSpWzUJEmSKmWjJkmSVCkbNUkqZXUV9u2DXbua29XV0jOSVBmvTCBJJayuwoEDsLbW7B850uyDVzaQ9E88oiZJJRw8eKxJW7e21oxLUstGTZJKOHq037ikhWSjJkkl7NnTb1zSQrJRk6QSDh2CpaXjx5aWmnFJatmoSVIJy8uwsgJ790JEc7uy4kICScdx1acklbK8bGMmaUseUZMkSaqUjZokSVKlbNQkSZIqZaMmSZJUKRs1SZKkStmoSVLtvHi7tLA8PYck1cyLt0sLzSNqklQzL94uLTQbNUmqmRdvlxaajZok1cyLt0sLzUZNkmrmxdulhWajJkk18+Lt0kJz1ack1c6Lt0sLyyNqkrSTeM41aUfxiJok7RSec03acTyiJkk7hedck3YcGzVJ2in6nnPNr0ml6tmoSdJO0eeca+tfkx45ApnHvibdqFnr09B1jR1Lzr6xXe3EP6eSSr5HQ8vMHbnd//73T0laKK96VebSUmbTejXb0lIzPm3v3uPj1re9e7efs2vsWHJuJ3bv3syI5najmNKvqfRrHyK2zzyHyjkDwOHcoJ8p3lB13YALgU8DVwE/d7J4GzVJC6nrX4IRGzdqEcfHdW3o+sSOJWef2CGa5LH8OZVukvu8piFyzshmjVo0j9UtIk4DPgM8HLgW+Ajww5n5yc2es3///jx8+PCcZihJI7NvX/N157S9e+Hqq4/t79rV/BU1LQJuuun4sa6xY8nZJ7brn2efnGP5c+rz2oeI7fOahsg5IxFxaWbunx4fy2/Uzgeuysw/z8x/AF4DPLrwnCRpvLpemqrP7966xo4lZ5/YPgs5dtqfU5/XPkRsn9c0RM6BjaVROxu4ZmL/2nZMkrQdXS9N1edao11jx5KzT2yfv9h32p9T6Sa5z2saIufQNvo+tLYNeBzw4on9JwHP3yDuAHAYOLxnz56ZfW8sSQttiB+KjyVn19ghftA+1Gsq+dpLL2YYaoHEDDDmxQTAtwFvn9j/eeDnt3qOiwkkSXM157/Yq1KySR5yrnO0WaM2lsUEu2kWEzwM+AuaxQRPzMwrN3uOiwkkSdJYbLaYYBTX+szMGyLiWcDbgdOAl27VpEmSJO0Eo2jUADLzrcBbS89DkiRpXsay6lOSJGnh2KhJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmiRJUqVs1CRJkiployZJklQpGzVJkqRK2ahJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmiRJUqVs1CRJkiployZJklQpGzVJkqRK2ahJkiRVKjKz9BwGERHXAUcGLnMm8Fczjl3knKXrjyVn6fpjyVm6/lhylq4/lpyl6y9yztL1++Q8FXsz86wTRjPTbZsbcHjWsYucs3T9seQsXX8sOUvXH0vO0vXHkrN0/UXOWbp+n5xDbH71KUmSVCkbNUmSpErZqJ2alQFiFzln6fpjyVm6/lhylq4/lpyl648lZ+n6i5yzdP0+OWduxy4mkCRJGjuPqEmSJFXKRk2SJKlSu0tPQLMTET+w1eOZ+fq+sUPkLF2/Z85nnyT2N/rEDRUbEXc4SdzfTOTsFDuWnKXrjyVn6fpjyVm6/iLnLF2/T8558jdqHUTE9cDkH1S0+wFkZp7RN3agnDcBl7Xbety6zMx/M5GzU+wQOUvX32bOS4CvT8WSmb/aJ26o2DbuWuCGTV7TN0zlPGnsWHKWrj+WnKXrjyVn6fqLnLN0/T455yoLnsRtLBvwBuBDwP8D7JlF7EA5vx94DXAY+I/AN55q7BA5S9fvmfM84Dk0zdJLgO+i/QfOduKGigV+G/g4cDHw7Zvl6xM7lpyl648lZ+n6Y8lZuv4i5yxdv0/OeW7FJzCWDbgt8BTg7cD7gGcAdziV2CFytrG3Ap4IvBH4I+A7t3hdnWKHyFm6fp+cbfwDgecDnwK+71TjZh1L86+/h9AsJb8MeC5w901ydYodS87S9ceSs3T9seQsXX+Rc5au3yfnvLZihce60SzA+GGa6349exaxs84JnAZ8D/A7wMeAR2yRr1PsEDlL1++Z8yzgmcB7gXcAF5xK3MCxtwP+LXAd8OMn+Tx1ih1LztL1x5KzdP2x5Cxdf5Fzlq7fJ+fQm4sJOoqIB9I0SN9Oc/Tl+zPzD08ldtY5I+Ihbcz5wDuB387Mw5vk6xQ7RM7S9XvmfArwQ8AtgP8DPD4zv7TduKFiI+JWwKPb2LOA1wP3y8xrths7lpyl648lZ+n6Y8lZuv4i5yxdv0/OeXIxQQcRcTXwFZrfNb2bYz80BCAzP9o3dqCcNwGX0zRyyfELEMjMn5zI2Sl2iJyl628j5xXA0fWHp2K/r0/cULER8bfAZ4FXA1dtEPf6iZydYseSs3T9seQsXX8sOUvXX+Scpev3yTlPNmodRMR7OfaGJZywEuShfWMHynnRVq8jM18xkbNT7BA5S9fvmfM7TxL7vj5xQ8VGxMuZ+p/K8WHHrWTtFDuWnKXrjyVn6fpjyVm6/iLnLF2/T855slE7RRFxs8z8x1nGzjpnRNwC+NeZ+b875OsUO0TO0vU3i4uI+wL3AK7MzE9t8fxOcUPGSpJ2ll2lJzBG0XhoRLyY5pwrpxw765wRcVpEPDIiXgkcofnOfbN8nWKHyFm6/sniIuKXgN8DfhB4S0T8+CZ5OsUNFRsRD4iIj0fE1yLigxFxzy1ydoodS87S9ceSs3T9seQsXX+Rc5au3yfnXGXBlQxj24AH0Jxn5SjwNeAi4PanEjvrnMB3AC8CrgFeB/wlsLRJvk6xQ+QsXb9H3JXr48AdgY9sUrdT3FCxNOeEezhwOvA44O1b5OwUO5acpeuPJWfp+mPJWbr+IucsXb9PznluxScwhg04RPMDw3cBP0bzF+bnTiV2oJzXAh8AngTcph3bLGen2CFylq7fM+elW+33jRsqFvjoVvvbiR1LztL1x5KzdP2x5Cxdf5Fzlq7fJ+c8N0/P0c0B4NPAC4E3Z+bfR0SeYuwQOV8HPIbm67sbI+KNbP7DyK6xQ+QsXb9PzntExJva+zG1Tx5bodk1bqjY28Xx1zA9bj+PX63UNXYsOUvXH0vO0vXHkrN0/UXOWbp+n5xz42KCDiLiNOC7ac699VDgPTSX8rlbZt6wndghcrax62dV/mHgUcAZwFOBt2bm17YTO0TO0vV7xH0nW8h6Vn2+bOuw41ZAdYodS87S9ceSs3T9seQsXX+Rc5au3yfnPNmo9RTNysDvpfkL/l8B78rMJ55K7BA529ibARe2sd+dmWdu8bo6xQ6Rs3T9PjklSZonG7VTEBFn0Fwh4BWzih0iZxt7y8z8u5PF9YkdImfp+n1ySpI0NBs1SZKkSnkeNUmSpEq56lPqKSI+k5nfNDW2C/hRmhPTnkNzPdbPAi/KzPduJ+ep5o2I/5qZv7DJY7em+V3e3SZy/kFm3rQTcm6Vd5FznkreRc65VV5zLu5ndF786nObRvQhG6IBmHnOzfKWzhkR13Ps1B3r11hdAtZoVgGd0ca9jObKBu8EHgt8FfhD4GeBN2bm8/vm7JM3Ip43/dJpzhP3SpqkkxeafzzwM8DHaVa+foDm6Pq3AMuZecWYcvbJu8g5++Rd5Jx98ppzcT+jc5UVnMyt9g143tT2fOAr6/tTsY8HPgK8GPgz4HeAVeBy4FsGznk9zV/kX23vXw/cuD4+lfNlwK/QrBz9LeA/0ZyR+Z3ATwyZs0/eCnI+n+Y/0jtPjH1ug8/I5VP7H2pvTwc+tZ2cffLSnMT3VcCTaa5YcRFw3fr96Zwcu9rBmbRn3wa+FfjA2HL2ybvIOUu/T2PJWfp9WuScpd/7PjnnuRUpOrat9AeiR84hGoCZ5+yTt3TOdvz+wLuBn6T5V9ifbxBzKXCP9v79gPdPPPbJ7eTskxe4DU3T+bvA2e3YZjmv4NjR9FsCH5t47BNjy9kn7yLnLP0+jSVn6fdpkXOWfu/75Jzn5m/Uurkn8J9pvnr8mcz8i4j45dz4tBgBrJ/e4W+BOwFk5uXt6TQGy5mZPxER9wdeHRFvAF7A5mfc/8eIuEdm/llE3A/4hzbH12PiqgdD5OyZt2jOdvzSiPgu4FnA+4BbbJDzZ4D3RMTfAzcDngAQEWcBb95mzs55M/N64Kfa1/+qiHgLmy8Weivwtoh4H/BI4H+3Oe/Asa9iR5OzZ95Fztk57yLn7JnXnIv7GZ2f0p3imDaaoyDvAf4DcPUmMb8OvB34BZrfEv1CO34H4Mo55dxFc6TmD4HPb5LzoTQXd/8M8DngAe34WcBz55GzS95ack48967AozZ5LIAzt/G52jTndvK28c8EXrVFzKPaz9zDp/7cTh9zzi55FzlnLe/TWHLupPd+LDlree+75JzX5mKCniIigGcA35aZP7JJzKOAewEfz8x3tGO7gJtl5tfnkbN9/K7AfTPzrVu8ljtm5l9t9ZqHznmyvKVzRsRtaY58nk1zhO7zNF8/f6XjPB6+/p5NjN0FIDP/sj069u3ApzPzyg75tlyF1P4rMTPzy13mN5SIuF9mfnSLx0cxzzam+FzHMs92Hr73M+Q8Z28sn1HAI2p9N5qjWLevYB7322T8tjQXG3828NPt/dv1zP3wqf27AHdp758F/ABw7465/usWj53SXKfneSpz3WyeNL8h/DPghcAvttuL2rEnd5zn0an9p9EcybsaeDrwJ8BLgU8DT52KfR4dFp0Ae4DX0PzO8bPAVcCX2rF9Pf5Mr5i4/83AJcBbgHsAL29rfxi45/TncWq7P83vMO87+VkdYp595tp1nrOa61jmOdb3foh5Ltp7P5Z5jukzOuvN36h1EBF7gOcCD6P5IEQ0vw17N/BzmXl1xzxXZOa3tPe/GfhN4Caar+n+I/AYmq/jLsrMT008737TqYA3RsS/pvmB5EfbuCcDvwz8AfAXbexDgP8aEb+ama/s+JJfQvOBJSKeBvxc+5p/nea0FlcCvxYRz83Ml0zM83kbzPNJ0ZxahDx+ufQs5vpP8+wz1z7zBA4C98+po2cRcXuaBuuV7f6bNpljAHecGnsWcG+aH7UeAb4xmyNrt6f5GvwlE7E/ALyX5s9p/bcUT6BZZDDp92h+BLucmTe2czoNeBzN/2QumJj7D2wx17tM7K8A/w24Nc1n/WeBp9Bca/YFNP89rDsMfAiYPLp7R+A3aI5CPnTAefaZa9d5dp7rWObZc65jee+HmGfnuY7lvR/LPHvOtehndJ786rODiPggzZv3fzZ4834qM7t+yF6UmWe1ce/n2IfsOTQfst+j+ZD9VGb+04csIm7ixA/ZBe1YZuZD27hP0/ze6itT87898Cc5cT6xkzQWD83MW7VxVwAPYJOmIjPPm8h5LSc2Ff+d5ncB5MRCia5z7TrPPnPtOc/PAP8yM/+/qXneFjicmee2+18GfgT42gbz/L3MvPPEcz+amfdr7388M+8z8djHMvO+E/u3oVl0cieOLTr588z8hqn5fHZ9Lif8QU09FhH/SHN6l43+439sZt5mei4RcVVmfuNGr6HdfyzwE8CvZ/tVc0R8LjPvPvQ8+8y16zz7zHUs8+wz17G890PMs89cx/Lej2WefeZa+jM6V1noUN6YNuCzXR8D/pHmEOzLNtiun4j72MT9q6ZyfHRq/7E0KwMfNTH2uQ3m8hngthuM33aDeX4Z+B7gO6e2BwNf3GguNL+PY6PX0O73WS7daa5d59lnrj3neRHHvvr8hXZb/+rzRyfiLgEeskmO90/tH6b5bSHAORPjt5ie98RjWy46ofnX3sU0jeo/a7cHtGOvnYq9FPgXm9S5ZuL+5RP3nzEV94kNnntrmqPE/5vmSOdGS/pnPs++c+0yzz5zHcs8d+J7P8Q8d+J7P5Z5ln7v+8xznluRomPbRvQh69RUtLGdGgsGaCr6zLXrPLcz1y7zbONuT/N1479vY5/AKfxOsX3/dm8wfjbwXVs8b9NVSMDNaX7v9jaacwZ9ov2zewZTq5poFi7s2aTG/on7TwNuvUHMNwK/tcU879v+uX5pHvPc7ly3mmefuY5lnjvxvR9injvxvR/LPEu/933mOc/Nrz47iIibA08FHk3zl2kA1wC/D7wkJ1ZdRsS3A0cy8+gGefZn5uH2/tOA1cz82lTMNwLPysyf2mQu96X5Xv3emXmnDR6/PfCIiXleS7NC8ct9X3ebbw/NKS5umBo/m+YHm+/c5HldVrIWn2uXeaq/9s/1Npn51dJz2YrznL2xzNV5ztZY5gnjmivgEbUxbjRNzRml57FoG7Cy1X7fuKFige/dan87sWPJWbr+WHKWrj+WnKXrL3LO0vX75Bx624V6iYjv3Wp/O7F9c2bjqyfJubLV/nZih8hZun6fnMD/PMl+37ihYv/lSfa3EzuWnKXrjyVn6fpjyVm6/iLnLF2/T85hleoQx7oBv7rV/nZiB8p5/632txM7RM7S9fvkdHNzc3Nzm/dWfAJubjVvwGk0P1r9z8CDph77xb5xQ8Zu8RpOODHwqcaeSk7gDNoLzU+Nf+sGYzOP7Zmz0wmUu8YNlXOD5256ountxs46J3D39jV986xiZ5WTZsHPLdr7QXN+rufT/NB8d9+4AXN+33rsSV5rp7ihcrbx3wH88/b+v6JZmPU9pxI7UM5b05xp4adpTulxIbCr6+scYnMxQUfRnAz1QuBuwA00Zy3+g8y8abuxs84ZEbtpFj18P83K1KS53NEbaRY9/GPf2CFynkxErGTmgVnFnUrOiHgxsERztusnAe/LzGe3j02eU6hT3JCxW7ymo5m552RxfWK3mzMiHk9zapQv0Vxk/kcz8yPtY9OvfeaxPXP+0wmUaa63+6M0J1B+EM01YV/SJ27AnBuewJn2ZMx5/ImmO8UOlPMNmfmY9v6jad6H9wIPBH4tM18+kbNT7BA528c/AZyfmWvRnDz7HsAbaE+Mmpn/pk/cgDn/DvhbmpWJr6ZZjHXj1PvROW7AnL8FnA/sprlu9cPa530nzamTfqZv7EA5Hw/8DPBx4CHAB2iuB/otwI9k5uUbvb7BlewSx7IBjwc+AryY5vQRv0NzQr7LOfFf651iB8r5aprTXVwAnNNuF7RjvzeVs1PsEDnb2Dtsst0RuLZv3IA5J0+jspvmbNivB07n+HOzdYobKhZ40ybb7wN/O5WzU+xAOS8D7trePx/4U+AH2v3p1z7z2J45r6Bpku9IcyLj9aNbtwcu6xs3YM5rgVfRXO7sona7bv3+dmIHyjn5PnwAuHt7/0y2Pu/hprFD5GzHPjlx/1ImjqhM1e8UN2DOj7WfiR8H3gV8keY0R9+5nbgBc15J08Av0Zwbc6kdvxknnputU+xAOS+feOxMmuYT4FuBD0y/rnltRYqObevz5nWNHSjnp7d4DZ+Z2u8UO0TOdv9G4M9prnm5vq3v/0PfuAFz/ukGr+WXgD/m+BPzdoobKpZ+JwbuFDtQzunrCt6V5i+jn+TEEz3PPLZnzq4nUO5zUughcvY5gXOn2IFyTr6mD/f4c9o0doic7f7baa58AvA6YG97/44c31R1ihsw5/Rn9i7tZ/mDHH/ezk5xA+b8RHt7C5r/V9yy3T+Nica0T+xAOa+Af/qm8ZZTn7UTzm86r61I0bFtfd68rrED5fwQzWWtJv8FtovmYud/MpWzU+wQOdvxz7L5SQ2v6Rs3YM5XARduEPdjwD/2jRsqln4nBu56suMhcn6Aqd+H0fxF/y7g61PjM4/tmbPTCZS7xg2Vc+KxTidw7hM7y5w0/0D6KnA98A8cO0p4cyaOHPeJHSJnO3a39rW8n+ao8Jdprif5MeBhfeMGzPmxLd6PvX3jBsz568Af0nwz9N/a13WQ5jJ+L9pO7IA5305zAvY/BH6hHb8DcOVWn/8htyJFx7b1efO6xg6Ucx/N9UKvo7lE02dofovze7SH+fvGDpGzjX0mcJ9N/rx/om/cUDndZv7f0n1orsE6PX4zmgshDxrbM2enK0h0jRsq59Tjm169YruxQ+Sces7taE44PbPYWeUE7klzovMfpLkazYY/Ku8aN+ucwIM7vsZOcUPlbOO/DbigvX8Pmob+8Zu8rk6xA+V8VPvYwyfGduGVCeoXEY8C7kXzr9l3tGO7aP7V+/XtxA6RcyL+jjRH4f6qw2vrFDtEzjGLiIevvxeziBsyVpI0TjZqC2KIBqB0A1JBzkFXSM4yVpI0TjZqC6KmUzTUXH86LiLetFkozQ9+b9UnbshYSdLOs7v0BDQ7J/lL/Y7biR0iZ+n6fXIC3w78CM0pEqZjz99G3JCxkqSdptSP49xmvzGSUzSUrt8zZ7EVkj3rnwH8Gs059p44FXfx1H6n2LHkLF1/LDlL1x9LztL1Fzln6fp9cs5z24VOKiLOiIhfi4jfiYgnTj128XZih8hJc3qMtcx839T2XuDTUy+ra+wQOUvX75wzMx+Zme9hA5n5HX3jBox9Gc1RttcBT4iI10XE6e1jF0w9tWvsWHKWrj+WnKXrjyVn6fqLnLN0/T4556dUhzimrX3TngM8huZs66+jXarLiSf96xQ7RE63xd048Wz1B2lOinvHDT5PnWLHkrN0/bHkLF1/LDlL11/knKXr98k5z61I0bFtpT8QtX543OrZgE9x4vmALqK5dMqR7cSOJWfp+mPJWbr+WHKWrr/IOUvX75NznluRomPbSn8gav3wuNWzAc9lgxOhAhdy4mWpOsWOJWfp+mPJWbr+WHKWrr/IOUvX75Nznpun5+ggIp4L/EFmvnNq/ELg+Zl5bt/YIXJKkqQdplSH6OY2ho2RrIBq978ZeBhw66nxja4V2il2LDlL1x9LztL1x5KzdP1Fzlm6fp+c89qKFB3jVvoD0SWWkSyBLl2/Z86ii0N61P9JmhWrbwCuBh498dh0zk6xY8lZuv5YcpauP5acpesvcs7S9fvknOdWpOjYttIfiB45R7M6tWT9njkvm9qvdQXUFbRNPLAPOAz8u3b/Y1M5OsWOJWfp+mPJWbr+WHKWrr/IOUvX75NznptXJujmx4H7Z+bXImIf8H8iYl9m/jbNOVe2EztEzntk5g+2998QEQeBd0fE923wmrrGDpGzdP0+OU+PiF2ZeRNAZh6KiGuB9wO33kbcULGnZebX2pirI+LBNJ+TvZz4eeoaO5acpeuPJWfp+mPJWbr+IucsXb9Pzvkp1SGOaQM+ObV/a+BtwG9w4hGPTrED5RzN6tSS9XvmHMsKqHcD503F7AZeCdw4Nd4pdiw5S9cfS87S9ceSs3T9Rc5Zun6fnPPcihQd21b6A9Ej5yiWQJeu3yfnWDbgHOAumzz2oO3EjiVn6fpjyVm6/lhylq6/yDlL1++Tc56bp+foICLOAW7IzL/c4LEHZeYf940dIqeGERHfDJwN/Em2h8Xb8Qsz82194waOvXMbm8DnM/OLW7yuTrFjyVm6/lhylq4/lpyl6y9yztL1++ScBxu1Hkp/ILrEDtEAlG5ASuaMiJ8Enknzdel5ND8sfWP72Ecz83594oaKjYjzgBcBtwX+on36OcBXgKdn5scmcnaKHUvO0vXHkrN0/bHkLF1/kXOWrt8n51z1PQS3iBvNX5AfovnL8p3t9qft2H23EztQzlGsTi1dv2fOsayAugx4wAaf3QuAj0+NdYodS87S9ceSs3T9seQsXX+Rc5au3yfnPLciRce2lf5A9Mg5iiXQpev3zFlscUjP+pv+tg64amq/U+xYcpauP5acpeuPJWfp+oucs3T9PjnnuXl6jm5ulZl/Mj2YmR+KiFttM3aInKWXK4+lfp+cfxkR52XmZW381yLie4GXAt+yjbihYi+JiLfQLDC5ph27G/BkmsaObcSOJWfp+mPJWbr+WHKWrr/IOUvX75NzbvyNWgcR8TzgHmz85n0uM5/VN3agnO8Gnr3+l3o7tpvmL/XlzDxtYrxT7BA5S9fvmbPo4pCesY8EHk3z27sArgXelJlv3eC5nWLHkrN0/bHkLF1/LDlL11/knKXr98k5LzZqHZX+QHSJHaIBKN2AlM45MT6KFVCSpB1mo+9D3ca9AXcG7gfcF7jzLGKHyFm6fpc4Ci4O6Vn/NOBpwH8GHjiV4xen9jvFjiVn6fpjyVm6/lhylq6/yDlL1++Tc55bkaJj20p/IHrkPI8RrE4tXb9nzssYxwqoFwO/C/wUcCnwGxOPTa9k7RQ7lpyl648lZ+n6Y8lZuv4i5yxdv0/OeW5Fio5tK/2B6JHzMkawOrV0/Z45x7IC6vKJ+7uBFeD1wOmcuJK1U+xYcpauP5acpeuPJWfp+oucs3T9Pjnnue1CXZyfmU/MzN8CHgDcOiJeHxGnc+Iqwa6xQ+TcdHUo0Hkl6VTsEDlL1++T85KIeEtE/FBEPLDdfqhdGXTCaqEOcUPF3nziddyQmQdoGtJ3c+KF3rvGjiVn6fpjyVm6/lhylq6/yDlL1++Tc35KdYhj2oA/3WDsl4A/5sTrTXaKHSjn84C3AD8EPLDdfqgde8HU8zvFDpGzdP0+Odv4R9Kcrfr3gTe39x+13bghYoFXARdu8NwfA/5xO7FjyVm6/lhylq4/lpyl6y9yztL1++Sc5+aqzw4i4lXAq/LEyxX9GPDCzLxZ39ghcrZj1a9OraF+jUuwT0VE3DUzvzDL2LHkLF1/LDlL1x9LztL1Fzln6fp9cs6TjVoHpT8QtX54FkFEnEbzr6lzgEsy8wMTj/1iZv6XPnFDxUbEJcDtgffSfCX6R5l5wyavqVPsWHKWrj+WnKXrjyVn6fqLnLN0/T4558lGrYPSH4geOYdoAEo3IKVzvhhYAj4MPAl4X2Y+u31s8qLoneIGjr0F8GCar0ofBByl+by8LTOPMqFr7Fhylq4/lpyl648lZ+n6i5yzdP0+OefFRq2j0h+ILrFDNAClG5AKcl6emd/a3t8NXAycCfww8KHMvG+fuCFjp0XE3Wk+LxcCd8nM8081diw5S9cfS87S9ceSs3T9Rc5Zun6fnIPJQj+OG/sG3B14BvAm4MOziD3VnIxkCXTp+j1zFlsc0jd2g7gzJ+7ffBaxY8lZuv5YcpauP5acpesvcs7S9fvkHGqbe8GdspX+QGwUy0hWp5au3zPnWFZAPRL4HPBHNFdauBL4M5pFEg+bem6n2LHkLF1/LDlL1x9LztL1Fzln6fp9cs5zK1J0bFvpD0SPnEM0AKUbkNI579rxM9IpbqhYmnP93BP4NuCvgQva8Xty4gmUO8WOJWfp+mPJWbr+WHKWrr/IOUvX75NznluRomPbSn8geuQcogEo3YCUznkJzaWlnkPzG8HdpxI3VOzU5+Ca6c/PdmLHkrN0/bHkLF1/LDlL11/knKXr98k5z2036uKmzPwUQESsZXMGezLzUxExfXWHrrFD5HxpRHRdWtw1doicpet3zpmZj5xYyPH9wH+PiBMWcnSNGzD2KxHxNOAM4MsR8dPAa4HvAr429bK6xo4lZ+n6Y8lZuv5Ycpauv8g5S9fvk3NuvIRUN1+JiKdFxM/QvnkRcXZEXMQmH4gOsTPPmZmPpPkL/b00f6l/KJpLTR2IiD2TCbvGDpGzdP0+Odv4v8/Mt2Xmv8vM/cC/p1mE8IKI+HDfuIFiLwLuB3wD8N3t2NuBxwM/PvWSusaOJWfp+mPJWbr+WHKWrr/IOUvX75Nzbjw9RwcRcTfgF4GbgF+lOTXCU4EjwH9YP9rVJ3aInJvMfRRLoEvX75nzzMz8q/b+zTPzH04lbshYSdLIlfrO1W0+GxWuTq2x/mZxjGQF1En+DH6px+elU+xYcpauP5acpeuPJWfp+oucs3T9PjlnvRUpupO20h+IydghGoDSDUgFOS9jBCugTvIZOdrj89Qpdiw5S9cfS87S9ceSs3T9Rc5Zun6fnLPe/OrzFEXE0cw84XdNpxK73ZwRcRnN16K3A94MfE9mfigi7gms5vFn3O8UO0TO0vV75py8osE1mXm3yXqZeV6fuKFiI+KrbCyAW2bm7onndYodS87S9ceSs3T9seQsXX+Rc5au3yfnPBUpOjYne/O2EztETsazOrV0/T45R7MCCviXmfnFqecTEddM5+wYO5acpeuPJWfp+mPJWbr+IucsXb9Pzrlx1Wc3XwHOzcwzprbbAF/YZuwgOWMEq1MrqN8n50WMYwXUK4G9bOx3p/a7xo4lZ+n6Y8lZuv5Ycpauv8g5S9fvk3N+stB3rmPagP8CnL/JY7++ndiBct4N+J/AC4G7AD8NfAJ4C3DPqed1ih0iZ+n6fXKOZWOLk+ZuN3YsOUvXH0vO0vXHkrN0/UXOWbp+n5zz3PyNWgcRsTs3P8nqtmKHyKn5iohfysz/NKu4U4mNiMM0iyHWT4R79RbP6xQ7lpyl648lZ+n6Y8lZuv4i5yxdv0/OebJR66D0B2IWH54hmoV5NCCV5xx0cUjf2IjYy7FzwZ1Ns6r1EuB9mfn1qed2ih1LztL1x5KzdP2x5Cxdf5Fzlq7fJ+e82Kh1VPoDcaofniGahXk1ICVzxkhWQG3wOm4GfDvN5+XBwHWZ+T2nEjuWnKXrjyVn6fpjyVm6/iLnLF2/T84h2ahtQ+kPxGaxQzQApRuQCnIeZYtVQNmeLqNr3JCxW4mIszPzL2YZO5acpeuPJWfp+mPJWbr+IucsXb9PzpnKCn4oN/YNOHvWsdvJCRwF7rxJzDVT+51ih8hZun7PnMUWh/SN3eLzcUmPz1Kn2LHkLF1/LDlL1x9LztL1Fzln6fp9cs568zxqpygiLsnmIt8ziz2FnOtLi084+sLmy5VPFjtEztL1++T8ldxkIUdm/uw24gaJjYj7bRRDc5TwvOMGOsaOJWfp+mPJWbr+WHKWrr/IOUvX75Nznvzqs4OTvHlvzsy79o0dKOdoVqeWrN8z51hWQN0IvI/mMzHtgsy8Zd/YseQsXX8sOUvXH0vO0vUXOWfp+n1yzlWpQ3lj2oAbgXcD79lg+7vtxA6U8zDwBuDfAvtO8po6xQ6Rs3T9Pjnb+L1t7BuAjwC/SXPy2dO3EzdELM154M7dZP7TX+d2ih1LztL1x5KzdP2x5Cxdf5Fzlq7fJ+c8tyJFx7aV/kD0jJ15szBEztL1++Scet7NgIcCzwU+DLzlVOJmFQs8FvjnmzznMVP7nWLHkrN0/bHkLF1/LDlL11/knKXr98k5z82vPjuIiMcCV2Tmpzd47DGZ+Ya+sUPk3OCxKlen1la/T84NnjuKFVCSpJEq1SG6zX+jktWptdfvETeWFVBP6ZGzU+xYcpauP5acpeuPJWfp+oucs3T9PjlnvXlE7RRFxFMy82WzjB0oZ02rU6utPx1XcnFI39jNxEhPNrwT6o8lZ+n6Y8lZuv4i5yxdv0/OWfP0HKfuV4FOTVWP2G3lLL1ceSz1ey7B/gibrwK63TbiBomNiMs3eJz2eXc+bqBj7Fhylq4/lpyl648lZ+n6i5yzdP0+OefJRq2D0h+IHrFDNAtFG5AKcn4KeFpmfnY6MCKu2UbcULF3Bh4BfHk6DPjA1FjX2LHkLF1/LDlL1x9LztL1Fzln6fp9cs6NjVo3pT8QXWOHaABKNyClc/4KsGs6rvUT24gbKvbNwK0z87LpoIh479RQ19ix5Cxdfyw5S9cfS87S9Rc5Z+n6fXLOT6kfx41pA14C/KtNHvvd7cQOlHMUS6BL1++T083Nzc3NreTmYgJpm6Lg4pC+sZKkcdrsKxXtMBHxlFnHDpGzdP0+OWkWcswybshYSdIIeURtQZRerjyW+tNxJ1nI8U2ZeXqfuCFjJUk7j4sJdpARrU4d0xLssayAkiTtQDZqO8tYVqeWrt8n51hWQEmSdiAbtZ2l9HLlsdTvnDMznzodM/HYE/vGDRkrSdp5/I2aJElSpVz1KUmSVCkbNUmSpErZqEmSJFXKRk3SwouIGyPisoi4MiI+HhHPjogt//8YEfsiwgUdkgZloyZJ8HeZeV5m3ht4OPAo4JdP8px9gI2apEG56lPSwouIr2XmrSf2vwH4CHAmsBf4HeBW7cPPyswPRMSHgHsCnwNeATwPeA7wYOB04P/NzP85txchaUeyUZO08KYbtXbsy8A3A9cDN2Xm30fEucCrM3N/RDwY+A+Z+b1t/AHgTpn5XyLidOCPgcdl5ufm+Vok7Sye8FaSNhbt7c2AF0TEecCNwDdtEv/dwLdGxGPb/dsC59IccZOkbbFRk6Qp7VefNwJfovmt2heB+9D8rvfvN3sa8BOZ+fa5TFLSQnAxgSRNiIizgBcBL8jmtyG3Bb6QmTcBTwJOa0OvB24z8dS3A0+PiJu1eb4pIm6FJJ0Cj6hJEtwyIi6j+ZrzBprFA7/RPnYx8LqIeBzwHuBv2/HLgRsi4uPAy4HfplkJ+tGICOA64DHzmb6kncrFBJIkSZXyq09JkqRK2ahJkiRVykZNkiSpUjZqkiRJlbJRkyRJqpSNmiRJUqVs1CRJkiployZJklSp/x+RI2bsvWzHNgAAAABJRU5ErkJggg==\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)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fc3feabb",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}