| import pandas as pd |
| import numpy as np |
|
|
|
|
| def optimize_slotting(df: pd.DataFrame): |
| """ |
| Assign aisle/rack based on velocity. |
| Fast → aisles 1–5 |
| Medium → 6–12 |
| Slow → 13–20 |
| """ |
|
|
| df = df.copy() |
|
|
| def assign_location(row): |
| if row["Velocity"].lower() == "fast": |
| aisle = np.random.randint(1, 6) |
| elif row["Velocity"].lower() == "medium": |
| aisle = np.random.randint(6, 12) |
| else: |
| aisle = np.random.randint(13, 20) |
| rack = np.random.randint(1, 30) |
| return aisle, rack |
|
|
| df["Suggested Aisle"], df["Suggested Rack"] = zip(*df.apply(assign_location, axis=1)) |
| return df |
|
|
