Code Editor for app.py

import streamlit as st
import plotly.graph_objects as go
from datetime import datetime

st.title("Chemical Tracking Tool Timeline")

# Define the events
events = [
    {
        'Date': 'Before 2025',
        'Event': 'Excel files specific to each site\nNo data centralization\nNo tracking tool',
        'Position': datetime(2024, 6, 1)  # Using mid-2024 for visualization
    },
    {
        'Date': 'December 2024',
        'Event': 'Launch of Chemical Tracking Tool project\nSnowflake database integration\nSpecifications document written',
        'Position': datetime(2024, 12, 1)
    },
    {
        'Date': 'Q4 2025',
        'Event': 'Tool available\nData department intervention\nCentralized database and Streamlit forms launch',
        'Position': datetime(2025, 10, 1)  # Using October 2025 for Q4
    }
]

# Create the timeline
fig = go.Figure()

# Add events to the timeline
for event in events:
    fig.add_trace(go.Scatter(
        x=[event['Position']],
        y=[0],
        mode='markers+text',
        name=event['Date'],
        text=event['Event'],
        textposition="top center",
        marker=dict(size=15, symbol='circle', color='#0083B8'),
        showlegend=False,
        hoverinfo='text',
        textfont=dict(size=14)
    ))

# Update layout
fig.update_layout(
    plot_bgcolor='white',
    paper_bgcolor='white',
    yaxis=dict(showgrid=False, zeroline=False, showticklabels=False, range=[-1, 1]),
    xaxis=dict(
        showgrid=True,
        zeroline=False,
        type='date',
        range=[datetime(2024, 1, 1), datetime(2026, 1, 1)]
    ),
    height=400,
    margin=dict(l=50, r=50, t=50, b=50)
)

# Add a line connecting all points
fig.add_shape(
    type="line",
    x0=datetime(2024, 1, 1),
    x1=datetime(2026, 1, 1),
    y0=0,
    y1=0,
    line=dict(color="#0083B8", width=2)
)

# Display the timeline
st.plotly_chart(fig, use_container_width=True)

# Add explanatory text
st.markdown("""
This timeline shows the evolution of the Chemical Tracking Tool project:

1. **Initial State (Before 2025)**: Decentralized system with site-specific Excel files
2. **Project Launch (December 2024)**: Beginning of centralization with Snowflake integration
3. **Implementation (Q4 2025)**: Full deployment with centralized database and Streamlit interface
""")