kodaira_scraper.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "kodaira-scraper.ipynb",
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/tom2rd/Googlecolabutils/blob/master/kodaira_scraper.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "npLdhiM8JHku",
        "colab_type": "text"
      },
      "source": [
        "# 小平市の情報スクレイピング\n",
        "* 市役所　統計情報\n",
        " * https://www.city.kodaira.tokyo.jp/kurashi/076/076079.html\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "J1kkhLP3NdoC",
        "colab_type": "code",
        "outputId": "d6a6228b-e48d-4299-db17-db3c458333e5",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 72
        }
      },
      "source": [
        "load_url = \"https://www.city.kodaira.tokyo.jp/kurashi/076/076079.html\"\n",
        "load_urlo=\"http://keishin.ullet.com/search/city/13211/pref/13.html#pref/13/city/13211\"\n",
        "html = requests.get(load_url)\n",
        "soup = BeautifulSoup(html.content, \"html.parser\")\n",
        "alists=soup.find_all('a',href=re.compile(\"/kurashi/076/\"))\n",
        "#print(alists)\n",
        "urlists=[]\n",
        "titlelists=[]\n",
        "for alist in alists:\n",
        " #print(alist.attrs[\"href\"],alist.text)\n",
        " urlists.append(alist.attrs[\"href\"])\n",
        " titlelists.append(alist.text)\n",
        "print(urlists)\n",
        "print(titlelists)\n",
        "#print(soup.find_all('a', class_=\"company_name\"))\n",
        "#print(soup.find_all('a',text=re.compile(\"P.\")))"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "['/kurashi/076/076081.html', '/kurashi/076/076067.html', '/kurashi/076/076068.html', '/kurashi/076/076069.html', '/kurashi/076/076070.html', '/kurashi/076/076071.html', '/kurashi/076/076072.html', '/kurashi/076/076073.html', '/kurashi/076/076074.html', '/kurashi/076/076075.html', '/kurashi/076/076076.html', '/kurashi/076/076077.html', '/kurashi/076/076078.html']\n",
            "['表紙', '自然条件 ', '人口 ', '産業 ', '経済・労働 ', '交通・通信 ', '都市施設 ', '保健衛生及び環境 ', '社会福祉 ', '教育 ', '治安・防災 ', '議会・選挙', '行財政']\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9vH4mYGoOBdi",
        "colab_type": "code",
        "outputId": "0558a343-8d28-4616-cd30-ba148c29d721",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "load_url=\"https://www.city.kodaira.tokyo.jp/kurashi/076/076068.html\"\n",
        "html = requests.get(load_url)\n",
        "soup = BeautifulSoup(html.content, \"html.parser\")\n",
        "alists=soup.find_all('a',class_=\"icon_excel\")\n",
        "alists"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[<a class=\"icon_excel\" href=\"/kurashi/files/76068/076068/att_0000001.xlsx\">統計表8～22<span class=\"filestatus\">（Excel 88.5KB）</span></a>]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "IoBPQ4rzYQu1",
        "colab_type": "code",
        "outputId": "6b9172d8-5d67-46b9-dbe4-22f6cab7c401",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 228
        }
      },
      "source": [
        "orig_url=\"https://www.city.kodaira.tokyo.jp\"\n",
        "xlslists=[]\n",
        "for lo_url in urlists:\n",
        " load_url=orig_url+lo_url\n",
        " #print(load_url)\n",
        " html = requests.get(load_url)\n",
        " soup = BeautifulSoup(html.content, \"html.parser\")\n",
        " alists=soup.find_all('a',class_=\"icon_excel\")\n",
        " for i in alists:\n",
        "  xlslists.append(orig_url+i.attrs[\"href\"])\n",
        "xlslists"
      ],
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['https://www.city.kodaira.tokyo.jp/kurashi/files/76067/076067/att_0000001.xlsx',\n",
              " 'https://www.city.kodaira.tokyo.jp/kurashi/files/76068/076068/att_0000001.xlsx',\n",
              " 'https://www.city.kodaira.tokyo.jp/kurashi/files/76069/076069/att_0000001.xlsx',\n",
              " 'https://www.city.kodaira.tokyo.jp/kurashi/files/76070/076070/att_0000001.xlsx',\n",
              " 'https://www.city.kodaira.tokyo.jp/kurashi/files/76071/076071/att_0000001.xlsx',\n",
              " 'https://www.city.kodaira.tokyo.jp/kurashi/files/76072/076072/att_0000001.xlsx',\n",
              " 'https://www.city.kodaira.tokyo.jp/kurashi/files/76073/076073/att_0000001.xlsx',\n",
              " 'https://www.city.kodaira.tokyo.jp/kurashi/files/76074/076074/att_0000001.xlsx',\n",
              " 'https://www.city.kodaira.tokyo.jp/kurashi/files/76075/076075/att_0000001.xlsx',\n",
              " 'https://www.city.kodaira.tokyo.jp/kurashi/files/76076/076076/att_0000001.xlsx',\n",
              " 'https://www.city.kodaira.tokyo.jp/kurashi/files/76077/076077/att_0000001.xlsx',\n",
              " 'https://www.city.kodaira.tokyo.jp/kurashi/files/76078/076078/att_0000001.xlsx']"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "39DuzojDeTIN",
        "colab_type": "code",
        "outputId": "85eee291-cadf-43c5-fd12-b737ae0c9b62",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "!pip install xlrd"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Requirement already satisfied: xlrd in /usr/local/lib/python3.6/dist-packages (1.1.0)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xbrqbA6X-BEL",
        "colab_type": "code",
        "outputId": "d930b9db-c8d9-4d32-d0b2-abd616454ceb",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 210
        }
      },
      "source": [
        "!wget https://www.city.kodaira.tokyo.jp/kurashi/files/76078/076078/att_0000001.xlsx"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "--2019-11-19 10:30:27--  https://www.city.kodaira.tokyo.jp/kurashi/files/76078/076078/att_0000001.xlsx\n",
            "Resolving www.city.kodaira.tokyo.jp (www.city.kodaira.tokyo.jp)... 210.140.79.20\n",
            "Connecting to www.city.kodaira.tokyo.jp (www.city.kodaira.tokyo.jp)|210.140.79.20|:443... connected.\n",
            "HTTP request sent, awaiting response... 200 OK\n",
            "Length: 106970 (104K) [application/vnd.openxmlformats-officedocument.spreadsheetml.sheet]\n",
            "Saving to: ‘att_0000001.xlsx’\n",
            "\n",
            "\ratt_0000001.xlsx      0%[                    ]       0  --.-KB/s               \ratt_0000001.xlsx    100%[===================>] 104.46K  --.-KB/s    in 0.1s    \n",
            "\n",
            "2019-11-19 10:30:27 (875 KB/s) - ‘att_0000001.xlsx’ saved [106970/106970]\n",
            "\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "d8srk83P-JRK",
        "colab_type": "code",
        "outputId": "0644deb7-aa42-4cf2-bcb2-202650e0cb1a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "import pandas as pd\n",
        "\n",
        "xls=pd.read_excel('att_0000001.xlsx',sheet_name=None,header=None)\n",
        "xls['P228.229']"
      ],
      "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>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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>198．図書館の分類別所蔵</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>資料数・貸出資料数</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\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>NaN</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>NaN</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>平成29年度</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>分　　　類</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>一　　　　　　　般　　　　　　　書</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>NaN</td>\n",
              "      <td>児　　　　　　　童　　　　　　　書</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>所 蔵 資 料 数</td>\n",
              "      <td>NaN</td>\n",
              "      <td>構　 成　 比</td>\n",
              "      <td>NaN</td>\n",
              "      <td>貸出資料数</td>\n",
              "      <td>NaN</td>\n",
              "      <td>構　 成　 比</td>\n",
              "      <td>NaN</td>\n",
              "      <td>所 蔵 資 料 数</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>構　 成　 比</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>貸 出 資 料 数</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>構　 成　 比</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>総　　　　　数</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>887,785</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1,044,964</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>352366</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>472934</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\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>NaN</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>NaN</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>総　 　記　 　類</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>25,984</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.9</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15,573</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.5</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6188</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2344</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.5</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>哲学・宗教等</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>35,242</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>42,136</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2063</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2253</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.5</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>歴史・地理学</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>73,658</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8.3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>92,701</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8.9</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12325</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.5</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6250</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.3</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>社会・教育</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>126,146</td>\n",
              "      <td>NaN</td>\n",
              "      <td>14.2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>81,873</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13498</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9661</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>自然科学</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>47,872</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>57,934</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.5</td>\n",
              "      <td>NaN</td>\n",
              "      <td>27710</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.9</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22551</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.8</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>工業・家事</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>67,515</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>117,304</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11.2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7782</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9297</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>産　  　　　　業</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>26,226</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>25,058</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7312</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9510</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>芸術・スポーツ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>70,717</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>60,333</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12262</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.5</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15741</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.3</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>語　 　　　　学</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13,595</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.5</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12,584</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2191</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1764</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.4</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>文　　   　　学</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>273,128</td>\n",
              "      <td>NaN</td>\n",
              "      <td>30.8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>410,539</td>\n",
              "      <td>NaN</td>\n",
              "      <td>39.3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>125517</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>35.6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>107854</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>22.8</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>地 域 行 政 資 料</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>68,793</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.7</td>\n",
              "      <td>NaN</td>\n",
              "      <td>10,430</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>雑　　　　  　誌</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>32,006</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>95,839</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>視 聴 覚 資 料</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18,227</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>16,434</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>絵　　  　　　本</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>131890</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>37.4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>277327</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>58.6</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>紙　 　芝　 　居</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>―</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2911</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7999</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.7</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>そ　 　の　 　他</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8,676</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6,226</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>717</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>383</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\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>NaN</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>NaN</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>資料：図書館事業概要、中央図書館</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\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>NaN</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>NaN</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\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>NaN</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>NaN</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\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>NaN</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>NaN</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>199．図 書 館 別 貸</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>出 資 料 数 推 移</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\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>NaN</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>NaN</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>年　度</td>\n",
              "      <td>総　　　数</td>\n",
              "      <td>NaN</td>\n",
              "      <td>中　　　央</td>\n",
              "      <td>NaN</td>\n",
              "      <td>地　　　   　　   　　区</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>NaN</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>分　　　　　　室</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>その他</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\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>NaN</td>\n",
              "      <td>花 小 金 井</td>\n",
              "      <td>NaN</td>\n",
              "      <td>小 川 西 町</td>\n",
              "      <td>NaN</td>\n",
              "      <td>喜　　　　平</td>\n",
              "      <td>NaN</td>\n",
              "      <td>上　　　　宿</td>\n",
              "      <td>NaN</td>\n",
              "      <td>津　　　　田</td>\n",
              "      <td>NaN</td>\n",
              "      <td>大　　　　沼</td>\n",
              "      <td>NaN</td>\n",
              "      <td>花小金井北</td>\n",
              "      <td>小  川</td>\n",
              "      <td>上水南</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>NaN</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>31</th>\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>NaN</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>NaN</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>平成25年</td>\n",
              "      <td>1509053</td>\n",
              "      <td>5186</td>\n",
              "      <td>466350</td>\n",
              "      <td>1603</td>\n",
              "      <td>4,644</td>\n",
              "      <td>16</td>\n",
              "      <td>249112</td>\n",
              "      <td>856</td>\n",
              "      <td>145206</td>\n",
              "      <td>499</td>\n",
              "      <td>205763</td>\n",
              "      <td>707</td>\n",
              "      <td>113751</td>\n",
              "      <td>391</td>\n",
              "      <td>145476</td>\n",
              "      <td>500</td>\n",
              "      <td>148602</td>\n",
              "      <td>511</td>\n",
              "      <td>5811</td>\n",
              "      <td>14670</td>\n",
              "      <td>9668</td>\n",
              "      <td>－</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>26</td>\n",
              "      <td>1486861</td>\n",
              "      <td>5109</td>\n",
              "      <td>431518</td>\n",
              "      <td>1483</td>\n",
              "      <td>14,892</td>\n",
              "      <td>51</td>\n",
              "      <td>231838</td>\n",
              "      <td>797</td>\n",
              "      <td>133642</td>\n",
              "      <td>459</td>\n",
              "      <td>186745</td>\n",
              "      <td>642</td>\n",
              "      <td>105042</td>\n",
              "      <td>361</td>\n",
              "      <td>132357</td>\n",
              "      <td>455</td>\n",
              "      <td>138275</td>\n",
              "      <td>475</td>\n",
              "      <td>4955</td>\n",
              "      <td>14304</td>\n",
              "      <td>7915</td>\n",
              "      <td>85378</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>27</td>\n",
              "      <td>1573185</td>\n",
              "      <td>5337</td>\n",
              "      <td>398764</td>\n",
              "      <td>1366</td>\n",
              "      <td>129631</td>\n",
              "      <td>439</td>\n",
              "      <td>236263</td>\n",
              "      <td>809</td>\n",
              "      <td>138428</td>\n",
              "      <td>474</td>\n",
              "      <td>183216</td>\n",
              "      <td>627</td>\n",
              "      <td>108044</td>\n",
              "      <td>370</td>\n",
              "      <td>129425</td>\n",
              "      <td>443</td>\n",
              "      <td>125688</td>\n",
              "      <td>430</td>\n",
              "      <td>5904</td>\n",
              "      <td>14614</td>\n",
              "      <td>8305</td>\n",
              "      <td>94903</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>28</td>\n",
              "      <td>1545789</td>\n",
              "      <td>5278</td>\n",
              "      <td>388595</td>\n",
              "      <td>1340</td>\n",
              "      <td>121628</td>\n",
              "      <td>417</td>\n",
              "      <td>234154</td>\n",
              "      <td>807</td>\n",
              "      <td>133656</td>\n",
              "      <td>461</td>\n",
              "      <td>179027</td>\n",
              "      <td>617</td>\n",
              "      <td>107489</td>\n",
              "      <td>371</td>\n",
              "      <td>127735</td>\n",
              "      <td>440</td>\n",
              "      <td>122830</td>\n",
              "      <td>424</td>\n",
              "      <td>8470</td>\n",
              "      <td>13128</td>\n",
              "      <td>9576</td>\n",
              "      <td>99501</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>29</td>\n",
              "      <td>1517898</td>\n",
              "      <td>5158</td>\n",
              "      <td>366732</td>\n",
              "      <td>1260</td>\n",
              "      <td>128123</td>\n",
              "      <td>437</td>\n",
              "      <td>233042</td>\n",
              "      <td>801</td>\n",
              "      <td>131078</td>\n",
              "      <td>450</td>\n",
              "      <td>177230</td>\n",
              "      <td>609</td>\n",
              "      <td>102309</td>\n",
              "      <td>352</td>\n",
              "      <td>124075</td>\n",
              "      <td>426</td>\n",
              "      <td>121228</td>\n",
              "      <td>417</td>\n",
              "      <td>7522</td>\n",
              "      <td>11227</td>\n",
              "      <td>10604</td>\n",
              "      <td>104728</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\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>NaN</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>NaN</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\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>NaN</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>NaN</td>\n",
              "      <td>（注）特別貸出分・団体貸出分を含む。</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\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>NaN</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>NaN</td>\n",
              "      <td>仲町図書館は、平成24年２月から休館以降、仲町公民館で貸出を実施。</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\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>NaN</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>NaN</td>\n",
              "      <td>平成27年３月開館。</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\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>NaN</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>NaN</td>\n",
              "      <td>「その他」は館内OPAC、図書館ホームページで利用期限延長があった</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\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>NaN</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>NaN</td>\n",
              "      <td>件数。平成26年度より集計。</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\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>NaN</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>NaN</td>\n",
              "      <td>資料：図書館事業概要、中央図書館</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                     0        1     2   ...       20          21                22\n",
              "0   198．図書館の分類別所蔵            NaN   NaN  ...      NaN         NaN               NaN\n",
              "1                   NaN      NaN   NaN  ...      NaN         NaN            平成29年度\n",
              "2                 分　　　類      NaN   NaN  ...      NaN         NaN               NaN\n",
              "3                   NaN      NaN   NaN  ...  構　 成　 比         NaN               NaN\n",
              "4               総　　　　　数      NaN   NaN  ...      NaN           1               NaN\n",
              "5                   NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "6             総　 　記　 　類      NaN   NaN  ...      NaN     　　　 0.5               NaN\n",
              "7                哲学・宗教等      NaN   NaN  ...      NaN         0.5               NaN\n",
              "8                歴史・地理学      NaN   NaN  ...      NaN         1.3               NaN\n",
              "9                 社会・教育      NaN   NaN  ...      NaN         2.0               NaN\n",
              "10                 自然科学      NaN   NaN  ...      NaN         4.8               NaN\n",
              "11                工業・家事      NaN   NaN  ...      NaN         2.0               NaN\n",
              "12            産　  　　　　業      NaN   NaN  ...      NaN         2.0               NaN\n",
              "13              芸術・スポーツ      NaN   NaN  ...      NaN         3.3               NaN\n",
              "14             語　 　　　　学      NaN   NaN  ...      NaN         0.4               NaN\n",
              "15            文　　   　　学      NaN   NaN  ...      NaN        22.8               NaN\n",
              "16          地 域 行 政 資 料      NaN   NaN  ...      NaN           ―               NaN\n",
              "17            雑　　　　  　誌      NaN   NaN  ...      NaN           ―               NaN\n",
              "18            視 聴 覚 資 料      NaN   NaN  ...      NaN           ―               NaN\n",
              "19            絵　　  　　　本      NaN   NaN  ...      NaN        58.6               NaN\n",
              "20            紙　 　芝　 　居      NaN   NaN  ...      NaN         1.7               NaN\n",
              "21            そ　 　の　 　他      NaN   NaN  ...      NaN         0.1               NaN\n",
              "22                  NaN      NaN   NaN  ...      NaN         NaN  資料：図書館事業概要、中央図書館\n",
              "23                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "24                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "25                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "26  199．図 書 館 別 貸            NaN   NaN  ...      NaN         NaN               NaN\n",
              "27                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "28                  年　度    総　　　数   NaN  ...      NaN         NaN               その他\n",
              "29                  NaN      NaN   NaN  ...     小  川         上水南               NaN\n",
              "30                  NaN    貸出資料数  １日平均  ...    貸出資料数       貸出資料数             貸出資料数\n",
              "31                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "32                平成25年  1509053  5186  ...    14670        9668                 －\n",
              "33                   26  1486861  5109  ...    14304        7915             85378\n",
              "34                   27  1573185  5337  ...    14614        8305             94903\n",
              "35                   28  1545789  5278  ...    13128        9576             99501\n",
              "36                   29  1517898  5158  ...    11227       10604            104728\n",
              "37                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "38                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "39                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "40                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "41                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "42                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "43                  NaN      NaN   NaN  ...      NaN         NaN               NaN\n",
              "\n",
              "[44 rows x 23 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "cFCUZGQQAnYq",
        "colab_type": "text"
      },
      "source": [
        "\n",
        "\n",
        "```\n",
        "# ダウンロード（読み込み + ローカル保存）\n",
        "# ダウンロードして rss.xml というファイル名で保存する例\n",
        "import requests\n",
        " \n",
        "url = 'https://it-engineer-lab.com/feed'\n",
        "try:\n",
        "    r = requests.get(url)\n",
        "    with open('rss.xml', mode='w') as f:\n",
        "        f.write(r.text)\n",
        "except requests.exceptions.RequestException as err:\n",
        "    print(err)\n",
        "```\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "QGcDpN-fFFzP",
        "colab_type": "code",
        "outputId": "6aba9c47-b0ce-4d26-88f5-01edee2ce0f5",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 255
        }
      },
      "source": [
        "xls['P202.203'].loc[2]"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0                 年　度\n",
              "1              総　　　　額\n",
              "2              市　　　　税\n",
              "3               地方譲与税\n",
              "4              利子割交付金\n",
              "5              配当割交付金\n",
              "6             株式等譲渡所得\n",
              "7      地方消費税\\n交  付  金\n",
              "8              ゴルフ場利用\n",
              "9     自動車取得税\\n交  付  金\n",
              "10            地方特例交付金\n",
              "11          地 方 交 付 税\n",
              "12             交通安全対策\n",
              "Name: 2, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 170
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tyuqRbgFGenH",
        "colab_type": "code",
        "outputId": "66c03860-a910-4f47-ef72-9d4ff1c8c615",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 255
        }
      },
      "source": [
        "xls['P202.203'].iloc[2]"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0                 年　度\n",
              "1              総　　　　額\n",
              "2              市　　　　税\n",
              "3               地方譲与税\n",
              "4              利子割交付金\n",
              "5              配当割交付金\n",
              "6             株式等譲渡所得\n",
              "7      地方消費税\\n交  付  金\n",
              "8              ゴルフ場利用\n",
              "9     自動車取得税\\n交  付  金\n",
              "10            地方特例交付金\n",
              "11          地 方 交 付 税\n",
              "12             交通安全対策\n",
              "Name: 2, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 171
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_OYnGiycG08N",
        "colab_type": "code",
        "outputId": "71fdc87e-13d9-4629-f576-35f6275cca49",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 173
        }
      },
      "source": [
        "xls['P202.203'].describe()"
      ],
      "execution_count": 0,
      "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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>23</td>\n",
              "      <td>22</td>\n",
              "      <td>22</td>\n",
              "      <td>22</td>\n",
              "      <td>22</td>\n",
              "      <td>22</td>\n",
              "      <td>23</td>\n",
              "      <td>23</td>\n",
              "      <td>23</td>\n",
              "      <td>22</td>\n",
              "      <td>22</td>\n",
              "      <td>24</td>\n",
              "      <td>13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>unique</th>\n",
              "      <td>12</td>\n",
              "      <td>22</td>\n",
              "      <td>22</td>\n",
              "      <td>22</td>\n",
              "      <td>22</td>\n",
              "      <td>22</td>\n",
              "      <td>23</td>\n",
              "      <td>23</td>\n",
              "      <td>23</td>\n",
              "      <td>22</td>\n",
              "      <td>22</td>\n",
              "      <td>15</td>\n",
              "      <td>13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>top</th>\n",
              "      <td>26</td>\n",
              "      <td>498591</td>\n",
              "      <td>30728110</td>\n",
              "      <td>257214</td>\n",
              "      <td>259086</td>\n",
              "      <td>71069</td>\n",
              "      <td>23201</td>\n",
              "      <td>4165535</td>\n",
              "      <td>16607</td>\n",
              "      <td>450303</td>\n",
              "      <td>2300328</td>\n",
              "      <td>―</td>\n",
              "      <td>24413</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>freq</th>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>10</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          0       1         2       3   ...      9        10  11     12\n",
              "count     23      22        22      22  ...      22       22  24     13\n",
              "unique    12      22        22      22  ...      22       22  15     13\n",
              "top       26  498591  30728110  257214  ...  450303  2300328   ―  24413\n",
              "freq       2       1         1       1  ...       1        1  10      1\n",
              "\n",
              "[4 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 172
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pC3hlQkvHJ_0",
        "colab_type": "code",
        "outputId": "751786a1-f3f8-4ee0-b49b-869f8703c647",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 171
        }
      },
      "source": [
        "xls['P202.203'][2:16]"
      ],
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "error",
          "ename": "KeyError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-15-dfccc650841a>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mxls\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'P202.203'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m2\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;36m16\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;31mKeyError\u001b[0m: 'P202.203'"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YWGzbmj_Hv6O",
        "colab_type": "code",
        "outputId": "d2dc22c6-adca-4b31-b69a-0a2436cfdb73",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 979
        }
      },
      "source": [
        "xls['P201']"
      ],
      "execution_count": 0,
      "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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>１．財    政</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>182．各会計別歳入歳出決算額</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\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>（単位：円）</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>年　度</td>\n",
              "      <td>一  般  会  計</td>\n",
              "      <td>NaN</td>\n",
              "      <td>国民健康保険事業</td>\n",
              "      <td>NaN</td>\n",
              "      <td>下水道事業特別会計</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>特  別  会  計</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>NaN</td>\n",
              "      <td>歳入決算額</td>\n",
              "      <td>歳出決算額</td>\n",
              "      <td>歳入決算額</td>\n",
              "      <td>歳出決算額</td>\n",
              "      <td>歳入決算額</td>\n",
              "      <td>歳出決算額</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>平成24年</td>\n",
              "      <td>61987261100</td>\n",
              "      <td>59628682373</td>\n",
              "      <td>17857545525</td>\n",
              "      <td>17313102505</td>\n",
              "      <td>4304837872</td>\n",
              "      <td>4077160899</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>25</td>\n",
              "      <td>60636386303</td>\n",
              "      <td>57757638582</td>\n",
              "      <td>18134133144</td>\n",
              "      <td>17879799036</td>\n",
              "      <td>4135408533</td>\n",
              "      <td>3945223569</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>26</td>\n",
              "      <td>61397274275</td>\n",
              "      <td>60139563173</td>\n",
              "      <td>17861383451</td>\n",
              "      <td>17585016298</td>\n",
              "      <td>3933696113</td>\n",
              "      <td>3802960901</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>27</td>\n",
              "      <td>62732331242</td>\n",
              "      <td>61550329738</td>\n",
              "      <td>20617918782</td>\n",
              "      <td>20351794190</td>\n",
              "      <td>3946566481</td>\n",
              "      <td>3662405978</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>28</td>\n",
              "      <td>63172869503</td>\n",
              "      <td>61529884883</td>\n",
              "      <td>20397702765</td>\n",
              "      <td>20160656517</td>\n",
              "      <td>4336650375</td>\n",
              "      <td>4083571020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>29</td>\n",
              "      <td>64143675556</td>\n",
              "      <td>62596977009</td>\n",
              "      <td>19844149798</td>\n",
              "      <td>19482001276</td>\n",
              "      <td>4317077005</td>\n",
              "      <td>4133462067</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>年　度</td>\n",
              "      <td>後期高齢者医療特別会計</td>\n",
              "      <td>NaN</td>\n",
              "      <td>介護保険事業特別会計</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>NaN</td>\n",
              "      <td>歳入決算額</td>\n",
              "      <td>歳出決算額</td>\n",
              "      <td>歳入決算額</td>\n",
              "      <td>歳出決算額</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>平成24年</td>\n",
              "      <td>3463145090</td>\n",
              "      <td>3395287547</td>\n",
              "      <td>10245106124</td>\n",
              "      <td>10000684899</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>25</td>\n",
              "      <td>3513932427</td>\n",
              "      <td>3468874582</td>\n",
              "      <td>10982285040</td>\n",
              "      <td>10800553313</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>26</td>\n",
              "      <td>3780167549</td>\n",
              "      <td>3730480095</td>\n",
              "      <td>11424311483</td>\n",
              "      <td>11259032009</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>27</td>\n",
              "      <td>3830655414</td>\n",
              "      <td>3790719873</td>\n",
              "      <td>11817082658</td>\n",
              "      <td>11645358557</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>28</td>\n",
              "      <td>3988497550</td>\n",
              "      <td>3939958911</td>\n",
              "      <td>12135080590</td>\n",
              "      <td>11860985474</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>29</td>\n",
              "      <td>4074533207</td>\n",
              "      <td>4041163314</td>\n",
              "      <td>12675155253</td>\n",
              "      <td>12536921064</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>資料：各会計決算書</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "           0                1            2  ...           6   7    8\n",
              "0   １．財    政              NaN          NaN  ...         NaN NaN  NaN\n",
              "1        NaN              NaN          NaN  ...         NaN NaN  NaN\n",
              "2        NaN              NaN          NaN  ...         NaN NaN  NaN\n",
              "3        NaN  182．各会計別歳入歳出決算額          NaN  ...         NaN NaN  NaN\n",
              "4        NaN              NaN          NaN  ...      （単位：円） NaN  NaN\n",
              "5        年　度       一  般  会  計          NaN  ...         NaN NaN  NaN\n",
              "6        NaN              NaN          NaN  ...         NaN NaN  NaN\n",
              "7        NaN            歳入決算額        歳出決算額  ...       歳出決算額 NaN  NaN\n",
              "8        NaN              NaN          NaN  ...         NaN NaN  NaN\n",
              "9      平成24年      61987261100  59628682373  ...  4077160899 NaN  NaN\n",
              "10        25      60636386303  57757638582  ...  3945223569 NaN  NaN\n",
              "11        26      61397274275  60139563173  ...  3802960901 NaN  NaN\n",
              "12        27      62732331242  61550329738  ...  3662405978 NaN  NaN\n",
              "13        28      63172869503  61529884883  ...  4083571020 NaN  NaN\n",
              "14        29      64143675556  62596977009  ...  4133462067 NaN  NaN\n",
              "15       NaN              NaN          NaN  ...         NaN NaN     \n",
              "16       NaN              NaN          NaN  ...         NaN NaN  NaN\n",
              "17       NaN              NaN          NaN  ...         NaN NaN  NaN\n",
              "18       NaN              NaN          NaN  ...         NaN NaN  NaN\n",
              "19       年　度      後期高齢者医療特別会計          NaN  ...         NaN NaN  NaN\n",
              "20       NaN            歳入決算額        歳出決算額  ...         NaN NaN  NaN\n",
              "21       NaN              NaN          NaN  ...         NaN NaN  NaN\n",
              "22     平成24年       3463145090   3395287547  ...         NaN NaN  NaN\n",
              "23        25       3513932427   3468874582  ...         NaN NaN  NaN\n",
              "24        26       3780167549   3730480095  ...         NaN NaN  NaN\n",
              "25        27       3830655414   3790719873  ...         NaN NaN  NaN\n",
              "26        28       3988497550   3939958911  ...         NaN NaN  NaN\n",
              "27        29       4074533207   4041163314  ...         NaN NaN  NaN\n",
              "28       NaN              NaN          NaN  ...         NaN NaN  NaN\n",
              "29       NaN              NaN          NaN  ...         NaN NaN  NaN\n",
              "\n",
              "[30 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 177
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gueJfCv-NJn2",
        "colab_type": "code",
        "outputId": "7f294426-5479-4c9e-e9c6-91834962634f",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 210
        }
      },
      "source": [
        "!wget https://www.city.kodaira.tokyo.jp/kurashi/files/76068/076068/att_0000001.xlsx"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "--2019-11-19 10:31:19--  https://www.city.kodaira.tokyo.jp/kurashi/files/76068/076068/att_0000001.xlsx\n",
            "Resolving www.city.kodaira.tokyo.jp (www.city.kodaira.tokyo.jp)... 210.140.79.20\n",
            "Connecting to www.city.kodaira.tokyo.jp (www.city.kodaira.tokyo.jp)|210.140.79.20|:443... connected.\n",
            "HTTP request sent, awaiting response... 200 OK\n",
            "Length: 90639 (89K) [application/vnd.openxmlformats-officedocument.spreadsheetml.sheet]\n",
            "Saving to: ‘att_0000001.xlsx.1’\n",
            "\n",
            "\ratt_0000001.xlsx.1    0%[                    ]       0  --.-KB/s               \ratt_0000001.xlsx.1  100%[===================>]  88.51K  --.-KB/s    in 0.08s   \n",
            "\n",
            "2019-11-19 10:31:19 (1.13 MB/s) - ‘att_0000001.xlsx.1’ saved [90639/90639]\n",
            "\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "GMSU1uBoNWeS",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "xls=pd.read_excel('att_0000001.xlsx.1',sheet_name=None,header=None)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "j9n0At3sNaOU",
        "colab_type": "code",
        "outputId": "addf2bde-5bb5-46a1-c0cd-69aee31bf3a8",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "xls"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "OrderedDict([('P13',\n",
              "                                                0       1  ...     6          7\n",
              "              0                         １．人　　　　　口     NaN  ...   NaN        NaN\n",
              "              1                               NaN     NaN  ...   NaN        NaN\n",
              "              2           ８．住 民 基 本 台 帳 人 口 の 推 移     NaN  ...   NaN        NaN\n",
              "              3                               NaN     NaN  ...   NaN     各年１月１日\n",
              "              4                             年　　　次   総　　　数  ...  1世帯当      人口増加率\n",
              "              5                               NaN     NaN  ...  たり人口        （％）\n",
              "              6                               NaN     NaN  ...   NaN        NaN\n",
              "              7                              平成２年  157446  ...  2.57        0.9\n",
              "              8                                 ３  159182  ...  2.54        1.1\n",
              "              9                                 ４  161463  ...   2.5        1.4\n",
              "              10                                ５  163603  ...  2.47        1.3\n",
              "              11                                ６  164264  ...  2.46        0.4\n",
              "              12                                ７  165177  ...  2.45        0.6\n",
              "              13                                ８  167045  ...  2.43        1.1\n",
              "              14                                ９  168408  ...  2.42        0.8\n",
              "              15                               10  168714  ...   2.4        0.2\n",
              "              16                               11  171021  ...  2.38        1.4\n",
              "              17                              NaN     NaN  ...   NaN        NaN\n",
              "              18                               12  171914  ...  2.36        0.5\n",
              "              19                               13  172782  ...  2.34        0.5\n",
              "              20                               14  174333  ...  2.32        0.9\n",
              "              21                               15  175599  ...  2.31        0.7\n",
              "              22                               16  175879  ...  2.29        0.2\n",
              "              23                               17  176486  ...  2.28        0.3\n",
              "              24                               18  176773  ...  2.26        0.2\n",
              "              25                               19  177532  ...  2.25        0.4\n",
              "              26                               20  178654  ...  2.23        0.6\n",
              "              27                               21  179269  ...  2.21     　　　0.3\n",
              "              28                              NaN     NaN  ...   NaN        NaN\n",
              "              29                               22  179717  ...   2.2        0.2\n",
              "              30                               23  179728  ...   2.2        0.0\n",
              "              31                               24  180314  ...  2.19        0.3\n",
              "              32                               25  185677  ...  2.17        2.9\n",
              "              33                               26  186339  ...  2.17        0.4\n",
              "              34                               27  186958  ...  2.16        0.3\n",
              "              35                               28  188609  ...  2.14        0.9\n",
              "              36                               29  189885  ...  2.13        0.7\n",
              "              37                               30  191308  ...  2.12        0.7\n",
              "              38                               31  193596  ...  2.11        1.2\n",
              "              39                              NaN     NaN  ...   NaN        NaN\n",
              "              40                              NaN     NaN  ...   NaN        NaN\n",
              "              41                              NaN     NaN  ...   NaN        NaN\n",
              "              42                              NaN     NaN  ...   NaN        NaN\n",
              "              \n",
              "              [43 rows x 8 columns]),\n",
              "             ('P14.15',\n",
              "                                0       1      2      3   ...    10     11         12           13\n",
              "              0   ９．町　　　丁　　　別          NaN    NaN    NaN  ...   NaN    NaN        NaN          NaN\n",
              "              1                NaN     NaN    NaN    NaN  ...   NaN    NaN  平成31年１月１日          NaN\n",
              "              2             町　　　　丁    人口総数      男      女  ...     女  世 帯 数    人 口 密 度       1世帯当たり\n",
              "              3                NaN     NaN    NaN    NaN  ...   NaN    NaN      人 ／ ㎢         人　　口\n",
              "              4                NaN     NaN    NaN    NaN  ...   NaN    NaN        NaN          NaN\n",
              "              5                 総数  193596  95312  98284  ...   NaN    NaN        NaN          NaN\n",
              "              6                NaN     NaN    NaN    NaN  ...   NaN    NaN        NaN          NaN\n",
              "              7                中島町    1861    916    945  ...  2305   2627      13040         1.74\n",
              "              8            上水新町１丁目    1518    741    777  ...  1948   1985      15152         1.91\n",
              "              9            上水新町２丁目    1567    740    827  ...  1199   1149      12547         2.07\n",
              "              10           上水新町３丁目    1545    752    793  ...  1200    990      12572         2.29\n",
              "              11              たかの台    2011    976   1035  ...  1642   1679      15785         1.88\n",
              "              12               NaN     NaN    NaN    NaN  ...   NaN    NaN        NaN          NaN\n",
              "              13            小川町１丁目   18641   9293   9348  ...  1342   1392      12291         1.94\n",
              "              14            小川町２丁目    5621   2872   2749  ...   889   1017      11863         1.87\n",
              "              15             栄町１丁目     710    362    348  ...  4560   4402      10160         2.05\n",
              "              16             栄町２丁目    1719    906    813  ...  1416   1473      18800         1.79\n",
              "              17             栄町３丁目     894    438    456  ...   669    777      13230          1.7\n",
              "              18               NaN     NaN    NaN    NaN  ...   NaN    NaN        NaN          NaN\n",
              "              19           小川西町１丁目    1153    540    613  ...   788    820       4081         1.84\n",
              "              20           小川西町２丁目    1662    806    856  ...  2572   2096       9798         2.48\n",
              "              21           小川西町３丁目    1156    584    572  ...  1317   1175       4647         2.29\n",
              "              22           小川西町４丁目    1573    753    820  ...  4891   4056      11425         2.39\n",
              "              23           小川西町５丁目    2740   1305   1435  ...  3380   3002      12330         2.22\n",
              "              24               NaN     NaN    NaN    NaN  ...   NaN    NaN        NaN          NaN\n",
              "              25              小川東町    1543    743    800  ...  1290   1019      15694         2.46\n",
              "              26           小川東町１丁目    3045   1539   1506  ...   774    776       9988         2.06\n",
              "              27           小川東町２丁目    1237    548    689  ...   180    141       3700         2.36\n",
              "              28           小川東町３丁目    1066    597    469  ...  1088    907      10105         2.34\n",
              "              29           小川東町４丁目    1165    522    643  ...   838    735      12454          2.2\n",
              "              30               NaN     NaN    NaN    NaN  ...   NaN    NaN        NaN          NaN\n",
              "              31           小川東町５丁目    2835   1421   1414  ...   996    868       8346         2.31\n",
              "              32           上水本町１丁目    1555    741    814  ...   369    301       4388         2.48\n",
              "              33           上水本町２丁目    1028    484    544  ...   950    853       9395         2.31\n",
              "              34           上水本町３丁目    1167    583    584  ...   267    197       3779         2.69\n",
              "              35           上水本町４丁目    1438    728    710  ...   323    240       4831         2.62\n",
              "              36               NaN     NaN    NaN    NaN  ...   NaN    NaN        NaN          NaN\n",
              "              37           上水本町５丁目    3472   1714   1758  ...  1424   1086      16620          2.3\n",
              "              38           上水本町６丁目    2456   1208   1248  ...  2617   2473       9294         2.03\n",
              "              39           上水南町１丁目    2067    981   1086  ...  1106   1144      10785         1.89\n",
              "              40           上水南町２丁目    2472   1239   1233  ...  1545   1401       8731         2.24\n",
              "              41           上水南町３丁目    2866   1411   1455  ...  2198   2040      13658         2.08\n",
              "              42               NaN     NaN    NaN    NaN  ...   NaN    NaN        NaN          NaN\n",
              "              43           上水南町４丁目    1044    540    504  ...  1393   1356      11842          2.1\n",
              "              44            喜平町1丁目    1752    869    883  ...  1320   1110       6238         2.25\n",
              "              45            喜平町２丁目    1241    691    550  ...  1300   1102      10713         2.33\n",
              "              46            喜平町３丁目    2766   1306   1460  ...  1623   1550      10665         2.13\n",
              "              47            津田町１丁目    1000    483    517  ...  1049   1105       8321         1.81\n",
              "              48               NaN     NaN    NaN    NaN  ...   NaN    NaN        NaN          NaN\n",
              "              49            津田町２丁目    1471    663    808  ...  1383   1152      17613         2.45\n",
              "              50            津田町３丁目    2532   1125   1407  ...   664    570       6419         2.36\n",
              "              51               NaN     NaN    NaN    NaN  ...   NaN    NaN        NaN          NaN\n",
              "              52               NaN     NaN    NaN    NaN  ...   NaN    NaN        NaN  資料：住民基本台帳人口\n",
              "              \n",
              "              [53 rows x 14 columns]),\n",
              "             ('P16.17',\n",
              "                                  0       1      2      3   ...      16     17     18           19\n",
              "              0   10．月　　別　　人　　口          NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "              1                  NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "              2                 年次及び    総　　数      男      女  ...    総　　数      男      女          世帯数\n",
              "              3                 月　　次     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "              4                  NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "              5                平成23年     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "              6                   １月  179728  89289  90439  ...  189885  93657  96228        88967\n",
              "              7                    ２  179687  89266  90421  ...  189975  93749  96226        88993\n",
              "              8                    ３  179519  89176  90343  ...  189782  93682  96100        88791\n",
              "              9                    ４  179412  89096  90316  ...  189955  93741  96214        89019\n",
              "              10                   ５  179703  89174  90529  ...  190847  94206  96641        89857\n",
              "              11                   ６  180012  89328  90684  ...  190954  94252  96702        89961\n",
              "              12                   ７  180049  89345  90704  ...  191067  94286  96781        90017\n",
              "              13                   ８  180037  89342  90695  ...  191278  94390  96888        90124\n",
              "              14                   ９  180063  89354  90709  ...  191136  94331  96805        89992\n",
              "              15                  10  180165  89402  90763  ...  191405  94489  96916        90233\n",
              "              16                  11  180117  89369  90748  ...  191496  94526  96970        90269\n",
              "              17                  12  180259  89442  90817  ...  191468  94528  96940        90233\n",
              "              18                 NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "              19                 NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "              20               平成24年     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "              21                  １月  180314  89449  90865  ...  191308  94397  96911        90166\n",
              "              22                   ２  180297  89429  90868  ...  191291  94360  96931        90124\n",
              "              23                   ３  180228  89398  90830  ...  191150  94307  96843        90015\n",
              "              24                   ４  180759  89654  91105  ...  191064  94174  96890        90047\n",
              "              25                   ５  181400  89894  91506  ...  192211  94728  97483        90952\n",
              "              26                   ６  181371  89881  91490  ...  192584  94884  97700        91177\n",
              "              27                   ７  181474  89928  91546  ...  192689  94937  97752        91214\n",
              "              28                   ８  185211  91725  93486  ...  192949  95084  97865        91270\n",
              "              29                   ９  185213  91736  93477  ...  192936  95069  97867        91165\n",
              "              30                  10  185279  91758  93521  ...  193191  95147  98044        91371\n",
              "              31                  11  185507  91872  93635  ...  193491  95291  98200        91590\n",
              "              32                  12  185665  91971  93694  ...  193612  95331  98281        91625\n",
              "              33                 NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "              34                 NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN  資料：住民基本台帳人口\n",
              "              \n",
              "              [35 rows x 20 columns]),\n",
              "             ('P18.19',\n",
              "                                  0    1            2   ...       26       27      28\n",
              "              0      11．　人　　　　口　      NaN          NaN  ...      NaN      NaN     NaN\n",
              "              1                  NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              2                 年　　次  NaN  年　　間\\n増 加 数  ...      NaN      NaN     NaN\n",
              "              3                  NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              4                  NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              5                平成20年  NaN          493  ...      NaN      NaN     NaN\n",
              "              6                   21  NaN          326  ...      NaN      NaN     NaN\n",
              "              7                   22  NaN        △ 106  ...      NaN      NaN     NaN\n",
              "              8                   23  NaN          487  ...      NaN      NaN     NaN\n",
              "              9                   24  NaN        1,425  ...      NaN      NaN     NaN\n",
              "              10                  25  NaN          806  ...      NaN      NaN     NaN\n",
              "              11                  26  NaN          678  ...      NaN      NaN     NaN\n",
              "              12                  27  NaN        1,716  ...      NaN      NaN     NaN\n",
              "              13                  28  NaN        1,323  ...      NaN      NaN     NaN\n",
              "              14                  29  NaN        1,401  ...      NaN      NaN     NaN\n",
              "              15                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              16                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              17                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              18                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              19                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              20                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              21                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              22                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              23  12．年　齢　（　5　歳　階　     NaN          NaN  ...      NaN      NaN     NaN\n",
              "              24                 NaN  NaN          NaN  ...      NaN      NaN  各年１月１日\n",
              "              25                年　　次  NaN         総　　数  ...  80 ～ 84  85 ～ 89   90歳 ～\n",
              "              26                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              27               27\\n年   総数       186958  ...     6420     3704    1864\n",
              "              28                 NaN    男        92231  ...     2683     1353     475\n",
              "              29                 NaN    女        94727  ...     3737     2351    1389\n",
              "              30                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              31                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              32               28\\n年   総数       188609  ...     6875     3934    2009\n",
              "              33                 NaN    男        93107  ...     2880     1414     531\n",
              "              34                 NaN    女        95502  ...     3995     2520    1478\n",
              "              35                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              36                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              37               29\\n年   総数       189885  ...     7103     4161    2113\n",
              "              38                 NaN    男        93657  ...     2935     1520     576\n",
              "              39                 NaN    女        96228  ...     4168     2641    1537\n",
              "              40                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              41                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              42               30\\n年   総数       191308  ...     7319     4410    2316\n",
              "              43                 NaN    男        94397  ...     3011     1617     624\n",
              "              44                 NaN    女        96911  ...     4308     2793    1692\n",
              "              45                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              46                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              47               31\\n年   総数       193596  ...     7275     4682    2520\n",
              "              48                 NaN    男        95312  ...     2982     1730     683\n",
              "              49                 NaN    女        98284  ...     4293     2952    1837\n",
              "              50                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              51                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              52                 NaN  NaN          NaN  ...      NaN      NaN     NaN\n",
              "              \n",
              "              [53 rows x 29 columns]),\n",
              "             ('P20.21',                            0   ...   21\n",
              "              0         　　　　　13．外 国 人 住 民 数  ...  NaN\n",
              "              1                         NaN  ...  NaN\n",
              "              2                        年　　次  ...  NaN\n",
              "              3                         NaN  ...  NaN\n",
              "              4                         NaN  ...  NaN\n",
              "              5                       平成22年  ...  NaN\n",
              "              6                          23  ...  NaN\n",
              "              7                          24  ...  NaN\n",
              "              8                          25  ...  NaN\n",
              "              9                          26  ...  NaN\n",
              "              10                         27  ...  NaN\n",
              "              11                         28  ...  NaN\n",
              "              12                         29  ...  NaN\n",
              "              13                         30  ...  NaN\n",
              "              14                         31  ...  NaN\n",
              "              15                        NaN  ...  NaN\n",
              "              16                        NaN  ...  NaN\n",
              "              17                        NaN  ...  NaN\n",
              "              18                        NaN  ...  NaN\n",
              "              19                        NaN  ...  NaN\n",
              "              20  　　　　　14．国 勢 調 査 人 口 の 推 移  ...  NaN\n",
              "              21                        NaN  ...  NaN\n",
              "              22                        NaN  ...  NaN\n",
              "              23                        年　次  ...  NaN\n",
              "              24                        NaN  ...  NaN\n",
              "              25                       大正９年  ...  NaN\n",
              "              26                         14  ...  NaN\n",
              "              27                       昭和５年  ...  NaN\n",
              "              28                         10  ...  NaN\n",
              "              29                         15  ...  NaN\n",
              "              30                         20  ...  NaN\n",
              "              31                         25  ...  NaN\n",
              "              32                         30  ...  NaN\n",
              "              33                         35  ...  NaN\n",
              "              34                         40  ...  NaN\n",
              "              35                         45  ...     \n",
              "              36                         50  ...  NaN\n",
              "              37                         55  ...  NaN\n",
              "              38                         60  ...  NaN\n",
              "              39                       平成２年  ...  NaN\n",
              "              40                          7  ...  NaN\n",
              "              41                         12  ...  NaN\n",
              "              42                         17  ...  NaN\n",
              "              43                         22  ...  NaN\n",
              "              44                         27  ...  NaN\n",
              "              45                        NaN  ...  NaN\n",
              "              46                        NaN  ...  NaN\n",
              "              \n",
              "              [47 rows x 22 columns]),\n",
              "             ('P22.23',\n",
              "                                              0        1      2   ...  21         22  23\n",
              "              0   　　　　16．他 区 市 町 村 か ら の 流 入 人 口      NaN    NaN  ... NaN        NaN NaN\n",
              "              1                              NaN      NaN    NaN  ... NaN        NaN NaN\n",
              "              2                      通　　　　勤　　　　者      NaN    NaN  ... NaN        NaN NaN\n",
              "              3                               順位    住 所 地  人　　　口  ... NaN     構成比（％） NaN\n",
              "              4                              NaN      NaN    NaN  ... NaN        NaN NaN\n",
              "              5                              NaN    総　　　数  29781  ... NaN        100 NaN\n",
              "              6                              NaN    東京都総数  22345  ... NaN    89.4219 NaN\n",
              "              7                              NaN   区　  　部   2837  ... NaN    35.8019 NaN\n",
              "              8                              NaN   市　  　部  19324  ... NaN    53.5426 NaN\n",
              "              9                              NaN  町  村  部    184  ... NaN  0.0773737 NaN\n",
              "              10                             NaN  他 県 総 数   7436  ... NaN    10.5781 NaN\n",
              "              11                             NaN      NaN    NaN  ... NaN        NaN NaN\n",
              "              12                               1  東 村 山 市   3663  ... NaN    9.38433 NaN\n",
              "              13                               2  東 大 和 市   2180  ... NaN    6.94153 NaN\n",
              "              14                               3  国 分 寺 市   1743  ... NaN    6.93047 NaN\n",
              "              15                               4    東久留米市   1554  ... NaN     6.1899 NaN\n",
              "              16                               5  西 東 京 市   1508  ... NaN    4.85244 NaN\n",
              "              17                               6    立　川　市   1369  ... NaN    4.64242 NaN\n",
              "              18                               7  小 金 井 市    959  ... NaN     4.0787 NaN\n",
              "              19                               8  八 王 子 市    776  ... NaN        3.7 NaN\n",
              "              20                               9    府　中　市    752  ... NaN     3.6034 NaN\n",
              "              21                              10    武蔵村山市    685  ... NaN        3.4 NaN\n",
              "              22                              11    練　馬　区    625  ... NaN    3.01757 NaN\n",
              "              23                              12    杉　並　区    535  ... NaN          3 NaN\n",
              "              24                              13    昭　島　市    516  ... NaN    2.70808 NaN\n",
              "              25                              14    日　野　市    405  ... NaN    2.64176 NaN\n",
              "              26                              15    青　梅　市    394  ... NaN    2.35437 NaN\n",
              "              27                              16  武 蔵 野 市    389  ... NaN    2.14436 NaN\n",
              "              28                              17    国　立　市    388  ... NaN     2.1333 NaN\n",
              "              29                              18    清　瀬　市    337  ... NaN    1.75749 NaN\n",
              "              30                              19    三　鷹　市    328  ... NaN    1.49221 NaN\n",
              "              31                              20    中　野　区    278  ... NaN    1.38167 NaN\n",
              "              32                              21    羽　村　市    275  ... NaN    1.32641 NaN\n",
              "              33                              22  世 田 谷 区    230  ... NaN    1.26009 NaN\n",
              "              34                              23    あきる野市    211  ... NaN    1.26009 NaN\n",
              "              35                              24    福　生　市    201  ... NaN    1.16061 NaN\n",
              "              36                              25    調　布　市    194  ... NaN    1.03902 NaN\n",
              "              37                              26    町　田　市    189  ... NaN   0.884271 NaN\n",
              "              38                              27    板　橋　区    139  ... NaN   0.784791 NaN\n",
              "              39                              28    稲　城　市    139  ... NaN   0.784791 NaN\n",
              "              40                              29    新　宿　区    128  ... NaN   0.630043 NaN\n",
              "              41                              30    多　摩　市    128  ... NaN   0.563723 NaN\n",
              "              42                             NaN      NaN    NaN  ... NaN        NaN NaN\n",
              "              43                             NaN      NaN    NaN  ... NaN        NaN NaN\n",
              "              44                             NaN      NaN    NaN  ... NaN        NaN NaN\n",
              "              \n",
              "              [45 rows x 24 columns]),\n",
              "             ('P24.25',\n",
              "                                     0      1       2   ...           13          14    15\n",
              "              0   18．町 丁 別 一 般 世 帯 数・　　    NaN     NaN  ...          NaN         NaN   NaN\n",
              "              1                     NaN    NaN     NaN  ...          NaN  平成27年10月１日   NaN\n",
              "              2                  町　　　　丁  一般世帯数  一般世帯人員  ...          NaN         NaN   NaN\n",
              "              3                     NaN    NaN     NaN  ...  夫婦と子供から成る世帯       ３世代世帯  単独世帯\n",
              "              4                      総数  82768  183966  ...           84          25   203\n",
              "              5                     NaN    NaN     NaN  ...          113          32   225\n",
              "              6                     中島町    845    1799  ...           74          24   128\n",
              "              7                 上水新町１丁目    607    1556  ...           73          16   102\n",
              "              8                 上水新町２丁目    640    1461  ...           71          25   175\n",
              "              9                 上水新町３丁目    696    1539  ...          NaN         NaN   NaN\n",
              "              10                   たかの台    977    2031  ...           60          22   161\n",
              "              11                    NaN    NaN     NaN  ...           34          17   105\n",
              "              12                 小川町１丁目   7615   16919  ...          249          98   417\n",
              "              13                 小川町２丁目   2618    5584  ...           63          25   186\n",
              "              14                  栄町１丁目    332     702  ...           22           8    50\n",
              "              15                  栄町２丁目    648    1658  ...          NaN         NaN   NaN\n",
              "              16                  栄町３丁目    375     875  ...           47          11    75\n",
              "              17                小川西町１丁目    471    1080  ...          118          29   131\n",
              "              18                小川西町２丁目    703    1621  ...           53          21    62\n",
              "              19                    NaN    NaN     NaN  ...          240          71   361\n",
              "              20                小川西町３丁目    587    1161  ...          121          49   235\n",
              "              21                小川西町４丁目    833    1544  ...          NaN         NaN   NaN\n",
              "              22                小川西町５丁目   1148    2691  ...           43          15    56\n",
              "              23                   小川東町    663    1570  ...           32          21    92\n",
              "              24                小川東町１丁目   1365    3021  ...            9           3    21\n",
              "              25                    NaN    NaN     NaN  ...           59          17    63\n",
              "              26                小川東町２丁目    594    1267  ...           32           9    77\n",
              "              27                小川東町３丁目    544    1183  ...          NaN         NaN   NaN\n",
              "              28                小川東町４丁目    819    1192  ...           51          21    67\n",
              "              29                小川東町５丁目   1202    2729  ...           17           9    12\n",
              "              30                上水本町１丁目    791    1709  ...           59          22    69\n",
              "              31                    NaN    NaN     NaN  ...           14           9     9\n",
              "              32                上水本町２丁目    510    1102  ...           10           5    14\n",
              "              33                上水本町３丁目    394    1015  ...          NaN         NaN   NaN\n",
              "              34                上水本町４丁目    655    1463  ...           51          28   206\n",
              "              35                上水本町５丁目   1347    3473  ...           51          15   135\n",
              "              36                上水本町６丁目    957    2443  ...           54          18   117\n",
              "              37                    NaN    NaN     NaN  ...           80          35   141\n",
              "              38                上水南町１丁目    795    1787  ...           51          20   128\n",
              "              39                上水南町２丁目   1074    2281  ...          NaN         NaN   NaN\n",
              "              40                上水南町３丁目   1147    2785  ...           58          20    97\n",
              "              41                上水南町４丁目    393     913  ...           52          32    71\n",
              "              42                 喜平町１丁目    740    1703  ...           56          18   121\n",
              "              43                    NaN    NaN     NaN  ...           98          31   165\n",
              "              44                 喜平町２丁目    484    1177  ...           41          22    90\n",
              "              45                 喜平町３丁目   1679    2970  ...          NaN         NaN   NaN\n",
              "              46                 津田町１丁目    501    1026  ...           45          15    58\n",
              "              47                 津田町２丁目    621    1380  ...           32           5    46\n",
              "              48                 津田町３丁目   1142    2554  ...          NaN         NaN   NaN\n",
              "              49                    NaN    NaN     NaN  ...  資料：国勢調査結果報告         NaN   NaN\n",
              "              \n",
              "              [50 rows x 16 columns]),\n",
              "             ('P26.27',\n",
              "                      0                 1   2   ...        24          25                26\n",
              "              0      NaN  19．年 齢 別 昼 間 人 口 NaN  ...       NaN         NaN               NaN\n",
              "              1      NaN               NaN NaN  ...       NaN   平成30年１月１日               NaN\n",
              "              2      年　齢           夜　間　人　口 NaN  ...       NaN         NaN               NaN\n",
              "              3      NaN               NaN NaN  ...  人　　　　　　口         NaN               NaN\n",
              "              4      NaN               NaN NaN  ...       NaN         NaN               NaN\n",
              "              5      NaN               NaN NaN  ...     総　　　数           男                 女\n",
              "              6      NaN               NaN NaN  ...       NaN         NaN               NaN\n",
              "              7      NaN               NaN NaN  ...  13637348     6720970           6916378\n",
              "              8     総　　数            188303 NaN  ...   9396595     4622881           4773714\n",
              "              9    15歳未満             24118 NaN  ...   4156737     2055543           2101194\n",
              "              10  15～19歳             10694 NaN  ...     57968       29181             28787\n",
              "              11   20～24             13205 NaN  ...     26048       13365             12683\n",
              "              12   25～29             10382 NaN  ...       NaN         NaN               NaN\n",
              "              13   30～34             11565 NaN  ...    563178      282095            281083\n",
              "              14   35～44             28027 NaN  ...    182658       90946             91712\n",
              "              15   45～54             27533 NaN  ...    144902       69494             75408\n",
              "              16   55～64             20640 NaN  ...    186375       91357             95018\n",
              "              17   65～74             21089 NaN  ...    135248       67954             67294\n",
              "              18   75歳以上             21050 NaN  ...    258654      130203            128451\n",
              "              19     NaN               NaN NaN  ...    113244       56424             56820\n",
              "              20     NaN               NaN NaN  ...    232473      113800            118673\n",
              "              21     NaN               NaN NaN  ...    428742      210268            218474\n",
              "              22     NaN               NaN NaN  ...    120268       59420             60848\n",
              "              23     NaN               NaN NaN  ...    191308       94397             96911\n",
              "              24     NaN               NaN NaN  ...    184667       92763             91904\n",
              "              25     NaN  20．昼 間 人 口 の 推 移 NaN  ...    151018       73823             77195\n",
              "              26     NaN               NaN NaN  ...    121673       60003             61670\n",
              "              27     NaN               NaN NaN  ...     75723       37035             38688\n",
              "              28     年　次  夜間人口\\n常住地に\\nよる人口 NaN  ...     58384       29164             29220\n",
              "              29     NaN               NaN NaN  ...     81788       39722             42066\n",
              "              30     NaN               NaN NaN  ...     85718       42253             43465\n",
              "              31     NaN               NaN NaN  ...     74845       36163             38682\n",
              "              32     NaN               NaN NaN  ...    116830       57093             59737\n",
              "              33    平成２年            162565 NaN  ...     72489       36090             36399\n",
              "              34       ７            172771 NaN  ...    148724       72800             75924\n",
              "              35      12            178597 NaN  ...     89915       45326             44589\n",
              "              36      17            183775 NaN  ...     55870       28363             27507\n",
              "              37      22            185500 NaN  ...     80985       40409             40576\n",
              "              38      27            188303 NaN  ...    201058       98178            102880\n",
              "              39     NaN               NaN NaN  ...       NaN         NaN               NaN\n",
              "              40     NaN               NaN NaN  ...       NaN  　資料：東京都総務局               NaN\n",
              "              41     NaN               NaN NaN  ...       NaN         NaN  （住民基本台帳による世帯と人口）\n",
              "              42     NaN               NaN NaN  ...       NaN         NaN               NaN\n",
              "              43     NaN               NaN NaN  ...       NaN         NaN               NaN\n",
              "              44     NaN               NaN NaN  ...       NaN         NaN               NaN\n",
              "              45     NaN               NaN NaN  ...       NaN         NaN               NaN\n",
              "              \n",
              "              [46 rows x 27 columns]),\n",
              "             ('P28',                0               1  ...        4        5\n",
              "              0            NaN  22．将 来 予 測 人 口  ...      NaN      NaN\n",
              "              1            NaN             NaN  ...      NaN      NaN\n",
              "              2           年　　齢          令和　2　年  ...    17  年    22  年\n",
              "              3        総　　　　　数          191443  ...   181991   175860\n",
              "              4      ０　～  14 歳           24707  ...    21003    20223\n",
              "              5          ０　～　４            8179  ...     6596     6481\n",
              "              6          ５　～　９            8426  ...     6943     6658\n",
              "              7        10　～　14            8102  ...     7464     7084\n",
              "              8        15　～　64          122022  ...   109543   103297\n",
              "              9        15　～　19            9667  ...    10047     9075\n",
              "              10       20　～　24           13367  ...    12819    12566\n",
              "              11       25　～　29           10433  ...     9416     9977\n",
              "              12       30　～　34           10473  ...     8903     9070\n",
              "              13       35　～　39           11927  ...     9746     8821\n",
              "              14       40　～　44           13438  ...     9870     9828\n",
              "              15       45　～　49           14973  ...    10209     9791\n",
              "              16       50　～　54           14423  ...    11583    10085\n",
              "              17       55　～　59           12972  ...    12825    11494\n",
              "              18       60　～　64           10349  ...    14125    12590\n",
              "              19      65　歳　以　上           44715  ...    51444    52340\n",
              "              20       65　～　69            9874  ...    13333    13689\n",
              "              21       70　～　74           10875  ...    11460    12649\n",
              "              22       75　～　79            8883  ...     8553    10488\n",
              "              23       80　～　84            7214  ...     7182     7292\n",
              "              24       85　～　89            5042  ...     6146     5271\n",
              "              25      90　歳　以　上            2827  ...     4770     2951\n",
              "              26           NaN             NaN  ...      NaN      NaN\n",
              "              27           NaN             NaN  ...      NaN      NaN\n",
              "              \n",
              "              [28 rows x 6 columns])])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "n_WgWBjENnvg",
        "colab_type": "code",
        "outputId": "5adf8d0b-c2a0-4a72-f9e8-845fee040656",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "xls['P13']"
      ],
      "execution_count": 11,
      "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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>１．人　　　　　口</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>８．住 民 基 本 台 帳 人 口 の 推 移</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\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>NaN</td>\n",
              "      <td>各年１月１日</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>年　　　次</td>\n",
              "      <td>総　　　数</td>\n",
              "      <td>男</td>\n",
              "      <td>女</td>\n",
              "      <td>世帯数</td>\n",
              "      <td>人口密度</td>\n",
              "      <td>1世帯当</td>\n",
              "      <td>人口増加率</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\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>たり人口</td>\n",
              "      <td>（％）</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>平成２年</td>\n",
              "      <td>157446</td>\n",
              "      <td>80485</td>\n",
              "      <td>76961</td>\n",
              "      <td>61227</td>\n",
              "      <td>7695</td>\n",
              "      <td>2.57</td>\n",
              "      <td>0.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>３</td>\n",
              "      <td>159182</td>\n",
              "      <td>81186</td>\n",
              "      <td>77996</td>\n",
              "      <td>62651</td>\n",
              "      <td>7780</td>\n",
              "      <td>2.54</td>\n",
              "      <td>1.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>４</td>\n",
              "      <td>161463</td>\n",
              "      <td>82301</td>\n",
              "      <td>79162</td>\n",
              "      <td>64539</td>\n",
              "      <td>7892</td>\n",
              "      <td>2.5</td>\n",
              "      <td>1.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>５</td>\n",
              "      <td>163603</td>\n",
              "      <td>83268</td>\n",
              "      <td>80335</td>\n",
              "      <td>66124</td>\n",
              "      <td>7996</td>\n",
              "      <td>2.47</td>\n",
              "      <td>1.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>６</td>\n",
              "      <td>164264</td>\n",
              "      <td>83382</td>\n",
              "      <td>80882</td>\n",
              "      <td>66870</td>\n",
              "      <td>8029</td>\n",
              "      <td>2.46</td>\n",
              "      <td>0.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>７</td>\n",
              "      <td>165177</td>\n",
              "      <td>83684</td>\n",
              "      <td>81493</td>\n",
              "      <td>67475</td>\n",
              "      <td>8073</td>\n",
              "      <td>2.45</td>\n",
              "      <td>0.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>８</td>\n",
              "      <td>167045</td>\n",
              "      <td>84418</td>\n",
              "      <td>82627</td>\n",
              "      <td>68680</td>\n",
              "      <td>8164</td>\n",
              "      <td>2.43</td>\n",
              "      <td>1.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>９</td>\n",
              "      <td>168408</td>\n",
              "      <td>85015</td>\n",
              "      <td>83393</td>\n",
              "      <td>69634</td>\n",
              "      <td>8231</td>\n",
              "      <td>2.42</td>\n",
              "      <td>0.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>10</td>\n",
              "      <td>168714</td>\n",
              "      <td>84821</td>\n",
              "      <td>83893</td>\n",
              "      <td>70304</td>\n",
              "      <td>8246</td>\n",
              "      <td>2.4</td>\n",
              "      <td>0.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>11</td>\n",
              "      <td>171021</td>\n",
              "      <td>85769</td>\n",
              "      <td>85252</td>\n",
              "      <td>71826</td>\n",
              "      <td>8359</td>\n",
              "      <td>2.38</td>\n",
              "      <td>1.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>12</td>\n",
              "      <td>171914</td>\n",
              "      <td>86063</td>\n",
              "      <td>85851</td>\n",
              "      <td>72772</td>\n",
              "      <td>8402</td>\n",
              "      <td>2.36</td>\n",
              "      <td>0.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>13</td>\n",
              "      <td>172782</td>\n",
              "      <td>86521</td>\n",
              "      <td>86261</td>\n",
              "      <td>73812</td>\n",
              "      <td>8445</td>\n",
              "      <td>2.34</td>\n",
              "      <td>0.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>14</td>\n",
              "      <td>174333</td>\n",
              "      <td>87157</td>\n",
              "      <td>87176</td>\n",
              "      <td>75053</td>\n",
              "      <td>8521</td>\n",
              "      <td>2.32</td>\n",
              "      <td>0.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>15</td>\n",
              "      <td>175599</td>\n",
              "      <td>87803</td>\n",
              "      <td>87796</td>\n",
              "      <td>76102</td>\n",
              "      <td>8583</td>\n",
              "      <td>2.31</td>\n",
              "      <td>0.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>16</td>\n",
              "      <td>175879</td>\n",
              "      <td>87984</td>\n",
              "      <td>87895</td>\n",
              "      <td>76729</td>\n",
              "      <td>8596</td>\n",
              "      <td>2.29</td>\n",
              "      <td>0.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>17</td>\n",
              "      <td>176486</td>\n",
              "      <td>88181</td>\n",
              "      <td>88305</td>\n",
              "      <td>77305</td>\n",
              "      <td>8626</td>\n",
              "      <td>2.28</td>\n",
              "      <td>0.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>18</td>\n",
              "      <td>176773</td>\n",
              "      <td>88236</td>\n",
              "      <td>88537</td>\n",
              "      <td>78142</td>\n",
              "      <td>8640</td>\n",
              "      <td>2.26</td>\n",
              "      <td>0.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>19</td>\n",
              "      <td>177532</td>\n",
              "      <td>88574</td>\n",
              "      <td>88958</td>\n",
              "      <td>79007</td>\n",
              "      <td>8677</td>\n",
              "      <td>2.25</td>\n",
              "      <td>0.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>20</td>\n",
              "      <td>178654</td>\n",
              "      <td>89109</td>\n",
              "      <td>89545</td>\n",
              "      <td>80182</td>\n",
              "      <td>8732</td>\n",
              "      <td>2.23</td>\n",
              "      <td>0.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>21</td>\n",
              "      <td>179269</td>\n",
              "      <td>89390</td>\n",
              "      <td>89879</td>\n",
              "      <td>81173</td>\n",
              "      <td>8762</td>\n",
              "      <td>2.21</td>\n",
              "      <td>0.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>22</td>\n",
              "      <td>179717</td>\n",
              "      <td>89353</td>\n",
              "      <td>90364</td>\n",
              "      <td>81619</td>\n",
              "      <td>8784</td>\n",
              "      <td>2.2</td>\n",
              "      <td>0.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>23</td>\n",
              "      <td>179728</td>\n",
              "      <td>89289</td>\n",
              "      <td>90439</td>\n",
              "      <td>81747</td>\n",
              "      <td>8784</td>\n",
              "      <td>2.2</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>24</td>\n",
              "      <td>180314</td>\n",
              "      <td>89449</td>\n",
              "      <td>90865</td>\n",
              "      <td>82330</td>\n",
              "      <td>8813</td>\n",
              "      <td>2.19</td>\n",
              "      <td>0.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>25</td>\n",
              "      <td>185677</td>\n",
              "      <td>91970</td>\n",
              "      <td>93707</td>\n",
              "      <td>85564</td>\n",
              "      <td>9075</td>\n",
              "      <td>2.17</td>\n",
              "      <td>2.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>26</td>\n",
              "      <td>186339</td>\n",
              "      <td>92041</td>\n",
              "      <td>94298</td>\n",
              "      <td>86026</td>\n",
              "      <td>9107</td>\n",
              "      <td>2.17</td>\n",
              "      <td>0.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>27</td>\n",
              "      <td>186958</td>\n",
              "      <td>92231</td>\n",
              "      <td>94727</td>\n",
              "      <td>86611</td>\n",
              "      <td>9115</td>\n",
              "      <td>2.16</td>\n",
              "      <td>0.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>28</td>\n",
              "      <td>188609</td>\n",
              "      <td>93107</td>\n",
              "      <td>95502</td>\n",
              "      <td>88016</td>\n",
              "      <td>9196</td>\n",
              "      <td>2.14</td>\n",
              "      <td>0.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>29</td>\n",
              "      <td>189885</td>\n",
              "      <td>93657</td>\n",
              "      <td>96228</td>\n",
              "      <td>88967</td>\n",
              "      <td>9258</td>\n",
              "      <td>2.13</td>\n",
              "      <td>0.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>30</td>\n",
              "      <td>191308</td>\n",
              "      <td>94397</td>\n",
              "      <td>96911</td>\n",
              "      <td>90166</td>\n",
              "      <td>9328</td>\n",
              "      <td>2.12</td>\n",
              "      <td>0.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>31</td>\n",
              "      <td>193596</td>\n",
              "      <td>95312</td>\n",
              "      <td>98284</td>\n",
              "      <td>91602</td>\n",
              "      <td>9439</td>\n",
              "      <td>2.11</td>\n",
              "      <td>1.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>（注）外国人登録制度が廃止され、平成24年７月９日より外国人</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>住民も住民基本台帳制度の対象となる法改正があった。</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>資料：住民基本台帳人口</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                  0       1  ...     6          7\n",
              "0                         １．人　　　　　口     NaN  ...   NaN        NaN\n",
              "1                               NaN     NaN  ...   NaN        NaN\n",
              "2           ８．住 民 基 本 台 帳 人 口 の 推 移     NaN  ...   NaN        NaN\n",
              "3                               NaN     NaN  ...   NaN     各年１月１日\n",
              "4                             年　　　次   総　　　数  ...  1世帯当      人口増加率\n",
              "5                               NaN     NaN  ...  たり人口        （％）\n",
              "6                               NaN     NaN  ...   NaN        NaN\n",
              "7                              平成２年  157446  ...  2.57        0.9\n",
              "8                                 ３  159182  ...  2.54        1.1\n",
              "9                                 ４  161463  ...   2.5        1.4\n",
              "10                                ５  163603  ...  2.47        1.3\n",
              "11                                ６  164264  ...  2.46        0.4\n",
              "12                                ７  165177  ...  2.45        0.6\n",
              "13                                ８  167045  ...  2.43        1.1\n",
              "14                                ９  168408  ...  2.42        0.8\n",
              "15                               10  168714  ...   2.4        0.2\n",
              "16                               11  171021  ...  2.38        1.4\n",
              "17                              NaN     NaN  ...   NaN        NaN\n",
              "18                               12  171914  ...  2.36        0.5\n",
              "19                               13  172782  ...  2.34        0.5\n",
              "20                               14  174333  ...  2.32        0.9\n",
              "21                               15  175599  ...  2.31        0.7\n",
              "22                               16  175879  ...  2.29        0.2\n",
              "23                               17  176486  ...  2.28        0.3\n",
              "24                               18  176773  ...  2.26        0.2\n",
              "25                               19  177532  ...  2.25        0.4\n",
              "26                               20  178654  ...  2.23        0.6\n",
              "27                               21  179269  ...  2.21     　　　0.3\n",
              "28                              NaN     NaN  ...   NaN        NaN\n",
              "29                               22  179717  ...   2.2        0.2\n",
              "30                               23  179728  ...   2.2        0.0\n",
              "31                               24  180314  ...  2.19        0.3\n",
              "32                               25  185677  ...  2.17        2.9\n",
              "33                               26  186339  ...  2.17        0.4\n",
              "34                               27  186958  ...  2.16        0.3\n",
              "35                               28  188609  ...  2.14        0.9\n",
              "36                               29  189885  ...  2.13        0.7\n",
              "37                               30  191308  ...  2.12        0.7\n",
              "38                               31  193596  ...  2.11        1.2\n",
              "39                              NaN     NaN  ...   NaN        NaN\n",
              "40                              NaN     NaN  ...   NaN        NaN\n",
              "41                              NaN     NaN  ...   NaN        NaN\n",
              "42                              NaN     NaN  ...   NaN        NaN\n",
              "\n",
              "[43 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VmUo8k3fNulb",
        "colab_type": "code",
        "outputId": "627e9e30-b7d0-4363-c5b7-43d4c3a37dd5",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "xls['P14.15'][2:]"
      ],
      "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>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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2</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>1世帯当たり</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\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>人　　口</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>人　　口</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\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>NaN</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>総数</td>\n",
              "      <td>193596</td>\n",
              "      <td>95312</td>\n",
              "      <td>98284</td>\n",
              "      <td>91602</td>\n",
              "      <td>9439</td>\n",
              "      <td>2.11</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\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>NaN</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>中島町</td>\n",
              "      <td>1861</td>\n",
              "      <td>916</td>\n",
              "      <td>945</td>\n",
              "      <td>902</td>\n",
              "      <td>7754</td>\n",
              "      <td>2.06</td>\n",
              "      <td>学園西町１丁目</td>\n",
              "      <td>4564</td>\n",
              "      <td>2259</td>\n",
              "      <td>2305</td>\n",
              "      <td>2627</td>\n",
              "      <td>13040</td>\n",
              "      <td>1.74</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>上水新町１丁目</td>\n",
              "      <td>1518</td>\n",
              "      <td>741</td>\n",
              "      <td>777</td>\n",
              "      <td>663</td>\n",
              "      <td>8433</td>\n",
              "      <td>2.29</td>\n",
              "      <td>学園西町２丁目</td>\n",
              "      <td>3788</td>\n",
              "      <td>1840</td>\n",
              "      <td>1948</td>\n",
              "      <td>1985</td>\n",
              "      <td>15152</td>\n",
              "      <td>1.91</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>上水新町２丁目</td>\n",
              "      <td>1567</td>\n",
              "      <td>740</td>\n",
              "      <td>827</td>\n",
              "      <td>696</td>\n",
              "      <td>9794</td>\n",
              "      <td>2.25</td>\n",
              "      <td>学園西町３丁目</td>\n",
              "      <td>2384</td>\n",
              "      <td>1185</td>\n",
              "      <td>1199</td>\n",
              "      <td>1149</td>\n",
              "      <td>12547</td>\n",
              "      <td>2.07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>上水新町３丁目</td>\n",
              "      <td>1545</td>\n",
              "      <td>752</td>\n",
              "      <td>793</td>\n",
              "      <td>720</td>\n",
              "      <td>12875</td>\n",
              "      <td>2.15</td>\n",
              "      <td>学園東町</td>\n",
              "      <td>2263</td>\n",
              "      <td>1063</td>\n",
              "      <td>1200</td>\n",
              "      <td>990</td>\n",
              "      <td>12572</td>\n",
              "      <td>2.29</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>たかの台</td>\n",
              "      <td>2011</td>\n",
              "      <td>976</td>\n",
              "      <td>1035</td>\n",
              "      <td>1018</td>\n",
              "      <td>9141</td>\n",
              "      <td>1.98</td>\n",
              "      <td>学園東町１丁目</td>\n",
              "      <td>3157</td>\n",
              "      <td>1515</td>\n",
              "      <td>1642</td>\n",
              "      <td>1679</td>\n",
              "      <td>15785</td>\n",
              "      <td>1.88</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\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>NaN</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>小川町１丁目</td>\n",
              "      <td>18641</td>\n",
              "      <td>9293</td>\n",
              "      <td>9348</td>\n",
              "      <td>9183</td>\n",
              "      <td>7486</td>\n",
              "      <td>2.03</td>\n",
              "      <td>学園東町２丁目</td>\n",
              "      <td>2704</td>\n",
              "      <td>1362</td>\n",
              "      <td>1342</td>\n",
              "      <td>1392</td>\n",
              "      <td>12291</td>\n",
              "      <td>1.94</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>小川町２丁目</td>\n",
              "      <td>5621</td>\n",
              "      <td>2872</td>\n",
              "      <td>2749</td>\n",
              "      <td>2638</td>\n",
              "      <td>6855</td>\n",
              "      <td>2.13</td>\n",
              "      <td>学園東町３丁目</td>\n",
              "      <td>1898</td>\n",
              "      <td>1009</td>\n",
              "      <td>889</td>\n",
              "      <td>1017</td>\n",
              "      <td>11863</td>\n",
              "      <td>1.87</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>栄町１丁目</td>\n",
              "      <td>710</td>\n",
              "      <td>362</td>\n",
              "      <td>348</td>\n",
              "      <td>364</td>\n",
              "      <td>5462</td>\n",
              "      <td>1.95</td>\n",
              "      <td>仲町</td>\n",
              "      <td>9042</td>\n",
              "      <td>4482</td>\n",
              "      <td>4560</td>\n",
              "      <td>4402</td>\n",
              "      <td>10160</td>\n",
              "      <td>2.05</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>栄町２丁目</td>\n",
              "      <td>1719</td>\n",
              "      <td>906</td>\n",
              "      <td>813</td>\n",
              "      <td>726</td>\n",
              "      <td>10744</td>\n",
              "      <td>2.37</td>\n",
              "      <td>美園町１丁目</td>\n",
              "      <td>2632</td>\n",
              "      <td>1216</td>\n",
              "      <td>1416</td>\n",
              "      <td>1473</td>\n",
              "      <td>18800</td>\n",
              "      <td>1.79</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>栄町３丁目</td>\n",
              "      <td>894</td>\n",
              "      <td>438</td>\n",
              "      <td>456</td>\n",
              "      <td>398</td>\n",
              "      <td>12771</td>\n",
              "      <td>2.25</td>\n",
              "      <td>美園町２丁目</td>\n",
              "      <td>1323</td>\n",
              "      <td>654</td>\n",
              "      <td>669</td>\n",
              "      <td>777</td>\n",
              "      <td>13230</td>\n",
              "      <td>1.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\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>NaN</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>小川西町１丁目</td>\n",
              "      <td>1153</td>\n",
              "      <td>540</td>\n",
              "      <td>613</td>\n",
              "      <td>515</td>\n",
              "      <td>10482</td>\n",
              "      <td>2.24</td>\n",
              "      <td>美園町３丁目</td>\n",
              "      <td>1510</td>\n",
              "      <td>722</td>\n",
              "      <td>788</td>\n",
              "      <td>820</td>\n",
              "      <td>4081</td>\n",
              "      <td>1.84</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>小川西町２丁目</td>\n",
              "      <td>1662</td>\n",
              "      <td>806</td>\n",
              "      <td>856</td>\n",
              "      <td>855</td>\n",
              "      <td>8747</td>\n",
              "      <td>1.94</td>\n",
              "      <td>回田町</td>\n",
              "      <td>5193</td>\n",
              "      <td>2621</td>\n",
              "      <td>2572</td>\n",
              "      <td>2096</td>\n",
              "      <td>9798</td>\n",
              "      <td>2.48</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>小川西町３丁目</td>\n",
              "      <td>1156</td>\n",
              "      <td>584</td>\n",
              "      <td>572</td>\n",
              "      <td>620</td>\n",
              "      <td>14450</td>\n",
              "      <td>1.86</td>\n",
              "      <td>御幸町</td>\n",
              "      <td>2695</td>\n",
              "      <td>1378</td>\n",
              "      <td>1317</td>\n",
              "      <td>1175</td>\n",
              "      <td>4647</td>\n",
              "      <td>2.29</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>小川西町４丁目</td>\n",
              "      <td>1573</td>\n",
              "      <td>753</td>\n",
              "      <td>820</td>\n",
              "      <td>903</td>\n",
              "      <td>13108</td>\n",
              "      <td>1.74</td>\n",
              "      <td>鈴木町１丁目</td>\n",
              "      <td>9711</td>\n",
              "      <td>4820</td>\n",
              "      <td>4891</td>\n",
              "      <td>4056</td>\n",
              "      <td>11425</td>\n",
              "      <td>2.39</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>小川西町５丁目</td>\n",
              "      <td>2740</td>\n",
              "      <td>1305</td>\n",
              "      <td>1435</td>\n",
              "      <td>1246</td>\n",
              "      <td>10960</td>\n",
              "      <td>2.2</td>\n",
              "      <td>鈴木町２丁目</td>\n",
              "      <td>6658</td>\n",
              "      <td>3278</td>\n",
              "      <td>3380</td>\n",
              "      <td>3002</td>\n",
              "      <td>12330</td>\n",
              "      <td>2.22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\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>NaN</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>小川東町</td>\n",
              "      <td>1543</td>\n",
              "      <td>743</td>\n",
              "      <td>800</td>\n",
              "      <td>712</td>\n",
              "      <td>15430</td>\n",
              "      <td>2.17</td>\n",
              "      <td>天神町１丁目</td>\n",
              "      <td>2511</td>\n",
              "      <td>1221</td>\n",
              "      <td>1290</td>\n",
              "      <td>1019</td>\n",
              "      <td>15694</td>\n",
              "      <td>2.46</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>小川東町１丁目</td>\n",
              "      <td>3045</td>\n",
              "      <td>1539</td>\n",
              "      <td>1506</td>\n",
              "      <td>1419</td>\n",
              "      <td>11712</td>\n",
              "      <td>2.15</td>\n",
              "      <td>天神町２丁目</td>\n",
              "      <td>1598</td>\n",
              "      <td>824</td>\n",
              "      <td>774</td>\n",
              "      <td>776</td>\n",
              "      <td>9988</td>\n",
              "      <td>2.06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>小川東町２丁目</td>\n",
              "      <td>1237</td>\n",
              "      <td>548</td>\n",
              "      <td>689</td>\n",
              "      <td>643</td>\n",
              "      <td>12370</td>\n",
              "      <td>1.92</td>\n",
              "      <td>天神町３丁目</td>\n",
              "      <td>333</td>\n",
              "      <td>153</td>\n",
              "      <td>180</td>\n",
              "      <td>141</td>\n",
              "      <td>3700</td>\n",
              "      <td>2.36</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>小川東町３丁目</td>\n",
              "      <td>1066</td>\n",
              "      <td>597</td>\n",
              "      <td>469</td>\n",
              "      <td>462</td>\n",
              "      <td>1748</td>\n",
              "      <td>2.31</td>\n",
              "      <td>天神町４丁目</td>\n",
              "      <td>2122</td>\n",
              "      <td>1034</td>\n",
              "      <td>1088</td>\n",
              "      <td>907</td>\n",
              "      <td>10105</td>\n",
              "      <td>2.34</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>小川東町４丁目</td>\n",
              "      <td>1165</td>\n",
              "      <td>522</td>\n",
              "      <td>643</td>\n",
              "      <td>842</td>\n",
              "      <td>4481</td>\n",
              "      <td>1.38</td>\n",
              "      <td>大沼町１丁目</td>\n",
              "      <td>1619</td>\n",
              "      <td>781</td>\n",
              "      <td>838</td>\n",
              "      <td>735</td>\n",
              "      <td>12454</td>\n",
              "      <td>2.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\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>NaN</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>小川東町５丁目</td>\n",
              "      <td>2835</td>\n",
              "      <td>1421</td>\n",
              "      <td>1414</td>\n",
              "      <td>1297</td>\n",
              "      <td>13500</td>\n",
              "      <td>2.19</td>\n",
              "      <td>大沼町２丁目</td>\n",
              "      <td>2003</td>\n",
              "      <td>1007</td>\n",
              "      <td>996</td>\n",
              "      <td>868</td>\n",
              "      <td>8346</td>\n",
              "      <td>2.31</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>上水本町１丁目</td>\n",
              "      <td>1555</td>\n",
              "      <td>741</td>\n",
              "      <td>814</td>\n",
              "      <td>728</td>\n",
              "      <td>8639</td>\n",
              "      <td>2.14</td>\n",
              "      <td>大沼町３丁目</td>\n",
              "      <td>746</td>\n",
              "      <td>377</td>\n",
              "      <td>369</td>\n",
              "      <td>301</td>\n",
              "      <td>4388</td>\n",
              "      <td>2.48</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>上水本町２丁目</td>\n",
              "      <td>1028</td>\n",
              "      <td>484</td>\n",
              "      <td>544</td>\n",
              "      <td>479</td>\n",
              "      <td>6425</td>\n",
              "      <td>2.15</td>\n",
              "      <td>大沼町４丁目</td>\n",
              "      <td>1973</td>\n",
              "      <td>1023</td>\n",
              "      <td>950</td>\n",
              "      <td>853</td>\n",
              "      <td>9395</td>\n",
              "      <td>2.31</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>上水本町３丁目</td>\n",
              "      <td>1167</td>\n",
              "      <td>583</td>\n",
              "      <td>584</td>\n",
              "      <td>487</td>\n",
              "      <td>11670</td>\n",
              "      <td>2.4</td>\n",
              "      <td>大沼町５丁目</td>\n",
              "      <td>529</td>\n",
              "      <td>262</td>\n",
              "      <td>267</td>\n",
              "      <td>197</td>\n",
              "      <td>3779</td>\n",
              "      <td>2.69</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>上水本町４丁目</td>\n",
              "      <td>1438</td>\n",
              "      <td>728</td>\n",
              "      <td>710</td>\n",
              "      <td>645</td>\n",
              "      <td>9587</td>\n",
              "      <td>2.23</td>\n",
              "      <td>大沼町６丁目</td>\n",
              "      <td>628</td>\n",
              "      <td>305</td>\n",
              "      <td>323</td>\n",
              "      <td>240</td>\n",
              "      <td>4831</td>\n",
              "      <td>2.62</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\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>NaN</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>上水本町５丁目</td>\n",
              "      <td>3472</td>\n",
              "      <td>1714</td>\n",
              "      <td>1758</td>\n",
              "      <td>1375</td>\n",
              "      <td>17360</td>\n",
              "      <td>2.53</td>\n",
              "      <td>大沼町７丁目</td>\n",
              "      <td>2493</td>\n",
              "      <td>1069</td>\n",
              "      <td>1424</td>\n",
              "      <td>1086</td>\n",
              "      <td>16620</td>\n",
              "      <td>2.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>上水本町６丁目</td>\n",
              "      <td>2456</td>\n",
              "      <td>1208</td>\n",
              "      <td>1248</td>\n",
              "      <td>1034</td>\n",
              "      <td>11695</td>\n",
              "      <td>2.38</td>\n",
              "      <td>花小金井南町１丁目</td>\n",
              "      <td>5019</td>\n",
              "      <td>2402</td>\n",
              "      <td>2617</td>\n",
              "      <td>2473</td>\n",
              "      <td>9294</td>\n",
              "      <td>2.03</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>上水南町１丁目</td>\n",
              "      <td>2067</td>\n",
              "      <td>981</td>\n",
              "      <td>1086</td>\n",
              "      <td>906</td>\n",
              "      <td>10879</td>\n",
              "      <td>2.28</td>\n",
              "      <td>花小金井南町２丁目</td>\n",
              "      <td>2157</td>\n",
              "      <td>1051</td>\n",
              "      <td>1106</td>\n",
              "      <td>1144</td>\n",
              "      <td>10785</td>\n",
              "      <td>1.89</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>上水南町２丁目</td>\n",
              "      <td>2472</td>\n",
              "      <td>1239</td>\n",
              "      <td>1233</td>\n",
              "      <td>1171</td>\n",
              "      <td>13011</td>\n",
              "      <td>2.11</td>\n",
              "      <td>花小金井南町３丁目</td>\n",
              "      <td>3143</td>\n",
              "      <td>1598</td>\n",
              "      <td>1545</td>\n",
              "      <td>1401</td>\n",
              "      <td>8731</td>\n",
              "      <td>2.24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>上水南町３丁目</td>\n",
              "      <td>2866</td>\n",
              "      <td>1411</td>\n",
              "      <td>1455</td>\n",
              "      <td>1240</td>\n",
              "      <td>11464</td>\n",
              "      <td>2.31</td>\n",
              "      <td>花小金井１丁目</td>\n",
              "      <td>4234</td>\n",
              "      <td>2036</td>\n",
              "      <td>2198</td>\n",
              "      <td>2040</td>\n",
              "      <td>13658</td>\n",
              "      <td>2.08</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\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>NaN</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>上水南町４丁目</td>\n",
              "      <td>1044</td>\n",
              "      <td>540</td>\n",
              "      <td>504</td>\n",
              "      <td>483</td>\n",
              "      <td>5495</td>\n",
              "      <td>2.16</td>\n",
              "      <td>花小金井２丁目</td>\n",
              "      <td>2842</td>\n",
              "      <td>1449</td>\n",
              "      <td>1393</td>\n",
              "      <td>1356</td>\n",
              "      <td>11842</td>\n",
              "      <td>2.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>喜平町1丁目</td>\n",
              "      <td>1752</td>\n",
              "      <td>869</td>\n",
              "      <td>883</td>\n",
              "      <td>809</td>\n",
              "      <td>10306</td>\n",
              "      <td>2.17</td>\n",
              "      <td>花小金井３丁目</td>\n",
              "      <td>2495</td>\n",
              "      <td>1175</td>\n",
              "      <td>1320</td>\n",
              "      <td>1110</td>\n",
              "      <td>6238</td>\n",
              "      <td>2.25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>喜平町２丁目</td>\n",
              "      <td>1241</td>\n",
              "      <td>691</td>\n",
              "      <td>550</td>\n",
              "      <td>537</td>\n",
              "      <td>3354</td>\n",
              "      <td>2.31</td>\n",
              "      <td>花小金井４丁目</td>\n",
              "      <td>2571</td>\n",
              "      <td>1271</td>\n",
              "      <td>1300</td>\n",
              "      <td>1102</td>\n",
              "      <td>10713</td>\n",
              "      <td>2.33</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>喜平町３丁目</td>\n",
              "      <td>2766</td>\n",
              "      <td>1306</td>\n",
              "      <td>1460</td>\n",
              "      <td>1708</td>\n",
              "      <td>17288</td>\n",
              "      <td>1.62</td>\n",
              "      <td>花小金井５丁目</td>\n",
              "      <td>3306</td>\n",
              "      <td>1683</td>\n",
              "      <td>1623</td>\n",
              "      <td>1550</td>\n",
              "      <td>10665</td>\n",
              "      <td>2.13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>津田町１丁目</td>\n",
              "      <td>1000</td>\n",
              "      <td>483</td>\n",
              "      <td>517</td>\n",
              "      <td>507</td>\n",
              "      <td>5556</td>\n",
              "      <td>1.967</td>\n",
              "      <td>花小金井６丁目</td>\n",
              "      <td>1997</td>\n",
              "      <td>948</td>\n",
              "      <td>1049</td>\n",
              "      <td>1105</td>\n",
              "      <td>8321</td>\n",
              "      <td>1.81</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\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>NaN</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>津田町２丁目</td>\n",
              "      <td>1471</td>\n",
              "      <td>663</td>\n",
              "      <td>808</td>\n",
              "      <td>725</td>\n",
              "      <td>7355</td>\n",
              "      <td>2.03</td>\n",
              "      <td>花小金井７丁目</td>\n",
              "      <td>2818</td>\n",
              "      <td>1435</td>\n",
              "      <td>1383</td>\n",
              "      <td>1152</td>\n",
              "      <td>17613</td>\n",
              "      <td>2.45</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>津田町３丁目</td>\n",
              "      <td>2532</td>\n",
              "      <td>1125</td>\n",
              "      <td>1407</td>\n",
              "      <td>1180</td>\n",
              "      <td>14067</td>\n",
              "      <td>2.15</td>\n",
              "      <td>花小金井８丁目</td>\n",
              "      <td>1348</td>\n",
              "      <td>684</td>\n",
              "      <td>664</td>\n",
              "      <td>570</td>\n",
              "      <td>6419</td>\n",
              "      <td>2.36</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\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>NaN</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>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>52</th>\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>NaN</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>資料：住民基本台帳人口</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         0       1      2      3   ...    10     11       12           13\n",
              "2    町　　　　丁    人口総数      男      女  ...     女  世 帯 数  人 口 密 度       1世帯当たり\n",
              "3       NaN     NaN    NaN    NaN  ...   NaN    NaN    人 ／ ㎢         人　　口\n",
              "4       NaN     NaN    NaN    NaN  ...   NaN    NaN      NaN          NaN\n",
              "5        総数  193596  95312  98284  ...   NaN    NaN      NaN          NaN\n",
              "6       NaN     NaN    NaN    NaN  ...   NaN    NaN      NaN          NaN\n",
              "7       中島町    1861    916    945  ...  2305   2627    13040         1.74\n",
              "8   上水新町１丁目    1518    741    777  ...  1948   1985    15152         1.91\n",
              "9   上水新町２丁目    1567    740    827  ...  1199   1149    12547         2.07\n",
              "10  上水新町３丁目    1545    752    793  ...  1200    990    12572         2.29\n",
              "11     たかの台    2011    976   1035  ...  1642   1679    15785         1.88\n",
              "12      NaN     NaN    NaN    NaN  ...   NaN    NaN      NaN          NaN\n",
              "13   小川町１丁目   18641   9293   9348  ...  1342   1392    12291         1.94\n",
              "14   小川町２丁目    5621   2872   2749  ...   889   1017    11863         1.87\n",
              "15    栄町１丁目     710    362    348  ...  4560   4402    10160         2.05\n",
              "16    栄町２丁目    1719    906    813  ...  1416   1473    18800         1.79\n",
              "17    栄町３丁目     894    438    456  ...   669    777    13230          1.7\n",
              "18      NaN     NaN    NaN    NaN  ...   NaN    NaN      NaN          NaN\n",
              "19  小川西町１丁目    1153    540    613  ...   788    820     4081         1.84\n",
              "20  小川西町２丁目    1662    806    856  ...  2572   2096     9798         2.48\n",
              "21  小川西町３丁目    1156    584    572  ...  1317   1175     4647         2.29\n",
              "22  小川西町４丁目    1573    753    820  ...  4891   4056    11425         2.39\n",
              "23  小川西町５丁目    2740   1305   1435  ...  3380   3002    12330         2.22\n",
              "24      NaN     NaN    NaN    NaN  ...   NaN    NaN      NaN          NaN\n",
              "25     小川東町    1543    743    800  ...  1290   1019    15694         2.46\n",
              "26  小川東町１丁目    3045   1539   1506  ...   774    776     9988         2.06\n",
              "27  小川東町２丁目    1237    548    689  ...   180    141     3700         2.36\n",
              "28  小川東町３丁目    1066    597    469  ...  1088    907    10105         2.34\n",
              "29  小川東町４丁目    1165    522    643  ...   838    735    12454          2.2\n",
              "30      NaN     NaN    NaN    NaN  ...   NaN    NaN      NaN          NaN\n",
              "31  小川東町５丁目    2835   1421   1414  ...   996    868     8346         2.31\n",
              "32  上水本町１丁目    1555    741    814  ...   369    301     4388         2.48\n",
              "33  上水本町２丁目    1028    484    544  ...   950    853     9395         2.31\n",
              "34  上水本町３丁目    1167    583    584  ...   267    197     3779         2.69\n",
              "35  上水本町４丁目    1438    728    710  ...   323    240     4831         2.62\n",
              "36      NaN     NaN    NaN    NaN  ...   NaN    NaN      NaN          NaN\n",
              "37  上水本町５丁目    3472   1714   1758  ...  1424   1086    16620          2.3\n",
              "38  上水本町６丁目    2456   1208   1248  ...  2617   2473     9294         2.03\n",
              "39  上水南町１丁目    2067    981   1086  ...  1106   1144    10785         1.89\n",
              "40  上水南町２丁目    2472   1239   1233  ...  1545   1401     8731         2.24\n",
              "41  上水南町３丁目    2866   1411   1455  ...  2198   2040    13658         2.08\n",
              "42      NaN     NaN    NaN    NaN  ...   NaN    NaN      NaN          NaN\n",
              "43  上水南町４丁目    1044    540    504  ...  1393   1356    11842          2.1\n",
              "44   喜平町1丁目    1752    869    883  ...  1320   1110     6238         2.25\n",
              "45   喜平町２丁目    1241    691    550  ...  1300   1102    10713         2.33\n",
              "46   喜平町３丁目    2766   1306   1460  ...  1623   1550    10665         2.13\n",
              "47   津田町１丁目    1000    483    517  ...  1049   1105     8321         1.81\n",
              "48      NaN     NaN    NaN    NaN  ...   NaN    NaN      NaN          NaN\n",
              "49   津田町２丁目    1471    663    808  ...  1383   1152    17613         2.45\n",
              "50   津田町３丁目    2532   1125   1407  ...   664    570     6419         2.36\n",
              "51      NaN     NaN    NaN    NaN  ...   NaN    NaN      NaN          NaN\n",
              "52      NaN     NaN    NaN    NaN  ...   NaN    NaN      NaN  資料：住民基本台帳人口\n",
              "\n",
              "[51 rows x 14 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FWkw1fI2O20E",
        "colab_type": "code",
        "outputId": "dfacec3c-9e63-4049-b43a-b58a6c4f1ba3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "xls['P16.17']"
      ],
      "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>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",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>10．月　　別　　人　　口</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>世　　帯　　数　　の　　推　　移</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\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>NaN</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>NaN</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>月　　次</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>月　　次</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>月　　次</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>月　　次</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\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>NaN</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>NaN</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>平成23年</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>平成25年</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>平成27年</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>平成29年</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>１月</td>\n",
              "      <td>179728</td>\n",
              "      <td>89289</td>\n",
              "      <td>90439</td>\n",
              "      <td>81747</td>\n",
              "      <td>１月</td>\n",
              "      <td>185677</td>\n",
              "      <td>91970</td>\n",
              "      <td>93707</td>\n",
              "      <td>85564</td>\n",
              "      <td>１月</td>\n",
              "      <td>186958</td>\n",
              "      <td>92231</td>\n",
              "      <td>94727</td>\n",
              "      <td>86611</td>\n",
              "      <td>１月</td>\n",
              "      <td>189885</td>\n",
              "      <td>93657</td>\n",
              "      <td>96228</td>\n",
              "      <td>88967</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>２</td>\n",
              "      <td>179687</td>\n",
              "      <td>89266</td>\n",
              "      <td>90421</td>\n",
              "      <td>81728</td>\n",
              "      <td>２</td>\n",
              "      <td>185610</td>\n",
              "      <td>91917</td>\n",
              "      <td>93693</td>\n",
              "      <td>85493</td>\n",
              "      <td>２</td>\n",
              "      <td>187047</td>\n",
              "      <td>92295</td>\n",
              "      <td>94752</td>\n",
              "      <td>86600</td>\n",
              "      <td>２</td>\n",
              "      <td>189975</td>\n",
              "      <td>93749</td>\n",
              "      <td>96226</td>\n",
              "      <td>88993</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>３</td>\n",
              "      <td>179519</td>\n",
              "      <td>89176</td>\n",
              "      <td>90343</td>\n",
              "      <td>81643</td>\n",
              "      <td>３</td>\n",
              "      <td>185499</td>\n",
              "      <td>91873</td>\n",
              "      <td>93626</td>\n",
              "      <td>85342</td>\n",
              "      <td>３</td>\n",
              "      <td>187131</td>\n",
              "      <td>92360</td>\n",
              "      <td>94771</td>\n",
              "      <td>86589</td>\n",
              "      <td>３</td>\n",
              "      <td>189782</td>\n",
              "      <td>93682</td>\n",
              "      <td>96100</td>\n",
              "      <td>88791</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>４</td>\n",
              "      <td>179412</td>\n",
              "      <td>89096</td>\n",
              "      <td>90316</td>\n",
              "      <td>81622</td>\n",
              "      <td>４</td>\n",
              "      <td>185320</td>\n",
              "      <td>91748</td>\n",
              "      <td>93572</td>\n",
              "      <td>85224</td>\n",
              "      <td>４</td>\n",
              "      <td>187328</td>\n",
              "      <td>92467</td>\n",
              "      <td>94861</td>\n",
              "      <td>86830</td>\n",
              "      <td>４</td>\n",
              "      <td>189955</td>\n",
              "      <td>93741</td>\n",
              "      <td>96214</td>\n",
              "      <td>89019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>５</td>\n",
              "      <td>179703</td>\n",
              "      <td>89174</td>\n",
              "      <td>90529</td>\n",
              "      <td>82018</td>\n",
              "      <td>５</td>\n",
              "      <td>186039</td>\n",
              "      <td>92033</td>\n",
              "      <td>94006</td>\n",
              "      <td>85909</td>\n",
              "      <td>５</td>\n",
              "      <td>188126</td>\n",
              "      <td>92899</td>\n",
              "      <td>95227</td>\n",
              "      <td>87653</td>\n",
              "      <td>５</td>\n",
              "      <td>190847</td>\n",
              "      <td>94206</td>\n",
              "      <td>96641</td>\n",
              "      <td>89857</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>６</td>\n",
              "      <td>180012</td>\n",
              "      <td>89328</td>\n",
              "      <td>90684</td>\n",
              "      <td>82175</td>\n",
              "      <td>６</td>\n",
              "      <td>186159</td>\n",
              "      <td>92057</td>\n",
              "      <td>94102</td>\n",
              "      <td>85975</td>\n",
              "      <td>６</td>\n",
              "      <td>188286</td>\n",
              "      <td>92969</td>\n",
              "      <td>95317</td>\n",
              "      <td>87752</td>\n",
              "      <td>６</td>\n",
              "      <td>190954</td>\n",
              "      <td>94252</td>\n",
              "      <td>96702</td>\n",
              "      <td>89961</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>７</td>\n",
              "      <td>180049</td>\n",
              "      <td>89345</td>\n",
              "      <td>90704</td>\n",
              "      <td>82179</td>\n",
              "      <td>７</td>\n",
              "      <td>186206</td>\n",
              "      <td>92065</td>\n",
              "      <td>94141</td>\n",
              "      <td>85984</td>\n",
              "      <td>７</td>\n",
              "      <td>188390</td>\n",
              "      <td>93011</td>\n",
              "      <td>95379</td>\n",
              "      <td>87804</td>\n",
              "      <td>７</td>\n",
              "      <td>191067</td>\n",
              "      <td>94286</td>\n",
              "      <td>96781</td>\n",
              "      <td>90017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>８</td>\n",
              "      <td>180037</td>\n",
              "      <td>89342</td>\n",
              "      <td>90695</td>\n",
              "      <td>82194</td>\n",
              "      <td>８</td>\n",
              "      <td>186244</td>\n",
              "      <td>92071</td>\n",
              "      <td>94173</td>\n",
              "      <td>85969</td>\n",
              "      <td>８</td>\n",
              "      <td>188408</td>\n",
              "      <td>93006</td>\n",
              "      <td>95402</td>\n",
              "      <td>87777</td>\n",
              "      <td>８</td>\n",
              "      <td>191278</td>\n",
              "      <td>94390</td>\n",
              "      <td>96888</td>\n",
              "      <td>90124</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>９</td>\n",
              "      <td>180063</td>\n",
              "      <td>89354</td>\n",
              "      <td>90709</td>\n",
              "      <td>82210</td>\n",
              "      <td>９</td>\n",
              "      <td>186116</td>\n",
              "      <td>92024</td>\n",
              "      <td>94092</td>\n",
              "      <td>85900</td>\n",
              "      <td>９</td>\n",
              "      <td>188309</td>\n",
              "      <td>92965</td>\n",
              "      <td>95344</td>\n",
              "      <td>87651</td>\n",
              "      <td>９</td>\n",
              "      <td>191136</td>\n",
              "      <td>94331</td>\n",
              "      <td>96805</td>\n",
              "      <td>89992</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>10</td>\n",
              "      <td>180165</td>\n",
              "      <td>89402</td>\n",
              "      <td>90763</td>\n",
              "      <td>82256</td>\n",
              "      <td>10</td>\n",
              "      <td>186268</td>\n",
              "      <td>92072</td>\n",
              "      <td>94196</td>\n",
              "      <td>86037</td>\n",
              "      <td>10</td>\n",
              "      <td>188439</td>\n",
              "      <td>93005</td>\n",
              "      <td>95434</td>\n",
              "      <td>87834</td>\n",
              "      <td>10</td>\n",
              "      <td>191405</td>\n",
              "      <td>94489</td>\n",
              "      <td>96916</td>\n",
              "      <td>90233</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>11</td>\n",
              "      <td>180117</td>\n",
              "      <td>89369</td>\n",
              "      <td>90748</td>\n",
              "      <td>82246</td>\n",
              "      <td>11</td>\n",
              "      <td>186380</td>\n",
              "      <td>92083</td>\n",
              "      <td>94297</td>\n",
              "      <td>86112</td>\n",
              "      <td>11</td>\n",
              "      <td>188557</td>\n",
              "      <td>93057</td>\n",
              "      <td>95500</td>\n",
              "      <td>87976</td>\n",
              "      <td>11</td>\n",
              "      <td>191496</td>\n",
              "      <td>94526</td>\n",
              "      <td>96970</td>\n",
              "      <td>90269</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>12</td>\n",
              "      <td>180259</td>\n",
              "      <td>89442</td>\n",
              "      <td>90817</td>\n",
              "      <td>82293</td>\n",
              "      <td>12</td>\n",
              "      <td>186379</td>\n",
              "      <td>92063</td>\n",
              "      <td>94316</td>\n",
              "      <td>86082</td>\n",
              "      <td>12</td>\n",
              "      <td>188574</td>\n",
              "      <td>93086</td>\n",
              "      <td>95488</td>\n",
              "      <td>88004</td>\n",
              "      <td>12</td>\n",
              "      <td>191468</td>\n",
              "      <td>94528</td>\n",
              "      <td>96940</td>\n",
              "      <td>90233</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\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>NaN</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>NaN</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\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>NaN</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>NaN</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>平成24年</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>平成26年</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>平成28年</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>平成30年</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>１月</td>\n",
              "      <td>180314</td>\n",
              "      <td>89449</td>\n",
              "      <td>90865</td>\n",
              "      <td>82330</td>\n",
              "      <td>１月</td>\n",
              "      <td>186339</td>\n",
              "      <td>92041</td>\n",
              "      <td>94298</td>\n",
              "      <td>86026</td>\n",
              "      <td>１月</td>\n",
              "      <td>188609</td>\n",
              "      <td>93107</td>\n",
              "      <td>95502</td>\n",
              "      <td>88016</td>\n",
              "      <td>１月</td>\n",
              "      <td>191308</td>\n",
              "      <td>94397</td>\n",
              "      <td>96911</td>\n",
              "      <td>90166</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>２</td>\n",
              "      <td>180297</td>\n",
              "      <td>89429</td>\n",
              "      <td>90868</td>\n",
              "      <td>82318</td>\n",
              "      <td>２</td>\n",
              "      <td>186215</td>\n",
              "      <td>91990</td>\n",
              "      <td>94225</td>\n",
              "      <td>85953</td>\n",
              "      <td>２</td>\n",
              "      <td>188561</td>\n",
              "      <td>93092</td>\n",
              "      <td>95469</td>\n",
              "      <td>87973</td>\n",
              "      <td>２</td>\n",
              "      <td>191291</td>\n",
              "      <td>94360</td>\n",
              "      <td>96931</td>\n",
              "      <td>90124</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>３</td>\n",
              "      <td>180228</td>\n",
              "      <td>89398</td>\n",
              "      <td>90830</td>\n",
              "      <td>82253</td>\n",
              "      <td>３</td>\n",
              "      <td>186017</td>\n",
              "      <td>91894</td>\n",
              "      <td>94123</td>\n",
              "      <td>85818</td>\n",
              "      <td>３</td>\n",
              "      <td>188455</td>\n",
              "      <td>93071</td>\n",
              "      <td>95384</td>\n",
              "      <td>87860</td>\n",
              "      <td>３</td>\n",
              "      <td>191150</td>\n",
              "      <td>94307</td>\n",
              "      <td>96843</td>\n",
              "      <td>90015</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>４</td>\n",
              "      <td>180759</td>\n",
              "      <td>89654</td>\n",
              "      <td>91105</td>\n",
              "      <td>82528</td>\n",
              "      <td>４</td>\n",
              "      <td>185846</td>\n",
              "      <td>91793</td>\n",
              "      <td>94053</td>\n",
              "      <td>85799</td>\n",
              "      <td>４</td>\n",
              "      <td>188576</td>\n",
              "      <td>93131</td>\n",
              "      <td>95445</td>\n",
              "      <td>87987</td>\n",
              "      <td>４</td>\n",
              "      <td>191064</td>\n",
              "      <td>94174</td>\n",
              "      <td>96890</td>\n",
              "      <td>90047</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>５</td>\n",
              "      <td>181400</td>\n",
              "      <td>89894</td>\n",
              "      <td>91506</td>\n",
              "      <td>83071</td>\n",
              "      <td>５</td>\n",
              "      <td>186624</td>\n",
              "      <td>92109</td>\n",
              "      <td>94515</td>\n",
              "      <td>86548</td>\n",
              "      <td>５</td>\n",
              "      <td>189323</td>\n",
              "      <td>93428</td>\n",
              "      <td>95895</td>\n",
              "      <td>88759</td>\n",
              "      <td>５</td>\n",
              "      <td>192211</td>\n",
              "      <td>94728</td>\n",
              "      <td>97483</td>\n",
              "      <td>90952</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>６</td>\n",
              "      <td>181371</td>\n",
              "      <td>89881</td>\n",
              "      <td>91490</td>\n",
              "      <td>83069</td>\n",
              "      <td>６</td>\n",
              "      <td>186716</td>\n",
              "      <td>92095</td>\n",
              "      <td>94621</td>\n",
              "      <td>86579</td>\n",
              "      <td>６</td>\n",
              "      <td>189326</td>\n",
              "      <td>93412</td>\n",
              "      <td>95914</td>\n",
              "      <td>88749</td>\n",
              "      <td>６</td>\n",
              "      <td>192584</td>\n",
              "      <td>94884</td>\n",
              "      <td>97700</td>\n",
              "      <td>91177</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>７</td>\n",
              "      <td>181474</td>\n",
              "      <td>89928</td>\n",
              "      <td>91546</td>\n",
              "      <td>83080</td>\n",
              "      <td>７</td>\n",
              "      <td>186872</td>\n",
              "      <td>92150</td>\n",
              "      <td>94722</td>\n",
              "      <td>86664</td>\n",
              "      <td>７</td>\n",
              "      <td>189308</td>\n",
              "      <td>93389</td>\n",
              "      <td>95919</td>\n",
              "      <td>88712</td>\n",
              "      <td>７</td>\n",
              "      <td>192689</td>\n",
              "      <td>94937</td>\n",
              "      <td>97752</td>\n",
              "      <td>91214</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>８</td>\n",
              "      <td>185211</td>\n",
              "      <td>91725</td>\n",
              "      <td>93486</td>\n",
              "      <td>85391</td>\n",
              "      <td>８</td>\n",
              "      <td>186854</td>\n",
              "      <td>92142</td>\n",
              "      <td>94712</td>\n",
              "      <td>86662</td>\n",
              "      <td>８</td>\n",
              "      <td>189308</td>\n",
              "      <td>93372</td>\n",
              "      <td>95936</td>\n",
              "      <td>88687</td>\n",
              "      <td>８</td>\n",
              "      <td>192949</td>\n",
              "      <td>95084</td>\n",
              "      <td>97865</td>\n",
              "      <td>91270</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>９</td>\n",
              "      <td>185213</td>\n",
              "      <td>91736</td>\n",
              "      <td>93477</td>\n",
              "      <td>85338</td>\n",
              "      <td>９</td>\n",
              "      <td>186679</td>\n",
              "      <td>92060</td>\n",
              "      <td>94619</td>\n",
              "      <td>86454</td>\n",
              "      <td>９</td>\n",
              "      <td>189270</td>\n",
              "      <td>93401</td>\n",
              "      <td>95869</td>\n",
              "      <td>88587</td>\n",
              "      <td>９</td>\n",
              "      <td>192936</td>\n",
              "      <td>95069</td>\n",
              "      <td>97867</td>\n",
              "      <td>91165</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>10</td>\n",
              "      <td>185279</td>\n",
              "      <td>91758</td>\n",
              "      <td>93521</td>\n",
              "      <td>85472</td>\n",
              "      <td>10</td>\n",
              "      <td>186873</td>\n",
              "      <td>92195</td>\n",
              "      <td>94678</td>\n",
              "      <td>86575</td>\n",
              "      <td>10</td>\n",
              "      <td>189600</td>\n",
              "      <td>93520</td>\n",
              "      <td>96080</td>\n",
              "      <td>88822</td>\n",
              "      <td>10</td>\n",
              "      <td>193191</td>\n",
              "      <td>95147</td>\n",
              "      <td>98044</td>\n",
              "      <td>91371</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>11</td>\n",
              "      <td>185507</td>\n",
              "      <td>91872</td>\n",
              "      <td>93635</td>\n",
              "      <td>85548</td>\n",
              "      <td>11</td>\n",
              "      <td>186951</td>\n",
              "      <td>92215</td>\n",
              "      <td>94736</td>\n",
              "      <td>86621</td>\n",
              "      <td>11</td>\n",
              "      <td>189826</td>\n",
              "      <td>93651</td>\n",
              "      <td>96175</td>\n",
              "      <td>88992</td>\n",
              "      <td>11</td>\n",
              "      <td>193491</td>\n",
              "      <td>95291</td>\n",
              "      <td>98200</td>\n",
              "      <td>91590</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>12</td>\n",
              "      <td>185665</td>\n",
              "      <td>91971</td>\n",
              "      <td>93694</td>\n",
              "      <td>85586</td>\n",
              "      <td>12</td>\n",
              "      <td>186910</td>\n",
              "      <td>92220</td>\n",
              "      <td>94690</td>\n",
              "      <td>86589</td>\n",
              "      <td>12</td>\n",
              "      <td>189828</td>\n",
              "      <td>93634</td>\n",
              "      <td>96194</td>\n",
              "      <td>88966</td>\n",
              "      <td>12</td>\n",
              "      <td>193612</td>\n",
              "      <td>95331</td>\n",
              "      <td>98281</td>\n",
              "      <td>91625</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\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>NaN</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>NaN</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\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>NaN</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>NaN</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",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                    0       1      2      3   ...      16     17     18           19\n",
              "0   10．月　　別　　人　　口          NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "1                  NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "2                 年次及び    総　　数      男      女  ...    総　　数      男      女          世帯数\n",
              "3                 月　　次     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "4                  NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "5                平成23年     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "6                   １月  179728  89289  90439  ...  189885  93657  96228        88967\n",
              "7                    ２  179687  89266  90421  ...  189975  93749  96226        88993\n",
              "8                    ３  179519  89176  90343  ...  189782  93682  96100        88791\n",
              "9                    ４  179412  89096  90316  ...  189955  93741  96214        89019\n",
              "10                   ５  179703  89174  90529  ...  190847  94206  96641        89857\n",
              "11                   ６  180012  89328  90684  ...  190954  94252  96702        89961\n",
              "12                   ７  180049  89345  90704  ...  191067  94286  96781        90017\n",
              "13                   ８  180037  89342  90695  ...  191278  94390  96888        90124\n",
              "14                   ９  180063  89354  90709  ...  191136  94331  96805        89992\n",
              "15                  10  180165  89402  90763  ...  191405  94489  96916        90233\n",
              "16                  11  180117  89369  90748  ...  191496  94526  96970        90269\n",
              "17                  12  180259  89442  90817  ...  191468  94528  96940        90233\n",
              "18                 NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "19                 NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "20               平成24年     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "21                  １月  180314  89449  90865  ...  191308  94397  96911        90166\n",
              "22                   ２  180297  89429  90868  ...  191291  94360  96931        90124\n",
              "23                   ３  180228  89398  90830  ...  191150  94307  96843        90015\n",
              "24                   ４  180759  89654  91105  ...  191064  94174  96890        90047\n",
              "25                   ５  181400  89894  91506  ...  192211  94728  97483        90952\n",
              "26                   ６  181371  89881  91490  ...  192584  94884  97700        91177\n",
              "27                   ７  181474  89928  91546  ...  192689  94937  97752        91214\n",
              "28                   ８  185211  91725  93486  ...  192949  95084  97865        91270\n",
              "29                   ９  185213  91736  93477  ...  192936  95069  97867        91165\n",
              "30                  10  185279  91758  93521  ...  193191  95147  98044        91371\n",
              "31                  11  185507  91872  93635  ...  193491  95291  98200        91590\n",
              "32                  12  185665  91971  93694  ...  193612  95331  98281        91625\n",
              "33                 NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN          NaN\n",
              "34                 NaN     NaN    NaN    NaN  ...     NaN    NaN    NaN  資料：住民基本台帳人口\n",
              "\n",
              "[35 rows x 20 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    }
  ]
}