import streamlit as st
import pandas as pd
import numpy as np
import altair as alt
import datetime
from datetime import date
import seaborn as sns
import calendar
data = pd.read_excel(r'C:\Users\stani\Desktop\Webapp\st_zagora\income_data.xlsx') 
df = pd.DataFrame(data)

df['year'] = pd.DatetimeIndex(df['data']).year
#month_year_formatter = mdates.DateFormatter('%b, %Y') # The "," is intentional.
#plot(month_year_formatter)

df['year'] = pd.DatetimeIndex(df['data']).year
#df['Date']=pd.to_datetime(df['data'], format='%Y-%m')
df['Month_Year'] = df['data'].dt.to_period('M')
#month_year_formatter = mdates.DateFormatter('%b, %Y') # The "," is intentional.
#x=df['Month_Year']
x=df['data']
y=df['income_milk']


st.header("Demo placeholder altair chart")

#df = pd.DataFrame(
 #   np.random.randn(200, 3),
  #  columns=['a', 'b', 'c']
#)



chart_placeholder = st.empty()

color = st.radio("select color", ("blue", 'red', 'green'))

#c = alt.Chart(df).mark_circle().encode(
 #   x='a',
  #  y='b',
   # color=alt.value(color),
   # size='c'
#)
c=alt.Chart(df).mark_bar().encode(
    x=x,
    y=y,
    color=alt.value(color)
)

chart_placeholder.altair_chart(c)