GitHunt
MI

mikeozero/mortgage-dashboard

Automation dashboard using echarts+python+mysql (resposive web design)

multi-dashboards

Automation dashboards using echarts+python+mysql (resposive web design)
image
image

The source data ('mortgage.csv' and 'Data_Product Hierarchy.xlsx') in sources/

1. readcsv.py: directly read and process data from 'mortgage.csv'. to check the result, just modify the app.py file as below:
image

2. mysql.sql: DDL statements, create tables 'Acct_perf', 'DATA_PRODUCT_MAPPING_LKP' and view 'VW_RESD_MTGE_OA_RISK' in mysql.

3. postgresql.sql: DDL statements, create tables 'Acct_perf', 'DATA_PRODUCT_MAPPING_LKP' and view 'VW_RESD_MTGE_OA_RISK' in postgresql. postgresql is case sensitive, create table "Test"... and create table Test... are different. In SqlAlchemy, any table name or column name including uppercase letters will be added "" autometicly.

4. models.py: ETL source data into database (mysql | postgresql).
image

5. readdatabase.py: read and process data from view 'VW_RESD_MTGE_OA_RISK'. to check the result, just modify the app.py file as below:
image

6. resposive web design:
image
image

keywords: echarts, javascript, jquery, ajax, html, css, python, pandas, flask, sqlalchemy, mysql, postgresql

Contributors

MIT License
Created June 17, 2021
Updated August 1, 2023
mikeozero/mortgage-dashboard | GitHunt