Assignment_07_ScaleRate.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import numpy as np\n",
    "\n",
    "import seaborn as sns\n",
    "import matplotlib\n",
    "import matplotlib.pyplot as plt #Visulization\n",
    "from matplotlib import pyplot\n",
    "\n",
    "matplotlib.rc('font',family = 'NanumGothicCoding')\n",
    "\n",
    "\n",
    "from sklearn import metrics\n",
    "from sklearn.model_selection import cross_val_score\n",
    "from sklearn.model_selection import KFold\n",
    "from sklearn.model_selection  import train_test_split\n",
    "from sklearn.model_selection import GridSearchCV\n",
    "from sklearn.pipeline import Pipeline\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "from sklearn.metrics import mean_squared_error, mean_absolute_error\n",
    "\n",
    "\n",
    "from sklearn.ensemble import RandomForestRegressor\n",
    "from sklearn.ensemble import GradientBoostingRegressor\n",
    "from sklearn.linear_model import LinearRegression\n",
    "from sklearn.tree import DecisionTreeRegressor\n",
    "from sklearn.neighbors import KNeighborsRegressor\n",
    "\n",
    "from sklearn.tree import export_graphviz\n",
    "import graphviz\n",
    "\n",
    "import statsmodels.formula.api as smf\n",
    "\n",
    "#ignore warnings\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "\n",
    "###\n",
    "from pandas import set_option\n",
    "from scipy import stats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>PLATE_NO</th>\n",
       "      <th>ROLLING_DATE</th>\n",
       "      <th>SCALE</th>\n",
       "      <th>SPEC</th>\n",
       "      <th>STEEL_KIND</th>\n",
       "      <th>PT_THK</th>\n",
       "      <th>PT_WDTH</th>\n",
       "      <th>PT_LTH</th>\n",
       "      <th>PT_WGT</th>\n",
       "      <th>FUR_NO</th>\n",
       "      <th>...</th>\n",
       "      <th>FUR_HZ_TEMP</th>\n",
       "      <th>FUR_HZ_TIME</th>\n",
       "      <th>FUR_SZ_TEMP</th>\n",
       "      <th>FUR_SZ_TIME</th>\n",
       "      <th>FUR_TIME</th>\n",
       "      <th>FUR_EXTEMP</th>\n",
       "      <th>ROLLING_TEMP_T5</th>\n",
       "      <th>HSB</th>\n",
       "      <th>ROLLING_DESCALING</th>\n",
       "      <th>WORK_GR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PB562774</td>\n",
       "      <td>2008-08-01:00:00:15</td>\n",
       "      <td>양품</td>\n",
       "      <td>AB/EH32-TM</td>\n",
       "      <td>T1</td>\n",
       "      <td>32.25</td>\n",
       "      <td>3707</td>\n",
       "      <td>15109</td>\n",
       "      <td>14180</td>\n",
       "      <td>1호기</td>\n",
       "      <td>...</td>\n",
       "      <td>1144</td>\n",
       "      <td>116</td>\n",
       "      <td>1133</td>\n",
       "      <td>59</td>\n",
       "      <td>282</td>\n",
       "      <td>1133</td>\n",
       "      <td>934</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>2조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PB562775</td>\n",
       "      <td>2008-08-01:00:00:16</td>\n",
       "      <td>양품</td>\n",
       "      <td>AB/EH32-TM</td>\n",
       "      <td>T1</td>\n",
       "      <td>32.25</td>\n",
       "      <td>3707</td>\n",
       "      <td>15109</td>\n",
       "      <td>14180</td>\n",
       "      <td>1호기</td>\n",
       "      <td>...</td>\n",
       "      <td>1144</td>\n",
       "      <td>122</td>\n",
       "      <td>1135</td>\n",
       "      <td>53</td>\n",
       "      <td>283</td>\n",
       "      <td>1135</td>\n",
       "      <td>937</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>2조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PB562776</td>\n",
       "      <td>2008-08-01:00:00:59</td>\n",
       "      <td>양품</td>\n",
       "      <td>NV-E36-TM</td>\n",
       "      <td>T8</td>\n",
       "      <td>33.27</td>\n",
       "      <td>3619</td>\n",
       "      <td>19181</td>\n",
       "      <td>18130</td>\n",
       "      <td>2호기</td>\n",
       "      <td>...</td>\n",
       "      <td>1129</td>\n",
       "      <td>116</td>\n",
       "      <td>1121</td>\n",
       "      <td>55</td>\n",
       "      <td>282</td>\n",
       "      <td>1121</td>\n",
       "      <td>889</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>3조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PB562777</td>\n",
       "      <td>2008-08-01:00:01:24</td>\n",
       "      <td>양품</td>\n",
       "      <td>NV-E36-TM</td>\n",
       "      <td>T8</td>\n",
       "      <td>33.27</td>\n",
       "      <td>3619</td>\n",
       "      <td>19181</td>\n",
       "      <td>18130</td>\n",
       "      <td>2호기</td>\n",
       "      <td>...</td>\n",
       "      <td>1152</td>\n",
       "      <td>125</td>\n",
       "      <td>1127</td>\n",
       "      <td>68</td>\n",
       "      <td>316</td>\n",
       "      <td>1127</td>\n",
       "      <td>885</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>3조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PB562778</td>\n",
       "      <td>2008-08-01:00:01:44</td>\n",
       "      <td>양품</td>\n",
       "      <td>BV-EH36-TM</td>\n",
       "      <td>T8</td>\n",
       "      <td>38.33</td>\n",
       "      <td>3098</td>\n",
       "      <td>13334</td>\n",
       "      <td>12430</td>\n",
       "      <td>3호기</td>\n",
       "      <td>...</td>\n",
       "      <td>1140</td>\n",
       "      <td>134</td>\n",
       "      <td>1128</td>\n",
       "      <td>48</td>\n",
       "      <td>314</td>\n",
       "      <td>1128</td>\n",
       "      <td>873</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>1조</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   PLATE_NO         ROLLING_DATE SCALE        SPEC STEEL_KIND  PT_THK  \\\n",
       "0  PB562774  2008-08-01:00:00:15    양품  AB/EH32-TM         T1   32.25   \n",
       "1  PB562775  2008-08-01:00:00:16    양품  AB/EH32-TM         T1   32.25   \n",
       "2  PB562776  2008-08-01:00:00:59    양품   NV-E36-TM         T8   33.27   \n",
       "3  PB562777  2008-08-01:00:01:24    양품   NV-E36-TM         T8   33.27   \n",
       "4  PB562778  2008-08-01:00:01:44    양품  BV-EH36-TM         T8   38.33   \n",
       "\n",
       "   PT_WDTH  PT_LTH  PT_WGT FUR_NO  ...  FUR_HZ_TEMP  FUR_HZ_TIME  FUR_SZ_TEMP  \\\n",
       "0     3707   15109   14180    1호기  ...         1144          116         1133   \n",
       "1     3707   15109   14180    1호기  ...         1144          122         1135   \n",
       "2     3619   19181   18130    2호기  ...         1129          116         1121   \n",
       "3     3619   19181   18130    2호기  ...         1152          125         1127   \n",
       "4     3098   13334   12430    3호기  ...         1140          134         1128   \n",
       "\n",
       "   FUR_SZ_TIME  FUR_TIME  FUR_EXTEMP  ROLLING_TEMP_T5  HSB ROLLING_DESCALING  \\\n",
       "0           59       282        1133              934   적용                 8   \n",
       "1           53       283        1135              937   적용                 8   \n",
       "2           55       282        1121              889   적용                 8   \n",
       "3           68       316        1127              885   적용                 8   \n",
       "4           48       314        1128              873   적용                 8   \n",
       "\n",
       "   WORK_GR  \n",
       "0       2조  \n",
       "1       2조  \n",
       "2       3조  \n",
       "3       3조  \n",
       "4       1조  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw = pd.read_csv(\"./data/SCALE불량.csv\", encoding = '949')\n",
    "df_raw.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(720, 21)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw.shape\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PLATE_NO              object\n",
       "ROLLING_DATE          object\n",
       "SCALE                 object\n",
       "SPEC                  object\n",
       "STEEL_KIND            object\n",
       "PT_THK               float64\n",
       "PT_WDTH                int64\n",
       "PT_LTH                 int64\n",
       "PT_WGT                 int64\n",
       "FUR_NO                object\n",
       "FUR_NO_ROW             int64\n",
       "FUR_HZ_TEMP            int64\n",
       "FUR_HZ_TIME            int64\n",
       "FUR_SZ_TEMP            int64\n",
       "FUR_SZ_TIME            int64\n",
       "FUR_TIME               int64\n",
       "FUR_EXTEMP             int64\n",
       "ROLLING_TEMP_T5        int64\n",
       "HSB                   object\n",
       "ROLLING_DESCALING      int64\n",
       "WORK_GR               object\n",
       "dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PLATE_NO             0\n",
       "ROLLING_DATE         0\n",
       "SCALE                0\n",
       "SPEC                 0\n",
       "STEEL_KIND           0\n",
       "PT_THK               0\n",
       "PT_WDTH              0\n",
       "PT_LTH               0\n",
       "PT_WGT               0\n",
       "FUR_NO               0\n",
       "FUR_NO_ROW           0\n",
       "FUR_HZ_TEMP          0\n",
       "FUR_HZ_TIME          0\n",
       "FUR_SZ_TEMP          0\n",
       "FUR_SZ_TIME          0\n",
       "FUR_TIME             0\n",
       "FUR_EXTEMP           0\n",
       "ROLLING_TEMP_T5      0\n",
       "HSB                  0\n",
       "ROLLING_DESCALING    0\n",
       "WORK_GR              0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count     720\n",
       "unique      2\n",
       "top        양품\n",
       "freq      489\n",
       "Name: SCALE, dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw['SCALE'].describe()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "720"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw['SCALE'].count()"
   ]
  },
  {
   "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>PT_THK</th>\n",
       "      <th>PT_WDTH</th>\n",
       "      <th>PT_LTH</th>\n",
       "      <th>PT_WGT</th>\n",
       "      <th>FUR_NO_ROW</th>\n",
       "      <th>FUR_HZ_TEMP</th>\n",
       "      <th>FUR_HZ_TIME</th>\n",
       "      <th>FUR_SZ_TEMP</th>\n",
       "      <th>FUR_SZ_TIME</th>\n",
       "      <th>FUR_TIME</th>\n",
       "      <th>FUR_EXTEMP</th>\n",
       "      <th>ROLLING_TEMP_T5</th>\n",
       "      <th>ROLLING_DESCALING</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>720.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>29.267857</td>\n",
       "      <td>2807.127778</td>\n",
       "      <td>34323.269444</td>\n",
       "      <td>41481.777778</td>\n",
       "      <td>1.497222</td>\n",
       "      <td>1155.338889</td>\n",
       "      <td>88.527778</td>\n",
       "      <td>1149.666667</td>\n",
       "      <td>78.802778</td>\n",
       "      <td>300.563889</td>\n",
       "      <td>1149.666667</td>\n",
       "      <td>933.920833</td>\n",
       "      <td>8.319444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>19.152651</td>\n",
       "      <td>517.839690</td>\n",
       "      <td>13828.434837</td>\n",
       "      <td>24751.322015</td>\n",
       "      <td>0.500340</td>\n",
       "      <td>20.866398</td>\n",
       "      <td>37.660799</td>\n",
       "      <td>17.571788</td>\n",
       "      <td>36.421004</td>\n",
       "      <td>45.390303</td>\n",
       "      <td>17.571788</td>\n",
       "      <td>107.863887</td>\n",
       "      <td>1.623252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>12.030000</td>\n",
       "      <td>1800.000000</td>\n",
       "      <td>7893.000000</td>\n",
       "      <td>7820.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1103.000000</td>\n",
       "      <td>43.000000</td>\n",
       "      <td>1113.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>221.000000</td>\n",
       "      <td>1113.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>16.090000</td>\n",
       "      <td>2466.000000</td>\n",
       "      <td>22663.000000</td>\n",
       "      <td>17757.500000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1139.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>1132.000000</td>\n",
       "      <td>57.750000</td>\n",
       "      <td>257.000000</td>\n",
       "      <td>1132.000000</td>\n",
       "      <td>889.750000</td>\n",
       "      <td>6.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>20.130000</td>\n",
       "      <td>2725.000000</td>\n",
       "      <td>37380.000000</td>\n",
       "      <td>36120.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1158.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>1155.000000</td>\n",
       "      <td>67.500000</td>\n",
       "      <td>304.000000</td>\n",
       "      <td>1155.000000</td>\n",
       "      <td>951.000000</td>\n",
       "      <td>8.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>40.000000</td>\n",
       "      <td>3125.000000</td>\n",
       "      <td>43735.000000</td>\n",
       "      <td>61120.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1171.000000</td>\n",
       "      <td>101.000000</td>\n",
       "      <td>1164.000000</td>\n",
       "      <td>86.000000</td>\n",
       "      <td>342.000000</td>\n",
       "      <td>1164.000000</td>\n",
       "      <td>994.250000</td>\n",
       "      <td>10.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>100.340000</td>\n",
       "      <td>4575.000000</td>\n",
       "      <td>54917.000000</td>\n",
       "      <td>115080.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1206.000000</td>\n",
       "      <td>312.000000</td>\n",
       "      <td>1185.000000</td>\n",
       "      <td>294.000000</td>\n",
       "      <td>398.000000</td>\n",
       "      <td>1185.000000</td>\n",
       "      <td>1078.000000</td>\n",
       "      <td>10.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           PT_THK      PT_WDTH        PT_LTH         PT_WGT  FUR_NO_ROW  \\\n",
       "count  720.000000   720.000000    720.000000     720.000000  720.000000   \n",
       "mean    29.267857  2807.127778  34323.269444   41481.777778    1.497222   \n",
       "std     19.152651   517.839690  13828.434837   24751.322015    0.500340   \n",
       "min     12.030000  1800.000000   7893.000000    7820.000000    1.000000   \n",
       "25%     16.090000  2466.000000  22663.000000   17757.500000    1.000000   \n",
       "50%     20.130000  2725.000000  37380.000000   36120.000000    1.000000   \n",
       "75%     40.000000  3125.000000  43735.000000   61120.000000    2.000000   \n",
       "max    100.340000  4575.000000  54917.000000  115080.000000    2.000000   \n",
       "\n",
       "       FUR_HZ_TEMP  FUR_HZ_TIME  FUR_SZ_TEMP  FUR_SZ_TIME    FUR_TIME  \\\n",
       "count   720.000000   720.000000   720.000000   720.000000  720.000000   \n",
       "mean   1155.338889    88.527778  1149.666667    78.802778  300.563889   \n",
       "std      20.866398    37.660799    17.571788    36.421004   45.390303   \n",
       "min    1103.000000    43.000000  1113.000000    35.000000  221.000000   \n",
       "25%    1139.000000    65.000000  1132.000000    57.750000  257.000000   \n",
       "50%    1158.000000    75.000000  1155.000000    67.500000  304.000000   \n",
       "75%    1171.000000   101.000000  1164.000000    86.000000  342.000000   \n",
       "max    1206.000000   312.000000  1185.000000   294.000000  398.000000   \n",
       "\n",
       "        FUR_EXTEMP  ROLLING_TEMP_T5  ROLLING_DESCALING  \n",
       "count   720.000000       720.000000         720.000000  \n",
       "mean   1149.666667       933.920833           8.319444  \n",
       "std      17.571788       107.863887           1.623252  \n",
       "min    1113.000000         0.000000           5.000000  \n",
       "25%    1132.000000       889.750000           6.000000  \n",
       "50%    1155.000000       951.000000           8.000000  \n",
       "75%    1164.000000       994.250000          10.000000  \n",
       "max    1185.000000      1078.000000          10.000000  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# sns.pairplot(df_raw, diag_kind='hist')\n",
    "# plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# sns.pairplot(df_raw,\n",
    "#             diag_kind = 'kde',\n",
    "#             hue = 'SCALE',\n",
    "#             palette='bright')\n",
    "# plt.show()"
   ]
  },
  {
   "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>PLATE_NO</th>\n",
       "      <th>ROLLING_DATE</th>\n",
       "      <th>SCALE</th>\n",
       "      <th>SPEC</th>\n",
       "      <th>STEEL_KIND</th>\n",
       "      <th>PT_THK</th>\n",
       "      <th>PT_WDTH</th>\n",
       "      <th>PT_LTH</th>\n",
       "      <th>PT_WGT</th>\n",
       "      <th>FUR_NO</th>\n",
       "      <th>...</th>\n",
       "      <th>FUR_HZ_TEMP</th>\n",
       "      <th>FUR_HZ_TIME</th>\n",
       "      <th>FUR_SZ_TEMP</th>\n",
       "      <th>FUR_SZ_TIME</th>\n",
       "      <th>FUR_TIME</th>\n",
       "      <th>FUR_EXTEMP</th>\n",
       "      <th>ROLLING_TEMP_T5</th>\n",
       "      <th>HSB</th>\n",
       "      <th>ROLLING_DESCALING</th>\n",
       "      <th>WORK_GR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PB562774</td>\n",
       "      <td>2008-08-01:00:00:15</td>\n",
       "      <td>양품</td>\n",
       "      <td>AB/EH32-TM</td>\n",
       "      <td>T1</td>\n",
       "      <td>32.25</td>\n",
       "      <td>3707</td>\n",
       "      <td>15109</td>\n",
       "      <td>14180</td>\n",
       "      <td>1호기</td>\n",
       "      <td>...</td>\n",
       "      <td>1144</td>\n",
       "      <td>116</td>\n",
       "      <td>1133</td>\n",
       "      <td>59</td>\n",
       "      <td>282</td>\n",
       "      <td>1133</td>\n",
       "      <td>934</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>2조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PB562775</td>\n",
       "      <td>2008-08-01:00:00:16</td>\n",
       "      <td>양품</td>\n",
       "      <td>AB/EH32-TM</td>\n",
       "      <td>T1</td>\n",
       "      <td>32.25</td>\n",
       "      <td>3707</td>\n",
       "      <td>15109</td>\n",
       "      <td>14180</td>\n",
       "      <td>1호기</td>\n",
       "      <td>...</td>\n",
       "      <td>1144</td>\n",
       "      <td>122</td>\n",
       "      <td>1135</td>\n",
       "      <td>53</td>\n",
       "      <td>283</td>\n",
       "      <td>1135</td>\n",
       "      <td>937</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>2조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PB562776</td>\n",
       "      <td>2008-08-01:00:00:59</td>\n",
       "      <td>양품</td>\n",
       "      <td>NV-E36-TM</td>\n",
       "      <td>T8</td>\n",
       "      <td>33.27</td>\n",
       "      <td>3619</td>\n",
       "      <td>19181</td>\n",
       "      <td>18130</td>\n",
       "      <td>2호기</td>\n",
       "      <td>...</td>\n",
       "      <td>1129</td>\n",
       "      <td>116</td>\n",
       "      <td>1121</td>\n",
       "      <td>55</td>\n",
       "      <td>282</td>\n",
       "      <td>1121</td>\n",
       "      <td>889</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>3조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PB562777</td>\n",
       "      <td>2008-08-01:00:01:24</td>\n",
       "      <td>양품</td>\n",
       "      <td>NV-E36-TM</td>\n",
       "      <td>T8</td>\n",
       "      <td>33.27</td>\n",
       "      <td>3619</td>\n",
       "      <td>19181</td>\n",
       "      <td>18130</td>\n",
       "      <td>2호기</td>\n",
       "      <td>...</td>\n",
       "      <td>1152</td>\n",
       "      <td>125</td>\n",
       "      <td>1127</td>\n",
       "      <td>68</td>\n",
       "      <td>316</td>\n",
       "      <td>1127</td>\n",
       "      <td>885</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>3조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PB562778</td>\n",
       "      <td>2008-08-01:00:01:44</td>\n",
       "      <td>양품</td>\n",
       "      <td>BV-EH36-TM</td>\n",
       "      <td>T8</td>\n",
       "      <td>38.33</td>\n",
       "      <td>3098</td>\n",
       "      <td>13334</td>\n",
       "      <td>12430</td>\n",
       "      <td>3호기</td>\n",
       "      <td>...</td>\n",
       "      <td>1140</td>\n",
       "      <td>134</td>\n",
       "      <td>1128</td>\n",
       "      <td>48</td>\n",
       "      <td>314</td>\n",
       "      <td>1128</td>\n",
       "      <td>873</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>1조</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   PLATE_NO         ROLLING_DATE SCALE        SPEC STEEL_KIND  PT_THK  \\\n",
       "0  PB562774  2008-08-01:00:00:15    양품  AB/EH32-TM         T1   32.25   \n",
       "1  PB562775  2008-08-01:00:00:16    양품  AB/EH32-TM         T1   32.25   \n",
       "2  PB562776  2008-08-01:00:00:59    양품   NV-E36-TM         T8   33.27   \n",
       "3  PB562777  2008-08-01:00:01:24    양품   NV-E36-TM         T8   33.27   \n",
       "4  PB562778  2008-08-01:00:01:44    양품  BV-EH36-TM         T8   38.33   \n",
       "\n",
       "   PT_WDTH  PT_LTH  PT_WGT FUR_NO  ...  FUR_HZ_TEMP  FUR_HZ_TIME  FUR_SZ_TEMP  \\\n",
       "0     3707   15109   14180    1호기  ...         1144          116         1133   \n",
       "1     3707   15109   14180    1호기  ...         1144          122         1135   \n",
       "2     3619   19181   18130    2호기  ...         1129          116         1121   \n",
       "3     3619   19181   18130    2호기  ...         1152          125         1127   \n",
       "4     3098   13334   12430    3호기  ...         1140          134         1128   \n",
       "\n",
       "   FUR_SZ_TIME  FUR_TIME  FUR_EXTEMP  ROLLING_TEMP_T5  HSB ROLLING_DESCALING  \\\n",
       "0           59       282        1133              934   적용                 8   \n",
       "1           53       283        1135              937   적용                 8   \n",
       "2           55       282        1121              889   적용                 8   \n",
       "3           68       316        1127              885   적용                 8   \n",
       "4           48       314        1128              873   적용                 8   \n",
       "\n",
       "   WORK_GR  \n",
       "0       2조  \n",
       "1       2조  \n",
       "2       3조  \n",
       "3       3조  \n",
       "4       1조  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PLATE_NO              object\n",
       "ROLLING_DATE          object\n",
       "SCALE                 object\n",
       "SPEC                  object\n",
       "STEEL_KIND            object\n",
       "PT_THK               float64\n",
       "PT_WDTH                int64\n",
       "PT_LTH                 int64\n",
       "PT_WGT                 int64\n",
       "FUR_NO                object\n",
       "FUR_NO_ROW             int64\n",
       "FUR_HZ_TEMP            int64\n",
       "FUR_HZ_TIME            int64\n",
       "FUR_SZ_TEMP            int64\n",
       "FUR_SZ_TIME            int64\n",
       "FUR_TIME               int64\n",
       "FUR_EXTEMP             int64\n",
       "ROLLING_TEMP_T5        int64\n",
       "HSB                   object\n",
       "ROLLING_DESCALING      int64\n",
       "WORK_GR               object\n",
       "dtype: object"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['2008-08-01:00:00:15', '2008-08-01:00:00:16',\n",
       "       '2008-08-01:00:00:59', '2008-08-01:00:01:24',\n",
       "       '2008-08-01:00:01:44', '2008-08-01:00:02:06',\n",
       "       '2008-08-01:00:02:28', '2008-08-01:00:02:21',\n",
       "       '2008-08-01:00:02:51', '2008-08-01:00:03:15',\n",
       "       '2008-08-01:00:03:24', '2008-08-01:00:04:15',\n",
       "       '2008-08-01:00:04:20', '2008-08-01:00:05:47',\n",
       "       '2008-08-01:00:05:25', '2008-08-01:00:05:16',\n",
       "       '2008-08-01:01:10:14', '2008-08-01:01:10:44',\n",
       "       '2008-08-01:01:11:01', '2008-08-01:01:11:08',\n",
       "       '2008-08-01:01:12:45', '2008-08-01:01:12:49',\n",
       "       '2008-08-01:01:13:47', '2008-08-01:01:13:05',\n",
       "       '2008-08-01:01:14:20', '2008-08-01:01:14:53',\n",
       "       '2008-08-01:01:14:25', '2008-08-01:01:15:39',\n",
       "       '2008-08-01:01:15:14', '2008-08-01:01:15:59',\n",
       "       '2008-08-01:01:15:34', '2008-08-01:02:20:52',\n",
       "       '2008-08-01:02:20:28', '2008-08-01:02:21:27',\n",
       "       '2008-08-01:02:21:11', '2008-08-01:02:21:37',\n",
       "       '2008-08-01:02:21:17', '2008-08-01:02:22:11',\n",
       "       '2008-08-01:02:22:16', '2008-08-01:02:22:18',\n",
       "       '2008-08-01:02:23:09', '2008-08-01:02:23:26',\n",
       "       '2008-08-01:02:24:27', '2008-08-01:02:24:44',\n",
       "       '2008-08-01:02:25:45', '2008-08-01:02:25:17',\n",
       "       '2008-08-01:02:25:50', '2008-08-01:03:30:18',\n",
       "       '2008-08-01:03:30:48', '2008-08-01:03:30:07',\n",
       "       '2008-08-01:03:31:44', '2008-08-01:03:31:31',\n",
       "       '2008-08-01:03:31:37', '2008-08-01:03:32:13',\n",
       "       '2008-08-01:03:32:10', '2008-08-01:03:32:50',\n",
       "       '2008-08-01:03:32:34', '2008-08-01:03:33:48',\n",
       "       '2008-08-01:03:33:52', '2008-08-01:03:33:38',\n",
       "       '2008-08-01:03:34:08', '2008-08-01:03:34:02',\n",
       "       '2008-08-01:03:34:26', '2008-08-01:03:34:14',\n",
       "       '2008-08-01:03:35:27', '2008-08-01:03:35:50',\n",
       "       '2008-08-01:03:35:38', '2008-08-01:04:40:56',\n",
       "       '2008-08-01:04:40:12', '2008-08-01:04:40:16',\n",
       "       '2008-08-01:04:41:42', '2008-08-01:04:41:29',\n",
       "       '2008-08-01:04:42:25', '2008-08-01:04:43:58',\n",
       "       '2008-08-01:04:41:04', '2008-08-01:04:43:30',\n",
       "       '2008-08-01:04:44:30', '2008-08-01:04:45:03',\n",
       "       '2008-08-01:05:50:36', '2008-08-01:05:50:06',\n",
       "       '2008-08-01:05:51:17', '2008-08-01:05:51:45',\n",
       "       '2008-08-01:05:52:21', '2008-08-01:05:52:32',\n",
       "       '2008-08-01:05:52:22', '2008-08-01:05:53:45',\n",
       "       '2008-08-01:05:53:58', '2008-08-01:05:53:39',\n",
       "       '2008-08-01:05:54:08', '2008-08-01:05:54:28',\n",
       "       '2008-08-01:05:54:29', '2008-08-01:05:54:26',\n",
       "       '2008-08-01:05:55:53', '2008-08-01:05:55:44',\n",
       "       '2008-08-01:05:55:04', '2008-08-01:05:55:16',\n",
       "       '2008-08-01:06:60:50', '2008-08-01:06:60:13',\n",
       "       '2008-08-01:06:60:32', '2008-08-01:06:60:12',\n",
       "       '2008-08-01:06:61:33', '2008-08-01:06:61:18',\n",
       "       '2008-08-01:06:61:27', '2008-08-01:06:61:49',\n",
       "       '2008-08-01:06:62:02', '2008-08-01:06:62:20',\n",
       "       '2008-08-01:06:62:05', '2008-08-01:06:62:16',\n",
       "       '2008-08-01:06:63:42', '2008-08-01:06:63:16',\n",
       "       '2008-08-01:06:63:49', '2008-08-01:06:63:19',\n",
       "       '2008-08-01:06:64:58', '2008-08-01:06:64:53',\n",
       "       '2008-08-01:06:64:16', '2008-08-01:06:65:45',\n",
       "       '2008-08-01:06:65:33', '2008-08-01:06:65:57',\n",
       "       '2008-08-01:06:65:03', '2008-08-01:07:70:37',\n",
       "       '2008-08-01:07:70:29', '2008-08-01:07:70:56',\n",
       "       '2008-08-01:07:70:36', '2008-08-01:07:71:04',\n",
       "       '2008-08-01:07:71:24', '2008-08-01:07:71:21',\n",
       "       '2008-08-01:07:71:32', '2008-08-01:07:72:20',\n",
       "       '2008-08-01:07:72:35', '2008-08-01:07:72:46',\n",
       "       '2008-08-01:07:72:58', '2008-08-01:07:73:03',\n",
       "       '2008-08-01:07:73:30', '2008-08-01:07:73:53',\n",
       "       '2008-08-01:07:73:14', '2008-08-01:07:74:32',\n",
       "       '2008-08-01:07:74:01', '2008-08-01:07:74:30',\n",
       "       '2008-08-01:07:74:28', '2008-08-01:07:75:52',\n",
       "       '2008-08-01:07:75:35', '2008-08-01:07:75:49',\n",
       "       '2008-08-01:08:80:22', '2008-08-01:08:80:12',\n",
       "       '2008-08-01:08:80:23', '2008-08-01:08:80:35',\n",
       "       '2008-08-01:08:81:49', '2008-08-01:08:81:45',\n",
       "       '2008-08-01:08:81:03', '2008-08-01:08:81:05',\n",
       "       '2008-08-01:08:82:22', '2008-08-01:08:82:02',\n",
       "       '2008-08-01:08:82:59', '2008-08-01:08:82:11',\n",
       "       '2008-08-01:08:82:39', '2008-08-01:08:82:57',\n",
       "       '2008-08-01:08:83:13', '2008-08-01:08:83:08',\n",
       "       '2008-08-01:08:83:45', '2008-08-01:08:85:20',\n",
       "       '2008-08-01:08:85:49', '2008-08-01:08:84:38',\n",
       "       '2008-08-01:08:85:27', '2008-08-01:09:90:22',\n",
       "       '2008-08-01:09:90:57', '2008-08-01:09:90:50',\n",
       "       '2008-08-01:09:91:43', '2008-08-01:09:90:45',\n",
       "       '2008-08-01:09:90:39', '2008-08-01:09:91:42',\n",
       "       '2008-08-01:09:91:37', '2008-08-01:09:91:41',\n",
       "       '2008-08-01:09:91:30', '2008-08-01:09:92:22',\n",
       "       '2008-08-01:09:92:11', '2008-08-01:09:92:06',\n",
       "       '2008-08-01:09:92:56', '2008-08-01:09:92:47',\n",
       "       '2008-08-01:10:00:06', '2008-08-01:09:94:29',\n",
       "       '2008-08-01:10:01:30', '2008-08-01:10:01:03',\n",
       "       '2008-08-01:10:01:26', '2008-08-01:10:01:50',\n",
       "       '2008-08-01:10:01:22', '2008-08-01:10:02:49',\n",
       "       '2008-08-01:10:02:10', '2008-08-01:10:02:41',\n",
       "       '2008-08-01:10:03:38', '2008-08-01:10:03:45',\n",
       "       '2008-08-01:10:03:21', '2008-08-01:10:03:16',\n",
       "       '2008-08-01:10:04:54', '2008-08-01:10:04:53',\n",
       "       '2008-08-01:10:03:58', '2008-08-01:10:04:44',\n",
       "       '2008-08-01:10:04:40', '2008-08-01:10:05:36',\n",
       "       '2008-08-01:10:05:34', '2008-08-01:10:05:35',\n",
       "       '2008-08-01:10:05:33', '2008-08-01:10:04:38',\n",
       "       '2008-08-01:10:05:37', '2008-08-01:11:10:29',\n",
       "       '2008-08-01:11:10:42', '2008-08-01:11:10:04',\n",
       "       '2008-08-01:11:10:47', '2008-08-01:11:10:06',\n",
       "       '2008-08-01:11:11:12', '2008-08-01:11:11:14',\n",
       "       '2008-08-01:11:11:37', '2008-08-01:11:11:31',\n",
       "       '2008-08-01:11:11:42', '2008-08-01:11:12:30',\n",
       "       '2008-08-01:11:12:31', '2008-08-01:11:12:22',\n",
       "       '2008-08-01:11:12:16', '2008-08-01:11:12:26',\n",
       "       '2008-08-01:11:13:28', '2008-08-01:11:13:40',\n",
       "       '2008-08-01:11:13:50', '2008-08-01:11:13:37',\n",
       "       '2008-08-01:11:14:00', '2008-08-01:11:13:16',\n",
       "       '2008-08-01:11:15:16', '2008-08-01:11:14:30',\n",
       "       '2008-08-01:11:14:45', '2008-08-01:11:14:46',\n",
       "       '2008-08-01:11:15:50', '2008-08-01:11:15:01',\n",
       "       '2008-08-01:11:15:58', '2008-08-01:11:15:00',\n",
       "       '2008-08-01:12:20:03', '2008-08-01:12:20:13',\n",
       "       '2008-08-01:12:20:54', '2008-08-01:12:20:15',\n",
       "       '2008-08-01:12:21:31', '2008-08-01:12:20:21',\n",
       "       '2008-08-01:12:21:35', '2008-08-01:12:21:38',\n",
       "       '2008-08-01:12:21:02', '2008-08-01:12:22:05',\n",
       "       '2008-08-01:12:22:13', '2008-08-01:12:22:27',\n",
       "       '2008-08-01:12:22:35', '2008-08-01:12:23:20',\n",
       "       '2008-08-01:12:23:30', '2008-08-01:12:23:45',\n",
       "       '2008-08-01:12:23:37', '2008-08-01:12:23:13',\n",
       "       '2008-08-01:12:24:37', '2008-08-01:12:24:05',\n",
       "       '2008-08-01:12:24:26', '2008-08-01:12:25:10',\n",
       "       '2008-08-01:12:25:30', '2008-08-01:12:24:16',\n",
       "       '2008-08-01:12:25:57', '2008-08-01:12:25:52',\n",
       "       '2008-08-01:13:30:18', '2008-08-01:13:30:38',\n",
       "       '2008-08-01:13:30:10', '2008-08-01:13:30:01',\n",
       "       '2008-08-01:13:31:18', '2008-08-01:13:31:02',\n",
       "       '2008-08-01:13:31:21', '2008-08-01:13:31:49',\n",
       "       '2008-08-01:13:32:17', '2008-08-01:13:32:01',\n",
       "       '2008-08-01:13:32:23', '2008-08-01:13:32:34',\n",
       "       '2008-08-01:13:33:45', '2008-08-01:13:33:55',\n",
       "       '2008-08-01:13:33:12', '2008-08-01:13:33:32',\n",
       "       '2008-08-01:13:34:09', '2008-08-01:13:34:31',\n",
       "       '2008-08-01:13:34:24', '2008-08-01:13:35:15',\n",
       "       '2008-08-01:13:35:36', '2008-08-01:13:35:44',\n",
       "       '2008-08-01:13:35:31', '2008-08-01:13:35:35',\n",
       "       '2008-08-01:14:40:22', '2008-08-01:14:40:54',\n",
       "       '2008-08-01:14:40:56', '2008-08-01:14:40:02',\n",
       "       '2008-08-01:14:41:43', '2008-08-01:14:41:40',\n",
       "       '2008-08-01:14:41:02', '2008-08-01:14:42:18',\n",
       "       '2008-08-01:14:42:38', '2008-08-01:14:42:29',\n",
       "       '2008-08-01:14:42:50', '2008-08-01:14:43:46',\n",
       "       '2008-08-01:14:43:57', '2008-08-01:14:43:09',\n",
       "       '2008-08-01:14:43:50', '2008-08-01:14:44:45',\n",
       "       '2008-08-01:14:44:03', '2008-08-01:14:44:58',\n",
       "       '2008-08-01:14:44:01', '2008-08-01:14:45:48',\n",
       "       '2008-08-01:14:45:07', '2008-08-01:14:45:41',\n",
       "       '2008-08-01:14:45:20', '2008-08-01:15:50:37',\n",
       "       '2008-08-01:15:50:00', '2008-08-01:15:50:09',\n",
       "       '2008-08-01:15:50:30', '2008-08-01:15:51:45',\n",
       "       '2008-08-01:15:51:19', '2008-08-01:15:51:32',\n",
       "       '2008-08-01:15:52:24', '2008-08-01:15:52:07',\n",
       "       '2008-08-01:15:52:41', '2008-08-01:15:52:22',\n",
       "       '2008-08-01:15:53:11', '2008-08-01:15:53:06',\n",
       "       '2008-08-01:15:53:31', '2008-08-01:15:53:27',\n",
       "       '2008-08-01:15:54:02', '2008-08-01:15:54:14',\n",
       "       '2008-08-01:15:54:42', '2008-08-01:15:54:00',\n",
       "       '2008-08-01:15:55:10', '2008-08-01:15:55:38',\n",
       "       '2008-08-01:15:55:06', '2008-08-01:15:55:40',\n",
       "       '2008-08-01:16:60:14', '2008-08-01:16:60:34',\n",
       "       '2008-08-01:16:60:17', '2008-08-01:16:60:21',\n",
       "       '2008-08-01:16:61:49', '2008-08-01:16:61:58',\n",
       "       '2008-08-01:16:61:19', '2008-08-01:16:62:16',\n",
       "       '2008-08-01:16:62:20', '2008-08-01:16:62:42',\n",
       "       '2008-08-01:16:62:39', '2008-08-01:16:62:11',\n",
       "       '2008-08-01:16:63:17', '2008-08-01:16:63:23',\n",
       "       '2008-08-01:16:63:46', '2008-08-01:16:63:37',\n",
       "       '2008-08-01:16:64:48', '2008-08-01:16:64:47',\n",
       "       '2008-08-01:16:64:29', '2008-08-01:16:64:44',\n",
       "       '2008-08-01:16:65:11', '2008-08-01:16:65:59',\n",
       "       '2008-08-01:16:65:15', '2008-08-01:17:70:18',\n",
       "       '2008-08-01:16:65:31', '2008-08-01:17:70:04',\n",
       "       '2008-08-01:17:70:34', '2008-08-01:17:71:11',\n",
       "       '2008-08-01:17:71:22', '2008-08-01:17:72:53',\n",
       "       '2008-08-01:17:70:33', '2008-08-01:17:71:05',\n",
       "       '2008-08-01:17:72:04', '2008-08-01:17:71:38',\n",
       "       '2008-08-01:17:71:47', '2008-08-01:17:72:45',\n",
       "       '2008-08-01:17:72:44', '2008-08-01:17:72:37',\n",
       "       '2008-08-01:17:73:18', '2008-08-01:17:73:36',\n",
       "       '2008-08-01:17:73:45', '2008-08-01:17:73:37',\n",
       "       '2008-08-01:17:74:17', '2008-08-01:17:74:08',\n",
       "       '2008-08-01:17:74:40', '2008-08-01:17:74:27',\n",
       "       '2008-08-01:17:75:00', '2008-08-01:17:75:24',\n",
       "       '2008-08-01:17:75:54', '2008-08-01:17:75:28',\n",
       "       '2008-08-01:18:80:41', '2008-08-01:18:80:53',\n",
       "       '2008-08-01:18:80:30', '2008-08-01:18:81:17',\n",
       "       '2008-08-01:18:81:16', '2008-08-01:18:81:57',\n",
       "       '2008-08-01:18:81:41', '2008-08-01:18:82:18',\n",
       "       '2008-08-01:18:82:38', '2008-08-01:18:82:05',\n",
       "       '2008-08-01:18:83:42', '2008-08-01:18:83:31',\n",
       "       '2008-08-01:18:83:07', '2008-08-01:18:84:08',\n",
       "       '2008-08-01:18:84:56', '2008-08-01:18:84:38',\n",
       "       '2008-08-01:18:84:33', '2008-08-01:18:85:10',\n",
       "       '2008-08-01:18:85:32', '2008-08-01:19:90:28',\n",
       "       '2008-08-01:19:90:54', '2008-08-01:19:91:30',\n",
       "       '2008-08-01:19:91:41', '2008-08-01:19:92:08',\n",
       "       '2008-08-01:19:92:22', '2008-08-01:19:92:50',\n",
       "       '2008-08-01:19:93:33', '2008-08-01:19:93:41',\n",
       "       '2008-08-01:19:94:45', '2008-08-01:19:94:11',\n",
       "       '2008-08-01:19:94:56', '2008-08-01:19:95:17',\n",
       "       '2008-08-01:19:95:14', '2008-08-01:19:95:44',\n",
       "       '2008-08-01:20:00:16', '2008-08-01:20:00:49',\n",
       "       '2008-08-01:20:01:07', '2008-08-01:20:01:15',\n",
       "       '2008-08-01:20:01:53', '2008-08-01:20:02:58',\n",
       "       '2008-08-01:20:02:10', '2008-08-01:20:03:22',\n",
       "       '2008-08-01:20:04:03', '2008-08-01:20:04:50',\n",
       "       '2008-08-01:20:05:43', '2008-08-01:20:05:10',\n",
       "       '2008-08-01:21:10:48', '2008-08-01:21:10:37',\n",
       "       '2008-08-01:21:11:20', '2008-08-01:21:12:39',\n",
       "       '2008-08-01:21:12:23', '2008-08-01:21:12:16',\n",
       "       '2008-08-01:21:13:39', '2008-08-01:21:14:11',\n",
       "       '2008-08-01:21:14:53', '2008-08-01:21:15:56',\n",
       "       '2008-08-01:22:20:26', '2008-08-01:22:21:58',\n",
       "       '2008-08-01:22:22:43', '2008-08-01:22:21:01',\n",
       "       '2008-08-01:22:22:39', '2008-08-01:22:22:14',\n",
       "       '2008-08-01:22:23:12', '2008-08-01:22:24:07',\n",
       "       '2008-08-01:22:24:14', '2008-08-01:22:24:55',\n",
       "       '2008-08-01:22:25:33', '2008-08-01:22:25:51',\n",
       "       '2008-08-01:23:30:27', '2008-08-01:23:30:37',\n",
       "       '2008-08-01:23:30:33', '2008-08-01:23:31:55',\n",
       "       '2008-08-01:23:31:38', '2008-08-01:23:31:00',\n",
       "       '2008-08-01:23:32:13', '2008-08-01:23:32:21',\n",
       "       '2008-08-01:23:32:45', '2008-08-01:23:33:38',\n",
       "       '2008-08-01:23:33:56', '2008-08-01:23:33:19',\n",
       "       '2008-08-01:23:34:47', '2008-08-01:23:34:25',\n",
       "       '2008-08-01:23:35:30', '2008-08-01:23:35:04',\n",
       "       '2008-08-01:23:35:39', '2008-08-01:23:35:07',\n",
       "       '2008-08-02:00:00:51', '2008-08-02:00:00:11',\n",
       "       '2008-08-02:00:00:42', '2008-08-02:00:01:52',\n",
       "       '2008-08-02:00:01:23', '2008-08-02:00:01:24',\n",
       "       '2008-08-02:00:02:45', '2008-08-02:00:02:24',\n",
       "       '2008-08-02:00:02:51', '2008-08-02:00:03:12',\n",
       "       '2008-08-02:00:03:56', '2008-08-02:00:03:21',\n",
       "       '2008-08-02:00:03:42', '2008-08-02:00:04:08',\n",
       "       '2008-08-02:00:04:24', '2008-08-02:00:04:44',\n",
       "       '2008-08-02:00:05:23', '2008-08-02:00:05:53',\n",
       "       '2008-08-02:00:05:49', '2008-08-02:01:10:40',\n",
       "       '2008-08-02:01:10:36', '2008-08-02:01:10:23',\n",
       "       '2008-08-02:02:20:10', '2008-08-02:01:15:42',\n",
       "       '2008-08-02:02:20:47', '2008-08-02:02:22:36',\n",
       "       '2008-08-02:02:22:35', '2008-08-02:02:21:32',\n",
       "       '2008-08-02:02:21:53', '2008-08-02:02:22:38',\n",
       "       '2008-08-02:02:24:43', '2008-08-02:02:24:54',\n",
       "       '2008-08-02:02:24:05', '2008-08-02:02:25:03',\n",
       "       '2008-08-02:02:25:53', '2008-08-02:02:25:12',\n",
       "       '2008-08-02:02:25:51', '2008-08-02:03:30:46',\n",
       "       '2008-08-02:03:31:22', '2008-08-02:03:31:18',\n",
       "       '2008-08-02:03:31:28', '2008-08-02:03:32:35',\n",
       "       '2008-08-02:03:32:45', '2008-08-02:03:33:56',\n",
       "       '2008-08-02:03:33:46', '2008-08-02:03:34:03',\n",
       "       '2008-08-02:03:34:39', '2008-08-02:03:35:16',\n",
       "       '2008-08-02:05:54:49', '2008-08-02:05:54:05',\n",
       "       '2008-08-02:05:55:41', '2008-08-02:05:55:17',\n",
       "       '2008-08-02:05:55:51', '2008-08-02:06:60:18',\n",
       "       '2008-08-02:06:60:22', '2008-08-02:06:61:23',\n",
       "       '2008-08-02:06:61:04', '2008-08-02:06:61:21',\n",
       "       '2008-08-02:06:61:39', '2008-08-02:06:62:07',\n",
       "       '2008-08-02:06:62:46', '2008-08-02:06:62:08',\n",
       "       '2008-08-02:06:62:32', '2008-08-02:06:63:01',\n",
       "       '2008-08-02:06:63:28', '2008-08-02:06:63:18',\n",
       "       '2008-08-02:06:63:44', '2008-08-02:06:64:58',\n",
       "       '2008-08-02:06:64:04', '2008-08-02:06:64:18',\n",
       "       '2008-08-02:06:65:20', '2008-08-02:06:65:46',\n",
       "       '2008-08-02:06:65:11', '2008-08-02:06:65:42',\n",
       "       '2008-08-02:07:70:26', '2008-08-02:07:70:38',\n",
       "       '2008-08-02:07:70:36', '2008-08-02:07:70:22',\n",
       "       '2008-08-02:07:71:13', '2008-08-02:07:71:31',\n",
       "       '2008-08-02:07:71:12', '2008-08-02:07:72:16',\n",
       "       '2008-08-02:07:71:03', '2008-08-02:07:72:44',\n",
       "       '2008-08-02:07:72:09', '2008-08-02:07:73:29',\n",
       "       '2008-08-02:07:73:47', '2008-08-02:07:73:14',\n",
       "       '2008-08-02:07:73:44', '2008-08-02:07:74:13',\n",
       "       '2008-08-02:07:74:39', '2008-08-02:07:74:31',\n",
       "       '2008-08-02:07:74:32', '2008-08-02:07:75:54',\n",
       "       '2008-08-02:07:75:32', '2008-08-02:07:75:02',\n",
       "       '2008-08-02:07:75:16', '2008-08-02:07:75:14',\n",
       "       '2008-08-02:08:80:45', '2008-08-02:08:80:05',\n",
       "       '2008-08-02:08:80:24', '2008-08-02:08:80:38',\n",
       "       '2008-08-02:08:81:50', '2008-08-02:08:81:00',\n",
       "       '2008-08-02:08:81:53', '2008-08-02:08:81:21',\n",
       "       '2008-08-02:08:81:33', '2008-08-02:08:82:08',\n",
       "       '2008-08-02:08:82:51', '2008-08-02:08:82:11',\n",
       "       '2008-08-02:08:83:15', '2008-08-02:08:83:39',\n",
       "       '2008-08-02:08:83:02', '2008-08-02:08:84:00',\n",
       "       '2008-08-02:08:84:44', '2008-08-02:08:84:18',\n",
       "       '2008-08-02:08:84:54', '2008-08-02:08:85:13',\n",
       "       '2008-08-02:08:85:41', '2008-08-02:08:85:54',\n",
       "       '2008-08-02:08:85:43', '2008-08-02:09:90:04',\n",
       "       '2008-08-02:09:90:13', '2008-08-02:09:90:06',\n",
       "       '2008-08-02:09:92:56', '2008-08-02:09:92:41',\n",
       "       '2008-08-02:09:92:29', '2008-08-02:09:93:01',\n",
       "       '2008-08-02:09:93:10', '2008-08-02:09:93:08',\n",
       "       '2008-08-02:09:93:58', '2008-08-02:09:93:18',\n",
       "       '2008-08-02:09:94:46', '2008-08-02:09:94:36',\n",
       "       '2008-08-02:09:94:19', '2008-08-02:09:94:08',\n",
       "       '2008-08-02:09:94:00', '2008-08-02:09:94:51',\n",
       "       '2008-08-02:09:95:40', '2008-08-02:09:95:30',\n",
       "       '2008-08-02:09:95:20', '2008-08-02:09:95:19',\n",
       "       '2008-08-02:09:95:13', '2008-08-02:10:00:16',\n",
       "       '2008-08-02:10:00:37', '2008-08-02:10:00:18',\n",
       "       '2008-08-02:10:00:25', '2008-08-02:10:01:47',\n",
       "       '2008-08-02:10:01:20', '2008-08-02:10:01:49',\n",
       "       '2008-08-02:10:01:16', '2008-08-02:10:02:54',\n",
       "       '2008-08-02:10:02:14', '2008-08-02:10:02:27',\n",
       "       '2008-08-02:10:02:57', '2008-08-02:10:03:54',\n",
       "       '2008-08-02:10:03:13', '2008-08-02:10:03:27',\n",
       "       '2008-08-02:10:03:29', '2008-08-02:10:04:32',\n",
       "       '2008-08-02:10:04:28', '2008-08-02:10:04:00',\n",
       "       '2008-08-02:10:04:27', '2008-08-02:10:04:06',\n",
       "       '2008-08-02:10:05:55', '2008-08-02:10:05:27',\n",
       "       '2008-08-02:10:05:41', '2008-08-02:11:10:15',\n",
       "       '2008-08-02:11:10:48', '2008-08-02:11:10:20',\n",
       "       '2008-08-02:11:10:40', '2008-08-02:11:11:21',\n",
       "       '2008-08-02:11:11:44', '2008-08-02:11:11:11',\n",
       "       '2008-08-02:11:11:33', '2008-08-02:11:12:03',\n",
       "       '2008-08-02:11:12:30', '2008-08-02:11:12:59',\n",
       "       '2008-08-02:11:12:33', '2008-08-02:11:12:31',\n",
       "       '2008-08-02:11:13:34', '2008-08-02:11:13:16',\n",
       "       '2008-08-02:11:13:09', '2008-08-02:11:13:04',\n",
       "       '2008-08-02:11:13:48', '2008-08-02:11:14:47',\n",
       "       '2008-08-02:11:14:39', '2008-08-02:11:14:33',\n",
       "       '2008-08-02:11:14:43', '2008-08-02:11:14:05',\n",
       "       '2008-08-02:11:15:43', '2008-08-02:11:15:44',\n",
       "       '2008-08-02:11:15:58', '2008-08-02:11:15:52',\n",
       "       '2008-08-02:11:15:57', '2008-08-02:12:20:11',\n",
       "       '2008-08-02:12:20:07', '2008-08-02:12:20:43',\n",
       "       '2008-08-02:12:20:34', '2008-08-02:12:20:20',\n",
       "       '2008-08-02:12:22:25', '2008-08-02:12:22:48',\n",
       "       '2008-08-02:12:21:06', '2008-08-02:12:21:29',\n",
       "       '2008-08-02:12:22:13', '2008-08-02:12:23:57',\n",
       "       '2008-08-02:12:23:11', '2008-08-02:12:23:29',\n",
       "       '2008-08-02:12:23:51', '2008-08-02:12:24:29',\n",
       "       '2008-08-02:12:24:53', '2008-08-02:12:24:54',\n",
       "       '2008-08-02:12:24:12', '2008-08-02:12:25:26',\n",
       "       '2008-08-02:12:25:51', '2008-08-02:12:25:42',\n",
       "       '2008-08-02:12:25:02', '2008-08-02:13:30:39',\n",
       "       '2008-08-02:13:30:47', '2008-08-02:13:30:03',\n",
       "       '2008-08-02:13:31:39', '2008-08-02:13:31:03',\n",
       "       '2008-08-02:13:31:36', '2008-08-02:13:33:09',\n",
       "       '2008-08-02:13:33:44', '2008-08-02:13:32:27',\n",
       "       '2008-08-02:13:32:00', '2008-08-02:13:33:26',\n",
       "       '2008-08-02:13:33:52', '2008-08-02:13:34:15',\n",
       "       '2008-08-02:13:34:44', '2008-08-02:13:34:16',\n",
       "       '2008-08-02:13:34:32', '2008-08-02:13:35:24',\n",
       "       '2008-08-02:14:40:33', '2008-08-02:13:35:36',\n",
       "       '2008-08-02:13:35:02', '2008-08-02:14:40:00',\n",
       "       '2008-08-02:13:35:19', '2008-08-02:14:40:53'], dtype=object)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw['PLATE_NO'].unique()\n",
    "df_raw['STEEL_KIND'].unique()\n",
    "df_raw['SPEC'].unique()\n",
    "df_raw['FUR_NO'].unique()\n",
    "df_raw['HSB'].unique()\n",
    "df_raw['WORK_GR'].unique()\n",
    "df_raw['ROLLING_DATE'].unique()\n"
   ]
  },
  {
   "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>PT_THK</th>\n",
       "      <th>PT_WDTH</th>\n",
       "      <th>PT_LTH</th>\n",
       "      <th>PT_WGT</th>\n",
       "      <th>FUR_NO</th>\n",
       "      <th>FUR_NO_ROW</th>\n",
       "      <th>FUR_HZ_TEMP</th>\n",
       "      <th>FUR_HZ_TIME</th>\n",
       "      <th>FUR_SZ_TEMP</th>\n",
       "      <th>FUR_SZ_TIME</th>\n",
       "      <th>FUR_TIME</th>\n",
       "      <th>FUR_EXTEMP</th>\n",
       "      <th>ROLLING_TEMP_T5</th>\n",
       "      <th>HSB</th>\n",
       "      <th>ROLLING_DESCALING</th>\n",
       "      <th>WORK_GR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>32.25</td>\n",
       "      <td>3707</td>\n",
       "      <td>15109</td>\n",
       "      <td>14180</td>\n",
       "      <td>1호기</td>\n",
       "      <td>1</td>\n",
       "      <td>1144</td>\n",
       "      <td>116</td>\n",
       "      <td>1133</td>\n",
       "      <td>59</td>\n",
       "      <td>282</td>\n",
       "      <td>1133</td>\n",
       "      <td>934</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>2조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>32.25</td>\n",
       "      <td>3707</td>\n",
       "      <td>15109</td>\n",
       "      <td>14180</td>\n",
       "      <td>1호기</td>\n",
       "      <td>2</td>\n",
       "      <td>1144</td>\n",
       "      <td>122</td>\n",
       "      <td>1135</td>\n",
       "      <td>53</td>\n",
       "      <td>283</td>\n",
       "      <td>1135</td>\n",
       "      <td>937</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>2조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>33.27</td>\n",
       "      <td>3619</td>\n",
       "      <td>19181</td>\n",
       "      <td>18130</td>\n",
       "      <td>2호기</td>\n",
       "      <td>1</td>\n",
       "      <td>1129</td>\n",
       "      <td>116</td>\n",
       "      <td>1121</td>\n",
       "      <td>55</td>\n",
       "      <td>282</td>\n",
       "      <td>1121</td>\n",
       "      <td>889</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>3조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>33.27</td>\n",
       "      <td>3619</td>\n",
       "      <td>19181</td>\n",
       "      <td>18130</td>\n",
       "      <td>2호기</td>\n",
       "      <td>2</td>\n",
       "      <td>1152</td>\n",
       "      <td>125</td>\n",
       "      <td>1127</td>\n",
       "      <td>68</td>\n",
       "      <td>316</td>\n",
       "      <td>1127</td>\n",
       "      <td>885</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>3조</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>38.33</td>\n",
       "      <td>3098</td>\n",
       "      <td>13334</td>\n",
       "      <td>12430</td>\n",
       "      <td>3호기</td>\n",
       "      <td>1</td>\n",
       "      <td>1140</td>\n",
       "      <td>134</td>\n",
       "      <td>1128</td>\n",
       "      <td>48</td>\n",
       "      <td>314</td>\n",
       "      <td>1128</td>\n",
       "      <td>873</td>\n",
       "      <td>적용</td>\n",
       "      <td>8</td>\n",
       "      <td>1조</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   PT_THK  PT_WDTH  PT_LTH  PT_WGT FUR_NO  FUR_NO_ROW  FUR_HZ_TEMP  \\\n",
       "0   32.25     3707   15109   14180    1호기           1         1144   \n",
       "1   32.25     3707   15109   14180    1호기           2         1144   \n",
       "2   33.27     3619   19181   18130    2호기           1         1129   \n",
       "3   33.27     3619   19181   18130    2호기           2         1152   \n",
       "4   38.33     3098   13334   12430    3호기           1         1140   \n",
       "\n",
       "   FUR_HZ_TIME  FUR_SZ_TEMP  FUR_SZ_TIME  FUR_TIME  FUR_EXTEMP  \\\n",
       "0          116         1133           59       282        1133   \n",
       "1          122         1135           53       283        1135   \n",
       "2          116         1121           55       282        1121   \n",
       "3          125         1127           68       316        1127   \n",
       "4          134         1128           48       314        1128   \n",
       "\n",
       "   ROLLING_TEMP_T5 HSB  ROLLING_DESCALING WORK_GR  \n",
       "0              934  적용                  8      2조  \n",
       "1              937  적용                  8      2조  \n",
       "2              889  적용                  8      3조  \n",
       "3              885  적용                  8      3조  \n",
       "4              873  적용                  8      1조  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw_y = df_raw['SCALE']\n",
    "df_raw_x = df_raw.drop([\"SCALE\",'SPEC','PLATE_NO','STEEL_KIND','ROLLING_DATE'], axis = 1, inplace = False)\n",
    "df_raw_x.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>PT_THK</th>\n",
       "      <th>PT_WDTH</th>\n",
       "      <th>PT_LTH</th>\n",
       "      <th>PT_WGT</th>\n",
       "      <th>FUR_NO_ROW</th>\n",
       "      <th>FUR_HZ_TEMP</th>\n",
       "      <th>FUR_HZ_TIME</th>\n",
       "      <th>FUR_SZ_TEMP</th>\n",
       "      <th>FUR_SZ_TIME</th>\n",
       "      <th>FUR_TIME</th>\n",
       "      <th>...</th>\n",
       "      <th>ROLLING_DESCALING</th>\n",
       "      <th>FUR_NO_1호기</th>\n",
       "      <th>FUR_NO_2호기</th>\n",
       "      <th>FUR_NO_3호기</th>\n",
       "      <th>HSB_미적용</th>\n",
       "      <th>HSB_적용</th>\n",
       "      <th>WORK_GR_1조</th>\n",
       "      <th>WORK_GR_2조</th>\n",
       "      <th>WORK_GR_3조</th>\n",
       "      <th>WORK_GR_4조</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>32.25</td>\n",
       "      <td>3707</td>\n",
       "      <td>15109</td>\n",
       "      <td>14180</td>\n",
       "      <td>1</td>\n",
       "      <td>1144</td>\n",
       "      <td>116</td>\n",
       "      <td>1133</td>\n",
       "      <td>59</td>\n",
       "      <td>282</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>32.25</td>\n",
       "      <td>3707</td>\n",
       "      <td>15109</td>\n",
       "      <td>14180</td>\n",
       "      <td>2</td>\n",
       "      <td>1144</td>\n",
       "      <td>122</td>\n",
       "      <td>1135</td>\n",
       "      <td>53</td>\n",
       "      <td>283</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>33.27</td>\n",
       "      <td>3619</td>\n",
       "      <td>19181</td>\n",
       "      <td>18130</td>\n",
       "      <td>1</td>\n",
       "      <td>1129</td>\n",
       "      <td>116</td>\n",
       "      <td>1121</td>\n",
       "      <td>55</td>\n",
       "      <td>282</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>33.27</td>\n",
       "      <td>3619</td>\n",
       "      <td>19181</td>\n",
       "      <td>18130</td>\n",
       "      <td>2</td>\n",
       "      <td>1152</td>\n",
       "      <td>125</td>\n",
       "      <td>1127</td>\n",
       "      <td>68</td>\n",
       "      <td>316</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>38.33</td>\n",
       "      <td>3098</td>\n",
       "      <td>13334</td>\n",
       "      <td>12430</td>\n",
       "      <td>1</td>\n",
       "      <td>1140</td>\n",
       "      <td>134</td>\n",
       "      <td>1128</td>\n",
       "      <td>48</td>\n",
       "      <td>314</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   PT_THK  PT_WDTH  PT_LTH  PT_WGT  FUR_NO_ROW  FUR_HZ_TEMP  FUR_HZ_TIME  \\\n",
       "0   32.25     3707   15109   14180           1         1144          116   \n",
       "1   32.25     3707   15109   14180           2         1144          122   \n",
       "2   33.27     3619   19181   18130           1         1129          116   \n",
       "3   33.27     3619   19181   18130           2         1152          125   \n",
       "4   38.33     3098   13334   12430           1         1140          134   \n",
       "\n",
       "   FUR_SZ_TEMP  FUR_SZ_TIME  FUR_TIME  ...  ROLLING_DESCALING  FUR_NO_1호기  \\\n",
       "0         1133           59       282  ...                  8           1   \n",
       "1         1135           53       283  ...                  8           1   \n",
       "2         1121           55       282  ...                  8           0   \n",
       "3         1127           68       316  ...                  8           0   \n",
       "4         1128           48       314  ...                  8           0   \n",
       "\n",
       "   FUR_NO_2호기  FUR_NO_3호기  HSB_미적용  HSB_적용  WORK_GR_1조  WORK_GR_2조  \\\n",
       "0           0           0        0       1           0           1   \n",
       "1           0           0        0       1           0           1   \n",
       "2           1           0        0       1           0           0   \n",
       "3           1           0        0       1           0           0   \n",
       "4           0           1        0       1           1           0   \n",
       "\n",
       "   WORK_GR_3조  WORK_GR_4조  \n",
       "0           0           0  \n",
       "1           0           0  \n",
       "2           1           0  \n",
       "3           1           0  \n",
       "4           0           0  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw_dummy = pd.get_dummies(df_raw_x)\n",
    "df_raw_dummy.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   불량  양품\n",
       "0   0   1\n",
       "1   0   1\n",
       "2   0   1\n",
       "3   0   1\n",
       "4   0   1"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw_y = df_raw['SCALE']\n",
    "df_raw_y = pd.get_dummies(df_raw_y)\n",
    "df_raw_y.head()"
   ]
  },
  {
   "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>PT_THK</th>\n",
       "      <th>PT_WDTH</th>\n",
       "      <th>PT_LTH</th>\n",
       "      <th>PT_WGT</th>\n",
       "      <th>FUR_NO_ROW</th>\n",
       "      <th>FUR_HZ_TEMP</th>\n",
       "      <th>FUR_HZ_TIME</th>\n",
       "      <th>FUR_SZ_TEMP</th>\n",
       "      <th>FUR_SZ_TIME</th>\n",
       "      <th>FUR_TIME</th>\n",
       "      <th>...</th>\n",
       "      <th>ROLLING_DESCALING</th>\n",
       "      <th>FUR_NO_1호기</th>\n",
       "      <th>FUR_NO_2호기</th>\n",
       "      <th>FUR_NO_3호기</th>\n",
       "      <th>HSB_미적용</th>\n",
       "      <th>HSB_적용</th>\n",
       "      <th>WORK_GR_1조</th>\n",
       "      <th>WORK_GR_2조</th>\n",
       "      <th>WORK_GR_3조</th>\n",
       "      <th>WORK_GR_4조</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>32.25</td>\n",
       "      <td>3707</td>\n",
       "      <td>15109</td>\n",
       "      <td>14180</td>\n",
       "      <td>1</td>\n",
       "      <td>1144</td>\n",
       "      <td>116</td>\n",
       "      <td>1133</td>\n",
       "      <td>59</td>\n",
       "      <td>282</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>32.25</td>\n",
       "      <td>3707</td>\n",
       "      <td>15109</td>\n",
       "      <td>14180</td>\n",
       "      <td>2</td>\n",
       "      <td>1144</td>\n",
       "      <td>122</td>\n",
       "      <td>1135</td>\n",
       "      <td>53</td>\n",
       "      <td>283</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>33.27</td>\n",
       "      <td>3619</td>\n",
       "      <td>19181</td>\n",
       "      <td>18130</td>\n",
       "      <td>1</td>\n",
       "      <td>1129</td>\n",
       "      <td>116</td>\n",
       "      <td>1121</td>\n",
       "      <td>55</td>\n",
       "      <td>282</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>33.27</td>\n",
       "      <td>3619</td>\n",
       "      <td>19181</td>\n",
       "      <td>18130</td>\n",
       "      <td>2</td>\n",
       "      <td>1152</td>\n",
       "      <td>125</td>\n",
       "      <td>1127</td>\n",
       "      <td>68</td>\n",
       "      <td>316</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>38.33</td>\n",
       "      <td>3098</td>\n",
       "      <td>13334</td>\n",
       "      <td>12430</td>\n",
       "      <td>1</td>\n",
       "      <td>1140</td>\n",
       "      <td>134</td>\n",
       "      <td>1128</td>\n",
       "      <td>48</td>\n",
       "      <td>314</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   PT_THK  PT_WDTH  PT_LTH  PT_WGT  FUR_NO_ROW  FUR_HZ_TEMP  FUR_HZ_TIME  \\\n",
       "0   32.25     3707   15109   14180           1         1144          116   \n",
       "1   32.25     3707   15109   14180           2         1144          122   \n",
       "2   33.27     3619   19181   18130           1         1129          116   \n",
       "3   33.27     3619   19181   18130           2         1152          125   \n",
       "4   38.33     3098   13334   12430           1         1140          134   \n",
       "\n",
       "   FUR_SZ_TEMP  FUR_SZ_TIME  FUR_TIME  ...  ROLLING_DESCALING  FUR_NO_1호기  \\\n",
       "0         1133           59       282  ...                  8           1   \n",
       "1         1135           53       283  ...                  8           1   \n",
       "2         1121           55       282  ...                  8           0   \n",
       "3         1127           68       316  ...                  8           0   \n",
       "4         1128           48       314  ...                  8           0   \n",
       "\n",
       "   FUR_NO_2호기  FUR_NO_3호기  HSB_미적용  HSB_적용  WORK_GR_1조  WORK_GR_2조  \\\n",
       "0           0           0        0       1           0           1   \n",
       "1           0           0        0       1           0           1   \n",
       "2           1           0        0       1           0           0   \n",
       "3           1           0        0       1           0           0   \n",
       "4           0           1        0       1           1           0   \n",
       "\n",
       "   WORK_GR_3조  WORK_GR_4조  \n",
       "0           0           0  \n",
       "1           0           0  \n",
       "2           1           0  \n",
       "3           1           0  \n",
       "4           0           0  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw_x = df_raw_dummy\n",
    "df_raw_x.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(720, 21)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_raw.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "train data X size : (504, 22)\n",
      "train data Y size : (504, 2)\n",
      "test data X size : (216, 22)\n",
      "test data Y size : (216, 2)\n"
     ]
    }
   ],
   "source": [
    "df_train_x, df_test_x, df_train_y, df_test_y = train_test_split(df_raw_x, df_raw_y\n",
    "                                                               , test_size = 0.3, random_state = 1234)\n",
    "print('train data X size : {}'.format(df_train_x.shape))\n",
    "print('train data Y size : {}'.format(df_train_y.shape))\n",
    "print('test data X size : {}'.format(df_test_x.shape))\n",
    "print('test data Y size : {}'.format(df_test_y.shape))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<LinearRegression>\n",
      "Score on trainning set : 0.483\n",
      "Score on test set : 0.446\n",
      "mse : 0.122\n",
      "mae : 0.291\n"
     ]
    }
   ],
   "source": [
    "lr = LinearRegression()\n",
    "lr.fit(df_train_x, df_train_y)\n",
    "pred_x = lr.predict(df_test_x)\n",
    "\n",
    "print('<LinearRegression>')\n",
    "print('Score on trainning set : {:.3f}'.format(lr.score(df_train_x, df_train_y)))\n",
    "print('Score on test set : {:.3f}'.format(lr.score(df_test_x, df_test_y)))\n",
    "print('mse : {:.3f}'.format(mean_squared_error(df_test_y, pred_x)))\n",
    "print('mae : {:.3f}'.format(mean_absolute_error(df_test_y, pred_x)))"
   ]
  },
  {
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}