Spaces:
Sleeping
Sleeping
import streamlit as st | |
import pandas as pd | |
# Load your dataset | |
# Replace 'your_dataset.csv' with the actual path to your dataset | |
data = pd.read_csv('results.csv') | |
st.title('Previsões de Receitas') | |
# Add filters for 'Instituição' and 'Conta' | |
selected_instituicao = st.selectbox('Selecionar Instituição', data['Instituição'].unique()) | |
selected_conta = st.selectbox('Selecionar Conta', data['Conta'].unique()) | |
# Function to extract and format numbers as monetary values | |
def extract_and_format_numbers(input_string): | |
# Extract numbers in scientific notation or standard decimal notation | |
numbers = re.findall(r'\d+\.\d+e\+\d+|\d+\.\d+', input_string) | |
# Format and print each number as a monetary value | |
for num in numbers: | |
# Convert the string to a float | |
num_float = float(num) | |
# Format as a monetary value (assuming Brazilian Real currency) | |
monetary_value = f'R$ {num_float:.2f}' | |
print(monetary_value) | |
# Filter the data based on user selections | |
filtered_data = data[(data['Instituição'] == selected_instituicao) & (data['Conta'] == selected_conta)] | |
# Display the 'Forecast' column values | |
st.write("Previsões:") | |
st.write(extract_and_format_numbers(filtered_data['Forecasts'])) | |