import streamlit as st
import pandas as pd
import plotly.graph_objects as go

# Title of the App
st.title("Excel Data Visualization with Dual Y-Axis")

# Upload Section
uploaded_file = st.file_uploader("Upload your Excel file", type=["xlsx", "xls"])

if uploaded_file:
    try:
        # Read the Excel file into a DataFrame
        df = pd.read_excel(uploaded_file)

        # Preview the uploaded data
        st.write("Data Preview:")
        st.dataframe(df)

        # Ensure required columns are present
        required_columns = ["Description", "Oct'24", "Nov'24", "Dec/(Inc)"]
        if not all(column in df.columns for column in required_columns):
            st.error(f"The uploaded file must contain the following columns: {', '.join(required_columns)}")
        else:
            # Plot the Graph
            fig = go.Figure()

            # Add Bar Traces for Oct'24 and Nov'24
            fig.add_trace(go.Bar(
                x=df["Description"],
                y=df["Oct'24"],
                name="Oct'24",
                marker_color='blue'
            ))

            fig.add_trace(go.Bar(
                x=df["Description"],
                y=df["Nov'24"],
                name="Nov'24",
                marker_color='green'
            ))

            # Add Line Trace for Dec/(Inc) on Secondary Y-axis
            fig.add_trace(go.Scatter(
                x=df["Description"],
                y=df["Dec/(Inc)"],
                name="Dec/(Inc)",
                mode="lines+markers",
                marker=dict(color='red'),
                yaxis="y2"
            ))

            # Update Layout for Dual Y-axis
            fig.update_layout(
                title="Dual Axis Chart",
                xaxis=dict(title="Description"),
                yaxis=dict(
                    title="Values (Oct'24 and Nov'24)",
                    titlefont=dict(color="blue"),
                    tickfont=dict(color="blue"),
                ),
                yaxis2=dict(
                    title="Dec/(Inc)",
                    titlefont=dict(color="red"),
                    tickfont=dict(color="red"),
                    overlaying="y",
                    side="right"
                ),
                barmode="group",
                legend=dict(x=0.5, y=1.2, orientation="h"),
                template="plotly_white"
            )

            # Render the Plot
            st.plotly_chart(fig)
    except Exception as e:
        st.error(f"Error processing the file: {e}")
else:
    st.info("Please upload an Excel file to get started.")

# Footer
st.write("---")
st.write("Developed using [Streamlit](https://streamlit.io) and [Hugging Face Spaces](https://huggingface.co/spaces).")