OneCompiler

Automation v2

102

Example heading with h2 size

Example heading with h3 size

Following is sample java code.

int i = 10;
if(i>0){
    System.out.println('positive');
}

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

app = Flask(name)

@app.route('/', methods=['GET', 'POST'])
def index():
# Load data
df1 = pd.read_csv("C:/Users/2733157/OneDrive/Project/datasets/Main_ref_data/Ref_Lookup_Area8277.csv", dtype={'Area_Code': str})
df2 = pd.read_csv("C:/Users/2733157/OneDrive/Project/datasets/Main_ref_data/Ref_Lookup_Age8277.csv", dtype={'Age_Code': str})
df3 = pd.read_csv("C:/Users/2733157/OneDrive/Project/datasets/Main_ref_data/Ref_Lookup_Sex8277.csv", dtype={'Sex_code': str})
df4 = pd.read_csv("C:/Users/2733157/OneDrive/Project/datasets/Main_ref_data/Ref_Lookup_Ethnic8277.csv", dtype={'Ethnic_Code': str})

# Extract options
areas = df1.loc[df1['Area_Code'].str.len() == 2, 'Area_Description'].unique().tolist()
years = ['2013', '2016', '2008']
main_age = df2.loc[df2['Age_Code'].str.len() == 1, 'Age_Description'].unique().tolist()
sub_age_1 = df2.loc[df2['Age_Code'].str.len() == 2, 'Age_Description'].unique().tolist()
sub_age_2 = df2.loc[df2['Age_Code'].str.len() == 3, 'Age_Description'].unique().tolist()
genders = df3['Sex_Description'].unique().tolist()
ethnics = df4.loc[df4['Ethnic_Code'].str.len() == 1, 'Ethnic_Description'].unique().tolist()

filtered_data = None
if request.method == 'POST':
    # Get selected options from the form
    selected_years = request.form.getlist('years')
    selected_areas = request.form.getlist('areas')
    selected_main_age = request.form.getlist('main_age')
    selected_sub_age_1 = request.form.getlist('sub_age_1')
    selected_sub_age_2 = request.form.getlist('sub_age_2')
    selected_genders = request.form.getlist('genders')
    selected_ethnics = request.form.getlist('ethnics')

    # Filter data (Example: Filter by Area and Year)
    filtered_data = {
        "Years": selected_years,
        "Areas": selected_areas,
        "Main Age": selected_main_age,
        "Sub Age 1": selected_sub_age_1,
        "Sub Age 2": selected_sub_age_2,
        "Genders": selected_genders,
        "Ethnics": selected_ethnics
    }

return render_template(
    'home.html', 
    years=years, areas=areas, main_age=main_age, sub_age_1=sub_age_1, sub_age_2=sub_age_2,
    genders=genders, ethnics=ethnics, filtered_data=filtered_data
)

if name == 'main':
app.run(debug=True)