01.2 - Creating_smaller_DF_with_Selected_features.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "9ccc0111",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "020a09be",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['./pcaps\\\\Chime_Doorbell\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Chime_Doorbell\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\D-Link_Cam936L\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Gosuna_LightBulb\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Gosuna_Socket\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Goumia_Coffemaker\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\itTiot_Cam\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\LaCrosse_AlarmClock\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb600\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Lumiman_Bulb900\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Lumiman_SmartPlug\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Minger_LightStrip\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Ocean_Radio\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\oossxx_SmartPlug\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Renpho_SmartPlug\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Ring_Doorbell\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Smart_Lamp\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Smart_LightStrip\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Tenvis_Cam\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\tp-link_LightBulb\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\tp-link_SmartPlug\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Wans_Cam\\\\2019-07-19_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-06-29_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-01_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-02_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-03_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-04_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-05_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-06_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-07_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-08_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-09_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-10_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-11_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-12_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-13_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-14_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-15_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-16_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-17_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-18_FE.csv',\n",
       " './pcaps\\\\Wemo_SmartPlug\\\\2019-07-19_FE.csv']"
      ]
     },
     "execution_count": 5,
     "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=\"./pcaps\"\n",
    "filenames=find_the_way(path,\".csv\")\n",
    "filenames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "8c79b127",
   "metadata": {},
   "outputs": [],
   "source": [
    "col= ['pck_size', 'Ether_type', 'LLC_ctrl', 'EAPOL_version', 'EAPOL_type', 'IP_ihl', 'IP_tos', 'IP_len', 'IP_flags', 'IP_DF', 'IP_ttl', 'IP_options', 'ICMP_code', 'TCP_dataofs', 'TCP_FIN', 'TCP_ACK', 'TCP_window', 'UDP_len', 'DHCP_options', 'BOOTP_hlen', 'BOOTP_flags', 'BOOTP_sname', 'BOOTP_file', 'BOOTP_options', 'DNS_qr', 'DNS_rd', 'DNS_qdcount', 'dport_class', 'payload_bytes', 'entropy',\n",
    "\"MAC\",\n",
    "'Label']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "d65da2af",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "./pcaps\\Chime_Doorbell\\2019-06-29_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-01_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-02_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-03_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-04_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-05_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-06_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-07_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-08_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-09_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-10_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-11_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-12_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-13_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-14_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-15_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-16_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-17_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-18_FE.csv\n",
      "./pcaps\\Chime_Doorbell\\2019-07-19_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-06-29_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-01_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-02_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-03_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-04_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-05_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-06_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-07_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-08_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-09_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-10_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-11_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-12_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-13_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-14_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-15_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-16_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-17_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-18_FE.csv\n",
      "./pcaps\\D-Link_Cam936L\\2019-07-19_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-06-29_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-01_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-02_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-03_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-04_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-05_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-06_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-07_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-08_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-09_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-10_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-11_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-12_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-13_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-14_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-15_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-16_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-17_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-18_FE.csv\n",
      "./pcaps\\Gosuna_LightBulb\\2019-07-19_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-06-29_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-01_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-02_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-03_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-04_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-05_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-06_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-07_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-08_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-09_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-10_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-11_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-12_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-13_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-14_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-15_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-16_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-17_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-18_FE.csv\n",
      "./pcaps\\Gosuna_Socket\\2019-07-19_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-06-29_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-01_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-02_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-03_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-04_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-05_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-06_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-07_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-08_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-09_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-10_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-11_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-12_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-13_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-14_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-15_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-16_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-17_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-18_FE.csv\n",
      "./pcaps\\Goumia_Coffemaker\\2019-07-19_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-06-29_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-01_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-02_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-03_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-04_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-05_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-06_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-07_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-08_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-09_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-10_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-11_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-12_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-13_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-14_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-15_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-16_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-17_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-18_FE.csv\n",
      "./pcaps\\itTiot_Cam\\2019-07-19_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-06-29_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-01_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-02_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-03_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-04_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-05_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-06_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-07_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-08_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-09_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-10_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-11_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-12_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-13_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-14_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-15_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-16_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-17_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-18_FE.csv\n",
      "./pcaps\\LaCrosse_AlarmClock\\2019-07-19_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-06-29_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-01_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-02_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-03_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-04_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-05_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-06_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-07_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-08_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-09_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-10_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-11_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-12_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-13_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-14_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-15_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-16_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-17_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-18_FE.csv\n",
      "./pcaps\\Lumiman_Bulb600\\2019-07-19_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-06-29_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-01_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-02_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-03_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-04_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-05_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-06_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-07_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-08_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-09_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-10_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-11_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-12_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-13_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-14_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-15_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-16_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-17_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-18_FE.csv\n",
      "./pcaps\\Lumiman_Bulb900\\2019-07-19_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-06-29_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-01_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-02_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-03_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-04_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-05_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-06_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-07_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-08_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-09_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-10_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-11_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-12_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-13_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-14_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-15_FE.csv\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "./pcaps\\Lumiman_SmartPlug\\2019-07-16_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-17_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-18_FE.csv\n",
      "./pcaps\\Lumiman_SmartPlug\\2019-07-19_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-06-29_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-01_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-02_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-03_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-04_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-05_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-06_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-07_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-08_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-09_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-10_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-11_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-12_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-13_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-14_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-15_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-16_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-17_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-18_FE.csv\n",
      "./pcaps\\Minger_LightStrip\\2019-07-19_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-06-29_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-01_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-02_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-03_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-04_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-05_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-06_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-07_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-08_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-09_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-10_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-11_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-12_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-13_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-14_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-15_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-16_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-17_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-18_FE.csv\n",
      "./pcaps\\Ocean_Radio\\2019-07-19_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-06-29_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-01_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-02_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-03_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-04_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-05_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-06_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-07_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-08_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-09_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-10_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-11_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-12_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-13_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-14_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-15_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-16_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-17_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-18_FE.csv\n",
      "./pcaps\\oossxx_SmartPlug\\2019-07-19_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-06-29_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-01_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-02_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-03_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-04_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-05_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-06_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-07_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-08_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-09_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-10_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-11_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-12_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-13_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-14_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-15_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-16_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-17_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-18_FE.csv\n",
      "./pcaps\\Renpho_SmartPlug\\2019-07-19_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-06-29_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-01_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-02_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-03_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-04_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-05_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-06_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-07_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-08_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-09_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-10_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-11_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-12_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-13_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-14_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-15_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-16_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-17_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-18_FE.csv\n",
      "./pcaps\\Ring_Doorbell\\2019-07-19_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-06-29_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-01_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-02_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-03_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-04_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-05_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-06_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-07_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-08_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-09_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-10_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-11_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-12_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-13_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-14_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-15_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-16_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-17_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-18_FE.csv\n",
      "./pcaps\\Smart_Lamp\\2019-07-19_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-06-29_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-01_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-02_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-03_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-04_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-05_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-06_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-07_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-08_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-09_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-10_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-11_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-12_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-13_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-14_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-15_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-16_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-17_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-18_FE.csv\n",
      "./pcaps\\Smart_LightStrip\\2019-07-19_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-06-29_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-01_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-02_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-03_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-04_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-05_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-06_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-07_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-08_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-09_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-10_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-11_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-12_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-13_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-14_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-15_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-16_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-17_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-18_FE.csv\n",
      "./pcaps\\Tenvis_Cam\\2019-07-19_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-06-29_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-01_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-02_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-03_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-04_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-05_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-06_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-07_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-08_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-09_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-10_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-11_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-12_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-13_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-14_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-15_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-16_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-17_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-18_FE.csv\n",
      "./pcaps\\tp-link_LightBulb\\2019-07-19_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-06-29_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-01_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-02_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-03_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-04_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-05_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-06_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-07_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-08_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-09_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-10_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-11_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-12_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-13_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-14_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-15_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-16_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-17_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-18_FE.csv\n",
      "./pcaps\\tp-link_SmartPlug\\2019-07-19_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-06-29_FE.csv\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "./pcaps\\Wans_Cam\\2019-07-01_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-02_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-03_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-04_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-05_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-06_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-07_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-08_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-09_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-10_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-11_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-12_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-13_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-14_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-15_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-16_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-17_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-18_FE.csv\n",
      "./pcaps\\Wans_Cam\\2019-07-19_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-06-29_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-01_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-02_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-03_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-04_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-05_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-06_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-07_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-08_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-09_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-10_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-11_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-12_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-13_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-14_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-15_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-16_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-17_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-18_FE.csv\n",
      "./pcaps\\Wemo_SmartPlug\\2019-07-19_FE.csv\n"
     ]
    }
   ],
   "source": [
    "for i in filenames:\n",
    "    print(i)\n",
    "    df=pd.read_csv(i,usecols=col)\n",
    "    df.to_csv(i,index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3ac99697",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ff2a5ef4",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "37a20ff6",
   "metadata": {},
   "outputs": [],
   "source": [
    "files=['2019-06-29',\n",
    " '2019-07-01',\n",
    " '2019-07-02',\n",
    " '2019-07-03',\n",
    " '2019-07-04',\n",
    " '2019-07-05',\n",
    " '2019-07-06',\n",
    " '2019-07-07',\n",
    " '2019-07-08',\n",
    " '2019-07-09',\n",
    " '2019-07-10',\n",
    " '2019-07-11',\n",
    " '2019-07-12',\n",
    " '2019-07-13',\n",
    " '2019-07-14',\n",
    " '2019-07-15',\n",
    " '2019-07-16',\n",
    " '2019-07-17',\n",
    " '2019-07-18',\n",
    " '2019-07-19']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "232ba842",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-06-29_FE.csv (7894, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-06-29_FE.csv (22885, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-06-29_FE.csv (109100, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-06-29_FE.csv (110193, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-06-29_FE.csv (12728, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-06-29_FE.csv (15513, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-06-29_FE.csv (20304, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-06-29_FE.csv (110435, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-06-29_FE.csv (110862, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-06-29_FE.csv (110342, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-06-29_FE.csv (25791, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-06-29_FE.csv (60262, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-06-29_FE.csv (110590, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-06-29_FE.csv (110305, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-06-29_FE.csv (561, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-06-29_FE.csv (109284, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-06-29_FE.csv (110607, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-06-29_FE.csv (6807, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-06-29_FE.csv (1401, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-06-29_FE.csv (1118, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-06-29_FE.csv (336251, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-06-29_FE.csv (1767, 32)\n"
     ]
    }
   ],
   "source": [
    "name=f\"./HPOTrain.csv\"\n",
    "df=pd.read_csv(\"./pcaps\\\\Chime_Doorbell\\\\2019-06-29_FE.csv\")\n",
    "col_names=list(df.columns)\n",
    "\n",
    "empty = pd.DataFrame(columns=col_names)\n",
    "empty.to_csv(name, mode=\"w\", index=False)#,header=False)\n",
    "\n",
    "\n",
    "for i in ['2019-06-29']:\n",
    "    name_list=find_the_way('./pcaps',i,\"csv\")\n",
    "    for iii in name_list:\n",
    "        df=pd.read_csv(iii)\n",
    "        print(\"name and shape of dataframe :\",iii,df.shape)\n",
    "        df.to_csv(name, mode=\"a\", index=False,header=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "707f5578",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-01_FE.csv (7703, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-01_FE.csv (22365, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-01_FE.csv (110252, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-01_FE.csv (110351, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-01_FE.csv (12752, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-01_FE.csv (14696, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-01_FE.csv (15866, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-01_FE.csv (110607, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-01_FE.csv (110931, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-01_FE.csv (107174, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-01_FE.csv (26037, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-01_FE.csv (60073, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-01_FE.csv (110390, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-01_FE.csv (108594, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-01_FE.csv (409, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-01_FE.csv (109718, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-01_FE.csv (110858, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-01_FE.csv (6105, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-01_FE.csv (1333, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-01_FE.csv (1222, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-01_FE.csv (333897, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-01_FE.csv (2003, 32)\n"
     ]
    }
   ],
   "source": [
    "name=f\"./HPOTest.csv\"\n",
    "df=pd.read_csv(\"./pcaps\\\\Chime_Doorbell\\\\2019-06-29_FE.csv\")\n",
    "col_names=list(df.columns)\n",
    "\n",
    "empty = pd.DataFrame(columns=col_names)\n",
    "empty.to_csv(name, mode=\"w\", index=False)#,header=False)\n",
    "\n",
    "\n",
    "for i in ['2019-07-01']:\n",
    "    name_list=find_the_way('./pcaps',i,\"csv\")\n",
    "    for iii in name_list:\n",
    "        df=pd.read_csv(iii)\n",
    "        print(\"name and shape of dataframe :\",iii,df.shape)\n",
    "        df.to_csv(name, mode=\"a\", index=False,header=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fc3f8121",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "eb8d6e9d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "65836439",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9a81f879",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "8131f891",
   "metadata": {},
   "outputs": [],
   "source": [
    "train=files[:len(files)//2]\n",
    "test=files[len(files)//2:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "1871b16a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2019-06-29',\n",
       " '2019-07-01',\n",
       " '2019-07-02',\n",
       " '2019-07-03',\n",
       " '2019-07-04',\n",
       " '2019-07-05',\n",
       " '2019-07-06',\n",
       " '2019-07-07',\n",
       " '2019-07-08',\n",
       " '2019-07-09']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "4ae778f9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2019-07-10',\n",
       " '2019-07-11',\n",
       " '2019-07-12',\n",
       " '2019-07-13',\n",
       " '2019-07-14',\n",
       " '2019-07-15',\n",
       " '2019-07-16',\n",
       " '2019-07-17',\n",
       " '2019-07-18',\n",
       " '2019-07-19']"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "95fcd23e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2019-06-29',\n",
       " '2019-07-01',\n",
       " '2019-07-02',\n",
       " '2019-07-03',\n",
       " '2019-07-04',\n",
       " '2019-07-05',\n",
       " '2019-07-06',\n",
       " '2019-07-07',\n",
       " '2019-07-08',\n",
       " '2019-07-09']"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "['2019-06-29',\n",
    " '2019-07-01',\n",
    " '2019-07-02',\n",
    " '2019-07-03',\n",
    " '2019-07-04',\n",
    " '2019-07-05',\n",
    " '2019-07-06',\n",
    " '2019-07-07',\n",
    " '2019-07-08',\n",
    " '2019-07-09']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "7d05badb",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-06-29_FE.csv (7894, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-06-29_FE.csv (22885, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-06-29_FE.csv (109100, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-06-29_FE.csv (110193, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-06-29_FE.csv (12728, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-06-29_FE.csv (15513, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-06-29_FE.csv (20304, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-06-29_FE.csv (110435, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-06-29_FE.csv (110862, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-06-29_FE.csv (110342, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-06-29_FE.csv (25791, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-06-29_FE.csv (60262, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-06-29_FE.csv (110590, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-06-29_FE.csv (110305, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-06-29_FE.csv (561, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-06-29_FE.csv (109284, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-06-29_FE.csv (110607, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-06-29_FE.csv (6807, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-06-29_FE.csv (1401, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-06-29_FE.csv (1118, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-06-29_FE.csv (336251, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-06-29_FE.csv (1767, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-01_FE.csv (7703, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-01_FE.csv (22365, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-01_FE.csv (110252, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-01_FE.csv (110351, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-01_FE.csv (12752, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-01_FE.csv (14696, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-01_FE.csv (15866, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-01_FE.csv (110607, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-01_FE.csv (110931, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-01_FE.csv (107174, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-01_FE.csv (26037, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-01_FE.csv (60073, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-01_FE.csv (110390, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-01_FE.csv (108594, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-01_FE.csv (409, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-01_FE.csv (109718, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-01_FE.csv (110858, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-01_FE.csv (6105, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-01_FE.csv (1333, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-01_FE.csv (1222, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-01_FE.csv (333897, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-01_FE.csv (2003, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-02_FE.csv (8604, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-02_FE.csv (21043, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-02_FE.csv (101330, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-02_FE.csv (100916, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-02_FE.csv (11799, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-02_FE.csv (14557, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-02_FE.csv (15066, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-02_FE.csv (101463, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-02_FE.csv (101679, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-02_FE.csv (100145, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-02_FE.csv (23890, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-02_FE.csv (56797, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-02_FE.csv (103486, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-02_FE.csv (103204, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-02_FE.csv (1959, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-02_FE.csv (103039, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-02_FE.csv (103110, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-02_FE.csv (6120, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-02_FE.csv (1267, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-02_FE.csv (1152, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-02_FE.csv (312440, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-02_FE.csv (1566, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-03_FE.csv (8689, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-03_FE.csv (23048, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-03_FE.csv (113356, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-03_FE.csv (113591, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-03_FE.csv (12880, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-03_FE.csv (14130, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-03_FE.csv (15811, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-03_FE.csv (113359, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-03_FE.csv (112821, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-03_FE.csv (111826, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-03_FE.csv (25986, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-03_FE.csv (64249, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-03_FE.csv (113034, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-03_FE.csv (113507, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-03_FE.csv (3113, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-03_FE.csv (112958, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-03_FE.csv (113370, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-03_FE.csv (5810, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-03_FE.csv (1195, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-03_FE.csv (1141, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-03_FE.csv (340243, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-03_FE.csv (1548, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-04_FE.csv (7581, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-04_FE.csv (23014, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-04_FE.csv (113163, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-04_FE.csv (113829, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-04_FE.csv (12886, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-04_FE.csv (10996, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-04_FE.csv (15278, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-04_FE.csv (112882, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-04_FE.csv (112780, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-04_FE.csv (112721, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-04_FE.csv (25773, 32)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-04_FE.csv (64565, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-04_FE.csv (112834, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-04_FE.csv (112586, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-04_FE.csv (413, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-04_FE.csv (113169, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-04_FE.csv (112136, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-04_FE.csv (6527, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-04_FE.csv (1187, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-04_FE.csv (1170, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-04_FE.csv (343131, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-04_FE.csv (1667, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-05_FE.csv (7849, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-05_FE.csv (22951, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-05_FE.csv (113707, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-05_FE.csv (112550, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-05_FE.csv (12831, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-05_FE.csv (16076, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-05_FE.csv (15738, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-05_FE.csv (112083, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-05_FE.csv (111795, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-05_FE.csv (113026, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-05_FE.csv (25916, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-05_FE.csv (64386, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-05_FE.csv (111613, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-05_FE.csv (112333, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-05_FE.csv (1388, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-05_FE.csv (113002, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-05_FE.csv (113444, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-05_FE.csv (6432, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-05_FE.csv (1197, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-05_FE.csv (1161, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-05_FE.csv (342516, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-05_FE.csv (1906, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-06_FE.csv (7657, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-06_FE.csv (22896, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-06_FE.csv (113027, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-06_FE.csv (113697, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-06_FE.csv (12845, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-06_FE.csv (16607, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-06_FE.csv (15594, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-06_FE.csv (113605, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-06_FE.csv (113387, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-06_FE.csv (113207, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-06_FE.csv (25889, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-06_FE.csv (64493, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-06_FE.csv (113638, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-06_FE.csv (113384, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-06_FE.csv (424, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-06_FE.csv (113771, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-06_FE.csv (113509, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-06_FE.csv (6489, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-06_FE.csv (1255, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-06_FE.csv (1207, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-06_FE.csv (342889, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-06_FE.csv (1680, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-07_FE.csv (8830, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-07_FE.csv (25308, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-07_FE.csv (122961, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-07_FE.csv (123118, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-07_FE.csv (13947, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-07_FE.csv (19561, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-07_FE.csv (17156, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-07_FE.csv (123327, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-07_FE.csv (123334, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-07_FE.csv (123202, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-07_FE.csv (28118, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-07_FE.csv (73093, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-07_FE.csv (122853, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-07_FE.csv (123403, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-07_FE.csv (1699, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-07_FE.csv (123507, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-07_FE.csv (123379, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-07_FE.csv (7395, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-07_FE.csv (1327, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-07_FE.csv (1218, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-07_FE.csv (368617, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-07_FE.csv (1811, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-08_FE.csv (9160, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-08_FE.csv (24447, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-08_FE.csv (115133, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-08_FE.csv (115142, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-08_FE.csv (12972, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-08_FE.csv (22430, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-08_FE.csv (15960, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-08_FE.csv (115141, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-08_FE.csv (115111, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-08_FE.csv (115176, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-08_FE.csv (26182, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-08_FE.csv (77670, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-08_FE.csv (115116, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-08_FE.csv (115144, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-08_FE.csv (3854, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-08_FE.csv (115157, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-08_FE.csv (115139, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-08_FE.csv (8708, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-08_FE.csv (1288, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-08_FE.csv (1120, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-08_FE.csv (349537, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-08_FE.csv (1921, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-09_FE.csv (8562, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-09_FE.csv (24480, 32)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-09_FE.csv (115140, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-09_FE.csv (115143, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-09_FE.csv (12908, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-09_FE.csv (22648, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-09_FE.csv (15702, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-09_FE.csv (115132, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-09_FE.csv (115138, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-09_FE.csv (115084, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-09_FE.csv (26370, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-09_FE.csv (77666, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-09_FE.csv (115108, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-09_FE.csv (115122, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-09_FE.csv (1593, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-09_FE.csv (115133, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-09_FE.csv (115113, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-09_FE.csv (10894, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-09_FE.csv (1294, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-09_FE.csv (1192, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-09_FE.csv (348947, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-09_FE.csv (1820, 32)\n"
     ]
    }
   ],
   "source": [
    "name=f\"./Train.csv\"\n",
    "df=pd.read_csv(\"./pcaps\\\\Chime_Doorbell\\\\2019-06-29_FE.csv\")\n",
    "col_names=list(df.columns)\n",
    "\n",
    "empty = pd.DataFrame(columns=col_names)\n",
    "empty.to_csv(name, mode=\"w\", index=False)#,header=False)\n",
    "\n",
    "\n",
    "for i in train:\n",
    "    name_list=find_the_way('./pcaps',i,\"csv\")\n",
    "    for iii in name_list:\n",
    "        df=pd.read_csv(iii)\n",
    "        print(\"name and shape of dataframe :\",iii,df.shape)\n",
    "        df.to_csv(name, mode=\"a\", index=False,header=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "b6eb8342",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-10_FE.csv (8404, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-10_FE.csv (26054, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-10_FE.csv (114916, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-10_FE.csv (115061, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-10_FE.csv (12912, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-10_FE.csv (22216, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-10_FE.csv (15470, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-10_FE.csv (115093, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-10_FE.csv (115124, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-10_FE.csv (114900, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-10_FE.csv (26424, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-10_FE.csv (77561, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-10_FE.csv (114992, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-10_FE.csv (115018, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-10_FE.csv (1232, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-10_FE.csv (114919, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-10_FE.csv (114934, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-10_FE.csv (9072, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-10_FE.csv (1368, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-10_FE.csv (1180, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-10_FE.csv (340583, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-10_FE.csv (1939, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-11_FE.csv (8987, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-11_FE.csv (24460, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-11_FE.csv (115149, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-11_FE.csv (115205, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-11_FE.csv (12908, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-11_FE.csv (20239, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-11_FE.csv (15018, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-11_FE.csv (115125, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-11_FE.csv (115139, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-11_FE.csv (115058, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-11_FE.csv (26383, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-11_FE.csv (77676, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-11_FE.csv (115096, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-11_FE.csv (115124, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-11_FE.csv (3259, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-11_FE.csv (115113, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-11_FE.csv (115114, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-11_FE.csv (8780, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-11_FE.csv (1296, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-11_FE.csv (1152, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-11_FE.csv (346815, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-11_FE.csv (1961, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-12_FE.csv (8481, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-12_FE.csv (24508, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-12_FE.csv (115129, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-12_FE.csv (115140, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-12_FE.csv (12948, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-12_FE.csv (19742, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-12_FE.csv (14202, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-12_FE.csv (115116, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-12_FE.csv (115138, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-12_FE.csv (115156, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-12_FE.csv (26269, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-12_FE.csv (77661, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-12_FE.csv (115108, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-12_FE.csv (115120, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-12_FE.csv (1135, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-12_FE.csv (115144, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-12_FE.csv (115136, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-12_FE.csv (8942, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-12_FE.csv (1418, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-12_FE.csv (1168, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-12_FE.csv (349242, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-12_FE.csv (1948, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-13_FE.csv (8412, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-13_FE.csv (24468, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-13_FE.csv (115136, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-13_FE.csv (115144, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-13_FE.csv (12942, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-13_FE.csv (19364, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-13_FE.csv (13978, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-13_FE.csv (115128, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-13_FE.csv (115150, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-13_FE.csv (115124, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-13_FE.csv (26144, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-13_FE.csv (77680, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-13_FE.csv (115104, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-13_FE.csv (115136, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-13_FE.csv (1150, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-13_FE.csv (115136, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-13_FE.csv (115149, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-13_FE.csv (8940, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-13_FE.csv (1260, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-13_FE.csv (1164, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-13_FE.csv (349557, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-13_FE.csv (1749, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-14_FE.csv (8351, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-14_FE.csv (24484, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-14_FE.csv (115116, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-14_FE.csv (115165, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-14_FE.csv (12928, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-14_FE.csv (19304, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-14_FE.csv (14766, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-14_FE.csv (115129, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-14_FE.csv (115140, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-14_FE.csv (115207, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-14_FE.csv (26351, 32)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-14_FE.csv (77686, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-14_FE.csv (115126, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-14_FE.csv (115136, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-14_FE.csv (829, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-14_FE.csv (115144, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-14_FE.csv (115150, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-14_FE.csv (8791, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-14_FE.csv (1224, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-14_FE.csv (1178, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-14_FE.csv (349913, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-14_FE.csv (2281, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-15_FE.csv (9252, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-15_FE.csv (24520, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-15_FE.csv (115125, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-15_FE.csv (115148, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-15_FE.csv (12922, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-15_FE.csv (19542, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-15_FE.csv (14160, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-15_FE.csv (115133, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-15_FE.csv (115132, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-15_FE.csv (115011, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-15_FE.csv (26358, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-15_FE.csv (77674, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-15_FE.csv (115112, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-15_FE.csv (115128, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-15_FE.csv (3933, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-15_FE.csv (115140, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-15_FE.csv (115116, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-15_FE.csv (7632, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-15_FE.csv (1324, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-15_FE.csv (1164, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-15_FE.csv (348450, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-15_FE.csv (1973, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-16_FE.csv (9302, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-16_FE.csv (24408, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-16_FE.csv (115123, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-16_FE.csv (115144, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-16_FE.csv (12916, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-16_FE.csv (19618, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-16_FE.csv (13804, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-16_FE.csv (115121, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-16_FE.csv (115156, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-16_FE.csv (115174, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-16_FE.csv (26213, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-16_FE.csv (77663, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-16_FE.csv (115128, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-16_FE.csv (115144, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-16_FE.csv (3462, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-16_FE.csv (115132, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-16_FE.csv (115153, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-16_FE.csv (7421, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-16_FE.csv (1372, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-16_FE.csv (1174, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-16_FE.csv (349620, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-16_FE.csv (1939, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-17_FE.csv (9030, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-17_FE.csv (24748, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-17_FE.csv (114966, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-17_FE.csv (115177, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-17_FE.csv (14580, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-17_FE.csv (21360, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-17_FE.csv (14380, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-17_FE.csv (115121, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-17_FE.csv (115137, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-17_FE.csv (114913, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-17_FE.csv (26341, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-17_FE.csv (77640, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-17_FE.csv (115112, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-17_FE.csv (115074, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-17_FE.csv (2922, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-17_FE.csv (115050, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-17_FE.csv (114880, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-17_FE.csv (8296, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-17_FE.csv (1182, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-17_FE.csv (1132, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-17_FE.csv (347617, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-17_FE.csv (2131, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-18_FE.csv (9741, 32)\n",
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-18_FE.csv (24512, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-18_FE.csv (115119, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-18_FE.csv (115189, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-18_FE.csv (19696, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-18_FE.csv (22182, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-18_FE.csv (13838, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-18_FE.csv (115128, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-18_FE.csv (115153, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-18_FE.csv (115241, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-18_FE.csv (26435, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-18_FE.csv (77663, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-18_FE.csv (115103, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-18_FE.csv (115116, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-18_FE.csv (4714, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-18_FE.csv (115132, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-18_FE.csv (115128, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-18_FE.csv (9099, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-18_FE.csv (1318, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-18_FE.csv (1200, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-18_FE.csv (345451, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-18_FE.csv (1950, 32)\n",
      "name and shape of dataframe : ./pcaps\\Chime_Doorbell\\2019-07-19_FE.csv (14618, 32)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "name and shape of dataframe : ./pcaps\\D-Link_Cam936L\\2019-07-19_FE.csv (24578, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_LightBulb\\2019-07-19_FE.csv (117081, 32)\n",
      "name and shape of dataframe : ./pcaps\\Gosuna_Socket\\2019-07-19_FE.csv (116940, 32)\n",
      "name and shape of dataframe : ./pcaps\\Goumia_Coffemaker\\2019-07-19_FE.csv (8952, 32)\n",
      "name and shape of dataframe : ./pcaps\\itTiot_Cam\\2019-07-19_FE.csv (27354, 32)\n",
      "name and shape of dataframe : ./pcaps\\LaCrosse_AlarmClock\\2019-07-19_FE.csv (14360, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb600\\2019-07-19_FE.csv (117053, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_Bulb900\\2019-07-19_FE.csv (117179, 32)\n",
      "name and shape of dataframe : ./pcaps\\Lumiman_SmartPlug\\2019-07-19_FE.csv (116904, 32)\n",
      "name and shape of dataframe : ./pcaps\\Minger_LightStrip\\2019-07-19_FE.csv (27092, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ocean_Radio\\2019-07-19_FE.csv (77662, 32)\n",
      "name and shape of dataframe : ./pcaps\\oossxx_SmartPlug\\2019-07-19_FE.csv (118540, 32)\n",
      "name and shape of dataframe : ./pcaps\\Renpho_SmartPlug\\2019-07-19_FE.csv (117479, 32)\n",
      "name and shape of dataframe : ./pcaps\\Ring_Doorbell\\2019-07-19_FE.csv (7680, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_Lamp\\2019-07-19_FE.csv (117084, 32)\n",
      "name and shape of dataframe : ./pcaps\\Smart_LightStrip\\2019-07-19_FE.csv (117174, 32)\n",
      "name and shape of dataframe : ./pcaps\\Tenvis_Cam\\2019-07-19_FE.csv (8760, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_LightBulb\\2019-07-19_FE.csv (3194, 32)\n",
      "name and shape of dataframe : ./pcaps\\tp-link_SmartPlug\\2019-07-19_FE.csv (3000, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wans_Cam\\2019-07-19_FE.csv (351186, 32)\n",
      "name and shape of dataframe : ./pcaps\\Wemo_SmartPlug\\2019-07-19_FE.csv (2088, 32)\n"
     ]
    }
   ],
   "source": [
    "name=f\"./Test.csv\"\n",
    "df=pd.read_csv(\"./pcaps\\\\Chime_Doorbell\\\\2019-06-29_FE.csv\")\n",
    "col_names=list(df.columns)\n",
    "\n",
    "empty = pd.DataFrame(columns=col_names)\n",
    "empty.to_csv(name, mode=\"w\", index=False)#,header=False)\n",
    "\n",
    "\n",
    "for i in test:\n",
    "    name_list=find_the_way('./pcaps',i,\"csv\")\n",
    "    for iii in name_list:\n",
    "        df=pd.read_csv(iii)\n",
    "        print(\"name and shape of dataframe :\",iii,df.shape)\n",
    "        df.to_csv(name, mode=\"a\", index=False,header=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "36fb7e30",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Label\n",
      "Chime_Doorbell           48940\n",
      "D-Link_Cam936L          246044\n",
      "Gosuna_LightBulb       1152084\n",
      "Gosuna_Socket          1152641\n",
      "Goumia_Coffemaker       116852\n",
      "LaCrosse_AlarmClock      71776\n",
      "Lumiman_Bulb600        1152433\n",
      "Lumiman_Bulb900        1152614\n",
      "Lumiman_SmartPlug      1151754\n",
      "Minger_LightStrip       148484\n",
      "Ocean_Radio             776060\n",
      "Renpho_SmartPlug       1152639\n",
      "Ring_Doorbell            16532\n",
      "Smart_Lamp             1152226\n",
      "Smart_LightStrip       1152076\n",
      "Tenvis_Cam               73789\n",
      "UNK                    2012178\n",
      "Wans_Cam               1801892\n",
      "Wemo_SmartPlug           12173\n",
      "itTiot_Cam              178937\n",
      "oossxx_SmartPlug       1153631\n",
      "tp-link_LightBulb         8896\n",
      "tp-link_SmartPlug         8034\n",
      "dtype: int64\n",
      "Label\n",
      "Chime_Doorbell           43963\n",
      "D-Link_Cam936L          232130\n",
      "Gosuna_LightBulb       1127085\n",
      "Gosuna_Socket          1128396\n",
      "Goumia_Coffemaker       128400\n",
      "LaCrosse_AlarmClock      81286\n",
      "Lumiman_Bulb600        1127960\n",
      "Lumiman_Bulb900        1127727\n",
      "Lumiman_SmartPlug      1121682\n",
      "Minger_LightStrip       145885\n",
      "Ocean_Radio             662733\n",
      "Renpho_SmartPlug       1127448\n",
      "Ring_Doorbell             8436\n",
      "Smart_Lamp             1128616\n",
      "Smart_LightStrip       1130527\n",
      "Tenvis_Cam               59654\n",
      "UNK                    1950451\n",
      "Wans_Cam               1775729\n",
      "Wemo_SmartPlug           10487\n",
      "itTiot_Cam              131614\n",
      "oossxx_SmartPlug       1128646\n",
      "tp-link_LightBulb         7351\n",
      "tp-link_SmartPlug         6626\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "files=[\"./Test.csv\",\"./Train.csv\"]\n",
    "\n",
    "for i in files:\n",
    "    df=pd.read_csv(i)#,usecols=[\"Label\"])\n",
    "    print(df.groupby(\"Label\").size())\n",
    "    df=df.sample(n=len(df)//10, random_state=42)\n",
    "    df.to_csv(i, index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "03c7fa3d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}