# Import packages
from dash import Dash, html, dash_table, dcc
import pandas as pd
import plotly.express as px

# Incorporate data
df = pd.read_excel('project_data.xlsx')

# Initialize the app
app = Dash()

# App layout
app.layout = [
	html.H1(children='Project Dashboard', style={'textAlign':'center'}),
	html.Div(children = [
		dcc.Graph(
			figure=px.histogram(
				df,
				x='Preparer',
				color='High Priority?',
				title='Control Count by Preparer'
			),
			style = {'flex-grow':'1'}
		),
		dcc.Graph(
			figure=px.histogram(
				df,
				x='Preparer',
				y='Projected Hours ',
				color='Status ',
				title='Project Hours by Preparer'
			),
			style = {'flex-grow':'1'}
		)
	], style = {'display':'flex', 'flex-wrap':'wrap', 'justify-content':'space-between', 'align-items':'center'}),
	dcc.Graph(
		figure=px.pie(
			df,
			values = df['Preparer'].value_counts().values,
			names=df['Reviewer'].value_counts().index,
			title='Reviewer Breakdown',
			hole=0.5
		)
	)
]

# Run the app
if __name__ == '__main__':
    app.run(debug=True)