app.py

import gradio as gr
import pandas as pd
import requests
import io

# google sheets CSV URL
CSV_URL = "https://docs.google.com/spreadsheets/d/e/2PACX-1vR66Wy-eHXPDCEFksh3SD4SzIFeB7pnmNFHBDkGtrkSFliy6Ef6vdyijfFP-FCuBkqWwXy7qQYRIvCM/pub?output=csv"

# fetch data from google sheets
def fetch_leaderboard_data():
    try:
        response = requests.get(CSV_URL)
        response.raise_for_status()
        data = pd.read_csv(io.StringIO(response.text))
        return data
    except Exception as e:
        print(f"Error fetching data: {e}")
        return pd.DataFrame({"Error": ["Unable to fetch data"]})

# title for the leaderboard
title = """
<center>
<h1> IEEE Low-Power Computer Vision Challenge </h1>
<b> 2025 CVPR WORKSHOP </b>
</center>
"""

# gradio app
def create_gradio_app():
    with gr.Blocks(theme="gradio/soft") as app:
        # gr.HTML(title)
        gr.DataFrame(
            value=fetch_leaderboard_data(),
            interactive=False,
            label="Leaderboard",
        )
    return app

# launch Gradio app
def run_gradio_app():
    app = create_gradio_app()
    app.launch(server_name="0.0.0.0", server_port=7860, share=True)

if __name__ == "__main__":
    run_gradio_app()