DataPreProcess_mugisung.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "DataPreProcess_mugisung.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "mount_file_id": "18h6g5PGBrSSwiutp4VzWhwuk75Ev5wqR",
      "authorship_tag": "ABX9TyPZp8FQxklzk+pgdhoRl0W3",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Gael-Android/forColab/blob/main/DataPreProcess_mugisung.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "OAmlClCGaDye"
      },
      "source": [
        "from sklearn.datasets import load_iris\n",
        "from sklearn.tree import DecisionTreeClassifier\n",
        "from sklearn.model_selection import train_test_split\n",
        "import pandas\n",
        "import numpy as np\n",
        "import pandas as pd"
      ],
      "execution_count": 1,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 406
        },
        "id": "tO-10jmwraGy",
        "outputId": "310287bf-afbc-461a-a84b-b7420da67244"
      },
      "source": [
        "df = pd.read_excel(\"/content/drive/MyDrive/tax/data/train.xlsx\")\n",
        "df.head()\n",
        "# 실행시 18초 정도 걸림"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>수입거래구분코드</th>\n",
              "      <th>수입종류코드</th>\n",
              "      <th>징수형태코드</th>\n",
              "      <th>신고중량(KG)</th>\n",
              "      <th>과세가격원화금액</th>\n",
              "      <th>운송수단유형코드</th>\n",
              "      <th>반입보세구역부호</th>\n",
              "      <th>HS10단위부호</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",
              "      <th>0</th>\n",
              "      <td>57298928</td>\n",
              "      <td>2020-01-01</td>\n",
              "      <td>121</td>\n",
              "      <td>2O5A2</td>\n",
              "      <td>82ZHWNL</td>\n",
              "      <td>NaN</td>\n",
              "      <td>TQ18AK</td>\n",
              "      <td>D</td>\n",
              "      <td>B</td>\n",
              "      <td>15</td>\n",
              "      <td>23</td>\n",
              "      <td>43</td>\n",
              "      <td>126.0</td>\n",
              "      <td>5.397966e+03</td>\n",
              "      <td>10</td>\n",
              "      <td>2106003</td>\n",
              "      <td>8481900000</td>\n",
              "      <td>US</td>\n",
              "      <td>US</td>\n",
              "      <td>A</td>\n",
              "      <td>8.0</td>\n",
              "      <td>N3</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>85092852</td>\n",
              "      <td>2020-01-01</td>\n",
              "      <td>30</td>\n",
              "      <td>305K5</td>\n",
              "      <td>5IS70LE</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>11</td>\n",
              "      <td>21</td>\n",
              "      <td>11</td>\n",
              "      <td>29845.4</td>\n",
              "      <td>5.730972e+05</td>\n",
              "      <td>40</td>\n",
              "      <td>4077010</td>\n",
              "      <td>2106909099</td>\n",
              "      <td>US</td>\n",
              "      <td>US</td>\n",
              "      <td>A</td>\n",
              "      <td>8.0</td>\n",
              "      <td>A</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>63014158</td>\n",
              "      <td>2020-01-01</td>\n",
              "      <td>20</td>\n",
              "      <td>CGMT6</td>\n",
              "      <td>GJ5KBL3</td>\n",
              "      <td>R9ZQOG7</td>\n",
              "      <td>NaN</td>\n",
              "      <td>D</td>\n",
              "      <td>B</td>\n",
              "      <td>11</td>\n",
              "      <td>21</td>\n",
              "      <td>18</td>\n",
              "      <td>23557.5</td>\n",
              "      <td>5.219489e+04</td>\n",
              "      <td>40</td>\n",
              "      <td>4077007</td>\n",
              "      <td>6307909000</td>\n",
              "      <td>US</td>\n",
              "      <td>US</td>\n",
              "      <td>A</td>\n",
              "      <td>10.0</td>\n",
              "      <td>A</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>40175917</td>\n",
              "      <td>2020-01-01</td>\n",
              "      <td>40</td>\n",
              "      <td>QWUTG</td>\n",
              "      <td>PBYW02T</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>94</td>\n",
              "      <td>21</td>\n",
              "      <td>43</td>\n",
              "      <td>12450.1</td>\n",
              "      <td>1.773608e+06</td>\n",
              "      <td>40</td>\n",
              "      <td>4077106</td>\n",
              "      <td>6505009090</td>\n",
              "      <td>CN</td>\n",
              "      <td>CN</td>\n",
              "      <td>A</td>\n",
              "      <td>8.0</td>\n",
              "      <td>A</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>11602631</td>\n",
              "      <td>2020-01-01</td>\n",
              "      <td>30</td>\n",
              "      <td>0X1CO</td>\n",
              "      <td>MCX0GJB</td>\n",
              "      <td>4Z9PX0Y</td>\n",
              "      <td>NaN</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>11</td>\n",
              "      <td>21</td>\n",
              "      <td>43</td>\n",
              "      <td>15692.7</td>\n",
              "      <td>8.777327e+06</td>\n",
              "      <td>40</td>\n",
              "      <td>2006075</td>\n",
              "      <td>6204320000</td>\n",
              "      <td>CN</td>\n",
              "      <td>CN</td>\n",
              "      <td>FCN1</td>\n",
              "      <td>5.2</td>\n",
              "      <td>M1_N1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       신고번호       신고일자  통관지세관부호  신고인부호  ...   관세율 검사결과코드 우범여부 핵심적발\n",
              "0  57298928 2020-01-01      121  2O5A2  ...   8.0     N3    1    1\n",
              "1  85092852 2020-01-01       30  305K5  ...   8.0      A    0    0\n",
              "2  63014158 2020-01-01       20  CGMT6  ...  10.0      A    0    0\n",
              "3  40175917 2020-01-01       40  QWUTG  ...   8.0      A    0    0\n",
              "4  11602631 2020-01-01       30  0X1CO  ...   5.2  M1_N1    1    1\n",
              "\n",
              "[5 rows x 24 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1E-IkwMEY1xX"
      },
      "source": [
        "df['']"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 453
        },
        "id": "TyJOH6myf0jh",
        "outputId": "abd2483d-af2f-45b4-b490-14a334fe21ef"
      },
      "source": [
        "new_df = df.drop(columns=['신고번호','신고일자','수입자부호','해외거래처부호','특송업체부호','검사결과코드','우범여부','핵심적발'])\n",
        "new_df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>신고중량(KG)</th>\n",
              "      <th>과세가격원화금액</th>\n",
              "      <th>운송수단유형코드</th>\n",
              "      <th>반입보세구역부호</th>\n",
              "      <th>HS10단위부호</th>\n",
              "      <th>적출국가코드</th>\n",
              "      <th>원산지국가코드</th>\n",
              "      <th>관세율구분코드</th>\n",
              "      <th>관세율</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>121</td>\n",
              "      <td>2O5A2</td>\n",
              "      <td>D</td>\n",
              "      <td>B</td>\n",
              "      <td>15</td>\n",
              "      <td>23</td>\n",
              "      <td>43</td>\n",
              "      <td>126.0</td>\n",
              "      <td>5.397966e+03</td>\n",
              "      <td>10</td>\n",
              "      <td>2106003</td>\n",
              "      <td>8481900000</td>\n",
              "      <td>US</td>\n",
              "      <td>US</td>\n",
              "      <td>A</td>\n",
              "      <td>8.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>30</td>\n",
              "      <td>305K5</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>11</td>\n",
              "      <td>21</td>\n",
              "      <td>11</td>\n",
              "      <td>29845.4</td>\n",
              "      <td>5.730972e+05</td>\n",
              "      <td>40</td>\n",
              "      <td>4077010</td>\n",
              "      <td>2106909099</td>\n",
              "      <td>US</td>\n",
              "      <td>US</td>\n",
              "      <td>A</td>\n",
              "      <td>8.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>20</td>\n",
              "      <td>CGMT6</td>\n",
              "      <td>D</td>\n",
              "      <td>B</td>\n",
              "      <td>11</td>\n",
              "      <td>21</td>\n",
              "      <td>18</td>\n",
              "      <td>23557.5</td>\n",
              "      <td>5.219489e+04</td>\n",
              "      <td>40</td>\n",
              "      <td>4077007</td>\n",
              "      <td>6307909000</td>\n",
              "      <td>US</td>\n",
              "      <td>US</td>\n",
              "      <td>A</td>\n",
              "      <td>10.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>40</td>\n",
              "      <td>QWUTG</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>94</td>\n",
              "      <td>21</td>\n",
              "      <td>43</td>\n",
              "      <td>12450.1</td>\n",
              "      <td>1.773608e+06</td>\n",
              "      <td>40</td>\n",
              "      <td>4077106</td>\n",
              "      <td>6505009090</td>\n",
              "      <td>CN</td>\n",
              "      <td>CN</td>\n",
              "      <td>A</td>\n",
              "      <td>8.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>30</td>\n",
              "      <td>0X1CO</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>11</td>\n",
              "      <td>21</td>\n",
              "      <td>43</td>\n",
              "      <td>15692.7</td>\n",
              "      <td>8.777327e+06</td>\n",
              "      <td>40</td>\n",
              "      <td>2006075</td>\n",
              "      <td>6204320000</td>\n",
              "      <td>CN</td>\n",
              "      <td>CN</td>\n",
              "      <td>FCN1</td>\n",
              "      <td>5.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <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",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89350</th>\n",
              "      <td>10</td>\n",
              "      <td>M9SYU</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>11</td>\n",
              "      <td>21</td>\n",
              "      <td>11</td>\n",
              "      <td>989.3</td>\n",
              "      <td>9.139535e+04</td>\n",
              "      <td>10</td>\n",
              "      <td>4002001</td>\n",
              "      <td>703101000</td>\n",
              "      <td>CN</td>\n",
              "      <td>CN</td>\n",
              "      <td>W2</td>\n",
              "      <td>135.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89351</th>\n",
              "      <td>41</td>\n",
              "      <td>T7VQN</td>\n",
              "      <td>E</td>\n",
              "      <td>E</td>\n",
              "      <td>15</td>\n",
              "      <td>11</td>\n",
              "      <td>11</td>\n",
              "      <td>152.7</td>\n",
              "      <td>3.752803e+04</td>\n",
              "      <td>40</td>\n",
              "      <td>4077008</td>\n",
              "      <td>6804220000</td>\n",
              "      <td>CN</td>\n",
              "      <td>CN</td>\n",
              "      <td>FCN1</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89352</th>\n",
              "      <td>40</td>\n",
              "      <td>7Q31W</td>\n",
              "      <td>C</td>\n",
              "      <td>B</td>\n",
              "      <td>29</td>\n",
              "      <td>21</td>\n",
              "      <td>11</td>\n",
              "      <td>138.0</td>\n",
              "      <td>1.381431e+04</td>\n",
              "      <td>10</td>\n",
              "      <td>2086001</td>\n",
              "      <td>8210005000</td>\n",
              "      <td>CN</td>\n",
              "      <td>CN</td>\n",
              "      <td>A</td>\n",
              "      <td>8.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89353</th>\n",
              "      <td>40</td>\n",
              "      <td>UJ0JR</td>\n",
              "      <td>F</td>\n",
              "      <td>B</td>\n",
              "      <td>15</td>\n",
              "      <td>21</td>\n",
              "      <td>14</td>\n",
              "      <td>201.3</td>\n",
              "      <td>4.030176e+03</td>\n",
              "      <td>40</td>\n",
              "      <td>1618003</td>\n",
              "      <td>3304999000</td>\n",
              "      <td>CA</td>\n",
              "      <td>CA</td>\n",
              "      <td>C</td>\n",
              "      <td>6.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89354</th>\n",
              "      <td>30</td>\n",
              "      <td>4TUUB</td>\n",
              "      <td>Z</td>\n",
              "      <td>B</td>\n",
              "      <td>15</td>\n",
              "      <td>21</td>\n",
              "      <td>11</td>\n",
              "      <td>77.2</td>\n",
              "      <td>1.545601e+03</td>\n",
              "      <td>10</td>\n",
              "      <td>3078039</td>\n",
              "      <td>3304999000</td>\n",
              "      <td>HK</td>\n",
              "      <td>HK</td>\n",
              "      <td>C</td>\n",
              "      <td>6.5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>89355 rows × 16 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       통관지세관부호  신고인부호 수입통관계획코드 수입신고구분코드  ...  적출국가코드  원산지국가코드  관세율구분코드    관세율\n",
              "0          121  2O5A2        D        B  ...      US       US        A    8.0\n",
              "1           30  305K5        C        B  ...      US       US        A    8.0\n",
              "2           20  CGMT6        D        B  ...      US       US        A   10.0\n",
              "3           40  QWUTG        C        B  ...      CN       CN        A    8.0\n",
              "4           30  0X1CO        C        B  ...      CN       CN     FCN1    5.2\n",
              "...        ...    ...      ...      ...  ...     ...      ...      ...    ...\n",
              "89350       10  M9SYU        C        B  ...      CN       CN       W2  135.0\n",
              "89351       41  T7VQN        E        E  ...      CN       CN     FCN1    0.0\n",
              "89352       40  7Q31W        C        B  ...      CN       CN        A    8.0\n",
              "89353       40  UJ0JR        F        B  ...      CA       CA        C    6.5\n",
              "89354       30  4TUUB        Z        B  ...      HK       HK        C    6.5\n",
              "\n",
              "[89355 rows x 16 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ueQM3llNhseQ",
        "outputId": "c7619407-4102-44ba-9628-ada44f51bfa8"
      },
      "source": [
        "new_df.info()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 89355 entries, 0 to 89354\n",
            "Data columns (total 16 columns):\n",
            " #   Column    Non-Null Count  Dtype  \n",
            "---  ------    --------------  -----  \n",
            " 0   통관지세관부호   89355 non-null  int64  \n",
            " 1   신고인부호     89355 non-null  object \n",
            " 2   수입통관계획코드  89355 non-null  object \n",
            " 3   수입신고구분코드  89355 non-null  object \n",
            " 4   수입거래구분코드  89355 non-null  int64  \n",
            " 5   수입종류코드    89355 non-null  int64  \n",
            " 6   징수형태코드    89355 non-null  int64  \n",
            " 7   신고중량(KG)  89355 non-null  float64\n",
            " 8   과세가격원화금액  89355 non-null  float64\n",
            " 9   운송수단유형코드  89355 non-null  int64  \n",
            " 10  반입보세구역부호  89355 non-null  int64  \n",
            " 11  HS10단위부호  89355 non-null  int64  \n",
            " 12  적출국가코드    89355 non-null  object \n",
            " 13  원산지국가코드   89355 non-null  object \n",
            " 14  관세율구분코드   89355 non-null  object \n",
            " 15  관세율       89355 non-null  float64\n",
            "dtypes: float64(3), int64(7), object(6)\n",
            "memory usage: 10.9+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "RhTc-54RiVUx"
      },
      "source": [
        "new_df['신고인부호'] = pd.factorize(new_df['신고인부호'])[0]\n",
        "new_df['수입통관계획코드'] = pd.factorize(new_df['수입통관계획코드'])[0]\n",
        "new_df['수입신고구분코드'] = pd.factorize(new_df['수입신고구분코드'])[0]\n",
        "new_df['적출국가코드'] = pd.factorize(new_df['적출국가코드'])[0]\n",
        "\n",
        "new_df['원산지국가코드'] = pd.factorize(new_df['원산지국가코드'])[0]\n",
        "new_df['관세율구분코드'] = pd.factorize(new_df['관세율구분코드'])[0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "V6NOPHaWlTXJ",
        "outputId": "cfe2e7bd-d8d6-4d7b-d094-e5a11a862117"
      },
      "source": [
        "from sklearn.preprocessing import MinMaxScaler\n",
        "min_max_scaler = MinMaxScaler()\n",
        "\n",
        "output = min_max_scaler.fit(new_df)\n",
        "output"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "MinMaxScaler(copy=True, feature_range=(0, 1))"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 709
        },
        "id": "UgjvILwMmP0Z",
        "outputId": "503fbbaf-244a-47f6-a68b-1a98c06be83d"
      },
      "source": [
        "output = min_max_scaler.transform(new_df)\n",
        "output = pd.DataFrame(output,columns=new_df.columns)\n",
        "output['우범여부'] = df['우범여부']\n",
        "output['핵심적발'] = df['핵심적발']\n",
        "output"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>신고중량(KG)</th>\n",
              "      <th>과세가격원화금액</th>\n",
              "      <th>운송수단유형코드</th>\n",
              "      <th>반입보세구역부호</th>\n",
              "      <th>HS10단위부호</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",
              "      <th>0</th>\n",
              "      <td>0.770833</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.047059</td>\n",
              "      <td>0.705882</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.000581</td>\n",
              "      <td>7.766857e-09</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.076666</td>\n",
              "      <td>0.872551</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.009996</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0.138889</td>\n",
              "      <td>0.001037</td>\n",
              "      <td>0.166667</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.588235</td>\n",
              "      <td>0.255814</td>\n",
              "      <td>0.137661</td>\n",
              "      <td>8.246003e-07</td>\n",
              "      <td>0.375</td>\n",
              "      <td>0.213542</td>\n",
              "      <td>0.208815</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.009996</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0.069444</td>\n",
              "      <td>0.002075</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.588235</td>\n",
              "      <td>0.418605</td>\n",
              "      <td>0.108658</td>\n",
              "      <td>7.510056e-08</td>\n",
              "      <td>0.375</td>\n",
              "      <td>0.213541</td>\n",
              "      <td>0.646205</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.012495</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>0.208333</td>\n",
              "      <td>0.003112</td>\n",
              "      <td>0.166667</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.976471</td>\n",
              "      <td>0.588235</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.057425</td>\n",
              "      <td>2.551954e-06</td>\n",
              "      <td>0.375</td>\n",
              "      <td>0.213548</td>\n",
              "      <td>0.666726</td>\n",
              "      <td>0.011364</td>\n",
              "      <td>0.010753</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.009996</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0.138889</td>\n",
              "      <td>0.004149</td>\n",
              "      <td>0.166667</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.588235</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.072382</td>\n",
              "      <td>1.262925e-05</td>\n",
              "      <td>0.375</td>\n",
              "      <td>0.069727</td>\n",
              "      <td>0.635420</td>\n",
              "      <td>0.011364</td>\n",
              "      <td>0.010753</td>\n",
              "      <td>0.029412</td>\n",
              "      <td>0.006498</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <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",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89350</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.565353</td>\n",
              "      <td>0.166667</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.588235</td>\n",
              "      <td>0.255814</td>\n",
              "      <td>0.004563</td>\n",
              "      <td>1.315041e-07</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.208333</td>\n",
              "      <td>0.062657</td>\n",
              "      <td>0.011364</td>\n",
              "      <td>0.010753</td>\n",
              "      <td>0.235294</td>\n",
              "      <td>0.168687</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89351</th>\n",
              "      <td>0.215278</td>\n",
              "      <td>0.186722</td>\n",
              "      <td>0.500000</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.047059</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.255814</td>\n",
              "      <td>0.000704</td>\n",
              "      <td>5.399716e-08</td>\n",
              "      <td>0.375</td>\n",
              "      <td>0.213541</td>\n",
              "      <td>0.697879</td>\n",
              "      <td>0.011364</td>\n",
              "      <td>0.010753</td>\n",
              "      <td>0.029412</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89352</th>\n",
              "      <td>0.208333</td>\n",
              "      <td>0.085062</td>\n",
              "      <td>0.166667</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.211765</td>\n",
              "      <td>0.588235</td>\n",
              "      <td>0.255814</td>\n",
              "      <td>0.000636</td>\n",
              "      <td>1.987671e-08</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.075277</td>\n",
              "      <td>0.844243</td>\n",
              "      <td>0.011364</td>\n",
              "      <td>0.010753</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.009996</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89353</th>\n",
              "      <td>0.208333</td>\n",
              "      <td>0.506224</td>\n",
              "      <td>0.666667</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.047059</td>\n",
              "      <td>0.588235</td>\n",
              "      <td>0.325581</td>\n",
              "      <td>0.000928</td>\n",
              "      <td>5.798814e-09</td>\n",
              "      <td>0.375</td>\n",
              "      <td>0.042777</td>\n",
              "      <td>0.333555</td>\n",
              "      <td>0.102273</td>\n",
              "      <td>0.236559</td>\n",
              "      <td>0.058824</td>\n",
              "      <td>0.008122</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89354</th>\n",
              "      <td>0.138889</td>\n",
              "      <td>0.744813</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.047059</td>\n",
              "      <td>0.588235</td>\n",
              "      <td>0.255814</td>\n",
              "      <td>0.000356</td>\n",
              "      <td>2.223887e-09</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.144169</td>\n",
              "      <td>0.333555</td>\n",
              "      <td>0.079545</td>\n",
              "      <td>0.204301</td>\n",
              "      <td>0.058824</td>\n",
              "      <td>0.008122</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>89355 rows × 18 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        통관지세관부호     신고인부호  수입통관계획코드  수입신고구분코드  ...   관세율구분코드       관세율  우범여부  핵심적발\n",
              "0      0.770833  0.000000  0.000000       0.0  ...  0.000000  0.009996     1     1\n",
              "1      0.138889  0.001037  0.166667       0.0  ...  0.000000  0.009996     0     0\n",
              "2      0.069444  0.002075  0.000000       0.0  ...  0.000000  0.012495     0     0\n",
              "3      0.208333  0.003112  0.166667       0.0  ...  0.000000  0.009996     0     0\n",
              "4      0.138889  0.004149  0.166667       0.0  ...  0.029412  0.006498     1     1\n",
              "...         ...       ...       ...       ...  ...       ...       ...   ...   ...\n",
              "89350  0.000000  0.565353  0.166667       0.0  ...  0.235294  0.168687     0     0\n",
              "89351  0.215278  0.186722  0.500000       1.0  ...  0.029412  0.000000     0     0\n",
              "89352  0.208333  0.085062  0.166667       0.0  ...  0.000000  0.009996     0     0\n",
              "89353  0.208333  0.506224  0.666667       0.0  ...  0.058824  0.008122     1     2\n",
              "89354  0.138889  0.744813  1.000000       0.0  ...  0.058824  0.008122     0     0\n",
              "\n",
              "[89355 rows x 18 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Juu92T6fnoBt"
      },
      "source": [
        "output.drop(columns=['우범여부','핵심적발']).to_csv(\"/content/drive/MyDrive/tax/data/mugisung_X.csv\",index=False)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Tbx8vau7rmhH"
      },
      "source": [
        "output.loc[:,['우범여부','핵심적발']].to_csv(\"/content/drive/MyDrive/tax/data/mugisung_y.csv\",index=False)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "-cVQOmCbJr4q"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}