data_clean.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "def refine_df(df):\n",
    "    col = [\"ind\",\"dom\",\"stay\",\"stay_tour\",\"stay_home\",\"stay_work\",\"day\",\"day_tour\",\"day_home\",\"day_work\",\"abr\",\"abr_tour\",\"abr_home\",\"abr_work\"]\n",
    "    ind = [\"Hokakido\",\"Touhoku\",\"Kanto\",\"Hokuriku\",\"Tyuubu\",\"Kinki\",\"Tyuugoku\",\"Shikoku\",\"Kyusyu\",\"Okinawa\",\"Asia\",\"Europ\",\"N_America\",\"S_America\",\"Africa\",\"Oceania\"]\n",
    "    df.drop([0,1,2,3,4],inplace=True)\n",
    "    df.columns = col\n",
    "    df = df[:16]\n",
    "    df.drop([\"dom\",\"stay\",\"day\",\"abr\"],axis=1,inplace=True)\n",
    "\n",
    "    df.loc[15,\"stay_tour\"] = df.loc[15,\"abr_tour\"]\n",
    "    df.loc[15,\"stay_home\"] = df.loc[15,\"abr_home\"]\n",
    "    df.loc[15,\"stay_work\"] = df.loc[15,\"abr_work\"]\n",
    "\n",
    "    df.loc[16,\"stay_tour\"] = df.loc[16,\"abr_tour\"]\n",
    "    df.loc[16,\"stay_home\"] = df.loc[16,\"abr_home\"]\n",
    "    df.loc[16,\"stay_work\"] = df.loc[16,\"abr_work\"]\n",
    "\n",
    "    df.loc[17,\"stay_tour\"] = df.loc[17,\"abr_tour\"]\n",
    "    df.loc[17,\"stay_home\"] = df.loc[17,\"abr_home\"]\n",
    "    df.loc[17,\"stay_work\"] = df.loc[17,\"abr_work\"]\n",
    "\n",
    "    df.loc[18,\"stay_tour\"] = df.loc[18,\"abr_tour\"]\n",
    "    df.loc[18,\"stay_home\"] = df.loc[18,\"abr_home\"]\n",
    "    df.loc[18,\"stay_work\"] = df.loc[18,\"abr_work\"]\n",
    "\n",
    "    df.loc[19,\"stay_tour\"] = df.loc[19,\"abr_tour\"]\n",
    "    df.loc[19,\"stay_home\"] = df.loc[19,\"abr_home\"]\n",
    "    df.loc[19,\"stay_work\"] = df.loc[19,\"abr_work\"]\n",
    "\n",
    "    df.loc[20,\"stay_tour\"] = df.loc[20,\"abr_tour\"]\n",
    "    df.loc[20,\"stay_home\"] = df.loc[20,\"abr_home\"]\n",
    "    df.loc[20,\"stay_work\"] = df.loc[20,\"abr_work\"]\n",
    "    \n",
    "    df.drop([\"abr_tour\",\"abr_home\",\"abr_work\",\"ind\"],axis=1,inplace=True)\n",
    "    df.replace({\"-\" : 0, \"…\" : 0},inplace=True)\n",
    "    df.index = ind\n",
    "    \n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_201810 = refine_df(pd.read_excel('201810.xlsx',sheet_name=3)).T\n",
    "df_201807 = refine_df(pd.read_excel('201807.xlsx',sheet_name=3)).T\n",
    "df_201804 = refine_df(pd.read_excel('201804.xlsx',sheet_name=3)).T\n",
    "df_201801 = refine_df(pd.read_excel('201801.xlsx',sheet_name=3)).T\n",
    "df_201710 = refine_df(pd.read_excel('201710.xls',sheet_name=3)).T\n",
    "df_201707 = refine_df(pd.read_excel('201707.xls',sheet_name=3)).T\n",
    "df_201704 = refine_df(pd.read_excel('201704.xls',sheet_name=3)).T\n",
    "df_201701 = refine_df(pd.read_excel('201701.xls',sheet_name=3)).T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hokakido</th>\n",
       "      <th>Touhoku</th>\n",
       "      <th>Kanto</th>\n",
       "      <th>Hokuriku</th>\n",
       "      <th>Tyuubu</th>\n",
       "      <th>Kinki</th>\n",
       "      <th>Tyuugoku</th>\n",
       "      <th>Shikoku</th>\n",
       "      <th>Kyusyu</th>\n",
       "      <th>Okinawa</th>\n",
       "      <th>Asia</th>\n",
       "      <th>Europ</th>\n",
       "      <th>N_America</th>\n",
       "      <th>S_America</th>\n",
       "      <th>Africa</th>\n",
       "      <th>Oceania</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>stay_tour</th>\n",
       "      <td>1714.172</td>\n",
       "      <td>2837.495</td>\n",
       "      <td>9893.941</td>\n",
       "      <td>4516.078</td>\n",
       "      <td>4696.647</td>\n",
       "      <td>5532.736</td>\n",
       "      <td>1927.364</td>\n",
       "      <td>806.145</td>\n",
       "      <td>2937.590</td>\n",
       "      <td>1340.795</td>\n",
       "      <td>1696.653</td>\n",
       "      <td>573.782</td>\n",
       "      <td>472.301</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.443</td>\n",
       "      <td>188.650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home</th>\n",
       "      <td>768.723</td>\n",
       "      <td>1742.053</td>\n",
       "      <td>3413.347</td>\n",
       "      <td>1232.461</td>\n",
       "      <td>1699.309</td>\n",
       "      <td>1871.759</td>\n",
       "      <td>852.866</td>\n",
       "      <td>755.348</td>\n",
       "      <td>1700.627</td>\n",
       "      <td>220.233</td>\n",
       "      <td>106.265</td>\n",
       "      <td>0.000</td>\n",
       "      <td>87.426</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>8.313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_work</th>\n",
       "      <td>587.331</td>\n",
       "      <td>783.721</td>\n",
       "      <td>3278.754</td>\n",
       "      <td>628.525</td>\n",
       "      <td>1658.727</td>\n",
       "      <td>2016.041</td>\n",
       "      <td>557.851</td>\n",
       "      <td>230.097</td>\n",
       "      <td>1264.430</td>\n",
       "      <td>218.098</td>\n",
       "      <td>690.921</td>\n",
       "      <td>232.052</td>\n",
       "      <td>129.793</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_tour</th>\n",
       "      <td>961.258</td>\n",
       "      <td>2488.679</td>\n",
       "      <td>16188.484</td>\n",
       "      <td>2992.208</td>\n",
       "      <td>4976.802</td>\n",
       "      <td>7263.831</td>\n",
       "      <td>2802.860</td>\n",
       "      <td>952.926</td>\n",
       "      <td>2756.144</td>\n",
       "      <td>244.552</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home</th>\n",
       "      <td>314.703</td>\n",
       "      <td>767.992</td>\n",
       "      <td>2665.669</td>\n",
       "      <td>551.827</td>\n",
       "      <td>1050.397</td>\n",
       "      <td>1709.329</td>\n",
       "      <td>686.385</td>\n",
       "      <td>166.031</td>\n",
       "      <td>761.976</td>\n",
       "      <td>7.904</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work</th>\n",
       "      <td>358.509</td>\n",
       "      <td>725.239</td>\n",
       "      <td>3611.690</td>\n",
       "      <td>636.989</td>\n",
       "      <td>1233.133</td>\n",
       "      <td>1627.656</td>\n",
       "      <td>947.348</td>\n",
       "      <td>199.301</td>\n",
       "      <td>618.987</td>\n",
       "      <td>8.561</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Hokakido   Touhoku      Kanto  Hokuriku    Tyuubu     Kinki  \\\n",
       "stay_tour  1714.172  2837.495   9893.941  4516.078  4696.647  5532.736   \n",
       "stay_home   768.723  1742.053   3413.347  1232.461  1699.309  1871.759   \n",
       "stay_work   587.331   783.721   3278.754   628.525  1658.727  2016.041   \n",
       "day_tour    961.258  2488.679  16188.484  2992.208  4976.802  7263.831   \n",
       "day_home    314.703   767.992   2665.669   551.827  1050.397  1709.329   \n",
       "day_work    358.509   725.239   3611.690   636.989  1233.133  1627.656   \n",
       "\n",
       "           Tyuugoku  Shikoku    Kyusyu   Okinawa      Asia    Europ  \\\n",
       "stay_tour  1927.364  806.145  2937.590  1340.795  1696.653  573.782   \n",
       "stay_home   852.866  755.348  1700.627   220.233   106.265    0.000   \n",
       "stay_work   557.851  230.097  1264.430   218.098   690.921  232.052   \n",
       "day_tour   2802.860  952.926  2756.144   244.552     0.000    0.000   \n",
       "day_home    686.385  166.031   761.976     7.904     0.000    0.000   \n",
       "day_work    947.348  199.301   618.987     8.561     0.000    0.000   \n",
       "\n",
       "           N_America  S_America  Africa  Oceania  \n",
       "stay_tour    472.301        0.0  14.443  188.650  \n",
       "stay_home     87.426        0.0   0.000    8.313  \n",
       "stay_work    129.793        0.0   0.000    0.000  \n",
       "day_tour       0.000        0.0   0.000    0.000  \n",
       "day_home       0.000        0.0   0.000    0.000  \n",
       "day_work       0.000        0.0   0.000    0.000  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201810"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hokakido</th>\n",
       "      <th>Touhoku</th>\n",
       "      <th>Kanto</th>\n",
       "      <th>Hokuriku</th>\n",
       "      <th>Tyuubu</th>\n",
       "      <th>Kinki</th>\n",
       "      <th>Tyuugoku</th>\n",
       "      <th>Shikoku</th>\n",
       "      <th>Kyusyu</th>\n",
       "      <th>Okinawa</th>\n",
       "      <th>Asia</th>\n",
       "      <th>Europ</th>\n",
       "      <th>N_America</th>\n",
       "      <th>S_America</th>\n",
       "      <th>Africa</th>\n",
       "      <th>Oceania</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>stay_tour</th>\n",
       "      <td>3025.337</td>\n",
       "      <td>3798.449</td>\n",
       "      <td>14639.905</td>\n",
       "      <td>6222.936</td>\n",
       "      <td>6972.292</td>\n",
       "      <td>7386.638</td>\n",
       "      <td>2200.846</td>\n",
       "      <td>1138.843</td>\n",
       "      <td>4462.213</td>\n",
       "      <td>1618.033</td>\n",
       "      <td>1619.385</td>\n",
       "      <td>513.391</td>\n",
       "      <td>462.294</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.263</td>\n",
       "      <td>411.395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home</th>\n",
       "      <td>1662.039</td>\n",
       "      <td>3093.617</td>\n",
       "      <td>4856.103</td>\n",
       "      <td>2137.714</td>\n",
       "      <td>3129.273</td>\n",
       "      <td>3471.199</td>\n",
       "      <td>2295.958</td>\n",
       "      <td>1406.515</td>\n",
       "      <td>2883.223</td>\n",
       "      <td>438.095</td>\n",
       "      <td>33.162</td>\n",
       "      <td>11.386</td>\n",
       "      <td>29.218</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>59.227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_work</th>\n",
       "      <td>675.860</td>\n",
       "      <td>1057.987</td>\n",
       "      <td>3354.876</td>\n",
       "      <td>501.910</td>\n",
       "      <td>1052.581</td>\n",
       "      <td>2112.105</td>\n",
       "      <td>591.578</td>\n",
       "      <td>215.566</td>\n",
       "      <td>1023.885</td>\n",
       "      <td>194.504</td>\n",
       "      <td>596.806</td>\n",
       "      <td>112.572</td>\n",
       "      <td>300.742</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36.100</td>\n",
       "      <td>33.929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_tour</th>\n",
       "      <td>1768.992</td>\n",
       "      <td>3532.701</td>\n",
       "      <td>20199.313</td>\n",
       "      <td>2861.704</td>\n",
       "      <td>7022.473</td>\n",
       "      <td>7684.404</td>\n",
       "      <td>2476.210</td>\n",
       "      <td>1277.557</td>\n",
       "      <td>4046.571</td>\n",
       "      <td>52.119</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home</th>\n",
       "      <td>521.326</td>\n",
       "      <td>805.366</td>\n",
       "      <td>3466.263</td>\n",
       "      <td>883.975</td>\n",
       "      <td>1048.320</td>\n",
       "      <td>1926.563</td>\n",
       "      <td>732.434</td>\n",
       "      <td>143.762</td>\n",
       "      <td>1239.630</td>\n",
       "      <td>5.538</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work</th>\n",
       "      <td>344.279</td>\n",
       "      <td>386.079</td>\n",
       "      <td>3741.283</td>\n",
       "      <td>705.344</td>\n",
       "      <td>1581.033</td>\n",
       "      <td>1030.472</td>\n",
       "      <td>707.889</td>\n",
       "      <td>82.597</td>\n",
       "      <td>767.420</td>\n",
       "      <td>61.503</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Hokakido   Touhoku      Kanto  Hokuriku    Tyuubu     Kinki  \\\n",
       "stay_tour  3025.337  3798.449  14639.905  6222.936  6972.292  7386.638   \n",
       "stay_home  1662.039  3093.617   4856.103  2137.714  3129.273  3471.199   \n",
       "stay_work   675.860  1057.987   3354.876   501.910  1052.581  2112.105   \n",
       "day_tour   1768.992  3532.701  20199.313  2861.704  7022.473  7684.404   \n",
       "day_home    521.326   805.366   3466.263   883.975  1048.320  1926.563   \n",
       "day_work    344.279   386.079   3741.283   705.344  1581.033  1030.472   \n",
       "\n",
       "           Tyuugoku   Shikoku    Kyusyu   Okinawa      Asia    Europ  \\\n",
       "stay_tour  2200.846  1138.843  4462.213  1618.033  1619.385  513.391   \n",
       "stay_home  2295.958  1406.515  2883.223   438.095    33.162   11.386   \n",
       "stay_work   591.578   215.566  1023.885   194.504   596.806  112.572   \n",
       "day_tour   2476.210  1277.557  4046.571    52.119     0.000    0.000   \n",
       "day_home    732.434   143.762  1239.630     5.538     0.000    0.000   \n",
       "day_work    707.889    82.597   767.420    61.503     0.000    0.000   \n",
       "\n",
       "           N_America  S_America  Africa  Oceania  \n",
       "stay_tour    462.294        0.0  20.263  411.395  \n",
       "stay_home     29.218        0.0   0.000   59.227  \n",
       "stay_work    300.742        0.0  36.100   33.929  \n",
       "day_tour       0.000        0.0   0.000    0.000  \n",
       "day_home       0.000        0.0   0.000    0.000  \n",
       "day_work       0.000        0.0   0.000    0.000  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201807"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hokakido</th>\n",
       "      <th>Touhoku</th>\n",
       "      <th>Kanto</th>\n",
       "      <th>Hokuriku</th>\n",
       "      <th>Tyuubu</th>\n",
       "      <th>Kinki</th>\n",
       "      <th>Tyuugoku</th>\n",
       "      <th>Shikoku</th>\n",
       "      <th>Kyusyu</th>\n",
       "      <th>Okinawa</th>\n",
       "      <th>Asia</th>\n",
       "      <th>Europ</th>\n",
       "      <th>N_America</th>\n",
       "      <th>S_America</th>\n",
       "      <th>Africa</th>\n",
       "      <th>Oceania</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>stay_tour</th>\n",
       "      <td>2246.328</td>\n",
       "      <td>2931.360</td>\n",
       "      <td>10423.650</td>\n",
       "      <td>3918.415</td>\n",
       "      <td>4654.961</td>\n",
       "      <td>5446.973</td>\n",
       "      <td>2001.926</td>\n",
       "      <td>957.212</td>\n",
       "      <td>2991.677</td>\n",
       "      <td>1141.215</td>\n",
       "      <td>1325.786</td>\n",
       "      <td>341.838</td>\n",
       "      <td>330.875</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>200.100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home</th>\n",
       "      <td>1051.355</td>\n",
       "      <td>2302.518</td>\n",
       "      <td>4188.075</td>\n",
       "      <td>1858.997</td>\n",
       "      <td>1834.481</td>\n",
       "      <td>2666.022</td>\n",
       "      <td>1588.585</td>\n",
       "      <td>630.516</td>\n",
       "      <td>2250.950</td>\n",
       "      <td>218.816</td>\n",
       "      <td>144.867</td>\n",
       "      <td>30.104</td>\n",
       "      <td>47.304</td>\n",
       "      <td>8.985</td>\n",
       "      <td>0.000</td>\n",
       "      <td>27.615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_work</th>\n",
       "      <td>694.861</td>\n",
       "      <td>977.767</td>\n",
       "      <td>3339.264</td>\n",
       "      <td>780.315</td>\n",
       "      <td>1626.169</td>\n",
       "      <td>1531.034</td>\n",
       "      <td>939.704</td>\n",
       "      <td>392.356</td>\n",
       "      <td>1856.952</td>\n",
       "      <td>245.545</td>\n",
       "      <td>587.715</td>\n",
       "      <td>215.582</td>\n",
       "      <td>176.377</td>\n",
       "      <td>0.000</td>\n",
       "      <td>27.374</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_tour</th>\n",
       "      <td>1785.517</td>\n",
       "      <td>4043.383</td>\n",
       "      <td>20180.989</td>\n",
       "      <td>3098.818</td>\n",
       "      <td>6973.642</td>\n",
       "      <td>8577.492</td>\n",
       "      <td>2637.584</td>\n",
       "      <td>1298.647</td>\n",
       "      <td>4251.391</td>\n",
       "      <td>81.283</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home</th>\n",
       "      <td>419.715</td>\n",
       "      <td>646.979</td>\n",
       "      <td>2799.865</td>\n",
       "      <td>643.034</td>\n",
       "      <td>1291.175</td>\n",
       "      <td>1878.099</td>\n",
       "      <td>643.546</td>\n",
       "      <td>228.395</td>\n",
       "      <td>964.903</td>\n",
       "      <td>9.713</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work</th>\n",
       "      <td>242.217</td>\n",
       "      <td>792.688</td>\n",
       "      <td>3977.835</td>\n",
       "      <td>261.923</td>\n",
       "      <td>2357.588</td>\n",
       "      <td>1498.427</td>\n",
       "      <td>631.135</td>\n",
       "      <td>140.274</td>\n",
       "      <td>927.494</td>\n",
       "      <td>12.356</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Hokakido   Touhoku      Kanto  Hokuriku    Tyuubu     Kinki  \\\n",
       "stay_tour  2246.328  2931.360  10423.650  3918.415  4654.961  5446.973   \n",
       "stay_home  1051.355  2302.518   4188.075  1858.997  1834.481  2666.022   \n",
       "stay_work   694.861   977.767   3339.264   780.315  1626.169  1531.034   \n",
       "day_tour   1785.517  4043.383  20180.989  3098.818  6973.642  8577.492   \n",
       "day_home    419.715   646.979   2799.865   643.034  1291.175  1878.099   \n",
       "day_work    242.217   792.688   3977.835   261.923  2357.588  1498.427   \n",
       "\n",
       "           Tyuugoku   Shikoku    Kyusyu   Okinawa      Asia    Europ  \\\n",
       "stay_tour  2001.926   957.212  2991.677  1141.215  1325.786  341.838   \n",
       "stay_home  1588.585   630.516  2250.950   218.816   144.867   30.104   \n",
       "stay_work   939.704   392.356  1856.952   245.545   587.715  215.582   \n",
       "day_tour   2637.584  1298.647  4251.391    81.283     0.000    0.000   \n",
       "day_home    643.546   228.395   964.903     9.713     0.000    0.000   \n",
       "day_work    631.135   140.274   927.494    12.356     0.000    0.000   \n",
       "\n",
       "           N_America  S_America  Africa  Oceania  \n",
       "stay_tour    330.875      0.000   0.000  200.100  \n",
       "stay_home     47.304      8.985   0.000   27.615  \n",
       "stay_work    176.377      0.000  27.374    0.000  \n",
       "day_tour       0.000      0.000   0.000    0.000  \n",
       "day_home       0.000      0.000   0.000    0.000  \n",
       "day_work       0.000      0.000   0.000    0.000  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201804"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hokakido</th>\n",
       "      <th>Touhoku</th>\n",
       "      <th>Kanto</th>\n",
       "      <th>Hokuriku</th>\n",
       "      <th>Tyuubu</th>\n",
       "      <th>Kinki</th>\n",
       "      <th>Tyuugoku</th>\n",
       "      <th>Shikoku</th>\n",
       "      <th>Kyusyu</th>\n",
       "      <th>Okinawa</th>\n",
       "      <th>Asia</th>\n",
       "      <th>Europ</th>\n",
       "      <th>N_America</th>\n",
       "      <th>S_America</th>\n",
       "      <th>Africa</th>\n",
       "      <th>Oceania</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>stay_tour</th>\n",
       "      <td>1678.891</td>\n",
       "      <td>2307.806</td>\n",
       "      <td>8511.584</td>\n",
       "      <td>4208.793</td>\n",
       "      <td>4840.223</td>\n",
       "      <td>6893.330</td>\n",
       "      <td>1221.969</td>\n",
       "      <td>942.424</td>\n",
       "      <td>2498.285</td>\n",
       "      <td>1200.180</td>\n",
       "      <td>1794.850</td>\n",
       "      <td>677.388</td>\n",
       "      <td>665.767</td>\n",
       "      <td>16.195</td>\n",
       "      <td>0.000</td>\n",
       "      <td>271.211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home</th>\n",
       "      <td>1013.897</td>\n",
       "      <td>2013.283</td>\n",
       "      <td>4950.046</td>\n",
       "      <td>1287.752</td>\n",
       "      <td>2547.617</td>\n",
       "      <td>3060.720</td>\n",
       "      <td>1225.578</td>\n",
       "      <td>1240.402</td>\n",
       "      <td>2908.020</td>\n",
       "      <td>225.249</td>\n",
       "      <td>326.408</td>\n",
       "      <td>0.000</td>\n",
       "      <td>14.192</td>\n",
       "      <td>27.763</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_work</th>\n",
       "      <td>583.632</td>\n",
       "      <td>1300.362</td>\n",
       "      <td>3190.519</td>\n",
       "      <td>1013.719</td>\n",
       "      <td>1128.469</td>\n",
       "      <td>1184.341</td>\n",
       "      <td>530.499</td>\n",
       "      <td>372.310</td>\n",
       "      <td>1281.196</td>\n",
       "      <td>541.328</td>\n",
       "      <td>576.969</td>\n",
       "      <td>82.488</td>\n",
       "      <td>96.077</td>\n",
       "      <td>55.750</td>\n",
       "      <td>11.309</td>\n",
       "      <td>35.943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_tour</th>\n",
       "      <td>935.011</td>\n",
       "      <td>1519.393</td>\n",
       "      <td>13027.129</td>\n",
       "      <td>2293.456</td>\n",
       "      <td>6284.223</td>\n",
       "      <td>7058.552</td>\n",
       "      <td>1844.724</td>\n",
       "      <td>779.118</td>\n",
       "      <td>3271.751</td>\n",
       "      <td>159.678</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home</th>\n",
       "      <td>795.337</td>\n",
       "      <td>849.566</td>\n",
       "      <td>3590.090</td>\n",
       "      <td>578.557</td>\n",
       "      <td>1273.683</td>\n",
       "      <td>1257.589</td>\n",
       "      <td>544.633</td>\n",
       "      <td>261.647</td>\n",
       "      <td>1017.407</td>\n",
       "      <td>28.235</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work</th>\n",
       "      <td>288.998</td>\n",
       "      <td>565.788</td>\n",
       "      <td>4499.068</td>\n",
       "      <td>289.639</td>\n",
       "      <td>1007.634</td>\n",
       "      <td>2150.943</td>\n",
       "      <td>294.110</td>\n",
       "      <td>56.878</td>\n",
       "      <td>1645.953</td>\n",
       "      <td>21.171</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Hokakido   Touhoku      Kanto  Hokuriku    Tyuubu     Kinki  \\\n",
       "stay_tour  1678.891  2307.806   8511.584  4208.793  4840.223  6893.330   \n",
       "stay_home  1013.897  2013.283   4950.046  1287.752  2547.617  3060.720   \n",
       "stay_work   583.632  1300.362   3190.519  1013.719  1128.469  1184.341   \n",
       "day_tour    935.011  1519.393  13027.129  2293.456  6284.223  7058.552   \n",
       "day_home    795.337   849.566   3590.090   578.557  1273.683  1257.589   \n",
       "day_work    288.998   565.788   4499.068   289.639  1007.634  2150.943   \n",
       "\n",
       "           Tyuugoku   Shikoku    Kyusyu   Okinawa      Asia    Europ  \\\n",
       "stay_tour  1221.969   942.424  2498.285  1200.180  1794.850  677.388   \n",
       "stay_home  1225.578  1240.402  2908.020   225.249   326.408    0.000   \n",
       "stay_work   530.499   372.310  1281.196   541.328   576.969   82.488   \n",
       "day_tour   1844.724   779.118  3271.751   159.678     0.000    0.000   \n",
       "day_home    544.633   261.647  1017.407    28.235     0.000    0.000   \n",
       "day_work    294.110    56.878  1645.953    21.171     0.000    0.000   \n",
       "\n",
       "           N_America  S_America  Africa  Oceania  \n",
       "stay_tour    665.767     16.195   0.000  271.211  \n",
       "stay_home     14.192     27.763   0.000    0.000  \n",
       "stay_work     96.077     55.750  11.309   35.943  \n",
       "day_tour       0.000      0.000   0.000    0.000  \n",
       "day_home       0.000      0.000   0.000    0.000  \n",
       "day_work       0.000      0.000   0.000    0.000  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201801"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hokakido</th>\n",
       "      <th>Touhoku</th>\n",
       "      <th>Kanto</th>\n",
       "      <th>Hokuriku</th>\n",
       "      <th>Tyuubu</th>\n",
       "      <th>Kinki</th>\n",
       "      <th>Tyuugoku</th>\n",
       "      <th>Shikoku</th>\n",
       "      <th>Kyusyu</th>\n",
       "      <th>Okinawa</th>\n",
       "      <th>Asia</th>\n",
       "      <th>Europ</th>\n",
       "      <th>N_America</th>\n",
       "      <th>S_America</th>\n",
       "      <th>Africa</th>\n",
       "      <th>Oceania</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>stay_tour</th>\n",
       "      <td>1737.721011</td>\n",
       "      <td>3043.499685</td>\n",
       "      <td>10697.296494</td>\n",
       "      <td>4273.182148</td>\n",
       "      <td>5755.830116</td>\n",
       "      <td>6672.438355</td>\n",
       "      <td>2280.453698</td>\n",
       "      <td>1041.401360</td>\n",
       "      <td>3716.095664</td>\n",
       "      <td>1274.783622</td>\n",
       "      <td>1342.499158</td>\n",
       "      <td>252.743681</td>\n",
       "      <td>668.267156</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.227739</td>\n",
       "      <td>149.536219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home</th>\n",
       "      <td>927.761814</td>\n",
       "      <td>2117.715278</td>\n",
       "      <td>4264.654992</td>\n",
       "      <td>1282.015880</td>\n",
       "      <td>2209.126004</td>\n",
       "      <td>2501.629173</td>\n",
       "      <td>1470.903571</td>\n",
       "      <td>783.698030</td>\n",
       "      <td>2602.973023</td>\n",
       "      <td>218.552779</td>\n",
       "      <td>317.169702</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>118.927178</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>22.444501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_work</th>\n",
       "      <td>593.843450</td>\n",
       "      <td>843.208004</td>\n",
       "      <td>5043.218581</td>\n",
       "      <td>447.366516</td>\n",
       "      <td>1699.685148</td>\n",
       "      <td>1886.816289</td>\n",
       "      <td>1013.059323</td>\n",
       "      <td>1165.977649</td>\n",
       "      <td>2714.423528</td>\n",
       "      <td>217.642672</td>\n",
       "      <td>697.823265</td>\n",
       "      <td>368.807023</td>\n",
       "      <td>207.017894</td>\n",
       "      <td>28.723752</td>\n",
       "      <td>10.919591</td>\n",
       "      <td>44.635789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_tour</th>\n",
       "      <td>1243.077244</td>\n",
       "      <td>2683.346907</td>\n",
       "      <td>16264.217815</td>\n",
       "      <td>3304.452841</td>\n",
       "      <td>6301.603797</td>\n",
       "      <td>8089.388914</td>\n",
       "      <td>2241.074735</td>\n",
       "      <td>1048.740441</td>\n",
       "      <td>4090.347226</td>\n",
       "      <td>164.164248</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home</th>\n",
       "      <td>718.738855</td>\n",
       "      <td>1275.640003</td>\n",
       "      <td>3650.657067</td>\n",
       "      <td>981.325378</td>\n",
       "      <td>1756.333664</td>\n",
       "      <td>1476.630386</td>\n",
       "      <td>1033.856475</td>\n",
       "      <td>176.768113</td>\n",
       "      <td>974.601011</td>\n",
       "      <td>8.985964</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work</th>\n",
       "      <td>390.370434</td>\n",
       "      <td>1107.492062</td>\n",
       "      <td>5573.149393</td>\n",
       "      <td>548.348389</td>\n",
       "      <td>2690.372265</td>\n",
       "      <td>2765.073465</td>\n",
       "      <td>1377.506195</td>\n",
       "      <td>236.926044</td>\n",
       "      <td>1560.843464</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Hokakido      Touhoku         Kanto     Hokuriku       Tyuubu  \\\n",
       "stay_tour  1737.721011  3043.499685  10697.296494  4273.182148  5755.830116   \n",
       "stay_home   927.761814  2117.715278   4264.654992  1282.015880  2209.126004   \n",
       "stay_work   593.843450   843.208004   5043.218581   447.366516  1699.685148   \n",
       "day_tour   1243.077244  2683.346907  16264.217815  3304.452841  6301.603797   \n",
       "day_home    718.738855  1275.640003   3650.657067   981.325378  1756.333664   \n",
       "day_work    390.370434  1107.492062   5573.149393   548.348389  2690.372265   \n",
       "\n",
       "                 Kinki     Tyuugoku      Shikoku       Kyusyu      Okinawa  \\\n",
       "stay_tour  6672.438355  2280.453698  1041.401360  3716.095664  1274.783622   \n",
       "stay_home  2501.629173  1470.903571   783.698030  2602.973023   218.552779   \n",
       "stay_work  1886.816289  1013.059323  1165.977649  2714.423528   217.642672   \n",
       "day_tour   8089.388914  2241.074735  1048.740441  4090.347226   164.164248   \n",
       "day_home   1476.630386  1033.856475   176.768113   974.601011     8.985964   \n",
       "day_work   2765.073465  1377.506195   236.926044  1560.843464     0.000000   \n",
       "\n",
       "                  Asia       Europ   N_America  S_America     Africa  \\\n",
       "stay_tour  1342.499158  252.743681  668.267156   0.000000  10.227739   \n",
       "stay_home   317.169702    0.000000  118.927178   0.000000   0.000000   \n",
       "stay_work   697.823265  368.807023  207.017894  28.723752  10.919591   \n",
       "day_tour      0.000000    0.000000    0.000000   0.000000   0.000000   \n",
       "day_home      0.000000    0.000000    0.000000   0.000000   0.000000   \n",
       "day_work      0.000000    0.000000    0.000000   0.000000   0.000000   \n",
       "\n",
       "              Oceania  \n",
       "stay_tour  149.536219  \n",
       "stay_home   22.444501  \n",
       "stay_work   44.635789  \n",
       "day_tour     0.000000  \n",
       "day_home     0.000000  \n",
       "day_work     0.000000  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201710"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hokakido</th>\n",
       "      <th>Touhoku</th>\n",
       "      <th>Kanto</th>\n",
       "      <th>Hokuriku</th>\n",
       "      <th>Tyuubu</th>\n",
       "      <th>Kinki</th>\n",
       "      <th>Tyuugoku</th>\n",
       "      <th>Shikoku</th>\n",
       "      <th>Kyusyu</th>\n",
       "      <th>Okinawa</th>\n",
       "      <th>Asia</th>\n",
       "      <th>Europ</th>\n",
       "      <th>N_America</th>\n",
       "      <th>S_America</th>\n",
       "      <th>Africa</th>\n",
       "      <th>Oceania</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>stay_tour</th>\n",
       "      <td>3685.041760</td>\n",
       "      <td>4710.902768</td>\n",
       "      <td>14858.716063</td>\n",
       "      <td>7389.670550</td>\n",
       "      <td>8406.207944</td>\n",
       "      <td>7581.144227</td>\n",
       "      <td>2492.329079</td>\n",
       "      <td>1032.372864</td>\n",
       "      <td>4673.911653</td>\n",
       "      <td>1657.116023</td>\n",
       "      <td>1493.756672</td>\n",
       "      <td>560.659508</td>\n",
       "      <td>815.983456</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>363.744329</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home</th>\n",
       "      <td>1905.345734</td>\n",
       "      <td>4076.445604</td>\n",
       "      <td>4816.154498</td>\n",
       "      <td>2099.624297</td>\n",
       "      <td>2865.809780</td>\n",
       "      <td>3360.230386</td>\n",
       "      <td>2367.127440</td>\n",
       "      <td>1614.308005</td>\n",
       "      <td>4257.090266</td>\n",
       "      <td>152.902953</td>\n",
       "      <td>281.442604</td>\n",
       "      <td>46.440686</td>\n",
       "      <td>286.024692</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.178129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_work</th>\n",
       "      <td>796.500374</td>\n",
       "      <td>1351.858394</td>\n",
       "      <td>4288.399070</td>\n",
       "      <td>980.201679</td>\n",
       "      <td>1623.487913</td>\n",
       "      <td>2116.160642</td>\n",
       "      <td>703.750890</td>\n",
       "      <td>720.406876</td>\n",
       "      <td>853.391329</td>\n",
       "      <td>211.119612</td>\n",
       "      <td>501.630611</td>\n",
       "      <td>292.980450</td>\n",
       "      <td>203.511659</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.971273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_tour</th>\n",
       "      <td>2404.659514</td>\n",
       "      <td>4549.906155</td>\n",
       "      <td>19582.023377</td>\n",
       "      <td>4438.174199</td>\n",
       "      <td>8577.537498</td>\n",
       "      <td>10233.028928</td>\n",
       "      <td>3116.936257</td>\n",
       "      <td>1229.396446</td>\n",
       "      <td>4660.449793</td>\n",
       "      <td>255.756853</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home</th>\n",
       "      <td>882.182164</td>\n",
       "      <td>1447.362068</td>\n",
       "      <td>4421.350402</td>\n",
       "      <td>948.579303</td>\n",
       "      <td>2319.406551</td>\n",
       "      <td>2272.152426</td>\n",
       "      <td>916.314457</td>\n",
       "      <td>616.961252</td>\n",
       "      <td>1543.870960</td>\n",
       "      <td>23.305581</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work</th>\n",
       "      <td>502.564902</td>\n",
       "      <td>671.605880</td>\n",
       "      <td>5166.706278</td>\n",
       "      <td>337.322076</td>\n",
       "      <td>2368.535537</td>\n",
       "      <td>3054.331743</td>\n",
       "      <td>1260.838445</td>\n",
       "      <td>1051.080920</td>\n",
       "      <td>1322.495348</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Hokakido      Touhoku         Kanto     Hokuriku       Tyuubu  \\\n",
       "stay_tour  3685.041760  4710.902768  14858.716063  7389.670550  8406.207944   \n",
       "stay_home  1905.345734  4076.445604   4816.154498  2099.624297  2865.809780   \n",
       "stay_work   796.500374  1351.858394   4288.399070   980.201679  1623.487913   \n",
       "day_tour   2404.659514  4549.906155  19582.023377  4438.174199  8577.537498   \n",
       "day_home    882.182164  1447.362068   4421.350402   948.579303  2319.406551   \n",
       "day_work    502.564902   671.605880   5166.706278   337.322076  2368.535537   \n",
       "\n",
       "                  Kinki     Tyuugoku      Shikoku       Kyusyu      Okinawa  \\\n",
       "stay_tour   7581.144227  2492.329079  1032.372864  4673.911653  1657.116023   \n",
       "stay_home   3360.230386  2367.127440  1614.308005  4257.090266   152.902953   \n",
       "stay_work   2116.160642   703.750890   720.406876   853.391329   211.119612   \n",
       "day_tour   10233.028928  3116.936257  1229.396446  4660.449793   255.756853   \n",
       "day_home    2272.152426   916.314457   616.961252  1543.870960    23.305581   \n",
       "day_work    3054.331743  1260.838445  1051.080920  1322.495348     0.000000   \n",
       "\n",
       "                  Asia       Europ   N_America  S_America  Africa     Oceania  \n",
       "stay_tour  1493.756672  560.659508  815.983456        0.0     0.0  363.744329  \n",
       "stay_home   281.442604   46.440686  286.024692        0.0     0.0    7.178129  \n",
       "stay_work   501.630611  292.980450  203.511659        0.0     0.0   29.971273  \n",
       "day_tour      0.000000    0.000000    0.000000        0.0     0.0    0.000000  \n",
       "day_home      0.000000    0.000000    0.000000        0.0     0.0    0.000000  \n",
       "day_work      0.000000    0.000000    0.000000        0.0     0.0    0.000000  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201707"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hokakido</th>\n",
       "      <th>Touhoku</th>\n",
       "      <th>Kanto</th>\n",
       "      <th>Hokuriku</th>\n",
       "      <th>Tyuubu</th>\n",
       "      <th>Kinki</th>\n",
       "      <th>Tyuugoku</th>\n",
       "      <th>Shikoku</th>\n",
       "      <th>Kyusyu</th>\n",
       "      <th>Okinawa</th>\n",
       "      <th>Asia</th>\n",
       "      <th>Europ</th>\n",
       "      <th>N_America</th>\n",
       "      <th>S_America</th>\n",
       "      <th>Africa</th>\n",
       "      <th>Oceania</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>stay_tour</th>\n",
       "      <td>2365.287343</td>\n",
       "      <td>3437.984355</td>\n",
       "      <td>11967.688107</td>\n",
       "      <td>4859.599628</td>\n",
       "      <td>6148.257370</td>\n",
       "      <td>6169.084854</td>\n",
       "      <td>1897.291657</td>\n",
       "      <td>1165.494750</td>\n",
       "      <td>4160.863353</td>\n",
       "      <td>1240.372885</td>\n",
       "      <td>1367.959262</td>\n",
       "      <td>403.860887</td>\n",
       "      <td>480.688322</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.743393</td>\n",
       "      <td>199.032419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home</th>\n",
       "      <td>1149.099430</td>\n",
       "      <td>2644.438288</td>\n",
       "      <td>5464.416775</td>\n",
       "      <td>1218.412916</td>\n",
       "      <td>2410.732410</td>\n",
       "      <td>2728.156633</td>\n",
       "      <td>1765.341711</td>\n",
       "      <td>1027.244621</td>\n",
       "      <td>2755.726262</td>\n",
       "      <td>269.596865</td>\n",
       "      <td>206.343880</td>\n",
       "      <td>34.765708</td>\n",
       "      <td>144.687177</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>32.185573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_work</th>\n",
       "      <td>693.436973</td>\n",
       "      <td>1052.256936</td>\n",
       "      <td>4688.660152</td>\n",
       "      <td>742.517770</td>\n",
       "      <td>2001.321974</td>\n",
       "      <td>2176.234384</td>\n",
       "      <td>746.840389</td>\n",
       "      <td>292.359892</td>\n",
       "      <td>1331.978172</td>\n",
       "      <td>493.761880</td>\n",
       "      <td>589.565495</td>\n",
       "      <td>202.217901</td>\n",
       "      <td>166.244135</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_tour</th>\n",
       "      <td>2469.587284</td>\n",
       "      <td>4173.156184</td>\n",
       "      <td>21449.177575</td>\n",
       "      <td>3465.769833</td>\n",
       "      <td>7771.370333</td>\n",
       "      <td>10661.379585</td>\n",
       "      <td>3445.630431</td>\n",
       "      <td>1333.650366</td>\n",
       "      <td>4980.083658</td>\n",
       "      <td>138.800304</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home</th>\n",
       "      <td>632.470586</td>\n",
       "      <td>798.403118</td>\n",
       "      <td>3866.720537</td>\n",
       "      <td>619.222943</td>\n",
       "      <td>2108.645209</td>\n",
       "      <td>1836.625156</td>\n",
       "      <td>985.683577</td>\n",
       "      <td>427.312171</td>\n",
       "      <td>1145.142127</td>\n",
       "      <td>83.197692</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work</th>\n",
       "      <td>723.202121</td>\n",
       "      <td>1725.516807</td>\n",
       "      <td>5550.342525</td>\n",
       "      <td>562.961551</td>\n",
       "      <td>1718.424919</td>\n",
       "      <td>2977.497198</td>\n",
       "      <td>1152.066061</td>\n",
       "      <td>705.090595</td>\n",
       "      <td>1927.821462</td>\n",
       "      <td>8.944164</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Hokakido      Touhoku         Kanto     Hokuriku       Tyuubu  \\\n",
       "stay_tour  2365.287343  3437.984355  11967.688107  4859.599628  6148.257370   \n",
       "stay_home  1149.099430  2644.438288   5464.416775  1218.412916  2410.732410   \n",
       "stay_work   693.436973  1052.256936   4688.660152   742.517770  2001.321974   \n",
       "day_tour   2469.587284  4173.156184  21449.177575  3465.769833  7771.370333   \n",
       "day_home    632.470586   798.403118   3866.720537   619.222943  2108.645209   \n",
       "day_work    723.202121  1725.516807   5550.342525   562.961551  1718.424919   \n",
       "\n",
       "                  Kinki     Tyuugoku      Shikoku       Kyusyu      Okinawa  \\\n",
       "stay_tour   6169.084854  1897.291657  1165.494750  4160.863353  1240.372885   \n",
       "stay_home   2728.156633  1765.341711  1027.244621  2755.726262   269.596865   \n",
       "stay_work   2176.234384   746.840389   292.359892  1331.978172   493.761880   \n",
       "day_tour   10661.379585  3445.630431  1333.650366  4980.083658   138.800304   \n",
       "day_home    1836.625156   985.683577   427.312171  1145.142127    83.197692   \n",
       "day_work    2977.497198  1152.066061   705.090595  1927.821462     8.944164   \n",
       "\n",
       "                  Asia       Europ   N_America  S_America     Africa  \\\n",
       "stay_tour  1367.959262  403.860887  480.688322        0.0  17.743393   \n",
       "stay_home   206.343880   34.765708  144.687177        0.0   0.000000   \n",
       "stay_work   589.565495  202.217901  166.244135        0.0   0.000000   \n",
       "day_tour      0.000000    0.000000    0.000000        0.0   0.000000   \n",
       "day_home      0.000000    0.000000    0.000000        0.0   0.000000   \n",
       "day_work      0.000000    0.000000    0.000000        0.0   0.000000   \n",
       "\n",
       "              Oceania  \n",
       "stay_tour  199.032419  \n",
       "stay_home   32.185573  \n",
       "stay_work    0.000000  \n",
       "day_tour     0.000000  \n",
       "day_home     0.000000  \n",
       "day_work     0.000000  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201704"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hokakido</th>\n",
       "      <th>Touhoku</th>\n",
       "      <th>Kanto</th>\n",
       "      <th>Hokuriku</th>\n",
       "      <th>Tyuubu</th>\n",
       "      <th>Kinki</th>\n",
       "      <th>Tyuugoku</th>\n",
       "      <th>Shikoku</th>\n",
       "      <th>Kyusyu</th>\n",
       "      <th>Okinawa</th>\n",
       "      <th>Asia</th>\n",
       "      <th>Europ</th>\n",
       "      <th>N_America</th>\n",
       "      <th>S_America</th>\n",
       "      <th>Africa</th>\n",
       "      <th>Oceania</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>stay_tour</th>\n",
       "      <td>1567.529947</td>\n",
       "      <td>2727.927092</td>\n",
       "      <td>9560.706409</td>\n",
       "      <td>3454.572725</td>\n",
       "      <td>6582.962973</td>\n",
       "      <td>5053.372477</td>\n",
       "      <td>1860.677127</td>\n",
       "      <td>1147.793911</td>\n",
       "      <td>3347.711590</td>\n",
       "      <td>1342.278911</td>\n",
       "      <td>1793.057486</td>\n",
       "      <td>485.406578</td>\n",
       "      <td>600.813532</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>25.363893</td>\n",
       "      <td>318.323123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home</th>\n",
       "      <td>1332.368044</td>\n",
       "      <td>1716.774479</td>\n",
       "      <td>5984.463754</td>\n",
       "      <td>1808.420026</td>\n",
       "      <td>2680.091504</td>\n",
       "      <td>2836.834038</td>\n",
       "      <td>1510.433979</td>\n",
       "      <td>1101.879080</td>\n",
       "      <td>2974.190848</td>\n",
       "      <td>435.537111</td>\n",
       "      <td>200.197887</td>\n",
       "      <td>38.338868</td>\n",
       "      <td>76.232762</td>\n",
       "      <td>60.340419</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>34.202665</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_work</th>\n",
       "      <td>451.967787</td>\n",
       "      <td>908.804144</td>\n",
       "      <td>3245.974067</td>\n",
       "      <td>1300.855666</td>\n",
       "      <td>1380.385025</td>\n",
       "      <td>1559.961444</td>\n",
       "      <td>554.948534</td>\n",
       "      <td>79.666197</td>\n",
       "      <td>897.705792</td>\n",
       "      <td>117.719488</td>\n",
       "      <td>633.277442</td>\n",
       "      <td>100.728967</td>\n",
       "      <td>200.367713</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_tour</th>\n",
       "      <td>1757.850562</td>\n",
       "      <td>1799.043606</td>\n",
       "      <td>14948.966063</td>\n",
       "      <td>2380.390699</td>\n",
       "      <td>6875.246108</td>\n",
       "      <td>7483.312489</td>\n",
       "      <td>1836.524099</td>\n",
       "      <td>972.478748</td>\n",
       "      <td>3582.124658</td>\n",
       "      <td>48.143223</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home</th>\n",
       "      <td>387.785289</td>\n",
       "      <td>865.136872</td>\n",
       "      <td>4082.849722</td>\n",
       "      <td>456.572764</td>\n",
       "      <td>1767.402490</td>\n",
       "      <td>2038.172803</td>\n",
       "      <td>753.773348</td>\n",
       "      <td>453.266537</td>\n",
       "      <td>1265.478360</td>\n",
       "      <td>12.882106</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work</th>\n",
       "      <td>549.633767</td>\n",
       "      <td>840.812577</td>\n",
       "      <td>5730.959041</td>\n",
       "      <td>1014.186662</td>\n",
       "      <td>1814.349120</td>\n",
       "      <td>1868.094766</td>\n",
       "      <td>781.576838</td>\n",
       "      <td>732.774027</td>\n",
       "      <td>176.283844</td>\n",
       "      <td>284.724944</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Hokakido      Touhoku         Kanto     Hokuriku       Tyuubu  \\\n",
       "stay_tour  1567.529947  2727.927092   9560.706409  3454.572725  6582.962973   \n",
       "stay_home  1332.368044  1716.774479   5984.463754  1808.420026  2680.091504   \n",
       "stay_work   451.967787   908.804144   3245.974067  1300.855666  1380.385025   \n",
       "day_tour   1757.850562  1799.043606  14948.966063  2380.390699  6875.246108   \n",
       "day_home    387.785289   865.136872   4082.849722   456.572764  1767.402490   \n",
       "day_work    549.633767   840.812577   5730.959041  1014.186662  1814.349120   \n",
       "\n",
       "                 Kinki     Tyuugoku      Shikoku       Kyusyu      Okinawa  \\\n",
       "stay_tour  5053.372477  1860.677127  1147.793911  3347.711590  1342.278911   \n",
       "stay_home  2836.834038  1510.433979  1101.879080  2974.190848   435.537111   \n",
       "stay_work  1559.961444   554.948534    79.666197   897.705792   117.719488   \n",
       "day_tour   7483.312489  1836.524099   972.478748  3582.124658    48.143223   \n",
       "day_home   2038.172803   753.773348   453.266537  1265.478360    12.882106   \n",
       "day_work   1868.094766   781.576838   732.774027   176.283844   284.724944   \n",
       "\n",
       "                  Asia       Europ   N_America  S_America     Africa  \\\n",
       "stay_tour  1793.057486  485.406578  600.813532   0.000000  25.363893   \n",
       "stay_home   200.197887   38.338868   76.232762  60.340419   0.000000   \n",
       "stay_work   633.277442  100.728967  200.367713   0.000000   0.000000   \n",
       "day_tour      0.000000    0.000000    0.000000   0.000000   0.000000   \n",
       "day_home      0.000000    0.000000    0.000000   0.000000   0.000000   \n",
       "day_work      0.000000    0.000000    0.000000   0.000000   0.000000   \n",
       "\n",
       "              Oceania  \n",
       "stay_tour  318.323123  \n",
       "stay_home   34.202665  \n",
       "stay_work    0.000000  \n",
       "day_tour     0.000000  \n",
       "day_home     0.000000  \n",
       "day_work     0.000000  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201701"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "def to_Series(df,col):\n",
    "    se = df.stack().reset_index(name=col)\n",
    "    ind = se[\"level_0\"] + \"_\" + se[\"level_1\"]\n",
    "    se.drop([\"level_0\",\"level_1\"],axis=1,inplace=True)\n",
    "    se.index = ind\n",
    "    \n",
    "    return se"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_201810 = to_Series(df_201810,\"201810\")\n",
    "df_201807= to_Series(df_201807,\"201807\")\n",
    "df_201804 = to_Series(df_201804,\"201804\")\n",
    "df_201801 = to_Series(df_201801,\"201801\")\n",
    "df_201710 = to_Series(df_201710,\"201710\")\n",
    "df_201707 = to_Series(df_201707,\"201707\")\n",
    "df_201704 = to_Series(df_201704,\"201704\")\n",
    "df_201701 = to_Series(df_201701,\"201701\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>201810</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>stay_tour_Hokakido</th>\n",
       "      <td>1714.172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Touhoku</th>\n",
       "      <td>2837.495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Kanto</th>\n",
       "      <td>9893.941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Hokuriku</th>\n",
       "      <td>4516.078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Tyuubu</th>\n",
       "      <td>4696.647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Kinki</th>\n",
       "      <td>5532.736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Tyuugoku</th>\n",
       "      <td>1927.364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Shikoku</th>\n",
       "      <td>806.145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Kyusyu</th>\n",
       "      <td>2937.590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Okinawa</th>\n",
       "      <td>1340.795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Asia</th>\n",
       "      <td>1696.653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Europ</th>\n",
       "      <td>573.782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_N_America</th>\n",
       "      <td>472.301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_S_America</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Africa</th>\n",
       "      <td>14.443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_tour_Oceania</th>\n",
       "      <td>188.650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Hokakido</th>\n",
       "      <td>768.723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Touhoku</th>\n",
       "      <td>1742.053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Kanto</th>\n",
       "      <td>3413.347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Hokuriku</th>\n",
       "      <td>1232.461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Tyuubu</th>\n",
       "      <td>1699.309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Kinki</th>\n",
       "      <td>1871.759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Tyuugoku</th>\n",
       "      <td>852.866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Shikoku</th>\n",
       "      <td>755.348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Kyusyu</th>\n",
       "      <td>1700.627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Okinawa</th>\n",
       "      <td>220.233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Asia</th>\n",
       "      <td>106.265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_Europ</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_N_America</th>\n",
       "      <td>87.426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stay_home_S_America</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Kanto</th>\n",
       "      <td>2665.669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Hokuriku</th>\n",
       "      <td>551.827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Tyuubu</th>\n",
       "      <td>1050.397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Kinki</th>\n",
       "      <td>1709.329</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Tyuugoku</th>\n",
       "      <td>686.385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Shikoku</th>\n",
       "      <td>166.031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Kyusyu</th>\n",
       "      <td>761.976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Okinawa</th>\n",
       "      <td>7.904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Asia</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Europ</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_N_America</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_S_America</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Africa</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_home_Oceania</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Hokakido</th>\n",
       "      <td>358.509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Touhoku</th>\n",
       "      <td>725.239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Kanto</th>\n",
       "      <td>3611.690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Hokuriku</th>\n",
       "      <td>636.989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Tyuubu</th>\n",
       "      <td>1233.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Kinki</th>\n",
       "      <td>1627.656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Tyuugoku</th>\n",
       "      <td>947.348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Shikoku</th>\n",
       "      <td>199.301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Kyusyu</th>\n",
       "      <td>618.987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Okinawa</th>\n",
       "      <td>8.561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Asia</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Europ</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_N_America</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_S_America</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Africa</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day_work_Oceania</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>96 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       201810\n",
       "stay_tour_Hokakido   1714.172\n",
       "stay_tour_Touhoku    2837.495\n",
       "stay_tour_Kanto      9893.941\n",
       "stay_tour_Hokuriku   4516.078\n",
       "stay_tour_Tyuubu     4696.647\n",
       "stay_tour_Kinki      5532.736\n",
       "stay_tour_Tyuugoku   1927.364\n",
       "stay_tour_Shikoku     806.145\n",
       "stay_tour_Kyusyu     2937.590\n",
       "stay_tour_Okinawa    1340.795\n",
       "stay_tour_Asia       1696.653\n",
       "stay_tour_Europ       573.782\n",
       "stay_tour_N_America   472.301\n",
       "stay_tour_S_America     0.000\n",
       "stay_tour_Africa       14.443\n",
       "stay_tour_Oceania     188.650\n",
       "stay_home_Hokakido    768.723\n",
       "stay_home_Touhoku    1742.053\n",
       "stay_home_Kanto      3413.347\n",
       "stay_home_Hokuriku   1232.461\n",
       "stay_home_Tyuubu     1699.309\n",
       "stay_home_Kinki      1871.759\n",
       "stay_home_Tyuugoku    852.866\n",
       "stay_home_Shikoku     755.348\n",
       "stay_home_Kyusyu     1700.627\n",
       "stay_home_Okinawa     220.233\n",
       "stay_home_Asia        106.265\n",
       "stay_home_Europ         0.000\n",
       "stay_home_N_America    87.426\n",
       "stay_home_S_America     0.000\n",
       "...                       ...\n",
       "day_home_Kanto       2665.669\n",
       "day_home_Hokuriku     551.827\n",
       "day_home_Tyuubu      1050.397\n",
       "day_home_Kinki       1709.329\n",
       "day_home_Tyuugoku     686.385\n",
       "day_home_Shikoku      166.031\n",
       "day_home_Kyusyu       761.976\n",
       "day_home_Okinawa        7.904\n",
       "day_home_Asia           0.000\n",
       "day_home_Europ          0.000\n",
       "day_home_N_America      0.000\n",
       "day_home_S_America      0.000\n",
       "day_home_Africa         0.000\n",
       "day_home_Oceania        0.000\n",
       "day_work_Hokakido     358.509\n",
       "day_work_Touhoku      725.239\n",
       "day_work_Kanto       3611.690\n",
       "day_work_Hokuriku     636.989\n",
       "day_work_Tyuubu      1233.133\n",
       "day_work_Kinki       1627.656\n",
       "day_work_Tyuugoku     947.348\n",
       "day_work_Shikoku      199.301\n",
       "day_work_Kyusyu       618.987\n",
       "day_work_Okinawa        8.561\n",
       "day_work_Asia           0.000\n",
       "day_work_Europ          0.000\n",
       "day_work_N_America      0.000\n",
       "day_work_S_America      0.000\n",
       "day_work_Africa         0.000\n",
       "day_work_Oceania        0.000\n",
       "\n",
       "[96 rows x 1 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201810"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "trip = pd.concat([df_201810,df_201807,df_201804,df_201801,df_201710,df_201707,df_201704,df_201701],axis=1).T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>stay_tour_Hokakido</th>\n",
       "      <th>stay_tour_Touhoku</th>\n",
       "      <th>stay_tour_Kanto</th>\n",
       "      <th>stay_tour_Hokuriku</th>\n",
       "      <th>stay_tour_Tyuubu</th>\n",
       "      <th>stay_tour_Kinki</th>\n",
       "      <th>stay_tour_Tyuugoku</th>\n",
       "      <th>stay_tour_Shikoku</th>\n",
       "      <th>stay_tour_Kyusyu</th>\n",
       "      <th>stay_tour_Okinawa</th>\n",
       "      <th>...</th>\n",
       "      <th>day_work_Tyuugoku</th>\n",
       "      <th>day_work_Shikoku</th>\n",
       "      <th>day_work_Kyusyu</th>\n",
       "      <th>day_work_Okinawa</th>\n",
       "      <th>day_work_Asia</th>\n",
       "      <th>day_work_Europ</th>\n",
       "      <th>day_work_N_America</th>\n",
       "      <th>day_work_S_America</th>\n",
       "      <th>day_work_Africa</th>\n",
       "      <th>day_work_Oceania</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>201810</th>\n",
       "      <td>1714.172000</td>\n",
       "      <td>2837.495000</td>\n",
       "      <td>9893.941000</td>\n",
       "      <td>4516.078000</td>\n",
       "      <td>4696.647000</td>\n",
       "      <td>5532.736000</td>\n",
       "      <td>1927.364000</td>\n",
       "      <td>806.145000</td>\n",
       "      <td>2937.590000</td>\n",
       "      <td>1340.795000</td>\n",
       "      <td>...</td>\n",
       "      <td>947.348000</td>\n",
       "      <td>199.301000</td>\n",
       "      <td>618.987000</td>\n",
       "      <td>8.561000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201807</th>\n",
       "      <td>3025.337000</td>\n",
       "      <td>3798.449000</td>\n",
       "      <td>14639.905000</td>\n",
       "      <td>6222.936000</td>\n",
       "      <td>6972.292000</td>\n",
       "      <td>7386.638000</td>\n",
       "      <td>2200.846000</td>\n",
       "      <td>1138.843000</td>\n",
       "      <td>4462.213000</td>\n",
       "      <td>1618.033000</td>\n",
       "      <td>...</td>\n",
       "      <td>707.889000</td>\n",
       "      <td>82.597000</td>\n",
       "      <td>767.420000</td>\n",
       "      <td>61.503000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201804</th>\n",
       "      <td>2246.328000</td>\n",
       "      <td>2931.360000</td>\n",
       "      <td>10423.650000</td>\n",
       "      <td>3918.415000</td>\n",
       "      <td>4654.961000</td>\n",
       "      <td>5446.973000</td>\n",
       "      <td>2001.926000</td>\n",
       "      <td>957.212000</td>\n",
       "      <td>2991.677000</td>\n",
       "      <td>1141.215000</td>\n",
       "      <td>...</td>\n",
       "      <td>631.135000</td>\n",
       "      <td>140.274000</td>\n",
       "      <td>927.494000</td>\n",
       "      <td>12.356000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201801</th>\n",
       "      <td>1678.891000</td>\n",
       "      <td>2307.806000</td>\n",
       "      <td>8511.584000</td>\n",
       "      <td>4208.793000</td>\n",
       "      <td>4840.223000</td>\n",
       "      <td>6893.330000</td>\n",
       "      <td>1221.969000</td>\n",
       "      <td>942.424000</td>\n",
       "      <td>2498.285000</td>\n",
       "      <td>1200.180000</td>\n",
       "      <td>...</td>\n",
       "      <td>294.110000</td>\n",
       "      <td>56.878000</td>\n",
       "      <td>1645.953000</td>\n",
       "      <td>21.171000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201710</th>\n",
       "      <td>1737.721011</td>\n",
       "      <td>3043.499685</td>\n",
       "      <td>10697.296494</td>\n",
       "      <td>4273.182148</td>\n",
       "      <td>5755.830116</td>\n",
       "      <td>6672.438355</td>\n",
       "      <td>2280.453698</td>\n",
       "      <td>1041.401360</td>\n",
       "      <td>3716.095664</td>\n",
       "      <td>1274.783622</td>\n",
       "      <td>...</td>\n",
       "      <td>1377.506195</td>\n",
       "      <td>236.926044</td>\n",
       "      <td>1560.843464</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201707</th>\n",
       "      <td>3685.041760</td>\n",
       "      <td>4710.902768</td>\n",
       "      <td>14858.716063</td>\n",
       "      <td>7389.670550</td>\n",
       "      <td>8406.207944</td>\n",
       "      <td>7581.144227</td>\n",
       "      <td>2492.329079</td>\n",
       "      <td>1032.372864</td>\n",
       "      <td>4673.911653</td>\n",
       "      <td>1657.116023</td>\n",
       "      <td>...</td>\n",
       "      <td>1260.838445</td>\n",
       "      <td>1051.080920</td>\n",
       "      <td>1322.495348</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201704</th>\n",
       "      <td>2365.287343</td>\n",
       "      <td>3437.984355</td>\n",
       "      <td>11967.688107</td>\n",
       "      <td>4859.599628</td>\n",
       "      <td>6148.257370</td>\n",
       "      <td>6169.084854</td>\n",
       "      <td>1897.291657</td>\n",
       "      <td>1165.494750</td>\n",
       "      <td>4160.863353</td>\n",
       "      <td>1240.372885</td>\n",
       "      <td>...</td>\n",
       "      <td>1152.066061</td>\n",
       "      <td>705.090595</td>\n",
       "      <td>1927.821462</td>\n",
       "      <td>8.944164</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201701</th>\n",
       "      <td>1567.529947</td>\n",
       "      <td>2727.927092</td>\n",
       "      <td>9560.706409</td>\n",
       "      <td>3454.572725</td>\n",
       "      <td>6582.962973</td>\n",
       "      <td>5053.372477</td>\n",
       "      <td>1860.677127</td>\n",
       "      <td>1147.793911</td>\n",
       "      <td>3347.711590</td>\n",
       "      <td>1342.278911</td>\n",
       "      <td>...</td>\n",
       "      <td>781.576838</td>\n",
       "      <td>732.774027</td>\n",
       "      <td>176.283844</td>\n",
       "      <td>284.724944</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 96 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        stay_tour_Hokakido  stay_tour_Touhoku  stay_tour_Kanto  \\\n",
       "201810         1714.172000        2837.495000      9893.941000   \n",
       "201807         3025.337000        3798.449000     14639.905000   \n",
       "201804         2246.328000        2931.360000     10423.650000   \n",
       "201801         1678.891000        2307.806000      8511.584000   \n",
       "201710         1737.721011        3043.499685     10697.296494   \n",
       "201707         3685.041760        4710.902768     14858.716063   \n",
       "201704         2365.287343        3437.984355     11967.688107   \n",
       "201701         1567.529947        2727.927092      9560.706409   \n",
       "\n",
       "        stay_tour_Hokuriku  stay_tour_Tyuubu  stay_tour_Kinki  \\\n",
       "201810         4516.078000       4696.647000      5532.736000   \n",
       "201807         6222.936000       6972.292000      7386.638000   \n",
       "201804         3918.415000       4654.961000      5446.973000   \n",
       "201801         4208.793000       4840.223000      6893.330000   \n",
       "201710         4273.182148       5755.830116      6672.438355   \n",
       "201707         7389.670550       8406.207944      7581.144227   \n",
       "201704         4859.599628       6148.257370      6169.084854   \n",
       "201701         3454.572725       6582.962973      5053.372477   \n",
       "\n",
       "        stay_tour_Tyuugoku  stay_tour_Shikoku  stay_tour_Kyusyu  \\\n",
       "201810         1927.364000         806.145000       2937.590000   \n",
       "201807         2200.846000        1138.843000       4462.213000   \n",
       "201804         2001.926000         957.212000       2991.677000   \n",
       "201801         1221.969000         942.424000       2498.285000   \n",
       "201710         2280.453698        1041.401360       3716.095664   \n",
       "201707         2492.329079        1032.372864       4673.911653   \n",
       "201704         1897.291657        1165.494750       4160.863353   \n",
       "201701         1860.677127        1147.793911       3347.711590   \n",
       "\n",
       "        stay_tour_Okinawa        ...         day_work_Tyuugoku  \\\n",
       "201810        1340.795000        ...                947.348000   \n",
       "201807        1618.033000        ...                707.889000   \n",
       "201804        1141.215000        ...                631.135000   \n",
       "201801        1200.180000        ...                294.110000   \n",
       "201710        1274.783622        ...               1377.506195   \n",
       "201707        1657.116023        ...               1260.838445   \n",
       "201704        1240.372885        ...               1152.066061   \n",
       "201701        1342.278911        ...                781.576838   \n",
       "\n",
       "        day_work_Shikoku  day_work_Kyusyu  day_work_Okinawa  day_work_Asia  \\\n",
       "201810        199.301000       618.987000          8.561000            0.0   \n",
       "201807         82.597000       767.420000         61.503000            0.0   \n",
       "201804        140.274000       927.494000         12.356000            0.0   \n",
       "201801         56.878000      1645.953000         21.171000            0.0   \n",
       "201710        236.926044      1560.843464          0.000000            0.0   \n",
       "201707       1051.080920      1322.495348          0.000000            0.0   \n",
       "201704        705.090595      1927.821462          8.944164            0.0   \n",
       "201701        732.774027       176.283844        284.724944            0.0   \n",
       "\n",
       "        day_work_Europ  day_work_N_America  day_work_S_America  \\\n",
       "201810             0.0                 0.0                 0.0   \n",
       "201807             0.0                 0.0                 0.0   \n",
       "201804             0.0                 0.0                 0.0   \n",
       "201801             0.0                 0.0                 0.0   \n",
       "201710             0.0                 0.0                 0.0   \n",
       "201707             0.0                 0.0                 0.0   \n",
       "201704             0.0                 0.0                 0.0   \n",
       "201701             0.0                 0.0                 0.0   \n",
       "\n",
       "        day_work_Africa  day_work_Oceania  \n",
       "201810              0.0               0.0  \n",
       "201807              0.0               0.0  \n",
       "201804              0.0               0.0  \n",
       "201801              0.0               0.0  \n",
       "201710              0.0               0.0  \n",
       "201707              0.0               0.0  \n",
       "201704              0.0               0.0  \n",
       "201701              0.0               0.0  \n",
       "\n",
       "[8 rows x 96 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trip"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['stay_home_Africa', 'day_tour_Asia', 'day_tour_Europ',\n",
       "       'day_tour_N_America', 'day_tour_S_America', 'day_tour_Africa',\n",
       "       'day_tour_Oceania', 'day_home_Asia', 'day_home_Europ',\n",
       "       'day_home_N_America', 'day_home_S_America', 'day_home_Africa',\n",
       "       'day_home_Oceania', 'day_work_Asia', 'day_work_Europ',\n",
       "       'day_work_N_America', 'day_work_S_America', 'day_work_Africa',\n",
       "       'day_work_Oceania'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trip.columns[(trip.sum() == 0).tolist()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "trip.drop(trip.columns[(trip.sum() == 0).tolist()],axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>term</th>\n",
       "      <th>stay_tour_Hokakido</th>\n",
       "      <th>stay_tour_Touhoku</th>\n",
       "      <th>stay_tour_Kanto</th>\n",
       "      <th>stay_tour_Hokuriku</th>\n",
       "      <th>stay_tour_Tyuubu</th>\n",
       "      <th>stay_tour_Kinki</th>\n",
       "      <th>stay_tour_Tyuugoku</th>\n",
       "      <th>stay_tour_Shikoku</th>\n",
       "      <th>stay_tour_Kyusyu</th>\n",
       "      <th>...</th>\n",
       "      <th>day_work_Hokakido</th>\n",
       "      <th>day_work_Touhoku</th>\n",
       "      <th>day_work_Kanto</th>\n",
       "      <th>day_work_Hokuriku</th>\n",
       "      <th>day_work_Tyuubu</th>\n",
       "      <th>day_work_Kinki</th>\n",
       "      <th>day_work_Tyuugoku</th>\n",
       "      <th>day_work_Shikoku</th>\n",
       "      <th>day_work_Kyusyu</th>\n",
       "      <th>day_work_Okinawa</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>201810</td>\n",
       "      <td>1714.172000</td>\n",
       "      <td>2837.495000</td>\n",
       "      <td>9893.941000</td>\n",
       "      <td>4516.078000</td>\n",
       "      <td>4696.647000</td>\n",
       "      <td>5532.736000</td>\n",
       "      <td>1927.364000</td>\n",
       "      <td>806.145000</td>\n",
       "      <td>2937.590000</td>\n",
       "      <td>...</td>\n",
       "      <td>358.509000</td>\n",
       "      <td>725.239000</td>\n",
       "      <td>3611.690000</td>\n",
       "      <td>636.989000</td>\n",
       "      <td>1233.133000</td>\n",
       "      <td>1627.656000</td>\n",
       "      <td>947.348000</td>\n",
       "      <td>199.301000</td>\n",
       "      <td>618.987000</td>\n",
       "      <td>8.561000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>201807</td>\n",
       "      <td>3025.337000</td>\n",
       "      <td>3798.449000</td>\n",
       "      <td>14639.905000</td>\n",
       "      <td>6222.936000</td>\n",
       "      <td>6972.292000</td>\n",
       "      <td>7386.638000</td>\n",
       "      <td>2200.846000</td>\n",
       "      <td>1138.843000</td>\n",
       "      <td>4462.213000</td>\n",
       "      <td>...</td>\n",
       "      <td>344.279000</td>\n",
       "      <td>386.079000</td>\n",
       "      <td>3741.283000</td>\n",
       "      <td>705.344000</td>\n",
       "      <td>1581.033000</td>\n",
       "      <td>1030.472000</td>\n",
       "      <td>707.889000</td>\n",
       "      <td>82.597000</td>\n",
       "      <td>767.420000</td>\n",
       "      <td>61.503000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>201804</td>\n",
       "      <td>2246.328000</td>\n",
       "      <td>2931.360000</td>\n",
       "      <td>10423.650000</td>\n",
       "      <td>3918.415000</td>\n",
       "      <td>4654.961000</td>\n",
       "      <td>5446.973000</td>\n",
       "      <td>2001.926000</td>\n",
       "      <td>957.212000</td>\n",
       "      <td>2991.677000</td>\n",
       "      <td>...</td>\n",
       "      <td>242.217000</td>\n",
       "      <td>792.688000</td>\n",
       "      <td>3977.835000</td>\n",
       "      <td>261.923000</td>\n",
       "      <td>2357.588000</td>\n",
       "      <td>1498.427000</td>\n",
       "      <td>631.135000</td>\n",
       "      <td>140.274000</td>\n",
       "      <td>927.494000</td>\n",
       "      <td>12.356000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>201801</td>\n",
       "      <td>1678.891000</td>\n",
       "      <td>2307.806000</td>\n",
       "      <td>8511.584000</td>\n",
       "      <td>4208.793000</td>\n",
       "      <td>4840.223000</td>\n",
       "      <td>6893.330000</td>\n",
       "      <td>1221.969000</td>\n",
       "      <td>942.424000</td>\n",
       "      <td>2498.285000</td>\n",
       "      <td>...</td>\n",
       "      <td>288.998000</td>\n",
       "      <td>565.788000</td>\n",
       "      <td>4499.068000</td>\n",
       "      <td>289.639000</td>\n",
       "      <td>1007.634000</td>\n",
       "      <td>2150.943000</td>\n",
       "      <td>294.110000</td>\n",
       "      <td>56.878000</td>\n",
       "      <td>1645.953000</td>\n",
       "      <td>21.171000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>201710</td>\n",
       "      <td>1737.721011</td>\n",
       "      <td>3043.499685</td>\n",
       "      <td>10697.296494</td>\n",
       "      <td>4273.182148</td>\n",
       "      <td>5755.830116</td>\n",
       "      <td>6672.438355</td>\n",
       "      <td>2280.453698</td>\n",
       "      <td>1041.401360</td>\n",
       "      <td>3716.095664</td>\n",
       "      <td>...</td>\n",
       "      <td>390.370434</td>\n",
       "      <td>1107.492062</td>\n",
       "      <td>5573.149393</td>\n",
       "      <td>548.348389</td>\n",
       "      <td>2690.372265</td>\n",
       "      <td>2765.073465</td>\n",
       "      <td>1377.506195</td>\n",
       "      <td>236.926044</td>\n",
       "      <td>1560.843464</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>201707</td>\n",
       "      <td>3685.041760</td>\n",
       "      <td>4710.902768</td>\n",
       "      <td>14858.716063</td>\n",
       "      <td>7389.670550</td>\n",
       "      <td>8406.207944</td>\n",
       "      <td>7581.144227</td>\n",
       "      <td>2492.329079</td>\n",
       "      <td>1032.372864</td>\n",
       "      <td>4673.911653</td>\n",
       "      <td>...</td>\n",
       "      <td>502.564902</td>\n",
       "      <td>671.605880</td>\n",
       "      <td>5166.706278</td>\n",
       "      <td>337.322076</td>\n",
       "      <td>2368.535537</td>\n",
       "      <td>3054.331743</td>\n",
       "      <td>1260.838445</td>\n",
       "      <td>1051.080920</td>\n",
       "      <td>1322.495348</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>201704</td>\n",
       "      <td>2365.287343</td>\n",
       "      <td>3437.984355</td>\n",
       "      <td>11967.688107</td>\n",
       "      <td>4859.599628</td>\n",
       "      <td>6148.257370</td>\n",
       "      <td>6169.084854</td>\n",
       "      <td>1897.291657</td>\n",
       "      <td>1165.494750</td>\n",
       "      <td>4160.863353</td>\n",
       "      <td>...</td>\n",
       "      <td>723.202121</td>\n",
       "      <td>1725.516807</td>\n",
       "      <td>5550.342525</td>\n",
       "      <td>562.961551</td>\n",
       "      <td>1718.424919</td>\n",
       "      <td>2977.497198</td>\n",
       "      <td>1152.066061</td>\n",
       "      <td>705.090595</td>\n",
       "      <td>1927.821462</td>\n",
       "      <td>8.944164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>201701</td>\n",
       "      <td>1567.529947</td>\n",
       "      <td>2727.927092</td>\n",
       "      <td>9560.706409</td>\n",
       "      <td>3454.572725</td>\n",
       "      <td>6582.962973</td>\n",
       "      <td>5053.372477</td>\n",
       "      <td>1860.677127</td>\n",
       "      <td>1147.793911</td>\n",
       "      <td>3347.711590</td>\n",
       "      <td>...</td>\n",
       "      <td>549.633767</td>\n",
       "      <td>840.812577</td>\n",
       "      <td>5730.959041</td>\n",
       "      <td>1014.186662</td>\n",
       "      <td>1814.349120</td>\n",
       "      <td>1868.094766</td>\n",
       "      <td>781.576838</td>\n",
       "      <td>732.774027</td>\n",
       "      <td>176.283844</td>\n",
       "      <td>284.724944</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 78 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     term  stay_tour_Hokakido  stay_tour_Touhoku  stay_tour_Kanto  \\\n",
       "0  201810         1714.172000        2837.495000      9893.941000   \n",
       "1  201807         3025.337000        3798.449000     14639.905000   \n",
       "2  201804         2246.328000        2931.360000     10423.650000   \n",
       "3  201801         1678.891000        2307.806000      8511.584000   \n",
       "4  201710         1737.721011        3043.499685     10697.296494   \n",
       "5  201707         3685.041760        4710.902768     14858.716063   \n",
       "6  201704         2365.287343        3437.984355     11967.688107   \n",
       "7  201701         1567.529947        2727.927092      9560.706409   \n",
       "\n",
       "   stay_tour_Hokuriku  stay_tour_Tyuubu  stay_tour_Kinki  stay_tour_Tyuugoku  \\\n",
       "0         4516.078000       4696.647000      5532.736000         1927.364000   \n",
       "1         6222.936000       6972.292000      7386.638000         2200.846000   \n",
       "2         3918.415000       4654.961000      5446.973000         2001.926000   \n",
       "3         4208.793000       4840.223000      6893.330000         1221.969000   \n",
       "4         4273.182148       5755.830116      6672.438355         2280.453698   \n",
       "5         7389.670550       8406.207944      7581.144227         2492.329079   \n",
       "6         4859.599628       6148.257370      6169.084854         1897.291657   \n",
       "7         3454.572725       6582.962973      5053.372477         1860.677127   \n",
       "\n",
       "   stay_tour_Shikoku  stay_tour_Kyusyu        ...         day_work_Hokakido  \\\n",
       "0         806.145000       2937.590000        ...                358.509000   \n",
       "1        1138.843000       4462.213000        ...                344.279000   \n",
       "2         957.212000       2991.677000        ...                242.217000   \n",
       "3         942.424000       2498.285000        ...                288.998000   \n",
       "4        1041.401360       3716.095664        ...                390.370434   \n",
       "5        1032.372864       4673.911653        ...                502.564902   \n",
       "6        1165.494750       4160.863353        ...                723.202121   \n",
       "7        1147.793911       3347.711590        ...                549.633767   \n",
       "\n",
       "   day_work_Touhoku  day_work_Kanto  day_work_Hokuriku  day_work_Tyuubu  \\\n",
       "0        725.239000     3611.690000         636.989000      1233.133000   \n",
       "1        386.079000     3741.283000         705.344000      1581.033000   \n",
       "2        792.688000     3977.835000         261.923000      2357.588000   \n",
       "3        565.788000     4499.068000         289.639000      1007.634000   \n",
       "4       1107.492062     5573.149393         548.348389      2690.372265   \n",
       "5        671.605880     5166.706278         337.322076      2368.535537   \n",
       "6       1725.516807     5550.342525         562.961551      1718.424919   \n",
       "7        840.812577     5730.959041        1014.186662      1814.349120   \n",
       "\n",
       "   day_work_Kinki  day_work_Tyuugoku  day_work_Shikoku  day_work_Kyusyu  \\\n",
       "0     1627.656000         947.348000        199.301000       618.987000   \n",
       "1     1030.472000         707.889000         82.597000       767.420000   \n",
       "2     1498.427000         631.135000        140.274000       927.494000   \n",
       "3     2150.943000         294.110000         56.878000      1645.953000   \n",
       "4     2765.073465        1377.506195        236.926044      1560.843464   \n",
       "5     3054.331743        1260.838445       1051.080920      1322.495348   \n",
       "6     2977.497198        1152.066061        705.090595      1927.821462   \n",
       "7     1868.094766         781.576838        732.774027       176.283844   \n",
       "\n",
       "   day_work_Okinawa  \n",
       "0          8.561000  \n",
       "1         61.503000  \n",
       "2         12.356000  \n",
       "3         21.171000  \n",
       "4          0.000000  \n",
       "5          0.000000  \n",
       "6          8.944164  \n",
       "7        284.724944  \n",
       "\n",
       "[8 rows x 78 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trip.reset_index(inplace=True)\n",
    "trip.rename(columns={\"index\":\"term\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}