Code: Select all
df['Machine_Status'] = df['Machine_Status'].astype(int)
df = df.dropna(subset=['Machine_Status'])
df =df.reset_index(drop=True)
df[['Timestamp', 'Machine_Status']].to_csv('machine_status_timeframe_output.csv', index=False)
fig = px.line(
df,
x='Timestamp',
y='Machine_Status',
title=f'{machine_id} Activity on {selected_date} (6 AM to 10 PM)',
labels={'Timestamp': 'Time', 'Machine_Status': 'Activity'},
line_shape='hv',
)
Timestamp
Machine_Status
2025-06-16 06:00:04
0
2025-06-16 06:00:09
0
2025-06-16 06:00:14
3
2025-06-16 06:00:18
0
2025-06-16 06:00:23
0
2025-06-16 06:00:28
3
2025-06-16 06:00:33
0
2025-06-16 06:00:38
0
2025-06-16 06:00:43
3
2025-06-16 06:00:48
0
2025-06-16 06:00:53
0
2025-06-16 06:00:58
3
2025-06-16 06:01:03 < /td>
0 < /td>
< /tr>
2025-06-16 06:01:08 < /td>
0 < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> /> 2025-06-16 06:01:13 < /td>
0 < /td>
< /tr>
2025-06-16 06:01:18 < /td>
0 < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> /> 2025-06-16 06:01:23 < /td>
0 < /td>
< /tr>
2025-06-16 06:01:28 < /td>
0 < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> /> 2025-06-16 06:01:33 < /td>
0 < /td>
< /tr>
2025-06-16 06:01:38 < /td>
0 < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> /> 2025-06-16 06:01:43 < /td>
0 < /td>
< /tr>
2025-06-16 06:01:48 < /td>
0 < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> < /td> /> 2025-06-16 06:01:53 < /td>
0 < /td>
< /tr>
< /tbody>
< /table> < /div>
src = "https://i.sstatic.net/gbcxvjiz.png"/>
Erwartete Verhalten: