File size: 2,065 Bytes
756aa06
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
"""Downloadable CSV writers with formula injection escaping."""

from __future__ import annotations

from pathlib import Path
from typing import Any, Mapping

import numpy as np
import pandas as pd


def escape_csv_cell(value: Any) -> str:
    """Neutralize spreadsheet formula injection for untrusted string cells."""
    if value is None:
        return ""
    if isinstance(value, (int, float, np.integer, np.floating)):
        if isinstance(value, (float, np.floating)) and not np.isfinite(value):
            return ""
        return str(value)
    text = str(value)
    if text and text[0] in {"=", "+", "-", "@", "\t", "\r"}:
        return "'" + text
    return text


def _safe_frame(columns: dict[str, Any]) -> pd.DataFrame:
    data = {k: [escape_csv_cell(v) for v in vals] for k, vals in columns.items()}
    return pd.DataFrame(data)


def write_forecast_csv(
    path: Path | str,
    *,
    times: list[Any],
    median: np.ndarray,
    q_low: np.ndarray,
    q_high: np.ndarray,
    low_level: float,
    high_level: float,
) -> Path:
    path = Path(path)
    median = np.asarray(median, dtype=np.float64)
    q_low = np.asarray(q_low, dtype=np.float64)
    q_high = np.asarray(q_high, dtype=np.float64)
    frame = _safe_frame(
        {
            "time": list(times),
            "median": median.tolist(),
            f"q{low_level:g}": q_low.tolist(),
            f"q{high_level:g}": q_high.tolist(),
        }
    )
    path.parent.mkdir(parents=True, exist_ok=True)
    frame.to_csv(path, index=False)
    return path


def write_metrics_csv(path: Path | str, rows: Mapping[str, Mapping[str, Any]]) -> Path:
    path = Path(path)
    models: list[str] = []
    maes: list[Any] = []
    mases: list[Any] = []
    for name, metrics in rows.items():
        models.append(name)
        maes.append(metrics.get("mae", ""))
        mases.append(metrics.get("mase", ""))
    frame = _safe_frame({"model": models, "mae": maes, "mase": mases})
    path.parent.mkdir(parents=True, exist_ok=True)
    frame.to_csv(path, index=False)
    return path