app.py

import streamlit as st
import pandas as pd

df = pd.read_csv('last_results.csv')

with st.sidebar:
    st.markdown('Previsões de Receitas')
    selected_instituicao = st.selectbox('Select Instituição', df['Instituição'].unique())
    selected_conta = st.selectbox('Select Conta', df['Conta'].unique())

# Filter the DataFrame based on selected values
filtered_df = df[(df['Instituição'] == selected_instituicao) & (df['Conta'] == selected_conta)]

# Display the filtered DataFrame
st.write('Filtered DataFrame:')
st.write(filtered_df)

# Display the Forecasts values
if not filtered_df.empty:
    forecasts_values = filtered_df['Forecasts'].values
    st.write('Forecasts Values:', forecasts_values)
else:
    st.warning('No data available for the selected filters.')