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

@author: stani
"""

import streamlit as st
import pandas as pd
import matplotlib.pyplot as plt
import numpy as np
import seaborn as sns

df = pd.read_excel(r'C:\Users\stani\Desktop\Webapp\st_zagora\data_for_python2.xlsx', index_col=0) 
print(df.index)

# months for selectbox options.
MONTHS = ('Gener', 'Febrer', 'Març',
          'Abril', 'Maig', 'Juny',
          'Juliol', 'Agost', 'Setembre',
          'Octubre', 'Novembre', 'Decembre')

# Create a sample dict for dataframe
# data = {
    # 'Data de la classe': ['2022-09-27', '2022-09-28',
                        #   '2022-09-29', '2022-10-03',
                        #   '2022-10-04']
# }

# Build df.
# df = pd.DataFrame(data)

#df = pd.read_csv('s.csv')
st.dataframe(df)

# Convert date string to datetime and put it in DateTime column.
#df['data'] = pd.to_datetime(df['Data for choose'], errors='coerce')
#df['data'] = pd.to_datetime(df['data'], format="%Y-%d-%m")

#df['Data for choose']=pd.to_datetime(df['data'],errors='coerce')

#Data_for_choose = pd.to_datetime(df['datas'])
#df['data'] = pd.to_datetime(df['data'],errors='coerce')

#df['day_type'] = df['data'].dt.strftime('%A')
# Create MonthNumber column based from DateTime column.
df["MonthNumber"] = df["DateTime"].dt.month
st.dataframe(df)

# Add streamlit selectbox.
sel_month = st.sidebar.selectbox(label="Select month", options=MONTHS)

# Get the month index based from selected month.
# We add 1 since index starts at 0 but our january starts at 1.
month_index = MONTHS.index(sel_month) + 1

# Execute query.
st.write('#### Query result')
dfSelection = df.query(
    "MonthNumber == @month_index"
)

# Show data frame with filters applied.
st.table(dfSelection)

# Show only the Data de la classe column.
dfSelection_classe = dfSelection[['Data for choose']]
st.table(dfSelection_classe)