Timewise_Equipment_Working.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Timewise_Equipment_Working.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyPk0CtrHqiybL9j7Ulhr74C",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/RachitBansal/AppliancePower_TimeSeries/blob/master/Timewise_Equipment_Working.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "I8xEFYl3SYfo",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n",
        "import os"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "59hAQYQ9SgCX",
        "colab_type": "code",
        "outputId": "0f68c7dc-761f-4e00-f001-df16480e69c4",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 131
        }
      },
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Go to this URL in a browser: https://accounts.google.com/o/oauth2/auth?client_id=947318989803-6bn6qk8qdgf4n4g3pfee6491hc0brc4i.apps.googleusercontent.com&redirect_uri=urn%3aietf%3awg%3aoauth%3a2.0%3aoob&response_type=code&scope=email%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdocs.test%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive.photos.readonly%20https%3a%2f%2fwww.googleapis.com%2fauth%2fpeopleapi.readonly\n",
            "\n",
            "Enter your authorization code:\n",
            "··········\n",
            "Mounted at /content/drive\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Lxb9QlmpS4d5",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#equip = int(input())\n",
        "#filepath= \"./drive/My Drive/uk dale dataset/ONN_OFF /equipment{}\".format(equip)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZIatXO8hS_7T",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "saved_path =\"./drive/My Drive/uk dale dataset/ONN_OFF /\"\n",
        "equipment_list = os.listdir(saved_path)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lY-OXd6KTWpL",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "path = \"./drive/My Drive/uk dale dataset/ONN_OFF /\""
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "F-DesLjESnVz",
        "colab_type": "code",
        "outputId": "8b92b65a-5677-4939-cb3b-e7d7808ef94d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 56
        }
      },
      "source": [
        "print(equipment_list)"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "['equipment2.npy', 'equipment1.npy', 'equipment3.npy', 'equipment5.npy', 'equipment6.npy', 'equipment8.npy', 'equipment9.npy', 'equipment10.npy', 'equipment11.npy', 'equipment12.npy', 'equipment13.npy', 'equipment14.npy', 'equipment15.npy', 'equipment16.npy', 'equipment23.npy', 'equipment24.npy', 'equipment25.npy', 'equipment26.npy', 'equipment28.npy', 'equipment29.npy']\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MJOlnYKdUlio",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def equipment_loader(file_path,equipments):\n",
        "      \n",
        "    equip_dict = {}\n",
        "    for equipment in equipments:\n",
        "        equip_data = np.load(file_path+equipment)\n",
        "        equipment = equipment[:-4]\n",
        "        equip_data = list(equip_data)\n",
        "        equip_data = [ x for x in equip_data if x!= '0']\n",
        "        equip_dict[equipment] = list(equip_data)\n",
        "    return equip_dict"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1bw7sT79Uxef",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "equipments_data = equipment_loader(path,equipment_list)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ds6ZBZQnWVY6",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def DateString():\n",
        "    date = input(\"Enter Date : \")\n",
        "    month = input(\"Enter Month : \")\n",
        "    year = input(\"Enter Year : \")\n",
        "    Date= [date,month,year]\n",
        "    Date ='-'.join(Date) \n",
        "    return Date"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Kvd1sH_xX4qJ",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "sample = equipments_data[\"equipment1\"][:2000]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_FUwSLLooHeo",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 56
        },
        "outputId": "c7a47b1b-5d96-4ed9-ab2b-b408dced861c"
      },
      "source": [
        "date ='2012-11-12' \n",
        "day_index = [x for x in sample if date in x ]\n",
        "print(day_index)"
      ],
      "execution_count": 34,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "['2012-11-12 00:00:00', '2012-11-12 00:05:00', '2012-11-12 00:10:00', '2012-11-12 00:15:00', '2012-11-12 00:20:00', '2012-11-12 00:25:00', '2012-11-12 00:30:00', '2012-11-12 00:35:00', '2012-11-12 00:40:00', '2012-11-12 00:45:00', '2012-11-12 00:50:00', '2012-11-12 00:55:00', '2012-11-12 01:00:00', '2012-11-12 01:05:00', '2012-11-12 01:10:00', '2012-11-12 01:15:00', '2012-11-12 01:20:00', '2012-11-12 01:25:00', '2012-11-12 01:30:00', '2012-11-12 01:35:00', '2012-11-12 01:40:00', '2012-11-12 01:45:00', '2012-11-12 01:50:00', '2012-11-12 01:55:00', '2012-11-12 02:00:00', '2012-11-12 02:05:00', '2012-11-12 02:10:00', '2012-11-12 02:15:00', '2012-11-12 02:20:00', '2012-11-12 02:25:00', '2012-11-12 02:30:00', '2012-11-12 02:35:00', '2012-11-12 02:40:00', '2012-11-12 02:45:00', '2012-11-12 02:50:00', '2012-11-12 02:55:00', '2012-11-12 03:00:00', '2012-11-12 03:05:00', '2012-11-12 03:10:00', '2012-11-12 03:15:00', '2012-11-12 03:20:00', '2012-11-12 03:25:00', '2012-11-12 03:30:00', '2012-11-12 03:35:00', '2012-11-12 03:40:00', '2012-11-12 03:45:00', '2012-11-12 03:50:00', '2012-11-12 03:55:00', '2012-11-12 04:00:00', '2012-11-12 04:05:00', '2012-11-12 04:10:00', '2012-11-12 04:15:00', '2012-11-12 04:20:00', '2012-11-12 04:25:00', '2012-11-12 04:30:00', '2012-11-12 04:35:00', '2012-11-12 04:40:00', '2012-11-12 04:45:00', '2012-11-12 04:50:00', '2012-11-12 04:55:00', '2012-11-12 05:00:00', '2012-11-12 05:05:00', '2012-11-12 05:10:00', '2012-11-12 05:15:00', '2012-11-12 05:20:00', '2012-11-12 05:25:00', '2012-11-12 05:30:00', '2012-11-12 05:35:00', '2012-11-12 05:40:00', '2012-11-12 05:45:00', '2012-11-12 05:50:00', '2012-11-12 05:55:00', '2012-11-12 06:00:00', '2012-11-12 06:05:00', '2012-11-12 06:10:00', '2012-11-12 06:15:00', '2012-11-12 06:20:00', '2012-11-12 06:25:00', '2012-11-12 06:30:00', '2012-11-12 06:35:00', '2012-11-12 06:40:00', '2012-11-12 06:45:00', '2012-11-12 06:50:00', '2012-11-12 06:55:00', '2012-11-12 07:00:00', '2012-11-12 07:05:00', '2012-11-12 07:10:00', '2012-11-12 07:15:00', '2012-11-12 07:20:00', '2012-11-12 07:25:00', '2012-11-12 07:30:00', '2012-11-12 07:35:00', '2012-11-12 07:40:00', '2012-11-12 07:45:00', '2012-11-12 07:50:00', '2012-11-12 07:55:00', '2012-11-12 08:00:00', '2012-11-12 08:05:00', '2012-11-12 08:10:00', '2012-11-12 08:15:00', '2012-11-12 08:20:00', '2012-11-12 08:25:00', '2012-11-12 08:30:00', '2012-11-12 08:35:00', '2012-11-12 08:40:00', '2012-11-12 08:45:00', '2012-11-12 08:50:00', '2012-11-12 08:55:00', '2012-11-12 09:00:00', '2012-11-12 09:05:00', '2012-11-12 09:10:00', '2012-11-12 09:15:00', '2012-11-12 09:20:00', '2012-11-12 09:25:00', '2012-11-12 09:30:00', '2012-11-12 09:35:00', '2012-11-12 09:40:00', '2012-11-12 09:45:00', '2012-11-12 09:50:00', '2012-11-12 09:55:00', '2012-11-12 10:00:00', '2012-11-12 10:05:00', '2012-11-12 10:10:00', '2012-11-12 10:15:00', '2012-11-12 10:20:00', '2012-11-12 10:25:00', '2012-11-12 10:30:00', '2012-11-12 10:35:00', '2012-11-12 10:40:00', '2012-11-12 10:45:00', '2012-11-12 10:50:00', '2012-11-12 10:55:00', '2012-11-12 11:00:00', '2012-11-12 11:05:00', '2012-11-12 11:10:00', '2012-11-12 11:15:00', '2012-11-12 11:20:00', '2012-11-12 11:25:00', '2012-11-12 11:30:00', '2012-11-12 11:35:00', '2012-11-12 11:40:00', '2012-11-12 11:45:00', '2012-11-12 11:50:00', '2012-11-12 11:55:00', '2012-11-12 12:00:00', '2012-11-12 12:05:00', '2012-11-12 12:10:00', '2012-11-12 12:15:00', '2012-11-12 12:20:00', '2012-11-12 12:25:00', '2012-11-12 12:30:00', '2012-11-12 12:35:00', '2012-11-12 12:40:00', '2012-11-12 12:45:00', '2012-11-12 12:50:00', '2012-11-12 12:55:00', '2012-11-12 13:00:00', '2012-11-12 13:05:00', '2012-11-12 13:10:00', '2012-11-12 13:15:00', '2012-11-12 13:20:00', '2012-11-12 13:25:00', '2012-11-12 13:30:00', '2012-11-12 13:35:00', '2012-11-12 13:40:00', '2012-11-12 13:45:00', '2012-11-12 13:50:00', '2012-11-12 13:55:00', '2012-11-12 14:00:00', '2012-11-12 14:05:00', '2012-11-12 14:10:00', '2012-11-12 14:15:00', '2012-11-12 14:20:00', '2012-11-12 14:25:00', '2012-11-12 14:30:00', '2012-11-12 14:35:00', '2012-11-12 14:40:00', '2012-11-12 14:45:00', '2012-11-12 14:50:00', '2012-11-12 14:55:00', '2012-11-12 15:00:00', '2012-11-12 15:05:00', '2012-11-12 15:10:00', '2012-11-12 15:15:00', '2012-11-12 15:20:00', '2012-11-12 15:25:00', '2012-11-12 15:30:00', '2012-11-12 15:35:00', '2012-11-12 15:40:00', '2012-11-12 15:45:00', '2012-11-12 15:50:00', '2012-11-12 15:55:00', '2012-11-12 16:00:00', '2012-11-12 16:05:00', '2012-11-12 16:10:00', '2012-11-12 16:15:00', '2012-11-12 16:20:00', '2012-11-12 16:25:00', '2012-11-12 16:30:00', '2012-11-12 16:35:00', '2012-11-12 16:40:00', '2012-11-12 16:45:00', '2012-11-12 16:50:00', '2012-11-12 16:55:00', '2012-11-12 17:00:00', '2012-11-12 17:05:00', '2012-11-12 17:10:00', '2012-11-12 17:15:00', '2012-11-12 17:20:00', '2012-11-12 17:25:00', '2012-11-12 18:25:00', '2012-11-12 18:30:00', '2012-11-12 18:35:00', '2012-11-12 18:40:00', '2012-11-12 18:45:00', '2012-11-12 18:50:00', '2012-11-12 18:55:00', '2012-11-12 19:00:00', '2012-11-12 19:05:00', '2012-11-12 19:10:00', '2012-11-12 19:15:00', '2012-11-12 19:20:00', '2012-11-12 19:25:00', '2012-11-12 19:30:00', '2012-11-12 19:35:00', '2012-11-12 19:40:00', '2012-11-12 19:45:00', '2012-11-12 19:50:00', '2012-11-12 19:55:00', '2012-11-12 20:00:00', '2012-11-12 20:05:00', '2012-11-12 20:40:00', '2012-11-12 20:45:00', '2012-11-12 20:50:00', '2012-11-12 20:55:00', '2012-11-12 21:00:00', '2012-11-12 21:05:00', '2012-11-12 21:10:00', '2012-11-12 21:15:00', '2012-11-12 21:20:00', '2012-11-12 21:25:00', '2012-11-12 21:30:00', '2012-11-12 21:35:00', '2012-11-12 21:40:00', '2012-11-12 21:45:00', '2012-11-12 21:50:00', '2012-11-12 21:55:00', '2012-11-12 22:00:00', '2012-11-12 22:05:00', '2012-11-12 22:10:00', '2012-11-12 22:15:00', '2012-11-12 22:20:00', '2012-11-12 22:25:00', '2012-11-12 22:30:00', '2012-11-12 22:35:00', '2012-11-12 22:40:00', '2012-11-12 22:45:00', '2012-11-12 22:50:00', '2012-11-12 22:55:00', '2012-11-12 23:00:00', '2012-11-12 23:05:00', '2012-11-12 23:10:00', '2012-11-12 23:15:00', '2012-11-12 23:20:00', '2012-11-12 23:25:00', '2012-11-12 23:30:00', '2012-11-12 23:35:00', '2012-11-12 23:40:00', '2012-11-12 23:45:00', '2012-11-12 23:50:00', '2012-11-12 23:55:00']\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EcIT8idqnM4O",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def DayDataExtraction(Data,equipment_list,Date):\n",
        "    day_data = {}\n",
        "    for equipment in equipment_list:\n",
        "        equipment = equipment[:-4]\n",
        "        e_data = list(Data[equipment])\n",
        "        e_data = [ x for x in e_data if Date in x]\n",
        "        day_data[equipment] = e_data\n",
        "    cleaned_day_data = {}    \n",
        "    for equipment in day_data.keys():\n",
        "        if len(day_data[equipment])==0:\n",
        "            continue\n",
        "        else:\n",
        "            cleaned_day_data[equipment] = day_data[equipment]\n",
        "    no_of_equipment_w = len(cleaned_day_data.keys()) \n",
        "    print(\"No of equipment working on {%s} are :\"%(Date),end = \" \")\n",
        "    print(no_of_equipment_w)       \n",
        "    return cleaned_day_data    "
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1c11Y-6qoLCd",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 36
        },
        "outputId": "fed4d856-1d93-4f12-e8c3-f31d542d80a9"
      },
      "source": [
        "day_data = DayDataExtraction(equipments_data,equipment_list,'2013-02-01')"
      ],
      "execution_count": 66,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "No of equipment working on {2013-02-01} are : 10\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ywDSwI7drE0w",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "hour = ['00','01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23']\n",
        "minute = ['00','05']\n",
        "for x in range(10,60):\n",
        "    if x%5==0:\n",
        "        minute.append(str(x))\n",
        "second = '00'"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "yAdAKrTF3qOa",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def HourDataExtraction(Data,Date,HourTime,equipment_list):\n",
        "    day_ = DayDataExtraction(Data,equipment_list,Date)\n",
        "    print(day_)\n",
        "    temp_list = [Date,HourTime[:2]]\n",
        "    temp_time = ' '.join(temp_list)\n",
        "    hourwise_data = {}\n",
        "    for equip in day_.keys():\n",
        "        temp_data = list(Data[equip])\n",
        "        temp_data = [ x for x in temp_data if temp_time in x]\n",
        "        if len(temp_data)==0:\n",
        "            continue\n",
        "        else:\n",
        "            hourwise_data[equip] = temp_data\n",
        "    print(\"No of equipments working at %s %s are :\"%(Date,HourTime),end =\" \")\n",
        "    print(len(hourwise_data.keys()))       \n",
        "    return hourwise_data       "
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jaiJg1Wi61kd",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "ce007695-b867-40c7-f256-2e02ee6445f4"
      },
      "source": [
        "HourDataExtraction(equipments_data,'2013-02-01','12:00:00',equipment_list)"
      ],
      "execution_count": 79,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "No of equipment working on {2013-02-01} are : 10\n",
            "{'equipment2': ['2013-02-01 11:05:00', '2013-02-01 11:10:00', '2013-02-01 11:20:00', '2013-02-01 11:25:00', '2013-02-01 11:30:00', '2013-02-01 11:35:00', '2013-02-01 11:40:00', '2013-02-01 11:45:00', '2013-02-01 11:50:00', '2013-02-01 11:55:00', '2013-02-01 12:00:00', '2013-02-01 12:05:00', '2013-02-01 12:10:00', '2013-02-01 12:15:00', '2013-02-01 12:20:00', '2013-02-01 12:25:00', '2013-02-01 12:30:00', '2013-02-01 12:35:00', '2013-02-01 12:40:00', '2013-02-01 12:45:00', '2013-02-01 12:50:00', '2013-02-01 12:55:00', '2013-02-01 13:00:00', '2013-02-01 13:05:00', '2013-02-01 13:10:00', '2013-02-01 13:15:00', '2013-02-01 13:20:00', '2013-02-01 13:25:00', '2013-02-01 13:30:00', '2013-02-01 13:35:00', '2013-02-01 13:40:00', '2013-02-01 13:45:00', '2013-02-01 13:50:00', '2013-02-01 13:55:00', '2013-02-01 14:00:00', '2013-02-01 14:05:00', '2013-02-01 14:15:00', '2013-02-01 14:20:00', '2013-02-01 14:25:00', '2013-02-01 17:55:00', '2013-02-01 18:00:00', '2013-02-01 18:05:00', '2013-02-01 18:10:00', '2013-02-01 18:15:00', '2013-02-01 18:20:00', '2013-02-01 18:25:00', '2013-02-01 18:30:00', '2013-02-01 18:35:00', '2013-02-01 18:40:00', '2013-02-01 18:45:00', '2013-02-01 18:50:00', '2013-02-01 18:55:00', '2013-02-01 19:00:00', '2013-02-01 19:05:00', '2013-02-01 19:10:00', '2013-02-01 19:15:00', '2013-02-01 19:20:00', '2013-02-01 19:25:00', '2013-02-01 19:30:00', '2013-02-01 19:35:00', '2013-02-01 19:40:00', '2013-02-01 19:45:00', '2013-02-01 19:50:00', '2013-02-01 19:55:00', '2013-02-01 20:00:00', '2013-02-01 20:05:00', '2013-02-01 20:10:00', '2013-02-01 20:15:00', '2013-02-01 21:05:00', '2013-02-01 21:10:00', '2013-02-01 21:15:00', '2013-02-01 21:20:00', '2013-02-01 21:25:00', '2013-02-01 21:30:00', '2013-02-01 21:35:00', '2013-02-01 21:40:00', '2013-02-01 21:45:00', '2013-02-01 21:50:00', '2013-02-01 21:55:00', '2013-02-01 22:00:00', '2013-02-01 22:05:00', '2013-02-01 22:10:00', '2013-02-01 22:15:00', '2013-02-01 22:20:00', '2013-02-01 22:25:00', '2013-02-01 22:30:00', '2013-02-01 22:35:00', '2013-02-01 22:40:00', '2013-02-01 22:45:00', '2013-02-01 22:50:00', '2013-02-01 22:55:00', '2013-02-01 23:00:00', '2013-02-01 23:05:00', '2013-02-01 23:10:00', '2013-02-01 23:15:00', '2013-02-01 23:20:00', '2013-02-01 23:25:00', '2013-02-01 23:30:00', '2013-02-01 23:35:00', '2013-02-01 23:40:00', '2013-02-01 23:45:00', '2013-02-01 23:50:00', '2013-02-01 23:55:00'], 'equipment3': ['2013-02-01 12:25:00', '2013-02-01 12:45:00', '2013-02-01 12:55:00', '2013-02-01 13:00:00', '2013-02-01 13:05:00', '2013-02-01 13:10:00', '2013-02-01 13:15:00', '2013-02-01 13:20:00', '2013-02-01 13:25:00', '2013-02-01 13:50:00'], 'equipment8': ['2013-02-01 13:40:00', '2013-02-01 13:45:00', '2013-02-01 17:55:00', '2013-02-01 18:00:00', '2013-02-01 18:05:00', '2013-02-01 18:10:00', '2013-02-01 18:15:00', '2013-02-01 18:20:00', '2013-02-01 18:25:00', '2013-02-01 18:30:00', '2013-02-01 18:35:00', '2013-02-01 18:40:00', '2013-02-01 18:45:00', '2013-02-01 20:05:00', '2013-02-01 21:20:00', '2013-02-01 21:25:00', '2013-02-01 21:30:00', '2013-02-01 23:50:00'], 'equipment9': ['2013-02-01 11:05:00', '2013-02-01 11:10:00', '2013-02-01 11:20:00', '2013-02-01 11:25:00', '2013-02-01 11:30:00', '2013-02-01 11:35:00', '2013-02-01 11:40:00', '2013-02-01 11:45:00', '2013-02-01 11:50:00', '2013-02-01 11:55:00', '2013-02-01 12:00:00', '2013-02-01 12:05:00', '2013-02-01 12:10:00', '2013-02-01 12:15:00', '2013-02-01 12:20:00', '2013-02-01 12:25:00', '2013-02-01 12:30:00', '2013-02-01 12:35:00', '2013-02-01 12:40:00', '2013-02-01 12:45:00', '2013-02-01 12:50:00', '2013-02-01 12:55:00', '2013-02-01 13:00:00', '2013-02-01 13:05:00', '2013-02-01 13:10:00', '2013-02-01 13:15:00', '2013-02-01 13:20:00', '2013-02-01 13:25:00', '2013-02-01 13:30:00', '2013-02-01 13:35:00', '2013-02-01 13:40:00', '2013-02-01 13:45:00', '2013-02-01 13:50:00', '2013-02-01 13:55:00', '2013-02-01 14:00:00', '2013-02-01 14:05:00', '2013-02-01 14:15:00', '2013-02-01 14:20:00', '2013-02-01 14:25:00', '2013-02-01 17:55:00', '2013-02-01 18:00:00', '2013-02-01 18:05:00', '2013-02-01 18:10:00', '2013-02-01 18:15:00', '2013-02-01 18:20:00', '2013-02-01 18:25:00', '2013-02-01 18:30:00', '2013-02-01 18:35:00', '2013-02-01 18:40:00', '2013-02-01 18:45:00', '2013-02-01 18:50:00', '2013-02-01 18:55:00', '2013-02-01 19:00:00', '2013-02-01 19:05:00', '2013-02-01 19:10:00', '2013-02-01 19:15:00', '2013-02-01 19:20:00', '2013-02-01 19:25:00', '2013-02-01 19:30:00', '2013-02-01 19:35:00', '2013-02-01 19:40:00', '2013-02-01 19:45:00', '2013-02-01 19:50:00', '2013-02-01 19:55:00', '2013-02-01 20:00:00', '2013-02-01 20:05:00', '2013-02-01 20:10:00', '2013-02-01 20:15:00', '2013-02-01 21:05:00', '2013-02-01 21:10:00', '2013-02-01 21:15:00', '2013-02-01 21:20:00', '2013-02-01 21:25:00', '2013-02-01 21:30:00', '2013-02-01 21:35:00', '2013-02-01 21:40:00', '2013-02-01 21:45:00', '2013-02-01 21:50:00', '2013-02-01 21:55:00', '2013-02-01 22:00:00', '2013-02-01 22:05:00', '2013-02-01 22:10:00', '2013-02-01 22:15:00', '2013-02-01 22:20:00', '2013-02-01 22:25:00', '2013-02-01 22:30:00', '2013-02-01 22:35:00', '2013-02-01 22:40:00', '2013-02-01 22:45:00', '2013-02-01 22:50:00', '2013-02-01 22:55:00', '2013-02-01 23:00:00', '2013-02-01 23:05:00', '2013-02-01 23:10:00', '2013-02-01 23:15:00', '2013-02-01 23:20:00', '2013-02-01 23:25:00', '2013-02-01 23:30:00', '2013-02-01 23:35:00', '2013-02-01 23:40:00', '2013-02-01 23:45:00', '2013-02-01 23:50:00', '2013-02-01 23:55:00'], 'equipment10': ['2013-02-01 12:05:00', '2013-02-01 12:10:00', '2013-02-01 13:40:00', '2013-02-01 13:45:00'], 'equipment11': ['2013-02-01 18:05:00', '2013-02-01 18:10:00', '2013-02-01 21:25:00', '2013-02-01 23:50:00', '2013-02-01 23:55:00'], 'equipment12': ['2013-02-01 11:25:00', '2013-02-01 11:30:00', '2013-02-01 11:35:00', '2013-02-01 11:40:00', '2013-02-01 11:45:00', '2013-02-01 11:50:00', '2013-02-01 11:55:00', '2013-02-01 12:10:00', '2013-02-01 12:15:00', '2013-02-01 12:20:00', '2013-02-01 12:35:00', '2013-02-01 12:40:00', '2013-02-01 12:45:00', '2013-02-01 12:50:00', '2013-02-01 12:55:00', '2013-02-01 13:00:00', '2013-02-01 13:05:00', '2013-02-01 13:10:00', '2013-02-01 13:15:00', '2013-02-01 13:20:00', '2013-02-01 13:25:00', '2013-02-01 13:55:00', '2013-02-01 14:00:00', '2013-02-01 14:05:00', '2013-02-01 14:20:00', '2013-02-01 17:55:00', '2013-02-01 18:00:00', '2013-02-01 18:05:00', '2013-02-01 18:10:00', '2013-02-01 18:15:00', '2013-02-01 18:25:00', '2013-02-01 18:30:00', '2013-02-01 18:35:00', '2013-02-01 18:40:00', '2013-02-01 18:45:00', '2013-02-01 18:50:00', '2013-02-01 18:55:00', '2013-02-01 19:05:00', '2013-02-01 19:10:00', '2013-02-01 19:15:00', '2013-02-01 19:20:00', '2013-02-01 19:25:00', '2013-02-01 19:30:00', '2013-02-01 19:35:00', '2013-02-01 19:40:00', '2013-02-01 19:45:00', '2013-02-01 20:05:00', '2013-02-01 21:05:00', '2013-02-01 21:10:00', '2013-02-01 21:15:00', '2013-02-01 21:20:00', '2013-02-01 21:25:00', '2013-02-01 21:30:00', '2013-02-01 21:35:00', '2013-02-01 22:15:00', '2013-02-01 22:20:00', '2013-02-01 22:25:00', '2013-02-01 23:20:00', '2013-02-01 23:25:00', '2013-02-01 23:30:00', '2013-02-01 23:35:00', '2013-02-01 23:40:00', '2013-02-01 23:45:00', '2013-02-01 23:50:00', '2013-02-01 23:55:00'], 'equipment13': ['2013-02-01 18:45:00'], 'equipment14': ['2013-02-01 11:05:00', '2013-02-01 11:10:00', '2013-02-01 11:20:00', '2013-02-01 11:25:00', '2013-02-01 11:45:00', '2013-02-01 11:50:00', '2013-02-01 11:55:00', '2013-02-01 12:00:00', '2013-02-01 12:05:00', '2013-02-01 12:10:00', '2013-02-01 12:15:00', '2013-02-01 12:20:00', '2013-02-01 12:25:00', '2013-02-01 12:30:00', '2013-02-01 12:35:00', '2013-02-01 12:40:00', '2013-02-01 12:45:00', '2013-02-01 12:50:00', '2013-02-01 12:55:00', '2013-02-01 13:00:00', '2013-02-01 13:05:00', '2013-02-01 13:10:00', '2013-02-01 13:15:00', '2013-02-01 13:20:00', '2013-02-01 13:25:00', '2013-02-01 13:30:00', '2013-02-01 13:35:00', '2013-02-01 13:40:00', '2013-02-01 13:45:00', '2013-02-01 13:50:00', '2013-02-01 13:55:00', '2013-02-01 14:00:00', '2013-02-01 14:05:00', '2013-02-01 14:15:00', '2013-02-01 14:20:00', '2013-02-01 14:25:00', '2013-02-01 17:55:00', '2013-02-01 18:00:00', '2013-02-01 20:05:00', '2013-02-01 20:10:00', '2013-02-01 20:15:00', '2013-02-01 21:05:00', '2013-02-01 21:10:00', '2013-02-01 21:15:00', '2013-02-01 21:20:00', '2013-02-01 21:25:00', '2013-02-01 21:30:00', '2013-02-01 21:35:00', '2013-02-01 21:40:00', '2013-02-01 21:45:00', '2013-02-01 21:50:00', '2013-02-01 21:55:00', '2013-02-01 22:00:00', '2013-02-01 22:05:00', '2013-02-01 22:10:00', '2013-02-01 22:15:00', '2013-02-01 22:20:00', '2013-02-01 22:25:00', '2013-02-01 22:30:00', '2013-02-01 22:35:00', '2013-02-01 22:40:00', '2013-02-01 22:45:00', '2013-02-01 22:50:00', '2013-02-01 22:55:00', '2013-02-01 23:00:00', '2013-02-01 23:05:00', '2013-02-01 23:10:00', '2013-02-01 23:15:00', '2013-02-01 23:20:00', '2013-02-01 23:25:00', '2013-02-01 23:30:00', '2013-02-01 23:35:00', '2013-02-01 23:40:00', '2013-02-01 23:45:00', '2013-02-01 23:50:00', '2013-02-01 23:55:00'], 'equipment15': ['2013-02-01 11:05:00', '2013-02-01 11:10:00', '2013-02-01 11:20:00', '2013-02-01 11:25:00', '2013-02-01 11:30:00', '2013-02-01 11:35:00', '2013-02-01 11:40:00', '2013-02-01 11:45:00', '2013-02-01 11:50:00', '2013-02-01 11:55:00', '2013-02-01 12:00:00', '2013-02-01 12:05:00']}\n",
            "No of equipments working at 2013-02-01 12:00:00 are : 7\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'equipment10': ['2013-02-01 12:05:00', '2013-02-01 12:10:00'],\n",
              " 'equipment12': ['2013-02-01 12:10:00',\n",
              "  '2013-02-01 12:15:00',\n",
              "  '2013-02-01 12:20:00',\n",
              "  '2013-02-01 12:35:00',\n",
              "  '2013-02-01 12:40:00',\n",
              "  '2013-02-01 12:45:00',\n",
              "  '2013-02-01 12:50:00',\n",
              "  '2013-02-01 12:55:00'],\n",
              " 'equipment14': ['2013-02-01 12:00:00',\n",
              "  '2013-02-01 12:05:00',\n",
              "  '2013-02-01 12:10:00',\n",
              "  '2013-02-01 12:15:00',\n",
              "  '2013-02-01 12:20:00',\n",
              "  '2013-02-01 12:25:00',\n",
              "  '2013-02-01 12:30:00',\n",
              "  '2013-02-01 12:35:00',\n",
              "  '2013-02-01 12:40:00',\n",
              "  '2013-02-01 12:45:00',\n",
              "  '2013-02-01 12:50:00',\n",
              "  '2013-02-01 12:55:00'],\n",
              " 'equipment15': ['2013-02-01 12:00:00', '2013-02-01 12:05:00'],\n",
              " 'equipment2': ['2013-02-01 12:00:00',\n",
              "  '2013-02-01 12:05:00',\n",
              "  '2013-02-01 12:10:00',\n",
              "  '2013-02-01 12:15:00',\n",
              "  '2013-02-01 12:20:00',\n",
              "  '2013-02-01 12:25:00',\n",
              "  '2013-02-01 12:30:00',\n",
              "  '2013-02-01 12:35:00',\n",
              "  '2013-02-01 12:40:00',\n",
              "  '2013-02-01 12:45:00',\n",
              "  '2013-02-01 12:50:00',\n",
              "  '2013-02-01 12:55:00'],\n",
              " 'equipment3': ['2013-02-01 12:25:00',\n",
              "  '2013-02-01 12:45:00',\n",
              "  '2013-02-01 12:55:00'],\n",
              " 'equipment9': ['2013-02-01 12:00:00',\n",
              "  '2013-02-01 12:05:00',\n",
              "  '2013-02-01 12:10:00',\n",
              "  '2013-02-01 12:15:00',\n",
              "  '2013-02-01 12:20:00',\n",
              "  '2013-02-01 12:25:00',\n",
              "  '2013-02-01 12:30:00',\n",
              "  '2013-02-01 12:35:00',\n",
              "  '2013-02-01 12:40:00',\n",
              "  '2013-02-01 12:45:00',\n",
              "  '2013-02-01 12:50:00',\n",
              "  '2013-02-01 12:55:00']}"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 79
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "unVB8HYd6-uJ",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}