unsupervised machine learning algorithms.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5a1a8003",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "7bfcfe58",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from sklearn.cluster import KMeans"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "80bae90a",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "2c6263c3",
   "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>sourceID</th>\n",
       "      <th>sourceAddress</th>\n",
       "      <th>sourceType</th>\n",
       "      <th>sourceLocation</th>\n",
       "      <th>destinationServiceAddress</th>\n",
       "      <th>destinationServiceType</th>\n",
       "      <th>destinationLocation</th>\n",
       "      <th>accessedNodeAddress</th>\n",
       "      <th>accessedNodeType</th>\n",
       "      <th>operation</th>\n",
       "      <th>value</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>normality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>lightcontrol2</td>\n",
       "      <td>/agent2/lightcontrol2</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>BedroomParents</td>\n",
       "      <td>/agent2/lightcontrol2</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>BedroomParents</td>\n",
       "      <td>/agent2/lightcontrol2</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>registerService</td>\n",
       "      <td>none</td>\n",
       "      <td>1520031600000</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>lightcontrol3</td>\n",
       "      <td>/agent3/lightcontrol3</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>Dinningroom</td>\n",
       "      <td>/agent3/lightcontrol3</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>Dinningroom</td>\n",
       "      <td>/agent3/lightcontrol3</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>registerService</td>\n",
       "      <td>none</td>\n",
       "      <td>1520031603269</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>lightcontrol1</td>\n",
       "      <td>/agent1/lightcontrol1</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>BedroomChildren</td>\n",
       "      <td>/agent1/lightcontrol1</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>BedroomChildren</td>\n",
       "      <td>/agent1/lightcontrol1</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>registerService</td>\n",
       "      <td>none</td>\n",
       "      <td>1520031603279</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>lightcontrol4</td>\n",
       "      <td>/agent4/lightcontrol4</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>Kitchen</td>\n",
       "      <td>/agent4/lightcontrol4</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>Kitchen</td>\n",
       "      <td>/agent4/lightcontrol4</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>registerService</td>\n",
       "      <td>none</td>\n",
       "      <td>1520031603290</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>movement4</td>\n",
       "      <td>/agent4/movement4</td>\n",
       "      <td>/movementSensor</td>\n",
       "      <td>Kitchen</td>\n",
       "      <td>/agent4/movement4</td>\n",
       "      <td>/movementSensor</td>\n",
       "      <td>Kitchen</td>\n",
       "      <td>/agent4/movement4</td>\n",
       "      <td>/movementSensor</td>\n",
       "      <td>registerService</td>\n",
       "      <td>none</td>\n",
       "      <td>1520031603464</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357947</th>\n",
       "      <td>lightcontrol23</td>\n",
       "      <td>/agent23/lightcontrol23</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>room_4</td>\n",
       "      <td>/agent23/tempin23</td>\n",
       "      <td>/sensorService</td>\n",
       "      <td>room_4</td>\n",
       "      <td>/agent23/tempin23</td>\n",
       "      <td>/sensorService</td>\n",
       "      <td>read</td>\n",
       "      <td>20.3479</td>\n",
       "      <td>1520117997001</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357948</th>\n",
       "      <td>washingmachine2</td>\n",
       "      <td>/agent11/washingmachine2</td>\n",
       "      <td>/washingService</td>\n",
       "      <td>Watterroom</td>\n",
       "      <td>/agent11/battery4</td>\n",
       "      <td>/batteryService</td>\n",
       "      <td>Watterroom</td>\n",
       "      <td>/agent11/battery4/charge</td>\n",
       "      <td>/basic/number</td>\n",
       "      <td>read</td>\n",
       "      <td>9</td>\n",
       "      <td>1520117997339</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357949</th>\n",
       "      <td>washingmachine2</td>\n",
       "      <td>/agent11/washingmachine2</td>\n",
       "      <td>/washingService</td>\n",
       "      <td>Watterroom</td>\n",
       "      <td>/agent11/battery4</td>\n",
       "      <td>/batteryService</td>\n",
       "      <td>Watterroom</td>\n",
       "      <td>/agent11/battery4/charging</td>\n",
       "      <td>/basic/text</td>\n",
       "      <td>read</td>\n",
       "      <td>true</td>\n",
       "      <td>1520117997401</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357950</th>\n",
       "      <td>lightcontrol28</td>\n",
       "      <td>/agent28/lightcontrol28</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>room_9</td>\n",
       "      <td>/agent28/movement28</td>\n",
       "      <td>/movementSensor</td>\n",
       "      <td>room_9</td>\n",
       "      <td>/agent28/movement28/movement</td>\n",
       "      <td>/derived/boolean</td>\n",
       "      <td>read</td>\n",
       "      <td>0</td>\n",
       "      <td>1520117998907</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357951</th>\n",
       "      <td>lightcontrol28</td>\n",
       "      <td>/agent28/lightcontrol28</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>room_9</td>\n",
       "      <td>/agent28/tempin28</td>\n",
       "      <td>/sensorService</td>\n",
       "      <td>room_9</td>\n",
       "      <td>/agent28/tempin28</td>\n",
       "      <td>/sensorService</td>\n",
       "      <td>read</td>\n",
       "      <td>20.4131</td>\n",
       "      <td>1520117999000</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>357952 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               sourceID             sourceAddress       sourceType  \\\n",
       "0         lightcontrol2     /agent2/lightcontrol2  /lightControler   \n",
       "1         lightcontrol3     /agent3/lightcontrol3  /lightControler   \n",
       "2         lightcontrol1     /agent1/lightcontrol1  /lightControler   \n",
       "3         lightcontrol4     /agent4/lightcontrol4  /lightControler   \n",
       "4             movement4         /agent4/movement4  /movementSensor   \n",
       "...                 ...                       ...              ...   \n",
       "357947   lightcontrol23   /agent23/lightcontrol23  /lightControler   \n",
       "357948  washingmachine2  /agent11/washingmachine2  /washingService   \n",
       "357949  washingmachine2  /agent11/washingmachine2  /washingService   \n",
       "357950   lightcontrol28   /agent28/lightcontrol28  /lightControler   \n",
       "357951   lightcontrol28   /agent28/lightcontrol28  /lightControler   \n",
       "\n",
       "         sourceLocation destinationServiceAddress destinationServiceType  \\\n",
       "0        BedroomParents     /agent2/lightcontrol2        /lightControler   \n",
       "1           Dinningroom     /agent3/lightcontrol3        /lightControler   \n",
       "2       BedroomChildren     /agent1/lightcontrol1        /lightControler   \n",
       "3               Kitchen     /agent4/lightcontrol4        /lightControler   \n",
       "4               Kitchen         /agent4/movement4        /movementSensor   \n",
       "...                 ...                       ...                    ...   \n",
       "357947           room_4         /agent23/tempin23         /sensorService   \n",
       "357948       Watterroom         /agent11/battery4        /batteryService   \n",
       "357949       Watterroom         /agent11/battery4        /batteryService   \n",
       "357950           room_9       /agent28/movement28        /movementSensor   \n",
       "357951           room_9         /agent28/tempin28         /sensorService   \n",
       "\n",
       "       destinationLocation           accessedNodeAddress  accessedNodeType  \\\n",
       "0           BedroomParents         /agent2/lightcontrol2   /lightControler   \n",
       "1              Dinningroom         /agent3/lightcontrol3   /lightControler   \n",
       "2          BedroomChildren         /agent1/lightcontrol1   /lightControler   \n",
       "3                  Kitchen         /agent4/lightcontrol4   /lightControler   \n",
       "4                  Kitchen             /agent4/movement4   /movementSensor   \n",
       "...                    ...                           ...               ...   \n",
       "357947              room_4             /agent23/tempin23    /sensorService   \n",
       "357948          Watterroom      /agent11/battery4/charge     /basic/number   \n",
       "357949          Watterroom    /agent11/battery4/charging       /basic/text   \n",
       "357950              room_9  /agent28/movement28/movement  /derived/boolean   \n",
       "357951              room_9             /agent28/tempin28    /sensorService   \n",
       "\n",
       "              operation    value      timestamp normality  \n",
       "0       registerService     none  1520031600000    normal  \n",
       "1       registerService     none  1520031603269    normal  \n",
       "2       registerService     none  1520031603279    normal  \n",
       "3       registerService     none  1520031603290    normal  \n",
       "4       registerService     none  1520031603464    normal  \n",
       "...                 ...      ...            ...       ...  \n",
       "357947             read  20.3479  1520117997001    normal  \n",
       "357948             read        9  1520117997339    normal  \n",
       "357949             read     true  1520117997401    normal  \n",
       "357950             read        0  1520117998907    normal  \n",
       "357951             read  20.4131  1520117999000    normal  \n",
       "\n",
       "[357952 rows x 13 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv('mainSimulationAccessTraces.csv')\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "2e892996",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7</td>\n",
       "      <td>21</td>\n",
       "      <td>30</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>29</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>57</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7</td>\n",
       "      <td>32</td>\n",
       "      <td>70</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>67</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>132</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7</td>\n",
       "      <td>33</td>\n",
       "      <td>77</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>72</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>142</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7</td>\n",
       "      <td>55</td>\n",
       "      <td>78</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>73</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>144</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355886</th>\n",
       "      <td>7</td>\n",
       "      <td>25</td>\n",
       "      <td>46</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>45</td>\n",
       "      <td>4</td>\n",
       "      <td>15</td>\n",
       "      <td>90</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>8505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355887</th>\n",
       "      <td>7</td>\n",
       "      <td>82</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355888</th>\n",
       "      <td>7</td>\n",
       "      <td>82</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355889</th>\n",
       "      <td>7</td>\n",
       "      <td>30</td>\n",
       "      <td>62</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>60</td>\n",
       "      <td>3</td>\n",
       "      <td>20</td>\n",
       "      <td>120</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355890</th>\n",
       "      <td>7</td>\n",
       "      <td>30</td>\n",
       "      <td>62</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>61</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "      <td>121</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>9156</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>355891 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        0   1   2  3   4   5  6   7    8  9  10    11\n",
       "0       7  21  30  2   3  29  2   3   57  5   1     0\n",
       "1       7  32  70  2   4  67  2   4  132  5   1     0\n",
       "2       7  15   1  2   2   0  2   2    0  5   1     0\n",
       "3       7  33  77  2   7  72  2   7  142  5   1     0\n",
       "4       7  55  78  3   7  73  3   7  144  6   1     0\n",
       "...    ..  ..  .. ..  ..  .. ..  ..  ... ..  ..   ...\n",
       "355886  7  25  46  2  15  45  4  15   90  7   0  8505\n",
       "355887  7  82  14  7  10   8  0  10   16  0   0    22\n",
       "355888  7  82  14  7  10   8  0  10   17  1   0     1\n",
       "355889  7  30  62  2  20  60  3  20  120  3   0     0\n",
       "355890  7  30  62  2  20  61  4  20  121  7   0  9156\n",
       "\n",
       "[355891 rows x 12 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv('dataset.csv')\n",
    "data"
   ]
  },
  {
   "cell_type": "raw",
   "id": "26645fdf",
   "metadata": {},
   "source": [
    " x = data.iloc[:,0:-1].values\n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "6ee10d0f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(array([[  21,   30,    2, ...,    5,    1,    0],\n",
       "        [  32,   70,    2, ...,    5,    1,    0],\n",
       "        [  15,    1,    2, ...,    5,    1,    0],\n",
       "        ...,\n",
       "        [  82,   14,    7, ...,    1,    0,    1],\n",
       "        [  30,   62,    2, ...,    3,    0,    0],\n",
       "        [  30,   62,    2, ...,    7,    0, 9156]], dtype=int64),\n",
       " array([7, 7, 7, ..., 7, 7, 7], dtype=int64))"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y = data.iloc[:,0].values\n",
    "x = data.iloc[:,1:].values\n",
    "x,y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "4a717af0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(355891,)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "c74a06de",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "KMeans()"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model = KMeans(n_clusters = 8)\n",
    "model.fit(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ada5433f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0, 0, 0, ..., 0, 0, 5])"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model.labels_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b12c16c1",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "8fd5ad5a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "228252"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c = 0\n",
    "d = {\n",
    "    0:7,1:6,2:5,3:4,4:3,5:2,6:1,7:0\n",
    "}\n",
    "for i in range(len(model.labels_)):\n",
    "    z = d[model.labels_[i]]\n",
    "    if(z == y[i]):\n",
    "        c+=1\n",
    "c"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "05ad667d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "d4b8d1cc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "19233"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c= 0\n",
    "for i in range(len(model.labels_)):\n",
    "   \n",
    "    if(model.labels_[i] == y[i]):\n",
    "        c+=1\n",
    "c"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "79ef93e4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.05404182741344962"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c/355891"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "2d5dd6be",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.mixture import GaussianMixture"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "5fe3241e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "GaussianMixture(n_components=8)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gmm = GaussianMixture(n_components = 8)\n",
    "gmm.fit(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "865dece6",
   "metadata": {},
   "outputs": [],
   "source": [
    "yp = gmm.predict(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "8dfb4ece",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "219950"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c = 0\n",
    "for i in range(len(yp)):\n",
    "    a = d[yp[i]]\n",
    "    if(a == y[i]):\n",
    "        c+=1\n",
    "c"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "901eacf8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.6180263058071152"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c/355891"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "944f8046",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.061089</td>\n",
       "      <td>0.045652</td>\n",
       "      <td>-0.076577</td>\n",
       "      <td>0.092182</td>\n",
       "      <td>0.019976</td>\n",
       "      <td>-0.065110</td>\n",
       "      <td>0.131751</td>\n",
       "      <td>0.017755</td>\n",
       "      <td>-0.039422</td>\n",
       "      <td>0.031757</td>\n",
       "      <td>0.017717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.061089</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.145622</td>\n",
       "      <td>0.906060</td>\n",
       "      <td>0.082407</td>\n",
       "      <td>0.073840</td>\n",
       "      <td>0.233804</td>\n",
       "      <td>0.116169</td>\n",
       "      <td>0.070714</td>\n",
       "      <td>0.327228</td>\n",
       "      <td>0.564896</td>\n",
       "      <td>0.325960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.045652</td>\n",
       "      <td>0.145622</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.053064</td>\n",
       "      <td>-0.026681</td>\n",
       "      <td>0.986934</td>\n",
       "      <td>0.032060</td>\n",
       "      <td>0.078348</td>\n",
       "      <td>0.986467</td>\n",
       "      <td>0.050886</td>\n",
       "      <td>0.040357</td>\n",
       "      <td>0.052695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-0.076577</td>\n",
       "      <td>0.906060</td>\n",
       "      <td>0.053064</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.009098</td>\n",
       "      <td>-0.026952</td>\n",
       "      <td>0.104214</td>\n",
       "      <td>0.022177</td>\n",
       "      <td>-0.028517</td>\n",
       "      <td>0.170593</td>\n",
       "      <td>0.344285</td>\n",
       "      <td>0.176814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.092182</td>\n",
       "      <td>0.082407</td>\n",
       "      <td>-0.026681</td>\n",
       "      <td>-0.009098</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.006078</td>\n",
       "      <td>0.318271</td>\n",
       "      <td>0.951994</td>\n",
       "      <td>-0.012174</td>\n",
       "      <td>0.282165</td>\n",
       "      <td>0.084317</td>\n",
       "      <td>0.174313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.019976</td>\n",
       "      <td>0.073840</td>\n",
       "      <td>0.986934</td>\n",
       "      <td>-0.026952</td>\n",
       "      <td>-0.006078</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.104745</td>\n",
       "      <td>0.096543</td>\n",
       "      <td>0.999838</td>\n",
       "      <td>0.113830</td>\n",
       "      <td>0.031692</td>\n",
       "      <td>0.086948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.065110</td>\n",
       "      <td>0.233804</td>\n",
       "      <td>0.032060</td>\n",
       "      <td>0.104214</td>\n",
       "      <td>0.318271</td>\n",
       "      <td>0.104745</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.302678</td>\n",
       "      <td>0.106085</td>\n",
       "      <td>0.931384</td>\n",
       "      <td>0.324641</td>\n",
       "      <td>0.599724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.131751</td>\n",
       "      <td>0.116169</td>\n",
       "      <td>0.078348</td>\n",
       "      <td>0.022177</td>\n",
       "      <td>0.951994</td>\n",
       "      <td>0.096543</td>\n",
       "      <td>0.302678</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.090084</td>\n",
       "      <td>0.267554</td>\n",
       "      <td>0.089812</td>\n",
       "      <td>0.166285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.017755</td>\n",
       "      <td>0.070714</td>\n",
       "      <td>0.986467</td>\n",
       "      <td>-0.028517</td>\n",
       "      <td>-0.012174</td>\n",
       "      <td>0.999838</td>\n",
       "      <td>0.106085</td>\n",
       "      <td>0.090084</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.112277</td>\n",
       "      <td>0.027096</td>\n",
       "      <td>0.082581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-0.039422</td>\n",
       "      <td>0.327228</td>\n",
       "      <td>0.050886</td>\n",
       "      <td>0.170593</td>\n",
       "      <td>0.282165</td>\n",
       "      <td>0.113830</td>\n",
       "      <td>0.931384</td>\n",
       "      <td>0.267554</td>\n",
       "      <td>0.112277</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.449554</td>\n",
       "      <td>0.734138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.031757</td>\n",
       "      <td>0.564896</td>\n",
       "      <td>0.040357</td>\n",
       "      <td>0.344285</td>\n",
       "      <td>0.084317</td>\n",
       "      <td>0.031692</td>\n",
       "      <td>0.324641</td>\n",
       "      <td>0.089812</td>\n",
       "      <td>0.027096</td>\n",
       "      <td>0.449554</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.454278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.017717</td>\n",
       "      <td>0.325960</td>\n",
       "      <td>0.052695</td>\n",
       "      <td>0.176814</td>\n",
       "      <td>0.174313</td>\n",
       "      <td>0.086948</td>\n",
       "      <td>0.599724</td>\n",
       "      <td>0.166285</td>\n",
       "      <td>0.082581</td>\n",
       "      <td>0.734138</td>\n",
       "      <td>0.454278</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           0         1         2         3         4         5         6  \\\n",
       "0   1.000000  0.061089  0.045652 -0.076577  0.092182  0.019976 -0.065110   \n",
       "1   0.061089  1.000000  0.145622  0.906060  0.082407  0.073840  0.233804   \n",
       "2   0.045652  0.145622  1.000000  0.053064 -0.026681  0.986934  0.032060   \n",
       "3  -0.076577  0.906060  0.053064  1.000000 -0.009098 -0.026952  0.104214   \n",
       "4   0.092182  0.082407 -0.026681 -0.009098  1.000000 -0.006078  0.318271   \n",
       "5   0.019976  0.073840  0.986934 -0.026952 -0.006078  1.000000  0.104745   \n",
       "6  -0.065110  0.233804  0.032060  0.104214  0.318271  0.104745  1.000000   \n",
       "7   0.131751  0.116169  0.078348  0.022177  0.951994  0.096543  0.302678   \n",
       "8   0.017755  0.070714  0.986467 -0.028517 -0.012174  0.999838  0.106085   \n",
       "9  -0.039422  0.327228  0.050886  0.170593  0.282165  0.113830  0.931384   \n",
       "10  0.031757  0.564896  0.040357  0.344285  0.084317  0.031692  0.324641   \n",
       "11  0.017717  0.325960  0.052695  0.176814  0.174313  0.086948  0.599724   \n",
       "\n",
       "           7         8         9        10        11  \n",
       "0   0.131751  0.017755 -0.039422  0.031757  0.017717  \n",
       "1   0.116169  0.070714  0.327228  0.564896  0.325960  \n",
       "2   0.078348  0.986467  0.050886  0.040357  0.052695  \n",
       "3   0.022177 -0.028517  0.170593  0.344285  0.176814  \n",
       "4   0.951994 -0.012174  0.282165  0.084317  0.174313  \n",
       "5   0.096543  0.999838  0.113830  0.031692  0.086948  \n",
       "6   0.302678  0.106085  0.931384  0.324641  0.599724  \n",
       "7   1.000000  0.090084  0.267554  0.089812  0.166285  \n",
       "8   0.090084  1.000000  0.112277  0.027096  0.082581  \n",
       "9   0.267554  0.112277  1.000000  0.449554  0.734138  \n",
       "10  0.089812  0.027096  0.449554  1.000000  0.454278  \n",
       "11  0.166285  0.082581  0.734138  0.454278  1.000000  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "correlations = data.corr(method='pearson')\n",
    "correlations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "e3c57181",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    -7.389561\n",
       "1     0.290022\n",
       "2     0.077694\n",
       "3     0.591577\n",
       "4     0.361776\n",
       "5     0.020013\n",
       "6    -0.401814\n",
       "7     0.538168\n",
       "8     0.027146\n",
       "9     0.149707\n",
       "10    0.832121\n",
       "11    1.392186\n",
       "dtype: float64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.skew()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "ee77284f",
   "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>sourceID</th>\n",
       "      <th>sourceAddress</th>\n",
       "      <th>sourceType</th>\n",
       "      <th>sourceLocation</th>\n",
       "      <th>destinationServiceAddress</th>\n",
       "      <th>destinationServiceType</th>\n",
       "      <th>destinationLocation</th>\n",
       "      <th>accessedNodeAddress</th>\n",
       "      <th>accessedNodeType</th>\n",
       "      <th>operation</th>\n",
       "      <th>value</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>normality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>lightcontrol2</td>\n",
       "      <td>/agent2/lightcontrol2</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>BedroomParents</td>\n",
       "      <td>/agent2/lightcontrol2</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>BedroomParents</td>\n",
       "      <td>/agent2/lightcontrol2</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>registerService</td>\n",
       "      <td>none</td>\n",
       "      <td>1520031600000</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>lightcontrol3</td>\n",
       "      <td>/agent3/lightcontrol3</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>Dinningroom</td>\n",
       "      <td>/agent3/lightcontrol3</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>Dinningroom</td>\n",
       "      <td>/agent3/lightcontrol3</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>registerService</td>\n",
       "      <td>none</td>\n",
       "      <td>1520031603269</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>lightcontrol1</td>\n",
       "      <td>/agent1/lightcontrol1</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>BedroomChildren</td>\n",
       "      <td>/agent1/lightcontrol1</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>BedroomChildren</td>\n",
       "      <td>/agent1/lightcontrol1</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>registerService</td>\n",
       "      <td>none</td>\n",
       "      <td>1520031603279</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>lightcontrol4</td>\n",
       "      <td>/agent4/lightcontrol4</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>Kitchen</td>\n",
       "      <td>/agent4/lightcontrol4</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>Kitchen</td>\n",
       "      <td>/agent4/lightcontrol4</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>registerService</td>\n",
       "      <td>none</td>\n",
       "      <td>1520031603290</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>movement4</td>\n",
       "      <td>/agent4/movement4</td>\n",
       "      <td>/movementSensor</td>\n",
       "      <td>Kitchen</td>\n",
       "      <td>/agent4/movement4</td>\n",
       "      <td>/movementSensor</td>\n",
       "      <td>Kitchen</td>\n",
       "      <td>/agent4/movement4</td>\n",
       "      <td>/movementSensor</td>\n",
       "      <td>registerService</td>\n",
       "      <td>none</td>\n",
       "      <td>1520031603464</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357947</th>\n",
       "      <td>lightcontrol23</td>\n",
       "      <td>/agent23/lightcontrol23</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>room_4</td>\n",
       "      <td>/agent23/tempin23</td>\n",
       "      <td>/sensorService</td>\n",
       "      <td>room_4</td>\n",
       "      <td>/agent23/tempin23</td>\n",
       "      <td>/sensorService</td>\n",
       "      <td>read</td>\n",
       "      <td>20.3479</td>\n",
       "      <td>1520117997001</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357948</th>\n",
       "      <td>washingmachine2</td>\n",
       "      <td>/agent11/washingmachine2</td>\n",
       "      <td>/washingService</td>\n",
       "      <td>Watterroom</td>\n",
       "      <td>/agent11/battery4</td>\n",
       "      <td>/batteryService</td>\n",
       "      <td>Watterroom</td>\n",
       "      <td>/agent11/battery4/charge</td>\n",
       "      <td>/basic/number</td>\n",
       "      <td>read</td>\n",
       "      <td>9</td>\n",
       "      <td>1520117997339</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357949</th>\n",
       "      <td>washingmachine2</td>\n",
       "      <td>/agent11/washingmachine2</td>\n",
       "      <td>/washingService</td>\n",
       "      <td>Watterroom</td>\n",
       "      <td>/agent11/battery4</td>\n",
       "      <td>/batteryService</td>\n",
       "      <td>Watterroom</td>\n",
       "      <td>/agent11/battery4/charging</td>\n",
       "      <td>/basic/text</td>\n",
       "      <td>read</td>\n",
       "      <td>true</td>\n",
       "      <td>1520117997401</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357950</th>\n",
       "      <td>lightcontrol28</td>\n",
       "      <td>/agent28/lightcontrol28</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>room_9</td>\n",
       "      <td>/agent28/movement28</td>\n",
       "      <td>/movementSensor</td>\n",
       "      <td>room_9</td>\n",
       "      <td>/agent28/movement28/movement</td>\n",
       "      <td>/derived/boolean</td>\n",
       "      <td>read</td>\n",
       "      <td>0</td>\n",
       "      <td>1520117998907</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357951</th>\n",
       "      <td>lightcontrol28</td>\n",
       "      <td>/agent28/lightcontrol28</td>\n",
       "      <td>/lightControler</td>\n",
       "      <td>room_9</td>\n",
       "      <td>/agent28/tempin28</td>\n",
       "      <td>/sensorService</td>\n",
       "      <td>room_9</td>\n",
       "      <td>/agent28/tempin28</td>\n",
       "      <td>/sensorService</td>\n",
       "      <td>read</td>\n",
       "      <td>20.4131</td>\n",
       "      <td>1520117999000</td>\n",
       "      <td>normal</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>357952 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               sourceID             sourceAddress       sourceType  \\\n",
       "0         lightcontrol2     /agent2/lightcontrol2  /lightControler   \n",
       "1         lightcontrol3     /agent3/lightcontrol3  /lightControler   \n",
       "2         lightcontrol1     /agent1/lightcontrol1  /lightControler   \n",
       "3         lightcontrol4     /agent4/lightcontrol4  /lightControler   \n",
       "4             movement4         /agent4/movement4  /movementSensor   \n",
       "...                 ...                       ...              ...   \n",
       "357947   lightcontrol23   /agent23/lightcontrol23  /lightControler   \n",
       "357948  washingmachine2  /agent11/washingmachine2  /washingService   \n",
       "357949  washingmachine2  /agent11/washingmachine2  /washingService   \n",
       "357950   lightcontrol28   /agent28/lightcontrol28  /lightControler   \n",
       "357951   lightcontrol28   /agent28/lightcontrol28  /lightControler   \n",
       "\n",
       "         sourceLocation destinationServiceAddress destinationServiceType  \\\n",
       "0        BedroomParents     /agent2/lightcontrol2        /lightControler   \n",
       "1           Dinningroom     /agent3/lightcontrol3        /lightControler   \n",
       "2       BedroomChildren     /agent1/lightcontrol1        /lightControler   \n",
       "3               Kitchen     /agent4/lightcontrol4        /lightControler   \n",
       "4               Kitchen         /agent4/movement4        /movementSensor   \n",
       "...                 ...                       ...                    ...   \n",
       "357947           room_4         /agent23/tempin23         /sensorService   \n",
       "357948       Watterroom         /agent11/battery4        /batteryService   \n",
       "357949       Watterroom         /agent11/battery4        /batteryService   \n",
       "357950           room_9       /agent28/movement28        /movementSensor   \n",
       "357951           room_9         /agent28/tempin28         /sensorService   \n",
       "\n",
       "       destinationLocation           accessedNodeAddress  accessedNodeType  \\\n",
       "0           BedroomParents         /agent2/lightcontrol2   /lightControler   \n",
       "1              Dinningroom         /agent3/lightcontrol3   /lightControler   \n",
       "2          BedroomChildren         /agent1/lightcontrol1   /lightControler   \n",
       "3                  Kitchen         /agent4/lightcontrol4   /lightControler   \n",
       "4                  Kitchen             /agent4/movement4   /movementSensor   \n",
       "...                    ...                           ...               ...   \n",
       "357947              room_4             /agent23/tempin23    /sensorService   \n",
       "357948          Watterroom      /agent11/battery4/charge     /basic/number   \n",
       "357949          Watterroom    /agent11/battery4/charging       /basic/text   \n",
       "357950              room_9  /agent28/movement28/movement  /derived/boolean   \n",
       "357951              room_9             /agent28/tempin28    /sensorService   \n",
       "\n",
       "              operation    value      timestamp normality  \n",
       "0       registerService     none  1520031600000    normal  \n",
       "1       registerService     none  1520031603269    normal  \n",
       "2       registerService     none  1520031603279    normal  \n",
       "3       registerService     none  1520031603290    normal  \n",
       "4       registerService     none  1520031603464    normal  \n",
       "...                 ...      ...            ...       ...  \n",
       "357947             read  20.3479  1520117997001    normal  \n",
       "357948             read        9  1520117997339    normal  \n",
       "357949             read     true  1520117997401    normal  \n",
       "357950             read        0  1520117998907    normal  \n",
       "357951             read  20.4131  1520117999000    normal  \n",
       "\n",
       "[357952 rows x 13 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data1 = pd.read_csv('mainSimulationAccessTraces.csv')\n",
    "data1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "672d6ed4",
   "metadata": {},
   "outputs": [],
   "source": [
    "data1 = data1.drop(['timestamp'],axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "11809eb2",
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: []\n",
       "Index: []"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "correlations = data1.corr(method='pearson')\n",
    "correlations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "4614c5dc",
   "metadata": {},
   "outputs": [],
   "source": [
    "from matplotlib import pyplot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "1905659d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAHUAAABSCAYAAABqrZsyAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAEQUlEQVR4nO2dTWhcVRiGn9fWKmShYLMoWqjFYsjCRTtIVyKI0GaRLnSRbjRSCUWLa8GF0I24EsRiCVr8WdRiVxEUERRcWTsBf1pFSQUxUjCt0o1QDXwu7k0N0yRz7uTcubcf3wMDc+fcn5d5uDOHw3fukZkR+OK2pgME+QmpDgmpDgmpDgmpDgmpDukrVdIpSX9IurBOuyS9LmlB0neS9uaPGVQh5U59BziwQftBYE/5mgHe3HysYDP0lWpmXwJ/brDLIeA9K/gKuFvSjlwBg+rk+E+9F/ht1fZi+VnQEFuHeTFJMxQ/0YyMjOwbGxsb5uVvOebn56+Y2WjV43JI/R3YuWr7vvKzmzCzWWAWoNPpWLfbzXB5v0j6dZDjcvz8zgFPlb3g/cA1M7uc4bzBgPS9UyWdBh4FtktaBF4Gbgcws5PAx8AEsAD8DTxTV9ggjb5Szexwn3YDns+WKNg0MaLkkJDqkJDqkJDqkJDqkJDqkJDqkJDqkJDqkJDqkJDqkJDqkJDqkJDqkJDqkCSpkg5I+qms7X1xjfZpSUuSvilfz+aPGqSSUvmwBTgBPE5RKXhe0pyZ/dCz6xkzO1ZDxqAiKXfqw8CCmf1iZv8AH1DU+gYtJUVqal3vE+W0i7OSdq7RjqQZSV1J3aWlpQHiBink6ih9BOwys4eAz4B319rJzGbNrGNmndHRyuWsQSIpUvvW9ZrZVTO7Xm6+BezLEy8YhBSp54E9ku6XtA2Yoqj1vUHP3JlJ4Md8EYOqpJSILks6BnwKbAFOmdlFSceBrpnNAS9ImgSWKSZTTdeYOeiDmnrkTky76I+keTPrVD0uRpQcElIdElIdElIdElIdElIdElIdElIdElIdElIdElIdElIdElIdElIdkqtE9A5JZ8r2c5J2ZU8aJJPyvN+VEtGDwDhwWNJ4z25HgL/M7AHgNeDV3EGDdHKViB7i/2Kzs8BjkpQvZlCFXCWiN/Yxs2XgGnBPjoBBdRp7NCxwfb1HuDfEduBK0yF6eHCQg1Kkpjz6dWWfRUlbgbuAq70nWv1oWEndQepv6qJteaDINMhxWUpEy+2ny/dPAp9bLCLXGLlKRN8G3pe0QFEiOlVn6GBjGisRlTRT/hy3grblgcEzNSY1qI8YJnRI7VLbNsTYtlnxtazQZWa1vSg6VpeA3cA24FtgvGef54CT5fspihnpTeaZBt6o83vpud4jwF7gwjrtE8AngID9wLl+56z7Tm3bEGPrZsVbDSt01S21bUOM2WbFD5HKK3RFR+lmkmbFt5m6pVYZYmSjIcZh5WnhrPjkFbpWqFtq24YYb8VZ8dVX6BpC724C+Jmi1/lS+dlxYLJ8fyfwIcUKVF8DuxvO8wpwkaJn/AUwVnOe08Bl4F+K/8sjwFHgaNkuiiKFS8D3QKffOWNEySHRUXJISHVISHVISHVISHVISHVISHVISHXIfxdQlcvz7SloAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "data.plot(kind='density', sharex=False)\n",
    "ax=pyplot.subplot(4,4,4)\n",
    "pyplot.show()\n"
   ]
  }
 ],
 "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}