kunitaka_data_analyse.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "kunitaka-data_analyse.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyMM/gpPXKyx9YgjASjmSwkp",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/imabari/ImabariScraping/blob/master/kunitaka_data_analyse.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "IgIytGZHgn01"
      },
      "outputs": [],
      "source": [
        "import pandas as pd"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "pd.set_option(\"display.max_columns\", None)"
      ],
      "metadata": {
        "id": "0a4J21CuguDQ"
      },
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv(\"accidents_fukui.csv\")"
      ],
      "metadata": {
        "id": "nDpn0RA4guGH"
      },
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "pNvbSUpiguIy",
        "outputId": "d9753a9b-f67a-401e-fdb7-803e5dbd865e"
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "     資料区分 都道府県コード    警察署等コード  本票番号 事故内容  死者数  負傷者数          路線コード  上下線  地点コード  \\\n",
              "0      本票      福井  高速道路交通警察隊     1   負傷    0     1    中部縦貫自動車道 上り    下     59   \n",
              "1      本票      福井  高速道路交通警察隊     2   負傷    0     1      北陸自動車道 上り    上    446   \n",
              "2      本票      福井  高速道路交通警察隊     3   負傷    0     2  近畿自動車道 敦賀線 上り    上   1562   \n",
              "3      本票      福井  高速道路交通警察隊     4   負傷    0     2  近畿自動車道 敦賀線 上り    上   1562   \n",
              "4      本票      福井  高速道路交通警察隊     5   負傷    0     2  近畿自動車道 敦賀線 上り    上   1562   \n",
              "...   ...     ...        ...   ...  ...  ...   ...            ...  ...    ...   \n",
              "2943   本票      福井        福井南   130   負傷    0     1  一般都道府県道 21540  対象外      0   \n",
              "2944   本票      福井        福井南   131   負傷    0     1          国道8号線    下   4142   \n",
              "2945   本票      福井        福井南   132   負傷    0     1  一般都道府県道 21540  対象外      0   \n",
              "2946   本票      福井        福井南   133   負傷    0     1          国道8号線    下      0   \n",
              "2947   本票      福井        福井南   134   負傷    0     1    都道府県道 10380  対象外      0   \n",
              "\n",
              "      市区町村コード   昼夜 天候       地形   路面状態     道路形状             環状交差点の直径     信号機  \\\n",
              "0         322  夜－暮  曇     非市街地  舗装－凍結   単路－その他  環状交差点以外 環状交差点以外をいう。    施設なし   \n",
              "1         202  昼－昼  曇     非市街地  舗装－乾燥  単路－トンネル  環状交差点以外 環状交差点以外をいう。    施設なし   \n",
              "2         202  夜－夜  雪     非市街地  舗装－積雪   単路－その他  環状交差点以外 環状交差点以外をいう。    施設なし   \n",
              "3         202  夜－夜  雪     非市街地  舗装－積雪   単路－その他  環状交差点以外 環状交差点以外をいう。    施設なし   \n",
              "4         202  夜－夜  雪     非市街地  舗装－積雪   単路－その他  環状交差点以外 環状交差点以外をいう。    施設なし   \n",
              "...       ...  ... ..      ...    ...      ...                  ...     ...   \n",
              "2943      201  昼－昼  雨     非市街地  舗装－乾燥   単路－その他  環状交差点以外 環状交差点以外をいう。    施設なし   \n",
              "2944      201  夜－夜  雪     非市街地  舗装－湿潤   単路－その他  環状交差点以外 環状交差点以外をいう。    施設なし   \n",
              "2945      201  夜－暮  雨  市街地－その他  舗装－湿潤   単路－その他  環状交差点以外 環状交差点以外をいう。    施設なし   \n",
              "2946      201  夜－夜  雨  市街地－その他  舗装－湿潤  交差点－その他  環状交差点以外 環状交差点以外をいう。  点灯－３灯式   \n",
              "2947      201  昼－昼  雪     非市街地  舗装－湿潤  交差点－その他  環状交差点以外 環状交差点以外をいう。    施設なし   \n",
              "\n",
              "     一時停止規制　標識（当事者A） 一時停止規制　表示（当事者A） 一時停止規制　標識（当事者B） 一時停止規制　表示（当事者B）  \\\n",
              "0             対象外当事者             その他          対象外当事者             その他   \n",
              "1             対象外当事者             その他          対象外当事者             その他   \n",
              "2             対象外当事者             その他          対象外当事者             その他   \n",
              "3             対象外当事者             その他          対象外当事者             その他   \n",
              "4             対象外当事者             その他          対象外当事者             その他   \n",
              "...              ...             ...             ...             ...   \n",
              "2943          対象外当事者             その他          対象外当事者             その他   \n",
              "2944          対象外当事者             その他          対象外当事者             その他   \n",
              "2945          対象外当事者             その他          対象外当事者             その他   \n",
              "2946            規制なし            表示なし            規制なし            表示なし   \n",
              "2947          標準－反射式            表示あり            規制なし            表示なし   \n",
              "\n",
              "                  車道幅員   道路線形          衝突地点 ゾーン規制    中央分離帯施設等          歩車道区分  \\\n",
              "0            単路－9.0m以上  直線－平坦  単路（交差点付近を含む）  規制なし  中央線－ポストコーン           区分なし   \n",
              "1           単路－13.0m以上  直線－平坦  単路（交差点付近を含む）  規制なし       中央分離帯           区分なし   \n",
              "2            単路－5.5m以上  直線－平坦  単路（交差点付近を含む）  規制なし  中央線－ポストコーン           区分なし   \n",
              "3            単路－5.5m以上  直線－平坦  単路（交差点付近を含む）  規制なし  中央線－ポストコーン           区分なし   \n",
              "4            単路－5.5m以上  直線－平坦  単路（交差点付近を含む）  規制なし  中央線－ポストコーン           区分なし   \n",
              "...                ...    ...           ...   ...         ...            ...   \n",
              "2943         単路－9.0m以上  直線－平坦  単路（交差点付近を含む）  規制なし    中央線－ペイント       区分あり－路側帯   \n",
              "2944        単路－13.0m以上  直線－平坦  単路（交差点付近を含む）  規制なし       中央分離帯  区分あり－縁石・ブロック等   \n",
              "2945         単路－9.0m以上  直線－平坦  単路（交差点付近を含む）  規制なし    中央線－ペイント  区分あり－縁石・ブロック等   \n",
              "2946  交差点－大（13.0ｍ以上）－大  直線－平坦          交差点内  規制なし      中央分離なし  区分あり－縁石・ブロック等   \n",
              "2947   交差点－中（5.5m以上）－中  直線－平坦          交差点内  規制なし    中央線－ペイント  区分あり－縁石・ブロック等   \n",
              "\n",
              "      事故類型 年齢（当事者A） 年齢（当事者B） 当事者種別（当事者A） 当事者種別（当事者B） 用途別（当事者A） 用途別（当事者B）  \\\n",
              "0     車両相互   55～64歳   25～34歳     乗用車－普通車     乗用車－普通車       自家用       自家用   \n",
              "1     車両相互    0～24歳   45～54歳     乗用車－普通車    乗用車－軽自動車       自家用       自家用   \n",
              "2     車両単独   45～54歳       不明     乗用車－普通車         物件等       自家用    対象外当事者   \n",
              "3     車両単独    0～24歳       不明     乗用車－普通車         物件等       自家用    対象外当事者   \n",
              "4     車両単独   25～34歳       不明    乗用車－軽自動車         物件等       自家用    対象外当事者   \n",
              "...    ...      ...      ...         ...         ...       ...       ...   \n",
              "2943  車両相互   25～34歳   35～44歳     乗用車－普通車     乗用車－普通車       自家用       自家用   \n",
              "2944  車両相互   55～64歳   25～34歳     貨物車－大型車     乗用車－普通車       事業用       自家用   \n",
              "2945  車両相互    0～24歳   45～54歳     乗用車－普通車     乗用車－普通車       自家用       自家用   \n",
              "2946  車両相互   55～64歳    0～24歳     貨物車－大型車    乗用車－軽自動車       事業用       自家用   \n",
              "2947  車両相互   55～64歳   25～34歳    貨物車－準中型車    乗用車－軽自動車       自家用       自家用   \n",
              "\n",
              "     車両形状（当事者A） 車両形状（当事者B） 速度規制（指定のみ）（当事者A） 速度規制（指定のみ）（当事者B） 車両の衝突部位（当事者A）  \\\n",
              "0           乗用車        乗用車          50㎞／ｈ以下          50㎞／ｈ以下           前-無   \n",
              "1           乗用車        乗用車          50㎞／ｈ以下          50㎞／ｈ以下           後-無   \n",
              "2           乗用車     対象外当事者          50㎞／ｈ以下           対象外当事者          右前-無   \n",
              "3           乗用車     対象外当事者          50㎞／ｈ以下           対象外当事者           前-無   \n",
              "4           乗用車     対象外当事者          50㎞／ｈ以下           対象外当事者          右前-無   \n",
              "...         ...        ...              ...              ...           ...   \n",
              "2943        乗用車        乗用車          50㎞／ｈ以下          50㎞／ｈ以下           前-無   \n",
              "2944        貨物車        乗用車       指定の速度規制なし等       指定の速度規制なし等          左前-無   \n",
              "2945        乗用車        乗用車          50㎞／ｈ以下          50㎞／ｈ以下           前-無   \n",
              "2946        貨物車        乗用車       指定の速度規制なし等       指定の速度規制なし等          右前-無   \n",
              "2947        貨物車        乗用車       指定の速度規制なし等       指定の速度規制なし等           前-無   \n",
              "\n",
              "     車両の衝突部位（当事者B） 車両の損壊程度（当事者A） 車両の損壊程度（当事者B） エアバッグの装備（当事者A） エアバッグの装備（当事者B）  \\\n",
              "0              後-無            小破            小破            その他            その他   \n",
              "1              前-無            小破            小破            その他            その他   \n",
              "2              無-無            大破        対象外当事者            その他         対象外当事者   \n",
              "3              無-無            大破        対象外当事者            その他         対象外当事者   \n",
              "4              無-無            中破        対象外当事者            その他         対象外当事者   \n",
              "...            ...           ...           ...            ...            ...   \n",
              "2943           後-無            小破            小破            その他            その他   \n",
              "2944           右-無            小破            小破            その他            その他   \n",
              "2945           後-無            小破            小破            その他            その他   \n",
              "2946          右前-無            小破            小破            その他        装備あり 作動   \n",
              "2947           左-無            中破            中破            その他        装備あり 作動   \n",
              "\n",
              "     サイドエアバッグの装備（当事者A） サイドエアバッグの装備（当事者B） 人身損傷程度（当事者A） 人身損傷程度（当事者B） 曜日(発生年月日)  \\\n",
              "0                  その他               その他         損傷なし           負傷         金   \n",
              "1                  その他               その他           負傷         損傷なし         木   \n",
              "2                  その他            対象外当事者           負傷       対象外当事者         木   \n",
              "3                  その他            対象外当事者         損傷なし       対象外当事者         木   \n",
              "4                  その他            対象外当事者           負傷       対象外当事者         木   \n",
              "...                ...               ...          ...          ...       ...   \n",
              "2943               その他               その他         損傷なし           負傷         月   \n",
              "2944               その他               その他         損傷なし         損傷なし         金   \n",
              "2945               その他               その他         損傷なし           負傷         水   \n",
              "2946               その他               その他         損傷なし           負傷         日   \n",
              "2947               その他               その他         損傷なし           負傷         木   \n",
              "\n",
              "     祝日(発生年月日)    発生地点  道路管理者区分        道路区分       道路構造 曲線半径     縦断勾配 トンネル番号  \\\n",
              "0          その他    59.0    国土交通省  走行車線－第一通行帯    非分離－その他   直線  平坦・該当なし    NaN   \n",
              "1          その他   446.0  中日本高速道路        追越車線  完全分離－トンネル   直線  平坦－１％以上     小河   \n",
              "2          その他  1562.0  中日本高速道路  走行車線－第一通行帯    非分離－その他   直線  平坦・該当なし    NaN   \n",
              "3          その他  1562.0  中日本高速道路  走行車線－第一通行帯    非分離－その他   直線  平坦・該当なし    NaN   \n",
              "4          その他  1562.0  中日本高速道路  走行車線－第一通行帯    非分離－その他   直線  平坦・該当なし    NaN   \n",
              "...        ...     ...      ...         ...        ...  ...      ...    ...   \n",
              "2943       その他     NaN      NaN         NaN        NaN  NaN      NaN    NaN   \n",
              "2944       その他     NaN      NaN         NaN        NaN  NaN      NaN    NaN   \n",
              "2945       その他     NaN      NaN         NaN        NaN  NaN      NaN    NaN   \n",
              "2946       その他     NaN      NaN         NaN        NaN  NaN      NaN    NaN   \n",
              "2947       その他     NaN      NaN         NaN        NaN  NaN      NaN    NaN   \n",
              "\n",
              "      当事者車両台数 車両単独事故の対象物 臨時速度規制の有無 速度規制（臨時のみ）  トンネル延長距離         緯度  \\\n",
              "0         2.0       該当なし    あり－その他    50㎞/h以下       0.0  36.079816   \n",
              "1         2.0       該当なし   あり－異常気象    50㎞/h以下    1125.0  35.627717   \n",
              "2         1.0        その他   あり－異常気象    50㎞/h以下       0.0  35.601432   \n",
              "3         1.0        その他   あり－異常気象    50㎞/h以下       0.0  35.601379   \n",
              "4         1.0        その他   あり－異常気象    50㎞/h以下       0.0  35.614034   \n",
              "...       ...        ...       ...        ...       ...        ...   \n",
              "2943      NaN        NaN       NaN        NaN       NaN  36.011538   \n",
              "2944      NaN        NaN       NaN        NaN       NaN  36.021347   \n",
              "2945      NaN        NaN       NaN        NaN       NaN  36.001785   \n",
              "2946      NaN        NaN       NaN        NaN       NaN  36.038293   \n",
              "2947      NaN        NaN       NaN        NaN       NaN  36.008103   \n",
              "\n",
              "              経度         発生日    発生時 color  \n",
              "0     136.362783  2018-12-28  17:45  blue  \n",
              "1     136.095899  2019-01-03  12:23  blue  \n",
              "2     136.054062  2019-01-03  05:40  blue  \n",
              "3     136.054230  2019-01-03  05:45  blue  \n",
              "4     135.995511  2019-01-03  05:46  blue  \n",
              "...          ...         ...    ...   ...  \n",
              "2943  136.203273  2021-12-13  12:02  blue  \n",
              "2944  136.215062  2021-12-17  19:33  blue  \n",
              "2945  136.198495  2021-12-01  17:36  blue  \n",
              "2946  136.230048  2021-12-19  19:30  blue  \n",
              "2947  136.225824  2021-12-30  11:35  blue  \n",
              "\n",
              "[2948 rows x 68 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5484db5d-8958-4897-aa15-06c4e99a1f66\">\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>一時停止規制　標識（当事者A）</th>\n",
              "      <th>一時停止規制　表示（当事者A）</th>\n",
              "      <th>一時停止規制　標識（当事者B）</th>\n",
              "      <th>一時停止規制　表示（当事者B）</th>\n",
              "      <th>車道幅員</th>\n",
              "      <th>道路線形</th>\n",
              "      <th>衝突地点</th>\n",
              "      <th>ゾーン規制</th>\n",
              "      <th>中央分離帯施設等</th>\n",
              "      <th>歩車道区分</th>\n",
              "      <th>事故類型</th>\n",
              "      <th>年齢（当事者A）</th>\n",
              "      <th>年齢（当事者B）</th>\n",
              "      <th>当事者種別（当事者A）</th>\n",
              "      <th>当事者種別（当事者B）</th>\n",
              "      <th>用途別（当事者A）</th>\n",
              "      <th>用途別（当事者B）</th>\n",
              "      <th>車両形状（当事者A）</th>\n",
              "      <th>車両形状（当事者B）</th>\n",
              "      <th>速度規制（指定のみ）（当事者A）</th>\n",
              "      <th>速度規制（指定のみ）（当事者B）</th>\n",
              "      <th>車両の衝突部位（当事者A）</th>\n",
              "      <th>車両の衝突部位（当事者B）</th>\n",
              "      <th>車両の損壊程度（当事者A）</th>\n",
              "      <th>車両の損壊程度（当事者B）</th>\n",
              "      <th>エアバッグの装備（当事者A）</th>\n",
              "      <th>エアバッグの装備（当事者B）</th>\n",
              "      <th>サイドエアバッグの装備（当事者A）</th>\n",
              "      <th>サイドエアバッグの装備（当事者B）</th>\n",
              "      <th>人身損傷程度（当事者A）</th>\n",
              "      <th>人身損傷程度（当事者B）</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>color</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>本票</td>\n",
              "      <td>福井</td>\n",
              "      <td>高速道路交通警察隊</td>\n",
              "      <td>1</td>\n",
              "      <td>負傷</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>中部縦貫自動車道 上り</td>\n",
              "      <td>下</td>\n",
              "      <td>59</td>\n",
              "      <td>322</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>単路－9.0m以上</td>\n",
              "      <td>直線－平坦</td>\n",
              "      <td>単路（交差点付近を含む）</td>\n",
              "      <td>規制なし</td>\n",
              "      <td>中央線－ポストコーン</td>\n",
              "      <td>区分なし</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>25～34歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>自家用</td>\n",
              "      <td>自家用</td>\n",
              "      <td>乗用車</td>\n",
              "      <td>乗用車</td>\n",
              "      <td>50㎞／ｈ以下</td>\n",
              "      <td>50㎞／ｈ以下</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>59.0</td>\n",
              "      <td>国土交通省</td>\n",
              "      <td>走行車線－第一通行帯</td>\n",
              "      <td>非分離－その他</td>\n",
              "      <td>直線</td>\n",
              "      <td>平坦・該当なし</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>該当なし</td>\n",
              "      <td>あり－その他</td>\n",
              "      <td>50㎞/h以下</td>\n",
              "      <td>0.0</td>\n",
              "      <td>36.079816</td>\n",
              "      <td>136.362783</td>\n",
              "      <td>2018-12-28</td>\n",
              "      <td>17:45</td>\n",
              "      <td>blue</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>本票</td>\n",
              "      <td>福井</td>\n",
              "      <td>高速道路交通警察隊</td>\n",
              "      <td>2</td>\n",
              "      <td>負傷</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>北陸自動車道 上り</td>\n",
              "      <td>上</td>\n",
              "      <td>446</td>\n",
              "      <td>202</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>単路－13.0m以上</td>\n",
              "      <td>直線－平坦</td>\n",
              "      <td>単路（交差点付近を含む）</td>\n",
              "      <td>規制なし</td>\n",
              "      <td>中央分離帯</td>\n",
              "      <td>区分なし</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>自家用</td>\n",
              "      <td>自家用</td>\n",
              "      <td>乗用車</td>\n",
              "      <td>乗用車</td>\n",
              "      <td>50㎞／ｈ以下</td>\n",
              "      <td>50㎞／ｈ以下</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>446.0</td>\n",
              "      <td>中日本高速道路</td>\n",
              "      <td>追越車線</td>\n",
              "      <td>完全分離－トンネル</td>\n",
              "      <td>直線</td>\n",
              "      <td>平坦－１％以上</td>\n",
              "      <td>小河</td>\n",
              "      <td>2.0</td>\n",
              "      <td>該当なし</td>\n",
              "      <td>あり－異常気象</td>\n",
              "      <td>50㎞/h以下</td>\n",
              "      <td>1125.0</td>\n",
              "      <td>35.627717</td>\n",
              "      <td>136.095899</td>\n",
              "      <td>2019-01-03</td>\n",
              "      <td>12:23</td>\n",
              "      <td>blue</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>本票</td>\n",
              "      <td>福井</td>\n",
              "      <td>高速道路交通警察隊</td>\n",
              "      <td>3</td>\n",
              "      <td>負傷</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>近畿自動車道 敦賀線 上り</td>\n",
              "      <td>上</td>\n",
              "      <td>1562</td>\n",
              "      <td>202</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>単路－5.5m以上</td>\n",
              "      <td>直線－平坦</td>\n",
              "      <td>単路（交差点付近を含む）</td>\n",
              "      <td>規制なし</td>\n",
              "      <td>中央線－ポストコーン</td>\n",
              "      <td>区分なし</td>\n",
              "      <td>車両単独</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>不明</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>物件等</td>\n",
              "      <td>自家用</td>\n",
              "      <td>対象外当事者</td>\n",
              "      <td>乗用車</td>\n",
              "      <td>対象外当事者</td>\n",
              "      <td>50㎞／ｈ以下</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>1562.0</td>\n",
              "      <td>中日本高速道路</td>\n",
              "      <td>走行車線－第一通行帯</td>\n",
              "      <td>非分離－その他</td>\n",
              "      <td>直線</td>\n",
              "      <td>平坦・該当なし</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>その他</td>\n",
              "      <td>あり－異常気象</td>\n",
              "      <td>50㎞/h以下</td>\n",
              "      <td>0.0</td>\n",
              "      <td>35.601432</td>\n",
              "      <td>136.054062</td>\n",
              "      <td>2019-01-03</td>\n",
              "      <td>05:40</td>\n",
              "      <td>blue</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>本票</td>\n",
              "      <td>福井</td>\n",
              "      <td>高速道路交通警察隊</td>\n",
              "      <td>4</td>\n",
              "      <td>負傷</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>近畿自動車道 敦賀線 上り</td>\n",
              "      <td>上</td>\n",
              "      <td>1562</td>\n",
              "      <td>202</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>単路－5.5m以上</td>\n",
              "      <td>直線－平坦</td>\n",
              "      <td>単路（交差点付近を含む）</td>\n",
              "      <td>規制なし</td>\n",
              "      <td>中央線－ポストコーン</td>\n",
              "      <td>区分なし</td>\n",
              "      <td>車両単独</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>不明</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>物件等</td>\n",
              "      <td>自家用</td>\n",
              "      <td>対象外当事者</td>\n",
              "      <td>乗用車</td>\n",
              "      <td>対象外当事者</td>\n",
              "      <td>50㎞／ｈ以下</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>1562.0</td>\n",
              "      <td>中日本高速道路</td>\n",
              "      <td>走行車線－第一通行帯</td>\n",
              "      <td>非分離－その他</td>\n",
              "      <td>直線</td>\n",
              "      <td>平坦・該当なし</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>その他</td>\n",
              "      <td>あり－異常気象</td>\n",
              "      <td>50㎞/h以下</td>\n",
              "      <td>0.0</td>\n",
              "      <td>35.601379</td>\n",
              "      <td>136.054230</td>\n",
              "      <td>2019-01-03</td>\n",
              "      <td>05:45</td>\n",
              "      <td>blue</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>本票</td>\n",
              "      <td>福井</td>\n",
              "      <td>高速道路交通警察隊</td>\n",
              "      <td>5</td>\n",
              "      <td>負傷</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>近畿自動車道 敦賀線 上り</td>\n",
              "      <td>上</td>\n",
              "      <td>1562</td>\n",
              "      <td>202</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>単路－5.5m以上</td>\n",
              "      <td>直線－平坦</td>\n",
              "      <td>単路（交差点付近を含む）</td>\n",
              "      <td>規制なし</td>\n",
              "      <td>中央線－ポストコーン</td>\n",
              "      <td>区分なし</td>\n",
              "      <td>車両単独</td>\n",
              "      <td>25～34歳</td>\n",
              "      <td>不明</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>物件等</td>\n",
              "      <td>自家用</td>\n",
              "      <td>対象外当事者</td>\n",
              "      <td>乗用車</td>\n",
              "      <td>対象外当事者</td>\n",
              "      <td>50㎞／ｈ以下</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>1562.0</td>\n",
              "      <td>中日本高速道路</td>\n",
              "      <td>走行車線－第一通行帯</td>\n",
              "      <td>非分離－その他</td>\n",
              "      <td>直線</td>\n",
              "      <td>平坦・該当なし</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>その他</td>\n",
              "      <td>あり－異常気象</td>\n",
              "      <td>50㎞/h以下</td>\n",
              "      <td>0.0</td>\n",
              "      <td>35.614034</td>\n",
              "      <td>135.995511</td>\n",
              "      <td>2019-01-03</td>\n",
              "      <td>05:46</td>\n",
              "      <td>blue</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2943</th>\n",
              "      <td>本票</td>\n",
              "      <td>福井</td>\n",
              "      <td>福井南</td>\n",
              "      <td>130</td>\n",
              "      <td>負傷</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>一般都道府県道 21540</td>\n",
              "      <td>対象外</td>\n",
              "      <td>0</td>\n",
              "      <td>201</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>単路－9.0m以上</td>\n",
              "      <td>直線－平坦</td>\n",
              "      <td>単路（交差点付近を含む）</td>\n",
              "      <td>規制なし</td>\n",
              "      <td>中央線－ペイント</td>\n",
              "      <td>区分あり－路側帯</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>25～34歳</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>自家用</td>\n",
              "      <td>自家用</td>\n",
              "      <td>乗用車</td>\n",
              "      <td>乗用車</td>\n",
              "      <td>50㎞／ｈ以下</td>\n",
              "      <td>50㎞／ｈ以下</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>36.011538</td>\n",
              "      <td>136.203273</td>\n",
              "      <td>2021-12-13</td>\n",
              "      <td>12:02</td>\n",
              "      <td>blue</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2944</th>\n",
              "      <td>本票</td>\n",
              "      <td>福井</td>\n",
              "      <td>福井南</td>\n",
              "      <td>131</td>\n",
              "      <td>負傷</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>国道8号線</td>\n",
              "      <td>下</td>\n",
              "      <td>4142</td>\n",
              "      <td>201</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>単路－13.0m以上</td>\n",
              "      <td>直線－平坦</td>\n",
              "      <td>単路（交差点付近を含む）</td>\n",
              "      <td>規制なし</td>\n",
              "      <td>中央分離帯</td>\n",
              "      <td>区分あり－縁石・ブロック等</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>25～34歳</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>36.021347</td>\n",
              "      <td>136.215062</td>\n",
              "      <td>2021-12-17</td>\n",
              "      <td>19:33</td>\n",
              "      <td>blue</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2945</th>\n",
              "      <td>本票</td>\n",
              "      <td>福井</td>\n",
              "      <td>福井南</td>\n",
              "      <td>132</td>\n",
              "      <td>負傷</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>一般都道府県道 21540</td>\n",
              "      <td>対象外</td>\n",
              "      <td>0</td>\n",
              "      <td>201</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>単路－9.0m以上</td>\n",
              "      <td>直線－平坦</td>\n",
              "      <td>単路（交差点付近を含む）</td>\n",
              "      <td>規制なし</td>\n",
              "      <td>中央線－ペイント</td>\n",
              "      <td>区分あり－縁石・ブロック等</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>自家用</td>\n",
              "      <td>自家用</td>\n",
              "      <td>乗用車</td>\n",
              "      <td>乗用車</td>\n",
              "      <td>50㎞／ｈ以下</td>\n",
              "      <td>50㎞／ｈ以下</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>36.001785</td>\n",
              "      <td>136.198495</td>\n",
              "      <td>2021-12-01</td>\n",
              "      <td>17:36</td>\n",
              "      <td>blue</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2946</th>\n",
              "      <td>本票</td>\n",
              "      <td>福井</td>\n",
              "      <td>福井南</td>\n",
              "      <td>133</td>\n",
              "      <td>負傷</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>国道8号線</td>\n",
              "      <td>下</td>\n",
              "      <td>0</td>\n",
              "      <td>201</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>交差点－大（13.0ｍ以上）－大</td>\n",
              "      <td>直線－平坦</td>\n",
              "      <td>交差点内</td>\n",
              "      <td>規制なし</td>\n",
              "      <td>中央分離なし</td>\n",
              "      <td>区分あり－縁石・ブロック等</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>0～24歳</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>36.038293</td>\n",
              "      <td>136.230048</td>\n",
              "      <td>2021-12-19</td>\n",
              "      <td>19:30</td>\n",
              "      <td>blue</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2947</th>\n",
              "      <td>本票</td>\n",
              "      <td>福井</td>\n",
              "      <td>福井南</td>\n",
              "      <td>134</td>\n",
              "      <td>負傷</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>都道府県道 10380</td>\n",
              "      <td>対象外</td>\n",
              "      <td>0</td>\n",
              "      <td>201</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>交差点－中（5.5m以上）－中</td>\n",
              "      <td>直線－平坦</td>\n",
              "      <td>交差点内</td>\n",
              "      <td>規制なし</td>\n",
              "      <td>中央線－ペイント</td>\n",
              "      <td>区分あり－縁石・ブロック等</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>25～34歳</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>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>36.008103</td>\n",
              "      <td>136.225824</td>\n",
              "      <td>2021-12-30</td>\n",
              "      <td>11:35</td>\n",
              "      <td>blue</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2948 rows × 68 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5484db5d-8958-4897-aa15-06c4e99a1f66')\"\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-5484db5d-8958-4897-aa15-06c4e99a1f66 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-5484db5d-8958-4897-aa15-06c4e99a1f66');\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": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "lNaWJjtgguLe",
        "outputId": "aff6336f-310b-4ccb-bad8-455dbbb58fbf"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['資料区分', '都道府県コード', '警察署等コード', '本票番号', '事故内容', '死者数', '負傷者数', '路線コード',\n",
              "       '上下線', '地点コード', '市区町村コード', '昼夜', '天候', '地形', '路面状態', '道路形状', '環状交差点の直径',\n",
              "       '信号機', '一時停止規制　標識（当事者A）', '一時停止規制　表示（当事者A）', '一時停止規制　標識（当事者B）',\n",
              "       '一時停止規制　表示（当事者B）', '車道幅員', '道路線形', '衝突地点', 'ゾーン規制', '中央分離帯施設等', '歩車道区分',\n",
              "       '事故類型', '年齢（当事者A）', '年齢（当事者B）', '当事者種別（当事者A）', '当事者種別（当事者B）',\n",
              "       '用途別（当事者A）', '用途別（当事者B）', '車両形状（当事者A）', '車両形状（当事者B）',\n",
              "       '速度規制（指定のみ）（当事者A）', '速度規制（指定のみ）（当事者B）', '車両の衝突部位（当事者A）',\n",
              "       '車両の衝突部位（当事者B）', '車両の損壊程度（当事者A）', '車両の損壊程度（当事者B）', 'エアバッグの装備（当事者A）',\n",
              "       'エアバッグの装備（当事者B）', 'サイドエアバッグの装備（当事者A）', 'サイドエアバッグの装備（当事者B）',\n",
              "       '人身損傷程度（当事者A）', '人身損傷程度（当事者B）', '曜日(発生年月日)', '祝日(発生年月日)', '発生地点',\n",
              "       '道路管理者区分', '道路区分', '道路構造', '曲線半径', '縦断勾配', 'トンネル番号', '当事者車両台数',\n",
              "       '車両単独事故の対象物', '臨時速度規制の有無', '速度規制（臨時のみ）', 'トンネル延長距離', '緯度', '経度', '発生日',\n",
              "       '発生時', 'color'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "kunitaka_df = (\n",
        "    df.query(\"(35.901899 < 緯度 < 35.932422) & (136.172767 < 経度 < 136.189627)\")\n",
        "    .reindex(\n",
        "        columns=[\n",
        "            \"緯度\",\n",
        "            \"経度\",\n",
        "            \"事故内容\",\n",
        "            \"事故類型\",\n",
        "            \"年齢（当事者A）\",\n",
        "            \"年齢（当事者B）\",\n",
        "            \"当事者種別（当事者A）\",\n",
        "            \"当事者種別（当事者B）\",\n",
        "        ]\n",
        "    )\n",
        "    .reset_index(drop=True)\n",
        ")"
      ],
      "metadata": {
        "id": "qMn3TTm9iINN"
      },
      "execution_count": 6,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "kunitaka_df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 740
        },
        "id": "ADiUNDTMjynt",
        "outputId": "cc21319e-84a9-46d5-c039-44573783b2b4"
      },
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           緯度          経度 事故内容  事故類型 年齢（当事者A） 年齢（当事者B） 当事者種別（当事者A） 当事者種別（当事者B）\n",
              "0   35.932300  136.177534   負傷  車両相互   55～64歳    0～24歳    貨物車－軽自動車     軽車両－自転車\n",
              "1   35.911226  136.177876   負傷  人対車両   45～54歳   45～54歳     乗用車－普通車         歩行者\n",
              "2   35.912417  136.188926   負傷  車両相互    0～24歳   45～54歳     乗用車－普通車     乗用車－普通車\n",
              "3   35.918619  136.176675   負傷  車両相互    0～24歳   35～44歳     乗用車－普通車     貨物車－普通車\n",
              "4   35.917501  136.179290   負傷  車両相互   45～54歳   35～44歳    乗用車－軽自動車    乗用車－軽自動車\n",
              "5   35.932299  136.189206   負傷  車両相互   65～74歳   25～34歳     乗用車－普通車     乗用車－普通車\n",
              "6   35.931464  136.180662   負傷  車両相互   35～44歳   45～54歳     乗用車－普通車     貨物車－普通車\n",
              "7   35.907917  136.184138   負傷  人対車両   35～44歳    75歳以上     乗用車－普通車         歩行者\n",
              "8   35.932370  136.177986   負傷  車両相互    0～24歳   45～54歳     乗用車－普通車     乗用車－普通車\n",
              "9   35.902643  136.175492   負傷  車両相互   65～74歳    0～24歳     乗用車－普通車    乗用車－軽自動車\n",
              "10  35.917900  136.183312   負傷  車両相互   65～74歳   55～64歳     乗用車－普通車    乗用車－軽自動車\n",
              "11  35.904873  136.176766   負傷  車両相互   45～54歳   55～64歳    乗用車－軽自動車     軽車両－自転車\n",
              "12  35.910680  136.177462   負傷  人対車両   35～44歳    0～24歳     乗用車－普通車         歩行者\n",
              "13  35.918650  136.176721   負傷  車両相互   35～44歳   25～34歳     乗用車－普通車     乗用車－普通車\n",
              "14  35.909405  136.175099   負傷  車両相互    75歳以上    0～24歳    乗用車－軽自動車     軽車両－自転車\n",
              "15  35.918695  136.176703   負傷  車両相互   25～34歳    75歳以上     乗用車－普通車    乗用車－軽自動車\n",
              "16  35.912365  136.189159   負傷  車両相互   45～54歳   55～64歳     乗用車－普通車    乗用車－軽自動車\n",
              "17  35.924557  136.185224   負傷  車両相互   65～74歳   55～64歳    乗用車－軽自動車     軽車両－自転車\n",
              "18  35.917156  136.189032   負傷  車両相互   65～74歳   35～44歳    乗用車－軽自動車    乗用車－軽自動車\n",
              "19  35.918658  136.176683   負傷  車両相互    75歳以上   35～44歳     乗用車－普通車    乗用車－軽自動車\n",
              "20  35.919488  136.179526   負傷  車両相互   35～44歳    75歳以上     乗用車－普通車     軽車両－自転車\n",
              "21  35.907948  136.187161   負傷  車両相互   45～54歳   65～74歳     乗用車－普通車    乗用車－軽自動車"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-caa188ea-d4b1-4984-94f1-c3cf11e932e6\">\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>年齢（当事者A）</th>\n",
              "      <th>年齢（当事者B）</th>\n",
              "      <th>当事者種別（当事者A）</th>\n",
              "      <th>当事者種別（当事者B）</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>35.932300</td>\n",
              "      <td>136.177534</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>貨物車－軽自動車</td>\n",
              "      <td>軽車両－自転車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>35.911226</td>\n",
              "      <td>136.177876</td>\n",
              "      <td>負傷</td>\n",
              "      <td>人対車両</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>歩行者</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>35.912417</td>\n",
              "      <td>136.188926</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>35.918619</td>\n",
              "      <td>136.176675</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>貨物車－普通車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>35.917501</td>\n",
              "      <td>136.179290</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>35.932299</td>\n",
              "      <td>136.189206</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>25～34歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>35.931464</td>\n",
              "      <td>136.180662</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>貨物車－普通車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>35.907917</td>\n",
              "      <td>136.184138</td>\n",
              "      <td>負傷</td>\n",
              "      <td>人対車両</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>75歳以上</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>歩行者</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>35.932370</td>\n",
              "      <td>136.177986</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>35.902643</td>\n",
              "      <td>136.175492</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>35.917900</td>\n",
              "      <td>136.183312</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>35.904873</td>\n",
              "      <td>136.176766</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>軽車両－自転車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>35.910680</td>\n",
              "      <td>136.177462</td>\n",
              "      <td>負傷</td>\n",
              "      <td>人対車両</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>歩行者</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>35.918650</td>\n",
              "      <td>136.176721</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>25～34歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>35.909405</td>\n",
              "      <td>136.175099</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>75歳以上</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>軽車両－自転車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>35.918695</td>\n",
              "      <td>136.176703</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>25～34歳</td>\n",
              "      <td>75歳以上</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>35.912365</td>\n",
              "      <td>136.189159</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>35.924557</td>\n",
              "      <td>136.185224</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>軽車両－自転車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>35.917156</td>\n",
              "      <td>136.189032</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>35.918658</td>\n",
              "      <td>136.176683</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>75歳以上</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>35.919488</td>\n",
              "      <td>136.179526</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>75歳以上</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>軽車両－自転車</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>35.907948</td>\n",
              "      <td>136.187161</td>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-caa188ea-d4b1-4984-94f1-c3cf11e932e6')\"\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-caa188ea-d4b1-4984-94f1-c3cf11e932e6 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-caa188ea-d4b1-4984-94f1-c3cf11e932e6');\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": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "kunitaka_df.to_csv(\"./accidents_kuknitaka.csv\")"
      ],
      "metadata": {
        "id": "ee7DMSNJjWYX"
      },
      "execution_count": 8,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def encode(lat: float, lng: float, level: int):\n",
        "    if level < 1:\n",
        "        return null\n",
        "    res = \"\"\n",
        "    if lng >= 0:\n",
        "        res += \"E\"\n",
        "    else:\n",
        "        res += \"W\"\n",
        "        lng += 180\n",
        "    lat += 90  # 180:the North Pole,  0:the South Pole\n",
        "    unit = 180\n",
        "    for i in range(1, level):\n",
        "        unit /= 3\n",
        "        x = int(lng / unit)\n",
        "        y = int(lat / unit)\n",
        "        res += chr(ord(\"0\") + x + y * 3 + 1)\n",
        "        lng -= x * unit\n",
        "        lat -= y * unit\n",
        "    return res"
      ],
      "metadata": {
        "id": "3TvjdqCRguRO"
      },
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "kunitaka_df[\"Geo3x3\"] = kunitaka_df[[\"緯度\", \"経度\"]].apply(lambda x: encode(x[0], x[1], 15), axis=1)"
      ],
      "metadata": {
        "id": "PG0a1PfikXyM"
      },
      "execution_count": 10,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# 緯度・経度削除\n",
        "kunitaka_df.drop([\"緯度\", \"経度\"], axis=1, inplace=True)"
      ],
      "metadata": {
        "id": "UQ2eIh1SlcYj"
      },
      "execution_count": 11,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "kunitaka_df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 740
        },
        "id": "mZfBHDN0laSM",
        "outputId": "fea2638b-421e-4718-a530-75ddf4d5245a"
      },
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   事故内容  事故類型 年齢（当事者A） 年齢（当事者B） 当事者種別（当事者A） 当事者種別（当事者B）           Geo3x3\n",
              "0    負傷  車両相互   55～64歳    0～24歳    貨物車－軽自動車     軽車両－自転車  E91387322371184\n",
              "1    負傷  人対車両   45～54歳   45～54歳     乗用車－普通車         歩行者  E91384988641557\n",
              "2    負傷  車両相互    0～24歳   45～54歳     乗用車－普通車     乗用車－普通車  E91384989446736\n",
              "3    負傷  車両相互    0～24歳   35～44歳     乗用車－普通車     貨物車－普通車  E91384988836762\n",
              "4    負傷  車両相互   45～54歳   35～44歳    乗用車－軽自動車    乗用車－軽自動車  E91384988912925\n",
              "5    負傷  車両相互   65～74歳   25～34歳     乗用車－普通車     乗用車－普通車  E91387323173295\n",
              "6    負傷  車両相互   35～44歳   45～54歳     乗用車－普通車     貨物車－普通車  E91387322357453\n",
              "7    負傷  人対車両   35～44歳    75歳以上     乗用車－普通車         歩行者  E91384988631295\n",
              "8    負傷  車両相互    0～24歳   45～54歳     乗用車－普通車     乗用車－普通車  E91387322371531\n",
              "9    負傷  車両相互   65～74歳    0～24歳     乗用車－普通車    乗用車－軽自動車  E91384988265119\n",
              "10   負傷  車両相互   65～74歳   55～64歳     乗用車－普通車    乗用車－軽自動車  E91384988926327\n",
              "11   負傷  車両相互   45～54歳   55～64歳    乗用車－軽自動車     軽車両－自転車  E91384988293274\n",
              "12   負傷  人対車両   35～44歳    0～24歳     乗用車－普通車         歩行者  E91384988617778\n",
              "13   負傷  車両相互   35～44歳   25～34歳     乗用車－普通車     乗用車－普通車  E91384988836766\n",
              "14   負傷  車両相互    75歳以上    0～24歳    乗用車－軽自動車     軽車両－自転車  E91384988534918\n",
              "15   負傷  車両相互   25～34歳    75歳以上     乗用車－普通車    乗用車－軽自動車  E91384988836769\n",
              "16   負傷  車両相互   45～54歳   55～64歳     乗用車－普通車    乗用車－軽自動車  E91384989446597\n",
              "17   負傷  車両相互   65～74歳   55～64歳    乗用車－軽自動車     軽車両－自転車  E91384988995677\n",
              "18   負傷  車両相互   65～74歳   35～44歳    乗用車－軽自動車    乗用車－軽自動車  E91384989713513\n",
              "19   負傷  車両相互    75歳以上   35～44歳     乗用車－普通車    乗用車－軽自動車  E91384988836765\n",
              "20   負傷  車両相互   35～44歳    75歳以上     乗用車－普通車     軽車両－自転車  E91384988919479\n",
              "21   負傷  車両相互   45～54歳   65～74歳     乗用車－普通車    乗用車－軽自動車  E91384989411298"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2645a18b-5363-4bd7-9458-4bae91edd820\">\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>年齢（当事者A）</th>\n",
              "      <th>年齢（当事者B）</th>\n",
              "      <th>当事者種別（当事者A）</th>\n",
              "      <th>当事者種別（当事者B）</th>\n",
              "      <th>Geo3x3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>貨物車－軽自動車</td>\n",
              "      <td>軽車両－自転車</td>\n",
              "      <td>E91387322371184</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>負傷</td>\n",
              "      <td>人対車両</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>歩行者</td>\n",
              "      <td>E91384988641557</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>E91384989446736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>貨物車－普通車</td>\n",
              "      <td>E91384988836762</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>E91384988912925</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>25～34歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>E91387323173295</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>貨物車－普通車</td>\n",
              "      <td>E91387322357453</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>負傷</td>\n",
              "      <td>人対車両</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>75歳以上</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>歩行者</td>\n",
              "      <td>E91384988631295</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>E91387322371531</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>E91384988265119</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>E91384988926327</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>軽車両－自転車</td>\n",
              "      <td>E91384988293274</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>負傷</td>\n",
              "      <td>人対車両</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>歩行者</td>\n",
              "      <td>E91384988617778</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>25～34歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>E91384988836766</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>75歳以上</td>\n",
              "      <td>0～24歳</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>軽車両－自転車</td>\n",
              "      <td>E91384988534918</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>25～34歳</td>\n",
              "      <td>75歳以上</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>E91384988836769</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>E91384989446597</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>55～64歳</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>軽車両－自転車</td>\n",
              "      <td>E91384988995677</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>E91384989713513</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>75歳以上</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>E91384988836765</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>35～44歳</td>\n",
              "      <td>75歳以上</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>軽車両－自転車</td>\n",
              "      <td>E91384988919479</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>負傷</td>\n",
              "      <td>車両相互</td>\n",
              "      <td>45～54歳</td>\n",
              "      <td>65～74歳</td>\n",
              "      <td>乗用車－普通車</td>\n",
              "      <td>乗用車－軽自動車</td>\n",
              "      <td>E91384989411298</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2645a18b-5363-4bd7-9458-4bae91edd820')\"\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-2645a18b-5363-4bd7-9458-4bae91edd820 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-2645a18b-5363-4bd7-9458-4bae91edd820');\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": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "kunitaka_df.to_csv(\"./accidents_kuknitaka_geo3x3.csv\")"
      ],
      "metadata": {
        "id": "Cf_vDs6ulrAt"
      },
      "execution_count": 13,
      "outputs": []
    }
  ]
}