Spaces:
Runtime error
Runtime error
File size: 1,877 Bytes
07f9aef a72e0f1 07f9aef a72e0f1 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
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) |