Skip to content

Instantly share code, notes, and snippets.

@shuuji3

shuuji3/2022-08-11-chiba-prefecture-covid-19-cases-by-city.ipynb

Created August 15, 2022 10:06
Show Gist options
  • Save shuuji3/190bc40ce8d1a784478d7910e138570b to your computer and use it in GitHub Desktop.
Save shuuji3/190bc40ce8d1a784478d7910e138570b to your computer and use it in GitHub Desktop.
Download ZIP
2022-08-11 chiba prefecture covid-19 cases by city.ipynb
Display the source blob
Display the rendered blob
Raw
2022-08-11-chiba-prefecture-covid-19-cases-by-city.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "2022-08-11 chiba prefecture covid-19 cases by city.ipynb",
"provenance": [],
"authorship_tag": "ABX9TyNIBDvdSg34DqTj5czeJU6x",
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
},
"language_info": {
"name": "python"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/shuuji3/190bc40ce8d1a784478d7910e138570b/2022-08-11-chiba-prefecture-covid-19-cases-by-city.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"id": "2cJHy7pYTeOb"
},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"source": [
"df = pd.read_excel('https://www.pref.chiba.lg.jp/kenfuku/kansenshou/ncov/documents/20220811shicyouson.xlsx', skiprows=4, index_col='市町村名').T\n",
"df"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 818
},
"id": "ZYrMOtqlTjAr",
"outputId": "91ef0b96-072f-4089-e8b1-b7f60d8276cc"
},
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"市町村名 千葉市 市川市 浦安市 習志野市 \\\n",
"2次医療圏 千葉 東葛南部 NaN NaN \n",
"2021-03-01 00:00:00 12.119718 17.103132 6.471616 26.848398 \n",
"2021-03-02 00:00:00 13.138182 16.499492 7.059945 28.562125 \n",
"2021-03-03 00:00:00 12.323411 16.700705 7.059945 30.847096 \n",
"2021-03-04 00:00:00 11.916026 19.517692 7.648274 30.275853 \n",
"... ... ... ... ... \n",
"2022-08-07 00:00:00 1197.099415 1038.672077 891.482435 795.566181 \n",
"2022-08-08 00:00:00 1195.771121 1025.595632 858.573393 803.516164 \n",
"2022-08-09 00:00:00 1184.736063 1054.564987 889.71945 818.848275 \n",
"2022-08-10 00:00:00 1184.940416 967.053394 789.229341 805.219732 \n",
"2022-08-11 00:00:00 1156.024477 954.379301 770.424174 716.634204 \n",
"\n",
"市町村名 八千代市 鎌ケ谷市 船橋市 柏市 \\\n",
"2次医療圏 NaN NaN NaN 東葛北部 \n",
"2021-03-01 00:00:00 6.487803 14.624961 24.005674 10.599933 \n",
"2021-03-02 00:00:00 5.489679 12.796841 22.446864 9.447767 \n",
"2021-03-03 00:00:00 6.487803 11.882781 24.317436 10.599933 \n",
"2021-03-04 00:00:00 7.984988 11.882781 23.38215 8.526033 \n",
"... ... ... ... ... \n",
"2022-08-07 00:00:00 1018.484151 970.007195 1030.318045 1139.918448 \n",
"2022-08-08 00:00:00 1048.177567 923.556147 1016.846799 1126.257025 \n",
"2022-08-09 00:00:00 1040.754213 936.307415 1008.330495 1116.531943 \n",
"2022-08-10 00:00:00 1016.50459 889.856366 984.329999 1061.42315 \n",
"2022-08-11 00:00:00 902.18494 820.635195 944.845313 1028.543113 \n",
"\n",
"市町村名 野田市 松戸市 ... 御宿町 館山市 \\\n",
"2次医療圏 NaN NaN ... NaN 安房 \n",
"2021-03-01 00:00:00 8.538083 12.381262 ... 0.0 22.36436 \n",
"2021-03-02 00:00:00 7.881308 12.990176 ... 0.0 22.36436 \n",
"2021-03-03 00:00:00 7.224532 13.599091 ... 0.0 24.600796 \n",
"2021-03-04 00:00:00 5.254205 13.802062 ... 0.0 24.600796 \n",
"... ... ... ... ... ... \n",
"2022-08-07 00:00:00 1075.381905 922.295823 ... 552.651232 778.562376 \n",
"2022-08-08 00:00:00 1150.974154 905.80111 ... 567.587752 760.456274 \n",
"2022-08-09 00:00:00 1139.799648 899.967614 ... 702.01643 923.41119 \n",
"2022-08-10 00:00:00 1117.450635 868.788584 ... 866.318148 943.780554 \n",
"2022-08-11 00:00:00 1038.571767 832.580678 ... 851.381628 893.988774 \n",
"\n",
"市町村名 鴨川市 南房総市 鋸南町 木更津市 \\\n",
"2次医療圏 NaN NaN NaN 君津 \n",
"2021-03-01 00:00:00 0.0 50.687092 0.0 0.0 \n",
"2021-03-02 00:00:00 0.0 47.871142 0.0 0.734311 \n",
"2021-03-03 00:00:00 0.0 47.871142 0.0 2.202934 \n",
"2021-03-04 00:00:00 0.0 47.871142 0.0 2.202934 \n",
"... ... ... ... ... \n",
"2022-08-07 00:00:00 1094.343235 828.961479 681.921503 1134.761149 \n",
"2022-08-08 00:00:00 1151.772326 866.641547 742.536748 1052.500147 \n",
"2022-08-09 00:00:00 1142.20081 965.189415 803.151993 1063.517245 \n",
"2022-08-10 00:00:00 1094.343235 1011.564882 863.767237 1042.217522 \n",
"2022-08-11 00:00:00 1011.390103 924.610881 742.536748 1042.951995 \n",
"\n",
"市町村名 君津市 富津市 袖ケ浦市 市原市 \n",
"2次医療圏 NaN NaN NaN 市原 \n",
"2021-03-01 00:00:00 6.142355 14.168989 9.395259 14.540953 \n",
"2021-03-02 00:00:00 6.142355 14.168989 10.961135 18.269403 \n",
"2021-03-03 00:00:00 2.456942 7.084494 9.395259 18.269403 \n",
"2021-03-04 00:00:00 3.685413 2.361498 7.829382 19.387938 \n",
"... ... ... ... ... \n",
"2022-08-07 00:00:00 1206.761835 1133.433867 1121.976166 1123.932827 \n",
"2022-08-08 00:00:00 1071.574744 1004.524006 1072.386059 1081.902618 \n",
"2022-08-09 00:00:00 1097.619963 1023.982099 1090.982349 1101.791913 \n",
"2022-08-10 00:00:00 1044.289276 951.014253 1046.041315 1092.78544 \n",
"2022-08-11 00:00:00 1020.724553 926.691638 1104.929567 1092.0349 \n",
"\n",
"[530 rows x 54 columns]"
],
"text/html": [
"\n",
" <div id=\"df-3b79f4bd-69ff-4537-8540-06a0d94164a8\">\n",
" <div class=\"colab-df-container\">\n",
" <div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>市町村名</th>\n",
" <th>千葉市</th>\n",
" <th>市川市</th>\n",
" <th>浦安市</th>\n",
" <th>習志野市</th>\n",
" <th>八千代市</th>\n",
" <th>鎌ケ谷市</th>\n",
" <th>船橋市</th>\n",
" <th>柏市</th>\n",
" <th>野田市</th>\n",
" <th>松戸市</th>\n",
" <th>...</th>\n",
" <th>御宿町</th>\n",
" <th>館山市</th>\n",
" <th>鴨川市</th>\n",
" <th>南房総市</th>\n",
" <th>鋸南町</th>\n",
" <th>木更津市</th>\n",
" <th>君津市</th>\n",
" <th>富津市</th>\n",
" <th>袖ケ浦市</th>\n",
" <th>市原市</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2次医療圏</th>\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>NaN</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>君津</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>市原</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-03-01 00:00:00</th>\n",
" <td>12.119718</td>\n",
" <td>17.103132</td>\n",
" <td>6.471616</td>\n",
" <td>26.848398</td>\n",
" <td>6.487803</td>\n",
" <td>14.624961</td>\n",
" <td>24.005674</td>\n",
" <td>10.599933</td>\n",
" <td>8.538083</td>\n",
" <td>12.381262</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>22.36436</td>\n",
" <td>0.0</td>\n",
" <td>50.687092</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>6.142355</td>\n",
" <td>14.168989</td>\n",
" <td>9.395259</td>\n",
" <td>14.540953</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-03-02 00:00:00</th>\n",
" <td>13.138182</td>\n",
" <td>16.499492</td>\n",
" <td>7.059945</td>\n",
" <td>28.562125</td>\n",
" <td>5.489679</td>\n",
" <td>12.796841</td>\n",
" <td>22.446864</td>\n",
" <td>9.447767</td>\n",
" <td>7.881308</td>\n",
" <td>12.990176</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>22.36436</td>\n",
" <td>0.0</td>\n",
" <td>47.871142</td>\n",
" <td>0.0</td>\n",
" <td>0.734311</td>\n",
" <td>6.142355</td>\n",
" <td>14.168989</td>\n",
" <td>10.961135</td>\n",
" <td>18.269403</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-03-03 00:00:00</th>\n",
" <td>12.323411</td>\n",
" <td>16.700705</td>\n",
" <td>7.059945</td>\n",
" <td>30.847096</td>\n",
" <td>6.487803</td>\n",
" <td>11.882781</td>\n",
" <td>24.317436</td>\n",
" <td>10.599933</td>\n",
" <td>7.224532</td>\n",
" <td>13.599091</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>24.600796</td>\n",
" <td>0.0</td>\n",
" <td>47.871142</td>\n",
" <td>0.0</td>\n",
" <td>2.202934</td>\n",
" <td>2.456942</td>\n",
" <td>7.084494</td>\n",
" <td>9.395259</td>\n",
" <td>18.269403</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-03-04 00:00:00</th>\n",
" <td>11.916026</td>\n",
" <td>19.517692</td>\n",
" <td>7.648274</td>\n",
" <td>30.275853</td>\n",
" <td>7.984988</td>\n",
" <td>11.882781</td>\n",
" <td>23.38215</td>\n",
" <td>8.526033</td>\n",
" <td>5.254205</td>\n",
" <td>13.802062</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>24.600796</td>\n",
" <td>0.0</td>\n",
" <td>47.871142</td>\n",
" <td>0.0</td>\n",
" <td>2.202934</td>\n",
" <td>3.685413</td>\n",
" <td>2.361498</td>\n",
" <td>7.829382</td>\n",
" <td>19.387938</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2022-08-07 00:00:00</th>\n",
" <td>1197.099415</td>\n",
" <td>1038.672077</td>\n",
" <td>891.482435</td>\n",
" <td>795.566181</td>\n",
" <td>1018.484151</td>\n",
" <td>970.007195</td>\n",
" <td>1030.318045</td>\n",
" <td>1139.918448</td>\n",
" <td>1075.381905</td>\n",
" <td>922.295823</td>\n",
" <td>...</td>\n",
" <td>552.651232</td>\n",
" <td>778.562376</td>\n",
" <td>1094.343235</td>\n",
" <td>828.961479</td>\n",
" <td>681.921503</td>\n",
" <td>1134.761149</td>\n",
" <td>1206.761835</td>\n",
" <td>1133.433867</td>\n",
" <td>1121.976166</td>\n",
" <td>1123.932827</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2022-08-08 00:00:00</th>\n",
" <td>1195.771121</td>\n",
" <td>1025.595632</td>\n",
" <td>858.573393</td>\n",
" <td>803.516164</td>\n",
" <td>1048.177567</td>\n",
" <td>923.556147</td>\n",
" <td>1016.846799</td>\n",
" <td>1126.257025</td>\n",
" <td>1150.974154</td>\n",
" <td>905.80111</td>\n",
" <td>...</td>\n",
" <td>567.587752</td>\n",
" <td>760.456274</td>\n",
" <td>1151.772326</td>\n",
" <td>866.641547</td>\n",
" <td>742.536748</td>\n",
" <td>1052.500147</td>\n",
" <td>1071.574744</td>\n",
" <td>1004.524006</td>\n",
" <td>1072.386059</td>\n",
" <td>1081.902618</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2022-08-09 00:00:00</th>\n",
" <td>1184.736063</td>\n",
" <td>1054.564987</td>\n",
" <td>889.71945</td>\n",
" <td>818.848275</td>\n",
" <td>1040.754213</td>\n",
" <td>936.307415</td>\n",
" <td>1008.330495</td>\n",
" <td>1116.531943</td>\n",
" <td>1139.799648</td>\n",
" <td>899.967614</td>\n",
" <td>...</td>\n",
" <td>702.01643</td>\n",
" <td>923.41119</td>\n",
" <td>1142.20081</td>\n",
" <td>965.189415</td>\n",
" <td>803.151993</td>\n",
" <td>1063.517245</td>\n",
" <td>1097.619963</td>\n",
" <td>1023.982099</td>\n",
" <td>1090.982349</td>\n",
" <td>1101.791913</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2022-08-10 00:00:00</th>\n",
" <td>1184.940416</td>\n",
" <td>967.053394</td>\n",
" <td>789.229341</td>\n",
" <td>805.219732</td>\n",
" <td>1016.50459</td>\n",
" <td>889.856366</td>\n",
" <td>984.329999</td>\n",
" <td>1061.42315</td>\n",
" <td>1117.450635</td>\n",
" <td>868.788584</td>\n",
" <td>...</td>\n",
" <td>866.318148</td>\n",
" <td>943.780554</td>\n",
" <td>1094.343235</td>\n",
" <td>1011.564882</td>\n",
" <td>863.767237</td>\n",
" <td>1042.217522</td>\n",
" <td>1044.289276</td>\n",
" <td>951.014253</td>\n",
" <td>1046.041315</td>\n",
" <td>1092.78544</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2022-08-11 00:00:00</th>\n",
" <td>1156.024477</td>\n",
" <td>954.379301</td>\n",
" <td>770.424174</td>\n",
" <td>716.634204</td>\n",
" <td>902.18494</td>\n",
" <td>820.635195</td>\n",
" <td>944.845313</td>\n",
" <td>1028.543113</td>\n",
" <td>1038.571767</td>\n",
" <td>832.580678</td>\n",
" <td>...</td>\n",
" <td>851.381628</td>\n",
" <td>893.988774</td>\n",
" <td>1011.390103</td>\n",
" <td>924.610881</td>\n",
" <td>742.536748</td>\n",
" <td>1042.951995</td>\n",
" <td>1020.724553</td>\n",
" <td>926.691638</td>\n",
" <td>1104.929567</td>\n",
" <td>1092.0349</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>530 rows × 54 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3b79f4bd-69ff-4537-8540-06a0d94164a8')\"\n",
" title=\"Convert this dataframe to an interactive table.\"\n",
" style=\"display:none;\">\n",
" \n",
" <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
" width=\"24px\">\n",
" <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
" <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
" </svg>\n",
" </button>\n",
" \n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\n",
" flex-wrap:wrap;\n",
" gap: 12px;\n",
" }\n",
"\n",
" .colab-df-convert {\n",
" background-color: #E8F0FE;\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: #1967D2;\n",
" height: 32px;\n",
" padding: 0 0 0 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-convert:hover {\n",
" background-color: #E2EBFA;\n",
" box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: #174EA6;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert {\n",
" background-color: #3B4455;\n",
" fill: #D2E3FC;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert:hover {\n",
" background-color: #434B5C;\n",
" box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
" filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
" fill: #FFFFFF;\n",
" }\n",
" </style>\n",
"\n",
" <script>\n",
" const buttonEl =\n",
" document.querySelector('#df-3b79f4bd-69ff-4537-8540-06a0d94164a8 button.colab-df-convert');\n",
" buttonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
"\n",
" async function convertToInteractive(key) {\n",
" const element = document.querySelector('#df-3b79f4bd-69ff-4537-8540-06a0d94164a8');\n",
" const dataTable =\n",
" await google.colab.kernel.invokeFunction('convertToInteractive',\n",
" [key], {});\n",
" if (!dataTable) return;\n",
"\n",
" const docLinkHtml = 'Like what you see? Visit the ' +\n",
" '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
" + ' to learn more about interactive tables.';\n",
" element.innerHTML = '';\n",
" dataTable['output_type'] = 'display_data';\n",
" await google.colab.output.renderOutput(dataTable, element);\n",
" const docLink = document.createElement('div');\n",
" docLink.innerHTML = docLinkHtml;\n",
" element.appendChild(docLink);\n",
" }\n",
" </script>\n",
" </div>\n",
" </div>\n",
" "
]
},
"metadata": {},
"execution_count": 19
}
]
},
{
"cell_type": "code",
"source": [
""
],
"metadata": {
"id": "9vhoXuIkTplw"
},
"execution_count": null,
"outputs": []
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment