Entropyobserver
Support Norwegian imports and reliable AI review
d4b4379
Raw History Blame Contribute Delete
6.83 kB
"""Production aggregates, statistical flags, and dashboard charts."""
from typing import Dict, List, Optional
import pandas as pd
import plotly.express as px
from config import get_chart_theme, get_material_label, get_translation
def get_material_stats(df: pd.DataFrame) -> Dict:
total = df["weight_kg"].sum()
stats = {}
for material, group in df.groupby("material_type", sort=False):
material_total = group["weight_kg"].sum()
stats[material] = {
"total": material_total,
"percentage": material_total / total * 100 if total else 0.0,
"daily_avg": group.groupby("date")["weight_kg"].sum().mean(),
"work_days": group["date"].nunique(),
"records": len(group),
}
stats["_total_"] = {
"total": total,
"percentage": 100.0 if total else 0.0,
"daily_avg": df.groupby("date")["weight_kg"].sum().mean(),
"work_days": df["date"].nunique(),
"records": len(df),
}
return stats
def detect_outliers(df: pd.DataFrame) -> Dict:
"""Flag individual weights outside material-specific 1.5 x IQR bounds."""
results = {}
for material, group in df.groupby("material_type", sort=False):
q1, q3 = group["weight_kg"].quantile([0.25, 0.75])
lower = q1 - 1.5 * (q3 - q1)
upper = q3 + 1.5 * (q3 - q1)
flagged = group[(group["weight_kg"] < lower) | (group["weight_kg"] > upper)]
results[material] = {
"count": len(flagged),
"range": f"{lower:.0f} - {upper:.0f} kg",
"dates": flagged["date"].dt.strftime("%Y-%m-%d").tolist(),
"row_indices": flagged.index.tolist(),
"lower": lower,
"upper": upper,
}
return results
def answer_quick_question(kind: str, df: pd.DataFrame, stats: Dict,
lang: str = "English") -> str:
"""Answer fixed dashboard questions from calculations, without an API call."""
t = get_translation(lang)
if kind == "calendar":
daily = df.groupby("date")["weight_kg"].sum()
weekday = daily[daily.index.weekday < 5]
weekend = daily[daily.index.weekday >= 5]
if weekend.empty:
return t["quick_no_weekend"].format(days=len(weekday))
return t["quick_calendar_result"].format(
weekday_days=len(weekday), weekday_avg=weekday.mean(),
weekend_days=len(weekend), weekend_avg=weekend.mean(),
)
if kind == "material":
if not stats["_total_"]["total"]:
return t["quick_no_weight"]
material, info = max(
((name, value) for name, value in stats.items() if name != "_total_"),
key=lambda pair: pair[1]["total"],
)
return t["quick_material_result"].format(
material=get_material_label(material, lang),
weight=info["total"], share=info["percentage"],
)
if kind == "shift":
if "shift" not in df.columns or df["shift"].isna().all():
return t["quick_no_shift"]
grouped = df.groupby("shift")["weight_kg"].agg(["sum", "count"]).sort_values(
"sum", ascending=False
)
details = ", ".join(
t["quick_shift_item"].format(shift=name, weight=row["sum"], records=int(row["count"]))
for name, row in grouped.iterrows()
)
return t["quick_shift_result"].format(details=details)
raise ValueError(f"Unknown quick question: {kind}")
def _with_period(df: pd.DataFrame, time_period: str) -> pd.DataFrame:
data = df.copy()
if time_period == "daily":
data["period"] = data["date"]
elif time_period == "weekly":
data["period"] = data["date"].dt.to_period("W-SUN").dt.start_time
elif time_period == "monthly":
data["period"] = data["date"].dt.to_period("M").dt.start_time
else:
raise ValueError(f"Unsupported time period: {time_period}")
return data
def _style(fig, show_legend: bool = True):
fig.update_layout(**get_chart_theme()["layout"], height=400, showlegend=show_legend)
return fig
def create_total_production_chart(
df: pd.DataFrame, time_period: str = "daily", lang: str = "English"
):
t = get_translation(lang)
grouped = _with_period(df, time_period).groupby("period", as_index=False).agg(
weight_kg=("weight_kg", "sum"), record_count=("weight_kg", "size")
)
title_key = {
"daily": "chart_total_production",
"weekly": "chart_total_production_weekly",
"monthly": "chart_total_production_monthly",
}[time_period]
fig = px.bar(
grouped, x="period", y="weight_kg", custom_data=["record_count"],
title=t[title_key],
labels={"period": t["label_date"], "weight_kg": t["label_weight"]},
)
records_label = "Registreringer" if lang == "Norsk" else "Records"
fig.update_traces(
hovertemplate=f"%{{x|%Y-%m-%d}}<br>%{{y:,.0f}} kg<br>{records_label}: %{{customdata[0]}}<extra></extra>"
)
return _style(fig, show_legend=False)
def create_materials_trend_chart(
df: pd.DataFrame, time_period: str = "daily",
selected_materials: Optional[List[str]] = None, lang: str = "English"
):
t = get_translation(lang)
data = df[df["material_type"].isin(selected_materials)] if selected_materials is not None else df
grouped = _with_period(data, time_period).groupby(
["period", "material_type"], as_index=False
)["weight_kg"].sum()
grouped["material_label"] = grouped["material_type"].map(
lambda material: get_material_label(material, lang)
)
title_key = {
"daily": "chart_materials_trends",
"weekly": "chart_materials_trends_weekly",
"monthly": "chart_materials_trends_monthly",
}[time_period]
chart = px.line if time_period == "daily" else px.bar
fig = chart(
grouped, x="period", y="weight_kg", color="material_label",
title=t[title_key],
labels={"period": t["label_date"], "weight_kg": t["label_weight"],
"material_label": t["label_material"]},
)
return _style(fig)
def create_shift_trend_chart(
df: pd.DataFrame, time_period: str = "daily", lang: str = "English"
):
t = get_translation(lang)
data = _with_period(df, time_period)
data["shift"] = data["shift"].fillna("Unspecified" if lang == "English" else "Uspesifisert")
grouped = data.groupby(["period", "shift"], as_index=False)["weight_kg"].sum()
title = (t["chart_shift_trends"] if time_period == "daily"
else t["chart_shift_trends_period"])
fig = px.bar(
grouped, x="period", y="weight_kg", color="shift", barmode="stack",
title=title,
labels={"period": t["label_date"], "weight_kg": t["label_weight"]},
)
return _style(fig)