File size: 11,746 Bytes
f0fae3f
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
85dc220
 
 
 
f0fae3f
 
 
 
 
 
 
 
85dc220
 
 
f0fae3f
 
 
 
 
 
 
 
85dc220
 
 
f0fae3f
 
 
 
 
 
 
 
85dc220
 
 
f0fae3f
 
 
 
 
 
 
 
 
 
85dc220
 
 
 
 
 
 
 
 
 
 
 
 
 
f0fae3f
 
 
85dc220
 
 
 
 
 
 
 
 
f0fae3f
 
 
 
 
 
 
 
 
 
 
85dc220
 
 
 
 
 
 
 
 
 
f0fae3f
 
 
85dc220
 
 
 
 
f0fae3f
 
 
 
 
 
 
 
85dc220
 
 
f0fae3f
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
"""
data_generation.py
-------------------
Generates the synthetic datasets used to train/evaluate the two ML models
that power the Smart Warehouse AI Assistant:

1. Intent classifier   -> routes free-text queries into warehouse-ops intents
2. Anomaly detector     -> flags abnormal conveyor/AGV sensor readings

All data is synthetically generated with templates + randomised slots so the
project is fully self-contained and reproducible (no external datasets or
scraping required). A fixed random seed keeps results reproducible.
"""

import random
import numpy as np
import pandas as pd

RANDOM_SEED = 42


# --------------------------------------------------------------------------
# 1. INTENT CLASSIFICATION DATA
# --------------------------------------------------------------------------

INTENT_TEMPLATES = {
    "inventory_check": [
        "How many units of {sku} are in {zone}?",
        "What is the current stock level for {sku}?",
        "Check inventory count for {sku} in {zone}",
        "Do we have enough {sku} to fulfill 200 units?",
        "Show me the on-hand quantity of {sku}",
        "Is {sku} in stock at {zone}?",
        "Give me stock levels across all zones for {sku}",
        "How much inventory is left for {sku}?",
    ],
    "order_status": [
        "What's the status of order {order_id}?",
        "Has order {order_id} shipped yet?",
        "Track order {order_id} for me",
        "Is order {order_id} delayed?",
        "When will order {order_id} be delivered?",
        "Show the fulfillment status of {order_id}",
        "Why hasn't order {order_id} left the dock yet?",
    ],
    "equipment_maintenance": [
        "The conveyor belt in {zone} is making noise",
        "Crane {equip_id} reported a fault code",
        "Schedule maintenance for {equip_id}",
        "{equip_id} motor temperature seems high",
        "The sorter in {zone} keeps jamming",
        "Report vibration issue on {equip_id}",
        "Belt {equip_id} stopped unexpectedly, please check",
        "Log a breakdown for {equip_id} in {zone}",
    ],
    "agv_navigation": [
        "Route {equip_id} to picking station {station}",
        "Send AGV {equip_id} to {zone}",
        "Why is {equip_id} stuck near {zone}?",
        "Reassign {equip_id} to charging station",
        "What is the current location of {equip_id}?",
        "Redirect {equip_id} around the blocked aisle in {zone}",
        "Can you dispatch {equip_id} to {zone} right away?",
        "{equip_id} seems to be idle near {zone}, please reroute it",
        "Send the next available AGV to picking station {station}",
        "Pause {equip_id} until the aisle in {zone} is clear",
    ],
    "picking_optimization": [
        "What's the fastest picking route for order {order_id}?",
        "Optimize the pick path for {zone}",
        "Should we batch pick these orders together?",
        "Suggest a wave picking plan for {zone}",
        "How can we reduce travel time for pickers in {zone}?",
        "Recommend a picking strategy for high-velocity SKUs",
        "What's the most efficient picking sequence for {zone} today?",
        "Would zone picking work better than batch picking for {zone}?",
        "How should we sequence orders to minimize walking distance in {zone}?",
    ],
    "safety_incident": [
        "A forklift near-miss was reported in {zone}",
        "Log a safety incident involving {equip_id}",
        "There was a near collision between {equip_id} and a pedestrian in {zone}",
        "File an incident report for {zone}",
        "A worker slipped near {equip_id}, please log it",
        "Report unsafe pallet stacking in {zone}",
        "Please log a near-miss between a pedestrian and {equip_id} in {zone}",
        "A spill was reported near {equip_id} in {zone}, needs cleanup",
        "Someone bypassed the safety gate near {equip_id}, please log this",
    ],
    "system_status": [
        "Is {equip_id} operational?",
        "What is the uptime for {equip_id} today?",
        "Check system health for {zone}",
        "Are all cranes online in {zone}?",
        "Give me the current status of the WMS integration",
        "Is the sorter in {zone} running normally?",
        "Has {equip_id} reported any faults today?",
        "What's the current uptime percentage for {zone}?",
        "Is the WCS connection to {equip_id} stable?",
    ],
    "general_faq": [
        "What is a WMS?",
        "Explain how an AS/RS works",
        "What's the difference between AGV and AMR?",
        "What is cycle counting?",
        "How does goods-to-person picking work?",
        "What KPIs matter most in warehouse automation?",
        "What is predictive maintenance?",
        "How do sortation systems decide where to route a parcel?",
        "What does WCS stand for?",
        "How is a WMS different from a WCS?",
        "What is a mini-load system?",
        "Explain the difference between discrete and batch picking",
        "What is wave picking?",
        "How does zone picking work?",
        "What's the difference between a stacker crane and a shuttle?",
        "Why do warehouses use cycle counting instead of annual counts?",
        "What causes a conveyor jam?",
        "How does regenerative braking work on an AS/RS crane?",
        "What is dock-to-stock time?",
        "Why is inventory accuracy important?",
        "What is a pick rate and how is it measured?",
        "How do warehouses reduce energy use during peak hours?",
    ],
}

ZONES = [
    "Zone A", "Zone B", "Zone C", "Zone D", "Zone E", "Zone F",
    "the mezzanine", "the receiving dock", "the shipping dock", "the cross-dock area",
]
EQUIP_IDS = [
    "AGV-07", "AGV-12", "AGV-18", "Crane-03", "Crane-05", "Crane-09",
    "Sorter-02", "Sorter-06", "Conveyor-14", "Conveyor-21", "AMR-21", "AMR-33",
]
STATIONS = ["3", "5", "7", "12", "15", "18", "22"]


def _rand_sku():
    return f"SKU-{random.randint(1000, 9999)}"


def _rand_order():
    return f"#{random.randint(10000, 99999)}"


def generate_intent_dataset(n_per_intent: int = 45, seed: int = RANDOM_SEED) -> pd.DataFrame:
    """Generate a labelled (text, intent) dataset by sampling + slot-filling templates.

    Actively avoids generating exact-duplicate text within each intent category
    (tries up to a bounded number of times per example, then stops early if the
    template+slot combination space is exhausted for that category). This
    matters because exact-duplicate rows straddling the later train/test split
    would let a classifier "memorize" test examples verbatim rather than
    generalizing -- see build_artifacts.py, which also deduplicates the full
    dataset before splitting as a second, structural safeguard.
    """
    rng = random.Random(seed)
    rows = []
    for intent, templates in INTENT_TEMPLATES.items():
        seen = set()
        attempts = 0
        max_attempts = n_per_intent * 20  # bounded, in case a category's combo space is small
        while len(seen) < n_per_intent and attempts < max_attempts:
            attempts += 1
            template = rng.choice(templates)
            text = template.format(
                sku=_rand_sku(),
                order_id=_rand_order(),
                zone=rng.choice(ZONES),
                equip_id=rng.choice(EQUIP_IDS),
                station=rng.choice(STATIONS),
            )
            if text in seen:
                continue
            seen.add(text)
            rows.append({"text": text, "intent": intent})
    df = pd.DataFrame(rows)
    df = df.sample(frac=1.0, random_state=seed).reset_index(drop=True)
    return df


# --------------------------------------------------------------------------
# 2. INVENTORY / ORDERS DATA (used by the Inventory & Task Query tab)
# --------------------------------------------------------------------------

def generate_inventory_db(n_skus: int = 60, seed: int = RANDOM_SEED) -> pd.DataFrame:
    rng = np.random.default_rng(seed)
    categories = ["Electronics", "Apparel", "Automotive Parts", "Food & Beverage", "Household"]
    zones = ["Zone A", "Zone B", "Zone C", "Zone D"]
    rows = []
    for i in range(n_skus):
        sku = f"SKU-{1000 + i}"
        rows.append({
            "sku": sku,
            "description": f"{rng.choice(categories)} item {1000 + i}",
            "category": rng.choice(categories),
            "zone": rng.choice(zones),
            "on_hand_units": int(rng.integers(0, 2000)),
            "reorder_point": int(rng.integers(50, 300)),
            "unit_cost_jpy": int(rng.integers(200, 15000)),
        })
    return pd.DataFrame(rows)


def generate_orders_db(n_orders: int = 80, seed: int = RANDOM_SEED) -> pd.DataFrame:
    rng = np.random.default_rng(seed)
    statuses = ["Received", "Picking", "Packed", "Shipped", "Delayed"]
    weights = [0.15, 0.25, 0.2, 0.3, 0.1]
    rows = []
    for i in range(n_orders):
        order_id = f"#{10000 + i}"
        rows.append({
            "order_id": order_id,
            "status": rng.choice(statuses, p=weights),
            "num_lines": int(rng.integers(1, 25)),
            "priority": rng.choice(["Standard", "Express", "Same-Day"], p=[0.6, 0.3, 0.1]),
            "zone": rng.choice(["Zone A", "Zone B", "Zone C", "Zone D"]),
        })
    return pd.DataFrame(rows)


# --------------------------------------------------------------------------
# 3. SENSOR DATA FOR ANOMALY DETECTION (predictive maintenance)
# --------------------------------------------------------------------------

def generate_sensor_dataset(n_normal: int = 900, n_anomaly: int = 100, seed: int = RANDOM_SEED) -> pd.DataFrame:
    """
    Synthetic conveyor/crane motor sensor readings.
    Features: motor_temp_c, vibration_mm_s, current_amps, belt_speed_mps
    Label: 1 = anomaly (bearing wear / misalignment / overload pattern), 0 = normal
    """
    rng = np.random.default_rng(seed)

    normal = pd.DataFrame({
        "motor_temp_c": rng.normal(55, 4, n_normal).clip(35, 75),
        "vibration_mm_s": rng.normal(2.2, 0.5, n_normal).clip(0.2, 5),
        "current_amps": rng.normal(12, 1.5, n_normal).clip(5, 20),
        "belt_speed_mps": rng.normal(1.5, 0.15, n_normal).clip(0.8, 2.2),
        "label": 0,
    })

    # Anomalies: elevated temp + vibration + current, reduced/erratic belt speed
    anomaly = pd.DataFrame({
        "motor_temp_c": rng.normal(78, 6, n_anomaly).clip(65, 100),
        "vibration_mm_s": rng.normal(5.5, 1.2, n_anomaly).clip(3.5, 10),
        "current_amps": rng.normal(19, 2.5, n_anomaly).clip(14, 28),
        "belt_speed_mps": rng.normal(0.9, 0.3, n_anomaly).clip(0.1, 1.6),
        "label": 1,
    })

    df = pd.concat([normal, anomaly], ignore_index=True)
    df = df.sample(frac=1.0, random_state=seed).reset_index(drop=True)
    return df


# --------------------------------------------------------------------------
# 4. RETRIEVAL EVALUATION SET (query -> expected KB doc id)
# --------------------------------------------------------------------------

RETRIEVAL_EVAL_SET = [
    ("How does an AS/RS crane retrieve a pallet?", "asrs_overview"),
    ("What's the difference between an AGV and an AMR?", "agv_amr_overview"),
    ("What does a WMS integrate with?", "wms_overview"),
    ("Why would a sorter jam?", "conveyor_sorting"),
    ("What is batch picking?", "picking_strategies"),
    ("How can we predict a motor failure before it happens?", "predictive_maintenance"),
    ("What should I do after a near-miss with a forklift?", "safety_protocol"),
    ("How do we keep inventory counts accurate?", "inventory_accuracy"),
    ("What KPIs should a warehouse manager track?", "kpi_overview"),
    ("How can automated warehouses save energy?", "energy_efficiency"),
]