Cluster.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 377,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "import plotly\n",
    "import plotly.plotly as py\n",
    "import plotly.graph_objs as go\n",
    "\n",
    "plotly.tools.set_credentials_file(username='iremoze', api_key='zzzzz')\n",
    "\n",
    "from sklearn.cluster import DBSCAN\n",
    "from collections import Counter\n",
    "import matplotlib.pyplot as plt\n",
    "from sklearn.decomposition import PCA\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 378,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel('Comapany1(DF).xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 379,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date/time occurrence</th>\n",
       "      <th>End devices</th>\n",
       "      <th>Malicious code</th>\n",
       "      <th>Respnse</th>\n",
       "      <th>Type of malware</th>\n",
       "      <th>Details</th>\n",
       "      <th>new_time</th>\n",
       "      <th>new_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-01-02 07:58:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:58:00</td>\n",
       "      <td>2017-01-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-01-03 07:57:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:57:00</td>\n",
       "      <td>2017-01-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-01-03 08:02:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:02:00</td>\n",
       "      <td>2017-01-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-01-03 10:16:00</td>\n",
       "      <td>2f</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>10:16:00</td>\n",
       "      <td>2017-01-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-01-03 16:30:00</td>\n",
       "      <td>2f</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>16:30:00</td>\n",
       "      <td>2017-01-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2017-01-04 08:29:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:29:00</td>\n",
       "      <td>2017-01-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017-01-05 07:58:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:58:00</td>\n",
       "      <td>2017-01-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017-01-06 07:56:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:56:00</td>\n",
       "      <td>2017-01-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017-01-07 08:03:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:03:00</td>\n",
       "      <td>2017-01-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017-01-09 08:06:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:06:00</td>\n",
       "      <td>2017-01-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2017-01-09 10:35:00</td>\n",
       "      <td>2f</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>10:35:00</td>\n",
       "      <td>2017-01-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2017-01-10 08:02:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:02:00</td>\n",
       "      <td>2017-01-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2017-01-11 08:00:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:00:00</td>\n",
       "      <td>2017-01-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2017-01-12 07:57:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:57:00</td>\n",
       "      <td>2017-01-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2017-01-12 09:25:00</td>\n",
       "      <td>hp</td>\n",
       "      <td>Trojan-Downloader:JS/Kavala.P</td>\n",
       "      <td>deleted</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\John\\AppData\\Local\\Microsoft\\Windows\\...</td>\n",
       "      <td>09:25:00</td>\n",
       "      <td>2017-01-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2017-01-12 09:26:00</td>\n",
       "      <td>hp</td>\n",
       "      <td>Trojan-Downloader:JS/Kavala.P</td>\n",
       "      <td>segregated</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\John\\AppData\\Local\\Microsoft\\Windows\\...</td>\n",
       "      <td>09:26:00</td>\n",
       "      <td>2017-01-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017-01-13 09:28:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>09:28:00</td>\n",
       "      <td>2017-01-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2017-01-15 08:08:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:08:00</td>\n",
       "      <td>2017-01-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2017-01-15 09:17:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Application:W32/Generic.4a143fc08b!Online</td>\n",
       "      <td>segregated</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Program Files\\AESCrypt\\aescrypt.exe</td>\n",
       "      <td>09:17:00</td>\n",
       "      <td>2017-01-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2017-01-16 08:03:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:03:00</td>\n",
       "      <td>2017-01-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2017-01-16 10:05:00</td>\n",
       "      <td>2f</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>10:05:00</td>\n",
       "      <td>2017-01-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2017-01-17 08:18:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:18:00</td>\n",
       "      <td>2017-01-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2017-01-17 08:37:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:37:00</td>\n",
       "      <td>2017-01-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2017-01-17 09:23:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>09:23:00</td>\n",
       "      <td>2017-01-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2017-01-17 09:28:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>a720dfafeb3ddf996292890cc2fdc55b79817c47</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\win7\\desktop\\win7patch.exe</td>\n",
       "      <td>09:28:00</td>\n",
       "      <td>2017-01-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2017-01-17 09:28:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>d35ae72f121be3f785e2f2485d2e22ffd7beb955</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\win7\\appdata\\local\\temp\\rarsfx0\\a...</td>\n",
       "      <td>09:28:00</td>\n",
       "      <td>2017-01-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2017-01-17 09:28:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>d35ae72f121be3f785e2f2485d2e22ffd7beb955</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\win7\\appdata\\local\\temp\\rarsfx0\\a...</td>\n",
       "      <td>09:28:00</td>\n",
       "      <td>2017-01-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2017-01-17 09:29:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>Trojan.ScriptKD.1838</td>\n",
       "      <td>deleted</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\WIN7\\AppData\\Local\\Temp\\7ZipSfx.000\\d...</td>\n",
       "      <td>09:29:00</td>\n",
       "      <td>2017-01-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2017-01-17 09:29:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>Trojan.ScriptKD.1837</td>\n",
       "      <td>deleted</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\WIN7\\AppData\\Local\\Temp\\7ZipSfx.000\\d...</td>\n",
       "      <td>09:29:00</td>\n",
       "      <td>2017-01-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2017-01-17 09:29:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>Application:W32/Generic.d35ae72f12!Online</td>\n",
       "      <td>deleted</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\WIN7\\AppData\\Local\\Temp\\RarSFX0\\A.I.exe</td>\n",
       "      <td>09:29:00</td>\n",
       "      <td>2017-01-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>901</th>\n",
       "      <td>2017-10-31 09:58:00</td>\n",
       "      <td>user-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\psw\\appdata\\local\\microsoft\\windo...</td>\n",
       "      <td>09:58:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>902</th>\n",
       "      <td>2017-10-31 09:58:00</td>\n",
       "      <td>hp</td>\n",
       "      <td>Trojan.Downloader.DDE.Gen</td>\n",
       "      <td>none</td>\n",
       "      <td>email attachment</td>\n",
       "      <td>Invoice 678169871 10.31.2017.doc</td>\n",
       "      <td>09:58:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>2017-10-31 09:59:00</td>\n",
       "      <td>user-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch (1)...</td>\n",
       "      <td>09:59:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>905</th>\n",
       "      <td>2017-10-31 09:59:00</td>\n",
       "      <td>user-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch (2)...</td>\n",
       "      <td>09:59:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>906</th>\n",
       "      <td>2017-10-31 10:00:00</td>\n",
       "      <td>user-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch.exe</td>\n",
       "      <td>10:00:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>907</th>\n",
       "      <td>2017-10-31 10:03:00</td>\n",
       "      <td>dw-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\dw\\appdata\\local\\microsoft\\window...</td>\n",
       "      <td>10:03:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>2017-10-31 10:04:00</td>\n",
       "      <td>dw-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\dw\\appdata\\local\\microsoft\\window...</td>\n",
       "      <td>10:04:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>909</th>\n",
       "      <td>2017-10-31 10:05:00</td>\n",
       "      <td>dw-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\dw\\desktop\\dawin_drm_patch.exe</td>\n",
       "      <td>10:05:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>2017-10-31 10:09:00</td>\n",
       "      <td>dskang-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\dskang\\appdata\\local\\microsoft\\wi...</td>\n",
       "      <td>10:09:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>911</th>\n",
       "      <td>2017-10-31 10:09:00</td>\n",
       "      <td>dskang-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\dskang\\appdata\\local\\microsoft\\wi...</td>\n",
       "      <td>10:09:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>2017-10-31 10:30:00</td>\n",
       "      <td>intel-pc00</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...</td>\n",
       "      <td>10:30:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>2017-10-31 10:30:00</td>\n",
       "      <td>intel-pc00</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...</td>\n",
       "      <td>10:30:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>2017-10-31 10:31:00</td>\n",
       "      <td>intel-pc00</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...</td>\n",
       "      <td>10:31:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>2017-10-31 16:18:00</td>\n",
       "      <td>ksun4062-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...</td>\n",
       "      <td>16:18:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>917</th>\n",
       "      <td>2017-10-31 16:18:00</td>\n",
       "      <td>bjcho-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\bjcho\\appdata\\local\\microsoft\\win...</td>\n",
       "      <td>16:18:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>2017-10-31 16:18:00</td>\n",
       "      <td>bjcho-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\bjcho\\appdata\\local\\microsoft\\win...</td>\n",
       "      <td>16:18:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>918</th>\n",
       "      <td>2017-10-31 16:19:00</td>\n",
       "      <td>ksun4062-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\ksun4062\\desktop\\dawin_drm_patch.exe</td>\n",
       "      <td>16:19:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>919</th>\n",
       "      <td>2017-10-31 16:19:00</td>\n",
       "      <td>ksun4062-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\ksun4062\\desktop\\dawin_drm_patch.exe</td>\n",
       "      <td>16:19:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>920</th>\n",
       "      <td>2017-10-31 16:20:00</td>\n",
       "      <td>ksun4062-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...</td>\n",
       "      <td>16:20:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>921</th>\n",
       "      <td>2017-10-31 16:20:00</td>\n",
       "      <td>user-hp</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\user\\appdata\\local\\microsoft\\wind...</td>\n",
       "      <td>16:20:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>2017-10-31 16:20:00</td>\n",
       "      <td>ksun4062-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...</td>\n",
       "      <td>16:20:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>923</th>\n",
       "      <td>2017-10-31 16:26:00</td>\n",
       "      <td>user-hp</td>\n",
       "      <td>Trojan.Generic.22379191</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\User\\Downloads\\Open.0xe</td>\n",
       "      <td>16:26:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>2017-10-31 17:25:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\appdata\\local\\microsoft\\windo...</td>\n",
       "      <td>17:25:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>925</th>\n",
       "      <td>2017-10-31 17:26:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\downloads\\dawin_drm_patch.exe</td>\n",
       "      <td>17:26:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\n",
       "      <td>2017-10-31 17:26:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\appdata\\local\\microsoft\\windo...</td>\n",
       "      <td>17:26:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>927</th>\n",
       "      <td>2017-10-31 17:27:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\downloads\\scpacker0298063\\scs...</td>\n",
       "      <td>17:27:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>928</th>\n",
       "      <td>2017-10-31 17:35:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\downloads\\scpacker0755707\\scs...</td>\n",
       "      <td>17:35:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>929</th>\n",
       "      <td>2017-10-31 17:41:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\downloads\\scpacker0116834\\scs...</td>\n",
       "      <td>17:41:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>930</th>\n",
       "      <td>2017-10-31 18:22:00</td>\n",
       "      <td>rc0208-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\rc0208\\appdata\\local\\microsoft\\wi...</td>\n",
       "      <td>18:22:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>931</th>\n",
       "      <td>2017-10-31 18:22:00</td>\n",
       "      <td>rc0208-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\rc0208\\appdata\\local\\microsoft\\wi...</td>\n",
       "      <td>18:22:00</td>\n",
       "      <td>2017-10-31</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>932 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Date/time occurrence  End devices  \\\n",
       "0    2017-01-02 07:58:00       과장님컴퓨터   \n",
       "1    2017-01-03 07:57:00       과장님컴퓨터   \n",
       "2    2017-01-03 08:02:00       과장님컴퓨터   \n",
       "3    2017-01-03 10:16:00           2f   \n",
       "4    2017-01-03 16:30:00           2f   \n",
       "5    2017-01-04 08:29:00       과장님컴퓨터   \n",
       "6    2017-01-05 07:58:00       과장님컴퓨터   \n",
       "7    2017-01-06 07:56:00       과장님컴퓨터   \n",
       "8    2017-01-07 08:03:00       과장님컴퓨터   \n",
       "9    2017-01-09 08:06:00       과장님컴퓨터   \n",
       "10   2017-01-09 10:35:00           2f   \n",
       "11   2017-01-10 08:02:00       과장님컴퓨터   \n",
       "12   2017-01-11 08:00:00       과장님컴퓨터   \n",
       "13   2017-01-12 07:57:00       과장님컴퓨터   \n",
       "14   2017-01-12 09:25:00           hp   \n",
       "15   2017-01-12 09:26:00           hp   \n",
       "16   2017-01-13 09:28:00       과장님컴퓨터   \n",
       "17   2017-01-15 08:08:00       과장님컴퓨터   \n",
       "18   2017-01-15 09:17:00       과장님컴퓨터   \n",
       "19   2017-01-16 08:03:00       과장님컴퓨터   \n",
       "20   2017-01-16 10:05:00           2f   \n",
       "21   2017-01-17 08:18:00       과장님컴퓨터   \n",
       "22   2017-01-17 08:37:00       과장님컴퓨터   \n",
       "23   2017-01-17 09:23:00       과장님컴퓨터   \n",
       "24   2017-01-17 09:28:00          kdj   \n",
       "25   2017-01-17 09:28:00          kdj   \n",
       "26   2017-01-17 09:28:00          kdj   \n",
       "28   2017-01-17 09:29:00          kdj   \n",
       "29   2017-01-17 09:29:00          kdj   \n",
       "27   2017-01-17 09:29:00          kdj   \n",
       "..                   ...          ...   \n",
       "901  2017-10-31 09:58:00      user-pc   \n",
       "902  2017-10-31 09:58:00           hp   \n",
       "904  2017-10-31 09:59:00      user-pc   \n",
       "905  2017-10-31 09:59:00      user-pc   \n",
       "906  2017-10-31 10:00:00      user-pc   \n",
       "907  2017-10-31 10:03:00        dw-pc   \n",
       "908  2017-10-31 10:04:00        dw-pc   \n",
       "909  2017-10-31 10:05:00        dw-pc   \n",
       "910  2017-10-31 10:09:00    dskang-pc   \n",
       "911  2017-10-31 10:09:00    dskang-pc   \n",
       "912  2017-10-31 10:30:00   intel-pc00   \n",
       "913  2017-10-31 10:30:00   intel-pc00   \n",
       "914  2017-10-31 10:31:00   intel-pc00   \n",
       "916  2017-10-31 16:18:00  ksun4062-pc   \n",
       "917  2017-10-31 16:18:00     bjcho-pc   \n",
       "915  2017-10-31 16:18:00     bjcho-pc   \n",
       "918  2017-10-31 16:19:00  ksun4062-pc   \n",
       "919  2017-10-31 16:19:00  ksun4062-pc   \n",
       "920  2017-10-31 16:20:00  ksun4062-pc   \n",
       "921  2017-10-31 16:20:00      user-hp   \n",
       "922  2017-10-31 16:20:00  ksun4062-pc   \n",
       "923  2017-10-31 16:26:00      user-hp   \n",
       "924  2017-10-31 17:25:00       doo-pc   \n",
       "925  2017-10-31 17:26:00       doo-pc   \n",
       "926  2017-10-31 17:26:00       doo-pc   \n",
       "927  2017-10-31 17:27:00       doo-pc   \n",
       "928  2017-10-31 17:35:00       doo-pc   \n",
       "929  2017-10-31 17:41:00       doo-pc   \n",
       "930  2017-10-31 18:22:00    rc0208-pc   \n",
       "931  2017-10-31 18:22:00    rc0208-pc   \n",
       "\n",
       "                                Malicious code     Respnse   Type of malware  \\\n",
       "0                                       Defo.A        none             virus   \n",
       "1                                       Defo.A        none             virus   \n",
       "2                                       Defo.A        none             virus   \n",
       "3                                       Defo.A        none             virus   \n",
       "4                                       Defo.A        none             virus   \n",
       "5                                       Defo.A        none             virus   \n",
       "6                                       Defo.A        none             virus   \n",
       "7                                       Defo.A        none             virus   \n",
       "8                                       Defo.A        none             virus   \n",
       "9                                       Defo.A        none             virus   \n",
       "10                                      Defo.A        none             virus   \n",
       "11                                      Defo.A        none             virus   \n",
       "12                                      Defo.A        none             virus   \n",
       "13                                      Defo.A        none             virus   \n",
       "14               Trojan-Downloader:JS/Kavala.P     deleted             virus   \n",
       "15               Trojan-Downloader:JS/Kavala.P  segregated             virus   \n",
       "16                                      Defo.A        none             virus   \n",
       "17                                      Defo.A        none             virus   \n",
       "18   Application:W32/Generic.4a143fc08b!Online  segregated             virus   \n",
       "19                                      Defo.A        none             virus   \n",
       "20                                      Defo.A        none             virus   \n",
       "21                                      Defo.A        none             virus   \n",
       "22                                      Defo.A        none             virus   \n",
       "23                                      Defo.A        none             virus   \n",
       "24    a720dfafeb3ddf996292890cc2fdc55b79817c47     blocked             virus   \n",
       "25    d35ae72f121be3f785e2f2485d2e22ffd7beb955     blocked             virus   \n",
       "26    d35ae72f121be3f785e2f2485d2e22ffd7beb955     blocked             virus   \n",
       "28                        Trojan.ScriptKD.1838     deleted             virus   \n",
       "29                        Trojan.ScriptKD.1837     deleted             virus   \n",
       "27   Application:W32/Generic.d35ae72f12!Online     deleted             virus   \n",
       "..                                         ...         ...               ...   \n",
       "901   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "902                  Trojan.Downloader.DDE.Gen        none  email attachment   \n",
       "904   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "905   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "906   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "907   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "908   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "909   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "910   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "911   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "912   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "913   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "914   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "916   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "917   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "915   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "918   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "919   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "920   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "921   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "922   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "923                    Trojan.Generic.22379191        none             virus   \n",
       "924   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "925   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "926   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "927   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "928   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "929   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "930   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "931   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "\n",
       "                                               Details  new_time    new_date  \n",
       "0                                           MBR (0x80)  07:58:00  2017-01-02  \n",
       "1                                           MBR (0x80)  07:57:00  2017-01-03  \n",
       "2                                           MBR (0x80)  08:02:00  2017-01-03  \n",
       "3                                           MBR (0x80)  10:16:00  2017-01-03  \n",
       "4                                           MBR (0x80)  16:30:00  2017-01-03  \n",
       "5                                           MBR (0x80)  08:29:00  2017-01-04  \n",
       "6                                           MBR (0x80)  07:58:00  2017-01-05  \n",
       "7                                           MBR (0x80)  07:56:00  2017-01-06  \n",
       "8                                           MBR (0x80)  08:03:00  2017-01-07  \n",
       "9                                           MBR (0x80)  08:06:00  2017-01-09  \n",
       "10                                          MBR (0x80)  10:35:00  2017-01-09  \n",
       "11                                          MBR (0x80)  08:02:00  2017-01-10  \n",
       "12                                          MBR (0x80)  08:00:00  2017-01-11  \n",
       "13                                          MBR (0x80)  07:57:00  2017-01-12  \n",
       "14   C:\\Users\\John\\AppData\\Local\\Microsoft\\Windows\\...  09:25:00  2017-01-12  \n",
       "15   C:\\Users\\John\\AppData\\Local\\Microsoft\\Windows\\...  09:26:00  2017-01-12  \n",
       "16                                          MBR (0x80)  09:28:00  2017-01-13  \n",
       "17                                          MBR (0x80)  08:08:00  2017-01-15  \n",
       "18              C:\\Program Files\\AESCrypt\\aescrypt.exe  09:17:00  2017-01-15  \n",
       "19                                          MBR (0x80)  08:03:00  2017-01-16  \n",
       "20                                          MBR (0x80)  10:05:00  2017-01-16  \n",
       "21                                          MBR (0x80)  08:18:00  2017-01-17  \n",
       "22                                          MBR (0x80)  08:37:00  2017-01-17  \n",
       "23                                          MBR (0x80)  09:23:00  2017-01-17  \n",
       "24             \\\\?\\c:\\users\\win7\\desktop\\win7patch.exe  09:28:00  2017-01-17  \n",
       "25   \\\\?\\c:\\users\\win7\\appdata\\local\\temp\\rarsfx0\\a...  09:28:00  2017-01-17  \n",
       "26   \\\\?\\c:\\users\\win7\\appdata\\local\\temp\\rarsfx0\\a...  09:28:00  2017-01-17  \n",
       "28   C:\\Users\\WIN7\\AppData\\Local\\Temp\\7ZipSfx.000\\d...  09:29:00  2017-01-17  \n",
       "29   C:\\Users\\WIN7\\AppData\\Local\\Temp\\7ZipSfx.000\\d...  09:29:00  2017-01-17  \n",
       "27    C:\\Users\\WIN7\\AppData\\Local\\Temp\\RarSFX0\\A.I.exe  09:29:00  2017-01-17  \n",
       "..                                                 ...       ...         ...  \n",
       "901  \\\\?\\c:\\users\\psw\\appdata\\local\\microsoft\\windo...  09:58:00  2017-10-31  \n",
       "902                   Invoice 678169871 10.31.2017.doc  09:58:00  2017-10-31  \n",
       "904  \\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch (1)...  09:59:00  2017-10-31  \n",
       "905  \\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch (2)...  09:59:00  2017-10-31  \n",
       "906     \\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch.exe  10:00:00  2017-10-31  \n",
       "907  \\\\?\\c:\\users\\dw\\appdata\\local\\microsoft\\window...  10:03:00  2017-10-31  \n",
       "908  \\\\?\\c:\\users\\dw\\appdata\\local\\microsoft\\window...  10:04:00  2017-10-31  \n",
       "909        \\\\?\\c:\\users\\dw\\desktop\\dawin_drm_patch.exe  10:05:00  2017-10-31  \n",
       "910  \\\\?\\c:\\users\\dskang\\appdata\\local\\microsoft\\wi...  10:09:00  2017-10-31  \n",
       "911  \\\\?\\c:\\users\\dskang\\appdata\\local\\microsoft\\wi...  10:09:00  2017-10-31  \n",
       "912  \\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...  10:30:00  2017-10-31  \n",
       "913  \\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...  10:30:00  2017-10-31  \n",
       "914  \\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...  10:31:00  2017-10-31  \n",
       "916  \\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...  16:18:00  2017-10-31  \n",
       "917  \\\\?\\c:\\users\\bjcho\\appdata\\local\\microsoft\\win...  16:18:00  2017-10-31  \n",
       "915  \\\\?\\c:\\users\\bjcho\\appdata\\local\\microsoft\\win...  16:18:00  2017-10-31  \n",
       "918  \\\\?\\c:\\users\\ksun4062\\desktop\\dawin_drm_patch.exe  16:19:00  2017-10-31  \n",
       "919  \\\\?\\c:\\users\\ksun4062\\desktop\\dawin_drm_patch.exe  16:19:00  2017-10-31  \n",
       "920  \\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...  16:20:00  2017-10-31  \n",
       "921  \\\\?\\c:\\users\\user\\appdata\\local\\microsoft\\wind...  16:20:00  2017-10-31  \n",
       "922  \\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...  16:20:00  2017-10-31  \n",
       "923                   C:\\Users\\User\\Downloads\\Open.0xe  16:26:00  2017-10-31  \n",
       "924  \\\\?\\c:\\users\\doo\\appdata\\local\\microsoft\\windo...  17:25:00  2017-10-31  \n",
       "925     \\\\?\\c:\\users\\doo\\downloads\\dawin_drm_patch.exe  17:26:00  2017-10-31  \n",
       "926  \\\\?\\c:\\users\\doo\\appdata\\local\\microsoft\\windo...  17:26:00  2017-10-31  \n",
       "927  \\\\?\\c:\\users\\doo\\downloads\\scpacker0298063\\scs...  17:27:00  2017-10-31  \n",
       "928  \\\\?\\c:\\users\\doo\\downloads\\scpacker0755707\\scs...  17:35:00  2017-10-31  \n",
       "929  \\\\?\\c:\\users\\doo\\downloads\\scpacker0116834\\scs...  17:41:00  2017-10-31  \n",
       "930  \\\\?\\c:\\users\\rc0208\\appdata\\local\\microsoft\\wi...  18:22:00  2017-10-31  \n",
       "931  \\\\?\\c:\\users\\rc0208\\appdata\\local\\microsoft\\wi...  18:22:00  2017-10-31  \n",
       "\n",
       "[932 rows x 8 columns]"
      ]
     },
     "execution_count": 379,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['new_time'] = [d.time() for d in df['Date/time occurrence']]\n",
    "df['new_date'] = [d.date() for d in df['Date/time occurrence']]\n",
    "\n",
    "df.sort_values(by = 'Date/time occurrence')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 380,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"new_date\"] = df[\"new_date\"].map(lambda x: x.strftime(\"%Y%m%d\"))\n",
    "#%Y%m%d"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 381,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date/time occurrence</th>\n",
       "      <th>End devices</th>\n",
       "      <th>Malicious code</th>\n",
       "      <th>Respnse</th>\n",
       "      <th>Type of malware</th>\n",
       "      <th>Details</th>\n",
       "      <th>new_time</th>\n",
       "      <th>new_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-01-02 07:58:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:58:00</td>\n",
       "      <td>20170102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-01-03 07:57:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:57:00</td>\n",
       "      <td>20170103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-01-03 08:02:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:02:00</td>\n",
       "      <td>20170103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-01-03 10:16:00</td>\n",
       "      <td>2f</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>10:16:00</td>\n",
       "      <td>20170103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-01-03 16:30:00</td>\n",
       "      <td>2f</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>16:30:00</td>\n",
       "      <td>20170103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2017-01-04 08:29:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:29:00</td>\n",
       "      <td>20170104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017-01-05 07:58:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:58:00</td>\n",
       "      <td>20170105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017-01-06 07:56:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:56:00</td>\n",
       "      <td>20170106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017-01-07 08:03:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:03:00</td>\n",
       "      <td>20170107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017-01-09 08:06:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:06:00</td>\n",
       "      <td>20170109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2017-01-09 10:35:00</td>\n",
       "      <td>2f</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>10:35:00</td>\n",
       "      <td>20170109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2017-01-10 08:02:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:02:00</td>\n",
       "      <td>20170110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2017-01-11 08:00:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:00:00</td>\n",
       "      <td>20170111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2017-01-12 07:57:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:57:00</td>\n",
       "      <td>20170112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2017-01-12 09:25:00</td>\n",
       "      <td>hp</td>\n",
       "      <td>Trojan-Downloader:JS/Kavala.P</td>\n",
       "      <td>deleted</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\John\\AppData\\Local\\Microsoft\\Windows\\...</td>\n",
       "      <td>09:25:00</td>\n",
       "      <td>20170112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2017-01-12 09:26:00</td>\n",
       "      <td>hp</td>\n",
       "      <td>Trojan-Downloader:JS/Kavala.P</td>\n",
       "      <td>segregated</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\John\\AppData\\Local\\Microsoft\\Windows\\...</td>\n",
       "      <td>09:26:00</td>\n",
       "      <td>20170112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017-01-13 09:28:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>09:28:00</td>\n",
       "      <td>20170113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2017-01-15 08:08:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:08:00</td>\n",
       "      <td>20170115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2017-01-15 09:17:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Application:W32/Generic.4a143fc08b!Online</td>\n",
       "      <td>segregated</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Program Files\\AESCrypt\\aescrypt.exe</td>\n",
       "      <td>09:17:00</td>\n",
       "      <td>20170115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2017-01-16 08:03:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:03:00</td>\n",
       "      <td>20170116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2017-01-16 10:05:00</td>\n",
       "      <td>2f</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>10:05:00</td>\n",
       "      <td>20170116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2017-01-17 08:18:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:18:00</td>\n",
       "      <td>20170117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2017-01-17 08:37:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:37:00</td>\n",
       "      <td>20170117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2017-01-17 09:23:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>09:23:00</td>\n",
       "      <td>20170117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2017-01-17 09:28:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>a720dfafeb3ddf996292890cc2fdc55b79817c47</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\win7\\desktop\\win7patch.exe</td>\n",
       "      <td>09:28:00</td>\n",
       "      <td>20170117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2017-01-17 09:28:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>d35ae72f121be3f785e2f2485d2e22ffd7beb955</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\win7\\appdata\\local\\temp\\rarsfx0\\a...</td>\n",
       "      <td>09:28:00</td>\n",
       "      <td>20170117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2017-01-17 09:28:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>d35ae72f121be3f785e2f2485d2e22ffd7beb955</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\win7\\appdata\\local\\temp\\rarsfx0\\a...</td>\n",
       "      <td>09:28:00</td>\n",
       "      <td>20170117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2017-01-17 09:29:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>Trojan.ScriptKD.1838</td>\n",
       "      <td>deleted</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\WIN7\\AppData\\Local\\Temp\\7ZipSfx.000\\d...</td>\n",
       "      <td>09:29:00</td>\n",
       "      <td>20170117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2017-01-17 09:29:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>Trojan.ScriptKD.1837</td>\n",
       "      <td>deleted</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\WIN7\\AppData\\Local\\Temp\\7ZipSfx.000\\d...</td>\n",
       "      <td>09:29:00</td>\n",
       "      <td>20170117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2017-01-17 09:29:00</td>\n",
       "      <td>kdj</td>\n",
       "      <td>Application:W32/Generic.d35ae72f12!Online</td>\n",
       "      <td>deleted</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\WIN7\\AppData\\Local\\Temp\\RarSFX0\\A.I.exe</td>\n",
       "      <td>09:29:00</td>\n",
       "      <td>20170117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>901</th>\n",
       "      <td>2017-10-31 09:58:00</td>\n",
       "      <td>user-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\psw\\appdata\\local\\microsoft\\windo...</td>\n",
       "      <td>09:58:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>902</th>\n",
       "      <td>2017-10-31 09:58:00</td>\n",
       "      <td>hp</td>\n",
       "      <td>Trojan.Downloader.DDE.Gen</td>\n",
       "      <td>none</td>\n",
       "      <td>email attachment</td>\n",
       "      <td>Invoice 678169871 10.31.2017.doc</td>\n",
       "      <td>09:58:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>2017-10-31 09:59:00</td>\n",
       "      <td>user-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch (1)...</td>\n",
       "      <td>09:59:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>905</th>\n",
       "      <td>2017-10-31 09:59:00</td>\n",
       "      <td>user-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch (2)...</td>\n",
       "      <td>09:59:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>906</th>\n",
       "      <td>2017-10-31 10:00:00</td>\n",
       "      <td>user-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch.exe</td>\n",
       "      <td>10:00:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>907</th>\n",
       "      <td>2017-10-31 10:03:00</td>\n",
       "      <td>dw-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\dw\\appdata\\local\\microsoft\\window...</td>\n",
       "      <td>10:03:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>2017-10-31 10:04:00</td>\n",
       "      <td>dw-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\dw\\appdata\\local\\microsoft\\window...</td>\n",
       "      <td>10:04:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>909</th>\n",
       "      <td>2017-10-31 10:05:00</td>\n",
       "      <td>dw-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\dw\\desktop\\dawin_drm_patch.exe</td>\n",
       "      <td>10:05:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>2017-10-31 10:09:00</td>\n",
       "      <td>dskang-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\dskang\\appdata\\local\\microsoft\\wi...</td>\n",
       "      <td>10:09:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>911</th>\n",
       "      <td>2017-10-31 10:09:00</td>\n",
       "      <td>dskang-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\dskang\\appdata\\local\\microsoft\\wi...</td>\n",
       "      <td>10:09:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>2017-10-31 10:30:00</td>\n",
       "      <td>intel-pc00</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...</td>\n",
       "      <td>10:30:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>2017-10-31 10:30:00</td>\n",
       "      <td>intel-pc00</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...</td>\n",
       "      <td>10:30:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>2017-10-31 10:31:00</td>\n",
       "      <td>intel-pc00</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...</td>\n",
       "      <td>10:31:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>2017-10-31 16:18:00</td>\n",
       "      <td>ksun4062-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...</td>\n",
       "      <td>16:18:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>917</th>\n",
       "      <td>2017-10-31 16:18:00</td>\n",
       "      <td>bjcho-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\bjcho\\appdata\\local\\microsoft\\win...</td>\n",
       "      <td>16:18:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>2017-10-31 16:18:00</td>\n",
       "      <td>bjcho-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\bjcho\\appdata\\local\\microsoft\\win...</td>\n",
       "      <td>16:18:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>918</th>\n",
       "      <td>2017-10-31 16:19:00</td>\n",
       "      <td>ksun4062-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\ksun4062\\desktop\\dawin_drm_patch.exe</td>\n",
       "      <td>16:19:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>919</th>\n",
       "      <td>2017-10-31 16:19:00</td>\n",
       "      <td>ksun4062-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\ksun4062\\desktop\\dawin_drm_patch.exe</td>\n",
       "      <td>16:19:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>920</th>\n",
       "      <td>2017-10-31 16:20:00</td>\n",
       "      <td>ksun4062-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...</td>\n",
       "      <td>16:20:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>921</th>\n",
       "      <td>2017-10-31 16:20:00</td>\n",
       "      <td>user-hp</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\user\\appdata\\local\\microsoft\\wind...</td>\n",
       "      <td>16:20:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>2017-10-31 16:20:00</td>\n",
       "      <td>ksun4062-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...</td>\n",
       "      <td>16:20:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>923</th>\n",
       "      <td>2017-10-31 16:26:00</td>\n",
       "      <td>user-hp</td>\n",
       "      <td>Trojan.Generic.22379191</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>C:\\Users\\User\\Downloads\\Open.0xe</td>\n",
       "      <td>16:26:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>2017-10-31 17:25:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\appdata\\local\\microsoft\\windo...</td>\n",
       "      <td>17:25:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>925</th>\n",
       "      <td>2017-10-31 17:26:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\downloads\\dawin_drm_patch.exe</td>\n",
       "      <td>17:26:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\n",
       "      <td>2017-10-31 17:26:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\appdata\\local\\microsoft\\windo...</td>\n",
       "      <td>17:26:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>927</th>\n",
       "      <td>2017-10-31 17:27:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\downloads\\scpacker0298063\\scs...</td>\n",
       "      <td>17:27:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>928</th>\n",
       "      <td>2017-10-31 17:35:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\downloads\\scpacker0755707\\scs...</td>\n",
       "      <td>17:35:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>929</th>\n",
       "      <td>2017-10-31 17:41:00</td>\n",
       "      <td>doo-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\doo\\downloads\\scpacker0116834\\scs...</td>\n",
       "      <td>17:41:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>930</th>\n",
       "      <td>2017-10-31 18:22:00</td>\n",
       "      <td>rc0208-pc</td>\n",
       "      <td>bb58fac4be57a228be3c650690f75b30c002c7d3</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\rc0208\\appdata\\local\\microsoft\\wi...</td>\n",
       "      <td>18:22:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>931</th>\n",
       "      <td>2017-10-31 18:22:00</td>\n",
       "      <td>rc0208-pc</td>\n",
       "      <td>d9bb7fe7b1f255b80ba9502d80127ce3a183e454</td>\n",
       "      <td>blocked</td>\n",
       "      <td>virus</td>\n",
       "      <td>\\\\?\\c:\\users\\rc0208\\appdata\\local\\microsoft\\wi...</td>\n",
       "      <td>18:22:00</td>\n",
       "      <td>20171031</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>932 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Date/time occurrence  End devices  \\\n",
       "0    2017-01-02 07:58:00       과장님컴퓨터   \n",
       "1    2017-01-03 07:57:00       과장님컴퓨터   \n",
       "2    2017-01-03 08:02:00       과장님컴퓨터   \n",
       "3    2017-01-03 10:16:00           2f   \n",
       "4    2017-01-03 16:30:00           2f   \n",
       "5    2017-01-04 08:29:00       과장님컴퓨터   \n",
       "6    2017-01-05 07:58:00       과장님컴퓨터   \n",
       "7    2017-01-06 07:56:00       과장님컴퓨터   \n",
       "8    2017-01-07 08:03:00       과장님컴퓨터   \n",
       "9    2017-01-09 08:06:00       과장님컴퓨터   \n",
       "10   2017-01-09 10:35:00           2f   \n",
       "11   2017-01-10 08:02:00       과장님컴퓨터   \n",
       "12   2017-01-11 08:00:00       과장님컴퓨터   \n",
       "13   2017-01-12 07:57:00       과장님컴퓨터   \n",
       "14   2017-01-12 09:25:00           hp   \n",
       "15   2017-01-12 09:26:00           hp   \n",
       "16   2017-01-13 09:28:00       과장님컴퓨터   \n",
       "17   2017-01-15 08:08:00       과장님컴퓨터   \n",
       "18   2017-01-15 09:17:00       과장님컴퓨터   \n",
       "19   2017-01-16 08:03:00       과장님컴퓨터   \n",
       "20   2017-01-16 10:05:00           2f   \n",
       "21   2017-01-17 08:18:00       과장님컴퓨터   \n",
       "22   2017-01-17 08:37:00       과장님컴퓨터   \n",
       "23   2017-01-17 09:23:00       과장님컴퓨터   \n",
       "24   2017-01-17 09:28:00          kdj   \n",
       "25   2017-01-17 09:28:00          kdj   \n",
       "26   2017-01-17 09:28:00          kdj   \n",
       "28   2017-01-17 09:29:00          kdj   \n",
       "29   2017-01-17 09:29:00          kdj   \n",
       "27   2017-01-17 09:29:00          kdj   \n",
       "..                   ...          ...   \n",
       "901  2017-10-31 09:58:00      user-pc   \n",
       "902  2017-10-31 09:58:00           hp   \n",
       "904  2017-10-31 09:59:00      user-pc   \n",
       "905  2017-10-31 09:59:00      user-pc   \n",
       "906  2017-10-31 10:00:00      user-pc   \n",
       "907  2017-10-31 10:03:00        dw-pc   \n",
       "908  2017-10-31 10:04:00        dw-pc   \n",
       "909  2017-10-31 10:05:00        dw-pc   \n",
       "910  2017-10-31 10:09:00    dskang-pc   \n",
       "911  2017-10-31 10:09:00    dskang-pc   \n",
       "912  2017-10-31 10:30:00   intel-pc00   \n",
       "913  2017-10-31 10:30:00   intel-pc00   \n",
       "914  2017-10-31 10:31:00   intel-pc00   \n",
       "916  2017-10-31 16:18:00  ksun4062-pc   \n",
       "917  2017-10-31 16:18:00     bjcho-pc   \n",
       "915  2017-10-31 16:18:00     bjcho-pc   \n",
       "918  2017-10-31 16:19:00  ksun4062-pc   \n",
       "919  2017-10-31 16:19:00  ksun4062-pc   \n",
       "920  2017-10-31 16:20:00  ksun4062-pc   \n",
       "921  2017-10-31 16:20:00      user-hp   \n",
       "922  2017-10-31 16:20:00  ksun4062-pc   \n",
       "923  2017-10-31 16:26:00      user-hp   \n",
       "924  2017-10-31 17:25:00       doo-pc   \n",
       "925  2017-10-31 17:26:00       doo-pc   \n",
       "926  2017-10-31 17:26:00       doo-pc   \n",
       "927  2017-10-31 17:27:00       doo-pc   \n",
       "928  2017-10-31 17:35:00       doo-pc   \n",
       "929  2017-10-31 17:41:00       doo-pc   \n",
       "930  2017-10-31 18:22:00    rc0208-pc   \n",
       "931  2017-10-31 18:22:00    rc0208-pc   \n",
       "\n",
       "                                Malicious code     Respnse   Type of malware  \\\n",
       "0                                       Defo.A        none             virus   \n",
       "1                                       Defo.A        none             virus   \n",
       "2                                       Defo.A        none             virus   \n",
       "3                                       Defo.A        none             virus   \n",
       "4                                       Defo.A        none             virus   \n",
       "5                                       Defo.A        none             virus   \n",
       "6                                       Defo.A        none             virus   \n",
       "7                                       Defo.A        none             virus   \n",
       "8                                       Defo.A        none             virus   \n",
       "9                                       Defo.A        none             virus   \n",
       "10                                      Defo.A        none             virus   \n",
       "11                                      Defo.A        none             virus   \n",
       "12                                      Defo.A        none             virus   \n",
       "13                                      Defo.A        none             virus   \n",
       "14               Trojan-Downloader:JS/Kavala.P     deleted             virus   \n",
       "15               Trojan-Downloader:JS/Kavala.P  segregated             virus   \n",
       "16                                      Defo.A        none             virus   \n",
       "17                                      Defo.A        none             virus   \n",
       "18   Application:W32/Generic.4a143fc08b!Online  segregated             virus   \n",
       "19                                      Defo.A        none             virus   \n",
       "20                                      Defo.A        none             virus   \n",
       "21                                      Defo.A        none             virus   \n",
       "22                                      Defo.A        none             virus   \n",
       "23                                      Defo.A        none             virus   \n",
       "24    a720dfafeb3ddf996292890cc2fdc55b79817c47     blocked             virus   \n",
       "25    d35ae72f121be3f785e2f2485d2e22ffd7beb955     blocked             virus   \n",
       "26    d35ae72f121be3f785e2f2485d2e22ffd7beb955     blocked             virus   \n",
       "28                        Trojan.ScriptKD.1838     deleted             virus   \n",
       "29                        Trojan.ScriptKD.1837     deleted             virus   \n",
       "27   Application:W32/Generic.d35ae72f12!Online     deleted             virus   \n",
       "..                                         ...         ...               ...   \n",
       "901   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "902                  Trojan.Downloader.DDE.Gen        none  email attachment   \n",
       "904   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "905   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "906   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "907   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "908   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "909   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "910   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "911   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "912   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "913   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "914   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "916   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "917   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "915   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "918   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "919   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "920   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "921   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "922   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "923                    Trojan.Generic.22379191        none             virus   \n",
       "924   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "925   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "926   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "927   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "928   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "929   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "930   bb58fac4be57a228be3c650690f75b30c002c7d3     blocked             virus   \n",
       "931   d9bb7fe7b1f255b80ba9502d80127ce3a183e454     blocked             virus   \n",
       "\n",
       "                                               Details  new_time  new_date  \n",
       "0                                           MBR (0x80)  07:58:00  20170102  \n",
       "1                                           MBR (0x80)  07:57:00  20170103  \n",
       "2                                           MBR (0x80)  08:02:00  20170103  \n",
       "3                                           MBR (0x80)  10:16:00  20170103  \n",
       "4                                           MBR (0x80)  16:30:00  20170103  \n",
       "5                                           MBR (0x80)  08:29:00  20170104  \n",
       "6                                           MBR (0x80)  07:58:00  20170105  \n",
       "7                                           MBR (0x80)  07:56:00  20170106  \n",
       "8                                           MBR (0x80)  08:03:00  20170107  \n",
       "9                                           MBR (0x80)  08:06:00  20170109  \n",
       "10                                          MBR (0x80)  10:35:00  20170109  \n",
       "11                                          MBR (0x80)  08:02:00  20170110  \n",
       "12                                          MBR (0x80)  08:00:00  20170111  \n",
       "13                                          MBR (0x80)  07:57:00  20170112  \n",
       "14   C:\\Users\\John\\AppData\\Local\\Microsoft\\Windows\\...  09:25:00  20170112  \n",
       "15   C:\\Users\\John\\AppData\\Local\\Microsoft\\Windows\\...  09:26:00  20170112  \n",
       "16                                          MBR (0x80)  09:28:00  20170113  \n",
       "17                                          MBR (0x80)  08:08:00  20170115  \n",
       "18              C:\\Program Files\\AESCrypt\\aescrypt.exe  09:17:00  20170115  \n",
       "19                                          MBR (0x80)  08:03:00  20170116  \n",
       "20                                          MBR (0x80)  10:05:00  20170116  \n",
       "21                                          MBR (0x80)  08:18:00  20170117  \n",
       "22                                          MBR (0x80)  08:37:00  20170117  \n",
       "23                                          MBR (0x80)  09:23:00  20170117  \n",
       "24             \\\\?\\c:\\users\\win7\\desktop\\win7patch.exe  09:28:00  20170117  \n",
       "25   \\\\?\\c:\\users\\win7\\appdata\\local\\temp\\rarsfx0\\a...  09:28:00  20170117  \n",
       "26   \\\\?\\c:\\users\\win7\\appdata\\local\\temp\\rarsfx0\\a...  09:28:00  20170117  \n",
       "28   C:\\Users\\WIN7\\AppData\\Local\\Temp\\7ZipSfx.000\\d...  09:29:00  20170117  \n",
       "29   C:\\Users\\WIN7\\AppData\\Local\\Temp\\7ZipSfx.000\\d...  09:29:00  20170117  \n",
       "27    C:\\Users\\WIN7\\AppData\\Local\\Temp\\RarSFX0\\A.I.exe  09:29:00  20170117  \n",
       "..                                                 ...       ...       ...  \n",
       "901  \\\\?\\c:\\users\\psw\\appdata\\local\\microsoft\\windo...  09:58:00  20171031  \n",
       "902                   Invoice 678169871 10.31.2017.doc  09:58:00  20171031  \n",
       "904  \\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch (1)...  09:59:00  20171031  \n",
       "905  \\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch (2)...  09:59:00  20171031  \n",
       "906     \\\\?\\c:\\users\\psw\\downloads\\dawin_drm_patch.exe  10:00:00  20171031  \n",
       "907  \\\\?\\c:\\users\\dw\\appdata\\local\\microsoft\\window...  10:03:00  20171031  \n",
       "908  \\\\?\\c:\\users\\dw\\appdata\\local\\microsoft\\window...  10:04:00  20171031  \n",
       "909        \\\\?\\c:\\users\\dw\\desktop\\dawin_drm_patch.exe  10:05:00  20171031  \n",
       "910  \\\\?\\c:\\users\\dskang\\appdata\\local\\microsoft\\wi...  10:09:00  20171031  \n",
       "911  \\\\?\\c:\\users\\dskang\\appdata\\local\\microsoft\\wi...  10:09:00  20171031  \n",
       "912  \\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...  10:30:00  20171031  \n",
       "913  \\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...  10:30:00  20171031  \n",
       "914  \\\\?\\c:\\users\\intel\\appdata\\local\\microsoft\\win...  10:31:00  20171031  \n",
       "916  \\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...  16:18:00  20171031  \n",
       "917  \\\\?\\c:\\users\\bjcho\\appdata\\local\\microsoft\\win...  16:18:00  20171031  \n",
       "915  \\\\?\\c:\\users\\bjcho\\appdata\\local\\microsoft\\win...  16:18:00  20171031  \n",
       "918  \\\\?\\c:\\users\\ksun4062\\desktop\\dawin_drm_patch.exe  16:19:00  20171031  \n",
       "919  \\\\?\\c:\\users\\ksun4062\\desktop\\dawin_drm_patch.exe  16:19:00  20171031  \n",
       "920  \\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...  16:20:00  20171031  \n",
       "921  \\\\?\\c:\\users\\user\\appdata\\local\\microsoft\\wind...  16:20:00  20171031  \n",
       "922  \\\\?\\c:\\users\\ksun4062\\appdata\\local\\microsoft\\...  16:20:00  20171031  \n",
       "923                   C:\\Users\\User\\Downloads\\Open.0xe  16:26:00  20171031  \n",
       "924  \\\\?\\c:\\users\\doo\\appdata\\local\\microsoft\\windo...  17:25:00  20171031  \n",
       "925     \\\\?\\c:\\users\\doo\\downloads\\dawin_drm_patch.exe  17:26:00  20171031  \n",
       "926  \\\\?\\c:\\users\\doo\\appdata\\local\\microsoft\\windo...  17:26:00  20171031  \n",
       "927  \\\\?\\c:\\users\\doo\\downloads\\scpacker0298063\\scs...  17:27:00  20171031  \n",
       "928  \\\\?\\c:\\users\\doo\\downloads\\scpacker0755707\\scs...  17:35:00  20171031  \n",
       "929  \\\\?\\c:\\users\\doo\\downloads\\scpacker0116834\\scs...  17:41:00  20171031  \n",
       "930  \\\\?\\c:\\users\\rc0208\\appdata\\local\\microsoft\\wi...  18:22:00  20171031  \n",
       "931  \\\\?\\c:\\users\\rc0208\\appdata\\local\\microsoft\\wi...  18:22:00  20171031  \n",
       "\n",
       "[932 rows x 8 columns]"
      ]
     },
     "execution_count": 381,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by = 'Date/time occurrence')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 382,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['freq'] = df.groupby('new_date')['new_date'].transform('count')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 383,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df.freq = pd.to_numeric(df.freq, errors='coerce')\n",
    "#df.new_date = pd.to_numeric(df.new_date, errors='coerce')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 384,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"\\ntrace = go.Scatter(\\n    x = df['new_date'],\\n    y = df['freq']\\n)\\n\\ndata = [trace]\\n\\npy.iplot(data, filename='basic-line')\\n\""
      ]
     },
     "execution_count": 384,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\"\n",
    "trace = go.Scatter(\n",
    "    x = df['new_date'],\n",
    "    y = df['freq']\n",
    ")\n",
    "\n",
    "data = [trace]\n",
    "\n",
    "py.iplot(data, filename='basic-line')\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 385,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.collections.PathCollection at 0xa4cf190080>"
      ]
     },
     "execution_count": 385,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAGetJREFUeJzt3X+MHOd93/HP93h35FESSVM8GorJK39Af5iuGgt3YGVYJFyHbGiLjQRYCQNTIQGLog3IpuoGtkUCBFqgRJOiqAuqf0lVcEzRqDSS5mjQRmNSsei6f5i+s5L2FDVVSFuyIJU8RZJJSeTxyPv2j5097e7N7s7MzuzuPfd+AYvdmX3mme/zzOx3n3t2ds/cXQCAcPV0OgAAQLFI9AAQOBI9AASORA8AgSPRA0DgSPQAEDgSPQAEjkQPAIEj0QNA4HrbubM1a9b4hg0b2rlLAFjwJiYm3nL3wazbtzXRb9iwQePj4+3cJQAseGb2aivbM3UDAIEj0QNA4Ej0ABA4Ej0ABI5EDwCBI9EDQODaenklAITGzOYed+t/7GNEDwAZVSb5uOVuQaIHgMCR6AEgcCR6AMiodk6+W+fo+TAWAFrQrcm9EiN6AAgciR4AAkeiB4DAkegBIHAkegAIHIkeAAJHogeAwJHoASBwJHoACByJHgACR6IHgMCR6AEgcCR6AAgciR4AAkeiB4DAkegBIHAkegAIXKL/MGVmv5B0VdItSTfdfcTMVks6KWmDpF9I+h13f6eYMAEAWaUZ0f8Td/+ku49Ey09Ket7d75b0fLQMAOgyrUzdPCjpRPT4hKSHWg8HAJC3pIneJf3AzCbM7GC07qPu/qYkRfdriwgQANCaRHP0kj7t7m+Y2VpJZ8zs/yTdQfTGcFCShoaGMoQIAGhFohG9u78R3V+W9OeStkq6ZGZ3SVJ0f7nOtk+7+4i7jwwODuYTNQAgsaaJ3sxuM7M7yo8l/VNJk5K+K2l/VGy/pFNFBQkAyC7J1M1HJf25mZXL/4m7/3cz+6mk75jZo5Jek/TbxYUJAMiqaaJ394uSfj1m/d9L+o0iggIA5IdvxgJA4Ej0ABA4Ej0ABI5EDwCBI9EDQOBI9AAQOBI9AASORA8AgSPRA0DgSPQAEDgSPQAEjkQPAIEj0QNA4Ej0ABA4Ej0ABI5EDwCBI9EDQOBI9AAQOBI9AASORA8AgSPRA0DgejsdABY+M5t77O4djARAHEb0aEllko9bBtB5JHoACByJHgACR6JHS2rn5JmjB7oPH8aiZSR3oLslHtGb2RIze9HMTkfLG83sJ2b2ipmdNLP+4sIEAGSVZurmCUkvVyz/oaRvu/vdkt6R9GiegQFACHp6emRm6unp3Ex5oj2b2TpJD0j6T9GySfqspD+NipyQ9FARAQLAQtXT0zM3tenuHUv2Sff6HyR9U9JstHynpHfd/Wa0/Lqkj8VtaGYHzWzczManpqZaChYAFpJuuVihaaI3s92SLrv7ROXqmKKxLXD3p919xN1HBgcHM4YJAAtPt3yhMMlVN5+W9Ftm9nlJyyStUGmEv8rMeqNR/TpJbxQXJhajJUuWaHZ2Vj09Pbp161anwwFSK5+/7i4z0+zsbPONCtB0RO/uh919nbtvkPS7kv7S3fdK+qGkh6Ni+yWdKixKLDrlJC+VXixLlizpcERANrOzs3L3jiV5qbUvTH1L0r8ws79Tac7+2XxCAjTvRdHJFwmw0KX6wpS7vyDphejxRUlb8w8JKF2tUJncO3lpGrDQ8epBV7p169ZccmeOHmgNP4GArkVyB/LBiB4AAkeiBxCkvr4+mZn6+vo6HUrHkegBBKevr083b5a+uH/z5s1Fn+xJ9ACCU07y9ZYXGxI9gOD09vY2XF5sSPQAgjMzMzOX3Ht7ezUzM9PhiDprcb/NAQjWYk/ulRjRA0DgSPQAgrN06VKZmZYuXdrpULoCiR5AUJYuXaobN25Ikm7cuEGyF4keQGDKSb7e8mJEogcQlP7+/obLixGJHkBQpqen55J7f3+/pqenOxxR53F5JYDgkNyrMaIHgMCR6NEVBgYGZGYaGBjodChAcEj06LiBgQFdv35dknT9+nWSPZAzEj06rpzk6y0DaA2JHh23bNmyhssAWkOiR8ddu3ZtLrkvW7ZM165d63BEQFi4vBJdgeQOFIcRPQAEjkQPAIEj0QNA4JomejNbZmbnzeyvzewlM/tX0fqNZvYTM3vFzE6aGb8cBABdKMmIflrSZ9391yV9UtIuM7tP0h9K+ra73y3pHUmPFhcmACCrponeS96LFvuim0v6rKQ/jdafkPRQIRECAFqSaI7ezJaY2V9JuizpjKQLkt5195tRkdclfayYEAEArUiU6N39lrt/UtI6SVslfTyuWNy2ZnbQzMbNbHxqaip7pACATFJddePu70p6QdJ9klaZWfkLV+skvVFnm6fdfcTdRwYHB1uJFQCQQZKrbgbNbFX0eEDSDkkvS/qhpIejYvslnSoqSABAdkl+AuEuSSfMbIlKbwzfcffTZvY3kv6rmf1rSS9KerbAOAEAGTVN9O7+vyTdG7P+okrz9QCALsY3YwEgcCR6AAgciR4AAkeiB4DAkegBIHAkegAIHIkeAAJHogeAwJHoASBwJHoACByJHgACR6IHgMCR6AEgcCR6AAgciR4AAkeiB4DAkegBIHAkegAIHIkeAAJHogeAwJHoASBwJHoACByJHgACR6IHgMCR6AHUtXnzZpmZNm/e3OlQ0AISPYBYmzdv1sWLFyVJFy9eJNkvYE0TvZmtN7MfmtnLZvaSmT0RrV9tZmfM7JXo/iPFhwugXcpJvt4yFo4kI/qbkn7f3T8u6T5Jj5vZFklPSnre3e+W9Hy0DCAQmzZtariMhaNponf3N939Z9Hjq5JelvQxSQ9KOhEVOyHpoaKCBNB+Fy5cmEvumzZt0oULFzocEbLqTVPYzDZIulfSTyR91N3flEpvBma2NvfoAHQUyT0MiT+MNbPbJf2ZpH/u7ldSbHfQzMbNbHxqaipLjACAFiRK9GbWp1KS/y/u/t+i1ZfM7K7o+bskXY7b1t2fdvcRdx8ZHBzMI2YAQApJrroxSc9Ketnd/33FU9+VtD96vF/SqfzDAwC0Kskc/acl/Z6k/21mfxWtOyLpDyR9x8welfSapN8uJkQAQCuaJnp3/7Ekq/P0b+QbDgAgb3wzFgACR6IHgMCR6AEgcCR6ALkZGRmRmWlkZKTToaACiR5ALkZGRjQxMSFJmpiYINl3ERI9gFyUk3y9ZXQOiR5ALoaHhxsuo3NI9AByMT4+Ppfch4eHNT4+3uGIUJbq1ysBoBGSe3diRA8AgSPRA0DgSPQAEDgSPQAEjkQPAIFb1Il+586dMjPt3Lmz06EAHZf29cDrZ+FYtIl+586dOnv2rCTp7NmznKxY1NK+Hnj9LCzm7m3b2cjIiHfLdbal/5BYrZ19AXSTtK8HXj/tZWYT7p75x4MW7Yh+x44dDZeBxSTt64HXz8KyaBP9mTNn5k7OHTt26MyZMx2OCOictK8HXj/J7N69Wz09Pdq9e3dH41i0UzcAUKTdu3fre9/73tzyAw88oNOnT2eqq9WpGxI9ABSgp6en6nMLM9Ps7GymupijB4Au9PnPf77hcjuR6AGgAKdPn9YDDzwgM2tp2iYP/EwxABSkk8m9EiN6AAgciV7SI488or6+Pj3yyCOdDgUFCe0Yh9aeItFXKn2brdFN0h9JuixpsmLdaklnJL0S3X+kWT3uruHhYe82e/fudUlzt71793Y6JOQstGMcWnuKFEpfSRr3BDm23q3p5ZVmtl3Se5L+2N3/YbTu30p6293/wMyejBL9t5q9qXTj5ZV9fX26efPm3HJvb69mZmY6GBHyFtoxDq09RQqlrwq/vNLdfyTp7ZrVD0o6ET0+IemhrAF02p49exoux3nssce0dOlSPfbYY0WF1RVCaWeWY9zNQmtPkeirSJJhv6QNqp66ebfm+XeS1NONUzfupT/vent7E/1Zd+DAgao/BQ8cONCGCNsvtHamOcYLQWjtKVIIfaWip24kycw2SDrtH07dvOvuqyqef8fdP1Jn24OSDkrS0NDQ8Kuvvprl/ahrLF26VDdu3Jhb7u/v1/T0dAcjKsZiaSewEHTqm7GXzOyuKIC7VPqwNpa7P+3uI+4+Mjg4mHF33WPfvn0Nl0OxWNoJLAZZE/13Je2PHu+XdCqfcLrfM888owMHDqi/v18HDhzQM8880+mQCrFY2ol4TzzxhJYvX64nnngimDi6pU0d0WxuR9Jzkt6UNCPpdUmPSrpT0vMqXV75vKTVSeaJunWOHsCHDh06VPX5zKFDhxZ8HN3SpqzUjjn6vHTj5ZUAqi1fvlzXrl2bWx4YGNAHH3ywoOPoljZlxa9XttGRI0e0cuVKHTlypOvi6ObY2rEt8lN7OW27Lq8tH/9PfepTWrlypbZs2ZIojiTnTZI2BX3+tfLnQNrbQp66OXz4cNWffocPH+6aOLo5tnZsi/wdOnTIBwYG2jbFUXv8y7fh4eGGcaQ5bxq1qdvPPzF10x4rV67UlStX5pZXrFihX/3qV10Rh6SujS1pHN3Sv+iM2uNf1uw8yOu86fbzj6mbNnn88ccbLncyjm6OrR3bYuGrd7ybnQd5nTfBn3+t/DmQ9raQp27cS3/erVixouN/1sXFkSS2Y8eO+Zo1a/zYsWMN1+UdWx7bZo0z7/a1qtviKULaNpbLb9++3VesWOH33XdfqnPo8OHD3tfX5wMDAy31a6uv7yKPrVqcuiHRLxLHjh2rmoM8duxY7LpulDXObmtft8VThLRtzKNPuqFfi46h1UTPHP0iMTg4qLfeemtuec2aNZI0b93U1FTbY2smLvYkcWbdrijdFk8R0rYxjz7phn4tOgbm6AP11FNPaWhoSA8//LCGhob01FNPpdqutvzXv/71ectx67pR1jg72b6447BQ+rsVaduYtHy98zrLPovQDTE01MqfA2lvTN0kc/z48dhLzY4fP55qu9ry7ZijL8pCmqNvdBwWSn+3Iuscfb3yzc7rLPssQjfP0TN104WGhob0y1/+ct769evX67XXXku8XbPyKAbHIV/0J1M3QfrGN76Ran2955uVRzE4DvmiP3PQyp8DaW9M3SR3/PhxX79+vX/hC1/w9evX+969e33Lli0+OjqaaLtm0zxxRkdH5+0j6bpQpG1bvfK1xyFLn2Xt5yTbVZZZCMcz7rxeCHHnRVxeGb7R0dGqOcoiTuy4fSRdF4q0bUtaPkufZe3nJNvVllmIxzPk8zAOiX4R2LJlS9VJvWXLlrbsI+m6UKRtW9LyWfosaz8n2a62zEI8niGfh3FaTfQLao7+1KlT2r59u06d6vz/OakXS+X6rPHWbvfNb36z6vna5bQxxonbR9J1afeVl/I+jxw5UnVfL4ZmMabt56Tlsxy/2jIzMzOxcTc7V+K2a7T/pOdWvf23Wi6pdrwmgtLKu0TaWysj+rGxsap38LGxscx1tapeLLXrs8Rbr+6085FZ+ivrHH0njk2jvo6LIWmMec3Rt1pveZt169bVjbvRudJou9p4ss51J+3Tos6PdrwmuoUWy9TNtm3bqg7Stm3bMtfVqnqx1K7PEm9e7Wxnf3Xi2DTq67gYuun8SaNR3Fmfa0dsWcoVrVviyGLRJPpuejfuxIg+rxiLENKIvts0ijvrc+2ILUu5onVLHFksmkTvXjpQ27ZtS3WAzp0753v27PFz587lWrYcy7Fjx6q2GRsb83vuucfvv/9+P3bsWGyZpHUnaWejmOPqSdLGNP1Qb19Z6kgbT3mfhw8frrofGxuL3aZRv7YSb55tjdMo7nrnYfm58rmY53E4fvz43L6S9mmW124RuiWOtBZVok/r3LlzVe/gzZJb0rKNtqldV/v17TyTQdqYk5TP0g9F1NFKXUX0SxHb5qVeDEUeh2Z1dkO/hIRE38CePXuqTrY9e/bkUrbRNrXr1q9fn7reItqXtHyWfiiijlbqKqJfitg2L/ViKPI4NKuzG/olJCT6CpOTk3706FGfnJx09/hRxeTkpH/lK1/xL3/5y3Pl4sqWP8mvVz5um3379s37Ike9EX1cvbXxN1O7r3qjpnK9teX37dvnk5OTVftNMxKrF2+SOsrbjo2Nzasjazxp9l+5r/3798879vViS7uvJMc07XFPGkPc+ZnXPjoxom90ztSWydrOevvJo95WkOgjk5OTbmYuyc2sKtmX5wknJyerTr7Kcu7VidPM5n14U1u+XP/nPve5qjKjo6NV86W1c7hxcYyNjcXGn6S9lW9MzfpldHTUd+3aNW//lftNMudcr78r+6VeHbWxV9YRV2+WOfC0bZDku3bt8tHR0bqxpd1Xsz5KWqaV9p47d67qeOexj8o5+iwxZdHonIkrk7WdcfuJe420G4k+cvTo0aoDc/To0aZlasvVPh93CV+SeuPKNIujdl9p66hXPq5c3P6T7jdrm5u1v15saepNK03fZIkjyzlZRHvb2adFSXJc8mhno9dGJ/uPRB9JOnpKMyJIMqJPuu9mcbQyom9UPq5c7agly2illdFT2hF9UZL0TV6jw6JH9K3G0e0Y0S+C36O/fPmyzp8/r61bt0qSzp8/r40bN+rnP/951f0LL7ygixcv6sEHH9SVK1fmnqvcbsWKFXruuefk7vra176mT3ziE1X7eumll3Ty5Ent2LFDV65caVq+drs9e/bElim3oRxTZb1f/OIX5/Z19uzZpnVs3bpVa9eubbjPyrJTU1PzylVuK6lh7HHx16s3brsf/OAHkqR777133rHavn27JiYm6sZWr12Vcaxdu7ZuHzVrSzmOL33pS/P2Pzw8rImJiblzYePGjXrxxRer2lK5n6R9FHcunDp1Sps2bdJnPvOZqvO6Wf1J2157Xle+JuL20WxdvT6NK5Pk9ZukLbXHJe78aPY6jDsHauMoH7Ph4WH96Ec/0qZNm3TPPffo7Nmz2rFjx9xv4Sc9B+r1WRqt/h5914/oL1265KtXr/Y77rjDV61a5atWrfLbbrvNzcyXL19edX/77bfPK1O57o477vDVq1f7pUuXEu8zSfmkbaiMqVxv0n2liamd8TfbbtWqVVWjospjlTa2ZnEkaXfatlSWV80IL+44Nqs3rly98zpN/WnaXvlaqiwfV0faemvLJHn9ZmlLK2r7Mmkck5OT887nLOdAFurkj5qZ2S4z+1sz+zsze7KVuuo5f/68ZmZmdPXqVU1PT2t6elrvv/++3F0ffPBB1f177703r0zluqtXr2pmZkbnz59PvM8k5ZO2oTKmcr1J95UmpnbG32y76enpueXaY5U2tmZxJGl32rZUlq9U7zg2qzeuXL3zOk39adpe+VqqLB9XR9p6a8skef1maUsravsyaRwnT56cdz5nOQc6Ius7hKQlki5I2iSpX9JfS9rSaBtG9IzoGdEzomdEn546NUdvZp+S9C/d/Tej5cPRG8e/qbdN0XP0tfPxceuSzpklmZfM0oZGc6/N9pUmpnbG32y7uDn6rPOXec/RJ4mjsnzaOfq4euPKSc3nrvNs+0Kco89Tozn6RnHEnc8LYY6+lUT/sKRd7n4gWv49Sf/Y3b9aU+6gpIOSNDQ0NPzqq69mjRUAFqVWE30rc/QWs27eu4a7P+3uI+4+Mjg42MLuAABZtJLoX5e0vmJ5naQ3WgsHAJC3VhL9TyXdbWYbzaxf0u9K+m4+YQEA8tKbdUN3v2lmX5X0FypdgfNH7v5SbpEBAHKROdFLkrt/X9L3c4oFAFCAlr4wBQDofm39rRszm5KU9frKNZLeiu5V8bj2Pu65pOuogzqogzqKrCOrf+Du2S9bbOXbVu28KfpmmKTxysdJnku6jjqogzqoo8g6OnVj6gYAAkeiB4DAtXTVTZs9XXMft67Rc9RBHdRBHZ2uoyPa+mEsAKD9mLoBgMDlMnVjZusl/bFKv3fza5Lel3SbpGuSVqn0hmKq/tGzuB9FAwBUu6nSrw+4pBmV8rZLui7pdkmD7t7w0s28RvQ3Jf2+pO2SflPSVZV+mniJpNPR8k8l3YiCez3aZiq6n5X0q+j+bUm3oobMRrfycvkGAO3WKPfcqHg8G1P+zYp15bLjFc/fitZPq5QT/59KA+a3Jb0raSK6/VjSX0p6RqXfFns7SeC5JHp3f9Pdfxbd/1jSpKTLKr3zPBft51mV/hPV/5V0l0rvTMv0YTK/I7rv1Ycd1aMPk7tV3N+Kni/fA0BRygnbapYrzVY8jiv3QcXjGyrlrjtVPYD9m6hcj6RXVBoUX5W0WtKfqJQbRyR9XNK3Jf1HScuTNCD3q27MbIOke1V6B7tN0kvR/f9UqQPuVGmkv0SlBveVN1Wpgf0V6xSVm6mzuyW5Bg8A89WbZvaK55ZVLJfXVQ6kr1bU1RPdhirKLpG0UaVc2SPpfn2YLyXp36n0zdoBSW+4+ytmdl0Jc2CuH8aa2e2S/kzSk5JOqDRHX77/z1Gxb6nUgGsqJXXpw0Q+I2mp5r9jlt+QyvEykgfQKbWJ/1bM+psVj12lzy/L+lT6C+B9lXJeeVbjdpWmsK9H5aYk/SLa/m8r9vVRM0v1GWduid7M+lRK8s9J2h/dS6U5eqn0oewtSV+N7ntUatwHFY8tur+h6j9pynNatW8AzNdnQ78B2dVO5VROJ5ctUfXrbFnFtuXn+lUaxPbow5H5nVFdVyR9QtKgSvP2P6uo56pKv5+zLma/sXJJ9NG7y7OSXpb0j2ru/5lKo3dT6UOFX4vul6iU5D0K9loUz3vRc+UPYW+putMqO6rRn1TtQMLEQsM5W61ef3jM49oEX1abR2dVPU9vkl6r2LZ8Fc3jmj+fPxs9956k31JpkFtO+ktV+ivgdpWmcfareu6/rly+MGVm90v6H5IuSNocBddfcQ8AyKY8DXRL0t+rlPjXqDSf36/ShS/fd/cD9Srgm7EAEDi+GQsAgSPRA0DgSPQAEDgSPQAEjkQPAIEj0QNA4Ej0ABA4Ej0ABO7/A3KsKxeOU3SxAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0xa4cf8d39b0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "f2 = df['freq'].values\n",
    "f1 = df['new_date'].values\n",
    "X = np.array(list(zip(f1,f2)))\n",
    "plt.scatter(f1,f2, c='black', s=7)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 462,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DBSCAN(algorithm='auto', eps=100, leaf_size=30, metric='euclidean',\n",
       "    metric_params=None, min_samples=90, n_jobs=1, p=None)"
      ]
     },
     "execution_count": 462,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model = DBSCAN(eps= 100, min_samples= 90).fit(X)\n",
    "model\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 463,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Counter({0: 924, -1: 8})\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date/time occurrence</th>\n",
       "      <th>End devices</th>\n",
       "      <th>Malicious code</th>\n",
       "      <th>Respnse</th>\n",
       "      <th>Type of malware</th>\n",
       "      <th>Details</th>\n",
       "      <th>new_time</th>\n",
       "      <th>new_date</th>\n",
       "      <th>freq</th>\n",
       "      <th>model</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-01-02 07:58:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:58:00</td>\n",
       "      <td>20170102</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-01-03 07:57:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>07:57:00</td>\n",
       "      <td>20170103</td>\n",
       "      <td>4</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-01-03 08:02:00</td>\n",
       "      <td>과장님컴퓨터</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>08:02:00</td>\n",
       "      <td>20170103</td>\n",
       "      <td>4</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-01-03 10:16:00</td>\n",
       "      <td>2f</td>\n",
       "      <td>Defo.A</td>\n",
       "      <td>none</td>\n",
       "      <td>virus</td>\n",
       "      <td>MBR (0x80)</td>\n",
       "      <td>10:16:00</td>\n",
       "      <td>20170103</td>\n",
       "      <td>4</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Date/time occurrence End devices Malicious code Respnse Type of malware  \\\n",
       "0  2017-01-02 07:58:00      과장님컴퓨터         Defo.A    none           virus   \n",
       "1  2017-01-03 07:57:00      과장님컴퓨터         Defo.A    none           virus   \n",
       "2  2017-01-03 08:02:00      과장님컴퓨터         Defo.A    none           virus   \n",
       "3  2017-01-03 10:16:00          2f         Defo.A    none           virus   \n",
       "\n",
       "      Details  new_time  new_date  freq  model  \n",
       "0  MBR (0x80)  07:58:00  20170102     1     -1  \n",
       "1  MBR (0x80)  07:57:00  20170103     4     -1  \n",
       "2  MBR (0x80)  08:02:00  20170103     4     -1  \n",
       "3  MBR (0x80)  10:16:00  20170103     4     -1  "
      ]
     },
     "execution_count": 463,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['model'] = model.labels_\n",
    "print(Counter(model.labels_))\n",
    "df.head(4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 464,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEICAYAAACktLTqAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAIABJREFUeJzt3XuYFNWd//H3lxmU+6AILAQQNK6roE50dA1qmNX17hqixkvcDUYN8ZfVXX9qVsW4uxpFzbrRJJLsajCQ/EyQkBgT73mMmJjwRAYzCqJGRQSUy4CCIqLM8P39UVVDT9PTXX2ju2s+r+fpp7urTp06p7r6W6dPVZ02d0dERJKlV6ULICIipafgLiKSQAruIiIJpOAuIpJACu4iIgmk4C4ikkAK7lI0C/zQzN41s2fN7Bgze6WI/NzMPlnKMuax7gvM7JlKrLsamFmzma0qQ75jzGyzmdWVOm/JTMF9FzKz5Wb2oZm9b2YbzeyPZnaJmfVKSTPLzD4Ovwjvm9kiM5uUMn83M/tvM1sVpnnDzO5IW88XzKwlnL/azB41s6PT0lwQBtGz06Y3h9NnpE1/xswu6KZqRwPHA6Pc/Qh3/72771/YViqMmZ0alnGjma0xs3vMbOCuLENaeSp2gKpG7r7C3Qe4e0ely9JTKLjvev/g7gOBvYFbgauBmWlpvunuA4AG4PvAL1JaPNcCTcARwEDg74A/Rwua2RXAncB0YDgwBvge8Nm0dUwB3gmf030AfNHMxsas097Acnf/IGb6cmgAbgJGAgcAo4D/qmB5CmZm9ZUugySAu+uxix7AcuDv06YdAWwHJoTvZwE3pczvBzgwMnz/EHB5N/k3AJuBz+cox97hOs8E2oHhKfOagVXAd4Efpkx/BrggQ14XAVuBjnDdN0R5pNX7KuAFYBNwP9AnZf7XgNXA28CFYX0/Gc47BVgKvA+8BVwVc1ufASzOMn808AugDdgA3BVOvwB4Jnw9NixLfcpy84GLw9efBJ4O67QeuD+c/rtwuQ/CbXJOOP00oBXYCPwRODhtG10dbqOPgPrw/Vth3V8BjuumLqcSHODfA1YC/5kyL6rDFGBFWM7rUub3Dfe5d8Pt/LXUzy7Duhy4BHg1XGYGYOG8XsDXgTeBdcCPgIZM2zLczsvCur0BnJ+yjguBl8L8Hwf2rvR3txYfFS9AT3qQIbiH01cA/yd8PYswuAN14RdpGVAXTvt6mP6rwEHRFyucdxJBsK7PUY7rgWfD14uBK1LmNRME978Kg8X+4fSMwT2cdwFhQEzNI63ezxK0qvcMv7iXpJR5LTAB6A/8hK7BfTVwTPh6D+DQmNv6TmBON/PqgOeBO8J19gGOTq9LekAKp81nR3D/KXBdGNQ68wjnddYhfH9oGPD+Nlz/lHC77J6yjVoJDjp9gf0JAvXIlLLs2019msN9oRdwcLg9J6fV4Z4w30MIDh4HhPNvBX4ffi6jgSXkDu4PAYMJfhW2ASeF8y4EXgP2AQYQHDx/nL4tw22eum+NAMaHryeHeRwQpv068MdKf3dr8aFumerwNsGXK3KVmW0kaPndCVzvO/oqbwFuA84HWoC3zCzqWhkCrHf39hzr+yJBECV83qlrxt3XAP8D3Jh/dTL6jru/7e7vAL8GGsPpZxP8QljiQbfOf6Yttw040MwGufu77v5crhWZ2fEEdfr3bpIcQXCg+Zq7f+DuW929kJOo2wh+BY2MkceXgf919z+5e4e7zyYIskempPmOu6909w8JfgntTlD33u6+3N1fz5Sxu89398Xuvt3dXyA46ExKS3aDu3/o7s8THNgOCaefDdzs7u+4+0rgOzHqfau7b3T3FcBT7Pgszwe+5e7L3H0zQRfiud10M20HJphZX3df7e4vhtO/Atzi7i+F+/F0oNHM9o5RLkmh4F4dPkHQ/x253d0HE7S0moD/MrOTAcLAMMPdjyJoPd0M3GtmBxB0L+yVrc/WzI4CxgFzwkk/AQ4ys8YMyW8DTjSzQzLMy9ealNdbCFp2EATZlSnz3kxb7kyCrpk3zexpM/t0tpWY2ZEEdTrL3f/STbLRwJsxDoK5/BtgwLNm9qKZXZgl7d7AleEJ343hwXs0Qf0jndvB3V8DLic42K0zszlmlpq2k5n9rZk9ZWZtZraJ4NfeXmnJCt3+mWTLK3X5Nwla38NTFw4P4ueE5VxtZg+b2d+Es/cGvp2yjd4h2MafiFEuSaHgXmFmdjjBjrtTq88DS4A/EPSrps//0N1nEPRNHggsIOj/npxllVMIviytZrYG+FM4/YsZ8t9A8MvhG/nUKU+rCYJcZExaGRa6+2eBYcAvgbndZWRmnwJ+BVzo7k9mWedKYEyME5fRCeJ+KdP+KqVsa9z9y+4+kqDF+b0sV8isJGghD0559HP3n6ak6TJEq7v/xN2PJgh4TnCwzeQnBPUe7e4NBL+4LEfdIlm3f57eJihral7tBN1EXbj74+5+PEGXzMsE3UYQbKevpG2nvu7+xyLK1SMpuFeImQ0ys9MIWtD/z90Xd5PubwguNXwxfH95eLliXzOrD7tkBgJ/dvdNBF0RM8xsspn1M7PeZnaymX3TzPoQ/AyfSvBTOnpcBpzfTbD7FjCRoA+0HOYCF5jZgWbWD/iPlLrvZmbnm1mDu28j6KfNeCmdmU0AHgMuc/df51jnswRB7VYz629mfcJfNF24exvBCc1/NLO6sGW+b8o6P29mo8K37xIE4Kh8awn6niP3AJeErWwL13tqd5drmtn+Znasme1OcMCOumoyGQi84+5bzewI4As56p9qLnCtme0R1uWyPJZN91Pg/5rZODMbQNClcn/6LyQzG25mp5tZf4Kuqc3sqNv/hOUZH6ZtMLPPF1GmHkvBfdf7tZm9T9BCuY4geH4pLc2/hdeofwA8AfwQ+N9w3ofAfxP8NF4P/DNwprsvA3D3bwFXEJyIagvXcylBq3dyuPyPwlbnmrBvfSbBSb6T0gvr7u8B36TrOYGScfdHCX4d/JbgRNpv05L8E7DczN4j+Bn/j91kdSUwFJgZbrvNZvZipoTh+Yt/ILjaZQXBCeRzusn3ywRXkGwAxhNc5RI5HPiTmW0maDn/q7u/Ec77T2B22L1wtru3hHndRXAgeI3g5G13dic42bme4LMeBkzrJu1XgRvD/erfyfLrJoMbCLpP3iDY136cx7Lp7g2X/12Y31YyHyx6EXxebxN0u0wiqAPu/gDBL5Q54We+BDi5iDL1WNElTCIikiBquYuIJJCCu4hIAim4i4gkkIK7iEgCxRqgyMwGAz8guEXcCW4zfoVgjJCxBLdOn+3u72bLZ6+99vKxY8cWXloRkR5o0aJF6919aD7LxLpaxsxmA7939x+Y2W4EN3VMI7i29lYzuwbYw92vzpZPU1OTt7S05FM+EZEez8wWuXtTPsvk7JYxs0HAZwiHpXX3j919I8EQsrPDZLPJflekiIjsQnH63PchuBnmh2b2ZzP7QXhn2XB3Xw0QPg/LtLCZTbXgjyNa2traSlZwERHpXpzgXk8wXOn33f1TBONtXBN3Be5+t7s3uXvT0KF5dRmJiEiB4pxQXUUwvnM0wNQ8guC+1sxGuPtqMxtBMFZ13rZt28aqVavYunVrIYv3eH369GHUqFH07t270kURkSqSM7i7+xozW2lm+7v7K8BxBP/YspRghMFbw+cHCynAqlWrGDhwIGPHjsUs7kB2AsEfrWzYsIFVq1Yxbty4ShdHRKpI3P9qvAy4L7xSZhnBQFe9gLlmdhHB4EsFjdy2detWBfYCmRlDhgxB5zJEJF2s4O7urQR/GpHuuFIUQoG9cNp2IpKJ7lAVEUkgBXdgzZo1nHvuuey7774ceOCBnHLKKfzlL39h+fLlTJgwoaA8Z82axdtvv11UuV5++WU+/elPs/vuu3P77bcXlZeIlJBZ8KhiPT64uzuf+9znaG5u5vXXX2fp0qVMnz6dtWt3+mewvBQS3Nvbu/6l55577sl3vvMdrrrqqqLKIiI9T20G9+bm4FECTz31FL179+aSSy7pnNbY2MgxxxzTJd2sWbO49NJLO9+fdtppzJ8/n46ODi644AImTJjAQQcdxB133MG8efNoaWnh/PPPp7GxkQ8//JBFixYxadIkDjvsME488URWr14dVqWZadOmMWnSJL797W93WeewYcM4/PDDdZmjSLVIb7FXcQs+7tUyibVkyRIOO+ywgpdvbW3lrbfeYsmSJQBs3LiRwYMHc9ddd3H77bfT1NTEtm3buOyyy3jwwQcZOnQo999/P9dddx333ntv5zJPP/10SeojIgK1Ftyj1noUCKP38+dXoDCBffbZh2XLlnHZZZdx6qmncsIJJ+yU5pVXXmHJkiUcf/zxAHR0dDBixIjO+eec093fd4pIVYkGWoxa61X8N6W1FdzLYPz48cybNy9nuvr6erZv3975Prqjdo899uD555/n8ccfZ8aMGcydO7ezRR5xd8aPH8+CBQsy5t2/f/8iaiAisrPa6nOfPz94TJoUPKL3RTj22GP56KOPuOeeezqnLVy4cKdukrFjx9La2sr27dtZuXIlzz77LADr169n+/btnHnmmXzjG9/gueeeA2DgwIG8//77AOy///60tbV1Bvdt27bx4osvFlVuEakg96putYNa7pgZDzzwAJdffjm33norffr0YezYsdx5551d0h111FGMGzeOgw46iAkTJnDooYcC8NZbb/GlL32ps1V/yy23AHDBBRdwySWX0LdvXxYsWMC8efP4l3/5FzZt2kR7ezuXX34548ePz1q2NWvW0NTUxHvvvUevXr248847Wbp0KYMGDSrDlhCRJIn1Zx2lkunPOl566SUOOOCAXVaGJNI2FEm2svxZh4iI1B4FdxGRBFJwFxFJIAV3EZEEUnAXEUkgBXcRkQRScKd6h/y97777OPjggzn44IOZOHEizz//fFH5iUjP0eODezUP+Ttu3DiefvppXnjhBa6//nqmTp1aVJlEpOeoueB+3+L7GHvnWHrd0Iuxd47lvsX3FZVfNQ/5O3HiRPbYYw8AjjzySFatWlVUXUWk56ip4QfuW3wfU389lS3btgDw5qY3mfrroDV7/kHnF5RnrQz5O3PmTE4++eSCyykiPUtNBffrnryuM7BHtmzbwnVPXldwcC/Wrhjy96mnnmLmzJk888wzpS28iCRWTQX3FZtW5DU9jmof8veFF17g4osv5tFHH2XIkCFxqiQiUlt97mMaxuQ1PY5qHvJ3xYoVnHHGGfz4xz/mr//6rwuuo4j0PDXVcr/5uJu79LkD9Ovdj5uPu7ngPKt5yN8bb7yRDRs28NWvfhUIfj2kj6opIpJJzQ35e9/i+7juyetYsWkFYxrGcPNxN1esv71aaMhfkWQrZMjfWC13M1sOvA90AO3u3mRmewL3A2OB5cDZ7v5uPisvxPkHnd/jg7mISC759Ln/nbs3phw9rgGedPf9gCfD9yIiUgWKOaH6WWB2+Ho2MLn44oiISCnEDe4OPGFmi8wsugd+uLuvBgifh2Va0MymmlmLmbW0tbUVX2IREckp7tUyR7n722Y2DPiNmb0cdwXufjdwNwQnVAsoo4iI5ClWy93d3w6f1wEPAEcAa81sBED4vK5chRQRkfzkDO5m1t/MBkavgROAJcCvgClhsinAg+UqZLlV65C/Dz74IAcffDCNjY00NTVp+AERiS1Ot8xw4AEzi9L/xN0fM7OFwFwzuwhYAXy+fMUsn2jI3ylTpjBnzhwgGAxs7dq1jB49uuB8Z82axYQJExg5cmTsZdrb26mv3/GRHHfccZx++umYGS+88AJnn302L78cu0dMRHqwnC13d1/m7oeEj/HufnM4fYO7H+fu+4XP75S/uIFNm2D8+OC5WNU85O+AAQMID6p88MEHna9FRHKpqeEHIg8/DEuXwiOPwHnnFZdXtQ/5+8ADD3Dttdeybt06Hn744YLLKSI9S00NHPaFL8CAATAl7On/4heD91/4QuXKlDrk72OPPcagQYN2SpM65G9jYyM33XRTlz/eyDbk7+c+9zlefvllfvnLX3L99deXpQ4ikjw1FdxvvBHGjIHevYP3vXvD3nvDN75ReJ7jx49n0aJFOdPlGvK3ubmZGTNmcPHFF++0bDTkb2trK62trSxevJgnnniic362IX8jn/nMZ3j99ddZv359nGqJSA9XU8H9k58MAvy2bdC/f/B8ww2w776F51nNQ/6+9tprRAO7Pffcc3z88cca011EYqm5Pve5c4PAfv31QYv9Zz+Ds84qPL9qHvL35z//OT/60Y/o3bs3ffv25f7779dJVRGJpeaG/F24MOiaGT4c1q6FlSuhKa+BMJNHQ/6KJFvZhvytJocfvuP18OHBQ0REuqqpPncREYlHwV1EJIEU3EVEEkjBXUQkgRTcRUQSqGaD+7Jly0qWV7UO+RtZuHAhdXV1zJs3ryT5iUjy1WRwv+WWW9h33307bxgqRjTkb3NzM6+//jpLly5l+vTprF27tqh8Cwnu7e3tO03r6Ojg6quv5sQTTyyqPCLSs9RccL/lllu46aabALjpppuKDvDVPOQvwHe/+13OPPNMhg3L+Be1IiIZ1dRNTFFg37JlCwBbtmzpDPTXXnttQXlW85C/b731Fg888AC//e1vWbhwYcFlFJGep2aCe3pgj5QiwBcjdcjfU089lRNOOGGnNKlD/kLQ1TJixIjO+d0N+Xv55Zdz2223UVdXV57Ci0hi1URwX7ZsGdOmTet2/pYtW5g2bRrnnHMO++yzT155jx8/PtaJylxD/j7++OPMmDGDuXPndrbII9GQv9GokOm6G/K3paWFc889FwhGn3zkkUeor69n8uTJseomIj1XTfS577PPPkyfPp1+/fplnN+vXz+mT5+ed2CH6h7y94033mD58uUsX76cs846i+9973sK7CISS0203GFHl0t610y/fv34+te/XnCXTDUP+VsToiGId+HooiKSW80N+Zva915sYE+Kig75q+AuUnY9YsjfKJBPmzZNgb2S0v80REFepKrUXHCHIMAXcvJURKSnqMngDiiwV1rUQleLXaQq1cTVMiIikp/Ywd3M6szsz2b2UPh+nJn9ycxeNbP7zWy38hVTqpa7Wu0i6cx2Pi+1i+XTcv9X4KWU97cBd7j7fsC7wEWlLJiIiBQuVnA3s1HAqcAPwvcGHAtEt3bOBmr27ppqHfJ3/vz5NDQ00NjYSGNjIzfeeGNR+YlImaW32CvYgo97QvVO4N+AgeH7IcBGd4/GqF0FfCLTgmY2FZgKMGbMmMJLWibRkL9Tpkxhzpw5QDAY2Nq1axk9enTB+c6aNYsJEyYwcuTI2Mu0t7dTX9/1IznmmGN46KGHCi6HiPRMOYO7mZ0GrHP3RWbWHE3OkDRjx6u73w3cDcFNTAWWE4Df/34QHR3v7zS9rm4gxxzzXkF5djfkL8Dy5cs7p82aNYuWlhbuuusuIBjy96qrruKYY47hoosuoqWlBTPjwgsvZPTo0Z1D/kZ3qC5dupQrrriCzZs3s9deezFr1ixGjBhBc3MzEydO5A9/+AOnn346V155ZUH1SBxdhSO1qIquIovTcj8KON3MTgH6AIMIWvKDzaw+bL2PAkrzt0NZZArs2abHUc1D/gIsWLCAQw45hJEjR3L77bcnY8gCESm7nMHd3a8FrgUIW+5Xufv5ZvYz4CxgDjAFeLCM5axa5Rzy99BDD+XNN99kwIABPPLII0yePJlXX321PBWpFrrzVZKgCvbXYq5zvxq4wsxeI+iDn1maIu1a48ePZ9GiRTnT5Rryt7m5mRkzZnDxxRfvtGw05G9rayutra0sXryYJ554onN+d0P+Dho0iAEDBgBwyimnsG3bNtavX59X/USkZ8oruLv7fHc/LXy9zN2PcPdPuvvn3f2j8hSxvKp5yN81a9YQDez27LPPsn37doYMGVJ8patZ+nXzuo5epCA1O/xAqVTzkL/z5s3j+9//PvX19fTt25c5c+ZgFb4xQkRqQ00N+VuOq2WSoKJD/opI2SV+yN+eHMBFJCadhAc0cJiISCJVRXDflV1DSaNtJxKqolv/q0HFg3ufPn3YsGGDglQB3J0NGzbQp0+fShdFRKpMxfvcR40axapVq2hra6t0UWpSnz59GDVqVKWLIVJ5VXTrfzWoeHDv3bs348aNq3QxREQSpeLBXUSkpHp4iz1S8T53EZGS6OEnUNMpuIuIJJC6ZUSktmkk0YzUchcRSSC13EWktukSyIzUchcRSSC13KXy1OKSUtD+04Va7iIiCaSWu1SOrnIQKRu13EVEEkgtd6kcXeUgUjZquYuIJJBa7lJ5arGLlJxa7iIiCaTgLiKSQAruIiIJlDO4m1kfM3vWzJ43sxfN7IZw+jgz+5OZvWpm95vZbuUvroiIxBGn5f4RcKy7HwI0AieZ2ZHAbcAd7r4f8C5wUfmKKSIi+cgZ3D2wOXzbO3w4cCwwL5w+G5hclhKKiEjeYvW5m1mdmbUC64DfAK8DG929PUyyCvhEeYooIiL5ihXc3b3D3RuBUcARwAGZkmVa1symmlmLmbW0tbUVXlIREYktr6tl3H0jMB84EhhsZtFNUKOAt7tZ5m53b3L3pqFDhxZTVhERiSnO1TJDzWxw+Lov8PfAS8BTwFlhsinAg+UqpIiI5CfO8AMjgNlmVkdwMJjr7g+Z2VJgjpndBPwZmFnGcoqISB5yBnd3fwH4VIbpywj630VEpMroDlURkQRScBcRSSAFdxGRBFJwFxFJIAV3EZEEUnAXEUkgBXcRkQRScBcRSSAFdxGRBFJwFxFJIAV3EZEEUnAXEUkgBXcRkQRScBcRSSAFdxGRBFJwFxFJIAV3EZEEUnAXEUkgBXcRkQRScBcRSSAFdxGRBFJwFxFJIAV3EdmZWfCQmqXgLiKSQPWVLoCIVJH01nr03n3Xl0WKopa7iEgC5QzuZjbazJ4ys5fM7EUz+9dw+p5m9hszezV83qP8xRWRsnLv2kpPfy81I07LvR240t0PAI4E/tnMDgSuAZ509/2AJ8P3IiJSBXIGd3df7e7Pha/fB14CPgF8FpgdJpsNTC5XIUVkF1OLvebl1eduZmOBTwF/Aoa7+2oIDgDAsG6WmWpmLWbW0tbWVlxpRUQkltjB3cwGAD8HLnf39+Iu5+53u3uTuzcNHTq0kDKKiEieYgV3M+tNENjvc/dfhJPXmtmIcP4IYF15iigiIvmKc7WMATOBl9z9WymzfgVMCV9PAR4sffFERKQQcW5iOgr4J2CxmbWG06YBtwJzzewiYAXw+fIUUURE8pUzuLv7M0B3g0wcV9riiIhIKegOVRGRBFJwF5HiaATJqqTgLiKSQBoVUkQKoxEkq5pa7iIiCaSWu4gUJmqhq8VeldRyFxFJILXcRaQ4arFXJbXcRUQSSMFdRCSBFNxFRBKoZwd33Vknkt/3QN+ZmtGzg7uISEL1zKtldGedSH7fA31nao5a7iIiCdQzW+66s04kv++BvjPxVck2UstdRCSBembLPaLWh0h+3wN9Z7pXZecl1HIXEUmgnt1yFxEplSo7L6GWu4hIAqnlLiJSSlVyXkItd9At1UmWtM82afUpF20nBXcRkSTq2d0yVXbpkpRQ0j7bpNWnXLSdOuVsuZvZvWa2zsyWpEzb08x+Y2avhs97lLeYVaSn/NzrKfUUSag43TKzgJPSpl0DPOnu+wFPhu9rj3vXI3r6e6ldSftsk1afctF26pQzuLv774B30iZ/Fpgdvp4NTC5xuapPeks2qS3bnlJPkYQr9ITqcHdfDRA+D+suoZlNNbMWM2tpa2srcHVl1oOP7omXtM82afUpF22n8l8t4+53u3uTuzcNHTq03Ksrn57yc6+n1FMyq5ZfaqUqR7XUpwIKDe5rzWwEQPi8rnRFEhGRYhUa3H8FTAlfTwEeLE1xakBPacn2lHpKoFrOtZSqHNVSnwqKcynkT4EFwP5mtsrMLgJuBY43s1eB48P3yVcNO0imMlRDuYotR7XUQXa96LPP5/Mv5f6S0H0v501M7n5eN7OOK3FZRKRSqmVEw1KVo1rqU0E9+w7VuKrhrrfuypBp2q7ekYvZPtWwbaUysu3DcZcpZn9J+L6n4N5TZNpxa2VnLqSc1Va3aitPd4opXynrWKrtVO7tXcWfq4J7HNXwEy9bGSq9gxWzfaph20r1yPX5p+8vpVhXQvc9Bfekq+bunFwK+dlcbT+1q6085ZBvHctx8nJXb9ca+FwV3PNRDR9cpjJUQ7mguHJUSx2kcir9yzNhFNyrVWrLIO7Ol6n1UM3dObkU8rO5Gn5qp667GspTbvnWMW76bPMrvV0rvf4Y9GcdIiIJpJZ7tSmkTzxO/181d+fkUkg5K9liT3/fU+72zbeOxezPha6z1Cq9/izUcpdA3DtfE3o3X1nvkCzF7fOlWCYJt+TXYpkrRC33alPIpV410P/XI2T6HBSI8qf9uSQU3GtJOXb2fC6VLHdZKqHYy/iypU9vJWfLt9DyxFkm12dcC59lLZa5wtQtU60K7WfWzl55+gxKQ/tzUWoquC9YEBywFyyodEnoOpJduUaoK+aPM+KWqbt1xJ2Wz7pKKd/t312afLdx3PSFfnaZ0nX3qyDuCdtcZSkkiMb9zEu1bxRb5h7YV19TwX3q1OD5K1+pbDlERKpdTfS519dDR8eO94sXBwfhujpob9/Fhcl1NQIU9lOyVJfRFdo3Gfcys0w3QeW7rmLku/3jlrFUl/EVmi5VtjIX0ucfzSu2zrnKVki6fBXyC6Mc5agBNdFyv+WWzNNvuy3GwvX1waNU6eJIzauU+eZaVynSl6K8papzofmUepuUa9laEdUxbj2Tvj1qRE0E9699DQ49tOu0Qw+FK6+sQGGytaTr6oJHKfIt9GRSqfKptnXFWUd3/dW7uozFylbm9Hmp+1ymeaWua3qe3W3PuOnKrRY//xKpmUNsa2vwPGwYrFu34323otZD1J8TvU/vx4mbLo7UviPo+pOwmHwzybfcudKXYjuUalsWmk+pt0k5ylhq6etPn1dMudLrmD49V3q14CuqZrb+l74Ep5wCZ5wBv/gFPPZYhkSDBwfPGzfS177BAAAIZ0lEQVR2n9HgwbBpEzQ0ZE6XuiNH+UVS06ce/bv7EmQrQ3q+0bS4rYpc64rySV9X6vJRi2/w4K7v40jd1tG64n6Zs23XuGXJtJ2yrT9T+kzbsKOja/my7UvZxN0Xs6XJti9E2ydTHerqdkyPu0/mK+4Jr1KcGMu2v6TOz7atc32vsn0nC90HKqxmgvsPfrDj9RlnBI+s0luk0fv0DzE93YAB+RcuPY/IgAHBgaQcZ34bGoLnzZu7liFOGTs6dj64Re+Lael1t83zVWhZ8l1/pm3Y3cGw2HWVWq71F7M/d7eO9On5lkl2qZoJ7llFX8hNm7q+T28RRvOjtGY7AknUwonSZLoqI+6RPD2v9NZgajnS15VrHel17U6mbZKp/unL5Go1x9nWcZdNnR79mkrNN99fE3HlKkemtHFbb3H3xVxpipW+D9ZiKzTb55SqmDp2t458vpNVqiZOqBalvT1eC6KhYUdLrth1pedVbL7Z5FvuXGkbGopvccXd5rkUWpZ811/M51OqupZ6/aXYn9PXEbeuld4mAoD5Ljxz3NTU5C0tLXkvt2kTTJwIf/xj8H7iRHj0UTj55OB5zQHNHPopqF8SnmVtbOyawfz50NwcvG5tzd7nHh2lGxvhmWe6/qzN98idesSP1g8755u6rmzriPKYPz97ayJXuvRpuVomqWWPs/5My6TKtl1z1au1Ndhe8+d3v85M8zLlEZ2Vz7R+CLprjj666/KZ1p/P9sm0/uh16n6bK//0PDNNh677c5QmU/q409J1lyZ9emq9I3E/w1L0uafmnS7184qkfidTyxz38y8xM1vk7k35LFMT3TIPPwxLl8IjjwTnRZYuhW9+c8fzWVtgwzswvNIFFRGpFu6+yx6HHXaY5+O889z793evr48uTu36eIpJ/hSTOie8S4Nv7t2wc8KGlGmTJgWP7kTz46bPJT2/1HwbGuKtK26ZdmXZu8u3u2XyySNTng0NO3+m0fJx6p0rj3zr0NCw8+eX7/rr6oJHd9snV/5x652aJv27kGkfjLNfdrfuTOvLVsd8PsNC5fo8s5Uj/TMr9PMvEtDiecbbovrczewkM3vFzF4zs2tKdLzpdOONMGYM9O4drS97+l69oE+fUpdCRKT2FNznbmZ1wF+A44FVwELgPHdf2t0yhfS5z5sH550Hu+8OH34YBPj6evjoo+C5vR2etmbcoe1n8znrLDL3gcXpP0yVb/q4+UXy7dssR7q4CulTzNbnHjePTHmWss897nZMVWyfa6b15+qPLqbPPVOaWutzL5Vsfe7ZypG6XA31uRfTcj8CeM3dl7n7x8Ac4LNF5JfR3LnQvz/ccEPQMu/VC/bfP5jXv3/w3K9fcMXcz35W6rWLiNSmYlruZwEnufvF4ft/Av7W3S9NSzcVmAowZsyYw95888281rNwYdA1M3x4cFeqGey5J/TtC4sWwWGHwdatMHo0rFwJTXkd20REqt+uvlomUw/4TkcKd78buBuCbpl8V3L44Tten3RS13kTJnR9P1yXy4iIAMV1y6wCRqe8HwW8XVxxRESkFIoJ7guB/cxsnJntBpwL/Ko0xRIRkWIU3C3j7u1mdinwOFAH3OvuL5asZCIiUrCi7lB190eAR0pUFhERKZHkDxwmItIDKbiLiCSQgruISAIpuIuIJNAuHc/dzNqA/G5R3WEvYH34TMrrbNPyTV/qaZVefzWWSevXPtHT1l8Ke7v70LyWyHcYyUo9CIe8BFpSX2eblm/6Uk+r9PqrsUxav/aJnrb+Sj3ULSMikkAK7iIiCVQTf7MXujvtOe60fNOXelql11+NZdL6K7v+aixTktdfEbv0hKqIiOwa6pYREUkgBXcRkQQqSZ+7mY0GfkQwpvtI4AOgP/AhMJjgIGJ0/TOPHH93LSLSY7UTjLbrwDaCWO3AVmAAMNTds15DX6qWeztwJfAZ4ETgfYK/1qsDHgrfLwQ+Dgu3KlymLXzeDmwKn98BOsKKbA8f0XvC5QnfR9O2ZyiTTiaISLGyxZHUuLMtfO5ImbY6w/yWlGkdBDHxI4I4uIagYfwOsBFYFD6eAX4L3EPwnxnvxCl4SYK7u6929+fC52eAJcA6gqPNT8P1zAR2A/4CjCCobB92BPCB4XM9OzZaL3YE8ail3yd8trR06fTLQERKxTO8/jhlWl34nBp3tqSkbScI5kPYEdMcWBqm6wW8StB4fR/YE/gJQTxsAg4A7gDuAvrFKXDJL4U0s7HApwiOWv2BF8PnPxBUfAjBhqgj2Di9o0UJKrhbyjTCdNvIrK6b6SIipWBpz6n6pLzulfYMQZCOGqZRfBuTklcdMI4gPvYCjmZHjAS4nWD4gr7A2+7+qpltJWbcK+kJVTMbAPwcuAaYTdDnHj3/OEx2NUEFPiQI5LAjeG8Ddmfnn0LRQagDEZHKiYJ1nG7fUSmvox6JDwjiXNRjMYCgSzrqbm4Dlof5vxJO6wCGm1levRElC+5m1psgsP8UmBI+Q9DnDsGJ1Q7g0vC5F0HltqS8jrpaPqbrT5doQ0blzdbXLiJSaunBPDon6GnzU+NVH3a00qMu5t0IAn0vdrTAhxDExPeA8cBQgn7451LyeZ9gMLJRxGzkliS4h0eUmcBLwMFpz/9A0Eo3gpMEI8PnOnb0SXWEaXoBm8N50YlUwufodbYjp06iikihMjUWo2np3TO96NpVE/U+pMagFSlpthPEtX9OmeZp8zYDpxM0bqNAvztBa38AQRfNFIK4mVNJ7lA1s6OB3wOvA/uGhdst5VlEROJrD587gA0EwX4vgv753QguWHnE3S/uLgMNPyAikkC6Q1VEJIEU3EVEEkjBXUQkgRTcRUQSSMFdRCSBFNxFRBJIwV1EJIH+PxYeGq+23XQ6AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0xa4cb9d0518>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "for i in range(0, len(df)):\n",
    "    if df['model'][i] == 0:\n",
    "         c1 = plt.scatter(df['new_date'][i],df['freq'][i],c='r',marker='+')\n",
    "    elif df['model'][i] == 1:\n",
    "         c2 = plt.scatter(df['new_date'][i],df['freq'][i],c='g',marker='o')\n",
    "    elif df['model'][i] == -1:\n",
    "         c3 = plt.scatter(df['new_date'][i],df['freq'][i],c='b',marker='*')\n",
    "    elif df['model'][i] == 2:\n",
    "         c4 = plt.scatter(df['new_date'][i],df['freq'][i],c='k',marker='D')\n",
    "    elif df['model'][i] == 3:\n",
    "         c5 = plt.scatter(df['new_date'][i],df['freq'][i],c='y',marker='s')\n",
    "            \n",
    "            \n",
    "plt.legend([c1, c2, c3,c4,c5], ['Cluster 1', 'Cluster 2','Cluster 3','Cluster 4','Cluster 5'])\n",
    "plt.title('DBSCAN finds 2 clusters and noise')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}