MOTION_DATASET.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "9171ee21",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "2d898a00",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"MOTION_DATASET.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "da294a45",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 706 entries, 0 to 705\n",
      "Data columns (total 13 columns):\n",
      " #   Column           Non-Null Count  Dtype  \n",
      "---  ------           --------------  -----  \n",
      " 0   DataMessageGUID  706 non-null    object \n",
      " 1   SensorID         706 non-null    int64  \n",
      " 2   Sensor Name      706 non-null    object \n",
      " 3   Date             706 non-null    object \n",
      " 4   Value            706 non-null    int64  \n",
      " 5   Formatted Value  706 non-null    object \n",
      " 6   Battery          706 non-null    int64  \n",
      " 7   Raw Data         706 non-null    bool   \n",
      " 8   Sensor State     706 non-null    int64  \n",
      " 9   GatewayID        706 non-null    int64  \n",
      " 10  Alert Sent       706 non-null    bool   \n",
      " 11  Signal Strength  706 non-null    int64  \n",
      " 12  Voltage          706 non-null    float64\n",
      "dtypes: bool(2), float64(1), int64(6), object(4)\n",
      "memory usage: 62.2+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "3a618210",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                          DataMessageGUID  SensorID Sensor Name  \\\n",
      "27   b21c780c-d5a8-4b00-92c1-4c1c9c4c7d5a    898918    Motion 1   \n",
      "28   6de1a8a7-e10d-465f-83c1-bc582d4eac62    898918    Motion 1   \n",
      "29   83c1f601-2999-4860-9989-64e7c8629d6f    898918    Motion 1   \n",
      "30   399cf07f-9d97-492f-ab6d-8e56216b4fc4    898918    Motion 1   \n",
      "31   3827e0c7-0672-4a3f-8a80-ae7953197479    898918    Motion 1   \n",
      "..                                    ...       ...         ...   \n",
      "701  5a91be76-de2f-4934-8095-5172fe61be30    898918    Motion 1   \n",
      "702  bee6fe84-e9b0-4f2b-b1b2-929468ba4a2a    898918    Motion 1   \n",
      "703  0c586f5f-a4d0-4f22-a198-999d66e40383    898918    Motion 1   \n",
      "704  6a79affc-ddee-431b-a5aa-7512bd3f99f2    898918    Motion 1   \n",
      "705  82a7e260-7655-4666-9eee-94b266aa6b11    898918    Motion 1   \n",
      "\n",
      "                    Date  Value  Formatted Value  Battery  Raw Data  \\\n",
      "27    11/18/2022 9:07 PM      1  Motion Detected      100      True   \n",
      "28    11/18/2022 8:57 PM      1  Motion Detected      100      True   \n",
      "29    11/18/2022 8:31 PM      0        No Motion      100     False   \n",
      "30    11/18/2022 8:21 PM      1  Motion Detected      100      True   \n",
      "31    11/18/2022 7:31 PM      0        No Motion      100     False   \n",
      "..                   ...    ...              ...      ...       ...   \n",
      "701   11/14/2022 4:39 AM      0        No Motion      100     False   \n",
      "702   11/14/2022 3:39 AM      0        No Motion      100     False   \n",
      "703   11/14/2022 2:39 AM      0        No Motion      100     False   \n",
      "704   11/14/2022 1:39 AM      0        No Motion      100     False   \n",
      "705  11/14/2022 12:39 AM      0        No Motion      100     False   \n",
      "\n",
      "     Sensor State  GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "27              2     964010       False              100     2.52  \n",
      "28              2     964010       False              100     2.52  \n",
      "29              0     964010       False              100     2.52  \n",
      "30              2     964010       False              100     2.53  \n",
      "31              0     964010       False              100     2.52  \n",
      "..            ...        ...         ...              ...      ...  \n",
      "701             0     964010       False               96     2.51  \n",
      "702             0     964010       False               95     2.51  \n",
      "703             0     964010       False               95     2.51  \n",
      "704             0     964010       False               95     2.51  \n",
      "705             0     964010       False               96     2.51  \n",
      "\n",
      "[679 rows x 13 columns]\n"
     ]
    }
   ],
   "source": [
    "n = 27\n",
    "df.drop(index=df.index[:n],inplace=True)\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "d34922a8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                          DataMessageGUID  SensorID Sensor Name  \\\n",
      "27   b21c780c-d5a8-4b00-92c1-4c1c9c4c7d5a    898918    Motion 1   \n",
      "28   6de1a8a7-e10d-465f-83c1-bc582d4eac62    898918    Motion 1   \n",
      "29   83c1f601-2999-4860-9989-64e7c8629d6f    898918    Motion 1   \n",
      "30   399cf07f-9d97-492f-ab6d-8e56216b4fc4    898918    Motion 1   \n",
      "31   3827e0c7-0672-4a3f-8a80-ae7953197479    898918    Motion 1   \n",
      "..                                    ...       ...         ...   \n",
      "130  3d800bbc-521a-4d6a-af13-6bd840578c8c    898918    Motion 1   \n",
      "131  a8274af7-a317-45be-817c-cb84ddbd1906    898918    Motion 1   \n",
      "132  9767eb45-84f5-47c7-8108-903fa70b7802    898918    Motion 1   \n",
      "133  82755130-a075-429d-b30b-19c0c6a0a88f    898918    Motion 1   \n",
      "134  5625989a-2557-491c-b08d-3d62483941f6    898918    Motion 1   \n",
      "\n",
      "                   Date  Value  Formatted Value  Battery  Raw Data  \\\n",
      "27   11/18/2022 9:07 PM      1  Motion Detected      100      True   \n",
      "28   11/18/2022 8:57 PM      1  Motion Detected      100      True   \n",
      "29   11/18/2022 8:31 PM      0        No Motion      100     False   \n",
      "30   11/18/2022 8:21 PM      1  Motion Detected      100      True   \n",
      "31   11/18/2022 7:31 PM      0        No Motion      100     False   \n",
      "..                  ...    ...              ...      ...       ...   \n",
      "130  11/18/2022 9:22 AM      0        No Motion      100     False   \n",
      "131  11/18/2022 9:12 AM      1  Motion Detected      100      True   \n",
      "132  11/18/2022 9:12 AM      0        No Motion      100     False   \n",
      "133  11/18/2022 9:02 AM      1  Motion Detected      100      True   \n",
      "134  11/18/2022 8:52 AM      1  Motion Detected      100      True   \n",
      "\n",
      "     Sensor State  GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "27              2     964010       False              100     2.52  \n",
      "28              2     964010       False              100     2.52  \n",
      "29              0     964010       False              100     2.52  \n",
      "30              2     964010       False              100     2.53  \n",
      "31              0     964010       False              100     2.52  \n",
      "..            ...        ...         ...              ...      ...  \n",
      "130             0     964010       False              100     2.51  \n",
      "131             2     964010       False              100     2.52  \n",
      "132             0     964010       False              100     2.51  \n",
      "133             2     964010       False              100     2.51  \n",
      "134             2     964010       False              100     2.52  \n",
      "\n",
      "[108 rows x 13 columns]\n"
     ]
    }
   ],
   "source": [
    "n = 571\n",
    "df.drop(df.tail(n).index,\n",
    "        inplace = True)\n",
    "print(df)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "0f0715a9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                          DataMessageGUID  SensorID Sensor Name  \\\n",
      "27   b21c780c-d5a8-4b00-92c1-4c1c9c4c7d5a    898918    Motion 1   \n",
      "28   6de1a8a7-e10d-465f-83c1-bc582d4eac62    898918    Motion 1   \n",
      "29   83c1f601-2999-4860-9989-64e7c8629d6f    898918    Motion 1   \n",
      "30   399cf07f-9d97-492f-ab6d-8e56216b4fc4    898918    Motion 1   \n",
      "31   3827e0c7-0672-4a3f-8a80-ae7953197479    898918    Motion 1   \n",
      "..                                    ...       ...         ...   \n",
      "129  91bca245-22fd-43ac-a6b1-a283868b0cce    898918    Motion 1   \n",
      "130  3d800bbc-521a-4d6a-af13-6bd840578c8c    898918    Motion 1   \n",
      "131  a8274af7-a317-45be-817c-cb84ddbd1906    898918    Motion 1   \n",
      "132  9767eb45-84f5-47c7-8108-903fa70b7802    898918    Motion 1   \n",
      "133  82755130-a075-429d-b30b-19c0c6a0a88f    898918    Motion 1   \n",
      "\n",
      "                   Date  Value  Formatted Value  Battery  Raw Data  \\\n",
      "27   11/18/2022 9:07 PM      1  Motion Detected      100      True   \n",
      "28   11/18/2022 8:57 PM      1  Motion Detected      100      True   \n",
      "29   11/18/2022 8:31 PM      0        No Motion      100     False   \n",
      "30   11/18/2022 8:21 PM      1  Motion Detected      100      True   \n",
      "31   11/18/2022 7:31 PM      0        No Motion      100     False   \n",
      "..                  ...    ...              ...      ...       ...   \n",
      "129  11/18/2022 9:22 AM      1  Motion Detected      100      True   \n",
      "130  11/18/2022 9:22 AM      0        No Motion      100     False   \n",
      "131  11/18/2022 9:12 AM      1  Motion Detected      100      True   \n",
      "132  11/18/2022 9:12 AM      0        No Motion      100     False   \n",
      "133  11/18/2022 9:02 AM      1  Motion Detected      100      True   \n",
      "\n",
      "     Sensor State  GatewayID  Alert Sent  Signal Strength  Voltage  \n",
      "27              2     964010       False              100     2.52  \n",
      "28              2     964010       False              100     2.52  \n",
      "29              0     964010       False              100     2.52  \n",
      "30              2     964010       False              100     2.53  \n",
      "31              0     964010       False              100     2.52  \n",
      "..            ...        ...         ...              ...      ...  \n",
      "129             2     964010       False              100     2.51  \n",
      "130             0     964010       False              100     2.51  \n",
      "131             2     964010       False              100     2.52  \n",
      "132             0     964010       False              100     2.51  \n",
      "133             2     964010       False              100     2.51  \n",
      "\n",
      "[107 rows x 13 columns]\n"
     ]
    }
   ],
   "source": [
    "n = 1\n",
    "df.drop(df.tail(n).index,\n",
    "        inplace = True)\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "fbc92d07",
   "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>27</th>\n",
       "      <td>b21c780c-d5a8-4b00-92c1-4c1c9c4c7d5a</td>\n",
       "      <td>898918</td>\n",
       "      <td>Motion 1</td>\n",
       "      <td>11/18/2022 9:07 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>Motion Detected</td>\n",
       "      <td>100</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>6de1a8a7-e10d-465f-83c1-bc582d4eac62</td>\n",
       "      <td>898918</td>\n",
       "      <td>Motion 1</td>\n",
       "      <td>11/18/2022 8:57 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>Motion Detected</td>\n",
       "      <td>100</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>83c1f601-2999-4860-9989-64e7c8629d6f</td>\n",
       "      <td>898918</td>\n",
       "      <td>Motion 1</td>\n",
       "      <td>11/18/2022 8:31 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>No Motion</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>399cf07f-9d97-492f-ab6d-8e56216b4fc4</td>\n",
       "      <td>898918</td>\n",
       "      <td>Motion 1</td>\n",
       "      <td>11/18/2022 8:21 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>Motion Detected</td>\n",
       "      <td>100</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>2.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>3827e0c7-0672-4a3f-8a80-ae7953197479</td>\n",
       "      <td>898918</td>\n",
       "      <td>Motion 1</td>\n",
       "      <td>11/18/2022 7:31 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>No Motion</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>964010</td>\n",
       "      <td>False</td>\n",
       "      <td>100</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         DataMessageGUID  SensorID Sensor Name  \\\n",
       "27  b21c780c-d5a8-4b00-92c1-4c1c9c4c7d5a    898918    Motion 1   \n",
       "28  6de1a8a7-e10d-465f-83c1-bc582d4eac62    898918    Motion 1   \n",
       "29  83c1f601-2999-4860-9989-64e7c8629d6f    898918    Motion 1   \n",
       "30  399cf07f-9d97-492f-ab6d-8e56216b4fc4    898918    Motion 1   \n",
       "31  3827e0c7-0672-4a3f-8a80-ae7953197479    898918    Motion 1   \n",
       "\n",
       "                  Date  Value  Formatted Value  Battery  Raw Data  \\\n",
       "27  11/18/2022 9:07 PM      1  Motion Detected      100      True   \n",
       "28  11/18/2022 8:57 PM      1  Motion Detected      100      True   \n",
       "29  11/18/2022 8:31 PM      0        No Motion      100     False   \n",
       "30  11/18/2022 8:21 PM      1  Motion Detected      100      True   \n",
       "31  11/18/2022 7:31 PM      0        No Motion      100     False   \n",
       "\n",
       "    Sensor State  GatewayID  Alert Sent  Signal Strength  Voltage  \n",
       "27             2     964010       False              100     2.52  \n",
       "28             2     964010       False              100     2.52  \n",
       "29             0     964010       False              100     2.52  \n",
       "30             2     964010       False              100     2.53  \n",
       "31             0     964010       False              100     2.52  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "a6b9dfb2",
   "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": 13,
   "id": "e6c785c7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                   Date  Value  Formatted Value  Raw Data  Sensor State  \\\n",
      "27   11/18/2022 9:07 PM      1  Motion Detected      True             2   \n",
      "28   11/18/2022 8:57 PM      1  Motion Detected      True             2   \n",
      "29   11/18/2022 8:31 PM      0        No Motion     False             0   \n",
      "30   11/18/2022 8:21 PM      1  Motion Detected      True             2   \n",
      "31   11/18/2022 7:31 PM      0        No Motion     False             0   \n",
      "..                  ...    ...              ...       ...           ...   \n",
      "129  11/18/2022 9:22 AM      1  Motion Detected      True             2   \n",
      "130  11/18/2022 9:22 AM      0        No Motion     False             0   \n",
      "131  11/18/2022 9:12 AM      1  Motion Detected      True             2   \n",
      "132  11/18/2022 9:12 AM      0        No Motion     False             0   \n",
      "133  11/18/2022 9:02 AM      1  Motion Detected      True             2   \n",
      "\n",
      "     Alert Sent  Voltage  \n",
      "27        False     2.52  \n",
      "28        False     2.52  \n",
      "29        False     2.52  \n",
      "30        False     2.53  \n",
      "31        False     2.52  \n",
      "..          ...      ...  \n",
      "129       False     2.51  \n",
      "130       False     2.51  \n",
      "131       False     2.52  \n",
      "132       False     2.51  \n",
      "133       False     2.51  \n",
      "\n",
      "[107 rows x 7 columns]\n"
     ]
    }
   ],
   "source": [
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "8bb004a6",
   "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>27</th>\n",
       "      <td>11/18/2022 9:07 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>Motion Detected</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>11/18/2022 8:57 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>Motion Detected</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>11/18/2022 8:31 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>No Motion</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>11/18/2022 8:21 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>Motion Detected</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>2.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>11/18/2022 7:31 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>No Motion</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Date  Value  Formatted Value  Raw Data  Sensor State  \\\n",
       "27  11/18/2022 9:07 PM      1  Motion Detected      True             2   \n",
       "28  11/18/2022 8:57 PM      1  Motion Detected      True             2   \n",
       "29  11/18/2022 8:31 PM      0        No Motion     False             0   \n",
       "30  11/18/2022 8:21 PM      1  Motion Detected      True             2   \n",
       "31  11/18/2022 7:31 PM      0        No Motion     False             0   \n",
       "\n",
       "    Alert Sent  Voltage  \n",
       "27       False     2.52  \n",
       "28       False     2.52  \n",
       "29       False     2.52  \n",
       "30       False     2.53  \n",
       "31       False     2.52  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "c38f4971",
   "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>Sensor State</th>\n",
       "      <th>Voltage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>107.000000</td>\n",
       "      <td>107.000000</td>\n",
       "      <td>107.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.579439</td>\n",
       "      <td>1.158879</td>\n",
       "      <td>2.525234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.495972</td>\n",
       "      <td>0.991944</td>\n",
       "      <td>0.006196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.520000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.530000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.530000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.530000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Value  Sensor State     Voltage\n",
       "count  107.000000    107.000000  107.000000\n",
       "mean     0.579439      1.158879    2.525234\n",
       "std      0.495972      0.991944    0.006196\n",
       "min      0.000000      0.000000    2.500000\n",
       "25%      0.000000      0.000000    2.520000\n",
       "50%      1.000000      2.000000    2.530000\n",
       "75%      1.000000      2.000000    2.530000\n",
       "max      1.000000      2.000000    2.530000"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()\n",
    "#IMPORTANT "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "05e90cc0",
   "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>27</th>\n",
       "      <td>11/18/2022 9:07 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>Motion Detected</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>11/18/2022 8:57 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>Motion Detected</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>11/18/2022 8:31 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>No Motion</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>11/18/2022 8:21 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>Motion Detected</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>2.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>11/18/2022 7:31 PM</td>\n",
       "      <td>0</td>\n",
       "      <td>No Motion</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Date  Value  Formatted Value  Raw Data  Sensor State  \\\n",
       "27  11/18/2022 9:07 PM      1  Motion Detected      True             2   \n",
       "28  11/18/2022 8:57 PM      1  Motion Detected      True             2   \n",
       "29  11/18/2022 8:31 PM      0        No Motion     False             0   \n",
       "30  11/18/2022 8:21 PM      1  Motion Detected      True             2   \n",
       "31  11/18/2022 7:31 PM      0        No Motion     False             0   \n",
       "\n",
       "    Alert Sent  Voltage  \n",
       "27       False     2.52  \n",
       "28       False     2.52  \n",
       "29       False     2.52  \n",
       "30       False     2.53  \n",
       "31       False     2.52  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "46ead6f7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                   Date  Value  Formatted Value  Raw Data  Sensor State  \\\n",
      "27   11/18/2022 9:07 PM      1  Motion Detected      True             2   \n",
      "28   11/18/2022 8:57 PM      1  Motion Detected      True             2   \n",
      "30   11/18/2022 8:21 PM      1  Motion Detected      True             2   \n",
      "32   11/18/2022 7:21 PM      1  Motion Detected      True             2   \n",
      "34   11/18/2022 7:10 PM      1  Motion Detected      True             2   \n",
      "..                  ...    ...              ...       ...           ...   \n",
      "125  11/18/2022 9:43 AM      1  Motion Detected      True             2   \n",
      "127  11/18/2022 9:33 AM      1  Motion Detected      True             2   \n",
      "129  11/18/2022 9:22 AM      1  Motion Detected      True             2   \n",
      "131  11/18/2022 9:12 AM      1  Motion Detected      True             2   \n",
      "133  11/18/2022 9:02 AM      1  Motion Detected      True             2   \n",
      "\n",
      "     Alert Sent  Voltage  \n",
      "27        False     2.52  \n",
      "28        False     2.52  \n",
      "30        False     2.53  \n",
      "32        False     2.53  \n",
      "34        False     2.53  \n",
      "..          ...      ...  \n",
      "125       False     2.52  \n",
      "127       False     2.50  \n",
      "129       False     2.51  \n",
      "131       False     2.52  \n",
      "133       False     2.51  \n",
      "\n",
      "[62 rows x 7 columns]\n"
     ]
    }
   ],
   "source": [
    "print(df[df.Value == df.Value.max()])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "56eb909d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                    Date  Value Formatted Value  Raw Data  Sensor State  \\\n",
      "29    11/18/2022 8:31 PM      0       No Motion     False             0   \n",
      "31    11/18/2022 7:31 PM      0       No Motion     False             0   \n",
      "33    11/18/2022 7:20 PM      0       No Motion     False             0   \n",
      "35    11/18/2022 7:05 PM      0       No Motion     False             0   \n",
      "37    11/18/2022 6:52 PM      0       No Motion     False             0   \n",
      "39    11/18/2022 6:39 PM      0       No Motion     False             0   \n",
      "42    11/18/2022 6:19 PM      0       No Motion     False             0   \n",
      "44    11/18/2022 6:09 PM      0       No Motion     False             0   \n",
      "46    11/18/2022 5:58 PM      0       No Motion     False             0   \n",
      "48    11/18/2022 5:48 PM      0       No Motion     False             0   \n",
      "51    11/18/2022 5:28 PM      0       No Motion     False             0   \n",
      "53    11/18/2022 5:15 PM      0       No Motion     False             0   \n",
      "56    11/18/2022 4:55 PM      0       No Motion     False             0   \n",
      "58    11/18/2022 4:44 PM      0       No Motion     False             0   \n",
      "60    11/18/2022 4:34 PM      0       No Motion     False             0   \n",
      "62    11/18/2022 4:24 PM      0       No Motion     False             0   \n",
      "64    11/18/2022 4:13 PM      0       No Motion     False             0   \n",
      "66    11/18/2022 4:03 PM      0       No Motion     False             0   \n",
      "69    11/18/2022 3:42 PM      0       No Motion     False             0   \n",
      "71    11/18/2022 3:32 PM      0       No Motion     False             0   \n",
      "73    11/18/2022 3:22 PM      0       No Motion     False             0   \n",
      "75    11/18/2022 3:10 PM      0       No Motion     False             0   \n",
      "77    11/18/2022 3:00 PM      0       No Motion     False             0   \n",
      "79    11/18/2022 2:49 PM      0       No Motion     False             0   \n",
      "80    11/18/2022 2:49 PM      0       No Motion     False             0   \n",
      "83    11/18/2022 2:29 PM      0       No Motion     False             0   \n",
      "88    11/18/2022 1:48 PM      0       No Motion     False             0   \n",
      "90    11/18/2022 1:38 PM      0       No Motion     False             0   \n",
      "92    11/18/2022 1:27 PM      0       No Motion     False             0   \n",
      "94    11/18/2022 1:16 PM      0       No Motion     False             0   \n",
      "98   11/18/2022 12:46 PM      0       No Motion     False             0   \n",
      "101  11/18/2022 12:25 PM      0       No Motion     False             0   \n",
      "103  11/18/2022 12:14 PM      0       No Motion     False             0   \n",
      "108  11/18/2022 11:34 AM      0       No Motion     False             0   \n",
      "110  11/18/2022 11:22 AM      0       No Motion     False             0   \n",
      "112  11/18/2022 11:12 AM      0       No Motion     False             0   \n",
      "115  11/18/2022 10:52 AM      0       No Motion     False             0   \n",
      "117  11/18/2022 10:40 AM      0       No Motion     False             0   \n",
      "119  11/18/2022 10:26 AM      0       No Motion     False             0   \n",
      "121  11/18/2022 10:14 AM      0       No Motion     False             0   \n",
      "124   11/18/2022 9:53 AM      0       No Motion     False             0   \n",
      "126   11/18/2022 9:43 AM      0       No Motion     False             0   \n",
      "128   11/18/2022 9:32 AM      0       No Motion     False             0   \n",
      "130   11/18/2022 9:22 AM      0       No Motion     False             0   \n",
      "132   11/18/2022 9:12 AM      0       No Motion     False             0   \n",
      "\n",
      "     Alert Sent  Voltage  \n",
      "29        False     2.52  \n",
      "31        False     2.52  \n",
      "33        False     2.52  \n",
      "35        False     2.52  \n",
      "37        False     2.52  \n",
      "39        False     2.53  \n",
      "42        False     2.53  \n",
      "44        False     2.53  \n",
      "46        False     2.53  \n",
      "48        False     2.53  \n",
      "51        False     2.53  \n",
      "53        False     2.53  \n",
      "56        False     2.53  \n",
      "58        False     2.53  \n",
      "60        False     2.53  \n",
      "62        False     2.52  \n",
      "64        False     2.53  \n",
      "66        False     2.53  \n",
      "69        False     2.52  \n",
      "71        False     2.52  \n",
      "73        False     2.53  \n",
      "75        False     2.53  \n",
      "77        False     2.53  \n",
      "79        False     2.52  \n",
      "80        False     2.52  \n",
      "83        False     2.53  \n",
      "88        False     2.53  \n",
      "90        False     2.53  \n",
      "92        False     2.53  \n",
      "94        False     2.53  \n",
      "98        False     2.53  \n",
      "101       False     2.53  \n",
      "103       False     2.53  \n",
      "108       False     2.53  \n",
      "110       False     2.53  \n",
      "112       False     2.53  \n",
      "115       False     2.52  \n",
      "117       False     2.52  \n",
      "119       False     2.52  \n",
      "121       False     2.52  \n",
      "124       False     2.52  \n",
      "126       False     2.52  \n",
      "128       False     2.52  \n",
      "130       False     2.51  \n",
      "132       False     2.51  \n"
     ]
    }
   ],
   "source": [
    "print(df[df.Value == df.Value.min()])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "1692cc54",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                   Date  Value  Formatted Value  Raw Data  Sensor State  \\\n",
      "27   11/18/2022 9:07 PM      1  Motion Detected      True             2   \n",
      "28   11/18/2022 8:57 PM      1  Motion Detected      True             2   \n",
      "30   11/18/2022 8:21 PM      1  Motion Detected      True             2   \n",
      "32   11/18/2022 7:21 PM      1  Motion Detected      True             2   \n",
      "34   11/18/2022 7:10 PM      1  Motion Detected      True             2   \n",
      "..                  ...    ...              ...       ...           ...   \n",
      "125  11/18/2022 9:43 AM      1  Motion Detected      True             2   \n",
      "127  11/18/2022 9:33 AM      1  Motion Detected      True             2   \n",
      "129  11/18/2022 9:22 AM      1  Motion Detected      True             2   \n",
      "131  11/18/2022 9:12 AM      1  Motion Detected      True             2   \n",
      "133  11/18/2022 9:02 AM      1  Motion Detected      True             2   \n",
      "\n",
      "     Alert Sent  Voltage  \n",
      "27        False     2.52  \n",
      "28        False     2.52  \n",
      "30        False     2.53  \n",
      "32        False     2.53  \n",
      "34        False     2.53  \n",
      "..          ...      ...  \n",
      "125       False     2.52  \n",
      "127       False     2.50  \n",
      "129       False     2.51  \n",
      "131       False     2.52  \n",
      "133       False     2.51  \n",
      "\n",
      "[62 rows x 7 columns]\n"
     ]
    }
   ],
   "source": [
    "print(df[df.Value == df.Value.median()])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c53600d1",
   "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
}