File size: 15,344 Bytes
fb34fd1 ef2d721 fb34fd1 fb35f3c fb34fd1 fb35f3c fb34fd1 fb35f3c fb34fd1 fb35f3c fb34fd1 ef2d721 fb34fd1 fe168cf fb34fd1 fe168cf | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 | """客数予測(β機能)
過去の客数実績・曜日/祝日区分・気象データから、朝食/ディナーの客数を予測する。
- 学習データが少ない間は、曜日(祝日は曜日に関わらず別区分)別の加重移動平均
(Tier1: 同じ曜日区分 → Tier2: 平日/休日(土日祝) → Tier3: 全体平均)にフォールバックする。
- 学習データが十分(既定30件以上)にある場合は scikit-learn の RandomForestRegressor で
曜日・祝日・特殊日フラグ・月・気象(Open-Meteo)・直近の同曜日傾向を特徴量として学習する。
- 気象APIや scikit-learn が利用できない場合も例外を投げず、統計フォールバックの結果を返す。
"""
from __future__ import annotations
import json
import urllib.error
import urllib.parse
import urllib.request
from datetime import date
from cache import cache
from db import repositories as repo
from utils.holidays import is_holiday
_DAY_CATS = ["月", "火", "水", "木", "金", "土", "日"]
_WEEKEND_CATS = {"土", "日", "祝日"}
_DECAY = 0.85 # 加重平均の減衰率(新しいデータほど重視)
_MIN_TIER_SAMPLES = 3 # 各階層フォールバックで使う最低サンプル数
_MIN_ML_SAMPLES = 30 # MLモデルを学習する最低データ件数
_MAX_HISTORY_DAYS = 730 # 学習に使う直近データの上限(約2年分)
_MAX_FORECAST_DAYS = 16 # Open-Meteo予報の取得可能日数
_OPEN_METEO_ARCHIVE = "https://archive-api.open-meteo.com/v1/archive"
_OPEN_METEO_FORECAST = "https://api.open-meteo.com/v1/forecast"
_DAILY_FIELDS = "temperature_2m_max,temperature_2m_min,precipitation_sum,weathercode"
# Open-Meteo の天気コード(WMO Weather interpretation codes)→ (Bootstrap Icon, 日本語ラベル)
WEATHER_CODE_MAP = {
0: ("bi-sun", "快晴"),
1: ("bi-brightness-high", "晴れ"),
2: ("bi-cloud-sun", "晴れ時々曇り"),
3: ("bi-clouds", "曇り"),
45: ("bi-cloud-fog2", "霧"),
48: ("bi-cloud-fog2", "霧(霜)"),
51: ("bi-cloud-drizzle", "小雨"),
53: ("bi-cloud-drizzle", "霧雨"),
55: ("bi-cloud-drizzle-fill", "強い霧雨"),
56: ("bi-cloud-sleet", "着氷性の霧雨"),
57: ("bi-cloud-sleet-fill", "強い着氷性の霧雨"),
61: ("bi-cloud-rain", "小雨"),
63: ("bi-cloud-rain", "雨"),
65: ("bi-cloud-rain-heavy", "大雨"),
66: ("bi-cloud-sleet", "着氷性の雨"),
67: ("bi-cloud-sleet-fill", "強い着氷性の雨"),
71: ("bi-cloud-snow", "小雪"),
73: ("bi-cloud-snow", "雪"),
75: ("bi-cloud-snow-fill", "大雪"),
77: ("bi-cloud-snow", "霧雪"),
80: ("bi-cloud-rain", "にわか雨"),
81: ("bi-cloud-rain-heavy", "強いにわか雨"),
82: ("bi-cloud-rain-heavy-fill", "激しいにわか雨"),
85: ("bi-cloud-snow", "にわか雪"),
86: ("bi-cloud-snow-fill", "強いにわか雪"),
95: ("bi-cloud-lightning", "雷雨"),
96: ("bi-cloud-lightning-rain", "雷雨(ひょう)"),
99: ("bi-cloud-lightning-rain-fill", "雷雨(激しいひょう)"),
}
_UNKNOWN_WEATHER = ("bi-question-circle", "不明")
def weather_icon_label(code) -> tuple[str, str]:
"""WMO天気コードから (Bootstrap Iconクラス, 日本語ラベル) を返す(不明な場合はクエスチョンアイコン)"""
if code is None:
return _UNKNOWN_WEATHER
try:
return WEATHER_CODE_MAP.get(int(code), _UNKNOWN_WEATHER)
except (TypeError, ValueError):
return _UNKNOWN_WEATHER
METHOD_LABELS = {
"ml": "機械学習モデル",
"weekday": "同じ曜日区分の実績平均",
"weekday_group": "平日/休日の実績平均",
"overall": "全体の実績平均",
"no_data": "データ不足",
}
def _day_category(d: date) -> str:
"""日付から曜日区分を返す(祝日は曜日に関わらず"祝日"扱い)"""
if is_holiday(d):
return "祝日"
return _DAY_CATS[d.weekday()]
def _tiered_average(values: list[float], cats: list[str], target_cat: str) -> dict:
"""
曜日区分別の加重平均(Tier1〜3フォールバック)。
values, cats は同じ並び(古い→新しい順)の実績値・曜日区分のリスト。
"""
is_weekend = target_cat in _WEEKEND_CATS
tier1 = [v for v, c in zip(values, cats) if c == target_cat]
tier2 = [v for v, c in zip(values, cats) if (c in _WEEKEND_CATS) == is_weekend]
tier3 = values
if len(tier1) >= _MIN_TIER_SAMPLES:
samples, method = tier1, "weekday"
elif len(tier2) >= _MIN_TIER_SAMPLES:
samples, method = tier2, "weekday_group"
elif tier3:
samples, method = tier3, "overall"
else:
return {"predicted": None, "low": None, "high": None, "n_samples": 0, "method": "no_data"}
n = len(samples)
weights = [_DECAY ** (n - 1 - i) for i in range(n)]
wsum = sum(weights)
mean = sum(w * v for w, v in zip(weights, samples)) / wsum
if n >= 2:
var = sum((v - mean) ** 2 for v in samples) / (n - 1)
sd = var ** 0.5
else:
sd = 0.0
return {
"predicted": max(0, round(mean)),
"low": max(0, round(mean - sd)),
"high": max(0, round(mean + sd)),
"n_samples": n,
"method": method,
}
# ── 気象データ(Open-Meteo) ─────────────────────────────────────────────
def _http_get_json(url: str, timeout: int = 8) -> dict | None:
try:
req = urllib.request.Request(url, headers={"User-Agent": "SDU-Shift-Forecast"})
with urllib.request.urlopen(req, timeout=timeout) as resp:
return json.loads(resp.read().decode())
except (urllib.error.URLError, TimeoutError, ValueError, OSError):
return None
def _safe_get(lst, i):
if not lst or i >= len(lst):
return None
return lst[i]
def _fetch_weather_range(lat: float, lon: float, start: date, end: date, archive: bool) -> dict[str, dict]:
"""指定期間の気象データを取得し {date_str: {...}} で返す(失敗時は{})"""
base = _OPEN_METEO_ARCHIVE if archive else _OPEN_METEO_FORECAST
params = {
"latitude": lat, "longitude": lon,
"daily": _DAILY_FIELDS,
"timezone": "Asia/Tokyo",
}
if archive:
params["start_date"] = start.isoformat()
params["end_date"] = end.isoformat()
else:
params["forecast_days"] = min(_MAX_FORECAST_DAYS, max(1, (end - date.today()).days + 1))
data = _http_get_json(f"{base}?{urllib.parse.urlencode(params)}")
if not data or "daily" not in data:
return {}
daily = data["daily"]
times = daily.get("time", [])
return {
d: {
"temp_max": _safe_get(daily.get("temperature_2m_max"), i),
"temp_min": _safe_get(daily.get("temperature_2m_min"), i),
"precipitation": _safe_get(daily.get("precipitation_sum"), i),
"weather_code": _safe_get(daily.get("weathercode"), i),
}
for i, d in enumerate(times)
}
def _get_weather_map(dates: list[date], lat: float | None, lon: float | None) -> dict[str, dict]:
"""指定日付群の気象データを {date_str: {...}} で返す(Open-Meteoから直接取得)
weather_cache テーブルへの読み書きは行わない(DB側のロック等で
リクエストがハングする事象が発生したため)。Open-Meteo呼び出しは
timeoutで保護されており、結果は predict_customer_counts_cached の
5分キャッシュにより呼び出し頻度が抑えられる。
"""
if lat is None or lon is None or not dates:
return {}
date_strs = sorted({d.isoformat() for d in dates})
target_dates = [date.fromisoformat(ds) for ds in date_strs]
today = date.today()
past = [d for d in target_dates if d < today]
future = [d for d in target_dates if d >= today]
fetched: dict[str, dict] = {}
if past:
fetched.update(_fetch_weather_range(lat, lon, min(past), max(past), archive=True))
if future:
fetched.update(_fetch_weather_range(lat, lon, min(future), max(future), archive=False))
return fetched
@cache.memoize(timeout=1800)
def get_weather_map_cached(date_strs: tuple[str, ...]) -> dict[str, dict]:
"""シフト表画面用の気象情報を {date_str: {"temp_max","temp_min","precipitation","weather_code"}} で返す(30分キャッシュ)
店舗の緯度・経度(store_lat/store_lon)が未設定の場合は{}を返す。
"""
lat_s = repo.get_app_setting("store_lat", "")
lon_s = repo.get_app_setting("store_lon", "")
try:
lat = float(lat_s) if lat_s else None
lon = float(lon_s) if lon_s else None
except ValueError:
lat, lon = None, None
dates = [date.fromisoformat(ds) for ds in date_strs]
return _get_weather_map(dates, lat, lon)
def _weather_means(history: list[dict], weather_map: dict[str, dict]) -> dict[str, float]:
"""欠損気象データの補完用に、学習データ期間の平均値を計算する"""
defaults = {"temp_max": 20.0, "temp_min": 10.0, "precipitation": 0.0, "weather_code": 0.0}
sums: dict[str, list[float]] = {k: [] for k in defaults}
for r in history:
w = weather_map.get(r["date"])
if not w:
continue
for k in defaults:
if w.get(k) is not None:
sums[k].append(w[k])
return {k: (sum(v) / len(v) if v else defaults[k]) for k, v in sums.items()}
# ── 特徴量・MLモデル ────────────────────────────────────────────────────
def _feature_row(d: date, weather: dict | None, is_special_day: int, means: dict, lag_avg: float) -> list[float]:
weekday_onehot = [1.0 if d.weekday() == i else 0.0 for i in range(7)]
holiday_flag = 1.0 if is_holiday(d) else 0.0
w = weather or {}
temp_max = w.get("temp_max") if w.get("temp_max") is not None else means["temp_max"]
temp_min = w.get("temp_min") if w.get("temp_min") is not None else means["temp_min"]
precip = w.get("precipitation") if w.get("precipitation") is not None else means["precipitation"]
wcode = w.get("weather_code") if w.get("weather_code") is not None else means["weather_code"]
return weekday_onehot + [holiday_flag, float(is_special_day), float(d.month),
temp_max, temp_min, precip, wcode, lag_avg]
def _build_training_set(history: list[dict], cats: list[str], slot: str,
weather_map: dict[str, dict], means: dict) -> tuple[list, list]:
values = [r[slot] for r in history]
X, y = [], []
for i, r in enumerate(history):
if i == 0:
continue # 直近傾向(ラグ特徴量)の算出に過去データが1件も無い行は除外
d = date.fromisoformat(r["date"])
lag_stat = _tiered_average(values[:i], cats[:i], cats[i])
feat = _feature_row(d, weather_map.get(r["date"]), r["is_special_day"], means, lag_stat["predicted"])
X.append(feat)
y.append(r[slot])
return X, y
def predict_customer_counts(target_dates: list[date], special_days: set[str] | None = None) -> dict[str, dict]:
"""
指定した日付リストについて朝食・ディナーの客数を予測する。
戻り値: {date_str: {"breakfast": {予測結果}, "dinner": {予測結果}}}
予測結果: {"predicted": int|None, "low": int|None, "high": int|None,
"n_samples": int, "method": str}
method は METHOD_LABELS のキーのいずれか。
"""
special_days = special_days or set()
history_all = repo.get_forecast_training_data()
history = history_all[-_MAX_HISTORY_DAYS:]
empty_slot = {"predicted": None, "low": None, "high": None, "n_samples": 0, "method": "no_data"}
if not history:
return {d.isoformat(): {"breakfast": dict(empty_slot), "dinner": dict(empty_slot)} for d in target_dates}
cats = [_day_category(date.fromisoformat(r["date"])) for r in history]
lat_s = repo.get_app_setting("store_lat", "")
lon_s = repo.get_app_setting("store_lon", "")
try:
lat = float(lat_s) if lat_s else None
lon = float(lon_s) if lon_s else None
except ValueError:
lat, lon = None, None
weather_map = _get_weather_map(
[date.fromisoformat(r["date"]) for r in history] + list(target_dates), lat, lon
)
means = _weather_means(history, weather_map)
result: dict[str, dict] = {ds: {} for ds in (d.isoformat() for d in target_dates)}
for slot in ("breakfast", "dinner"):
values = [r[slot] for r in history]
model = None
if len(history) >= _MIN_ML_SAMPLES:
X, y = _build_training_set(history, cats, slot, weather_map, means)
if len(X) >= _MIN_ML_SAMPLES:
try:
from sklearn.ensemble import RandomForestRegressor
model = RandomForestRegressor(n_estimators=200, max_depth=8, random_state=42)
model.fit(X, y)
except Exception:
model = None
for d in target_dates:
ds = d.isoformat()
target_cat = _day_category(d)
stat = _tiered_average(values, cats, target_cat)
if model is not None:
try:
is_special = 1 if ds in special_days else 0
lag_stat = _tiered_average(values, cats, target_cat)
feat = _feature_row(d, weather_map.get(ds), is_special, means, lag_stat["predicted"])
pred = float(model.predict([feat])[0])
stat = {**stat, "predicted": max(0, round(pred)), "method": "ml"}
except Exception:
pass
result[ds][slot] = stat
return result
@cache.memoize(timeout=300)
def predict_customer_counts_cached(target_date_strs: tuple[str, ...], special_days: tuple[str, ...]) -> dict:
"""predict_customer_counts() のキャッシュ付きラッパー(モデル再学習のコスト軽減のため5分間キャッシュ)
β機能のため、DBエラー等で予測に失敗してもページ全体を巻き込まないよう
例外を握りつぶし「データ不足」扱いの結果を返す。
"""
target_dates = [date.fromisoformat(ds) for ds in target_date_strs]
try:
return predict_customer_counts(target_dates, set(special_days))
except Exception:
empty_slot = {"predicted": None, "low": None, "high": None, "n_samples": 0, "method": "no_data"}
return {ds: {"breakfast": dict(empty_slot), "dinner": dict(empty_slot)} for ds in target_date_strs}
|