import streamlit as st
import pandas as pd
import matplotlib.pyplot as plt

# Title
st.title("Ontology Benchmark Metrics")

# Load Excel file (assumed to be in the same directory)
df = pd.read_excel("metrics.xlsx")

# Show Data
st.subheader("Metrics Table")
st.dataframe(df)

# Visualization
st.subheader("Metric Visualization")
metric = st.selectbox("Select column to visualize:", df.columns[1:])

fig, ax = plt.subplots()
df.plot(x=df.columns[0], y=metric, kind='bar', ax=ax)
st.pyplot(fig)