# -*- coding: utf-8 -*-
"""
Created on Fri May 19 13:53:43 2023

@author: stani
"""

import streamlit as st
import pandas as pd
import streamlit_pandas as sp

@st.cache_data(allow_output_mutation=True)
def load_data():
    df = pd.read_excel(r'C:\Users\stani\Desktop\Webapp\st_zagora\data_for_python2.xlsx', index_col=0) 
    return df

df =load_data()

all_widgets= sp.create_widgets(df)
res=sp.filter_df(df, all_widgets)
st.write(res)