from flask import Flask, render_template
import pandas as pd

app = Flask(__name__)

CSV_URL = "https://huggingface.co/datasets/Andrew12121212/RASP/resolve/main/pronosticos.csv"

@app.route("/")
def index():
    df = pd.read_csv(CSV_URL)
    columnas = ["Equipo A", "Equipo B", "Fecha", "Recomendación", "Cuota"]
    filas = []
    for _, row in df.iterrows():
        fila = {col: row.get(col, "") for col in columnas}
        fila["Resumen"] = row.get("Resumen", "")
        filas.append(fila)
    return render_template("index.html", columnas=columnas, filas=filas)

if __name__ == "__main__":
    app.run(host="0.0.0.0", port=7860)