[IterativeImputer] Completing matrix with shape (12168, 16)
[IterativeImputer] Change: 8.828120105598833, scaled tolerance: 2020033.124
[IterativeImputer] Early stopping criterion reached.
|
datetime |
precipitation_utsunomiya |
precipitation_chiba |
precipitation_tokyo |
temperature_utsunomiya |
temperature_chiba |
temperature_tokyo |
winddirection_utsunomiya |
winddirection_chiba |
winddirection_tokyo |
windspeed_utsunomiya |
windspeed_chiba |
windspeed_tokyo |
pollen_utsunomiya |
pollen_chiba |
pollen_tokyo |
0 |
2017020101 |
0.0 |
0.0 |
0.0 |
-1.0 |
4.1 |
2.9 |
16 |
1 |
2 |
2.7 |
2.5 |
1.3 |
0.0 |
8.0 |
0.0 |
1 |
2017020102 |
0.0 |
0.0 |
0.0 |
-1.1 |
4.2 |
2.6 |
1 |
1 |
1 |
3.3 |
1.5 |
0.9 |
0.0 |
24.0 |
4.0 |
2 |
2017020103 |
0.0 |
0.0 |
0.0 |
-0.7 |
4.2 |
2.4 |
1 |
15 |
16 |
4.0 |
1.7 |
0.6 |
4.0 |
32.0 |
12.0 |
def run_add_feat(train, test):
# 連結して全データに対して処理
df = pd.concat([train, test]).reset_index(drop=True)
# 基本時間特徴の追加
df = add_time_feat(df)
# 手動特徴の追加
windd_col = ['winddirection_utsunomiya', 'winddirection_chiba', 'winddirection_tokyo']
winds_col = ['windspeed_utsunomiya', 'windspeed_chiba', 'windspeed_tokyo']
for d, s in zip(windd_col, winds_col):
df[f'{d}_{s}'] = np.sin(df[windd_col] * (2 * np.pi / 17))[d] * df[s]
precipitation_col = ['precipitation_utsunomiya', 'precipitation_chiba', 'precipitation_tokyo']
# ラグ特徴の追加
feat = [
'precipitation_utsunomiya', 'precipitation_chiba', 'precipitation_tokyo',
'temperature_utsunomiya', 'temperature_chiba', 'temperature_tokyo',
'windspeed_utsunomiya', 'windspeed_chiba', 'windspeed_tokyo',
'winddirection_utsunomiya', 'winddirection_chiba', 'winddirection_tokyo'
]
df = add_lag_feat(df, feat, 'year')
# train/testに再分割、欠損処理
train_df = df[:len(train)]
test_df = df[len(train):]
train_df = train_df.dropna().reset_index(drop=True)
# 集計特徴の追加
cat_columns = ['year', 'month', 'day', 'hour', 'winddirection_utsunomiya', 'winddirection_chiba', 'winddirection_tokyo']
num_columns = ['precipitation_utsunomiya', 'precipitation_chiba', 'precipitation_tokyo',
'temperature_utsunomiya', 'temperature_chiba', 'temperature_tokyo',
'windspeed_utsunomiya', 'windspeed_chiba', 'windspeed_tokyo']
train_df, test_df = additional_encoding(train_df, test_df, cat_columns, num_columns)
return train_df, test_df
train_df, test_df = run_add_feat(train, test)
print(train_df.shape)
display(train_df.head(3))
print(test_df.shape)
display(test_df.head(3))
|
datetime |
precipitation_utsunomiya |
precipitation_chiba |
precipitation_tokyo |
temperature_utsunomiya |
temperature_chiba |
temperature_tokyo |
winddirection_utsunomiya |
winddirection_chiba |
winddirection_tokyo |
windspeed_utsunomiya |
windspeed_chiba |
windspeed_tokyo |
pollen_utsunomiya |
pollen_chiba |
pollen_tokyo |
time |
year |
month |
day |
hour |
weekday |
day_of_year |
day_sin |
day_cos |
winddirection_utsunomiya_windspeed_utsunomiya |
winddirection_chiba_windspeed_chiba |
winddirection_tokyo_windspeed_tokyo |
shift1_precipitation_utsunomiya |
shift1_precipitation_chiba |
shift1_precipitation_tokyo |
shift1_temperature_utsunomiya |
shift1_temperature_chiba |
shift1_temperature_tokyo |
shift1_windspeed_utsunomiya |
shift1_windspeed_chiba |
shift1_windspeed_tokyo |
shift1_winddirection_utsunomiya |
shift1_winddirection_chiba |
shift1_winddirection_tokyo |
diff1_precipitation_utsunomiya |
diff1_precipitation_chiba |
diff1_precipitation_tokyo |
diff1_temperature_utsunomiya |
diff1_temperature_chiba |
diff1_temperature_tokyo |
diff1_windspeed_utsunomiya |
diff1_windspeed_chiba |
diff1_windspeed_tokyo |
diff1_winddirection_utsunomiya |
diff1_winddirection_chiba |
diff1_winddirection_tokyo |
shift2_precipitation_utsunomiya |
shift2_precipitation_chiba |
shift2_precipitation_tokyo |
shift2_temperature_utsunomiya |
shift2_temperature_chiba |
shift2_temperature_tokyo |
shift2_windspeed_utsunomiya |
shift2_windspeed_chiba |
shift2_windspeed_tokyo |
shift2_winddirection_utsunomiya |
shift2_winddirection_chiba |
shift2_winddirection_tokyo |
diff2_precipitation_utsunomiya |
diff2_precipitation_chiba |
diff2_precipitation_tokyo |
diff2_temperature_utsunomiya |
diff2_temperature_chiba |
diff2_temperature_tokyo |
diff2_windspeed_utsunomiya |
diff2_windspeed_chiba |
diff2_windspeed_tokyo |
diff2_winddirection_utsunomiya |
diff2_winddirection_chiba |
diff2_winddirection_tokyo |
shift3_precipitation_utsunomiya |
shift3_precipitation_chiba |
shift3_precipitation_tokyo |
shift3_temperature_utsunomiya |
shift3_temperature_chiba |
shift3_temperature_tokyo |
shift3_windspeed_utsunomiya |
shift3_windspeed_chiba |
shift3_windspeed_tokyo |
shift3_winddirection_utsunomiya |
shift3_winddirection_chiba |
shift3_winddirection_tokyo |
diff3_precipitation_utsunomiya |
diff3_precipitation_chiba |
diff3_precipitation_tokyo |
diff3_temperature_utsunomiya |
diff3_temperature_chiba |
diff3_temperature_tokyo |
diff3_windspeed_utsunomiya |
diff3_windspeed_chiba |
diff3_windspeed_tokyo |
diff3_winddirection_utsunomiya |
diff3_winddirection_chiba |
diff3_winddirection_tokyo |
... |
winddirection_chiba_min_y |
winddirection_chiba_max_y |
winddirection_chiba_abs_mean_y |
winddirection_chiba_min_max_y |
winddirection_chiba_mean_x |
winddirection_chiba_std_x |
winddirection_chiba_min_x |
winddirection_chiba_max_x |
winddirection_chiba_abs_mean_x |
winddirection_chiba_min_max_x |
winddirection_chiba_mean_y |
winddirection_chiba_std_y |
winddirection_chiba_min_y |
winddirection_chiba_max_y |
winddirection_chiba_abs_mean_y |
winddirection_chiba_min_max_y |
winddirection_chiba_mean_x |
winddirection_chiba_std_x |
winddirection_chiba_min_x |
winddirection_chiba_max_x |
winddirection_chiba_abs_mean_x |
winddirection_chiba_min_max_x |
winddirection_chiba_mean_y |
winddirection_chiba_std_y |
winddirection_chiba_min_y |
winddirection_chiba_max_y |
winddirection_chiba_abs_mean_y |
winddirection_chiba_min_max_y |
winddirection_chiba_mean_x |
winddirection_chiba_std_x |
winddirection_chiba_min_x |
winddirection_chiba_max_x |
winddirection_chiba_abs_mean_x |
winddirection_chiba_min_max_x |
winddirection_chiba_mean_y |
winddirection_chiba_std_y |
winddirection_chiba_min_y |
winddirection_chiba_max_y |
winddirection_chiba_abs_mean_y |
winddirection_chiba_min_max_y |
winddirection_chiba_mean |
winddirection_chiba_std |
winddirection_chiba_min |
winddirection_chiba_max |
winddirection_chiba_abs_mean |
winddirection_chiba_min_max |
winddirection_tokyo_mean_x |
winddirection_tokyo_std_x |
winddirection_tokyo_min_x |
winddirection_tokyo_max_x |
winddirection_tokyo_abs_mean_x |
winddirection_tokyo_min_max_x |
winddirection_tokyo_mean_y |
winddirection_tokyo_std_y |
winddirection_tokyo_min_y |
winddirection_tokyo_max_y |
winddirection_tokyo_abs_mean_y |
winddirection_tokyo_min_max_y |
winddirection_tokyo_mean_x |
winddirection_tokyo_std_x |
winddirection_tokyo_min_x |
winddirection_tokyo_max_x |
winddirection_tokyo_abs_mean_x |
winddirection_tokyo_min_max_x |
winddirection_tokyo_mean_y |
winddirection_tokyo_std_y |
winddirection_tokyo_min_y |
winddirection_tokyo_max_y |
winddirection_tokyo_abs_mean_y |
winddirection_tokyo_min_max_y |
winddirection_tokyo_mean_x |
winddirection_tokyo_std_x |
winddirection_tokyo_min_x |
winddirection_tokyo_max_x |
winddirection_tokyo_abs_mean_x |
winddirection_tokyo_min_max_x |
winddirection_tokyo_mean_y |
winddirection_tokyo_std_y |
winddirection_tokyo_min_y |
winddirection_tokyo_max_y |
winddirection_tokyo_abs_mean_y |
winddirection_tokyo_min_max_y |
winddirection_tokyo_mean_x |
winddirection_tokyo_std_x |
winddirection_tokyo_min_x |
winddirection_tokyo_max_x |
winddirection_tokyo_abs_mean_x |
winddirection_tokyo_min_max_x |
winddirection_tokyo_mean_y |
winddirection_tokyo_std_y |
winddirection_tokyo_min_y |
winddirection_tokyo_max_y |
winddirection_tokyo_abs_mean_y |
winddirection_tokyo_min_max_y |
winddirection_tokyo_mean |
winddirection_tokyo_std |
winddirection_tokyo_min |
winddirection_tokyo_max |
winddirection_tokyo_abs_mean |
winddirection_tokyo_min_max |
0 |
2017020106 |
0.0 |
0.0 |
0.0 |
-1.8 |
4.0 |
1.1 |
1 |
15 |
15 |
2.6 |
2.3 |
1.0 |
4.0 |
4.0 |
0.0 |
2017-02-01 |
2017 |
2 |
1 |
6 |
2 |
32 |
0.523416 |
0.852078 |
0.939228 |
-1.549500 |
-0.673696 |
0.0 |
0.0 |
0.0 |
-1.2 |
4.1 |
1.5 |
3.7 |
3.4 |
0.9 |
2.0 |
14.0 |
14.0 |
0.0 |
0.0 |
0.0 |
-0.6 |
-0.1 |
-0.4 |
-1.1 |
-1.1 |
0.1 |
-1.0 |
1.0 |
1.0 |
0.0 |
0.0 |
0.0 |
-1.1 |
4.4 |
1.8 |
4.1 |
3.1 |
1.4 |
1.0 |
15.0 |
1.0 |
0.0 |
0.0 |
0.0 |
-0.7 |
-0.4 |
-0.7 |
-1.5 |
-0.8 |
-0.4 |
0.0 |
0.0 |
14.0 |
0.0 |
0.0 |
0.0 |
-0.7 |
4.2 |
2.4 |
4.0 |
1.7 |
0.6 |
1.0 |
15.0 |
16.0 |
0.0 |
0.0 |
0.0 |
-1.1 |
-0.2 |
-1.3 |
-1.4 |
0.6 |
0.4 |
0.0 |
0.0 |
-1.0 |
... |
0.0 |
15.0 |
0.205139 |
0.0 |
0.152906 |
0.636507 |
0.0 |
8.5 |
0.152906 |
0.0 |
6.382730 |
6.217927 |
-6.5 |
28.3 |
6.382730 |
-183.95 |
9.277759 |
5.565696 |
-0.9 |
28.6 |
9.277759 |
-25.74 |
7.740775 |
5.979493 |
-4.0 |
29.6 |
7.740775 |
-118.40 |
3.165965 |
2.144589 |
0.1 |
12.9 |
3.165965 |
1.29 |
3.415754 |
1.668560 |
0.3 |
11.4 |
3.415754 |
3.42 |
1.376327 |
0.747432 |
0.0 |
4.1 |
1.376327 |
0.0 |
0.234670 |
0.812608 |
0.0 |
9.0 |
0.234670 |
0.0 |
0.369693 |
1.175232 |
0.0 |
13.5 |
0.369693 |
0.0 |
0.375590 |
1.554642 |
0.0 |
21.5 |
0.375590 |
0.0 |
8.883962 |
6.598716 |
-3.8 |
27.1 |
8.883962 |
-102.98 |
11.517571 |
6.004159 |
-0.1 |
28.2 |
11.517571 |
-2.82 |
10.191627 |
6.179070 |
-2.3 |
29.0 |
10.191627 |
-66.70 |
3.314151 |
2.200207 |
0.1 |
11.8 |
3.314151 |
1.18 |
3.909434 |
2.321321 |
0.2 |
15.3 |
3.909434 |
3.06 |
1.384552 |
0.718821 |
0.3 |
4.5 |
1.384552 |
1.35 |
1 |
2017020107 |
0.0 |
0.0 |
0.0 |
-2.1 |
3.7 |
0.7 |
16 |
15 |
14 |
2.9 |
1.8 |
1.3 |
0.0 |
12.0 |
0.0 |
2017-02-01 |
2017 |
2 |
1 |
7 |
2 |
32 |
0.523416 |
0.852078 |
-1.047601 |
-1.212652 |
-1.163712 |
0.0 |
0.0 |
0.0 |
-1.8 |
4.0 |
1.1 |
2.6 |
2.3 |
1.0 |
1.0 |
15.0 |
15.0 |
0.0 |
0.0 |
0.0 |
-0.3 |
-0.3 |
-0.4 |
0.3 |
-0.5 |
0.3 |
15.0 |
0.0 |
-1.0 |
0.0 |
0.0 |
0.0 |
-1.2 |
4.1 |
1.5 |
3.7 |
3.4 |
0.9 |
2.0 |
14.0 |
14.0 |
0.0 |
0.0 |
0.0 |
-0.9 |
-0.4 |
-0.8 |
-0.8 |
-1.6 |
0.4 |
14.0 |
1.0 |
0.0 |
0.0 |
0.0 |
0.0 |
-1.1 |
4.4 |
1.8 |
4.1 |
3.1 |
1.4 |
1.0 |
15.0 |
1.0 |
0.0 |
0.0 |
0.0 |
-1.0 |
-0.7 |
-1.1 |
-1.2 |
-1.3 |
-0.1 |
15.0 |
0.0 |
13.0 |
... |
0.0 |
15.0 |
0.205139 |
0.0 |
0.152906 |
0.636507 |
0.0 |
8.5 |
0.152906 |
0.0 |
6.382730 |
6.217927 |
-6.5 |
28.3 |
6.382730 |
-183.95 |
9.277759 |
5.565696 |
-0.9 |
28.6 |
9.277759 |
-25.74 |
7.740775 |
5.979493 |
-4.0 |
29.6 |
7.740775 |
-118.40 |
3.165965 |
2.144589 |
0.1 |
12.9 |
3.165965 |
1.29 |
3.415754 |
1.668560 |
0.3 |
11.4 |
3.415754 |
3.42 |
1.376327 |
0.747432 |
0.0 |
4.1 |
1.376327 |
0.0 |
0.221142 |
0.814820 |
0.0 |
11.5 |
0.221142 |
0.0 |
0.346902 |
1.430341 |
0.0 |
21.5 |
0.346902 |
0.0 |
0.351762 |
1.199612 |
0.0 |
14.0 |
0.351762 |
0.0 |
8.993439 |
6.411261 |
-6.5 |
27.5 |
8.993439 |
-178.75 |
11.705225 |
5.986661 |
-1.4 |
28.8 |
11.705225 |
-40.32 |
10.035966 |
6.177933 |
-2.9 |
29.7 |
10.035966 |
-86.13 |
3.147388 |
2.141114 |
0.1 |
13.9 |
3.147388 |
1.39 |
3.515796 |
2.327821 |
0.2 |
14.4 |
3.515796 |
2.88 |
1.365249 |
0.805476 |
0.3 |
5.1 |
1.365249 |
1.53 |
2 |
2017020108 |
0.0 |
0.0 |
0.0 |
-0.2 |
3.9 |
2.0 |
16 |
14 |
14 |
2.2 |
2.3 |
1.0 |
8.0 |
16.0 |
8.0 |
2017-02-01 |
2017 |
2 |
1 |
8 |
2 |
32 |
0.523416 |
0.852078 |
-0.794732 |
-2.058876 |
-0.895163 |
0.0 |
0.0 |
0.0 |
-2.1 |
3.7 |
0.7 |
2.9 |
1.8 |
1.3 |
16.0 |
15.0 |
14.0 |
0.0 |
0.0 |
0.0 |
1.9 |
0.2 |
1.3 |
-0.7 |
0.5 |
-0.3 |
0.0 |
-1.0 |
0.0 |
0.0 |
0.0 |
0.0 |
-1.8 |
4.0 |
1.1 |
2.6 |
2.3 |
1.0 |
1.0 |
15.0 |
15.0 |
0.0 |
0.0 |
0.0 |
1.6 |
-0.1 |
0.9 |
-0.4 |
0.0 |
0.0 |
15.0 |
-1.0 |
-1.0 |
0.0 |
0.0 |
0.0 |
-1.2 |
4.1 |
1.5 |
3.7 |
3.4 |
0.9 |
2.0 |
14.0 |
14.0 |
0.0 |
0.0 |
0.0 |
1.0 |
-0.2 |
0.5 |
-1.5 |
-1.1 |
0.1 |
14.0 |
0.0 |
0.0 |
... |
0.0 |
7.5 |
0.050968 |
0.0 |
0.034839 |
0.251762 |
0.0 |
4.0 |
0.034839 |
0.0 |
7.310581 |
5.953827 |
-4.6 |
27.8 |
7.310581 |
-127.88 |
10.326323 |
5.332706 |
-0.1 |
29.2 |
10.326323 |
-2.92 |
8.772774 |
5.742079 |
-4.3 |
30.1 |
8.772774 |
-129.43 |
3.823226 |
2.716188 |
0.2 |
15.9 |
3.823226 |
3.18 |
4.774323 |
2.622473 |
0.3 |
13.2 |
4.774323 |
3.96 |
1.637032 |
0.915166 |
0.0 |
5.1 |
1.637032 |
0.0 |
0.221142 |
0.814820 |
0.0 |
11.5 |
0.221142 |
0.0 |
0.346902 |
1.430341 |
0.0 |
21.5 |
0.346902 |
0.0 |
0.351762 |
1.199612 |
0.0 |
14.0 |
0.351762 |
0.0 |
8.993439 |
6.411261 |
-6.5 |
27.5 |
8.993439 |
-178.75 |
11.705225 |
5.986661 |
-1.4 |
28.8 |
11.705225 |
-40.32 |
10.035966 |
6.177933 |
-2.9 |
29.7 |
10.035966 |
-86.13 |
3.147388 |
2.141114 |
0.1 |
13.9 |
3.147388 |
1.39 |
3.515796 |
2.327821 |
0.2 |
14.4 |
3.515796 |
2.88 |
1.365249 |
0.805476 |
0.3 |
5.1 |
1.365249 |
1.53 |
3 rows × 557 columns
|
datetime |
precipitation_utsunomiya |
precipitation_chiba |
precipitation_tokyo |
temperature_utsunomiya |
temperature_chiba |
temperature_tokyo |
winddirection_utsunomiya |
winddirection_chiba |
winddirection_tokyo |
windspeed_utsunomiya |
windspeed_chiba |
windspeed_tokyo |
pollen_utsunomiya |
pollen_chiba |
pollen_tokyo |
time |
year |
month |
day |
hour |
weekday |
day_of_year |
day_sin |
day_cos |
winddirection_utsunomiya_windspeed_utsunomiya |
winddirection_chiba_windspeed_chiba |
winddirection_tokyo_windspeed_tokyo |
shift1_precipitation_utsunomiya |
shift1_precipitation_chiba |
shift1_precipitation_tokyo |
shift1_temperature_utsunomiya |
shift1_temperature_chiba |
shift1_temperature_tokyo |
shift1_windspeed_utsunomiya |
shift1_windspeed_chiba |
shift1_windspeed_tokyo |
shift1_winddirection_utsunomiya |
shift1_winddirection_chiba |
shift1_winddirection_tokyo |
diff1_precipitation_utsunomiya |
diff1_precipitation_chiba |
diff1_precipitation_tokyo |
diff1_temperature_utsunomiya |
diff1_temperature_chiba |
diff1_temperature_tokyo |
diff1_windspeed_utsunomiya |
diff1_windspeed_chiba |
diff1_windspeed_tokyo |
diff1_winddirection_utsunomiya |
diff1_winddirection_chiba |
diff1_winddirection_tokyo |
shift2_precipitation_utsunomiya |
shift2_precipitation_chiba |
shift2_precipitation_tokyo |
shift2_temperature_utsunomiya |
shift2_temperature_chiba |
shift2_temperature_tokyo |
shift2_windspeed_utsunomiya |
shift2_windspeed_chiba |
shift2_windspeed_tokyo |
shift2_winddirection_utsunomiya |
shift2_winddirection_chiba |
shift2_winddirection_tokyo |
diff2_precipitation_utsunomiya |
diff2_precipitation_chiba |
diff2_precipitation_tokyo |
diff2_temperature_utsunomiya |
diff2_temperature_chiba |
diff2_temperature_tokyo |
diff2_windspeed_utsunomiya |
diff2_windspeed_chiba |
diff2_windspeed_tokyo |
diff2_winddirection_utsunomiya |
diff2_winddirection_chiba |
diff2_winddirection_tokyo |
shift3_precipitation_utsunomiya |
shift3_precipitation_chiba |
shift3_precipitation_tokyo |
shift3_temperature_utsunomiya |
shift3_temperature_chiba |
shift3_temperature_tokyo |
shift3_windspeed_utsunomiya |
shift3_windspeed_chiba |
shift3_windspeed_tokyo |
shift3_winddirection_utsunomiya |
shift3_winddirection_chiba |
shift3_winddirection_tokyo |
diff3_precipitation_utsunomiya |
diff3_precipitation_chiba |
diff3_precipitation_tokyo |
diff3_temperature_utsunomiya |
diff3_temperature_chiba |
diff3_temperature_tokyo |
diff3_windspeed_utsunomiya |
diff3_windspeed_chiba |
diff3_windspeed_tokyo |
diff3_winddirection_utsunomiya |
diff3_winddirection_chiba |
diff3_winddirection_tokyo |
... |
winddirection_chiba_min_y |
winddirection_chiba_max_y |
winddirection_chiba_abs_mean_y |
winddirection_chiba_min_max_y |
winddirection_chiba_mean_x |
winddirection_chiba_std_x |
winddirection_chiba_min_x |
winddirection_chiba_max_x |
winddirection_chiba_abs_mean_x |
winddirection_chiba_min_max_x |
winddirection_chiba_mean_y |
winddirection_chiba_std_y |
winddirection_chiba_min_y |
winddirection_chiba_max_y |
winddirection_chiba_abs_mean_y |
winddirection_chiba_min_max_y |
winddirection_chiba_mean_x |
winddirection_chiba_std_x |
winddirection_chiba_min_x |
winddirection_chiba_max_x |
winddirection_chiba_abs_mean_x |
winddirection_chiba_min_max_x |
winddirection_chiba_mean_y |
winddirection_chiba_std_y |
winddirection_chiba_min_y |
winddirection_chiba_max_y |
winddirection_chiba_abs_mean_y |
winddirection_chiba_min_max_y |
winddirection_chiba_mean_x |
winddirection_chiba_std_x |
winddirection_chiba_min_x |
winddirection_chiba_max_x |
winddirection_chiba_abs_mean_x |
winddirection_chiba_min_max_x |
winddirection_chiba_mean_y |
winddirection_chiba_std_y |
winddirection_chiba_min_y |
winddirection_chiba_max_y |
winddirection_chiba_abs_mean_y |
winddirection_chiba_min_max_y |
winddirection_chiba_mean |
winddirection_chiba_std |
winddirection_chiba_min |
winddirection_chiba_max |
winddirection_chiba_abs_mean |
winddirection_chiba_min_max |
winddirection_tokyo_mean_x |
winddirection_tokyo_std_x |
winddirection_tokyo_min_x |
winddirection_tokyo_max_x |
winddirection_tokyo_abs_mean_x |
winddirection_tokyo_min_max_x |
winddirection_tokyo_mean_y |
winddirection_tokyo_std_y |
winddirection_tokyo_min_y |
winddirection_tokyo_max_y |
winddirection_tokyo_abs_mean_y |
winddirection_tokyo_min_max_y |
winddirection_tokyo_mean_x |
winddirection_tokyo_std_x |
winddirection_tokyo_min_x |
winddirection_tokyo_max_x |
winddirection_tokyo_abs_mean_x |
winddirection_tokyo_min_max_x |
winddirection_tokyo_mean_y |
winddirection_tokyo_std_y |
winddirection_tokyo_min_y |
winddirection_tokyo_max_y |
winddirection_tokyo_abs_mean_y |
winddirection_tokyo_min_max_y |
winddirection_tokyo_mean_x |
winddirection_tokyo_std_x |
winddirection_tokyo_min_x |
winddirection_tokyo_max_x |
winddirection_tokyo_abs_mean_x |
winddirection_tokyo_min_max_x |
winddirection_tokyo_mean_y |
winddirection_tokyo_std_y |
winddirection_tokyo_min_y |
winddirection_tokyo_max_y |
winddirection_tokyo_abs_mean_y |
winddirection_tokyo_min_max_y |
winddirection_tokyo_mean_x |
winddirection_tokyo_std_x |
winddirection_tokyo_min_x |
winddirection_tokyo_max_x |
winddirection_tokyo_abs_mean_x |
winddirection_tokyo_min_max_x |
winddirection_tokyo_mean_y |
winddirection_tokyo_std_y |
winddirection_tokyo_min_y |
winddirection_tokyo_max_y |
winddirection_tokyo_abs_mean_y |
winddirection_tokyo_min_max_y |
winddirection_tokyo_mean |
winddirection_tokyo_std |
winddirection_tokyo_min |
winddirection_tokyo_max |
winddirection_tokyo_abs_mean |
winddirection_tokyo_min_max |
0 |
2020040101 |
0.0 |
0.0 |
0.0 |
9.5 |
10.5 |
9.0 |
14 |
2 |
14 |
2.1 |
2.3 |
1.2 |
0.0 |
0.0 |
0.0 |
2020-04-01 |
2020 |
4 |
1 |
1 |
2 |
91 |
0.999991 |
0.004304 |
-1.879843 |
1.549500 |
-1.074196 |
0.0 |
0.0 |
0.0 |
9.7 |
10.7 |
8.9 |
1.0 |
2.7 |
0.4 |
16.0 |
1.0 |
16.0 |
0.0 |
0.0 |
0.0 |
-0.2 |
-0.2 |
0.1 |
1.1 |
-0.4 |
0.8 |
-2.0 |
1.0 |
-2.0 |
0.5 |
0.0 |
0.0 |
9.7 |
10.9 |
8.9 |
0.5 |
2.9 |
0.6 |
16.0 |
16.0 |
1.0 |
-0.5 |
0.0 |
0.0 |
-0.2 |
-0.4 |
0.1 |
1.6 |
-0.6 |
0.6 |
-2.0 |
-14.0 |
13.0 |
0.0 |
0.0 |
0.0 |
9.8 |
11.3 |
8.8 |
1.2 |
2.7 |
0.9 |
3.0 |
15.0 |
15.0 |
0.0 |
0.0 |
0.0 |
-0.3 |
-0.8 |
0.2 |
0.9 |
-0.4 |
0.3 |
11.0 |
-13.0 |
-1.0 |
... |
0.0 |
11.5 |
0.209054 |
0.0 |
0.213123 |
0.830675 |
0.0 |
10.0 |
0.213123 |
0.0 |
11.105697 |
6.529016 |
-6.1 |
27.5 |
11.105697 |
-167.75 |
12.908850 |
5.756066 |
-1.4 |
27.5 |
12.908850 |
-38.5 |
12.245575 |
6.104280 |
-3.0 |
28.4 |
12.245575 |
-85.2 |
2.683316 |
1.556318 |
0.0 |
11.2 |
2.683316 |
0.00 |
3.287080 |
1.379972 |
0.3 |
8.2 |
3.287080 |
2.46 |
1.478332 |
0.817158 |
0.0 |
4.7 |
1.478332 |
0.0 |
0.221142 |
0.81482 |
0.0 |
11.5 |
0.221142 |
0.0 |
0.346902 |
1.430341 |
0.0 |
21.5 |
0.346902 |
0.0 |
0.351762 |
1.199612 |
0.0 |
14.0 |
0.351762 |
0.0 |
8.993439 |
6.411261 |
-6.5 |
27.5 |
8.993439 |
-178.75 |
11.705225 |
5.986661 |
-1.4 |
28.8 |
11.705225 |
-40.32 |
10.035966 |
6.177933 |
-2.9 |
29.7 |
10.035966 |
-86.13 |
3.147388 |
2.141114 |
0.1 |
13.9 |
3.147388 |
1.39 |
3.515796 |
2.327821 |
0.2 |
14.4 |
3.515796 |
2.88 |
1.365249 |
0.805476 |
0.3 |
5.1 |
1.365249 |
1.53 |
1 |
2020040102 |
0.0 |
0.0 |
0.0 |
9.2 |
10.3 |
9.0 |
2 |
16 |
14 |
1.4 |
2.7 |
0.8 |
0.0 |
0.0 |
0.0 |
2020-04-01 |
2020 |
4 |
1 |
2 |
2 |
91 |
0.999991 |
0.004304 |
0.943174 |
-0.975352 |
-0.716131 |
0.0 |
0.0 |
0.0 |
9.5 |
10.5 |
9.0 |
2.1 |
2.3 |
1.2 |
14.0 |
2.0 |
14.0 |
0.0 |
0.0 |
0.0 |
-0.3 |
-0.2 |
0.0 |
-0.7 |
0.4 |
-0.4 |
-12.0 |
14.0 |
0.0 |
0.0 |
0.0 |
0.0 |
9.7 |
10.7 |
8.9 |
1.0 |
2.7 |
0.4 |
16.0 |
1.0 |
16.0 |
0.0 |
0.0 |
0.0 |
-0.5 |
-0.4 |
0.1 |
0.4 |
0.0 |
0.4 |
-14.0 |
15.0 |
-2.0 |
0.5 |
0.0 |
0.0 |
9.7 |
10.9 |
8.9 |
0.5 |
2.9 |
0.6 |
16.0 |
16.0 |
1.0 |
-0.5 |
0.0 |
0.0 |
-0.5 |
-0.6 |
0.1 |
0.9 |
-0.2 |
0.2 |
-14.0 |
0.0 |
13.0 |
... |
0.0 |
9.5 |
0.292402 |
0.0 |
0.248982 |
0.832885 |
0.0 |
6.5 |
0.248982 |
0.0 |
7.495387 |
6.633393 |
-4.7 |
27.5 |
7.495387 |
-129.25 |
9.779376 |
5.937938 |
-0.2 |
29.5 |
9.779376 |
-5.9 |
8.547490 |
6.377572 |
-4.0 |
30.6 |
8.547490 |
-122.4 |
3.129715 |
1.955545 |
0.2 |
11.6 |
3.129715 |
2.32 |
2.229851 |
1.017832 |
0.3 |
7.1 |
2.229851 |
2.13 |
1.297015 |
0.680167 |
0.0 |
4.2 |
1.297015 |
0.0 |
0.221142 |
0.81482 |
0.0 |
11.5 |
0.221142 |
0.0 |
0.346902 |
1.430341 |
0.0 |
21.5 |
0.346902 |
0.0 |
0.351762 |
1.199612 |
0.0 |
14.0 |
0.351762 |
0.0 |
8.993439 |
6.411261 |
-6.5 |
27.5 |
8.993439 |
-178.75 |
11.705225 |
5.986661 |
-1.4 |
28.8 |
11.705225 |
-40.32 |
10.035966 |
6.177933 |
-2.9 |
29.7 |
10.035966 |
-86.13 |
3.147388 |
2.141114 |
0.1 |
13.9 |
3.147388 |
1.39 |
3.515796 |
2.327821 |
0.2 |
14.4 |
3.515796 |
2.88 |
1.365249 |
0.805476 |
0.3 |
5.1 |
1.365249 |
1.53 |
2 |
2020040103 |
0.0 |
0.0 |
0.0 |
9.2 |
10.2 |
9.1 |
16 |
16 |
12 |
3.3 |
2.5 |
0.5 |
0.0 |
0.0 |
0.0 |
2020-04-01 |
2020 |
4 |
1 |
3 |
2 |
91 |
0.999991 |
0.004304 |
-1.192097 |
-0.903104 |
-0.480913 |
0.0 |
0.0 |
0.0 |
9.2 |
10.3 |
9.0 |
1.4 |
2.7 |
0.8 |
2.0 |
16.0 |
14.0 |
0.0 |
0.0 |
0.0 |
0.0 |
-0.1 |
0.1 |
1.9 |
-0.2 |
-0.3 |
14.0 |
0.0 |
-2.0 |
0.0 |
0.0 |
0.0 |
9.5 |
10.5 |
9.0 |
2.1 |
2.3 |
1.2 |
14.0 |
2.0 |
14.0 |
0.0 |
0.0 |
0.0 |
-0.3 |
-0.3 |
0.1 |
1.2 |
0.2 |
-0.7 |
2.0 |
14.0 |
-2.0 |
0.0 |
0.0 |
0.0 |
9.7 |
10.7 |
8.9 |
1.0 |
2.7 |
0.4 |
16.0 |
1.0 |
16.0 |
0.0 |
0.0 |
0.0 |
-0.5 |
-0.5 |
0.2 |
2.3 |
-0.2 |
0.1 |
0.0 |
15.0 |
-4.0 |
... |
0.0 |
9.5 |
0.292402 |
0.0 |
0.248982 |
0.832885 |
0.0 |
6.5 |
0.248982 |
0.0 |
7.495387 |
6.633393 |
-4.7 |
27.5 |
7.495387 |
-129.25 |
9.779376 |
5.937938 |
-0.2 |
29.5 |
9.779376 |
-5.9 |
8.547490 |
6.377572 |
-4.0 |
30.6 |
8.547490 |
-122.4 |
3.129715 |
1.955545 |
0.2 |
11.6 |
3.129715 |
2.32 |
2.229851 |
1.017832 |
0.3 |
7.1 |
2.229851 |
2.13 |
1.297015 |
0.680167 |
0.0 |
4.2 |
1.297015 |
0.0 |
0.031306 |
0.41737 |
0.0 |
9.0 |
0.031306 |
0.0 |
0.039356 |
0.504699 |
0.0 |
11.0 |
0.039356 |
0.0 |
0.075134 |
1.035953 |
0.0 |
23.5 |
0.075134 |
0.0 |
8.798748 |
7.142278 |
-5.0 |
28.8 |
8.798748 |
-144.00 |
12.214311 |
6.118142 |
0.0 |
27.1 |
12.214311 |
0.00 |
9.931664 |
6.817144 |
-4.0 |
31.2 |
9.931664 |
-124.80 |
2.359034 |
1.559301 |
0.1 |
11.8 |
2.359034 |
1.18 |
2.782826 |
2.078830 |
0.2 |
14.4 |
2.782826 |
2.88 |
1.005546 |
0.538471 |
0.3 |
4.8 |
1.005546 |
1.44 |
3 rows × 557 columns
0%| | 0/3 [00:00<?, ?it/s]
|
datetime |
pollen_utsunomiya |
pollen_chiba |
pollen_tokyo |
0 |
2020040101 |
84.0 |
32.0 |
32.0 |
1 |
2020040102 |
80.0 |
36.0 |
32.0 |
2 |
2020040103 |
80.0 |
36.0 |
32.0 |
|
datetime |
pollen_utsunomiya |
pollen_chiba |
pollen_tokyo |
0 |
2020040101 |
0 |
0 |
0 |
1 |
2020040102 |
0 |
0 |
0 |
2 |
2020040103 |
0 |
0 |
0 |
|
datetime |
pollen_utsunomiya |
pollen_chiba |
pollen_tokyo |
0 |
2020040101 |
4 |
4 |
4 |
1 |
2020040102 |
4 |
4 |
4 |
2 |
2020040103 |
4 |
4 |
4 |
|
datetime |
pollen_utsunomiya |
pollen_chiba |
pollen_tokyo |
0 |
2020040101 |
8 |
8 |
8 |
1 |
2020040102 |
8 |
8 |
8 |
2 |
2020040103 |
8 |
8 |
8 |
2-3月
pollen_utsunomiya pollen_chiba pollen_tokyo
count 4185.000000 4185.000000 4185.000000
mean 170.580167 53.825806 44.210275
std 542.361827 157.080851 110.309489
min 0.000000 0.000000 0.000000
25% 8.000000 4.000000 4.000000
50% 28.000000 12.000000 12.000000
75% 122.000000 45.000000 36.000000
max 12193.000000 4141.000000 2209.000000
4月前半
pollen_utsunomiya pollen_chiba pollen_tokyo
count 1008.000000 1008.000000 1008.000000
mean 152.183532 46.733135 46.874008
std 341.681206 104.334555 88.650295
min 0.000000 0.000000 0.000000
25% 20.000000 4.000000 4.000000
50% 57.000000 16.000000 16.000000
75% 151.000000 45.000000 49.000000
max 5629.000000 2119.000000 746.000000
0%| | 0/9 [00:00<?, ?it/s]
|
pollen_utsunomiya |
pollen_chiba |
pollen_tokyo |
4 |
25.270670 |
16.169495 |
12.431046 |
8 |
24.584037 |
15.180790 |
11.975406 |
12 |
23.421559 |
14.710188 |
11.983310 |
16 |
23.221837 |
14.546360 |
12.066856 |
20 |
22.754685 |
14.516001 |
12.376283 |
24 |
22.371299 |
14.574958 |
12.675389 |
28 |
22.328795 |
14.691928 |
13.030755 |
32 |
22.505439 |
14.739105 |
13.535812 |
36 |
22.616658 |
14.950690 |
13.818950 |
0%| | 0/3 [00:00<?, ?it/s]
==========pollen_utsunomiya==========
<year : 2017>
LOSS : 1.1938153630467006
LOSS : 1.4568659271147195
LOSS : 1.5079497032585705
Mean LOSS : 1.3862103311399967
==========pollen_chiba==========
<year : 2017>
LOSS : 1.0321580800023542
LOSS : 1.3894891307069823
LOSS : 1.3890817102532345
Mean LOSS : 1.2702429736541903
==========pollen_tokyo==========
<year : 2017>