Spaces:
Sleeping
Sleeping
import pandas as pd | |
import numpy as np | |
import datetime | |
def simulate_data(n=10, faults=True): | |
today = datetime.date.today() | |
poles = [f"Pole_{i+1:03}" for i in range(n)] | |
data = [] | |
for pole in poles: | |
solar = round(np.random.uniform(3.0, 7.5), 2) | |
wind = round(np.random.uniform(0.5, 2.0), 2) | |
required = round(np.random.uniform(1.0, 1.5), 2) | |
total = solar + wind | |
cam = np.random.choice(['Online', 'Offline'], p=[0.85, 0.15]) if faults else "Online" | |
tilt = round(np.random.uniform(0, 12), 1) | |
vib = round(np.random.uniform(0.1, 2.5), 2) | |
sufficient = "Yes" if total >= required else "No" | |
anomaly = [] | |
if faults: | |
if solar < 4.0: | |
anomaly.append("Low Solar Output") | |
if wind < 0.7: | |
anomaly.append("Low Wind Output") | |
if tilt > 10: | |
anomaly.append("Pole Tilt Risk") | |
if vib > 2.0: | |
anomaly.append("Vibration Alert") | |
if cam == "Offline": | |
anomaly.append("Camera Offline") | |
if sufficient == "No": | |
anomaly.append("Power Insufficient") | |
alert = "Green" | |
if len(anomaly) == 1: | |
alert = "Yellow" | |
elif len(anomaly) > 1: | |
alert = "Red" | |
data.append({ | |
"Pole ID": pole, | |
"Date": today, | |
"Solar Gen (kWh)": solar, | |
"Wind Gen (kWh)": wind, | |
"Power Required (kWh)": required, | |
"Power Sufficient": sufficient, | |
"Camera Status": cam, | |
"Tilt (°)": tilt, | |
"Vibration (g)": vib, | |
"Anomalies": "; ".join(anomaly) if anomaly else "None", | |
"Alert Level": alert | |
}) | |
return pd.DataFrame(data) |