preprocessing_code_WDsize1Min.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[00:00:00]</td>\n",
       "      <td>&lt;11tlalsehrwo&gt;</td>\n",
       "      <td>치마</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[00:00:01]</td>\n",
       "      <td>&lt;eedaee&gt;</td>\n",
       "      <td>야호</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[00:00:01]</td>\n",
       "      <td>&lt;결핍소년&gt;</td>\n",
       "      <td>치마</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[00:00:02]</td>\n",
       "      <td>&lt;lililili1li&gt;</td>\n",
       "      <td>침하</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[00:00:03]</td>\n",
       "      <td>&lt;버디오&gt;</td>\n",
       "      <td>침하</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43058</th>\n",
       "      <td>[02:24:27]</td>\n",
       "      <td>&lt;chocotintin_taste_good&gt;</td>\n",
       "      <td>그립으빈다..</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43059</th>\n",
       "      <td>[02:24:27]</td>\n",
       "      <td>&lt;jong4647&gt;</td>\n",
       "      <td>아</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43060</th>\n",
       "      <td>[02:24:28]</td>\n",
       "      <td>&lt;가벼운&gt;</td>\n",
       "      <td>얼마든지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43061</th>\n",
       "      <td>[02:24:28]</td>\n",
       "      <td>&lt;할머니지팡이부수기&gt;</td>\n",
       "      <td>어디감?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43062</th>\n",
       "      <td>[02:24:28]</td>\n",
       "      <td>&lt;176_66_16_13&gt;</td>\n",
       "      <td>침착맨</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>43063 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         timeline                    userId  comment\n",
       "0      [00:00:00]            <11tlalsehrwo>       치마\n",
       "1      [00:00:01]                  <eedaee>       야호\n",
       "2      [00:00:01]                    <결핍소년>       치마\n",
       "3      [00:00:02]             <lililili1li>       침하\n",
       "4      [00:00:03]                     <버디오>       침하\n",
       "...           ...                       ...      ...\n",
       "43058  [02:24:27]  <chocotintin_taste_good>  그립으빈다..\n",
       "43059  [02:24:27]                <jong4647>        아\n",
       "43060  [02:24:28]                     <가벼운>     얼마든지\n",
       "43061  [02:24:28]               <할머니지팡이부수기>     어디감?\n",
       "43062  [02:24:28]            <176_66_16_13>      침착맨\n",
       "\n",
       "[43063 rows x 3 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"804682340.txt\",sep=' ',names=['timeline','userId','comment'] ,encoding =\"utf-8\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        [00:00:00]\n",
       "1        [00:00:01]\n",
       "2        [00:00:01]\n",
       "3        [00:00:02]\n",
       "4        [00:00:03]\n",
       "            ...    \n",
       "43058    [02:24:27]\n",
       "43059    [02:24:27]\n",
       "43060    [02:24:28]\n",
       "43061    [02:24:28]\n",
       "43062    [02:24:28]\n",
       "Name: timeline, Length: 43063, dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "timeline = df['timeline']\n",
    "timeline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_temp = df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>00:00:00</td>\n",
       "      <td>&lt;11tlalsehrwo&gt;</td>\n",
       "      <td>치마</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>00:00:01</td>\n",
       "      <td>&lt;eedaee&gt;</td>\n",
       "      <td>야호</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>00:00:01</td>\n",
       "      <td>&lt;결핍소년&gt;</td>\n",
       "      <td>치마</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>00:00:02</td>\n",
       "      <td>&lt;lililili1li&gt;</td>\n",
       "      <td>침하</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>00:00:03</td>\n",
       "      <td>&lt;버디오&gt;</td>\n",
       "      <td>침하</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43058</th>\n",
       "      <td>02:24:27</td>\n",
       "      <td>&lt;chocotintin_taste_good&gt;</td>\n",
       "      <td>그립으빈다..</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43059</th>\n",
       "      <td>02:24:27</td>\n",
       "      <td>&lt;jong4647&gt;</td>\n",
       "      <td>아</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43060</th>\n",
       "      <td>02:24:28</td>\n",
       "      <td>&lt;가벼운&gt;</td>\n",
       "      <td>얼마든지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43061</th>\n",
       "      <td>02:24:28</td>\n",
       "      <td>&lt;할머니지팡이부수기&gt;</td>\n",
       "      <td>어디감?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43062</th>\n",
       "      <td>02:24:28</td>\n",
       "      <td>&lt;176_66_16_13&gt;</td>\n",
       "      <td>침착맨</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>43063 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       timeline                    userId  comment\n",
       "0      00:00:00            <11tlalsehrwo>       치마\n",
       "1      00:00:01                  <eedaee>       야호\n",
       "2      00:00:01                    <결핍소년>       치마\n",
       "3      00:00:02             <lililili1li>       침하\n",
       "4      00:00:03                     <버디오>       침하\n",
       "...         ...                       ...      ...\n",
       "43058  02:24:27  <chocotintin_taste_good>  그립으빈다..\n",
       "43059  02:24:27                <jong4647>        아\n",
       "43060  02:24:28                     <가벼운>     얼마든지\n",
       "43061  02:24:28               <할머니지팡이부수기>     어디감?\n",
       "43062  02:24:28            <176_66_16_13>      침착맨\n",
       "\n",
       "[43063 rows x 3 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp[\"timeline\"] = df_temp[\"timeline\"].apply(lambda x: x.replace('[',''))\n",
    "df_temp[\"timeline\"] = df_temp[\"timeline\"].apply(lambda x: x.replace(']',''))\n",
    "df_temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>28727</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;gca004&gt;</td>\n",
       "      <td>??</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28728</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;뚜웳&gt;</td>\n",
       "      <td>ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28729</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;짤셔틀람가&gt;</td>\n",
       "      <td>롯데리아</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28730</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;집착강한집착맨&gt;</td>\n",
       "      <td>돌겠네</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28731</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;얼리열&gt;</td>\n",
       "      <td>????</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28732</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;슈라라라라&gt;</td>\n",
       "      <td>맞는말임</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28733</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;르마코&gt;</td>\n",
       "      <td>뭔소리</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28734</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;megatone&gt;</td>\n",
       "      <td>ㅗ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28735</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;아라따리또&gt;</td>\n",
       "      <td>한번도</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28736</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;mlt_luv&gt;</td>\n",
       "      <td>ㅈ데</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       timeline      userId       comment\n",
       "28727  01:39:00    <gca004>            ??\n",
       "28728  01:39:00        <뚜웳>  ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ\n",
       "28729  01:39:00     <짤셔틀람가>          롯데리아\n",
       "28730  01:39:00   <집착강한집착맨>           돌겠네\n",
       "28731  01:39:00       <얼리열>          ????\n",
       "28732  01:39:00     <슈라라라라>          맞는말임\n",
       "28733  01:39:00       <르마코>           뭔소리\n",
       "28734  01:39:00  <megatone>             ㅗ\n",
       "28735  01:39:00     <아라따리또>           한번도\n",
       "28736  01:39:00   <mlt_luv>            ㅈ데"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "highlight1 = df_temp[df_temp['timeline']=='01:39:00']\n",
    "highlight1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>28393</th>\n",
       "      <td>01:38:00</td>\n",
       "      <td>&lt;멜로멜&gt;</td>\n",
       "      <td>ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28394</th>\n",
       "      <td>01:38:00</td>\n",
       "      <td>&lt;쏜디&gt;</td>\n",
       "      <td>서브웨이를</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28395</th>\n",
       "      <td>01:38:00</td>\n",
       "      <td>&lt;송어1&gt;</td>\n",
       "      <td>ㅋㅋㅋㅋㅋㅋㅋㅋ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28396</th>\n",
       "      <td>01:38:00</td>\n",
       "      <td>&lt;위시윙&gt;</td>\n",
       "      <td>억칭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28397</th>\n",
       "      <td>01:38:00</td>\n",
       "      <td>&lt;milk200ml&gt;</td>\n",
       "      <td>건갱한맛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28727</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;gca004&gt;</td>\n",
       "      <td>??</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28728</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;뚜웳&gt;</td>\n",
       "      <td>ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28729</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;짤셔틀람가&gt;</td>\n",
       "      <td>롯데리아</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28730</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;집착강한집착맨&gt;</td>\n",
       "      <td>돌겠네</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28731</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;얼리열&gt;</td>\n",
       "      <td>????</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28732</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;슈라라라라&gt;</td>\n",
       "      <td>맞는말임</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28733</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;르마코&gt;</td>\n",
       "      <td>뭔소리</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28734</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;megatone&gt;</td>\n",
       "      <td>ㅗ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28735</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;아라따리또&gt;</td>\n",
       "      <td>한번도</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28736</th>\n",
       "      <td>01:39:00</td>\n",
       "      <td>&lt;mlt_luv&gt;</td>\n",
       "      <td>ㅈ데</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29313</th>\n",
       "      <td>01:40:00</td>\n",
       "      <td>&lt;슬도&gt;</td>\n",
       "      <td>가격은</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29314</th>\n",
       "      <td>01:40:00</td>\n",
       "      <td>&lt;흰색레알트랙탑&gt;</td>\n",
       "      <td>맘스터치에</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29315</th>\n",
       "      <td>01:40:00</td>\n",
       "      <td>&lt;깁투더슨&gt;</td>\n",
       "      <td>오달수</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       timeline       userId             comment\n",
       "28393  01:38:00        <멜로멜>  ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ\n",
       "28394  01:38:00         <쏜디>               서브웨이를\n",
       "28395  01:38:00        <송어1>            ㅋㅋㅋㅋㅋㅋㅋㅋ\n",
       "28396  01:38:00        <위시윙>                  억칭\n",
       "28397  01:38:00  <milk200ml>                건갱한맛\n",
       "28727  01:39:00     <gca004>                  ??\n",
       "28728  01:39:00         <뚜웳>        ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ\n",
       "28729  01:39:00      <짤셔틀람가>                롯데리아\n",
       "28730  01:39:00    <집착강한집착맨>                 돌겠네\n",
       "28731  01:39:00        <얼리열>                ????\n",
       "28732  01:39:00      <슈라라라라>                맞는말임\n",
       "28733  01:39:00        <르마코>                 뭔소리\n",
       "28734  01:39:00   <megatone>                   ㅗ\n",
       "28735  01:39:00      <아라따리또>                 한번도\n",
       "28736  01:39:00    <mlt_luv>                  ㅈ데\n",
       "29313  01:40:00         <슬도>                 가격은\n",
       "29314  01:40:00    <흰색레알트랙탑>               맘스터치에\n",
       "29315  01:40:00       <깁투더슨>                 오달수"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "high1 = df_temp[df_temp['timeline'].isin(['01:38:00','01:39:00','01:40:00'])]\n",
    "high1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ 서브웨이를 ㅋㅋㅋㅋㅋㅋㅋㅋ 억칭 건갱한맛 ?? ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ 롯데리아 돌겠네 ???? 맞는말임 뭔소리 ㅗ 한번도 ㅈ데 가격은 맘스터치에 오달수'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "high1_com = \" \".join(high1[\"comment\"].astype(str))\n",
    "high1_com"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ',\n",
       " '서브웨이',\n",
       " '를',\n",
       " 'ㅋㅋㅋㅋㅋㅋㅋㅋ',\n",
       " '억칭',\n",
       " '건갱',\n",
       " '한',\n",
       " '맛',\n",
       " '??',\n",
       " 'ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ',\n",
       " '롯데리아',\n",
       " '돌겠네',\n",
       " '????',\n",
       " '맞는말',\n",
       " '임',\n",
       " '뭔',\n",
       " '소리',\n",
       " 'ㅗ',\n",
       " '한번',\n",
       " '도',\n",
       " 'ㅈ',\n",
       " '데',\n",
       " '가격',\n",
       " '은',\n",
       " '맘스터치',\n",
       " '에',\n",
       " '오달수']"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from konlpy.tag import Okt  \n",
    "okt=Okt()  \n",
    "word_list = okt.morphs(high1_com)\n",
    "word_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ': 1,\n",
       " '서브웨이': 1,\n",
       " '를': 1,\n",
       " 'ㅋㅋㅋㅋㅋㅋㅋㅋ': 1,\n",
       " '억칭': 1,\n",
       " '건갱': 1,\n",
       " '한': 1,\n",
       " '맛': 1,\n",
       " '??': 1,\n",
       " 'ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ': 1,\n",
       " '롯데리아': 1,\n",
       " '돌겠네': 1,\n",
       " '????': 1,\n",
       " '맞는말': 1,\n",
       " '임': 1,\n",
       " '뭔': 1,\n",
       " '소리': 1,\n",
       " 'ㅗ': 1,\n",
       " '한번': 1,\n",
       " '도': 1,\n",
       " 'ㅈ': 1,\n",
       " '데': 1,\n",
       " '가격': 1,\n",
       " '은': 1,\n",
       " '맘스터치': 1,\n",
       " '에': 1,\n",
       " '오달수': 1}"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def counter(input_list):\n",
    "    word_count = {}\n",
    "    for word in word_list:\n",
    "        if word in  word_count:\n",
    "            word_count[word] += 1\n",
    "        else:\n",
    "            word_count[word] = 1\n",
    "    return word_count\n",
    "    \n",
    "word_count = counter(word_list)\n",
    "word_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ', 1),\n",
       " ('서브웨이', 1),\n",
       " ('를', 1),\n",
       " ('ㅋㅋㅋㅋㅋㅋㅋㅋ', 1),\n",
       " ('억칭', 1),\n",
       " ('건갱', 1),\n",
       " ('한', 1),\n",
       " ('맛', 1),\n",
       " ('??', 1),\n",
       " ('ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ', 1),\n",
       " ('롯데리아', 1),\n",
       " ('돌겠네', 1),\n",
       " ('????', 1),\n",
       " ('맞는말', 1),\n",
       " ('임', 1),\n",
       " ('뭔', 1),\n",
       " ('소리', 1),\n",
       " ('ㅗ', 1),\n",
       " ('한번', 1),\n",
       " ('도', 1),\n",
       " ('ㅈ', 1),\n",
       " ('데', 1),\n",
       " ('가격', 1),\n",
       " ('은', 1),\n",
       " ('맘스터치', 1),\n",
       " ('에', 1),\n",
       " ('오달수', 1)]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "word_count = sorted(word_count.items(), key=lambda x:x[1], reverse=True)\n",
    "word_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>16945</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;왜죵프렌치블랙&gt;</td>\n",
       "      <td>가지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16946</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;몽태구&gt;</td>\n",
       "      <td>쿵짝짝</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16947</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;까칠한네로&gt;</td>\n",
       "      <td>펑펑</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16948</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;클롭_&gt;</td>\n",
       "      <td>가지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16949</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;gulhee002&gt;</td>\n",
       "      <td>잇을때</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16950</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;도벽너구리&gt;</td>\n",
       "      <td>가지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16951</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;꼬잉꾸앙&gt;</td>\n",
       "      <td>가지뺏다</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16952</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;함정의공명&gt;</td>\n",
       "      <td>펑!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16953</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;와지&gt;</td>\n",
       "      <td>빵이</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16954</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;싱기&gt;</td>\n",
       "      <td>가지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16955</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;요호호호&gt;</td>\n",
       "      <td>가지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16956</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;minchojoah&gt;</td>\n",
       "      <td>절대</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16957</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;Layu_0&gt;</td>\n",
       "      <td>맛없는것만</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16958</th>\n",
       "      <td>01:01:00</td>\n",
       "      <td>&lt;jjbbhh&gt;</td>\n",
       "      <td>그래도</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       timeline        userId comment\n",
       "16945  01:01:00     <왜죵프렌치블랙>      가지\n",
       "16946  01:01:00         <몽태구>     쿵짝짝\n",
       "16947  01:01:00       <까칠한네로>      펑펑\n",
       "16948  01:01:00         <클롭_>      가지\n",
       "16949  01:01:00   <gulhee002>     잇을때\n",
       "16950  01:01:00       <도벽너구리>      가지\n",
       "16951  01:01:00        <꼬잉꾸앙>    가지뺏다\n",
       "16952  01:01:00       <함정의공명>      펑!\n",
       "16953  01:01:00          <와지>      빵이\n",
       "16954  01:01:00          <싱기>      가지\n",
       "16955  01:01:00        <요호호호>      가지\n",
       "16956  01:01:00  <minchojoah>      절대\n",
       "16957  01:01:00      <Layu_0>   맛없는것만\n",
       "16958  01:01:00      <jjbbhh>     그래도"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "highlight2 = df_temp[df_temp['timeline']=='01:01:00']\n",
    "highlight2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>15454</th>\n",
       "      <td>00:58:00</td>\n",
       "      <td>&lt;청올챙이&gt;</td>\n",
       "      <td>투덜투덜</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15455</th>\n",
       "      <td>00:58:00</td>\n",
       "      <td>&lt;machine_manquante&gt;</td>\n",
       "      <td>시이일패</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15456</th>\n",
       "      <td>00:58:00</td>\n",
       "      <td>&lt;우미김&gt;</td>\n",
       "      <td>안먹을라고</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15457</th>\n",
       "      <td>00:58:00</td>\n",
       "      <td>&lt;아라따리또&gt;</td>\n",
       "      <td>옷색이랑같애</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       timeline               userId comment\n",
       "15454  00:58:00               <청올챙이>    투덜투덜\n",
       "15455  00:58:00  <machine_manquante>    시이일패\n",
       "15456  00:58:00                <우미김>   안먹을라고\n",
       "15457  00:58:00              <아라따리또>  옷색이랑같애"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "highlight3 = df_temp[df_temp['timeline']=='00:58:00']\n",
    "highlight3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13871</th>\n",
       "      <td>00:54:00</td>\n",
       "      <td>&lt;꿀뻠&gt;</td>\n",
       "      <td>밀리터리</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13872</th>\n",
       "      <td>00:54:00</td>\n",
       "      <td>&lt;maaaad25&gt;</td>\n",
       "      <td>돌림</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13873</th>\n",
       "      <td>00:54:00</td>\n",
       "      <td>&lt;525252&gt;</td>\n",
       "      <td>그냥</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13874</th>\n",
       "      <td>00:54:00</td>\n",
       "      <td>&lt;올해의사자성어&gt;</td>\n",
       "      <td>밀리터리</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13875</th>\n",
       "      <td>00:54:00</td>\n",
       "      <td>&lt;enemycontrol&gt;</td>\n",
       "      <td>맛이</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13876</th>\n",
       "      <td>00:54:00</td>\n",
       "      <td>&lt;cyosep&gt;</td>\n",
       "      <td>돈주고사는건데</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13877</th>\n",
       "      <td>00:54:00</td>\n",
       "      <td>&lt;네오리스&gt;</td>\n",
       "      <td>군데리아</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13878</th>\n",
       "      <td>00:54:00</td>\n",
       "      <td>&lt;티모라서죽었다&gt;</td>\n",
       "      <td>폴더버거는</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       timeline          userId  comment\n",
       "13871  00:54:00            <꿀뻠>     밀리터리\n",
       "13872  00:54:00      <maaaad25>       돌림\n",
       "13873  00:54:00        <525252>       그냥\n",
       "13874  00:54:00       <올해의사자성어>     밀리터리\n",
       "13875  00:54:00  <enemycontrol>       맛이\n",
       "13876  00:54:00        <cyosep>  돈주고사는건데\n",
       "13877  00:54:00          <네오리스>     군데리아\n",
       "13878  00:54:00       <티모라서죽었다>    폴더버거는"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "highlight4 = df_temp[df_temp['timeline']=='00:54:00']\n",
    "highlight4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>36088</th>\n",
       "      <td>02:02:00</td>\n",
       "      <td>&lt;다현좋아서결혼&gt;</td>\n",
       "      <td>ㅋㅋㅋㅋㅋ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36089</th>\n",
       "      <td>02:02:00</td>\n",
       "      <td>&lt;dney0629&gt;</td>\n",
       "      <td>ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36090</th>\n",
       "      <td>02:02:00</td>\n",
       "      <td>&lt;달빛철도&gt;</td>\n",
       "      <td>ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36091</th>\n",
       "      <td>02:02:00</td>\n",
       "      <td>&lt;쏜디&gt;</td>\n",
       "      <td>ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36092</th>\n",
       "      <td>02:02:00</td>\n",
       "      <td>&lt;김치특공대&gt;</td>\n",
       "      <td>까르륵</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       timeline      userId          comment\n",
       "36088  02:02:00   <다현좋아서결혼>            ㅋㅋㅋㅋㅋ\n",
       "36089  02:02:00  <dney0629>    ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ\n",
       "36090  02:02:00      <달빛철도>  ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ\n",
       "36091  02:02:00        <쏜디>       ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ\n",
       "36092  02:02:00     <김치특공대>              까르륵"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "highlight5 = df_temp[df_temp['timeline']=='02:02:00']\n",
    "highlight5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "~~~ 여기까지 키워드입니다 ~~~"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_temp[\"timeline\"] = df_temp[\"timeline\"].apply(lambda x: datetime.datetime.strptime(x, '%H:%M:%S'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1900-01-01 00:00:00</td>\n",
       "      <td>&lt;11tlalsehrwo&gt;</td>\n",
       "      <td>치마</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1900-01-01 00:00:01</td>\n",
       "      <td>&lt;eedaee&gt;</td>\n",
       "      <td>야호</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1900-01-01 00:00:01</td>\n",
       "      <td>&lt;결핍소년&gt;</td>\n",
       "      <td>치마</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1900-01-01 00:00:02</td>\n",
       "      <td>&lt;lililili1li&gt;</td>\n",
       "      <td>침하</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1900-01-01 00:00:03</td>\n",
       "      <td>&lt;버디오&gt;</td>\n",
       "      <td>침하</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43058</th>\n",
       "      <td>1900-01-01 02:24:27</td>\n",
       "      <td>&lt;chocotintin_taste_good&gt;</td>\n",
       "      <td>그립으빈다..</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43059</th>\n",
       "      <td>1900-01-01 02:24:27</td>\n",
       "      <td>&lt;jong4647&gt;</td>\n",
       "      <td>아</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43060</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;가벼운&gt;</td>\n",
       "      <td>얼마든지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43061</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;할머니지팡이부수기&gt;</td>\n",
       "      <td>어디감?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43062</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;176_66_16_13&gt;</td>\n",
       "      <td>침착맨</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>43063 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 timeline                    userId  comment\n",
       "0     1900-01-01 00:00:00            <11tlalsehrwo>       치마\n",
       "1     1900-01-01 00:00:01                  <eedaee>       야호\n",
       "2     1900-01-01 00:00:01                    <결핍소년>       치마\n",
       "3     1900-01-01 00:00:02             <lililili1li>       침하\n",
       "4     1900-01-01 00:00:03                     <버디오>       침하\n",
       "...                   ...                       ...      ...\n",
       "43058 1900-01-01 02:24:27  <chocotintin_taste_good>  그립으빈다..\n",
       "43059 1900-01-01 02:24:27                <jong4647>        아\n",
       "43060 1900-01-01 02:24:28                     <가벼운>     얼마든지\n",
       "43061 1900-01-01 02:24:28               <할머니지팡이부수기>     어디감?\n",
       "43062 1900-01-01 02:24:28            <176_66_16_13>      침착맨\n",
       "\n",
       "[43063 rows x 3 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.datetime(1900, 1, 1, 0, 1)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "startWindow = datetime.datetime.strptime(\"00:01:00\",'%H:%M:%S')\n",
    "classNum = 1\n",
    "startWindow"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "float"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type((startWindow -  df_temp['timeline'][42291]).total_seconds())\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "class_list = []\n",
    "for i in range(df_temp.shape[0]):\n",
    "    if (startWindow -  df_temp['timeline'][i]).total_seconds() > 0 :\n",
    "        class_list.append(classNum)\n",
    "    else:\n",
    "        startWindow = startWindow + datetime.timedelta(minutes=1)\n",
    "        classNum+=1\n",
    "        class_list.append(classNum)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "      <th>class</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1900-01-01 00:00:00</td>\n",
       "      <td>&lt;11tlalsehrwo&gt;</td>\n",
       "      <td>치마</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1900-01-01 00:00:01</td>\n",
       "      <td>&lt;eedaee&gt;</td>\n",
       "      <td>야호</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1900-01-01 00:00:01</td>\n",
       "      <td>&lt;결핍소년&gt;</td>\n",
       "      <td>치마</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1900-01-01 00:00:02</td>\n",
       "      <td>&lt;lililili1li&gt;</td>\n",
       "      <td>침하</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1900-01-01 00:00:03</td>\n",
       "      <td>&lt;버디오&gt;</td>\n",
       "      <td>침하</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43058</th>\n",
       "      <td>1900-01-01 02:24:27</td>\n",
       "      <td>&lt;chocotintin_taste_good&gt;</td>\n",
       "      <td>그립으빈다..</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43059</th>\n",
       "      <td>1900-01-01 02:24:27</td>\n",
       "      <td>&lt;jong4647&gt;</td>\n",
       "      <td>아</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43060</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;가벼운&gt;</td>\n",
       "      <td>얼마든지</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43061</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;할머니지팡이부수기&gt;</td>\n",
       "      <td>어디감?</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43062</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;176_66_16_13&gt;</td>\n",
       "      <td>침착맨</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>43063 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 timeline                    userId  comment  class\n",
       "0     1900-01-01 00:00:00            <11tlalsehrwo>       치마      1\n",
       "1     1900-01-01 00:00:01                  <eedaee>       야호      1\n",
       "2     1900-01-01 00:00:01                    <결핍소년>       치마      1\n",
       "3     1900-01-01 00:00:02             <lililili1li>       침하      1\n",
       "4     1900-01-01 00:00:03                     <버디오>       침하      1\n",
       "...                   ...                       ...      ...    ...\n",
       "43058 1900-01-01 02:24:27  <chocotintin_taste_good>  그립으빈다..    145\n",
       "43059 1900-01-01 02:24:27                <jong4647>        아    145\n",
       "43060 1900-01-01 02:24:28                     <가벼운>     얼마든지    145\n",
       "43061 1900-01-01 02:24:28               <할머니지팡이부수기>     어디감?    145\n",
       "43062 1900-01-01 02:24:28            <176_66_16_13>      침착맨    145\n",
       "\n",
       "[43063 rows x 4 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp['class'] = class_list\n",
    "df_temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "75"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df_temp[df_temp['class'] == 1]['userId'])  #총 댓글 수\n",
    "len(df_temp[df_temp['class'] == 1]['userId'].unique()) # 참여 유저 수"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "      <th>class</th>\n",
       "      <th>com_len</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1900-01-01 00:00:00</td>\n",
       "      <td>&lt;11tlalsehrwo&gt;</td>\n",
       "      <td>치마</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1900-01-01 00:00:01</td>\n",
       "      <td>&lt;eedaee&gt;</td>\n",
       "      <td>야호</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1900-01-01 00:00:01</td>\n",
       "      <td>&lt;결핍소년&gt;</td>\n",
       "      <td>치마</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1900-01-01 00:00:02</td>\n",
       "      <td>&lt;lililili1li&gt;</td>\n",
       "      <td>침하</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1900-01-01 00:00:03</td>\n",
       "      <td>&lt;버디오&gt;</td>\n",
       "      <td>침하</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43058</th>\n",
       "      <td>1900-01-01 02:24:27</td>\n",
       "      <td>&lt;chocotintin_taste_good&gt;</td>\n",
       "      <td>그립으빈다..</td>\n",
       "      <td>145</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43059</th>\n",
       "      <td>1900-01-01 02:24:27</td>\n",
       "      <td>&lt;jong4647&gt;</td>\n",
       "      <td>아</td>\n",
       "      <td>145</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43060</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;가벼운&gt;</td>\n",
       "      <td>얼마든지</td>\n",
       "      <td>145</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43061</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;할머니지팡이부수기&gt;</td>\n",
       "      <td>어디감?</td>\n",
       "      <td>145</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43062</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;176_66_16_13&gt;</td>\n",
       "      <td>침착맨</td>\n",
       "      <td>145</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>43063 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 timeline                    userId  comment  class  com_len\n",
       "0     1900-01-01 00:00:00            <11tlalsehrwo>       치마      1        2\n",
       "1     1900-01-01 00:00:01                  <eedaee>       야호      1        2\n",
       "2     1900-01-01 00:00:01                    <결핍소년>       치마      1        2\n",
       "3     1900-01-01 00:00:02             <lililili1li>       침하      1        2\n",
       "4     1900-01-01 00:00:03                     <버디오>       침하      1        2\n",
       "...                   ...                       ...      ...    ...      ...\n",
       "43058 1900-01-01 02:24:27  <chocotintin_taste_good>  그립으빈다..    145        7\n",
       "43059 1900-01-01 02:24:27                <jong4647>        아    145        1\n",
       "43060 1900-01-01 02:24:28                     <가벼운>     얼마든지    145        4\n",
       "43061 1900-01-01 02:24:28               <할머니지팡이부수기>     어디감?    145        4\n",
       "43062 1900-01-01 02:24:28            <176_66_16_13>      침착맨    145        3\n",
       "\n",
       "[43063 rows x 5 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp[\"com_len\"] = df_temp[\"comment\"].apply(lambda x: len(x))\n",
    "df_temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>timeline</th>\n",
       "      <th>userId</th>\n",
       "      <th>comment</th>\n",
       "      <th>class</th>\n",
       "      <th>com_len</th>\n",
       "      <th>com_exc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1900-01-01 00:00:00</td>\n",
       "      <td>&lt;11tlalsehrwo&gt;</td>\n",
       "      <td>치마</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1900-01-01 00:00:01</td>\n",
       "      <td>&lt;eedaee&gt;</td>\n",
       "      <td>야호</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1900-01-01 00:00:01</td>\n",
       "      <td>&lt;결핍소년&gt;</td>\n",
       "      <td>치마</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1900-01-01 00:00:02</td>\n",
       "      <td>&lt;lililili1li&gt;</td>\n",
       "      <td>침하</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1900-01-01 00:00:03</td>\n",
       "      <td>&lt;버디오&gt;</td>\n",
       "      <td>침하</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43058</th>\n",
       "      <td>1900-01-01 02:24:27</td>\n",
       "      <td>&lt;chocotintin_taste_good&gt;</td>\n",
       "      <td>그립으빈다..</td>\n",
       "      <td>145</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43059</th>\n",
       "      <td>1900-01-01 02:24:27</td>\n",
       "      <td>&lt;jong4647&gt;</td>\n",
       "      <td>아</td>\n",
       "      <td>145</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43060</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;가벼운&gt;</td>\n",
       "      <td>얼마든지</td>\n",
       "      <td>145</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43061</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;할머니지팡이부수기&gt;</td>\n",
       "      <td>어디감?</td>\n",
       "      <td>145</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43062</th>\n",
       "      <td>1900-01-01 02:24:28</td>\n",
       "      <td>&lt;176_66_16_13&gt;</td>\n",
       "      <td>침착맨</td>\n",
       "      <td>145</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>43063 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 timeline                    userId  comment  class  com_len  \\\n",
       "0     1900-01-01 00:00:00            <11tlalsehrwo>       치마      1        2   \n",
       "1     1900-01-01 00:00:01                  <eedaee>       야호      1        2   \n",
       "2     1900-01-01 00:00:01                    <결핍소년>       치마      1        2   \n",
       "3     1900-01-01 00:00:02             <lililili1li>       침하      1        2   \n",
       "4     1900-01-01 00:00:03                     <버디오>       침하      1        2   \n",
       "...                   ...                       ...      ...    ...      ...   \n",
       "43058 1900-01-01 02:24:27  <chocotintin_taste_good>  그립으빈다..    145        7   \n",
       "43059 1900-01-01 02:24:27                <jong4647>        아    145        1   \n",
       "43060 1900-01-01 02:24:28                     <가벼운>     얼마든지    145        4   \n",
       "43061 1900-01-01 02:24:28               <할머니지팡이부수기>     어디감?    145        4   \n",
       "43062 1900-01-01 02:24:28            <176_66_16_13>      침착맨    145        3   \n",
       "\n",
       "       com_exc  \n",
       "0            0  \n",
       "1            0  \n",
       "2            0  \n",
       "3            0  \n",
       "4            0  \n",
       "...        ...  \n",
       "43058        0  \n",
       "43059        0  \n",
       "43060        0  \n",
       "43061        0  \n",
       "43062        0  \n",
       "\n",
       "[43063 rows x 6 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp[\"com_exc\"] = df_temp[\"comment\"].apply(lambda x: x.count('ㅋ')+x.count('ㅎ')+x.count('!'))\n",
    "df_temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>class</th>\n",
       "      <th>com_len</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>3.366071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>3.908163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>4.977444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>3.804054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>5.761905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>141</td>\n",
       "      <td>5.862823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>142</td>\n",
       "      <td>4.138889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>143</td>\n",
       "      <td>4.182073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>144</td>\n",
       "      <td>3.785942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>145</td>\n",
       "      <td>4.226744</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>145 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     class   com_len\n",
       "0        1  3.366071\n",
       "1        2  3.908163\n",
       "2        3  4.977444\n",
       "3        4  3.804054\n",
       "4        5  5.761905\n",
       "..     ...       ...\n",
       "140    141  5.862823\n",
       "141    142  4.138889\n",
       "142    143  4.182073\n",
       "143    144  3.785942\n",
       "144    145  4.226744\n",
       "\n",
       "[145 rows x 2 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp.groupby('class',as_index=False)['com_len'].mean() #댓글 평균 길이"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>class</th>\n",
       "      <th>com_exc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>141</td>\n",
       "      <td>503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>142</td>\n",
       "      <td>432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>143</td>\n",
       "      <td>357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>144</td>\n",
       "      <td>313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>145</td>\n",
       "      <td>172</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>145 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     class  com_exc\n",
       "0        1      112\n",
       "1        2      294\n",
       "2        3      266\n",
       "3        4      148\n",
       "4        5      252\n",
       "..     ...      ...\n",
       "140    141      503\n",
       "141    142      432\n",
       "142    143      357\n",
       "143    144      313\n",
       "144    145      172\n",
       "\n",
       "[145 rows x 2 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_preprocessed = df_temp.groupby('class',as_index=False)['com_exc'].count()  #댓글 평균 길이\n",
    "df_preprocessed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>class</th>\n",
       "      <th>com_exc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>00:00:00</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>00:01:00</td>\n",
       "      <td>294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>00:02:00</td>\n",
       "      <td>266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>00:03:00</td>\n",
       "      <td>148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>00:04:00</td>\n",
       "      <td>252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>02:20:00</td>\n",
       "      <td>503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>02:21:00</td>\n",
       "      <td>432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>02:22:00</td>\n",
       "      <td>357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>02:23:00</td>\n",
       "      <td>313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>02:24:00</td>\n",
       "      <td>172</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>145 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        class  com_exc\n",
       "0    00:00:00      112\n",
       "1    00:01:00      294\n",
       "2    00:02:00      266\n",
       "3    00:03:00      148\n",
       "4    00:04:00      252\n",
       "..        ...      ...\n",
       "140  02:20:00      503\n",
       "141  02:21:00      432\n",
       "142  02:22:00      357\n",
       "143  02:23:00      313\n",
       "144  02:24:00      172\n",
       "\n",
       "[145 rows x 2 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_preprocessed[\"class\"] = df_preprocessed[\"class\"].apply(lambda x: (datetime.datetime.strptime(\"00:00:00\", '%H:%M:%S') + datetime.timedelta(minutes=x-1)).strftime('%H:%M:%S'))\n",
    "df_preprocessed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>class</th>\n",
       "      <th>com_exc</th>\n",
       "      <th>com_len</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>00:00:00</td>\n",
       "      <td>112</td>\n",
       "      <td>3.366071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>00:01:00</td>\n",
       "      <td>294</td>\n",
       "      <td>3.908163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>00:02:00</td>\n",
       "      <td>266</td>\n",
       "      <td>4.977444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>00:03:00</td>\n",
       "      <td>148</td>\n",
       "      <td>3.804054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>00:04:00</td>\n",
       "      <td>252</td>\n",
       "      <td>5.761905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>02:20:00</td>\n",
       "      <td>503</td>\n",
       "      <td>5.862823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>02:21:00</td>\n",
       "      <td>432</td>\n",
       "      <td>4.138889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>02:22:00</td>\n",
       "      <td>357</td>\n",
       "      <td>4.182073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>02:23:00</td>\n",
       "      <td>313</td>\n",
       "      <td>3.785942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>02:24:00</td>\n",
       "      <td>172</td>\n",
       "      <td>4.226744</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>145 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        class  com_exc   com_len\n",
       "0    00:00:00      112  3.366071\n",
       "1    00:01:00      294  3.908163\n",
       "2    00:02:00      266  4.977444\n",
       "3    00:03:00      148  3.804054\n",
       "4    00:04:00      252  5.761905\n",
       "..        ...      ...       ...\n",
       "140  02:20:00      503  5.862823\n",
       "141  02:21:00      432  4.138889\n",
       "142  02:22:00      357  4.182073\n",
       "143  02:23:00      313  3.785942\n",
       "144  02:24:00      172  4.226744\n",
       "\n",
       "[145 rows x 3 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_preprocessed['com_len'] = df_temp.groupby('class',as_index=False)['com_len'].mean()['com_len'] \n",
    "df_preprocessed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>class</th>\n",
       "      <th>com_exc</th>\n",
       "      <th>com_len</th>\n",
       "      <th>com_cnt</th>\n",
       "      <th>user_cnt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>00:00:00</td>\n",
       "      <td>112</td>\n",
       "      <td>3.366071</td>\n",
       "      <td>112</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>00:01:00</td>\n",
       "      <td>294</td>\n",
       "      <td>3.908163</td>\n",
       "      <td>294</td>\n",
       "      <td>169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>00:02:00</td>\n",
       "      <td>266</td>\n",
       "      <td>4.977444</td>\n",
       "      <td>266</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>00:03:00</td>\n",
       "      <td>148</td>\n",
       "      <td>3.804054</td>\n",
       "      <td>148</td>\n",
       "      <td>108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>00:04:00</td>\n",
       "      <td>252</td>\n",
       "      <td>5.761905</td>\n",
       "      <td>252</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>02:20:00</td>\n",
       "      <td>503</td>\n",
       "      <td>5.862823</td>\n",
       "      <td>503</td>\n",
       "      <td>246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>02:21:00</td>\n",
       "      <td>432</td>\n",
       "      <td>4.138889</td>\n",
       "      <td>432</td>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>02:22:00</td>\n",
       "      <td>357</td>\n",
       "      <td>4.182073</td>\n",
       "      <td>357</td>\n",
       "      <td>204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>02:23:00</td>\n",
       "      <td>313</td>\n",
       "      <td>3.785942</td>\n",
       "      <td>313</td>\n",
       "      <td>171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>02:24:00</td>\n",
       "      <td>172</td>\n",
       "      <td>4.226744</td>\n",
       "      <td>172</td>\n",
       "      <td>121</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>145 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        class  com_exc   com_len  com_cnt  user_cnt\n",
       "0    00:00:00      112  3.366071      112        75\n",
       "1    00:01:00      294  3.908163      294       169\n",
       "2    00:02:00      266  4.977444      266       145\n",
       "3    00:03:00      148  3.804054      148       108\n",
       "4    00:04:00      252  5.761905      252       145\n",
       "..        ...      ...       ...      ...       ...\n",
       "140  02:20:00      503  5.862823      503       246\n",
       "141  02:21:00      432  4.138889      432       251\n",
       "142  02:22:00      357  4.182073      357       204\n",
       "143  02:23:00      313  3.785942      313       171\n",
       "144  02:24:00      172  4.226744      172       121\n",
       "\n",
       "[145 rows x 5 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "com_cnt_lst = []\n",
    "user_cnt_lst = []\n",
    "\n",
    "for i in range(1, df_preprocessed.shape[0]+1):\n",
    "    com_cnt_lst.append(len(df_temp[df_temp['class'] == i]['userId']))\n",
    "    user_cnt_lst.append(len(df_temp[df_temp['class'] == i]['userId'].unique()))\n",
    "    \n",
    "df_preprocessed['com_cnt'] = com_cnt_lst\n",
    "df_preprocessed['user_cnt'] = user_cnt_lst\n",
    "\n",
    "df_preprocessed"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "전처리 종료"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      00:00:00\n",
       "1      00:01:00\n",
       "2      00:02:00\n",
       "3      00:03:00\n",
       "4      00:04:00\n",
       "         ...   \n",
       "140    02:20:00\n",
       "141    02:21:00\n",
       "142    02:22:00\n",
       "143    02:23:00\n",
       "144    02:24:00\n",
       "Name: class, Length: 145, dtype: object"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "TIMESTAMP_FIELD = df_preprocessed[\"class\"]\n",
    "TIMESTAMP_FIELD"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_preprocessed = df_preprocessed.drop('class',axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 145 entries, 0 to 144\n",
      "Data columns (total 4 columns):\n",
      " #   Column    Non-Null Count  Dtype  \n",
      "---  ------    --------------  -----  \n",
      " 0   com_exc   145 non-null    int64  \n",
      " 1   com_len   145 non-null    float64\n",
      " 2   com_cnt   145 non-null    int64  \n",
      " 3   user_cnt  145 non-null    int64  \n",
      "dtypes: float64(1), int64(3)\n",
      "memory usage: 5.7 KB\n"
     ]
    }
   ],
   "source": [
    "df_preprocessed.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "import seaborn as sns\n",
    "sns.set_style(\"darkgrid\")\n",
    "from sklearn.ensemble import IsolationForest"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "IsolationForest(contamination=0.01, max_features=4, n_jobs=-1)"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model=IsolationForest(n_estimators=100, max_samples='auto', n_jobs=-1,\n",
    "                      max_features=4, contamination=0.01)\n",
    "model.fit(df_preprocessed.to_numpy())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>com_exc</th>\n",
       "      <th>com_len</th>\n",
       "      <th>com_cnt</th>\n",
       "      <th>user_cnt</th>\n",
       "      <th>scores</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>112</td>\n",
       "      <td>3.366071</td>\n",
       "      <td>112</td>\n",
       "      <td>75</td>\n",
       "      <td>0.045948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>294</td>\n",
       "      <td>3.908163</td>\n",
       "      <td>294</td>\n",
       "      <td>169</td>\n",
       "      <td>0.238855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>266</td>\n",
       "      <td>4.977444</td>\n",
       "      <td>266</td>\n",
       "      <td>145</td>\n",
       "      <td>0.220206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>148</td>\n",
       "      <td>3.804054</td>\n",
       "      <td>148</td>\n",
       "      <td>108</td>\n",
       "      <td>0.186242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>252</td>\n",
       "      <td>5.761905</td>\n",
       "      <td>252</td>\n",
       "      <td>145</td>\n",
       "      <td>0.202858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>503</td>\n",
       "      <td>5.862823</td>\n",
       "      <td>503</td>\n",
       "      <td>246</td>\n",
       "      <td>0.093374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>432</td>\n",
       "      <td>4.138889</td>\n",
       "      <td>432</td>\n",
       "      <td>251</td>\n",
       "      <td>0.213166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>357</td>\n",
       "      <td>4.182073</td>\n",
       "      <td>357</td>\n",
       "      <td>204</td>\n",
       "      <td>0.239055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>313</td>\n",
       "      <td>3.785942</td>\n",
       "      <td>313</td>\n",
       "      <td>171</td>\n",
       "      <td>0.230229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>172</td>\n",
       "      <td>4.226744</td>\n",
       "      <td>172</td>\n",
       "      <td>121</td>\n",
       "      <td>0.224796</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>145 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     com_exc   com_len  com_cnt  user_cnt    scores\n",
       "0        112  3.366071      112        75  0.045948\n",
       "1        294  3.908163      294       169  0.238855\n",
       "2        266  4.977444      266       145  0.220206\n",
       "3        148  3.804054      148       108  0.186242\n",
       "4        252  5.761905      252       145  0.202858\n",
       "..       ...       ...      ...       ...       ...\n",
       "140      503  5.862823      503       246  0.093374\n",
       "141      432  4.138889      432       251  0.213166\n",
       "142      357  4.182073      357       204  0.239055\n",
       "143      313  3.785942      313       171  0.230229\n",
       "144      172  4.226744      172       121  0.224796\n",
       "\n",
       "[145 rows x 5 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "score = model.decision_function(df_preprocessed.to_numpy())\n",
    "df_result = df_preprocessed.copy()\n",
    "df_result['scores']= score\n",
    "df_result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_result['timeline'] = TIMESTAMP_FIELD"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>com_exc</th>\n",
       "      <th>com_len</th>\n",
       "      <th>com_cnt</th>\n",
       "      <th>user_cnt</th>\n",
       "      <th>scores</th>\n",
       "      <th>timeline</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>586</td>\n",
       "      <td>4.208191</td>\n",
       "      <td>586</td>\n",
       "      <td>357</td>\n",
       "      <td>-0.015987</td>\n",
       "      <td>01:39:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>602</td>\n",
       "      <td>4.835548</td>\n",
       "      <td>602</td>\n",
       "      <td>318</td>\n",
       "      <td>-0.003822</td>\n",
       "      <td>01:01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>567</td>\n",
       "      <td>6.091711</td>\n",
       "      <td>567</td>\n",
       "      <td>337</td>\n",
       "      <td>0.004864</td>\n",
       "      <td>00:58:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>556</td>\n",
       "      <td>3.735612</td>\n",
       "      <td>556</td>\n",
       "      <td>316</td>\n",
       "      <td>0.040744</td>\n",
       "      <td>00:54:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>177</td>\n",
       "      <td>8.039548</td>\n",
       "      <td>177</td>\n",
       "      <td>115</td>\n",
       "      <td>0.042790</td>\n",
       "      <td>00:15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>112</td>\n",
       "      <td>3.366071</td>\n",
       "      <td>112</td>\n",
       "      <td>75</td>\n",
       "      <td>0.045948</td>\n",
       "      <td>00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>513</td>\n",
       "      <td>6.469786</td>\n",
       "      <td>513</td>\n",
       "      <td>275</td>\n",
       "      <td>0.057089</td>\n",
       "      <td>02:02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>433</td>\n",
       "      <td>7.861432</td>\n",
       "      <td>433</td>\n",
       "      <td>227</td>\n",
       "      <td>0.083972</td>\n",
       "      <td>01:32:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>109</td>\n",
       "      <td>3.678899</td>\n",
       "      <td>109</td>\n",
       "      <td>82</td>\n",
       "      <td>0.088589</td>\n",
       "      <td>00:29:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>111</td>\n",
       "      <td>4.090090</td>\n",
       "      <td>111</td>\n",
       "      <td>88</td>\n",
       "      <td>0.089858</td>\n",
       "      <td>00:31:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     com_exc   com_len  com_cnt  user_cnt    scores  timeline\n",
       "99       586  4.208191      586       357 -0.015987  01:39:00\n",
       "61       602  4.835548      602       318 -0.003822  01:01:00\n",
       "58       567  6.091711      567       337  0.004864  00:58:00\n",
       "54       556  3.735612      556       316  0.040744  00:54:00\n",
       "15       177  8.039548      177       115  0.042790  00:15:00\n",
       "0        112  3.366071      112        75  0.045948  00:00:00\n",
       "122      513  6.469786      513       275  0.057089  02:02:00\n",
       "92       433  7.861432      433       227  0.083972  01:32:00\n",
       "29       109  3.678899      109        82  0.088589  00:29:00\n",
       "31       111  4.090090      111        88  0.089858  00:31:00"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_candidate = df_result.sort_values(by = ['scores'], axis = 0, ascending=True).head(10)\n",
    "df_candidate "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "standard = df_result.quantile(q = 0.85,interpolation='nearest')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "com_exc_std = standard[0]\n",
    "com_cnt_std = standard[2]\n",
    "user_cnt_std = standard[3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>com_exc</th>\n",
       "      <th>com_len</th>\n",
       "      <th>com_cnt</th>\n",
       "      <th>user_cnt</th>\n",
       "      <th>scores</th>\n",
       "      <th>timeline</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>586</td>\n",
       "      <td>4.208191</td>\n",
       "      <td>586</td>\n",
       "      <td>357</td>\n",
       "      <td>-0.015987</td>\n",
       "      <td>01:39:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>602</td>\n",
       "      <td>4.835548</td>\n",
       "      <td>602</td>\n",
       "      <td>318</td>\n",
       "      <td>-0.003822</td>\n",
       "      <td>01:01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>567</td>\n",
       "      <td>6.091711</td>\n",
       "      <td>567</td>\n",
       "      <td>337</td>\n",
       "      <td>0.004864</td>\n",
       "      <td>00:58:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>556</td>\n",
       "      <td>3.735612</td>\n",
       "      <td>556</td>\n",
       "      <td>316</td>\n",
       "      <td>0.040744</td>\n",
       "      <td>00:54:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>513</td>\n",
       "      <td>6.469786</td>\n",
       "      <td>513</td>\n",
       "      <td>275</td>\n",
       "      <td>0.057089</td>\n",
       "      <td>02:02:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     com_exc   com_len  com_cnt  user_cnt    scores  timeline\n",
       "99       586  4.208191      586       357 -0.015987  01:39:00\n",
       "61       602  4.835548      602       318 -0.003822  01:01:00\n",
       "58       567  6.091711      567       337  0.004864  00:58:00\n",
       "54       556  3.735612      556       316  0.040744  00:54:00\n",
       "122      513  6.469786      513       275  0.057089  02:02:00"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_final = df_candidate[(df_candidate['com_exc'] > com_exc_std) & (df_candidate['com_cnt'] > com_cnt_std ) & (df_candidate['user_cnt'] > user_cnt_std )]\n",
    "df_final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "99     01:39:00\n",
       "61     01:01:00\n",
       "58     00:58:00\n",
       "54     00:54:00\n",
       "122    02:02:00\n",
       "Name: timeline, dtype: object"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_timeline = df_final['timeline']\n",
    "final_timeline"
   ]
  },
  {
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}