Danilo Barbeiro shared you an app

import streamlit as st import pandas as pd #import xlrd import locale from datetime import datetime # Sidebar with current date and time st.sidebar.title("Sidebar") # Add a logo to the sidebar st.sidebar.image("logo.png", use_column_width=True) current_time = datetime.now().strftime("%Y-%m-%d %H:%M:%S") st.sidebar.write(f"The last Update: {current_time}") # File uploader for Excel and CSV files uploaded_file = st.sidebar.file_uploader("Choose an Excel file", type=["xls", "xlsx"]) if uploaded_file: # Read the file based on its extension df = pd.read_excel(uploaded_file) #header=0 deixar a primeira linha cabeçalho, skiprows=1 pular a primeira linha df = pd.read_excel(uploaded_file, header=0, skiprows=1) #tirando hora da celula data df['Vencto'] = pd.to_datetime(df['Vencto']).dt.date df['Emissao'] = pd.to_datetime(df['Emissao']).dt.date df['EmissaoCTE'] = pd.to_datetime(df['EmissaoCTE']).dt.date st.write("Data from the uploaded Excel file:") st.success("Arquivo XLSX carregado com sucesso!") st.write(df) # Filtrando os dados para mostrar apenas os valores vencidos df['Vencto'] = pd.to_datetime(df['Vencto']) data_atual = pd.to_datetime('today') df_vencidos = df[df['Vencto'] < data_atual] # Agrupando os dados por centro de custo e calculando o total de valores vencidos df_agrupado = df_vencidos.groupby('CC')['ValorLiquido'].sum().reset_index() # Criando o gráfico de barras st.bar_chart(data=df_agrupado, x='CC', y='ValorLiquido') # Button to export the dataframe to Excel if st.sidebar.button("Export to Excel"): df.to_excel("exported_data.xlsx", index=False) st.sidebar.write("Database exported to Excel file: exported_data.xlsx")

Please login to use this app.