100-knock-1章.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.6.9"
    },
    "colab": {
      "name": "1章.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/tkota0726/Jupyter/blob/master/100-knock-1%E7%AB%A0.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HB3mviwv25Jc",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "5d106ed9-a26d-481d-9292-698cd4b69649"
      },
      "source": [
        "# 下記セルを実行すると、authorization codeの入力を求められます。\n",
        "# 出力されたリンク先をクリックし、Googleアカウントにログインし、\n",
        "# authorization codeをコピーし、貼り付けをおこなってください。\n",
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/drive\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HcOU_u4l25Jd"
      },
      "source": [
        "import os \n",
        "project = '100knock-process-visualization'\n",
        "chapter = 1\n",
        "os.chdir(f'/content/drive/MyDrive/python-training-100/{project}/chapter-{chapter}/')"
      ],
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "pCbOP-x725Jd"
      },
      "source": [
        "# １章 システムデータの加工・可視化を行う２０本ノック"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "OrJw1o3ZAf2z"
      },
      "source": [
        "## ノック１：法人情報データを読み込んでみよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Kxb1fvmCv_4a"
      },
      "source": [
        "import pandas as pd\n",
        "data = pd.read_csv('data/22_shizuoka_all_20210331.csv', encoding=\"shift-jis\",header=None )"
      ],
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Vn9gtsmwv_9u",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "b58b76fd-f52c-47ca-dc18-ea5856fc59c4"
      },
      "source": [
        "data.columns"
      ],
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Int64Index([ 0,  1,  2,  3,  4,  5,  6,  7,  8,  9, 10, 11, 12, 13, 14, 15, 16,\n",
              "            17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29],\n",
              "           dtype='int64')"
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "0FrKeZvUrFKn"
      },
      "source": [
        "## ノック２：読み込んだデータを確認しよう"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "M4by1Jywr4G2"
      },
      "source": [
        "## ノック３：ヘッダ用のテキストファイルを読み込もう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7ogDQr2Kya4I"
      },
      "source": [
        "mst = pd.read_csv('data/mst_column_name.txt', encoding='shift-jis',sep='\\t')"
      ],
      "execution_count": 6,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gG1lNXn-ya65",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "outputId": "dcf184a8-04dd-45ea-8353-71d2cc4869de"
      },
      "source": [
        "mst.head()"
      ],
      "execution_count": 7,
      "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>column_id</th>\n",
              "      <th>column_name_ja</th>\n",
              "      <th>column_name_en</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>一連番号</td>\n",
              "      <td>sequenceNumber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>法人番号</td>\n",
              "      <td>corporateNumber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>処理区分</td>\n",
              "      <td>process</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>訂正区分</td>\n",
              "      <td>correct</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>更新年月日</td>\n",
              "      <td>updateDate</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   column_id column_name_ja   column_name_en\n",
              "0          1           一連番号   sequenceNumber\n",
              "1          2           法人番号  corporateNumber\n",
              "2          3           処理区分          process\n",
              "3          4           訂正区分          correct\n",
              "4          5          更新年月日       updateDate"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Z5be3u4kz5iH",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "10d72ba4-d9e9-4ba1-f423-ce8aa1373bca"
      },
      "source": [
        "len(mst)"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "30"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "l00v3lF_PM8k",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "74cdfe97-d860-42a4-95de-934f1c84f2ea"
      },
      "source": [
        "len(mst) == len(data.columns)"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "True"
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "XueV-vtPwMY7"
      },
      "source": [
        "## ノック４：ヘッダ行を追加しよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "yl6UHFMX0Gvq"
      },
      "source": [
        "columns = mst.column_name_en.values"
      ],
      "execution_count": 10,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "IdQIr8vOG-14"
      },
      "source": [
        "data.columns = columns"
      ],
      "execution_count": 11,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CKedAXnp0Jop",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 496
        },
        "outputId": "72a4a4e3-517e-4fd5-a504-920c19fc8ed1"
      },
      "source": [
        "data.head()"
      ],
      "execution_count": 12,
      "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1000013040008</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>静岡家庭裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市葵区</td>\n",
              "      <td>城内町１−２０</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>101</td>\n",
              "      <td>4200854.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shizuoka Family Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-20, Jonaicho, Aoi ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シズオカカテイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>1000013050072</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>清水簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市清水区</td>\n",
              "      <td>天神１丁目６−１５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>103</td>\n",
              "      <td>4240809.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shimizu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-6-15, Tenjin, Shimizu ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シミズカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>1000013050080</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>浜松簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市中区</td>\n",
              "      <td>中央１丁目１２−５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>131</td>\n",
              "      <td>4300929.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Hamamatsu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-12-5, Chuo, Naka ku, Hamamatsu shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハママツカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>1000020222119</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-05</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>磐田市</td>\n",
              "      <td>NaN</td>\n",
              "      <td>201</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>磐田市</td>\n",
              "      <td>国府台３−１</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>211</td>\n",
              "      <td>4380077.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Iwata City</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>3-1,Kounodai, Iwata shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>イワタシ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>1000020222127</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-05</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>焼津市</td>\n",
              "      <td>NaN</td>\n",
              "      <td>201</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>焼津市</td>\n",
              "      <td>本町２丁目１６−３２</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>212</td>\n",
              "      <td>4250022.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Yaizu city</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>2-16-32 Honmachi, Yaizu shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ヤイヅシ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   sequenceNumber  corporateNumber  ...       furigana  hihyoji\n",
              "0               1    1000013040008  ...  シズオカカテイサイバンショ        0\n",
              "1               2    1000013050072  ...   シミズカンイサイバンショ        0\n",
              "2               3    1000013050080  ...  ハママツカンイサイバンショ        0\n",
              "3               4    1000020222119  ...           イワタシ        0\n",
              "4               5    1000020222127  ...           ヤイヅシ        0\n",
              "\n",
              "[5 rows x 30 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "nrlLRoaExgGP"
      },
      "source": [
        "## ノック５：統計量や欠損値を確認しよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "zVoqN0NSxw2S",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 317
        },
        "outputId": "07ef2b5d-6aa5-4820-d061-1d38cc86dfcb"
      },
      "source": [
        "data.describe()"
      ],
      "execution_count": 13,
      "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>latest</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>hihyoji</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>114613.000000</td>\n",
              "      <td>1.146130e+05</td>\n",
              "      <td>114613.000000</td>\n",
              "      <td>114613.000000</td>\n",
              "      <td>1243.000000</td>\n",
              "      <td>114613.000000</td>\n",
              "      <td>1195.000000</td>\n",
              "      <td>114613.0</td>\n",
              "      <td>114613.000000</td>\n",
              "      <td>1.144400e+05</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>10077.000000</td>\n",
              "      <td>6.660000e+02</td>\n",
              "      <td>114613.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>114613.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>57307.000000</td>\n",
              "      <td>5.085795e+12</td>\n",
              "      <td>3.976181</td>\n",
              "      <td>0.295856</td>\n",
              "      <td>71557.514883</td>\n",
              "      <td>314.465558</td>\n",
              "      <td>81666.374895</td>\n",
              "      <td>22.0</td>\n",
              "      <td>178.326394</td>\n",
              "      <td>4.231842e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.190731</td>\n",
              "      <td>4.957128e+12</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.001963</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>33086.067539</td>\n",
              "      <td>2.581533e+12</td>\n",
              "      <td>7.453937</td>\n",
              "      <td>0.456429</td>\n",
              "      <td>11848.454350</td>\n",
              "      <td>34.832874</td>\n",
              "      <td>13422.273042</td>\n",
              "      <td>0.0</td>\n",
              "      <td>64.170267</td>\n",
              "      <td>8.983892e+04</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.758547</td>\n",
              "      <td>2.587259e+12</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.044264</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000013e+12</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>67209.000000</td>\n",
              "      <td>101.000000</td>\n",
              "      <td>67247.000000</td>\n",
              "      <td>22.0</td>\n",
              "      <td>100.000000</td>\n",
              "      <td>4.100000e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.010001e+12</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>28654.000000</td>\n",
              "      <td>3.080002e+12</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>67695.500000</td>\n",
              "      <td>301.000000</td>\n",
              "      <td>79441.500000</td>\n",
              "      <td>22.0</td>\n",
              "      <td>131.000000</td>\n",
              "      <td>4.160907e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>3.080001e+12</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>57307.000000</td>\n",
              "      <td>5.080102e+12</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>68059.000000</td>\n",
              "      <td>302.000000</td>\n",
              "      <td>79792.000000</td>\n",
              "      <td>22.0</td>\n",
              "      <td>203.000000</td>\n",
              "      <td>4.228034e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>5.025501e+12</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>85960.000000</td>\n",
              "      <td>7.080401e+12</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>68445.000000</td>\n",
              "      <td>302.000000</td>\n",
              "      <td>80115.500000</td>\n",
              "      <td>22.0</td>\n",
              "      <td>212.000000</td>\n",
              "      <td>4.312102e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>7.080401e+12</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>114613.000000</td>\n",
              "      <td>9.700150e+12</td>\n",
              "      <td>71.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>121799.000000</td>\n",
              "      <td>499.000000</td>\n",
              "      <td>122416.000000</td>\n",
              "      <td>22.0</td>\n",
              "      <td>484.000000</td>\n",
              "      <td>4.390037e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>31.000000</td>\n",
              "      <td>9.180301e+12</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       sequenceNumber  corporateNumber  ...  enAddressOutside        hihyoji\n",
              "count   114613.000000     1.146130e+05  ...               0.0  114613.000000\n",
              "mean     57307.000000     5.085795e+12  ...               NaN       0.001963\n",
              "std      33086.067539     2.581533e+12  ...               NaN       0.044264\n",
              "min          1.000000     1.000013e+12  ...               NaN       0.000000\n",
              "25%      28654.000000     3.080002e+12  ...               NaN       0.000000\n",
              "50%      57307.000000     5.080102e+12  ...               NaN       0.000000\n",
              "75%      85960.000000     7.080401e+12  ...               NaN       0.000000\n",
              "max     114613.000000     9.700150e+12  ...               NaN       1.000000\n",
              "\n",
              "[8 rows x 17 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "BWJGrOBJxz1F",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "adae2484-e5e2-4892-90a5-4c0fa39983aa"
      },
      "source": [
        "data.isna().sum()"
      ],
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "sequenceNumber                   0\n",
              "corporateNumber                  0\n",
              "process                          0\n",
              "correct                          0\n",
              "updateDate                       0\n",
              "changeDate                       0\n",
              "name                             0\n",
              "nameImageId                 113370\n",
              "kind                             0\n",
              "prefectureName                   0\n",
              "cityName                         0\n",
              "streetNumber                    17\n",
              "addressImageId              113418\n",
              "prefectureCode                   0\n",
              "cityCode                         0\n",
              "postCode                       173\n",
              "addressOutside              114613\n",
              "addressOutsideImageId       114613\n",
              "closeDate                   104536\n",
              "closeCause                  104536\n",
              "successorCorporateNumber    113947\n",
              "changeCause                 113502\n",
              "assignmentDate                   0\n",
              "latest                           0\n",
              "enName                      114381\n",
              "enPrefectureName            114383\n",
              "enCityName                  114383\n",
              "enAddressOutside            114613\n",
              "furigana                     67993\n",
              "hihyoji                          0\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "1Z8rwT646g7X"
      },
      "source": [
        "## ノック６：データの追加（繰り返し・読込・抽出・結合）"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_6ESyddb0lha",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "9a528706-4c91-4d8e-8450-333ff45d8bd9"
      },
      "source": [
        "import os\n",
        "\n",
        "os.listdir('data')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['22_shizuoka_all_20210331.csv',\n",
              " 'diff_20210401.csv',\n",
              " 'diff_20210405.csv',\n",
              " 'diff_20210406.csv',\n",
              " 'diff_20210407.csv',\n",
              " 'diff_20210408.csv',\n",
              " 'diff_20210409.csv',\n",
              " 'mst_process_kbn.csv',\n",
              " 'mst_correct_kbn.csv',\n",
              " 'mst_latest.csv',\n",
              " 'mst_closeCause.csv',\n",
              " 'mst_corp_kind.csv',\n",
              " 'mst_hihyoji.csv',\n",
              " 'mst_column_name.txt']"
            ]
          },
          "metadata": {},
          "execution_count": 94
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lN3unz0ZNh4x"
      },
      "source": [
        "from glob import glob\n",
        "diff_files = glob('data/diff*.csv')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "oyzaHgbP0lxI",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "36d9d898-e276-442d-df27-d88ddc8a1c94"
      },
      "source": [
        "diff_files"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['data/diff_20210401.csv',\n",
              " 'data/diff_20210405.csv',\n",
              " 'data/diff_20210406.csv',\n",
              " 'data/diff_20210407.csv',\n",
              " 'data/diff_20210408.csv',\n",
              " 'data/diff_20210409.csv']"
            ]
          },
          "metadata": {},
          "execution_count": 96
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9l-ZzTWnaHLR"
      },
      "source": [
        "diff_files.sort()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "QmO-WGYfatBA"
      },
      "source": [
        "diff = pd.read_csv(diff_files[0], encoding='shift-jis',header=None,dtype=object)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jews9WyY2pU6",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "4a473210-dcee-4090-bb94-e7cb46f59c1b"
      },
      "source": [
        "print(len(diff))"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "2316\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1wsUlE5wPpfY",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 811
        },
        "outputId": "4a23000d-f8f1-4c91-f686-2447086e4e36"
      },
      "source": [
        "diff.head(2)"
      ],
      "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>0</th>\n",
              "      <th>1</th>\n",
              "      <th>2</th>\n",
              "      <th>3</th>\n",
              "      <th>4</th>\n",
              "      <th>5</th>\n",
              "      <th>6</th>\n",
              "      <th>7</th>\n",
              "      <th>8</th>\n",
              "      <th>9</th>\n",
              "      <th>10</th>\n",
              "      <th>11</th>\n",
              "      <th>12</th>\n",
              "      <th>13</th>\n",
              "      <th>14</th>\n",
              "      <th>15</th>\n",
              "      <th>16</th>\n",
              "      <th>17</th>\n",
              "      <th>18</th>\n",
              "      <th>19</th>\n",
              "      <th>20</th>\n",
              "      <th>21</th>\n",
              "      <th>22</th>\n",
              "      <th>23</th>\n",
              "      <th>24</th>\n",
              "      <th>25</th>\n",
              "      <th>26</th>\n",
              "      <th>27</th>\n",
              "      <th>28</th>\n",
              "      <th>29</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1010001016019</td>\n",
              "      <td>71</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2021-03-01</td>\n",
              "      <td>株式会社国際漢方研究所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>東京都</td>\n",
              "      <td>千代田区</td>\n",
              "      <td>内神田３丁目６番１号</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13</td>\n",
              "      <td>101</td>\n",
              "      <td>1010047</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>令和３年３月１日東京都渋谷区千駄ヶ谷五丁目２９番１１号ナカニシビル６０２号室株式会社Ｉｎｔｅ...</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>コクサイカンポウケンキュウショ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>1010001092869</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2020-06-11</td>\n",
              "      <td>あさひ銀リテールファイナンス株式会社</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>東京都</td>\n",
              "      <td>千代田区</td>\n",
              "      <td>大手町１丁目１番２号りそな銀行内</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13</td>\n",
              "      <td>101</td>\n",
              "      <td>1000004</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020-06-11</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>アサヒギンリテールファイナンス</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  0              1   2  3           4   ...   25   26   27               28 29\n",
              "0  1  1010001016019  71  0  2021-04-01  ...  NaN  NaN  NaN  コクサイカンポウケンキュウショ  0\n",
              "1  2  1010001092869  01  1  2021-04-01  ...  NaN  NaN  NaN  アサヒギンリテールファイナンス  0\n",
              "\n",
              "[2 rows x 30 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 100
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4Yxyb8yYOVN5",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "outputId": "4d7f93d0-39ff-4bac-b8b6-276184b9851c"
      },
      "source": [
        "diff.columns = columns\n",
        "diff = diff.loc[diff['prefectureName']=='静岡県']\n",
        "print(len(diff))\n",
        "diff.head(3)\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "43\n"
          ],
          "name": "stdout"
        },
        {
          "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>107</th>\n",
              "      <td>108</td>\n",
              "      <td>1080001015906</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>株式会社エムケイテック</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>焼津市</td>\n",
              "      <td>策牛９８番地の２</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>212</td>\n",
              "      <td>4250007</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>エムケイテック</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>108</th>\n",
              "      <td>109</td>\n",
              "      <td>1080001015906</td>\n",
              "      <td>12</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2021-03-30</td>\n",
              "      <td>株式会社エムケイテック</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>藤枝市</td>\n",
              "      <td>岡部桂島９８５番地の５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>214</td>\n",
              "      <td>4260000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>エムケイテック</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>109</th>\n",
              "      <td>110</td>\n",
              "      <td>1080002015434</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>有限会社ハイナンＤＣ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>牧之原市</td>\n",
              "      <td>大沢１４４番地９</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>226</td>\n",
              "      <td>4210526</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハイナンディーシー</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    sequenceNumber corporateNumber process  ... enAddressOutside   furigana hihyoji\n",
              "107            108   1080001015906      01  ...              NaN    エムケイテック       0\n",
              "108            109   1080001015906      12  ...              NaN    エムケイテック       0\n",
              "109            110   1080002015434      01  ...              NaN  ハイナンディーシー       0\n",
              "\n",
              "[3 rows x 30 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 101
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "UyaZcj3WY59P",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 383
        },
        "outputId": "a8beb150-6435-43df-adb2-0a3cb460f276"
      },
      "source": [
        "data_test = data\n",
        "print(len(data_test))\n",
        "\n",
        "print(len(data_test) == len(data))\n",
        "print(len(diff))\n",
        "data_test = data_test.append(diff)\n",
        "print(len(data_test))\n",
        "data_test.tail(3)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "114613\n",
            "True\n",
            "43\n",
            "114656\n"
          ],
          "name": "stdout"
        },
        {
          "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2159</th>\n",
              "      <td>2160</td>\n",
              "      <td>9080401024929</td>\n",
              "      <td>01</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>株式会社リガーレ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市中区</td>\n",
              "      <td>鍛冶町３１９番地の２４</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>131</td>\n",
              "      <td>4300933</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>リガーレ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2160</th>\n",
              "      <td>2161</td>\n",
              "      <td>9080402007726</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>有限会社丸信商店</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市中区</td>\n",
              "      <td>天神町４番８号</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>131</td>\n",
              "      <td>4300808</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>マルシンショウテン</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2161</th>\n",
              "      <td>2162</td>\n",
              "      <td>9080402021917</td>\n",
              "      <td>21</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2021-03-30</td>\n",
              "      <td>有限会社岡本商会</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>袋井市</td>\n",
              "      <td>梅山３６１番地の１</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>216</td>\n",
              "      <td>4371105</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-03-30</td>\n",
              "      <td>01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>オカモトショウカイ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     sequenceNumber corporateNumber  ...   furigana hihyoji\n",
              "2159           2160   9080401024929  ...       リガーレ       0\n",
              "2160           2161   9080402007726  ...  マルシンショウテン       0\n",
              "2161           2162   9080402021917  ...  オカモトショウカイ       0\n",
              "\n",
              "[3 rows x 30 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 102
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FB0jcpNbh7L7",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "8f39f342-9453-4970-8b55-ecd9094561cc"
      },
      "source": [
        "for f in diff_files:\n",
        "  diff = pd.read_csv(f, encoding='shift-jis',header=None,dtype=object)\n",
        "  diff.columns = columns\n",
        "  diff = diff.loc[diff['prefectureName']=='静岡県']\n",
        "  data = data.append(diff)\n",
        "data"
      ],
      "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1000013040008</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>静岡家庭裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市葵区</td>\n",
              "      <td>城内町１−２０</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>101</td>\n",
              "      <td>4.20085e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shizuoka Family Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-20, Jonaicho, Aoi ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シズオカカテイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>1000013050072</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>清水簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市清水区</td>\n",
              "      <td>天神１丁目６−１５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>103</td>\n",
              "      <td>4.24081e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shimizu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-6-15, Tenjin, Shimizu ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シミズカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>1000013050080</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>浜松簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市中区</td>\n",
              "      <td>中央１丁目１２−５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>131</td>\n",
              "      <td>4.30093e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Hamamatsu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-12-5, Chuo, Naka ku, Hamamatsu shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハママツカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>1000020222119</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-05</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>磐田市</td>\n",
              "      <td>NaN</td>\n",
              "      <td>201</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>磐田市</td>\n",
              "      <td>国府台３−１</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>211</td>\n",
              "      <td>4.38008e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Iwata City</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>3-1,Kounodai, Iwata shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>イワタシ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>1000020222127</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-05</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>焼津市</td>\n",
              "      <td>NaN</td>\n",
              "      <td>201</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>焼津市</td>\n",
              "      <td>本町２丁目１６−３２</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>212</td>\n",
              "      <td>4.25002e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Yaizu city</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>2-16-32 Honmachi, Yaizu shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ヤイヅシ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <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",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3194</th>\n",
              "      <td>3195</td>\n",
              "      <td>9080001021673</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2017-07-07</td>\n",
              "      <td>株式会社ＡＣＴ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市葵区</td>\n",
              "      <td>太田町１４番地の４</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>101</td>\n",
              "      <td>4200845</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2017-07-07</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>アクト</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3195</th>\n",
              "      <td>3196</td>\n",
              "      <td>9080101022431</td>\n",
              "      <td>01</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>株式会社ＬＥＳＱＵＡ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>沼津市</td>\n",
              "      <td>大岡２５５番地の１５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>203</td>\n",
              "      <td>4100022</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>レスカ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3196</th>\n",
              "      <td>3197</td>\n",
              "      <td>9080102008933</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>有限会社サクラ急送</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>伊豆の国市</td>\n",
              "      <td>奈古谷６６３番地の２</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>225</td>\n",
              "      <td>4102132</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>サクラキュウソウ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3197</th>\n",
              "      <td>3198</td>\n",
              "      <td>9080402002859</td>\n",
              "      <td>21</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>有限会社弘法</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市南区</td>\n",
              "      <td>下江町４５６番地の１</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>134</td>\n",
              "      <td>4300825</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>11</td>\n",
              "      <td>8080401016019</td>\n",
              "      <td>令和３年４月１日静岡県磐田市安久路二丁目２番地の２まごころ株式会社（808040101601...</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>コウボウ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3198</th>\n",
              "      <td>3199</td>\n",
              "      <td>9080402015836</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>有限会社エコワークス</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市西区</td>\n",
              "      <td>大人見町３３７４番地の１</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>133</td>\n",
              "      <td>4311112</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>エコワークス</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>115020 rows × 30 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     sequenceNumber corporateNumber  ...       furigana hihyoji\n",
              "0                 1   1000013040008  ...  シズオカカテイサイバンショ       0\n",
              "1                 2   1000013050072  ...   シミズカンイサイバンショ       0\n",
              "2                 3   1000013050080  ...  ハママツカンイサイバンショ       0\n",
              "3                 4   1000020222119  ...           イワタシ       0\n",
              "4                 5   1000020222127  ...           ヤイヅシ       0\n",
              "...             ...             ...  ...            ...     ...\n",
              "3194           3195   9080001021673  ...            アクト       0\n",
              "3195           3196   9080101022431  ...            レスカ       0\n",
              "3196           3197   9080102008933  ...       サクラキュウソウ       0\n",
              "3197           3198   9080402002859  ...           コウボウ       0\n",
              "3198           3199   9080402015836  ...         エコワークス       0\n",
              "\n",
              "[115020 rows x 30 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 103
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NR6s7J-lPr4L",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 615
        },
        "outputId": "ca6e57c7-92dd-4e0c-eda6-02cb4a7336e7"
      },
      "source": [
        "for f in diff_files:\n",
        "  diff = pd.read_csv(f, encoding='shift-jis',header=None,dtype=object)\n",
        "  diff.columns = columns\n",
        "diff.head()"
      ],
      "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1000030070053</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>半田財産区</td>\n",
              "      <td>NaN</td>\n",
              "      <td>201</td>\n",
              "      <td>福島県</td>\n",
              "      <td>伊達郡桑折町</td>\n",
              "      <td>字東大隅１８番地</td>\n",
              "      <td>NaN</td>\n",
              "      <td>07</td>\n",
              "      <td>301</td>\n",
              "      <td>9691611</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>0</td>\n",
              "      <td>koorimachihanda property district</td>\n",
              "      <td>Fukushima</td>\n",
              "      <td>18, Higashiosumi, Koori machi,date gun</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハンダザイサンク</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>1000030070053</td>\n",
              "      <td>12</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-03-30</td>\n",
              "      <td>半田財産区</td>\n",
              "      <td>NaN</td>\n",
              "      <td>201</td>\n",
              "      <td>福島県</td>\n",
              "      <td>伊達郡桑折町</td>\n",
              "      <td>大字谷地字道下２２−７</td>\n",
              "      <td>NaN</td>\n",
              "      <td>07</td>\n",
              "      <td>301</td>\n",
              "      <td>9691643</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>koorimachihanda property district</td>\n",
              "      <td>Fukushima</td>\n",
              "      <td>22-7, michishita,yaji, koori machi,date gun</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハンダザイサンク</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>1010001033237</td>\n",
              "      <td>11</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>株式会社ＪＰＦ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>東京都</td>\n",
              "      <td>千代田区</td>\n",
              "      <td>富士見２丁目４番１１号</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13</td>\n",
              "      <td>101</td>\n",
              "      <td>1020071</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ジェイピーエフ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>1010001063449</td>\n",
              "      <td>21</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>ショーレイフィット株式会社</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>東京都</td>\n",
              "      <td>中央区</td>\n",
              "      <td>日本橋浜町１丁目１２番９号</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13</td>\n",
              "      <td>102</td>\n",
              "      <td>1030007</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>11</td>\n",
              "      <td>6010001110163</td>\n",
              "      <td>令和３年４月１日東京都中央区日本橋浜町一丁目１２番９号昭和冷蔵株式会社（6010001110...</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ショーレイフィット</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>1010001142500</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-03-31</td>\n",
              "      <td>株式会社Ｏｆｆｉｃｅ　ＭＡＫＩ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>東京都</td>\n",
              "      <td>港区</td>\n",
              "      <td>六本木２丁目２−２−４０４</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13</td>\n",
              "      <td>103</td>\n",
              "      <td>1060032</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>オフィスマキ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  sequenceNumber corporateNumber process  ... enAddressOutside   furigana hihyoji\n",
              "0              1   1000030070053      01  ...              NaN   ハンダザイサンク       0\n",
              "1              2   1000030070053      12  ...              NaN   ハンダザイサンク       0\n",
              "2              3   1010001033237      11  ...              NaN    ジェイピーエフ       0\n",
              "3              4   1010001063449      21  ...              NaN  ショーレイフィット       0\n",
              "4              5   1010001142500      12  ...              NaN     オフィスマキ       0\n",
              "\n",
              "[5 rows x 30 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 104
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 312
        },
        "id": "hwKj1P_Ans8x",
        "outputId": "ce255b22-81cb-48af-fc4f-fbd50e88388a"
      },
      "source": [
        "data.describe()"
      ],
      "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>115020</td>\n",
              "      <td>115020</td>\n",
              "      <td>115020</td>\n",
              "      <td>115020</td>\n",
              "      <td>115020</td>\n",
              "      <td>115020</td>\n",
              "      <td>115020</td>\n",
              "      <td>1246.0</td>\n",
              "      <td>115020</td>\n",
              "      <td>115020</td>\n",
              "      <td>115020</td>\n",
              "      <td>115003</td>\n",
              "      <td>1198.0</td>\n",
              "      <td>115020</td>\n",
              "      <td>115020</td>\n",
              "      <td>114847.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>10108</td>\n",
              "      <td>10108.0</td>\n",
              "      <td>6.780000e+02</td>\n",
              "      <td>1130</td>\n",
              "      <td>115020</td>\n",
              "      <td>115020</td>\n",
              "      <td>233</td>\n",
              "      <td>231</td>\n",
              "      <td>231</td>\n",
              "      <td>0</td>\n",
              "      <td>47018</td>\n",
              "      <td>115020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>unique</th>\n",
              "      <td>114999</td>\n",
              "      <td>114983</td>\n",
              "      <td>11</td>\n",
              "      <td>4</td>\n",
              "      <td>1322</td>\n",
              "      <td>1351</td>\n",
              "      <td>106019</td>\n",
              "      <td>1246.0</td>\n",
              "      <td>15</td>\n",
              "      <td>1</td>\n",
              "      <td>46</td>\n",
              "      <td>99862</td>\n",
              "      <td>1198.0</td>\n",
              "      <td>2</td>\n",
              "      <td>89</td>\n",
              "      <td>3090.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1334</td>\n",
              "      <td>6.0</td>\n",
              "      <td>5.810000e+02</td>\n",
              "      <td>1067</td>\n",
              "      <td>1334</td>\n",
              "      <td>3</td>\n",
              "      <td>232</td>\n",
              "      <td>1</td>\n",
              "      <td>130</td>\n",
              "      <td>0</td>\n",
              "      <td>41577</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>top</th>\n",
              "      <td>3032</td>\n",
              "      <td>7080402010509</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-11-13</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>八幡神社</td>\n",
              "      <td>114683.0</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市中区</td>\n",
              "      <td>新貝町２３９番地の１</td>\n",
              "      <td>114631.0</td>\n",
              "      <td>22</td>\n",
              "      <td>131</td>\n",
              "      <td>4100022.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2016-02-08</td>\n",
              "      <td>1.0</td>\n",
              "      <td>8.080001e+12</td>\n",
              "      <td>平成２９年１２月１日静岡市駿河区富士見台一丁目２１番２２号富士見工業株式会社（8080001...</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Kamiide financial ward</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>2-1-1,oohara, Ito shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハチマングウ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>freq</th>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>94126</td>\n",
              "      <td>80704</td>\n",
              "      <td>55969</td>\n",
              "      <td>83411</td>\n",
              "      <td>171</td>\n",
              "      <td>1.0</td>\n",
              "      <td>51229</td>\n",
              "      <td>115020</td>\n",
              "      <td>10020</td>\n",
              "      <td>51</td>\n",
              "      <td>1.0</td>\n",
              "      <td>114613</td>\n",
              "      <td>9978</td>\n",
              "      <td>732.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>509</td>\n",
              "      <td>7642.0</td>\n",
              "      <td>1.200000e+01</td>\n",
              "      <td>12</td>\n",
              "      <td>101546</td>\n",
              "      <td>114613</td>\n",
              "      <td>2</td>\n",
              "      <td>231</td>\n",
              "      <td>10</td>\n",
              "      <td>NaN</td>\n",
              "      <td>30</td>\n",
              "      <td>114388</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       sequenceNumber corporateNumber  ...  furigana  hihyoji\n",
              "count          115020          115020  ...     47018   115020\n",
              "unique         114999          114983  ...     41577        3\n",
              "top              3032   7080402010509  ...    ハチマングウ        0\n",
              "freq                3               4  ...        30   114388\n",
              "\n",
              "[4 rows x 30 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 105
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8g4WMIl9nzO3"
      },
      "source": [
        "data.drop_duplicates(subset='corporateNumber',keep='last',inplace=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 312
        },
        "id": "67DxTiP1n9ah",
        "outputId": "44c7a402-61e9-45df-e03c-f62cfca9f82f"
      },
      "source": [
        "data.describe()"
      ],
      "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>114983</td>\n",
              "      <td>114983</td>\n",
              "      <td>114983</td>\n",
              "      <td>114983</td>\n",
              "      <td>114983</td>\n",
              "      <td>114983</td>\n",
              "      <td>114983</td>\n",
              "      <td>1246.0</td>\n",
              "      <td>114983</td>\n",
              "      <td>114983</td>\n",
              "      <td>114983</td>\n",
              "      <td>114966</td>\n",
              "      <td>1198.0</td>\n",
              "      <td>114983</td>\n",
              "      <td>114983</td>\n",
              "      <td>114810.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>10108</td>\n",
              "      <td>10108.0</td>\n",
              "      <td>6.780000e+02</td>\n",
              "      <td>1130</td>\n",
              "      <td>114983</td>\n",
              "      <td>114983</td>\n",
              "      <td>233</td>\n",
              "      <td>231</td>\n",
              "      <td>231</td>\n",
              "      <td>0</td>\n",
              "      <td>46986</td>\n",
              "      <td>114983</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>unique</th>\n",
              "      <td>114967</td>\n",
              "      <td>114983</td>\n",
              "      <td>11</td>\n",
              "      <td>4</td>\n",
              "      <td>1322</td>\n",
              "      <td>1351</td>\n",
              "      <td>106019</td>\n",
              "      <td>1246.0</td>\n",
              "      <td>15</td>\n",
              "      <td>1</td>\n",
              "      <td>46</td>\n",
              "      <td>99860</td>\n",
              "      <td>1198.0</td>\n",
              "      <td>2</td>\n",
              "      <td>88</td>\n",
              "      <td>3077.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1334</td>\n",
              "      <td>6.0</td>\n",
              "      <td>5.810000e+02</td>\n",
              "      <td>1067</td>\n",
              "      <td>1334</td>\n",
              "      <td>3</td>\n",
              "      <td>232</td>\n",
              "      <td>1</td>\n",
              "      <td>130</td>\n",
              "      <td>0</td>\n",
              "      <td>41577</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>top</th>\n",
              "      <td>3032</td>\n",
              "      <td>5080001019903</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-11-13</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>八幡神社</td>\n",
              "      <td>114683.0</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市中区</td>\n",
              "      <td>新貝町２３９番地の１</td>\n",
              "      <td>114631.0</td>\n",
              "      <td>22</td>\n",
              "      <td>131</td>\n",
              "      <td>4100022.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2016-02-08</td>\n",
              "      <td>1.0</td>\n",
              "      <td>8.080001e+12</td>\n",
              "      <td>平成２９年１２月１日静岡市駿河区富士見台一丁目２１番２２号富士見工業株式会社（8080001...</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Kamiide financial ward</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>2-1-1,oohara, Ito shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハチマングウ</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>freq</th>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>94126</td>\n",
              "      <td>80704</td>\n",
              "      <td>55969</td>\n",
              "      <td>83386</td>\n",
              "      <td>171</td>\n",
              "      <td>1.0</td>\n",
              "      <td>51229</td>\n",
              "      <td>114983</td>\n",
              "      <td>10014</td>\n",
              "      <td>51</td>\n",
              "      <td>1.0</td>\n",
              "      <td>114613</td>\n",
              "      <td>9978</td>\n",
              "      <td>732.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>509</td>\n",
              "      <td>7642.0</td>\n",
              "      <td>1.200000e+01</td>\n",
              "      <td>12</td>\n",
              "      <td>101512</td>\n",
              "      <td>114613</td>\n",
              "      <td>2</td>\n",
              "      <td>231</td>\n",
              "      <td>10</td>\n",
              "      <td>NaN</td>\n",
              "      <td>30</td>\n",
              "      <td>114388</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       sequenceNumber  corporateNumber  ...  furigana  hihyoji\n",
              "count          114983           114983  ...     46986   114983\n",
              "unique         114967           114983  ...     41577        3\n",
              "top              3032    5080001019903  ...    ハチマングウ        0\n",
              "freq                3                1  ...        30   114388\n",
              "\n",
              "[4 rows x 30 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 107
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "VX_I07U4n-LU",
        "outputId": "58236e05-ba5f-43a2-a52a-f8a67be1df84"
      },
      "source": [
        "data.isna().sum()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "sequenceNumber                   0\n",
              "corporateNumber                  0\n",
              "process                          0\n",
              "correct                          0\n",
              "updateDate                       0\n",
              "changeDate                       0\n",
              "name                             0\n",
              "nameImageId                 113737\n",
              "kind                             0\n",
              "prefectureName                   0\n",
              "cityName                         0\n",
              "streetNumber                    17\n",
              "addressImageId              113785\n",
              "prefectureCode                   0\n",
              "cityCode                         0\n",
              "postCode                       173\n",
              "addressOutside              114983\n",
              "addressOutsideImageId       114983\n",
              "closeDate                   104875\n",
              "closeCause                  104875\n",
              "successorCorporateNumber    114305\n",
              "changeCause                 113853\n",
              "assignmentDate                   0\n",
              "latest                           0\n",
              "enName                      114750\n",
              "enPrefectureName            114752\n",
              "enCityName                  114752\n",
              "enAddressOutside            114983\n",
              "furigana                     67997\n",
              "hihyoji                          0\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 108
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "EmMEqFfNwdYB"
      },
      "source": [
        "## ノック７：マスタを読み込んで項目を横に繋げよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "D8lyUCQ6QtY-",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "a256ff7d-c6fd-4f9f-bf6e-30ec1d2c3d30"
      },
      "source": [
        "os.listdir('data')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['22_shizuoka_all_20210331.csv',\n",
              " 'diff_20210401.csv',\n",
              " 'diff_20210405.csv',\n",
              " 'diff_20210406.csv',\n",
              " 'diff_20210407.csv',\n",
              " 'diff_20210408.csv',\n",
              " 'diff_20210409.csv',\n",
              " 'mst_process_kbn.csv',\n",
              " 'mst_correct_kbn.csv',\n",
              " 'mst_latest.csv',\n",
              " 'mst_closeCause.csv',\n",
              " 'mst_corp_kind.csv',\n",
              " 'mst_hihyoji.csv',\n",
              " 'mst_column_name.txt']"
            ]
          },
          "metadata": {},
          "execution_count": 109
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "x77F4mLe7i2e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 359
        },
        "outputId": "b958142a-741a-4881-d24e-7d47dde35489"
      },
      "source": [
        "mst_process_kbn = pd.read_csv('data/mst_process_kbn.csv', dtype=object)\n",
        "mst_process_kbn"
      ],
      "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>process</th>\n",
              "      <th>process_kbn_name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>01</td>\n",
              "      <td>新規</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>11</td>\n",
              "      <td>商号又は名称の変更</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>12</td>\n",
              "      <td>国内所在地の変更</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>13</td>\n",
              "      <td>国外所在地の変更</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>21</td>\n",
              "      <td>登記記録の閉鎖等</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>22</td>\n",
              "      <td>登記記録の復活等</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>71</td>\n",
              "      <td>吸収合併</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>72</td>\n",
              "      <td>吸収合併無効</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>81</td>\n",
              "      <td>商号の登記の抹消</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>99</td>\n",
              "      <td>削除</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  process process_kbn_name\n",
              "0      01               新規\n",
              "1      11        商号又は名称の変更\n",
              "2      12         国内所在地の変更\n",
              "3      13         国外所在地の変更\n",
              "4      21         登記記録の閉鎖等\n",
              "5      22         登記記録の復活等\n",
              "6      71             吸収合併\n",
              "7      72           吸収合併無効\n",
              "8      81         商号の登記の抹消\n",
              "9      99               削除"
            ]
          },
          "metadata": {},
          "execution_count": 110
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "WxiLuvtM7jB5"
      },
      "source": [
        "data = data.merge(mst_process_kbn, on='process', how='left')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PpAJDJwc7sBy",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 366
        },
        "outputId": "5c534d8a-e313-424e-d15d-9b775507b56b"
      },
      "source": [
        "data.head(3)"
      ],
      "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "      <th>process_kbn_name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1000013040008</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>静岡家庭裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市葵区</td>\n",
              "      <td>城内町１−２０</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>101</td>\n",
              "      <td>4.20085e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shizuoka Family Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-20, Jonaicho, Aoi ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シズオカカテイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>1000013050072</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>清水簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市清水区</td>\n",
              "      <td>天神１丁目６−１５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>103</td>\n",
              "      <td>4.24081e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shimizu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-6-15, Tenjin, Shimizu ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シミズカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>1000013050080</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>浜松簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市中区</td>\n",
              "      <td>中央１丁目１２−５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>131</td>\n",
              "      <td>4.30093e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Hamamatsu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-12-5, Chuo, Naka ku, Hamamatsu shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハママツカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  sequenceNumber corporateNumber  ... hihyoji process_kbn_name\n",
              "0              1   1000013040008  ...       0              NaN\n",
              "1              2   1000013050072  ...       0              NaN\n",
              "2              3   1000013050080  ...       0              NaN\n",
              "\n",
              "[3 rows x 31 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 112
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ETz0LwEkiLaN",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 383
        },
        "outputId": "fde3c6f8-e547-4eb8-fe96-42d34bfab76c"
      },
      "source": [
        "print(len(data.columns))\n",
        "data.head(3)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "31\n"
          ],
          "name": "stdout"
        },
        {
          "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "      <th>process_kbn_name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1000013040008</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>静岡家庭裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市葵区</td>\n",
              "      <td>城内町１−２０</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>101</td>\n",
              "      <td>4.20085e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shizuoka Family Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-20, Jonaicho, Aoi ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シズオカカテイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>1000013050072</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>清水簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市清水区</td>\n",
              "      <td>天神１丁目６−１５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>103</td>\n",
              "      <td>4.24081e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shimizu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-6-15, Tenjin, Shimizu ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シミズカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>1000013050080</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>浜松簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市中区</td>\n",
              "      <td>中央１丁目１２−５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>131</td>\n",
              "      <td>4.30093e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Hamamatsu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-12-5, Chuo, Naka ku, Hamamatsu shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハママツカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  sequenceNumber corporateNumber  ... hihyoji process_kbn_name\n",
              "0              1   1000013040008  ...       0              NaN\n",
              "1              2   1000013050072  ...       0              NaN\n",
              "2              3   1000013050080  ...       0              NaN\n",
              "\n",
              "[3 rows x 31 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 113
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pb30UGboVvLj",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 111
        },
        "outputId": "f691187d-e8b1-477d-dbf7-70f3d9e25021"
      },
      "source": [
        "mst_correct_kbn = pd.read_csv('data/mst_correct_kbn.csv',encoding='shift-jis',dtype=object)\n",
        "mst_correct_kbn"
      ],
      "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>correct</th>\n",
              "      <th>correct_kbn_name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>訂正以外</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>訂正</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  correct correct_kbn_name\n",
              "0       0             訂正以外\n",
              "1       1               訂正"
            ]
          },
          "metadata": {},
          "execution_count": 114
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CjgQzboxiLWz",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "cad4371a-df7d-4065-c744-cd15806221ec"
      },
      "source": [
        "data = data.merge(mst_correct_kbn, on='correct',how='left')\n",
        "print(len(data.columns))\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "32\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HqfXFSaoWGTx",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 366
        },
        "outputId": "f20d5716-cd6c-43a2-da58-c29d24b434fa"
      },
      "source": [
        "data.head(3)"
      ],
      "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "      <th>process_kbn_name</th>\n",
              "      <th>correct_kbn_name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1000013040008</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>静岡家庭裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市葵区</td>\n",
              "      <td>城内町１−２０</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>101</td>\n",
              "      <td>4.20085e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shizuoka Family Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-20, Jonaicho, Aoi ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シズオカカテイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>1000013050072</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>清水簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市清水区</td>\n",
              "      <td>天神１丁目６−１５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>103</td>\n",
              "      <td>4.24081e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shimizu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-6-15, Tenjin, Shimizu ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シミズカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>1000013050080</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>浜松簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市中区</td>\n",
              "      <td>中央１丁目１２−５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>131</td>\n",
              "      <td>4.30093e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Hamamatsu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-12-5, Chuo, Naka ku, Hamamatsu shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハママツカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  sequenceNumber corporateNumber  ... process_kbn_name correct_kbn_name\n",
              "0              1   1000013040008  ...              NaN              NaN\n",
              "1              2   1000013050072  ...              NaN              NaN\n",
              "2              3   1000013050080  ...              NaN              NaN\n",
              "\n",
              "[3 rows x 32 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 116
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6CJqDq2iQtf2",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "013475d8-1ba2-478b-a7d2-5827d5dd4b1b"
      },
      "source": [
        "data[data['correct_kbn_name'].notna()]"
      ],
      "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "      <th>process_kbn_name</th>\n",
              "      <th>correct_kbn_name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>114613</th>\n",
              "      <td>109</td>\n",
              "      <td>1080001015906</td>\n",
              "      <td>12</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2021-03-30</td>\n",
              "      <td>株式会社エムケイテック</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>藤枝市</td>\n",
              "      <td>岡部桂島９８５番地の５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>214</td>\n",
              "      <td>4260000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>エムケイテック</td>\n",
              "      <td>0</td>\n",
              "      <td>国内所在地の変更</td>\n",
              "      <td>訂正</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114614</th>\n",
              "      <td>110</td>\n",
              "      <td>1080002015434</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>有限会社ハイナンＤＣ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>牧之原市</td>\n",
              "      <td>大沢１４４番地９</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>226</td>\n",
              "      <td>4210526</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハイナンディーシー</td>\n",
              "      <td>0</td>\n",
              "      <td>新規</td>\n",
              "      <td>訂正</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114615</th>\n",
              "      <td>111</td>\n",
              "      <td>1080105005588</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2021-03-25</td>\n",
              "      <td>認定特定非営利活動法人ＲＥＡＬＥ　ＷＯＲＬＤ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>399</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>伊東市</td>\n",
              "      <td>富戸１３１７番地５０３０</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>208</td>\n",
              "      <td>4130231</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-12-11</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>レアーレワールド</td>\n",
              "      <td>0</td>\n",
              "      <td>国内所在地の変更</td>\n",
              "      <td>訂正以外</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114616</th>\n",
              "      <td>112</td>\n",
              "      <td>1080401024928</td>\n",
              "      <td>01</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>ＡＧＡＩＮＮＴ’Ｓ株式会社</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市東区</td>\n",
              "      <td>篠ケ瀬町１２４７番地の１、２階</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>132</td>\n",
              "      <td>4350042</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>アゲインツ</td>\n",
              "      <td>0</td>\n",
              "      <td>新規</td>\n",
              "      <td>訂正以外</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114617</th>\n",
              "      <td>113</td>\n",
              "      <td>1080401024936</td>\n",
              "      <td>01</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>株式会社通</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市西区</td>\n",
              "      <td>雄踏町宇布見４７３３番地</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>133</td>\n",
              "      <td>4310102</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ツウ</td>\n",
              "      <td>0</td>\n",
              "      <td>新規</td>\n",
              "      <td>訂正以外</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",
              "      <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>114978</th>\n",
              "      <td>3195</td>\n",
              "      <td>9080001021673</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2017-07-07</td>\n",
              "      <td>株式会社ＡＣＴ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市葵区</td>\n",
              "      <td>太田町１４番地の４</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>101</td>\n",
              "      <td>4200845</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2017-07-07</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>アクト</td>\n",
              "      <td>0</td>\n",
              "      <td>新規</td>\n",
              "      <td>訂正</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114979</th>\n",
              "      <td>3196</td>\n",
              "      <td>9080101022431</td>\n",
              "      <td>01</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>株式会社ＬＥＳＱＵＡ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>沼津市</td>\n",
              "      <td>大岡２５５番地の１５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>203</td>\n",
              "      <td>4100022</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>レスカ</td>\n",
              "      <td>0</td>\n",
              "      <td>新規</td>\n",
              "      <td>訂正以外</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114980</th>\n",
              "      <td>3197</td>\n",
              "      <td>9080102008933</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>有限会社サクラ急送</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>伊豆の国市</td>\n",
              "      <td>奈古谷６６３番地の２</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>225</td>\n",
              "      <td>4102132</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>サクラキュウソウ</td>\n",
              "      <td>0</td>\n",
              "      <td>新規</td>\n",
              "      <td>訂正</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114981</th>\n",
              "      <td>3198</td>\n",
              "      <td>9080402002859</td>\n",
              "      <td>21</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>有限会社弘法</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市南区</td>\n",
              "      <td>下江町４５６番地の１</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>134</td>\n",
              "      <td>4300825</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>11</td>\n",
              "      <td>8080401016019</td>\n",
              "      <td>令和３年４月１日静岡県磐田市安久路二丁目２番地の２まごころ株式会社（808040101601...</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>コウボウ</td>\n",
              "      <td>0</td>\n",
              "      <td>登記記録の閉鎖等</td>\n",
              "      <td>訂正以外</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114982</th>\n",
              "      <td>3199</td>\n",
              "      <td>9080402015836</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>有限会社エコワークス</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市西区</td>\n",
              "      <td>大人見町３３７４番地の１</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>133</td>\n",
              "      <td>4311112</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>エコワークス</td>\n",
              "      <td>0</td>\n",
              "      <td>国内所在地の変更</td>\n",
              "      <td>訂正以外</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>370 rows × 32 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       sequenceNumber corporateNumber  ... process_kbn_name correct_kbn_name\n",
              "114613            109   1080001015906  ...         国内所在地の変更               訂正\n",
              "114614            110   1080002015434  ...               新規               訂正\n",
              "114615            111   1080105005588  ...         国内所在地の変更             訂正以外\n",
              "114616            112   1080401024928  ...               新規             訂正以外\n",
              "114617            113   1080401024936  ...               新規             訂正以外\n",
              "...               ...             ...  ...              ...              ...\n",
              "114978           3195   9080001021673  ...               新規               訂正\n",
              "114979           3196   9080101022431  ...               新規             訂正以外\n",
              "114980           3197   9080102008933  ...               新規               訂正\n",
              "114981           3198   9080402002859  ...         登記記録の閉鎖等             訂正以外\n",
              "114982           3199   9080402015836  ...         国内所在地の変更             訂正以外\n",
              "\n",
              "[370 rows x 32 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 117
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gQC3_PosiLTD",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "outputId": "7c0e7918-1f9b-4049-ab45-a54598f3344a"
      },
      "source": [
        "mst_corp_kind = pd.read_csv('data/mst_corp_kind.csv', dtype=object)\n",
        "mst_corp_kind.head()"
      ],
      "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>kind</th>\n",
              "      <th>corp_kind_name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>101</td>\n",
              "      <td>国の機関</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>201</td>\n",
              "      <td>地方公共団体</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>301</td>\n",
              "      <td>株式会社</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>302</td>\n",
              "      <td>有限会社</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>303</td>\n",
              "      <td>合名会社</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  kind corp_kind_name\n",
              "0  101           国の機関\n",
              "1  201         地方公共団体\n",
              "2  301           株式会社\n",
              "3  302           有限会社\n",
              "4  303           合名会社"
            ]
          },
          "metadata": {},
          "execution_count": 118
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5fqJ4wDIi6Oe",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "72a2765e-09c5-45f6-b774-965f98ee3762"
      },
      "source": [
        "data = data.merge(mst_corp_kind, on='kind',how='left')\n",
        "print(len(data.columns))\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "33\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dmW_80f__Uqa",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "ef6f1e10-a342-42e7-a255-4b1be958f2e0"
      },
      "source": [
        "data"
      ],
      "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>sequenceNumber</th>\n",
              "      <th>corporateNumber</th>\n",
              "      <th>process</th>\n",
              "      <th>correct</th>\n",
              "      <th>updateDate</th>\n",
              "      <th>changeDate</th>\n",
              "      <th>name</th>\n",
              "      <th>nameImageId</th>\n",
              "      <th>kind</th>\n",
              "      <th>prefectureName</th>\n",
              "      <th>cityName</th>\n",
              "      <th>streetNumber</th>\n",
              "      <th>addressImageId</th>\n",
              "      <th>prefectureCode</th>\n",
              "      <th>cityCode</th>\n",
              "      <th>postCode</th>\n",
              "      <th>addressOutside</th>\n",
              "      <th>addressOutsideImageId</th>\n",
              "      <th>closeDate</th>\n",
              "      <th>closeCause</th>\n",
              "      <th>successorCorporateNumber</th>\n",
              "      <th>changeCause</th>\n",
              "      <th>assignmentDate</th>\n",
              "      <th>latest</th>\n",
              "      <th>enName</th>\n",
              "      <th>enPrefectureName</th>\n",
              "      <th>enCityName</th>\n",
              "      <th>enAddressOutside</th>\n",
              "      <th>furigana</th>\n",
              "      <th>hihyoji</th>\n",
              "      <th>process_kbn_name</th>\n",
              "      <th>correct_kbn_name</th>\n",
              "      <th>corp_kind_name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1000013040008</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>静岡家庭裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市葵区</td>\n",
              "      <td>城内町１−２０</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>101</td>\n",
              "      <td>4.20085e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shizuoka Family Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-20, Jonaicho, Aoi ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シズオカカテイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>1000013050072</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>清水簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市清水区</td>\n",
              "      <td>天神１丁目６−１５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>103</td>\n",
              "      <td>4.24081e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Shimizu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-6-15, Tenjin, Shimizu ku, Shizuoka shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>シミズカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>1000013050080</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-02</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>浜松簡易裁判所</td>\n",
              "      <td>NaN</td>\n",
              "      <td>101</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市中区</td>\n",
              "      <td>中央１丁目１２−５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>131</td>\n",
              "      <td>4.30093e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Hamamatsu Summary Court</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>1-12-5, Chuo, Naka ku, Hamamatsu shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ハママツカンイサイバンショ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>1000020222119</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-05</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>磐田市</td>\n",
              "      <td>NaN</td>\n",
              "      <td>201</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>磐田市</td>\n",
              "      <td>国府台３−１</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>211</td>\n",
              "      <td>4.38008e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Iwata City</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>3-1,Kounodai, Iwata shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>イワタシ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>1000020222127</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2018-04-05</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>焼津市</td>\n",
              "      <td>NaN</td>\n",
              "      <td>201</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>焼津市</td>\n",
              "      <td>本町２丁目１６−３２</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>212</td>\n",
              "      <td>4.25002e+06</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>Yaizu city</td>\n",
              "      <td>Shizuoka</td>\n",
              "      <td>2-16-32 Honmachi, Yaizu shi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ヤイヅシ</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</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",
              "      <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>114978</th>\n",
              "      <td>3195</td>\n",
              "      <td>9080001021673</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2017-07-07</td>\n",
              "      <td>株式会社ＡＣＴ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>静岡市葵区</td>\n",
              "      <td>太田町１４番地の４</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>101</td>\n",
              "      <td>4200845</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2017-07-07</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>アクト</td>\n",
              "      <td>0</td>\n",
              "      <td>新規</td>\n",
              "      <td>訂正</td>\n",
              "      <td>株式会社</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114979</th>\n",
              "      <td>3196</td>\n",
              "      <td>9080101022431</td>\n",
              "      <td>01</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>株式会社ＬＥＳＱＵＡ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>301</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>沼津市</td>\n",
              "      <td>大岡２５５番地の１５</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>203</td>\n",
              "      <td>4100022</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>レスカ</td>\n",
              "      <td>0</td>\n",
              "      <td>新規</td>\n",
              "      <td>訂正以外</td>\n",
              "      <td>株式会社</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114980</th>\n",
              "      <td>3197</td>\n",
              "      <td>9080102008933</td>\n",
              "      <td>01</td>\n",
              "      <td>1</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>有限会社サクラ急送</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>伊豆の国市</td>\n",
              "      <td>奈古谷６６３番地の２</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>225</td>\n",
              "      <td>4102132</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>サクラキュウソウ</td>\n",
              "      <td>0</td>\n",
              "      <td>新規</td>\n",
              "      <td>訂正</td>\n",
              "      <td>有限会社</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114981</th>\n",
              "      <td>3198</td>\n",
              "      <td>9080402002859</td>\n",
              "      <td>21</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>有限会社弘法</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市南区</td>\n",
              "      <td>下江町４５６番地の１</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>134</td>\n",
              "      <td>4300825</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>11</td>\n",
              "      <td>8080401016019</td>\n",
              "      <td>令和３年４月１日静岡県磐田市安久路二丁目２番地の２まごころ株式会社（808040101601...</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>コウボウ</td>\n",
              "      <td>0</td>\n",
              "      <td>登記記録の閉鎖等</td>\n",
              "      <td>訂正以外</td>\n",
              "      <td>有限会社</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114982</th>\n",
              "      <td>3199</td>\n",
              "      <td>9080402015836</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-04-09</td>\n",
              "      <td>2021-04-01</td>\n",
              "      <td>有限会社エコワークス</td>\n",
              "      <td>NaN</td>\n",
              "      <td>302</td>\n",
              "      <td>静岡県</td>\n",
              "      <td>浜松市西区</td>\n",
              "      <td>大人見町３３７４番地の１</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22</td>\n",
              "      <td>133</td>\n",
              "      <td>4311112</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2015-10-05</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>エコワークス</td>\n",
              "      <td>0</td>\n",
              "      <td>国内所在地の変更</td>\n",
              "      <td>訂正以外</td>\n",
              "      <td>有限会社</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>114983 rows × 33 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       sequenceNumber corporateNumber  ... correct_kbn_name corp_kind_name\n",
              "0                   1   1000013040008  ...              NaN            NaN\n",
              "1                   2   1000013050072  ...              NaN            NaN\n",
              "2                   3   1000013050080  ...              NaN            NaN\n",
              "3                   4   1000020222119  ...              NaN            NaN\n",
              "4                   5   1000020222127  ...              NaN            NaN\n",
              "...               ...             ...  ...              ...            ...\n",
              "114978           3195   9080001021673  ...               訂正           株式会社\n",
              "114979           3196   9080101022431  ...             訂正以外           株式会社\n",
              "114980           3197   9080102008933  ...               訂正           有限会社\n",
              "114981           3198   9080402002859  ...             訂正以外           有限会社\n",
              "114982           3199   9080402015836  ...             訂正以外           有限会社\n",
              "\n",
              "[114983 rows x 33 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 121
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rqEjlChui6L6"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KzDF_WOH-3iH"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "9K0jraNW615H"
      },
      "source": [
        "## ノック８：テキストの連結や分割をしよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tAY0PgnG7Two"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "L5X2wDCPws7j"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ExieiuWXxrAX"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Rssx-kkDxrEl"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "V9JeCiW0yaKx"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "czPeOvRpC0q-"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KbYfrW_vJ3fi"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "B5Hn_XxOJ3ph"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "T6n7m5TJ7AkB"
      },
      "source": [
        "## ノック９：日付を加工しよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Hh4voaK5EWIy"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pp4IM35pEWNx"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PYcrAHBXEWXy"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SQ5WXWwLKe6G"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DrSSIdr-EWer"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NmkV16LBKHYz"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HYCFhKdNxE0o"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pxB5wykkKHdL"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HkpTWI6VLKzs"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NhtPdrAmLqf6"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_-nKto7YL7Bm"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "XMwFLVzu-CZC"
      },
      "source": [
        "## ノック１０：年度を設定しよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8Qm0lSGh-eXC"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "yd-2BV8CbXqf"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DNZpbuhvX2QD"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "QPEBK5A47IFZ"
      },
      "source": [
        "## ノック１１：加工したデータをファイルに出力しよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DmJe35nRzIYT"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "oFrIz626NtRx"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4jBHTfcRNtWK"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "3adikQ_m65BI"
      },
      "source": [
        "## ノック１２：不要な項目の削除と並べ替えをしよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "d8kal8_4w0vQ"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "WIHn2hG4w0yw"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "v1sp97Bow041"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "aXfxDIbJPYcS"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "m87Vuvjb69bU"
      },
      "source": [
        "## ノック１３：まとまった単位で集計しよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3yC1LA6Gosp0"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LebTq01-hwjW"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SB7cpmJflhPW"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Zk1k3xaQjyX7"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Uc_fFgydqhNj"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ChDnISx2McsC"
      },
      "source": [
        "## ノック１４：市区町村別の法人数を可視化しよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ltr0lIZ7YnVF"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EIF1Jx8nHlzu"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "otM88RmMYU1t"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "JLjaeA5SBYzu"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "xZUzoupPKyHu"
      },
      "source": [
        "## ノック１５：グラフの縦横と表示順を変えてみよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "56cZ_GCFLeC-"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1Roi13s5U6Tv"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "3rjir-OYMuSC"
      },
      "source": [
        "## ノック１６：グラフのタイトルとラベルを設定しよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3Sn0LaQjXs36"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SCFxrkPIJ89L"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ZVbB0ORNMuce"
      },
      "source": [
        "## ノック１７：グラフの見た目をもっと変えてみよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Imo1pjuQcDMT"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "MPSnLkD0Mkly"
      },
      "source": [
        "## ノック１８：９０日以内に新規登録された法人数を可視化してみよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Gm9PR3GwM4F8"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "79WyMnMEVTK4"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "aHPDh73iNATi"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pWDrnaBIqck0"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FV_zIHl0EGQb"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "oIIvA-vHEGTO"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fZZlKIRpEGV7"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "MitoEhNPM5s1"
      },
      "source": [
        "## ノック１９：年度別の推移を可視化しよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NBcoQ9bnLaWW"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YrytswQ5xVhc"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LTNolgJoGN3q"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NMh07RKdxUWQ"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "20F9WmchGlfL"
      },
      "source": [
        "## ノック２０：データとグラフを出力しよう"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "RKR4X1so6XQW"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LXQIkSZY2Zys"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}