Spaces:
Runtime error
Runtime error
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) |