01.3 - Creating Session_ID.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d97cfb6e",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c63e93b6",
   "metadata": {},
   "outputs": [],
   "source": [
    "def intjoin(list):\n",
    "    s = [str(i) for i in list]\n",
    "    res = int(\"\".join(s))\n",
    "    return(res)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "909937c5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['./csvs\\\\A211102.csv',\n",
       " './csvs\\\\A211103.csv',\n",
       " './csvs\\\\A211105.csv',\n",
       " './csvs\\\\A211108.csv',\n",
       " './csvs\\\\A211109.csv',\n",
       " './csvs\\\\A211110.csv',\n",
       " './csvs\\\\A211112.csv',\n",
       " './csvs\\\\A211115.csv',\n",
       " './csvs\\\\A211116.csv',\n",
       " './csvs\\\\A211117.csv',\n",
       " './csvs\\\\A211118.csv',\n",
       " './csvs\\\\A211119.csv',\n",
       " './csvs\\\\A211122.csv',\n",
       " './csvs\\\\A211123.csv',\n",
       " './csvs\\\\A211124.csv',\n",
       " './csvs\\\\A211125.csv',\n",
       " './csvs\\\\A211126.csv',\n",
       " './csvs\\\\A211206.csv',\n",
       " './csvs\\\\A211207.csv',\n",
       " './csvs\\\\A211208.csv',\n",
       " './csvs\\\\A211223.csv',\n",
       " './csvs\\\\A211225.csv',\n",
       " './csvs\\\\A211228.csv',\n",
       " './csvs\\\\A220103.csv',\n",
       " './csvs\\\\ACTIVE_Test.csv',\n",
       " './csvs\\\\ACTIVE_Train.csv',\n",
       " './csvs\\\\I211102.csv',\n",
       " './csvs\\\\I211103.csv',\n",
       " './csvs\\\\I211104.csv',\n",
       " './csvs\\\\I211108.csv',\n",
       " './csvs\\\\I211110.csv',\n",
       " './csvs\\\\I211112.csv',\n",
       " './csvs\\\\I211115.csv',\n",
       " './csvs\\\\I211116.csv',\n",
       " './csvs\\\\I211117.csv',\n",
       " './csvs\\\\I211118.csv',\n",
       " './csvs\\\\I211119.csv',\n",
       " './csvs\\\\I211122.csv',\n",
       " './csvs\\\\I211124.csv',\n",
       " './csvs\\\\I211125.csv',\n",
       " './csvs\\\\I211126.csv',\n",
       " './csvs\\\\I211129.csv',\n",
       " './csvs\\\\I211130.csv',\n",
       " './csvs\\\\I211201.csv',\n",
       " './csvs\\\\I211202.csv',\n",
       " './csvs\\\\I211203.csv',\n",
       " './csvs\\\\I211207.csv',\n",
       " './csvs\\\\I211208.csv',\n",
       " './csvs\\\\I211209.csv',\n",
       " './csvs\\\\I211210.csv',\n",
       " './csvs\\\\I211213.csv',\n",
       " './csvs\\\\I211215.csv',\n",
       " './csvs\\\\I211216.csv',\n",
       " './csvs\\\\I211220.csv',\n",
       " './csvs\\\\I211222.csv',\n",
       " './csvs\\\\I211223.csv',\n",
       " './csvs\\\\IDLE_Test.csv',\n",
       " './csvs\\\\IDLE_Train.csv',\n",
       " './csvs\\\\Interactions_Test.csv',\n",
       " './csvs\\\\Interactions_Train.csv',\n",
       " './csvs\\\\Power_Test.csv',\n",
       " './csvs\\\\Power_Train.csv']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def find_the_way(path,file_format,con=\"\"):\n",
    "    files_add = []\n",
    "    # r=root, d=directories, f = files\n",
    "    for r, d, f in os.walk(path):\n",
    "        for file in f:\n",
    "            if file_format in file:\n",
    "                if con in file:\n",
    "                    files_add.append(os.path.join(r, file))  \n",
    "            \n",
    "    return files_add\n",
    "path=\"./csvs\"\n",
    "filenames=find_the_way(path,\".csv\")\n",
    "filenames"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8ebf9044",
   "metadata": {},
   "source": [
    "#### Rename CSV files\n",
    "#### formed by adding the prefixes A for \"Active\" and I for \"Idle\" to the date of data collection."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "f4feb25f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "A211102\n",
      "I211102\n",
      "A211103\n",
      "I211103\n",
      "I211104\n",
      "A211105\n",
      "A211108\n",
      "I211108\n",
      "A211109\n",
      "A211110\n",
      "I211110\n",
      "A211112\n",
      "I211112\n",
      "A211115\n",
      "I211115\n",
      "A211116\n",
      "I211116\n",
      "A211117\n",
      "I211117\n",
      "A211118\n",
      "I211118\n",
      "A211119\n",
      "I211119\n",
      "A211122\n",
      "I211122\n",
      "A211123\n",
      "A211124\n",
      "I211124\n",
      "A211125\n",
      "I211125\n",
      "A211126\n",
      "I211126\n",
      "I211129\n",
      "I211130\n",
      "I211201\n",
      "I211202\n",
      "I211203\n",
      "A211206\n",
      "A211207\n",
      "I211207\n",
      "A211208\n",
      "I211208\n",
      "I211209\n",
      "I211210\n",
      "I211213\n",
      "I211215\n",
      "I211216\n",
      "I211220\n",
      "I211222\n",
      "A211223\n",
      "I211223\n",
      "A211225\n",
      "A211228\n",
      "A220103\n"
     ]
    }
   ],
   "source": [
    "for i in filenames:\n",
    "    temp=i[9:-7]\n",
    "    temp=temp.replace(\"_\",\"\")\n",
    "    if \"Active\" in temp:\n",
    "        temp=temp.replace(\"Active\",\"\")\n",
    "        temp=f\"A{temp}\"\n",
    "    else:\n",
    "        temp=temp.replace(\"Idle\",\"\")\n",
    "        temp=f\"I{temp}\"\n",
    "    print(temp)\n",
    "    os.rename(i,f\"./csvs/{temp}.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a0fe6d87",
   "metadata": {},
   "outputs": [],
   "source": [
    "renamer={'Amazon Alexa Echo Dot 1': \"Amazon Alexa Echo Dot\",\n",
    " 'Amazon Alexa Echo Dot 2': \"Amazon Alexa Echo Dot\",\n",
    " 'D-Link DCHS-161 Water Sensor': 'D-Link Water Sensor',\n",
    " 'DCS8000LHA1 D-Link Mini Camera': 'D-Link Mini Camera',\n",
    " 'Gosund ESP_032979 Plug':'Gosund Plug',\n",
    " 'Gosund ESP_039AAF Socket':'Gosund Socket',\n",
    " 'Gosund ESP_0C3994 Plug': 'Gosund Plug',\n",
    " 'Gosund ESP_10098F Socket':'Gosund Socket',\n",
    " 'Gosund ESP_10ACD8 Plug':'Gosund Plug',\n",
    " 'Gosund ESP_147FF9 Plug': 'Gosund Plug',\n",
    " 'Gosund ESP_1ACEE1  Socket':'Gosund Socket',\n",
    " 'Philips Hue Bridge 1': \"Philips Hue Bridge\",\n",
    " 'Philips Hue Bridge 2': \"Philips Hue Bridge\",\n",
    " 'Philips Hue White 1': \"Philips Hue White\",\n",
    " 'Philips Hue White 2':\"Philips Hue White\",\n",
    " 'Ring Base Station AC:1236': 'Ring Base Station',\n",
    " 'Sengled Smart Plug 1': 'Sengled Smart Plug',\n",
    " 'Sengled Smart Plug 2': 'Sengled Smart Plug',\n",
    " 'SmartThings Smart Bulb 1': 'SmartThings Smart Bulb',\n",
    " 'SmartThings Smart Bulb 2': 'SmartThings Smart Bulb',\n",
    " 'SmartThings Smart Bulb 3': 'SmartThings Smart Bulb',\n",
    " 'SmartThings Smart Bulb 4': 'SmartThings Smart Bulb',\n",
    " 'SmartThings Smart Bulb 5': 'SmartThings Smart Bulb',\n",
    " 'Sonoff Smart Plug 1': 'Sonoff Smart Plug',\n",
    " 'Sonoff Smart Plug 2': 'Sonoff Smart Plug',\n",
    " 'Teckin Plug 1':'Teckin Plug',\n",
    " 'Teckin Plug 2':'Teckin Plug',\n",
    " 'Yutron Plug 1': 'Yutron Plug',\n",
    " 'Yutron Plug 2':  'Yutron Plug'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "c2a17c80",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['./csvs\\\\A211102.csv',\n",
       " './csvs\\\\A211103.csv',\n",
       " './csvs\\\\A211105.csv',\n",
       " './csvs\\\\A211108.csv',\n",
       " './csvs\\\\A211109.csv',\n",
       " './csvs\\\\A211110.csv',\n",
       " './csvs\\\\A211112.csv',\n",
       " './csvs\\\\A211115.csv',\n",
       " './csvs\\\\A211116.csv',\n",
       " './csvs\\\\A211117.csv',\n",
       " './csvs\\\\A211118.csv',\n",
       " './csvs\\\\A211119.csv',\n",
       " './csvs\\\\A211122.csv',\n",
       " './csvs\\\\A211123.csv',\n",
       " './csvs\\\\A211124.csv',\n",
       " './csvs\\\\A211125.csv',\n",
       " './csvs\\\\A211126.csv',\n",
       " './csvs\\\\A211206.csv',\n",
       " './csvs\\\\A211207.csv',\n",
       " './csvs\\\\A211208.csv',\n",
       " './csvs\\\\A211223.csv',\n",
       " './csvs\\\\A211225.csv',\n",
       " './csvs\\\\A211228.csv',\n",
       " './csvs\\\\A220103.csv',\n",
       " './csvs\\\\I211102.csv',\n",
       " './csvs\\\\I211103.csv',\n",
       " './csvs\\\\I211104.csv',\n",
       " './csvs\\\\I211108.csv',\n",
       " './csvs\\\\I211110.csv',\n",
       " './csvs\\\\I211112.csv',\n",
       " './csvs\\\\I211115.csv',\n",
       " './csvs\\\\I211116.csv',\n",
       " './csvs\\\\I211117.csv',\n",
       " './csvs\\\\I211118.csv',\n",
       " './csvs\\\\I211119.csv',\n",
       " './csvs\\\\I211122.csv',\n",
       " './csvs\\\\I211124.csv',\n",
       " './csvs\\\\I211125.csv',\n",
       " './csvs\\\\I211126.csv',\n",
       " './csvs\\\\I211129.csv',\n",
       " './csvs\\\\I211130.csv',\n",
       " './csvs\\\\I211201.csv',\n",
       " './csvs\\\\I211202.csv',\n",
       " './csvs\\\\I211203.csv',\n",
       " './csvs\\\\I211207.csv',\n",
       " './csvs\\\\I211208.csv',\n",
       " './csvs\\\\I211209.csv',\n",
       " './csvs\\\\I211210.csv',\n",
       " './csvs\\\\I211213.csv',\n",
       " './csvs\\\\I211215.csv',\n",
       " './csvs\\\\I211216.csv',\n",
       " './csvs\\\\I211220.csv',\n",
       " './csvs\\\\I211222.csv',\n",
       " './csvs\\\\I211223.csv']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path=\"./csvs\"\n",
    "filenames=find_the_way(path,\".csv\")\n",
    "filenames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "647ad3e0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "./csvs\\A211102.csv\n",
      "./csvs\\A211103.csv\n",
      "./csvs\\A211105.csv\n",
      "./csvs\\A211108.csv\n",
      "./csvs\\A211109.csv\n",
      "./csvs\\A211110.csv\n",
      "./csvs\\A211112.csv\n",
      "./csvs\\A211115.csv\n",
      "./csvs\\A211116.csv\n",
      "./csvs\\A211117.csv\n",
      "./csvs\\A211118.csv\n",
      "./csvs\\A211119.csv\n",
      "./csvs\\A211122.csv\n",
      "./csvs\\A211123.csv\n",
      "./csvs\\A211124.csv\n",
      "./csvs\\A211125.csv\n",
      "./csvs\\A211126.csv\n",
      "./csvs\\A211206.csv\n",
      "./csvs\\A211207.csv\n",
      "./csvs\\A211208.csv\n",
      "./csvs\\A211223.csv\n",
      "./csvs\\A211225.csv\n",
      "./csvs\\A211228.csv\n",
      "./csvs\\A220103.csv\n",
      "./csvs\\I211102.csv\n",
      "./csvs\\I211103.csv\n",
      "./csvs\\I211104.csv\n",
      "./csvs\\I211108.csv\n",
      "./csvs\\I211110.csv\n",
      "./csvs\\I211112.csv\n",
      "./csvs\\I211115.csv\n",
      "./csvs\\I211116.csv\n",
      "./csvs\\I211117.csv\n",
      "./csvs\\I211118.csv\n",
      "./csvs\\I211119.csv\n",
      "./csvs\\I211122.csv\n",
      "./csvs\\I211124.csv\n",
      "./csvs\\I211125.csv\n",
      "./csvs\\I211126.csv\n",
      "./csvs\\I211129.csv\n",
      "./csvs\\I211130.csv\n",
      "./csvs\\I211201.csv\n",
      "./csvs\\I211202.csv\n",
      "./csvs\\I211203.csv\n",
      "./csvs\\I211207.csv\n",
      "./csvs\\I211208.csv\n",
      "./csvs\\I211209.csv\n",
      "./csvs\\I211210.csv\n",
      "./csvs\\I211213.csv\n",
      "./csvs\\I211215.csv\n",
      "./csvs\\I211216.csv\n",
      "./csvs\\I211220.csv\n",
      "./csvs\\I211222.csv\n",
      "./csvs\\I211223.csv\n"
     ]
    }
   ],
   "source": [
    "devices=[]\n",
    "for name in filenames:\n",
    "    print(name)\n",
    "    df = pd.read_csv(name)\n",
    "    df[\"Label\"]=df[\"Label\"].replace(renamer)\n",
    "    df.to_csv(name,index=False)\n",
    "    for i in df[\"Label\"].unique():\n",
    "        if i not in devices:\n",
    "            devices.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "afc64819",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['./csvs\\\\A211102.csv',\n",
       " './csvs\\\\A211103.csv',\n",
       " './csvs\\\\A211105.csv',\n",
       " './csvs\\\\A211108.csv',\n",
       " './csvs\\\\A211109.csv',\n",
       " './csvs\\\\A211110.csv',\n",
       " './csvs\\\\A211112.csv',\n",
       " './csvs\\\\A211115.csv',\n",
       " './csvs\\\\A211116.csv',\n",
       " './csvs\\\\A211117.csv',\n",
       " './csvs\\\\A211118.csv',\n",
       " './csvs\\\\A211119.csv',\n",
       " './csvs\\\\A211122.csv',\n",
       " './csvs\\\\A211123.csv',\n",
       " './csvs\\\\A211124.csv',\n",
       " './csvs\\\\A211125.csv',\n",
       " './csvs\\\\A211126.csv',\n",
       " './csvs\\\\A211206.csv',\n",
       " './csvs\\\\A211207.csv',\n",
       " './csvs\\\\A211208.csv',\n",
       " './csvs\\\\A211223.csv',\n",
       " './csvs\\\\A211225.csv',\n",
       " './csvs\\\\A211228.csv',\n",
       " './csvs\\\\A220103.csv',\n",
       " './csvs\\\\I211102.csv',\n",
       " './csvs\\\\I211103.csv',\n",
       " './csvs\\\\I211104.csv',\n",
       " './csvs\\\\I211108.csv',\n",
       " './csvs\\\\I211110.csv',\n",
       " './csvs\\\\I211112.csv',\n",
       " './csvs\\\\I211115.csv',\n",
       " './csvs\\\\I211116.csv',\n",
       " './csvs\\\\I211117.csv',\n",
       " './csvs\\\\I211118.csv',\n",
       " './csvs\\\\I211119.csv',\n",
       " './csvs\\\\I211122.csv',\n",
       " './csvs\\\\I211124.csv',\n",
       " './csvs\\\\I211125.csv',\n",
       " './csvs\\\\I211126.csv',\n",
       " './csvs\\\\I211129.csv',\n",
       " './csvs\\\\I211130.csv',\n",
       " './csvs\\\\I211201.csv',\n",
       " './csvs\\\\I211202.csv',\n",
       " './csvs\\\\I211203.csv',\n",
       " './csvs\\\\I211207.csv',\n",
       " './csvs\\\\I211208.csv',\n",
       " './csvs\\\\I211209.csv',\n",
       " './csvs\\\\I211210.csv',\n",
       " './csvs\\\\I211213.csv',\n",
       " './csvs\\\\I211215.csv',\n",
       " './csvs\\\\I211216.csv',\n",
       " './csvs\\\\I211220.csv',\n",
       " './csvs\\\\I211222.csv',\n",
       " './csvs\\\\I211223.csv']"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path=\"./csvs\"\n",
    "filenames=find_the_way(path,\".csv\")\n",
    "filenames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "f6edffd5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['AMCREST WiFi Camera',\n",
       " 'Amazon Alexa Echo Dot',\n",
       " 'Amazon Alexa Echo Spot',\n",
       " 'Amazon Alexa Echo Studio',\n",
       " 'Amazon Plug',\n",
       " 'Arlo Base Station',\n",
       " 'Arlo Q Camera',\n",
       " 'Atomi Coffee Maker',\n",
       " 'Borun/Sichuan-AI Camera',\n",
       " 'D-Link Mini Camera',\n",
       " 'D-Link Water Sensor',\n",
       " 'Eufy HomeBase 2',\n",
       " 'Globe Lamp ESP_B1680C',\n",
       " 'Google Nest Mini',\n",
       " 'Gosund Plug',\n",
       " 'Gosund Socket',\n",
       " 'HeimVision Smart WiFi Camera',\n",
       " 'HeimVision SmartLife Radio/Lamp',\n",
       " 'Home Eye Camera',\n",
       " 'LG Smart TV',\n",
       " 'Luohe Cam Dog',\n",
       " 'Nest Indoor Camera',\n",
       " 'Netatmo Camera',\n",
       " 'Netatmo Weather Station',\n",
       " 'Philips Hue Bridge',\n",
       " 'Ring Base Station',\n",
       " 'SIMCAM 1S (AMPAKTec)',\n",
       " 'Smart Board',\n",
       " 'Sonos One Speaker',\n",
       " 'Teckin Plug',\n",
       " 'Yutron Plug',\n",
       " 'iRobot Roomba']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sorted(devices)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "a3ebc259",
   "metadata": {},
   "outputs": [],
   "source": [
    "\"\"\"devices=['AMCREST WiFi Camera',\n",
    " 'Amazon Alexa Echo Dot 1',\n",
    " 'Amazon Alexa Echo Dot 2',\n",
    " 'Amazon Alexa Echo Spot',\n",
    " 'Amazon Alexa Echo Studio',\n",
    " 'Amazon Plug',\n",
    " 'Arlo Base Station',\n",
    " 'Arlo Q Camera',\n",
    " 'Atomi Coffee Maker',\n",
    " 'Borun/Sichuan-AI Camera',\n",
    " 'D-Link DCHS-161 Water Sensor',\n",
    " 'DCS8000LHA1 D-Link Mini Camera',\n",
    " 'Eufy HomeBase 2',\n",
    " 'Globe Lamp ESP_B1680C',\n",
    " 'Google Nest Mini',\n",
    " 'Gosund ESP_032979 Plug',\n",
    " 'Gosund ESP_039AAF Socket',\n",
    " 'Gosund ESP_0C3994 Plug',\n",
    " 'Gosund ESP_10098F Socket',\n",
    " 'Gosund ESP_10ACD8 Plug',\n",
    " 'Gosund ESP_147FF9 Plug',\n",
    " 'Gosund ESP_1ACEE1  Socket',\n",
    " 'HeimVision Smart WiFi Camera',\n",
    " 'HeimVision SmartLife Radio/Lamp',\n",
    " 'Home Eye Camera',\n",
    " 'LG Smart TV',\n",
    " 'Luohe Cam Dog',\n",
    " 'Nest Indoor Camera',\n",
    " 'Netatmo Camera',\n",
    " 'Netatmo Weather Station',\n",
    " 'Philips Hue Bridge',\n",
    " 'Ring Base Station AC:1236',\n",
    " 'SIMCAM 1S (AMPAKTec)',\n",
    " 'Smart Board',\n",
    " 'Sonos One Speaker',\n",
    " 'Teckin Plug 1',\n",
    " 'Teckin Plug 2',\n",
    " 'Yutron Plug 1',\n",
    " 'Yutron Plug 2',\n",
    " 'iRobot Roomba']\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "91c12df6",
   "metadata": {},
   "outputs": [],
   "source": [
    "devices=['AMCREST WiFi Camera',\n",
    " 'Amazon Alexa Echo Dot',\n",
    " 'Amazon Alexa Echo Spot',\n",
    " 'Amazon Alexa Echo Studio',\n",
    " 'Amazon Plug',\n",
    " 'Arlo Base Station',\n",
    " 'Arlo Q Camera',\n",
    " 'Atomi Coffee Maker',\n",
    " 'Borun/Sichuan-AI Camera',\n",
    " 'D-Link Mini Camera',\n",
    " 'D-Link Water Sensor',\n",
    " 'Eufy HomeBase 2',\n",
    " 'Globe Lamp ESP_B1680C',\n",
    " 'Google Nest Mini',\n",
    " 'Gosund Plug',\n",
    " 'Gosund Socket',\n",
    " 'HeimVision Smart WiFi Camera',\n",
    " 'HeimVision SmartLife Radio/Lamp',\n",
    " 'Home Eye Camera',\n",
    " 'LG Smart TV',\n",
    " 'Luohe Cam Dog',\n",
    " 'Nest Indoor Camera',\n",
    " 'Netatmo Camera',\n",
    " 'Netatmo Weather Station',\n",
    " 'Philips Hue Bridge',\n",
    " 'Ring Base Station',\n",
    " 'SIMCAM 1S (AMPAKTec)',\n",
    " 'Smart Board',\n",
    " 'Sonos One Speaker',\n",
    " 'Teckin Plug',\n",
    " 'Yutron Plug',\n",
    " 'iRobot Roomba']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "02f28fde",
   "metadata": {},
   "source": [
    "#### a CSV file containing the number of packets per device for the sessions is created"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "7c0924c7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "./csvs\\A211102.csv\n",
      "./csvs\\A211103.csv\n",
      "./csvs\\A211105.csv\n",
      "./csvs\\A211108.csv\n",
      "./csvs\\A211109.csv\n",
      "./csvs\\A211110.csv\n",
      "./csvs\\A211112.csv\n",
      "./csvs\\A211115.csv\n",
      "./csvs\\A211116.csv\n",
      "./csvs\\A211117.csv\n",
      "./csvs\\A211118.csv\n",
      "./csvs\\A211119.csv\n",
      "./csvs\\A211122.csv\n",
      "./csvs\\A211123.csv\n",
      "./csvs\\A211124.csv\n",
      "./csvs\\A211125.csv\n",
      "./csvs\\A211126.csv\n",
      "./csvs\\A211206.csv\n",
      "./csvs\\A211207.csv\n",
      "./csvs\\A211208.csv\n",
      "./csvs\\A211223.csv\n",
      "./csvs\\A211225.csv\n",
      "./csvs\\A211228.csv\n",
      "./csvs\\A220103.csv\n",
      "./csvs\\I211102.csv\n",
      "./csvs\\I211103.csv\n",
      "./csvs\\I211104.csv\n",
      "./csvs\\I211108.csv\n",
      "./csvs\\I211110.csv\n",
      "./csvs\\I211112.csv\n",
      "./csvs\\I211115.csv\n",
      "./csvs\\I211116.csv\n",
      "./csvs\\I211117.csv\n",
      "./csvs\\I211118.csv\n",
      "./csvs\\I211119.csv\n",
      "./csvs\\I211122.csv\n",
      "./csvs\\I211124.csv\n",
      "./csvs\\I211125.csv\n",
      "./csvs\\I211126.csv\n",
      "./csvs\\I211129.csv\n",
      "./csvs\\I211130.csv\n",
      "./csvs\\I211201.csv\n",
      "./csvs\\I211202.csv\n",
      "./csvs\\I211203.csv\n",
      "./csvs\\I211207.csv\n",
      "./csvs\\I211208.csv\n",
      "./csvs\\I211209.csv\n",
      "./csvs\\I211210.csv\n",
      "./csvs\\I211213.csv\n",
      "./csvs\\I211215.csv\n",
      "./csvs\\I211216.csv\n",
      "./csvs\\I211220.csv\n",
      "./csvs\\I211222.csv\n",
      "./csvs\\I211223.csv\n"
     ]
    }
   ],
   "source": [
    "lines=[[\"File\",\"Date\",\"Type\",'AMCREST WiFi Camera',\n",
    " 'Amazon Alexa Echo Dot',\n",
    " 'Amazon Alexa Echo Spot',\n",
    " 'Amazon Alexa Echo Studio',\n",
    " 'Amazon Plug',\n",
    " 'Arlo Base Station',\n",
    " 'Arlo Q Camera',\n",
    " 'Atomi Coffee Maker',\n",
    " 'Borun/Sichuan-AI Camera',\n",
    " 'D-Link Mini Camera',\n",
    " 'D-Link Water Sensor',\n",
    " 'Eufy HomeBase 2',\n",
    " 'Globe Lamp ESP_B1680C',\n",
    " 'Google Nest Mini',\n",
    " 'Gosund Plug',\n",
    " 'Gosund Socket',\n",
    " 'HeimVision Smart WiFi Camera',\n",
    " 'HeimVision SmartLife Radio/Lamp',\n",
    " 'Home Eye Camera',\n",
    " 'LG Smart TV',\n",
    " 'Luohe Cam Dog',\n",
    " 'Nest Indoor Camera',\n",
    " 'Netatmo Camera',\n",
    " 'Netatmo Weather Station',\n",
    " 'Philips Hue Bridge',\n",
    " 'Ring Base Station',\n",
    " 'SIMCAM 1S (AMPAKTec)',\n",
    " 'Smart Board',\n",
    " 'Sonos One Speaker',\n",
    " 'Teckin Plug',\n",
    " 'Yutron Plug',\n",
    " 'iRobot Roomba']]\n",
    "\n",
    "for i in filenames:\n",
    "    print(i)\n",
    "    df=pd.read_csv(i)\n",
    "    dist=dict(df.groupby(\"Label\").size())\n",
    "    \n",
    "    for d in devices:\n",
    "        if d not in dist:\n",
    "            dist[d]=0\n",
    "    dist=dict(sorted(dist.items()))\n",
    "    temp=i\n",
    "    if \"I\" in temp:\n",
    "        file_type=\"IDLE\"\n",
    "    else:file_type=\"ACTIVE\"\n",
    "    line=[i,\"20\"+temp[8:-4],file_type]\n",
    "    line+=dist.values()\n",
    "    lines.append(line)\n",
    "results = pd.DataFrame (lines[1:], columns = lines[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "b10c3d30",
   "metadata": {},
   "outputs": [],
   "source": [
    "results = pd.DataFrame (lines[1:], columns = lines[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "7da10b16",
   "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>File</th>\n",
       "      <th>Date</th>\n",
       "      <th>Type</th>\n",
       "      <th>AMCREST WiFi Camera</th>\n",
       "      <th>Amazon Alexa Echo Dot</th>\n",
       "      <th>Amazon Alexa Echo Spot</th>\n",
       "      <th>Amazon Alexa Echo Studio</th>\n",
       "      <th>Amazon Plug</th>\n",
       "      <th>Arlo Base Station</th>\n",
       "      <th>Arlo Q Camera</th>\n",
       "      <th>...</th>\n",
       "      <th>Netatmo Camera</th>\n",
       "      <th>Netatmo Weather Station</th>\n",
       "      <th>Philips Hue Bridge</th>\n",
       "      <th>Ring Base Station</th>\n",
       "      <th>SIMCAM 1S (AMPAKTec)</th>\n",
       "      <th>Smart Board</th>\n",
       "      <th>Sonos One Speaker</th>\n",
       "      <th>Teckin Plug</th>\n",
       "      <th>Yutron Plug</th>\n",
       "      <th>iRobot Roomba</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>./csvs\\A211102.csv</td>\n",
       "      <td>20211102</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>6683</td>\n",
       "      <td>13747</td>\n",
       "      <td>14944</td>\n",
       "      <td>13204</td>\n",
       "      <td>1470</td>\n",
       "      <td>12628</td>\n",
       "      <td>21077</td>\n",
       "      <td>...</td>\n",
       "      <td>9591</td>\n",
       "      <td>1811</td>\n",
       "      <td>12501</td>\n",
       "      <td>3368</td>\n",
       "      <td>21448</td>\n",
       "      <td>404</td>\n",
       "      <td>5180</td>\n",
       "      <td>13014</td>\n",
       "      <td>13031</td>\n",
       "      <td>1123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>./csvs\\A211103.csv</td>\n",
       "      <td>20211103</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5535</td>\n",
       "      <td>14076</td>\n",
       "      <td>15193</td>\n",
       "      <td>13163</td>\n",
       "      <td>1475</td>\n",
       "      <td>4928</td>\n",
       "      <td>18809</td>\n",
       "      <td>...</td>\n",
       "      <td>12208</td>\n",
       "      <td>1874</td>\n",
       "      <td>12671</td>\n",
       "      <td>3259</td>\n",
       "      <td>21083</td>\n",
       "      <td>545</td>\n",
       "      <td>8708</td>\n",
       "      <td>12911</td>\n",
       "      <td>13187</td>\n",
       "      <td>1207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>./csvs\\A211105.csv</td>\n",
       "      <td>20211105</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5515</td>\n",
       "      <td>13932</td>\n",
       "      <td>13720</td>\n",
       "      <td>13122</td>\n",
       "      <td>1476</td>\n",
       "      <td>4948</td>\n",
       "      <td>21539</td>\n",
       "      <td>...</td>\n",
       "      <td>26146</td>\n",
       "      <td>1700</td>\n",
       "      <td>14034</td>\n",
       "      <td>3208</td>\n",
       "      <td>20914</td>\n",
       "      <td>380</td>\n",
       "      <td>4970</td>\n",
       "      <td>13065</td>\n",
       "      <td>12695</td>\n",
       "      <td>1052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>./csvs\\A211108.csv</td>\n",
       "      <td>20211108</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5627</td>\n",
       "      <td>21651</td>\n",
       "      <td>14993</td>\n",
       "      <td>13060</td>\n",
       "      <td>1470</td>\n",
       "      <td>45081</td>\n",
       "      <td>78958</td>\n",
       "      <td>...</td>\n",
       "      <td>10191</td>\n",
       "      <td>1819</td>\n",
       "      <td>13805</td>\n",
       "      <td>3468</td>\n",
       "      <td>21956</td>\n",
       "      <td>432</td>\n",
       "      <td>4970</td>\n",
       "      <td>12657</td>\n",
       "      <td>12727</td>\n",
       "      <td>1055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>./csvs\\A211109.csv</td>\n",
       "      <td>20211109</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>6092</td>\n",
       "      <td>22381</td>\n",
       "      <td>14718</td>\n",
       "      <td>13174</td>\n",
       "      <td>1472</td>\n",
       "      <td>45974</td>\n",
       "      <td>47257</td>\n",
       "      <td>...</td>\n",
       "      <td>9168</td>\n",
       "      <td>1769</td>\n",
       "      <td>12466</td>\n",
       "      <td>3344</td>\n",
       "      <td>21652</td>\n",
       "      <td>436</td>\n",
       "      <td>4994</td>\n",
       "      <td>12708</td>\n",
       "      <td>12712</td>\n",
       "      <td>1046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>./csvs\\A211110.csv</td>\n",
       "      <td>20211110</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>6743</td>\n",
       "      <td>92566</td>\n",
       "      <td>19876</td>\n",
       "      <td>14951</td>\n",
       "      <td>2393</td>\n",
       "      <td>22247</td>\n",
       "      <td>37377</td>\n",
       "      <td>...</td>\n",
       "      <td>9004</td>\n",
       "      <td>1816</td>\n",
       "      <td>13790</td>\n",
       "      <td>3270</td>\n",
       "      <td>21153</td>\n",
       "      <td>6150</td>\n",
       "      <td>6866</td>\n",
       "      <td>12205</td>\n",
       "      <td>12946</td>\n",
       "      <td>1156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>./csvs\\A211112.csv</td>\n",
       "      <td>20211112</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5653</td>\n",
       "      <td>54894</td>\n",
       "      <td>15696</td>\n",
       "      <td>19457</td>\n",
       "      <td>1472</td>\n",
       "      <td>4890</td>\n",
       "      <td>37475</td>\n",
       "      <td>...</td>\n",
       "      <td>10530</td>\n",
       "      <td>1908</td>\n",
       "      <td>15194</td>\n",
       "      <td>3279</td>\n",
       "      <td>21477</td>\n",
       "      <td>8361</td>\n",
       "      <td>6977</td>\n",
       "      <td>12506</td>\n",
       "      <td>12950</td>\n",
       "      <td>1194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>./csvs\\A211115.csv</td>\n",
       "      <td>20211115</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5658</td>\n",
       "      <td>23969</td>\n",
       "      <td>14932</td>\n",
       "      <td>14209</td>\n",
       "      <td>1824</td>\n",
       "      <td>110057</td>\n",
       "      <td>55184</td>\n",
       "      <td>...</td>\n",
       "      <td>9433</td>\n",
       "      <td>1833</td>\n",
       "      <td>17496</td>\n",
       "      <td>3848</td>\n",
       "      <td>21474</td>\n",
       "      <td>3035</td>\n",
       "      <td>4254</td>\n",
       "      <td>12635</td>\n",
       "      <td>13166</td>\n",
       "      <td>1213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>./csvs\\A211116.csv</td>\n",
       "      <td>20211116</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5425</td>\n",
       "      <td>22291</td>\n",
       "      <td>13676</td>\n",
       "      <td>13817</td>\n",
       "      <td>1473</td>\n",
       "      <td>11093</td>\n",
       "      <td>98636</td>\n",
       "      <td>...</td>\n",
       "      <td>14129</td>\n",
       "      <td>1899</td>\n",
       "      <td>15715</td>\n",
       "      <td>3321</td>\n",
       "      <td>22033</td>\n",
       "      <td>8060</td>\n",
       "      <td>3843</td>\n",
       "      <td>12112</td>\n",
       "      <td>12510</td>\n",
       "      <td>1171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>./csvs\\A211117.csv</td>\n",
       "      <td>20211117</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5362</td>\n",
       "      <td>46049</td>\n",
       "      <td>15327</td>\n",
       "      <td>58610</td>\n",
       "      <td>1468</td>\n",
       "      <td>4884</td>\n",
       "      <td>44920</td>\n",
       "      <td>...</td>\n",
       "      <td>9539</td>\n",
       "      <td>1912</td>\n",
       "      <td>13698</td>\n",
       "      <td>3253</td>\n",
       "      <td>21233</td>\n",
       "      <td>3993</td>\n",
       "      <td>4843</td>\n",
       "      <td>12163</td>\n",
       "      <td>12487</td>\n",
       "      <td>1096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>./csvs\\A211118.csv</td>\n",
       "      <td>20211118</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5973</td>\n",
       "      <td>23125</td>\n",
       "      <td>13330</td>\n",
       "      <td>14210</td>\n",
       "      <td>1467</td>\n",
       "      <td>4810</td>\n",
       "      <td>4973</td>\n",
       "      <td>...</td>\n",
       "      <td>4308</td>\n",
       "      <td>1883</td>\n",
       "      <td>12864</td>\n",
       "      <td>3203</td>\n",
       "      <td>21005</td>\n",
       "      <td>3634</td>\n",
       "      <td>3887</td>\n",
       "      <td>12474</td>\n",
       "      <td>12660</td>\n",
       "      <td>1341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>./csvs\\A211119.csv</td>\n",
       "      <td>20211119</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5542</td>\n",
       "      <td>22973</td>\n",
       "      <td>13412</td>\n",
       "      <td>14217</td>\n",
       "      <td>1474</td>\n",
       "      <td>4909</td>\n",
       "      <td>3641</td>\n",
       "      <td>...</td>\n",
       "      <td>4096</td>\n",
       "      <td>1850</td>\n",
       "      <td>12697</td>\n",
       "      <td>3212</td>\n",
       "      <td>20924</td>\n",
       "      <td>1373</td>\n",
       "      <td>3821</td>\n",
       "      <td>12130</td>\n",
       "      <td>12458</td>\n",
       "      <td>1117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>./csvs\\A211122.csv</td>\n",
       "      <td>20211122</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5618</td>\n",
       "      <td>18890</td>\n",
       "      <td>14911</td>\n",
       "      <td>13487</td>\n",
       "      <td>1465</td>\n",
       "      <td>15095</td>\n",
       "      <td>58717</td>\n",
       "      <td>...</td>\n",
       "      <td>9487</td>\n",
       "      <td>1817</td>\n",
       "      <td>13544</td>\n",
       "      <td>3321</td>\n",
       "      <td>21263</td>\n",
       "      <td>3822</td>\n",
       "      <td>3871</td>\n",
       "      <td>12182</td>\n",
       "      <td>12774</td>\n",
       "      <td>1116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>./csvs\\A211123.csv</td>\n",
       "      <td>20211123</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>6284</td>\n",
       "      <td>21989</td>\n",
       "      <td>15335</td>\n",
       "      <td>13581</td>\n",
       "      <td>1409</td>\n",
       "      <td>7823</td>\n",
       "      <td>58498</td>\n",
       "      <td>...</td>\n",
       "      <td>11608</td>\n",
       "      <td>1853</td>\n",
       "      <td>12966</td>\n",
       "      <td>3326</td>\n",
       "      <td>28149</td>\n",
       "      <td>5242</td>\n",
       "      <td>3930</td>\n",
       "      <td>12428</td>\n",
       "      <td>13161</td>\n",
       "      <td>1061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>./csvs\\A211124.csv</td>\n",
       "      <td>20211124</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5738</td>\n",
       "      <td>21495</td>\n",
       "      <td>14607</td>\n",
       "      <td>13344</td>\n",
       "      <td>1468</td>\n",
       "      <td>4898</td>\n",
       "      <td>17536</td>\n",
       "      <td>...</td>\n",
       "      <td>6471</td>\n",
       "      <td>1855</td>\n",
       "      <td>12565</td>\n",
       "      <td>3288</td>\n",
       "      <td>27765</td>\n",
       "      <td>4743</td>\n",
       "      <td>4114</td>\n",
       "      <td>12328</td>\n",
       "      <td>12800</td>\n",
       "      <td>1034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>./csvs\\A211125.csv</td>\n",
       "      <td>20211125</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5758</td>\n",
       "      <td>21617</td>\n",
       "      <td>15995</td>\n",
       "      <td>14077</td>\n",
       "      <td>1546</td>\n",
       "      <td>5147</td>\n",
       "      <td>34633</td>\n",
       "      <td>...</td>\n",
       "      <td>5754</td>\n",
       "      <td>1902</td>\n",
       "      <td>14362</td>\n",
       "      <td>3297</td>\n",
       "      <td>21163</td>\n",
       "      <td>6040</td>\n",
       "      <td>5745</td>\n",
       "      <td>12276</td>\n",
       "      <td>12600</td>\n",
       "      <td>1175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>./csvs\\A211126.csv</td>\n",
       "      <td>20211126</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>7741</td>\n",
       "      <td>31070</td>\n",
       "      <td>20224</td>\n",
       "      <td>17214</td>\n",
       "      <td>517</td>\n",
       "      <td>326314</td>\n",
       "      <td>148989</td>\n",
       "      <td>...</td>\n",
       "      <td>19261</td>\n",
       "      <td>2466</td>\n",
       "      <td>17647</td>\n",
       "      <td>5690</td>\n",
       "      <td>29406</td>\n",
       "      <td>211966</td>\n",
       "      <td>6207</td>\n",
       "      <td>16894</td>\n",
       "      <td>17023</td>\n",
       "      <td>1556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>./csvs\\A211206.csv</td>\n",
       "      <td>20211206</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>6498</td>\n",
       "      <td>21745</td>\n",
       "      <td>15585</td>\n",
       "      <td>15761</td>\n",
       "      <td>1562</td>\n",
       "      <td>24180</td>\n",
       "      <td>33805</td>\n",
       "      <td>...</td>\n",
       "      <td>11826</td>\n",
       "      <td>1771</td>\n",
       "      <td>12827</td>\n",
       "      <td>3412</td>\n",
       "      <td>21783</td>\n",
       "      <td>767</td>\n",
       "      <td>4656</td>\n",
       "      <td>12395</td>\n",
       "      <td>13108</td>\n",
       "      <td>1201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>./csvs\\A211207.csv</td>\n",
       "      <td>20211207</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5660</td>\n",
       "      <td>21525</td>\n",
       "      <td>15568</td>\n",
       "      <td>14439</td>\n",
       "      <td>1520</td>\n",
       "      <td>438038</td>\n",
       "      <td>41608</td>\n",
       "      <td>...</td>\n",
       "      <td>9888</td>\n",
       "      <td>1819</td>\n",
       "      <td>14184</td>\n",
       "      <td>3809</td>\n",
       "      <td>21622</td>\n",
       "      <td>426</td>\n",
       "      <td>11616</td>\n",
       "      <td>12982</td>\n",
       "      <td>13454</td>\n",
       "      <td>1053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>./csvs\\A211208.csv</td>\n",
       "      <td>20211208</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>6162</td>\n",
       "      <td>21247</td>\n",
       "      <td>15343</td>\n",
       "      <td>13631</td>\n",
       "      <td>1516</td>\n",
       "      <td>13704</td>\n",
       "      <td>29369</td>\n",
       "      <td>...</td>\n",
       "      <td>9708</td>\n",
       "      <td>1786</td>\n",
       "      <td>12854</td>\n",
       "      <td>3460</td>\n",
       "      <td>21972</td>\n",
       "      <td>512</td>\n",
       "      <td>3894</td>\n",
       "      <td>12709</td>\n",
       "      <td>13128</td>\n",
       "      <td>1064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>./csvs\\A211223.csv</td>\n",
       "      <td>20211223</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>6259</td>\n",
       "      <td>23214</td>\n",
       "      <td>13326</td>\n",
       "      <td>13331</td>\n",
       "      <td>1463</td>\n",
       "      <td>4934</td>\n",
       "      <td>3790</td>\n",
       "      <td>...</td>\n",
       "      <td>3782</td>\n",
       "      <td>1774</td>\n",
       "      <td>12813</td>\n",
       "      <td>3168</td>\n",
       "      <td>20892</td>\n",
       "      <td>742</td>\n",
       "      <td>4984</td>\n",
       "      <td>13483</td>\n",
       "      <td>13200</td>\n",
       "      <td>1204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>./csvs\\A211225.csv</td>\n",
       "      <td>20211225</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5676</td>\n",
       "      <td>27882</td>\n",
       "      <td>14884</td>\n",
       "      <td>14387</td>\n",
       "      <td>1458</td>\n",
       "      <td>13160</td>\n",
       "      <td>23086</td>\n",
       "      <td>...</td>\n",
       "      <td>7097</td>\n",
       "      <td>1881</td>\n",
       "      <td>12945</td>\n",
       "      <td>3200</td>\n",
       "      <td>21150</td>\n",
       "      <td>2707</td>\n",
       "      <td>11822</td>\n",
       "      <td>13477</td>\n",
       "      <td>13103</td>\n",
       "      <td>1036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>./csvs\\A211228.csv</td>\n",
       "      <td>20211228</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5451</td>\n",
       "      <td>23492</td>\n",
       "      <td>20393</td>\n",
       "      <td>15065</td>\n",
       "      <td>1459</td>\n",
       "      <td>8510</td>\n",
       "      <td>23499</td>\n",
       "      <td>...</td>\n",
       "      <td>5673</td>\n",
       "      <td>1811</td>\n",
       "      <td>7076</td>\n",
       "      <td>3233</td>\n",
       "      <td>21188</td>\n",
       "      <td>613</td>\n",
       "      <td>44113</td>\n",
       "      <td>13466</td>\n",
       "      <td>12810</td>\n",
       "      <td>1104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>./csvs\\A220103.csv</td>\n",
       "      <td>20220103</td>\n",
       "      <td>ACTIVE</td>\n",
       "      <td>5590</td>\n",
       "      <td>21072</td>\n",
       "      <td>14450</td>\n",
       "      <td>13353</td>\n",
       "      <td>1495</td>\n",
       "      <td>4908</td>\n",
       "      <td>2745</td>\n",
       "      <td>...</td>\n",
       "      <td>3739</td>\n",
       "      <td>1681</td>\n",
       "      <td>7073</td>\n",
       "      <td>3164</td>\n",
       "      <td>20913</td>\n",
       "      <td>484</td>\n",
       "      <td>4917</td>\n",
       "      <td>13045</td>\n",
       "      <td>13214</td>\n",
       "      <td>1386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>./csvs\\I211102.csv</td>\n",
       "      <td>20211102</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7921</td>\n",
       "      <td>17840</td>\n",
       "      <td>19264</td>\n",
       "      <td>121468</td>\n",
       "      <td>2001</td>\n",
       "      <td>6852</td>\n",
       "      <td>3822</td>\n",
       "      <td>...</td>\n",
       "      <td>7353</td>\n",
       "      <td>2471</td>\n",
       "      <td>17046</td>\n",
       "      <td>4791</td>\n",
       "      <td>28622</td>\n",
       "      <td>352</td>\n",
       "      <td>6890</td>\n",
       "      <td>17781</td>\n",
       "      <td>17895</td>\n",
       "      <td>1432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>./csvs\\I211103.csv</td>\n",
       "      <td>20211103</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7847</td>\n",
       "      <td>18196</td>\n",
       "      <td>18779</td>\n",
       "      <td>19424</td>\n",
       "      <td>2045</td>\n",
       "      <td>6825</td>\n",
       "      <td>3824</td>\n",
       "      <td>...</td>\n",
       "      <td>7269</td>\n",
       "      <td>2461</td>\n",
       "      <td>16927</td>\n",
       "      <td>4699</td>\n",
       "      <td>28635</td>\n",
       "      <td>199</td>\n",
       "      <td>6815</td>\n",
       "      <td>17775</td>\n",
       "      <td>18019</td>\n",
       "      <td>1423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>./csvs\\I211104.csv</td>\n",
       "      <td>20211104</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8600</td>\n",
       "      <td>18685</td>\n",
       "      <td>18896</td>\n",
       "      <td>19414</td>\n",
       "      <td>2094</td>\n",
       "      <td>6888</td>\n",
       "      <td>3936</td>\n",
       "      <td>...</td>\n",
       "      <td>7691</td>\n",
       "      <td>2529</td>\n",
       "      <td>16884</td>\n",
       "      <td>4734</td>\n",
       "      <td>28600</td>\n",
       "      <td>235</td>\n",
       "      <td>6898</td>\n",
       "      <td>17756</td>\n",
       "      <td>17443</td>\n",
       "      <td>1509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>./csvs\\I211108.csv</td>\n",
       "      <td>20211108</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7969</td>\n",
       "      <td>31033</td>\n",
       "      <td>17532</td>\n",
       "      <td>19504</td>\n",
       "      <td>2048</td>\n",
       "      <td>6808</td>\n",
       "      <td>3806</td>\n",
       "      <td>...</td>\n",
       "      <td>5117</td>\n",
       "      <td>2506</td>\n",
       "      <td>16888</td>\n",
       "      <td>4690</td>\n",
       "      <td>28635</td>\n",
       "      <td>52</td>\n",
       "      <td>6818</td>\n",
       "      <td>17464</td>\n",
       "      <td>17491</td>\n",
       "      <td>1516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>./csvs\\I211110.csv</td>\n",
       "      <td>20211110</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8426</td>\n",
       "      <td>30654</td>\n",
       "      <td>19415</td>\n",
       "      <td>17879</td>\n",
       "      <td>1982</td>\n",
       "      <td>6842</td>\n",
       "      <td>51550</td>\n",
       "      <td>...</td>\n",
       "      <td>5170</td>\n",
       "      <td>2512</td>\n",
       "      <td>17111</td>\n",
       "      <td>4677</td>\n",
       "      <td>28631</td>\n",
       "      <td>3873</td>\n",
       "      <td>6856</td>\n",
       "      <td>16697</td>\n",
       "      <td>18049</td>\n",
       "      <td>1432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>./csvs\\I211112.csv</td>\n",
       "      <td>20211112</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8527</td>\n",
       "      <td>29991</td>\n",
       "      <td>17218</td>\n",
       "      <td>17353</td>\n",
       "      <td>1999</td>\n",
       "      <td>6800</td>\n",
       "      <td>47365</td>\n",
       "      <td>...</td>\n",
       "      <td>5115</td>\n",
       "      <td>2548</td>\n",
       "      <td>24878</td>\n",
       "      <td>4723</td>\n",
       "      <td>28638</td>\n",
       "      <td>3295</td>\n",
       "      <td>6930</td>\n",
       "      <td>16809</td>\n",
       "      <td>17726</td>\n",
       "      <td>1427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>./csvs\\I211115.csv</td>\n",
       "      <td>20211115</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7437</td>\n",
       "      <td>32238</td>\n",
       "      <td>17821</td>\n",
       "      <td>18010</td>\n",
       "      <td>1991</td>\n",
       "      <td>10246</td>\n",
       "      <td>3954</td>\n",
       "      <td>...</td>\n",
       "      <td>5108</td>\n",
       "      <td>2580</td>\n",
       "      <td>24867</td>\n",
       "      <td>4647</td>\n",
       "      <td>28633</td>\n",
       "      <td>1408</td>\n",
       "      <td>5314</td>\n",
       "      <td>16859</td>\n",
       "      <td>17549</td>\n",
       "      <td>1426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>./csvs\\I211116.csv</td>\n",
       "      <td>20211116</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7501</td>\n",
       "      <td>32128</td>\n",
       "      <td>17922</td>\n",
       "      <td>18089</td>\n",
       "      <td>1994</td>\n",
       "      <td>6808</td>\n",
       "      <td>3837</td>\n",
       "      <td>...</td>\n",
       "      <td>5200</td>\n",
       "      <td>2469</td>\n",
       "      <td>17212</td>\n",
       "      <td>4691</td>\n",
       "      <td>28641</td>\n",
       "      <td>0</td>\n",
       "      <td>5327</td>\n",
       "      <td>16717</td>\n",
       "      <td>17265</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>./csvs\\I211117.csv</td>\n",
       "      <td>20211117</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7559</td>\n",
       "      <td>32614</td>\n",
       "      <td>17936</td>\n",
       "      <td>18517</td>\n",
       "      <td>2007</td>\n",
       "      <td>6861</td>\n",
       "      <td>3839</td>\n",
       "      <td>...</td>\n",
       "      <td>5256</td>\n",
       "      <td>2588</td>\n",
       "      <td>17199</td>\n",
       "      <td>4752</td>\n",
       "      <td>28652</td>\n",
       "      <td>0</td>\n",
       "      <td>21857</td>\n",
       "      <td>16650</td>\n",
       "      <td>17373</td>\n",
       "      <td>1505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>./csvs\\I211118.csv</td>\n",
       "      <td>20211118</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7558</td>\n",
       "      <td>32831</td>\n",
       "      <td>17997</td>\n",
       "      <td>18492</td>\n",
       "      <td>2004</td>\n",
       "      <td>6778</td>\n",
       "      <td>3800</td>\n",
       "      <td>...</td>\n",
       "      <td>5163</td>\n",
       "      <td>2626</td>\n",
       "      <td>17173</td>\n",
       "      <td>4718</td>\n",
       "      <td>28641</td>\n",
       "      <td>3375</td>\n",
       "      <td>5358</td>\n",
       "      <td>16696</td>\n",
       "      <td>17303</td>\n",
       "      <td>1476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>./csvs\\I211119.csv</td>\n",
       "      <td>20211119</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8253</td>\n",
       "      <td>33060</td>\n",
       "      <td>18137</td>\n",
       "      <td>18413</td>\n",
       "      <td>2002</td>\n",
       "      <td>6903</td>\n",
       "      <td>5308</td>\n",
       "      <td>...</td>\n",
       "      <td>5213</td>\n",
       "      <td>2501</td>\n",
       "      <td>17281</td>\n",
       "      <td>4707</td>\n",
       "      <td>28637</td>\n",
       "      <td>1293</td>\n",
       "      <td>5415</td>\n",
       "      <td>16675</td>\n",
       "      <td>17228</td>\n",
       "      <td>1423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>./csvs\\I211122.csv</td>\n",
       "      <td>20211122</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7679</td>\n",
       "      <td>27506</td>\n",
       "      <td>20862</td>\n",
       "      <td>17409</td>\n",
       "      <td>2047</td>\n",
       "      <td>6808</td>\n",
       "      <td>3800</td>\n",
       "      <td>...</td>\n",
       "      <td>5045</td>\n",
       "      <td>2556</td>\n",
       "      <td>17250</td>\n",
       "      <td>4695</td>\n",
       "      <td>28633</td>\n",
       "      <td>1342</td>\n",
       "      <td>5317</td>\n",
       "      <td>16737</td>\n",
       "      <td>17711</td>\n",
       "      <td>1462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>./csvs\\I211124.csv</td>\n",
       "      <td>20211124</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7751</td>\n",
       "      <td>29729</td>\n",
       "      <td>18744</td>\n",
       "      <td>17164</td>\n",
       "      <td>2006</td>\n",
       "      <td>6830</td>\n",
       "      <td>4337</td>\n",
       "      <td>...</td>\n",
       "      <td>5135</td>\n",
       "      <td>2483</td>\n",
       "      <td>17176</td>\n",
       "      <td>4651</td>\n",
       "      <td>37528</td>\n",
       "      <td>4549</td>\n",
       "      <td>5377</td>\n",
       "      <td>16819</td>\n",
       "      <td>17355</td>\n",
       "      <td>1433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>./csvs\\I211125.csv</td>\n",
       "      <td>20211125</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7950</td>\n",
       "      <td>30262</td>\n",
       "      <td>18762</td>\n",
       "      <td>17594</td>\n",
       "      <td>2043</td>\n",
       "      <td>6824</td>\n",
       "      <td>3810</td>\n",
       "      <td>...</td>\n",
       "      <td>5069</td>\n",
       "      <td>2553</td>\n",
       "      <td>17183</td>\n",
       "      <td>4676</td>\n",
       "      <td>28638</td>\n",
       "      <td>481</td>\n",
       "      <td>5366</td>\n",
       "      <td>16724</td>\n",
       "      <td>16989</td>\n",
       "      <td>1429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>./csvs\\I211126.csv</td>\n",
       "      <td>20211126</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8949</td>\n",
       "      <td>31951</td>\n",
       "      <td>21803</td>\n",
       "      <td>19960</td>\n",
       "      <td>0</td>\n",
       "      <td>6852</td>\n",
       "      <td>4377</td>\n",
       "      <td>...</td>\n",
       "      <td>4999</td>\n",
       "      <td>2497</td>\n",
       "      <td>17212</td>\n",
       "      <td>4686</td>\n",
       "      <td>28619</td>\n",
       "      <td>4772</td>\n",
       "      <td>5378</td>\n",
       "      <td>16971</td>\n",
       "      <td>17253</td>\n",
       "      <td>1422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>./csvs\\I211129.csv</td>\n",
       "      <td>20211129</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8489</td>\n",
       "      <td>29687</td>\n",
       "      <td>19230</td>\n",
       "      <td>19328</td>\n",
       "      <td>1965</td>\n",
       "      <td>7036</td>\n",
       "      <td>3969</td>\n",
       "      <td>...</td>\n",
       "      <td>5021</td>\n",
       "      <td>2590</td>\n",
       "      <td>17309</td>\n",
       "      <td>0</td>\n",
       "      <td>28729</td>\n",
       "      <td>389</td>\n",
       "      <td>5398</td>\n",
       "      <td>17129</td>\n",
       "      <td>18046</td>\n",
       "      <td>1484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>./csvs\\I211130.csv</td>\n",
       "      <td>20211130</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7794</td>\n",
       "      <td>30063</td>\n",
       "      <td>19175</td>\n",
       "      <td>17506</td>\n",
       "      <td>2003</td>\n",
       "      <td>10012</td>\n",
       "      <td>3803</td>\n",
       "      <td>...</td>\n",
       "      <td>5079</td>\n",
       "      <td>2457</td>\n",
       "      <td>17267</td>\n",
       "      <td>4703</td>\n",
       "      <td>28615</td>\n",
       "      <td>376</td>\n",
       "      <td>5335</td>\n",
       "      <td>17166</td>\n",
       "      <td>16802</td>\n",
       "      <td>1424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>./csvs\\I211201.csv</td>\n",
       "      <td>20211201</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8900</td>\n",
       "      <td>30087</td>\n",
       "      <td>18899</td>\n",
       "      <td>17483</td>\n",
       "      <td>2011</td>\n",
       "      <td>6845</td>\n",
       "      <td>3798</td>\n",
       "      <td>...</td>\n",
       "      <td>5194</td>\n",
       "      <td>2556</td>\n",
       "      <td>17262</td>\n",
       "      <td>4710</td>\n",
       "      <td>28625</td>\n",
       "      <td>436</td>\n",
       "      <td>5369</td>\n",
       "      <td>17158</td>\n",
       "      <td>16972</td>\n",
       "      <td>1425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>./csvs\\I211202.csv</td>\n",
       "      <td>20211202</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7772</td>\n",
       "      <td>28860</td>\n",
       "      <td>19083</td>\n",
       "      <td>17488</td>\n",
       "      <td>1966</td>\n",
       "      <td>6904</td>\n",
       "      <td>3802</td>\n",
       "      <td>...</td>\n",
       "      <td>5149</td>\n",
       "      <td>2521</td>\n",
       "      <td>17248</td>\n",
       "      <td>4677</td>\n",
       "      <td>28601</td>\n",
       "      <td>504</td>\n",
       "      <td>5338</td>\n",
       "      <td>17061</td>\n",
       "      <td>17567</td>\n",
       "      <td>1425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>./csvs\\I211203.csv</td>\n",
       "      <td>20211203</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8438</td>\n",
       "      <td>29646</td>\n",
       "      <td>18240</td>\n",
       "      <td>17324</td>\n",
       "      <td>1993</td>\n",
       "      <td>6859</td>\n",
       "      <td>3821</td>\n",
       "      <td>...</td>\n",
       "      <td>5137</td>\n",
       "      <td>2470</td>\n",
       "      <td>17698</td>\n",
       "      <td>4669</td>\n",
       "      <td>28630</td>\n",
       "      <td>14913</td>\n",
       "      <td>5195</td>\n",
       "      <td>17042</td>\n",
       "      <td>18031</td>\n",
       "      <td>1004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>./csvs\\I211207.csv</td>\n",
       "      <td>20211207</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8051</td>\n",
       "      <td>29359</td>\n",
       "      <td>18628</td>\n",
       "      <td>19224</td>\n",
       "      <td>2005</td>\n",
       "      <td>6906</td>\n",
       "      <td>3814</td>\n",
       "      <td>...</td>\n",
       "      <td>5244</td>\n",
       "      <td>2614</td>\n",
       "      <td>17333</td>\n",
       "      <td>6408</td>\n",
       "      <td>28633</td>\n",
       "      <td>577</td>\n",
       "      <td>5380</td>\n",
       "      <td>16960</td>\n",
       "      <td>17687</td>\n",
       "      <td>1495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>./csvs\\I211208.csv</td>\n",
       "      <td>20211208</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7993</td>\n",
       "      <td>29756</td>\n",
       "      <td>18938</td>\n",
       "      <td>19500</td>\n",
       "      <td>2002</td>\n",
       "      <td>6776</td>\n",
       "      <td>3821</td>\n",
       "      <td>...</td>\n",
       "      <td>5047</td>\n",
       "      <td>2402</td>\n",
       "      <td>17259</td>\n",
       "      <td>4697</td>\n",
       "      <td>28632</td>\n",
       "      <td>410</td>\n",
       "      <td>5288</td>\n",
       "      <td>17467</td>\n",
       "      <td>18099</td>\n",
       "      <td>1443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>./csvs\\I211209.csv</td>\n",
       "      <td>20211209</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7634</td>\n",
       "      <td>29089</td>\n",
       "      <td>18905</td>\n",
       "      <td>19178</td>\n",
       "      <td>1969</td>\n",
       "      <td>6890</td>\n",
       "      <td>3824</td>\n",
       "      <td>...</td>\n",
       "      <td>5206</td>\n",
       "      <td>2537</td>\n",
       "      <td>17302</td>\n",
       "      <td>4699</td>\n",
       "      <td>28628</td>\n",
       "      <td>652</td>\n",
       "      <td>23080</td>\n",
       "      <td>16868</td>\n",
       "      <td>17092</td>\n",
       "      <td>1424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>./csvs\\I211210.csv</td>\n",
       "      <td>20211210</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8118</td>\n",
       "      <td>30189</td>\n",
       "      <td>19129</td>\n",
       "      <td>19349</td>\n",
       "      <td>2275</td>\n",
       "      <td>6899</td>\n",
       "      <td>3792</td>\n",
       "      <td>...</td>\n",
       "      <td>5198</td>\n",
       "      <td>2366</td>\n",
       "      <td>17250</td>\n",
       "      <td>4689</td>\n",
       "      <td>28590</td>\n",
       "      <td>471</td>\n",
       "      <td>6855</td>\n",
       "      <td>16854</td>\n",
       "      <td>17331</td>\n",
       "      <td>1432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>./csvs\\I211213.csv</td>\n",
       "      <td>20211213</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8471</td>\n",
       "      <td>30214</td>\n",
       "      <td>19425</td>\n",
       "      <td>19539</td>\n",
       "      <td>2046</td>\n",
       "      <td>6739</td>\n",
       "      <td>3823</td>\n",
       "      <td>...</td>\n",
       "      <td>5420</td>\n",
       "      <td>2417</td>\n",
       "      <td>17255</td>\n",
       "      <td>4659</td>\n",
       "      <td>28538</td>\n",
       "      <td>420</td>\n",
       "      <td>6895</td>\n",
       "      <td>16811</td>\n",
       "      <td>17279</td>\n",
       "      <td>1422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>./csvs\\I211215.csv</td>\n",
       "      <td>20211215</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8092</td>\n",
       "      <td>27961</td>\n",
       "      <td>18830</td>\n",
       "      <td>17678</td>\n",
       "      <td>1997</td>\n",
       "      <td>7355</td>\n",
       "      <td>3813</td>\n",
       "      <td>...</td>\n",
       "      <td>5159</td>\n",
       "      <td>2627</td>\n",
       "      <td>17272</td>\n",
       "      <td>4664</td>\n",
       "      <td>28602</td>\n",
       "      <td>498</td>\n",
       "      <td>5375</td>\n",
       "      <td>17232</td>\n",
       "      <td>17336</td>\n",
       "      <td>1436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>./csvs\\I211216.csv</td>\n",
       "      <td>20211216</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7654</td>\n",
       "      <td>24503</td>\n",
       "      <td>18825</td>\n",
       "      <td>17254</td>\n",
       "      <td>2004</td>\n",
       "      <td>6910</td>\n",
       "      <td>3804</td>\n",
       "      <td>...</td>\n",
       "      <td>5146</td>\n",
       "      <td>2459</td>\n",
       "      <td>17197</td>\n",
       "      <td>4656</td>\n",
       "      <td>28607</td>\n",
       "      <td>371</td>\n",
       "      <td>5326</td>\n",
       "      <td>17408</td>\n",
       "      <td>17427</td>\n",
       "      <td>1430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>./csvs\\I211220.csv</td>\n",
       "      <td>20211220</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7783</td>\n",
       "      <td>30486</td>\n",
       "      <td>18353</td>\n",
       "      <td>19856</td>\n",
       "      <td>2000</td>\n",
       "      <td>6802</td>\n",
       "      <td>3828</td>\n",
       "      <td>...</td>\n",
       "      <td>5175</td>\n",
       "      <td>2276</td>\n",
       "      <td>17315</td>\n",
       "      <td>4750</td>\n",
       "      <td>28619</td>\n",
       "      <td>516</td>\n",
       "      <td>5321</td>\n",
       "      <td>18507</td>\n",
       "      <td>17911</td>\n",
       "      <td>1578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>./csvs\\I211222.csv</td>\n",
       "      <td>20211222</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>7631</td>\n",
       "      <td>32249</td>\n",
       "      <td>18556</td>\n",
       "      <td>20420</td>\n",
       "      <td>1999</td>\n",
       "      <td>6775</td>\n",
       "      <td>3793</td>\n",
       "      <td>...</td>\n",
       "      <td>5200</td>\n",
       "      <td>2526</td>\n",
       "      <td>17277</td>\n",
       "      <td>4686</td>\n",
       "      <td>28639</td>\n",
       "      <td>2387</td>\n",
       "      <td>6843</td>\n",
       "      <td>18492</td>\n",
       "      <td>17976</td>\n",
       "      <td>1436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>./csvs\\I211223.csv</td>\n",
       "      <td>20211223</td>\n",
       "      <td>IDLE</td>\n",
       "      <td>8319</td>\n",
       "      <td>32354</td>\n",
       "      <td>18368</td>\n",
       "      <td>20513</td>\n",
       "      <td>1980</td>\n",
       "      <td>6837</td>\n",
       "      <td>3801</td>\n",
       "      <td>...</td>\n",
       "      <td>5193</td>\n",
       "      <td>2537</td>\n",
       "      <td>17275</td>\n",
       "      <td>4702</td>\n",
       "      <td>28623</td>\n",
       "      <td>3185</td>\n",
       "      <td>6866</td>\n",
       "      <td>18549</td>\n",
       "      <td>17932</td>\n",
       "      <td>1561</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>54 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  File      Date    Type  AMCREST WiFi Camera  \\\n",
       "0   ./csvs\\A211102.csv  20211102  ACTIVE                 6683   \n",
       "1   ./csvs\\A211103.csv  20211103  ACTIVE                 5535   \n",
       "2   ./csvs\\A211105.csv  20211105  ACTIVE                 5515   \n",
       "3   ./csvs\\A211108.csv  20211108  ACTIVE                 5627   \n",
       "4   ./csvs\\A211109.csv  20211109  ACTIVE                 6092   \n",
       "5   ./csvs\\A211110.csv  20211110  ACTIVE                 6743   \n",
       "6   ./csvs\\A211112.csv  20211112  ACTIVE                 5653   \n",
       "7   ./csvs\\A211115.csv  20211115  ACTIVE                 5658   \n",
       "8   ./csvs\\A211116.csv  20211116  ACTIVE                 5425   \n",
       "9   ./csvs\\A211117.csv  20211117  ACTIVE                 5362   \n",
       "10  ./csvs\\A211118.csv  20211118  ACTIVE                 5973   \n",
       "11  ./csvs\\A211119.csv  20211119  ACTIVE                 5542   \n",
       "12  ./csvs\\A211122.csv  20211122  ACTIVE                 5618   \n",
       "13  ./csvs\\A211123.csv  20211123  ACTIVE                 6284   \n",
       "14  ./csvs\\A211124.csv  20211124  ACTIVE                 5738   \n",
       "15  ./csvs\\A211125.csv  20211125  ACTIVE                 5758   \n",
       "16  ./csvs\\A211126.csv  20211126  ACTIVE                 7741   \n",
       "17  ./csvs\\A211206.csv  20211206  ACTIVE                 6498   \n",
       "18  ./csvs\\A211207.csv  20211207  ACTIVE                 5660   \n",
       "19  ./csvs\\A211208.csv  20211208  ACTIVE                 6162   \n",
       "20  ./csvs\\A211223.csv  20211223  ACTIVE                 6259   \n",
       "21  ./csvs\\A211225.csv  20211225  ACTIVE                 5676   \n",
       "22  ./csvs\\A211228.csv  20211228  ACTIVE                 5451   \n",
       "23  ./csvs\\A220103.csv  20220103  ACTIVE                 5590   \n",
       "24  ./csvs\\I211102.csv  20211102    IDLE                 7921   \n",
       "25  ./csvs\\I211103.csv  20211103    IDLE                 7847   \n",
       "26  ./csvs\\I211104.csv  20211104    IDLE                 8600   \n",
       "27  ./csvs\\I211108.csv  20211108    IDLE                 7969   \n",
       "28  ./csvs\\I211110.csv  20211110    IDLE                 8426   \n",
       "29  ./csvs\\I211112.csv  20211112    IDLE                 8527   \n",
       "30  ./csvs\\I211115.csv  20211115    IDLE                 7437   \n",
       "31  ./csvs\\I211116.csv  20211116    IDLE                 7501   \n",
       "32  ./csvs\\I211117.csv  20211117    IDLE                 7559   \n",
       "33  ./csvs\\I211118.csv  20211118    IDLE                 7558   \n",
       "34  ./csvs\\I211119.csv  20211119    IDLE                 8253   \n",
       "35  ./csvs\\I211122.csv  20211122    IDLE                 7679   \n",
       "36  ./csvs\\I211124.csv  20211124    IDLE                 7751   \n",
       "37  ./csvs\\I211125.csv  20211125    IDLE                 7950   \n",
       "38  ./csvs\\I211126.csv  20211126    IDLE                 8949   \n",
       "39  ./csvs\\I211129.csv  20211129    IDLE                 8489   \n",
       "40  ./csvs\\I211130.csv  20211130    IDLE                 7794   \n",
       "41  ./csvs\\I211201.csv  20211201    IDLE                 8900   \n",
       "42  ./csvs\\I211202.csv  20211202    IDLE                 7772   \n",
       "43  ./csvs\\I211203.csv  20211203    IDLE                 8438   \n",
       "44  ./csvs\\I211207.csv  20211207    IDLE                 8051   \n",
       "45  ./csvs\\I211208.csv  20211208    IDLE                 7993   \n",
       "46  ./csvs\\I211209.csv  20211209    IDLE                 7634   \n",
       "47  ./csvs\\I211210.csv  20211210    IDLE                 8118   \n",
       "48  ./csvs\\I211213.csv  20211213    IDLE                 8471   \n",
       "49  ./csvs\\I211215.csv  20211215    IDLE                 8092   \n",
       "50  ./csvs\\I211216.csv  20211216    IDLE                 7654   \n",
       "51  ./csvs\\I211220.csv  20211220    IDLE                 7783   \n",
       "52  ./csvs\\I211222.csv  20211222    IDLE                 7631   \n",
       "53  ./csvs\\I211223.csv  20211223    IDLE                 8319   \n",
       "\n",
       "    Amazon Alexa Echo Dot  Amazon Alexa Echo Spot  Amazon Alexa Echo Studio  \\\n",
       "0                   13747                   14944                     13204   \n",
       "1                   14076                   15193                     13163   \n",
       "2                   13932                   13720                     13122   \n",
       "3                   21651                   14993                     13060   \n",
       "4                   22381                   14718                     13174   \n",
       "5                   92566                   19876                     14951   \n",
       "6                   54894                   15696                     19457   \n",
       "7                   23969                   14932                     14209   \n",
       "8                   22291                   13676                     13817   \n",
       "9                   46049                   15327                     58610   \n",
       "10                  23125                   13330                     14210   \n",
       "11                  22973                   13412                     14217   \n",
       "12                  18890                   14911                     13487   \n",
       "13                  21989                   15335                     13581   \n",
       "14                  21495                   14607                     13344   \n",
       "15                  21617                   15995                     14077   \n",
       "16                  31070                   20224                     17214   \n",
       "17                  21745                   15585                     15761   \n",
       "18                  21525                   15568                     14439   \n",
       "19                  21247                   15343                     13631   \n",
       "20                  23214                   13326                     13331   \n",
       "21                  27882                   14884                     14387   \n",
       "22                  23492                   20393                     15065   \n",
       "23                  21072                   14450                     13353   \n",
       "24                  17840                   19264                    121468   \n",
       "25                  18196                   18779                     19424   \n",
       "26                  18685                   18896                     19414   \n",
       "27                  31033                   17532                     19504   \n",
       "28                  30654                   19415                     17879   \n",
       "29                  29991                   17218                     17353   \n",
       "30                  32238                   17821                     18010   \n",
       "31                  32128                   17922                     18089   \n",
       "32                  32614                   17936                     18517   \n",
       "33                  32831                   17997                     18492   \n",
       "34                  33060                   18137                     18413   \n",
       "35                  27506                   20862                     17409   \n",
       "36                  29729                   18744                     17164   \n",
       "37                  30262                   18762                     17594   \n",
       "38                  31951                   21803                     19960   \n",
       "39                  29687                   19230                     19328   \n",
       "40                  30063                   19175                     17506   \n",
       "41                  30087                   18899                     17483   \n",
       "42                  28860                   19083                     17488   \n",
       "43                  29646                   18240                     17324   \n",
       "44                  29359                   18628                     19224   \n",
       "45                  29756                   18938                     19500   \n",
       "46                  29089                   18905                     19178   \n",
       "47                  30189                   19129                     19349   \n",
       "48                  30214                   19425                     19539   \n",
       "49                  27961                   18830                     17678   \n",
       "50                  24503                   18825                     17254   \n",
       "51                  30486                   18353                     19856   \n",
       "52                  32249                   18556                     20420   \n",
       "53                  32354                   18368                     20513   \n",
       "\n",
       "    Amazon Plug  Arlo Base Station  Arlo Q Camera  ...  Netatmo Camera  \\\n",
       "0          1470              12628          21077  ...            9591   \n",
       "1          1475               4928          18809  ...           12208   \n",
       "2          1476               4948          21539  ...           26146   \n",
       "3          1470              45081          78958  ...           10191   \n",
       "4          1472              45974          47257  ...            9168   \n",
       "5          2393              22247          37377  ...            9004   \n",
       "6          1472               4890          37475  ...           10530   \n",
       "7          1824             110057          55184  ...            9433   \n",
       "8          1473              11093          98636  ...           14129   \n",
       "9          1468               4884          44920  ...            9539   \n",
       "10         1467               4810           4973  ...            4308   \n",
       "11         1474               4909           3641  ...            4096   \n",
       "12         1465              15095          58717  ...            9487   \n",
       "13         1409               7823          58498  ...           11608   \n",
       "14         1468               4898          17536  ...            6471   \n",
       "15         1546               5147          34633  ...            5754   \n",
       "16          517             326314         148989  ...           19261   \n",
       "17         1562              24180          33805  ...           11826   \n",
       "18         1520             438038          41608  ...            9888   \n",
       "19         1516              13704          29369  ...            9708   \n",
       "20         1463               4934           3790  ...            3782   \n",
       "21         1458              13160          23086  ...            7097   \n",
       "22         1459               8510          23499  ...            5673   \n",
       "23         1495               4908           2745  ...            3739   \n",
       "24         2001               6852           3822  ...            7353   \n",
       "25         2045               6825           3824  ...            7269   \n",
       "26         2094               6888           3936  ...            7691   \n",
       "27         2048               6808           3806  ...            5117   \n",
       "28         1982               6842          51550  ...            5170   \n",
       "29         1999               6800          47365  ...            5115   \n",
       "30         1991              10246           3954  ...            5108   \n",
       "31         1994               6808           3837  ...            5200   \n",
       "32         2007               6861           3839  ...            5256   \n",
       "33         2004               6778           3800  ...            5163   \n",
       "34         2002               6903           5308  ...            5213   \n",
       "35         2047               6808           3800  ...            5045   \n",
       "36         2006               6830           4337  ...            5135   \n",
       "37         2043               6824           3810  ...            5069   \n",
       "38            0               6852           4377  ...            4999   \n",
       "39         1965               7036           3969  ...            5021   \n",
       "40         2003              10012           3803  ...            5079   \n",
       "41         2011               6845           3798  ...            5194   \n",
       "42         1966               6904           3802  ...            5149   \n",
       "43         1993               6859           3821  ...            5137   \n",
       "44         2005               6906           3814  ...            5244   \n",
       "45         2002               6776           3821  ...            5047   \n",
       "46         1969               6890           3824  ...            5206   \n",
       "47         2275               6899           3792  ...            5198   \n",
       "48         2046               6739           3823  ...            5420   \n",
       "49         1997               7355           3813  ...            5159   \n",
       "50         2004               6910           3804  ...            5146   \n",
       "51         2000               6802           3828  ...            5175   \n",
       "52         1999               6775           3793  ...            5200   \n",
       "53         1980               6837           3801  ...            5193   \n",
       "\n",
       "    Netatmo Weather Station  Philips Hue Bridge  Ring Base Station  \\\n",
       "0                      1811               12501               3368   \n",
       "1                      1874               12671               3259   \n",
       "2                      1700               14034               3208   \n",
       "3                      1819               13805               3468   \n",
       "4                      1769               12466               3344   \n",
       "5                      1816               13790               3270   \n",
       "6                      1908               15194               3279   \n",
       "7                      1833               17496               3848   \n",
       "8                      1899               15715               3321   \n",
       "9                      1912               13698               3253   \n",
       "10                     1883               12864               3203   \n",
       "11                     1850               12697               3212   \n",
       "12                     1817               13544               3321   \n",
       "13                     1853               12966               3326   \n",
       "14                     1855               12565               3288   \n",
       "15                     1902               14362               3297   \n",
       "16                     2466               17647               5690   \n",
       "17                     1771               12827               3412   \n",
       "18                     1819               14184               3809   \n",
       "19                     1786               12854               3460   \n",
       "20                     1774               12813               3168   \n",
       "21                     1881               12945               3200   \n",
       "22                     1811                7076               3233   \n",
       "23                     1681                7073               3164   \n",
       "24                     2471               17046               4791   \n",
       "25                     2461               16927               4699   \n",
       "26                     2529               16884               4734   \n",
       "27                     2506               16888               4690   \n",
       "28                     2512               17111               4677   \n",
       "29                     2548               24878               4723   \n",
       "30                     2580               24867               4647   \n",
       "31                     2469               17212               4691   \n",
       "32                     2588               17199               4752   \n",
       "33                     2626               17173               4718   \n",
       "34                     2501               17281               4707   \n",
       "35                     2556               17250               4695   \n",
       "36                     2483               17176               4651   \n",
       "37                     2553               17183               4676   \n",
       "38                     2497               17212               4686   \n",
       "39                     2590               17309                  0   \n",
       "40                     2457               17267               4703   \n",
       "41                     2556               17262               4710   \n",
       "42                     2521               17248               4677   \n",
       "43                     2470               17698               4669   \n",
       "44                     2614               17333               6408   \n",
       "45                     2402               17259               4697   \n",
       "46                     2537               17302               4699   \n",
       "47                     2366               17250               4689   \n",
       "48                     2417               17255               4659   \n",
       "49                     2627               17272               4664   \n",
       "50                     2459               17197               4656   \n",
       "51                     2276               17315               4750   \n",
       "52                     2526               17277               4686   \n",
       "53                     2537               17275               4702   \n",
       "\n",
       "    SIMCAM 1S (AMPAKTec)  Smart Board  Sonos One Speaker  Teckin Plug  \\\n",
       "0                  21448          404               5180        13014   \n",
       "1                  21083          545               8708        12911   \n",
       "2                  20914          380               4970        13065   \n",
       "3                  21956          432               4970        12657   \n",
       "4                  21652          436               4994        12708   \n",
       "5                  21153         6150               6866        12205   \n",
       "6                  21477         8361               6977        12506   \n",
       "7                  21474         3035               4254        12635   \n",
       "8                  22033         8060               3843        12112   \n",
       "9                  21233         3993               4843        12163   \n",
       "10                 21005         3634               3887        12474   \n",
       "11                 20924         1373               3821        12130   \n",
       "12                 21263         3822               3871        12182   \n",
       "13                 28149         5242               3930        12428   \n",
       "14                 27765         4743               4114        12328   \n",
       "15                 21163         6040               5745        12276   \n",
       "16                 29406       211966               6207        16894   \n",
       "17                 21783          767               4656        12395   \n",
       "18                 21622          426              11616        12982   \n",
       "19                 21972          512               3894        12709   \n",
       "20                 20892          742               4984        13483   \n",
       "21                 21150         2707              11822        13477   \n",
       "22                 21188          613              44113        13466   \n",
       "23                 20913          484               4917        13045   \n",
       "24                 28622          352               6890        17781   \n",
       "25                 28635          199               6815        17775   \n",
       "26                 28600          235               6898        17756   \n",
       "27                 28635           52               6818        17464   \n",
       "28                 28631         3873               6856        16697   \n",
       "29                 28638         3295               6930        16809   \n",
       "30                 28633         1408               5314        16859   \n",
       "31                 28641            0               5327        16717   \n",
       "32                 28652            0              21857        16650   \n",
       "33                 28641         3375               5358        16696   \n",
       "34                 28637         1293               5415        16675   \n",
       "35                 28633         1342               5317        16737   \n",
       "36                 37528         4549               5377        16819   \n",
       "37                 28638          481               5366        16724   \n",
       "38                 28619         4772               5378        16971   \n",
       "39                 28729          389               5398        17129   \n",
       "40                 28615          376               5335        17166   \n",
       "41                 28625          436               5369        17158   \n",
       "42                 28601          504               5338        17061   \n",
       "43                 28630        14913               5195        17042   \n",
       "44                 28633          577               5380        16960   \n",
       "45                 28632          410               5288        17467   \n",
       "46                 28628          652              23080        16868   \n",
       "47                 28590          471               6855        16854   \n",
       "48                 28538          420               6895        16811   \n",
       "49                 28602          498               5375        17232   \n",
       "50                 28607          371               5326        17408   \n",
       "51                 28619          516               5321        18507   \n",
       "52                 28639         2387               6843        18492   \n",
       "53                 28623         3185               6866        18549   \n",
       "\n",
       "    Yutron Plug  iRobot Roomba  \n",
       "0         13031           1123  \n",
       "1         13187           1207  \n",
       "2         12695           1052  \n",
       "3         12727           1055  \n",
       "4         12712           1046  \n",
       "5         12946           1156  \n",
       "6         12950           1194  \n",
       "7         13166           1213  \n",
       "8         12510           1171  \n",
       "9         12487           1096  \n",
       "10        12660           1341  \n",
       "11        12458           1117  \n",
       "12        12774           1116  \n",
       "13        13161           1061  \n",
       "14        12800           1034  \n",
       "15        12600           1175  \n",
       "16        17023           1556  \n",
       "17        13108           1201  \n",
       "18        13454           1053  \n",
       "19        13128           1064  \n",
       "20        13200           1204  \n",
       "21        13103           1036  \n",
       "22        12810           1104  \n",
       "23        13214           1386  \n",
       "24        17895           1432  \n",
       "25        18019           1423  \n",
       "26        17443           1509  \n",
       "27        17491           1516  \n",
       "28        18049           1432  \n",
       "29        17726           1427  \n",
       "30        17549           1426  \n",
       "31        17265           1500  \n",
       "32        17373           1505  \n",
       "33        17303           1476  \n",
       "34        17228           1423  \n",
       "35        17711           1462  \n",
       "36        17355           1433  \n",
       "37        16989           1429  \n",
       "38        17253           1422  \n",
       "39        18046           1484  \n",
       "40        16802           1424  \n",
       "41        16972           1425  \n",
       "42        17567           1425  \n",
       "43        18031           1004  \n",
       "44        17687           1495  \n",
       "45        18099           1443  \n",
       "46        17092           1424  \n",
       "47        17331           1432  \n",
       "48        17279           1422  \n",
       "49        17336           1436  \n",
       "50        17427           1430  \n",
       "51        17911           1578  \n",
       "52        17976           1436  \n",
       "53        17932           1561  \n",
       "\n",
       "[54 rows x 35 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results.to_csv(\"01.4 - Devices_packet_numbers_merged.csv\",index=False)\n",
    "results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "9f0c5ff0",
   "metadata": {},
   "outputs": [],
   "source": [
    "#### Generating session ID numbers that identify which devices the sessions do and do not involve"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "3ef02c37",
   "metadata": {},
   "outputs": [],
   "source": [
    "raw_ID= np.where(results!=0, 1, 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "34684828",
   "metadata": {},
   "outputs": [],
   "source": [
    "Device_ID={}\n",
    "for i, ii in enumerate(results[\"File\"]):\n",
    "    Device_ID[ii]=intjoin(raw_ID[i][3:])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "08a3d12e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'./csvs\\\\A211102.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211103.csv': 11111111110111111111111111111111,\n",
       " './csvs\\\\A211105.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211108.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211109.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211110.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211112.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211115.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211116.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211117.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211118.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211119.csv': 11111111110111110110111111111111,\n",
       " './csvs\\\\A211122.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211123.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211124.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\A211125.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211126.csv': 11111111110111111111111111111111,\n",
       " './csvs\\\\A211206.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211207.csv': 11111111110111111111111111111111,\n",
       " './csvs\\\\A211208.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211223.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211225.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A211228.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\A220103.csv': 11111111110111111110011111111111,\n",
       " './csvs\\\\I211102.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\I211103.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\I211104.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\I211108.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\I211110.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\I211112.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\I211115.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\I211116.csv': 11111111110111111110111111101111,\n",
       " './csvs\\\\I211117.csv': 11111111110111111110111111101111,\n",
       " './csvs\\\\I211118.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\I211119.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\I211122.csv': 11111111110111111110111111111111,\n",
       " './csvs\\\\I211124.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211125.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211126.csv': 11110111111111111110111111111111,\n",
       " './csvs\\\\I211129.csv': 11111111111111111110111110111111,\n",
       " './csvs\\\\I211130.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211201.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211202.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211203.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211207.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211208.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211209.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211210.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211213.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211215.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211216.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211220.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211222.csv': 11111111111111111110111111111111,\n",
       " './csvs\\\\I211223.csv': 11111111111111111110111111111111}"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Device_ID"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c1b29705",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "8af85d27",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Grouping of sessions with similar device distribution using session IDs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "35fc02bc",
   "metadata": {},
   "outputs": [],
   "source": [
    "vererse_ID={}\n",
    "for i in Device_ID:\n",
    "    if Device_ID[i] not in vererse_ID:\n",
    "        vererse_ID[Device_ID[i]]=[i]\n",
    "    else:\n",
    "        vererse_ID[Device_ID[i]].append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "6419b7bb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{11111111110111111110111111111111: ['./csvs\\\\A211102.csv',\n",
       "  './csvs\\\\A211105.csv',\n",
       "  './csvs\\\\A211108.csv',\n",
       "  './csvs\\\\A211109.csv',\n",
       "  './csvs\\\\A211110.csv',\n",
       "  './csvs\\\\A211112.csv',\n",
       "  './csvs\\\\A211115.csv',\n",
       "  './csvs\\\\A211116.csv',\n",
       "  './csvs\\\\A211117.csv',\n",
       "  './csvs\\\\A211118.csv',\n",
       "  './csvs\\\\A211122.csv',\n",
       "  './csvs\\\\A211123.csv',\n",
       "  './csvs\\\\A211125.csv',\n",
       "  './csvs\\\\A211206.csv',\n",
       "  './csvs\\\\A211208.csv',\n",
       "  './csvs\\\\A211223.csv',\n",
       "  './csvs\\\\A211225.csv',\n",
       "  './csvs\\\\A211228.csv',\n",
       "  './csvs\\\\I211102.csv',\n",
       "  './csvs\\\\I211103.csv',\n",
       "  './csvs\\\\I211104.csv',\n",
       "  './csvs\\\\I211108.csv',\n",
       "  './csvs\\\\I211110.csv',\n",
       "  './csvs\\\\I211112.csv',\n",
       "  './csvs\\\\I211115.csv',\n",
       "  './csvs\\\\I211118.csv',\n",
       "  './csvs\\\\I211119.csv',\n",
       "  './csvs\\\\I211122.csv'],\n",
       " 11111111110111111111111111111111: ['./csvs\\\\A211103.csv',\n",
       "  './csvs\\\\A211126.csv',\n",
       "  './csvs\\\\A211207.csv'],\n",
       " 11111111110111110110111111111111: ['./csvs\\\\A211119.csv'],\n",
       " 11111111111111111110111111111111: ['./csvs\\\\A211124.csv',\n",
       "  './csvs\\\\I211124.csv',\n",
       "  './csvs\\\\I211125.csv',\n",
       "  './csvs\\\\I211130.csv',\n",
       "  './csvs\\\\I211201.csv',\n",
       "  './csvs\\\\I211202.csv',\n",
       "  './csvs\\\\I211203.csv',\n",
       "  './csvs\\\\I211207.csv',\n",
       "  './csvs\\\\I211208.csv',\n",
       "  './csvs\\\\I211209.csv',\n",
       "  './csvs\\\\I211210.csv',\n",
       "  './csvs\\\\I211213.csv',\n",
       "  './csvs\\\\I211215.csv',\n",
       "  './csvs\\\\I211216.csv',\n",
       "  './csvs\\\\I211220.csv',\n",
       "  './csvs\\\\I211222.csv',\n",
       "  './csvs\\\\I211223.csv'],\n",
       " 11111111110111111110011111111111: ['./csvs\\\\A220103.csv'],\n",
       " 11111111110111111110111111101111: ['./csvs\\\\I211116.csv',\n",
       "  './csvs\\\\I211117.csv'],\n",
       " 11110111111111111110111111111111: ['./csvs\\\\I211126.csv'],\n",
       " 11111111111111111110111110111111: ['./csvs\\\\I211129.csv']}"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vererse_ID"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "c0898893",
   "metadata": {},
   "outputs": [],
   "source": [
    "datasets=[]\n",
    "for i in vererse_ID:\n",
    "    if len(vererse_ID[i])>1:\n",
    "        datasets.append(vererse_ID[i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "83543c4f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['./csvs\\\\A211102.csv',\n",
       "  './csvs\\\\A211105.csv',\n",
       "  './csvs\\\\A211108.csv',\n",
       "  './csvs\\\\A211109.csv',\n",
       "  './csvs\\\\A211110.csv',\n",
       "  './csvs\\\\A211112.csv',\n",
       "  './csvs\\\\A211115.csv',\n",
       "  './csvs\\\\A211116.csv',\n",
       "  './csvs\\\\A211117.csv',\n",
       "  './csvs\\\\A211118.csv',\n",
       "  './csvs\\\\A211122.csv',\n",
       "  './csvs\\\\A211123.csv',\n",
       "  './csvs\\\\A211125.csv',\n",
       "  './csvs\\\\A211206.csv',\n",
       "  './csvs\\\\A211208.csv',\n",
       "  './csvs\\\\A211223.csv',\n",
       "  './csvs\\\\A211225.csv',\n",
       "  './csvs\\\\A211228.csv',\n",
       "  './csvs\\\\I211102.csv',\n",
       "  './csvs\\\\I211103.csv',\n",
       "  './csvs\\\\I211104.csv',\n",
       "  './csvs\\\\I211108.csv',\n",
       "  './csvs\\\\I211110.csv',\n",
       "  './csvs\\\\I211112.csv',\n",
       "  './csvs\\\\I211115.csv',\n",
       "  './csvs\\\\I211118.csv',\n",
       "  './csvs\\\\I211119.csv',\n",
       "  './csvs\\\\I211122.csv'],\n",
       " ['./csvs\\\\A211103.csv', './csvs\\\\A211126.csv', './csvs\\\\A211207.csv'],\n",
       " ['./csvs\\\\A211124.csv',\n",
       "  './csvs\\\\I211124.csv',\n",
       "  './csvs\\\\I211125.csv',\n",
       "  './csvs\\\\I211130.csv',\n",
       "  './csvs\\\\I211201.csv',\n",
       "  './csvs\\\\I211202.csv',\n",
       "  './csvs\\\\I211203.csv',\n",
       "  './csvs\\\\I211207.csv',\n",
       "  './csvs\\\\I211208.csv',\n",
       "  './csvs\\\\I211209.csv',\n",
       "  './csvs\\\\I211210.csv',\n",
       "  './csvs\\\\I211213.csv',\n",
       "  './csvs\\\\I211215.csv',\n",
       "  './csvs\\\\I211216.csv',\n",
       "  './csvs\\\\I211220.csv',\n",
       "  './csvs\\\\I211222.csv',\n",
       "  './csvs\\\\I211223.csv'],\n",
       " ['./csvs\\\\I211116.csv', './csvs\\\\I211117.csv']]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datasets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "81353c22",
   "metadata": {},
   "outputs": [],
   "source": [
    "{11111111110111111110111111111111: ['./csvs\\\\A211102.csv',\n",
    "  './csvs\\\\A211105.csv',\n",
    "  './csvs\\\\A211108.csv',\n",
    "  './csvs\\\\A211109.csv',\n",
    "  './csvs\\\\A211110.csv',\n",
    "  './csvs\\\\A211112.csv',\n",
    "  './csvs\\\\A211115.csv',\n",
    "  './csvs\\\\A211116.csv',\n",
    "  './csvs\\\\A211117.csv',\n",
    "  './csvs\\\\A211118.csv',\n",
    "  './csvs\\\\A211122.csv',\n",
    "  './csvs\\\\A211123.csv',\n",
    "  './csvs\\\\A211125.csv',\n",
    "  './csvs\\\\A211206.csv',\n",
    "  './csvs\\\\A211208.csv',\n",
    "  './csvs\\\\A211223.csv',\n",
    "  './csvs\\\\A211225.csv',\n",
    "  './csvs\\\\A211228.csv',\n",
    "  './csvs\\\\I211102.csv',\n",
    "  './csvs\\\\I211103.csv',\n",
    "  './csvs\\\\I211104.csv',\n",
    "  './csvs\\\\I211108.csv',\n",
    "  './csvs\\\\I211110.csv',\n",
    "  './csvs\\\\I211112.csv',\n",
    "  './csvs\\\\I211115.csv',\n",
    "  './csvs\\\\I211118.csv',\n",
    "  './csvs\\\\I211119.csv',\n",
    "  './csvs\\\\I211122.csv'],\n",
    " 11111111110111111111111111111111: ['./csvs\\\\A211103.csv',\n",
    "  './csvs\\\\A211126.csv',\n",
    "  './csvs\\\\A211207.csv'],\n",
    " 11111111110111110110111111111111: ['./csvs\\\\A211119.csv'],\n",
    " 11111111111111111110111111111111: ['./csvs\\\\A211124.csv',\n",
    "  './csvs\\\\I211124.csv',\n",
    "  './csvs\\\\I211125.csv',\n",
    "  './csvs\\\\I211130.csv',\n",
    "  './csvs\\\\I211201.csv',\n",
    "  './csvs\\\\I211202.csv',\n",
    "  './csvs\\\\I211203.csv',\n",
    "  './csvs\\\\I211207.csv',\n",
    "  './csvs\\\\I211208.csv',\n",
    "  './csvs\\\\I211209.csv',\n",
    "  './csvs\\\\I211210.csv',\n",
    "  './csvs\\\\I211213.csv',\n",
    "  './csvs\\\\I211215.csv',\n",
    "  './csvs\\\\I211216.csv',\n",
    "  './csvs\\\\I211220.csv',\n",
    "  './csvs\\\\I211222.csv',\n",
    "  './csvs\\\\I211223.csv'],\n",
    " 11111111110111111110011111111111: ['./csvs\\\\A220103.csv'],\n",
    " 11111111110111111110111111101111: ['./csvs\\\\I211116.csv',\n",
    "  './csvs\\\\I211117.csv'],\n",
    " 11110111111111111110111111111111: ['./csvs\\\\I211126.csv'],\n",
    " 11111111111111111110111110111111: ['./csvs\\\\I211129.csv']}"
   ]
  }
 ],
 "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.10.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}