Download analytics.py from entropy25/IndustrialProductionIntelligence: direct link, hf CLI and curl.
- Browser
- Download file 6.83 kB
-
https://huggingface.co/spaces/entropy25/IndustrialProductionIntelligence/resolve/main/analytics.py
- Command line
-
hf download hf://spaces/entropy25/IndustrialProductionIntelligence/analytics.py
-
curl -L -o analytics.py https://huggingface.co/spaces/entropy25/IndustrialProductionIntelligence/resolve/main/analytics.py
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) | |