import streamlit as st
import pandas as pd
import plotly.express as px

df_acct = pd.read_csv('/home/kartikalidyasianipar/assignment/dataset/completedacct.csv')
df_card = pd.read_csv('/home/kartikalidyasianipar/assignment/dataset/completedcard.csv')
df_client = pd.read_csv('/home/kartikalidyasianipar/assignment/dataset/completedclient.csv')
df_disp = pd.read_csv('/home/kartikalidyasianipar/assignment/dataset/completeddisposition.csv')
df_loan = pd.read_csv('/home/kartikalidyasianipar/assignment/dataset/completedloan.csv')
df_order = pd.read_csv('/home/kartikalidyasianipar/assignment/dataset/completedorder.csv')
df_trans = pd.read_csv('/home/kartikalidyasianipar/assignment/dataset/completedtrans.csv')
df_crm_cc = pd.read_csv('/home/kartikalidyasianipar/assignment/dataset/crm_call_center_logs.csv')
df_crm_evt = pd.read_csv('/home/kartikalidyasianipar/assignment/dataset/crm_events.csv')
df_crm_review = pd.read_csv('/home/kartikalidyasianipar/assignment/dataset/crm_reviews.csv')
df_luxury = pd.read_csv('/home/kartikalidyasianipar/assignment/dataset/luxuryloanportfolio.csv')

st.title('Retail Banking Analysis')


### top row 

st.markdown("## Retail")

client, loan, order = st.columns(3)

with client:
    st.markdown("**Client**")
    totalclient = df_client["client_id"].count()
    st.markdown(f"<h1 style='text-align: center; color: red;'>{totalclient}</h1>", unsafe_allow_html=True)

with loan:
    st.markdown("**Loan**")
    totalloan = df_loan["loan_id"].count()
    st.markdown(f"<h1 style='text-align: center; color: red;'>{totalloan}</h1>", unsafe_allow_html=True)

with order:
    st.markdown("**Order**")
    totalorder = df_order["order_id"].count()
    st.markdown(f"<h1 style='text-align: center; color: red;'>{totalorder}</h1>", unsafe_allow_html=True)


st.write("All Review")
chart_data = df_crm_review["stars"].count()
st.bar_chart(chart_data)