02. Pre-proceessing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [],
   "source": [
    "clien=pd.read_csv('./clien.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "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>추천수</th>\n",
       "      <th>게시판</th>\n",
       "      <th>제목</th>\n",
       "      <th>리플수</th>\n",
       "      <th>아이디</th>\n",
       "      <th>조회수</th>\n",
       "      <th>날짜</th>\n",
       "      <th>문서번호</th>\n",
       "      <th>사진유무</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>요즘 신천지 찌라시 근황</td>\n",
       "      <td>0</td>\n",
       "      <td>미나미모리마치</td>\n",
       "      <td>380</td>\n",
       "      <td>2019-12-28 16:31:51</td>\n",
       "      <td>14437898</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>조선판 위쳐가 나오면 무슨 느낌일까요?</td>\n",
       "      <td>4</td>\n",
       "      <td>CODE</td>\n",
       "      <td>149</td>\n",
       "      <td>2019-12-28 16:30:48</td>\n",
       "      <td>14437895</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>김용민 트윗 근황.jpg</td>\n",
       "      <td>0</td>\n",
       "      <td>umberto_eco</td>\n",
       "      <td>831</td>\n",
       "      <td>2019-12-28 16:30:07</td>\n",
       "      <td>14437894</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>올해 극장에서 재밌게 본 영화들.jpg</td>\n",
       "      <td>6</td>\n",
       "      <td>아하라라</td>\n",
       "      <td>450</td>\n",
       "      <td>2019-12-28 16:28:52</td>\n",
       "      <td>14437890</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>모공</td>\n",
       "      <td>남친을 오너일가로 장가보낸썰 풉니다</td>\n",
       "      <td>0</td>\n",
       "      <td>곰삭은푸</td>\n",
       "      <td>1231</td>\n",
       "      <td>2019-12-28 16:27:11</td>\n",
       "      <td>14437889</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   추천수 게시판                     제목  리플수          아이디   조회수  \\\n",
       "0    0  모공          요즘 신천지 찌라시 근황    0      미나미모리마치   380   \n",
       "1    0  모공  조선판 위쳐가 나오면 무슨 느낌일까요?    4         CODE   149   \n",
       "2    0  모공          김용민 트윗 근황.jpg    0  umberto_eco   831   \n",
       "3    0  모공  올해 극장에서 재밌게 본 영화들.jpg    6         아하라라   450   \n",
       "4   10  모공    남친을 오너일가로 장가보낸썰 풉니다    0         곰삭은푸  1231   \n",
       "\n",
       "                    날짜      문서번호 사진유무  \n",
       "0  2019-12-28 16:31:51  14437898    Y  \n",
       "1  2019-12-28 16:30:48  14437895    Y  \n",
       "2  2019-12-28 16:30:07  14437894    Y  \n",
       "3  2019-12-28 16:28:52  14437890    Y  \n",
       "4  2019-12-28 16:27:11  14437889    Y  "
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clien.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 135679 entries, 0 to 135678\n",
      "Data columns (total 9 columns):\n",
      "추천수     135679 non-null int64\n",
      "게시판     135679 non-null object\n",
      "제목      135679 non-null object\n",
      "리플수     135679 non-null int64\n",
      "아이디     135679 non-null object\n",
      "조회수     135679 non-null object\n",
      "날짜      135679 non-null object\n",
      "문서번호    135679 non-null int64\n",
      "사진유무    135679 non-null object\n",
      "dtypes: int64(3), object(6)\n",
      "memory usage: 9.3+ MB\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "(135679, 9)"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clien.info()\n",
    "clien.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 조회수가 1000이상이면 1k식으로 저장이 되기때문에 조회수 컬럼이 object 타입으로 나옴"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Change date to datetype\n",
    "clien['날짜']=pd.to_datetime(clien['날짜'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\sm208\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  # Remove the CWD from sys.path while we load stuff.\n",
      "C:\\Users\\sm208\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:8: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \n"
     ]
    }
   ],
   "source": [
    "# 조회수 . k 단위 int로 변경\n",
    "clien['조회수int'] =\"\"\n",
    "for i in range(len(clien['조회수'])):\n",
    "    if \"k\" in str(clien['조회수'][i]):\n",
    "        a = str(clien['조회수'][i])\n",
    "        b = a.replace(\"k\",\"0000\").replace(\" \",\"\")\n",
    "        c = round(float(b)*1000)\n",
    "        clien['조회수int'][i] = int(c)\n",
    "    else:\n",
    "        clien['조회수int'][i]= int(clien['조회수'][i])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [],
   "source": [
    "#int변경\n",
    "clien['조회수int'] = clien['조회수int'].astype(int)\n",
    "# clien['조회수int'] = pd.to_numeric(clien.조회수int, errors = 'coerce')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# null값 없음\n",
    "clien['조회수int'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "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>추천수</th>\n",
       "      <th>게시판</th>\n",
       "      <th>제목</th>\n",
       "      <th>리플수</th>\n",
       "      <th>아이디</th>\n",
       "      <th>조회수</th>\n",
       "      <th>날짜</th>\n",
       "      <th>문서번호</th>\n",
       "      <th>사진유무</th>\n",
       "      <th>조회수int</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [추천수, 게시판, 제목, 리플수, 아이디, 조회수, 날짜, 문서번호, 사진유무, 조회수int]\n",
       "Index: []"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 1보다 작은거 없음\n",
    "clien[clien['조회수int']<1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [],
   "source": [
    "# clien Feature 구성\n",
    "clien['date'] = clien['날짜'].dt.date\n",
    "clien['year'] = clien['날짜'].dt.year\n",
    "clien['month'] = clien['날짜'].dt.month\n",
    "clien['day'] = clien['날짜'].dt.day\n",
    "clien['hour'] = clien['날짜'].dt.hour\n",
    "clien['minute'] = clien['날짜'].dt.minute\n",
    "clien['second'] = clien['날짜'].dt.second\n",
    "clien['dayofweek'] = clien['날짜'].dt.dayofweek"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 135679 entries, 0 to 135678\n",
      "Data columns (total 18 columns):\n",
      "추천수          135679 non-null int64\n",
      "게시판          135679 non-null object\n",
      "제목           135679 non-null object\n",
      "리플수          135679 non-null int64\n",
      "아이디          135679 non-null object\n",
      "조회수          135679 non-null object\n",
      "날짜           135679 non-null datetime64[ns]\n",
      "문서번호         135679 non-null int64\n",
      "사진유무         135679 non-null object\n",
      "조회수int       135679 non-null int32\n",
      "date         135679 non-null object\n",
      "year         135679 non-null int64\n",
      "month        135679 non-null int64\n",
      "day          135679 non-null int64\n",
      "hour         135679 non-null int64\n",
      "minute       135679 non-null int64\n",
      "second       135679 non-null int64\n",
      "dayofweek    135679 non-null int64\n",
      "dtypes: datetime64[ns](1), int32(1), int64(10), object(6)\n",
      "memory usage: 18.1+ MB\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "(135679, 18)"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# check basic info and size\n",
    "clien.info()\n",
    "clien.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [],
   "source": [
    "holiday = pd.read_excel('./holiday.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "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>순서</th>\n",
       "      <th>년</th>\n",
       "      <th>월</th>\n",
       "      <th>일</th>\n",
       "      <th>설명</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>새해</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2018</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>설날</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2018</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>설날</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2018</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>설날</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2018</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>삼일절</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   순서     년  월   일   설명\n",
       "0   1  2018  1   1   새해\n",
       "1   2  2018  2  15   설날\n",
       "2   3  2018  2  16   설날\n",
       "3   4  2018  2  17   설날\n",
       "4   5  2018  3   1  삼일절"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "holiday.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [],
   "source": [
    "holiday['일']=holiday['일'].astype(str)\n",
    "holiday['월']=holiday['월'].astype(str)\n",
    "holiday['년']=holiday['년'].astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [],
   "source": [
    "holiday['날짜'] = holiday['년']+\"-\"+holiday['월']+\"-\"+holiday['일']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [],
   "source": [
    "holiday['date']=pd.to_datetime(holiday['날짜'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [],
   "source": [
    "holiday.head()\n",
    "holiday = holiday[['설명','date']]\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [],
   "source": [
    "holiday.to_csv('./holiday.csv', index =False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "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>설명</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>새해</td>\n",
       "      <td>2018-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>설날</td>\n",
       "      <td>2018-02-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>설날</td>\n",
       "      <td>2018-02-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>설날</td>\n",
       "      <td>2018-02-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>삼일절</td>\n",
       "      <td>2018-03-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61</td>\n",
       "      <td>추석</td>\n",
       "      <td>2021-10-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>62</td>\n",
       "      <td>추석</td>\n",
       "      <td>2021-10-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>63</td>\n",
       "      <td>개천절</td>\n",
       "      <td>2021-10-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>64</td>\n",
       "      <td>한글날</td>\n",
       "      <td>2021-10-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>65</td>\n",
       "      <td>크리스마스</td>\n",
       "      <td>2021-12-25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>66 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       설명       date\n",
       "0      새해 2018-01-01\n",
       "1      설날 2018-02-15\n",
       "2      설날 2018-02-16\n",
       "3      설날 2018-02-17\n",
       "4     삼일절 2018-03-01\n",
       "..    ...        ...\n",
       "61     추석 2021-10-21\n",
       "62     추석 2021-10-22\n",
       "63    개천절 2021-10-03\n",
       "64    한글날 2021-10-09\n",
       "65  크리스마스 2021-12-25\n",
       "\n",
       "[66 rows x 2 columns]"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "holiday"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "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>추천수</th>\n",
       "      <th>게시판</th>\n",
       "      <th>제목</th>\n",
       "      <th>리플수</th>\n",
       "      <th>아이디</th>\n",
       "      <th>조회수</th>\n",
       "      <th>날짜</th>\n",
       "      <th>문서번호</th>\n",
       "      <th>사진유무</th>\n",
       "      <th>조회수int</th>\n",
       "      <th>date</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>minute</th>\n",
       "      <th>second</th>\n",
       "      <th>dayofweek</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>요즘 신천지 찌라시 근황</td>\n",
       "      <td>0</td>\n",
       "      <td>미나미모리마치</td>\n",
       "      <td>380</td>\n",
       "      <td>2019-12-28 16:31:51</td>\n",
       "      <td>14437898</td>\n",
       "      <td>Y</td>\n",
       "      <td>380</td>\n",
       "      <td>2019-12-28</td>\n",
       "      <td>2019</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "      <td>16</td>\n",
       "      <td>31</td>\n",
       "      <td>51</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>조선판 위쳐가 나오면 무슨 느낌일까요?</td>\n",
       "      <td>4</td>\n",
       "      <td>CODE</td>\n",
       "      <td>149</td>\n",
       "      <td>2019-12-28 16:30:48</td>\n",
       "      <td>14437895</td>\n",
       "      <td>Y</td>\n",
       "      <td>149</td>\n",
       "      <td>2019-12-28</td>\n",
       "      <td>2019</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "      <td>16</td>\n",
       "      <td>30</td>\n",
       "      <td>48</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>김용민 트윗 근황.jpg</td>\n",
       "      <td>0</td>\n",
       "      <td>umberto_eco</td>\n",
       "      <td>831</td>\n",
       "      <td>2019-12-28 16:30:07</td>\n",
       "      <td>14437894</td>\n",
       "      <td>Y</td>\n",
       "      <td>831</td>\n",
       "      <td>2019-12-28</td>\n",
       "      <td>2019</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "      <td>16</td>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>올해 극장에서 재밌게 본 영화들.jpg</td>\n",
       "      <td>6</td>\n",
       "      <td>아하라라</td>\n",
       "      <td>450</td>\n",
       "      <td>2019-12-28 16:28:52</td>\n",
       "      <td>14437890</td>\n",
       "      <td>Y</td>\n",
       "      <td>450</td>\n",
       "      <td>2019-12-28</td>\n",
       "      <td>2019</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "      <td>16</td>\n",
       "      <td>28</td>\n",
       "      <td>52</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>모공</td>\n",
       "      <td>남친을 오너일가로 장가보낸썰 풉니다</td>\n",
       "      <td>0</td>\n",
       "      <td>곰삭은푸</td>\n",
       "      <td>1231</td>\n",
       "      <td>2019-12-28 16:27:11</td>\n",
       "      <td>14437889</td>\n",
       "      <td>Y</td>\n",
       "      <td>1231</td>\n",
       "      <td>2019-12-28</td>\n",
       "      <td>2019</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "      <td>16</td>\n",
       "      <td>27</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   추천수 게시판                     제목  리플수          아이디   조회수                  날짜  \\\n",
       "0    0  모공          요즘 신천지 찌라시 근황    0      미나미모리마치   380 2019-12-28 16:31:51   \n",
       "1    0  모공  조선판 위쳐가 나오면 무슨 느낌일까요?    4         CODE   149 2019-12-28 16:30:48   \n",
       "2    0  모공          김용민 트윗 근황.jpg    0  umberto_eco   831 2019-12-28 16:30:07   \n",
       "3    0  모공  올해 극장에서 재밌게 본 영화들.jpg    6         아하라라   450 2019-12-28 16:28:52   \n",
       "4   10  모공    남친을 오너일가로 장가보낸썰 풉니다    0         곰삭은푸  1231 2019-12-28 16:27:11   \n",
       "\n",
       "       문서번호 사진유무  조회수int        date  year  month  day  hour  minute  second  \\\n",
       "0  14437898    Y     380  2019-12-28  2019     12   28    16      31      51   \n",
       "1  14437895    Y     149  2019-12-28  2019     12   28    16      30      48   \n",
       "2  14437894    Y     831  2019-12-28  2019     12   28    16      30       7   \n",
       "3  14437890    Y     450  2019-12-28  2019     12   28    16      28      52   \n",
       "4  14437889    Y    1231  2019-12-28  2019     12   28    16      27      11   \n",
       "\n",
       "   dayofweek  \n",
       "0          5  \n",
       "1          5  \n",
       "2          5  \n",
       "3          5  \n",
       "4          5  "
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clien.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [],
   "source": [
    "clien['date'] = clien['date'].astype(str)\n",
    "holiday['date']= holiday['date'].astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [],
   "source": [
    "clien = pd.merge(clien,holiday,how ='left',on ='date')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {},
   "outputs": [],
   "source": [
    "clien['holiday'] = 0\n",
    "clien.loc[(clien['dayofweek'] == 5) | (clien['dayofweek'] == 6)|(clien['설명'].notnull()),'holiday']=1\n",
    "\n",
    "## loc가 중요"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 전처리 끗"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "clien.to_csv('./clien.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "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>추천수</th>\n",
       "      <th>게시판</th>\n",
       "      <th>제목</th>\n",
       "      <th>리플수</th>\n",
       "      <th>아이디</th>\n",
       "      <th>조회수</th>\n",
       "      <th>날짜</th>\n",
       "      <th>문서번호</th>\n",
       "      <th>사진유무</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>요즘 신천지 찌라시 근황</td>\n",
       "      <td>0</td>\n",
       "      <td>미나미모리마치</td>\n",
       "      <td>380</td>\n",
       "      <td>2019-12-28 16:31:51</td>\n",
       "      <td>14437898</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>조선판 위쳐가 나오면 무슨 느낌일까요?</td>\n",
       "      <td>4</td>\n",
       "      <td>CODE</td>\n",
       "      <td>149</td>\n",
       "      <td>2019-12-28 16:30:48</td>\n",
       "      <td>14437895</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>김용민 트윗 근황.jpg</td>\n",
       "      <td>0</td>\n",
       "      <td>umberto_eco</td>\n",
       "      <td>831</td>\n",
       "      <td>2019-12-28 16:30:07</td>\n",
       "      <td>14437894</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>모공</td>\n",
       "      <td>올해 극장에서 재밌게 본 영화들.jpg</td>\n",
       "      <td>6</td>\n",
       "      <td>아하라라</td>\n",
       "      <td>450</td>\n",
       "      <td>2019-12-28 16:28:52</td>\n",
       "      <td>14437890</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>모공</td>\n",
       "      <td>남친을 오너일가로 장가보낸썰 풉니다</td>\n",
       "      <td>0</td>\n",
       "      <td>곰삭은푸</td>\n",
       "      <td>1231</td>\n",
       "      <td>2019-12-28 16:27:11</td>\n",
       "      <td>14437889</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>53813</td>\n",
       "      <td>1</td>\n",
       "      <td>모공</td>\n",
       "      <td>[MUSIC] Asoto Union - Think about'Chu</td>\n",
       "      <td>6</td>\n",
       "      <td>강력한별명</td>\n",
       "      <td>223</td>\n",
       "      <td>2019-12-04 00:06:55</td>\n",
       "      <td>14356183</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>53814</td>\n",
       "      <td>46</td>\n",
       "      <td>모공</td>\n",
       "      <td>마봉춘 응원 합니다</td>\n",
       "      <td>0</td>\n",
       "      <td>횟칼을잡은남자</td>\n",
       "      <td>1154</td>\n",
       "      <td>2019-12-04 00:06:41</td>\n",
       "      <td>14356180</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>53815</td>\n",
       "      <td>22</td>\n",
       "      <td>모공</td>\n",
       "      <td>오늘 pd수첩은 학교 수업시간에 틀어줘야 할 정도네요.</td>\n",
       "      <td>10</td>\n",
       "      <td>lightfeel</td>\n",
       "      <td>1693</td>\n",
       "      <td>2019-12-04 00:06:37</td>\n",
       "      <td>14356179</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>53816</td>\n",
       "      <td>1</td>\n",
       "      <td>모공</td>\n",
       "      <td>i mac 2011 CTO 써멀 재도포.jpg</td>\n",
       "      <td>0</td>\n",
       "      <td>진단</td>\n",
       "      <td>1888</td>\n",
       "      <td>2019-12-04 00:06:11</td>\n",
       "      <td>14356178</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>53817</td>\n",
       "      <td>101</td>\n",
       "      <td>모공</td>\n",
       "      <td>pd 수첩 끝나자마자......</td>\n",
       "      <td>1</td>\n",
       "      <td>perisher</td>\n",
       "      <td>8884</td>\n",
       "      <td>2019-12-04 00:05:29</td>\n",
       "      <td>14356177</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>53818 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       추천수 게시판                                     제목  리플수          아이디   조회수  \\\n",
       "0        0  모공                          요즘 신천지 찌라시 근황    0      미나미모리마치   380   \n",
       "1        0  모공                  조선판 위쳐가 나오면 무슨 느낌일까요?    4         CODE   149   \n",
       "2        0  모공                          김용민 트윗 근황.jpg    0  umberto_eco   831   \n",
       "3        0  모공                  올해 극장에서 재밌게 본 영화들.jpg    6         아하라라   450   \n",
       "4       10  모공                    남친을 오너일가로 장가보낸썰 풉니다    0         곰삭은푸  1231   \n",
       "...    ...  ..                                    ...  ...          ...   ...   \n",
       "53813    1  모공  [MUSIC] Asoto Union - Think about'Chu    6        강력한별명   223   \n",
       "53814   46  모공                             마봉춘 응원 합니다    0      횟칼을잡은남자  1154   \n",
       "53815   22  모공         오늘 pd수첩은 학교 수업시간에 틀어줘야 할 정도네요.   10    lightfeel  1693   \n",
       "53816    1  모공              i mac 2011 CTO 써멀 재도포.jpg    0           진단  1888   \n",
       "53817  101  모공                      pd 수첩 끝나자마자......    1     perisher  8884   \n",
       "\n",
       "                       날짜      문서번호 사진유무  \n",
       "0     2019-12-28 16:31:51  14437898    Y  \n",
       "1     2019-12-28 16:30:48  14437895    Y  \n",
       "2     2019-12-28 16:30:07  14437894    Y  \n",
       "3     2019-12-28 16:28:52  14437890    Y  \n",
       "4     2019-12-28 16:27:11  14437889    Y  \n",
       "...                   ...       ...  ...  \n",
       "53813 2019-12-04 00:06:55  14356183    Y  \n",
       "53814 2019-12-04 00:06:41  14356180    Y  \n",
       "53815 2019-12-04 00:06:37  14356179    Y  \n",
       "53816 2019-12-04 00:06:11  14356178    Y  \n",
       "53817 2019-12-04 00:05:29  14356177    Y  \n",
       "\n",
       "[53818 rows x 9 columns]"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}