import streamlit as st
#from datetime import time
import pandas as pd
import matplotlib.pyplot as plt
import numpy as np
#appointment = st.slider(
 #   "Schedule your appointment:",
  #  value=(time(11, 30), time(12, 45)))
#st.write("You're scheduled for:", appointment)

#import streamlit as st
from datetime import datetime



start_time = st.slider(
    "When do you start?",
   # value=(datetime(2019, 1, 1), datetime(2022, 1, 1)))
    value=(datetime(2019, 1, 1), datetime(2022, 1, 1)))






st.write("Start time:", start_time)
#print(start_time[0])
data = pd.read_excel(r'C:\Users\stani\Desktop\Webapp\st_zagora\data_for_python2.xlsx') 

df = pd.DataFrame(data)
#print(df)
array = df.values
#dates=df[(df['Дата']>datetime.date(2019,1,1)) & (df['Дата']<datetime.date(2019,12,1))] 
dates=df[(df['data'] >= start_time[0]) & (df['data'] <= start_time[1])]
print(dates)


#start_date = '2020-11-15'
#end_date   = '2021-10-18'
#df2 = df.query('InsertedDates >= @start_date and InsertedDates <= @end_date')
#print(df2)