ワクチン接種歴別の新規陽性者数簡易CSV変換.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "ワクチン接種歴別の新規陽性者数簡易CSV変換.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyPcOcRPGsO8eIVFEA1J7W7u",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/imabari/ImabariScraping/blob/master/%E3%83%AF%E3%82%AF%E3%83%81%E3%83%B3%E6%8E%A5%E7%A8%AE%E6%AD%B4%E5%88%A5%E3%81%AE%E6%96%B0%E8%A6%8F%E9%99%BD%E6%80%A7%E8%80%85%E6%95%B0%E7%B0%A1%E6%98%93CSV%E5%A4%89%E6%8F%9B.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install pdfplumber"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "sD08ug2HTcyK",
        "outputId": "92f1982b-50cb-4d0f-bcef-927738de24cc"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Requirement already satisfied: pdfplumber in /usr/local/lib/python3.7/dist-packages (0.7.4)\n",
            "Requirement already satisfied: Wand>=0.6.7 in /usr/local/lib/python3.7/dist-packages (from pdfplumber) (0.6.10)\n",
            "Requirement already satisfied: Pillow>=9.1 in /usr/local/lib/python3.7/dist-packages (from pdfplumber) (9.2.0)\n",
            "Requirement already satisfied: pdfminer.six==20220524 in /usr/local/lib/python3.7/dist-packages (from pdfplumber) (20220524)\n",
            "Requirement already satisfied: charset-normalizer>=2.0.0 in /usr/local/lib/python3.7/dist-packages (from pdfminer.six==20220524->pdfplumber) (2.1.0)\n",
            "Requirement already satisfied: cryptography>=36.0.0 in /usr/local/lib/python3.7/dist-packages (from pdfminer.six==20220524->pdfplumber) (37.0.4)\n",
            "Requirement already satisfied: cffi>=1.12 in /usr/local/lib/python3.7/dist-packages (from cryptography>=36.0.0->pdfminer.six==20220524->pdfplumber) (1.15.1)\n",
            "Requirement already satisfied: pycparser in /usr/local/lib/python3.7/dist-packages (from cffi>=1.12->cryptography>=36.0.0->pdfminer.six==20220524->pdfplumber) (2.21)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# 設定"
      ],
      "metadata": {
        "id": "LBfiGsR04eKe"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "url = \"https://www.mhlw.go.jp/content/10900000/000975388.pdf\" #@param {type:\"string\"}\n",
        "page_no = 2 #@param {type:\"integer\"}\n",
        "view_date = \"2022-07-31\" #@param {type:\"date\"}"
      ],
      "metadata": {
        "cellView": "form",
        "id": "abou1IUp2Kel"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# ダウンロード"
      ],
      "metadata": {
        "id": "zGxvxiUA4gx2"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "!wget $url -O data.pdf"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "WATsNDVJTcvi",
        "outputId": "716c4cf9-d91d-4798-c8e7-59d6ee9a7f57"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "--2022-08-19 02:20:03--  https://www.mhlw.go.jp/content/10900000/000975388.pdf\n",
            "Resolving www.mhlw.go.jp (www.mhlw.go.jp)... 96.7.101.214, 2600:1417:e800:183::3194, 2600:1417:e800:185::3194\n",
            "Connecting to www.mhlw.go.jp (www.mhlw.go.jp)|96.7.101.214|:443... connected.\n",
            "HTTP request sent, awaiting response... 200 OK\n",
            "Length: 2767986 (2.6M) [application/pdf]\n",
            "Saving to: ‘data.pdf’\n",
            "\n",
            "data.pdf            100%[===================>]   2.64M  --.-KB/s    in 0.1s    \n",
            "\n",
            "2022-08-19 02:20:04 (25.1 MB/s) - ‘data.pdf’ saved [2767986/2767986]\n",
            "\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pdfplumber\n",
        "import pandas as pd"
      ],
      "metadata": {
        "id": "c52w2tlhTc06"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# ページ番号変換\n",
        "page_num = lambda x: x - 1"
      ],
      "metadata": {
        "id": "nZd_jOHEZCli"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# 表抽出\n",
        "\n",
        "with pdfplumber.open(\"data.pdf\") as pdf:\n",
        "\n",
        "    page = pdf.pages[page_num(page_no)]\n",
        "\n",
        "    table = page.extract_table()"
      ],
      "metadata": {
        "id": "xlxpzxSATyEi"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# 列名\n",
        "\n",
        "df_col = pd.DataFrame(table[:2]).fillna(method=\"ffill\", axis=1).replace(\"\\s\", \"\", regex=True)\n",
        "df_col.iat[0, 0] = view_date\n",
        "df_col"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 541
        },
        "id": "-H3w-Vj9VMqC",
        "outputId": "8bc6a04f-dd5a-4bfd-930c-c61afd96a7d5"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           0                     1              2               3   \\\n",
              "0  2022-07-31                   未接種            未接種             未接種   \n",
              "1              新規陽性者数(7/25-7/31の合計）  未接種者数(7/31時点)  10万人あたりの新規陽性者数   \n",
              "\n",
              "                     4                            5                    6   \\\n",
              "0   ２回目接種済み（３回目接種済みを除く）          ２回目接種済み（３回目接種済みを除く）  ２回目接種済み（３回目接種済みを除く）   \n",
              "1  新規陽性者数(7/25-7/31の合計）  ２回目接種者数(３回目接種者数を除く)(7/31時点)       10万人あたりの新規陽性者数   \n",
              "\n",
              "                     7                8               9                     10  \n",
              "0               ３回目接種済み          ３回目接種済み         ３回目接種済み                 接種歴不明  \n",
              "1  新規陽性者数(7/25-7/31の合計）  ３回目接種者数(7/31時点)  10万人あたりの新規陽性者数  新規陽性者数(7/25-7/31の合計)  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1d250df1-054a-4786-8349-059bdb59ee2b\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2022-07-31</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>1</th>\n",
              "      <td></td>\n",
              "      <td>新規陽性者数(7/25-7/31の合計）</td>\n",
              "      <td>未接種者数(7/31時点)</td>\n",
              "      <td>10万人あたりの新規陽性者数</td>\n",
              "      <td>新規陽性者数(7/25-7/31の合計）</td>\n",
              "      <td>２回目接種者数(３回目接種者数を除く)(7/31時点)</td>\n",
              "      <td>10万人あたりの新規陽性者数</td>\n",
              "      <td>新規陽性者数(7/25-7/31の合計）</td>\n",
              "      <td>３回目接種者数(7/31時点)</td>\n",
              "      <td>10万人あたりの新規陽性者数</td>\n",
              "      <td>新規陽性者数(7/25-7/31の合計)</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1d250df1-054a-4786-8349-059bdb59ee2b')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-1d250df1-054a-4786-8349-059bdb59ee2b button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-1d250df1-054a-4786-8349-059bdb59ee2b');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "col = df_col.values.tolist()"
      ],
      "metadata": {
        "id": "7jZK1Ic2VTrj"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.DataFrame(table[2:], columns=col)"
      ],
      "metadata": {
        "id": "NpNj1qJbTyQC"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 487
        },
        "id": "pwWSsbP6TyTK",
        "outputId": "3c251885-5e7c-42a7-bac6-876987364469"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   2022-07-31                  未接種                               \\\n",
              "              新規陽性者数(7/25-7/31の合計） 未接種者数(7/31時点) 10万人あたりの新規陽性者数   \n",
              "0       0-11歳              142,312    10,661,366         1334.8   \n",
              "1      12-19歳               29,032     2,188,505         1326.6   \n",
              "2      20-29歳               31,161     2,403,918         1296.3   \n",
              "3      30-39歳               28,014     2,817,875          994.2   \n",
              "4      40-49歳               21,447     3,156,002          679.6   \n",
              "5      50-59歳               12,638     1,232,272         1025.6   \n",
              "6      60-64歳                3,011       613,625          490.7   \n",
              "7      65-69歳                1,815     1,042,000          174.2   \n",
              "8      70-79歳                2,782       862,504          322.5   \n",
              "9      80-89歳                1,864        40,255         4630.5   \n",
              "10      90歳以上                  820             －              －   \n",
              "\n",
              "    ２回目接種済み（３回目接種済みを除く）                                             \\\n",
              "   新規陽性者数(7/25-7/31の合計） ２回目接種者数(３回目接種者数を除く)(7/31時点) 10万人あたりの新規陽性者数   \n",
              "0                                                                    \n",
              "1                46,576                   3,653,795         1274.7   \n",
              "2                57,377                   4,172,212         1375.2   \n",
              "3                51,511                   4,042,230         1274.3   \n",
              "4                46,397                   4,067,295         1140.7   \n",
              "5                22,503                   2,474,289          909.5   \n",
              "6                 4,187                     575,442          727.6   \n",
              "7                 2,142                     348,966          613.8   \n",
              "8                 2,854                     571,087          499.7   \n",
              "9                 1,936                     394,766          490.4   \n",
              "10                  791                     134,534          588.0   \n",
              "\n",
              "                ３回目接種済み                                               接種歴不明  \n",
              "   新規陽性者数(7/25-7/31の合計） ３回目接種者数(7/31時点) 10万人あたりの新規陽性者数 新規陽性者数(7/25-7/31の合計)  \n",
              "0                                                                            \n",
              "1                22,153       3,094,663          715.8               33,445  \n",
              "2                64,850       6,147,698         1054.9               43,416  \n",
              "3                72,661       7,435,826          977.2               46,491  \n",
              "4                96,272      11,133,273          864.7               46,311  \n",
              "5                84,447      13,058,644          646.7               30,861  \n",
              "6                31,051       6,209,106          500.1                9,820  \n",
              "7                25,295       6,693,599          377.9                7,710  \n",
              "8                40,892      14,761,040          277.0               12,593  \n",
              "9                22,916       8,592,454          266.7                8,714  \n",
              "10                9,451       2,261,986          417.8                3,704  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-e186c8bb-1708-4bea-94af-638910c5681a\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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 tr th {\n",
              "        text-align: left;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th></th>\n",
              "      <th>2022-07-31</th>\n",
              "      <th colspan=\"3\" halign=\"left\">未接種</th>\n",
              "      <th colspan=\"3\" halign=\"left\">２回目接種済み（３回目接種済みを除く）</th>\n",
              "      <th colspan=\"3\" halign=\"left\">３回目接種済み</th>\n",
              "      <th>接種歴不明</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th>新規陽性者数(7/25-7/31の合計）</th>\n",
              "      <th>未接種者数(7/31時点)</th>\n",
              "      <th>10万人あたりの新規陽性者数</th>\n",
              "      <th>新規陽性者数(7/25-7/31の合計）</th>\n",
              "      <th>２回目接種者数(３回目接種者数を除く)(7/31時点)</th>\n",
              "      <th>10万人あたりの新規陽性者数</th>\n",
              "      <th>新規陽性者数(7/25-7/31の合計）</th>\n",
              "      <th>３回目接種者数(7/31時点)</th>\n",
              "      <th>10万人あたりの新規陽性者数</th>\n",
              "      <th>新規陽性者数(7/25-7/31の合計)</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0-11歳</td>\n",
              "      <td>142,312</td>\n",
              "      <td>10,661,366</td>\n",
              "      <td>1334.8</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>1</th>\n",
              "      <td>12-19歳</td>\n",
              "      <td>29,032</td>\n",
              "      <td>2,188,505</td>\n",
              "      <td>1326.6</td>\n",
              "      <td>46,576</td>\n",
              "      <td>3,653,795</td>\n",
              "      <td>1274.7</td>\n",
              "      <td>22,153</td>\n",
              "      <td>3,094,663</td>\n",
              "      <td>715.8</td>\n",
              "      <td>33,445</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>20-29歳</td>\n",
              "      <td>31,161</td>\n",
              "      <td>2,403,918</td>\n",
              "      <td>1296.3</td>\n",
              "      <td>57,377</td>\n",
              "      <td>4,172,212</td>\n",
              "      <td>1375.2</td>\n",
              "      <td>64,850</td>\n",
              "      <td>6,147,698</td>\n",
              "      <td>1054.9</td>\n",
              "      <td>43,416</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>30-39歳</td>\n",
              "      <td>28,014</td>\n",
              "      <td>2,817,875</td>\n",
              "      <td>994.2</td>\n",
              "      <td>51,511</td>\n",
              "      <td>4,042,230</td>\n",
              "      <td>1274.3</td>\n",
              "      <td>72,661</td>\n",
              "      <td>7,435,826</td>\n",
              "      <td>977.2</td>\n",
              "      <td>46,491</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>40-49歳</td>\n",
              "      <td>21,447</td>\n",
              "      <td>3,156,002</td>\n",
              "      <td>679.6</td>\n",
              "      <td>46,397</td>\n",
              "      <td>4,067,295</td>\n",
              "      <td>1140.7</td>\n",
              "      <td>96,272</td>\n",
              "      <td>11,133,273</td>\n",
              "      <td>864.7</td>\n",
              "      <td>46,311</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>50-59歳</td>\n",
              "      <td>12,638</td>\n",
              "      <td>1,232,272</td>\n",
              "      <td>1025.6</td>\n",
              "      <td>22,503</td>\n",
              "      <td>2,474,289</td>\n",
              "      <td>909.5</td>\n",
              "      <td>84,447</td>\n",
              "      <td>13,058,644</td>\n",
              "      <td>646.7</td>\n",
              "      <td>30,861</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>60-64歳</td>\n",
              "      <td>3,011</td>\n",
              "      <td>613,625</td>\n",
              "      <td>490.7</td>\n",
              "      <td>4,187</td>\n",
              "      <td>575,442</td>\n",
              "      <td>727.6</td>\n",
              "      <td>31,051</td>\n",
              "      <td>6,209,106</td>\n",
              "      <td>500.1</td>\n",
              "      <td>9,820</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>65-69歳</td>\n",
              "      <td>1,815</td>\n",
              "      <td>1,042,000</td>\n",
              "      <td>174.2</td>\n",
              "      <td>2,142</td>\n",
              "      <td>348,966</td>\n",
              "      <td>613.8</td>\n",
              "      <td>25,295</td>\n",
              "      <td>6,693,599</td>\n",
              "      <td>377.9</td>\n",
              "      <td>7,710</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>70-79歳</td>\n",
              "      <td>2,782</td>\n",
              "      <td>862,504</td>\n",
              "      <td>322.5</td>\n",
              "      <td>2,854</td>\n",
              "      <td>571,087</td>\n",
              "      <td>499.7</td>\n",
              "      <td>40,892</td>\n",
              "      <td>14,761,040</td>\n",
              "      <td>277.0</td>\n",
              "      <td>12,593</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>80-89歳</td>\n",
              "      <td>1,864</td>\n",
              "      <td>40,255</td>\n",
              "      <td>4630.5</td>\n",
              "      <td>1,936</td>\n",
              "      <td>394,766</td>\n",
              "      <td>490.4</td>\n",
              "      <td>22,916</td>\n",
              "      <td>8,592,454</td>\n",
              "      <td>266.7</td>\n",
              "      <td>8,714</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>90歳以上</td>\n",
              "      <td>820</td>\n",
              "      <td>－</td>\n",
              "      <td>－</td>\n",
              "      <td>791</td>\n",
              "      <td>134,534</td>\n",
              "      <td>588.0</td>\n",
              "      <td>9,451</td>\n",
              "      <td>2,261,986</td>\n",
              "      <td>417.8</td>\n",
              "      <td>3,704</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e186c8bb-1708-4bea-94af-638910c5681a')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-e186c8bb-1708-4bea-94af-638910c5681a button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-e186c8bb-1708-4bea-94af-638910c5681a');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.to_csv(\"result.csv\", encoding=\"utf_8_sig\")"
      ],
      "metadata": {
        "id": "bvscBHWAXpSq"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}