Flask website not working

Python
1

import pandas as pd
from flask import Flask, render_template, request

app = Flask(name)
df = pd.read_csv(‘C:\Coding\IA\Week3\FormattedDF.csv’)

@app.route(‘/’, methods=[‘GET’, ‘POST’])
def dropdown():
teams = [‘Arsenal’, ‘Aston Villa’, ‘Bournemouth’, ‘Brentford’, ‘Brighton’,
‘Burnley’, ‘Chelsea’, ‘Crystal Palace’, ‘Everton’, ‘Fulham’,
‘Leeds United’, ‘Leicester City’, ‘Liverpool’, ‘Manchester City’,
‘Manchester United’, ‘Newcastle United’, ‘Norwich City’,
‘Nottingham Forest’, ‘Southampton’, ‘Tottenham’, ‘Watford’,
‘West Ham’, ‘Wolves’]

selected_team = None
selected_rows = None
if request.method == 'POST':
    selected_team = request.form['team']
    print(f'{selected_team = }')
    selected_rows = df[df['team'] == selected_team]

return render_template('test.html', teams=teams, selected_rows=selected_rows, data=df)

if name == “main”:
app.run(host=“localhost”, port=int(“5000”))

Dropdown {% for team in teams %} {{ team }} {% endfor %}

{% if selected_rows.empty %}



{% for col in data.columns %}

{% endfor %}



{% for index, row in selected_rows.iterrows() %}

{% for val in row %}

{% endfor %}

{% endfor %}

{{ col }}
{{ val }}

{% endif %}
2

It should be like this but have only the rows which have the value ‘selected_team’ in teams column.
Everything is working except displaying the table itself, the values and everything work.

1000008382
10000083821718×931 82.6 KB